Report that shows which companies are opening my emails | Community
Skip to main content
A
Anonymous
March 22, 2016
Question

Report that shows which companies are opening my emails

  • March 22, 2016
  • 3 replies
  • 3559 views

Hello!

I'm hoping you can help!

I'm still a bit of a new Marketo user, and know how to create:

1) A report that shows all of my emails created (e.g., Subject Line: "Meet Amanda)" along with how many were bounced, delivered, opened, clicked, etc., and

2) A report that shows all of my leads grouped by company name (e.g., Coca Cola, M&M Mars, etc). along with how many total leads exist within those companies, unsubscribes that have happened in all time, blacklists, hard bounces, etc.

What I'm trying to figure out is whether or not I can create a combined report that shows how leads grouped by company name have responded to all of my emails.

e.g., Everyone from Coca Cola opened and clicked on "Meet Amanda", but only half of the people from M&M Mars opened "Meet Amanda".

Is that possible? If so - can you help me?

Thanks so much!

-Amanda

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

3 replies

Grégoire_Miche2
Grégoire_Miche2
Level 10
March 22, 2016

Hi Amanda,

Post you questions in "Products", much more people will read them and may answer. Scott K. Wilder​, could you please relocate it ?

Re the answer, this is typically what Account Based Marketing is about.

Mahesh Jeswani (MJ)​, this is for you

-Greg

A
Anonymous
March 22, 2016

Will move

Will forward to MJ. : ) Thanks

A
Anonymous
March 23, 2016

Thank you, Scott! =D

Nicholas_Manojl
Nicholas_Manojl
Level 8
March 23, 2016

I haven't done this personally but I don't see why the following wouldn't work. It might be a bit long-winded in the setup.

1. Create a segmentation of all your different accounts.. you could use the smart-list "Company is".

2. Use the email performance report.

3. Under 'Setup', choose "Group by Segmentations" and select your newly created Company segmentation.

A
Anonymous
March 23, 2016

Nicholas,

This is great information! I did it, and it's very close to what I'm looking for. Now, however, it's providing company statistics for ALL emails selected. Is there a way to "drill down" (which is no longer appearing in "Report Actions) to see each email and how each company responds to those emails within one report?

e.g.,

*Email #1 Meet Amanda

  --Coca Cola had this many opens and bounces

  --M&M Mars had this many opens and bounces

*Email #2 Have Coffee with Amanda

  --Coca Cola had this many opens and bounces

  --M&M Mars had this many opens and bounces

What do you think? Can I get everything in one place?

Thanks for your help!

-Amanda

Nicholas_Manojl
Nicholas_Manojl
Level 8
March 24, 2016

Hey Amanda, glad to hear that worked out.

I'm not sure it's possible to do that "secondary dimension" style of reporting, unfortunately.

I reckon you could click the Smart List tab and add in a filter along the lines of "Was sent email", or you could use the Setup tab and only select the particular emails you're interested in, but it'd be a manual process.

Robb_Barrett
Robb_Barrett
Level 10
March 26, 2016

Easy Way:

If it's just a few key accounts, create email performance reports with those company names in the smart list.

Less easy way:

Create smart lists for Delivered, Opened, Bounced, Clicked with lead info, company name and email address

Export

In each report, add one column with the report type (i.e. Bounce, Delivered, etc)

Copy and paste into one Excel doc

Pivot Table

Robb Barrett
Terms & ConditionsAccessibility statement

Loading footer...