Help on running a report by email domain/ISP/email client | Community
Skip to main content
A
Anonymous
August 25, 2017
Question

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

  • August 25, 2017
  • 1 reply
  • 2196 views

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!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

SanfordWhiteman
SanfordWhiteman
Level 10
August 25, 2017

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
Josh_Hill13
Level 10
August 25, 2017

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.

Terms & ConditionsAccessibility statement

Loading footer...