Can I report on user email domain in Explore?

Question

Is there a type of report I can create to pull the email address of everyone who sent us a question?

Answer

You can report on the email address of a user by using attributes such as Requester email or Submitter email. See more Support metrics and attributes in this article: Metrics and attributes for Zendesk Support.

If you just want to have a list of the domains your customers are contacting you from, it is possible to retrieve that information by getting creating two standard calculated metrics and a standard calculated attribute.

Warning: If your Explore account is not in English, copying and pasting this formula results in a syntax error. See the article for more details: How can I convert formulas from English into another language? 

To create a report that lists the domains of the users 

1. In Explore, click the report ( ) icon.
2. In the reports library, click New report.
3. Choose the dataset containing the information you want to use in your report.
4. Next, add your metrics, the things you want to measure; in this case, the number of tickets created. In the Metrics panel, click Add.
5. From the list of metrics, choose Users and organizations > Users, then click Apply.
6. Create the attribute with the formula below and name it Requester email domain.

   REGEXP_EXTRACT([Requester email],"([^@]+)$")

7. Under Rows, click Add. From the list of attributes, choose Calculated attributes > Requester email domain.
8. Under Filters, click Add and select a time filter you want to use. In this example, the Requester created - Date was selected. 
9. Lastly, go to the Result manipulations > Sort and choose the Value descending option from the list.