Help on running a report by email domain/ISP/email client

[Anonymous]

Hi there,

I need to run a report to analyse which webmail clients our customers are using to allow us to dive into some deliverability testing. I can't seem to find the appropriate report. Does a canned report exist? If not, can someone point me in the direction of how to build a custom one?

Essentially the desired output is to have customer domains by % of total base. E.g. @hotmail.* = 20%, @gmail.com = 40% etc.

Thank you!

[SanfordWhiteman]

There's no canned report like this.

The lowest-level barrier is that Marketo doesn't have a field to hold only the email domain. You can create such a custom field and populate it via webhook or Excel export-reimport. This is worth it. But since you're exporting, you'll be happier doing aggregations in Excel as well.

Also check this recent thread for related discussion: https://nation.marketo.com/message/170788-re-group-records-by-email-domain-and-date

[Josh_Hill13]

I wrote about this once

Device and Client Counting Methods in Marketo - Marketing Rockstar Guides

http://www.marketingrockstarguides.com/wp-content/uploads/2016/09/marketo-device-os-lists.xlsx

Block Personal Emails in Marketo - Marketing Rockstar Guides

If you just want to group up a list of data where you know the proportion of personal domains in the database, use a smart list or Segmentation. I am doing this now and got the data very quickly.

Sure, it would be fast to do the export, but it's not really necessary.