Can I report on user email domain in Analytics?

Question

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

Answer

Yes. You can report on the email address of a user with attributes such as Requester email or Submitter email. See Metrics and attributes for Zendesk Support.

If you want only a list of the domains your customers contact you from, retrieve that information. Create two standard calculated metrics and a standard calculated attribute.

Warning: If your Analytics account isn't in English, a syntax error occurs when you copy and paste this formula. See How can I convert formulas from English into another language?.

To create a report that lists user domains:

In Analytics, click the report ( ) icon

In the reports library, click New report

Choose the dataset with the information you want to use in your report

Next, add your metrics to measure the number of tickets created. In the Metrics panel, click Add.

From the list of metrics, choose Users and organizations > Users, then click Apply

Create the attribute with the formula below and name it Requester email domain

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

Under Rows, click Add. From the list of attributes, choose Calculated attributes > Requester email domain.

Under Filters, click Add and select a time filter you want to use. In this example, select the Requester created - Date.

Lastly, go to the Result manipulations > Sort and choose the Value descending option from the list.