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.
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
I wrote about this once
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.