Can anyone please tell me how to fetch below data | Community
Skip to main content
July 6, 2018
Question

Can anyone please tell me how to fetch below data

  • July 6, 2018
  • 1 reply
  • 1503 views
  • # of emails sent to the email address
  • # of clicks per email address

For one email address I am able to track the above data, but say I have 100 contacts for which I need the summarized view or raw data

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
Level 10
July 6, 2018

Can you not mark your question as Correct first?

July 6, 2018

Hi,

I have a list of 100+ contacts from our Marketo database for which I need the total number of emails sent to them. For a single contact, I was able to do that but couldn't for all those 100+ together

SanfordWhiteman
Level 10
July 6, 2018

You will need to extract the Activity Log via API to do this, if you haven't already been preparing your database for this report. (Note the Activity Log does not go back infinitely in time, even via API, but only 25 months for Send Email and Click Email.)

Marketo does not automatically keep a lead-level counter of # of clicks or # of sends. You can do this yourself by maintaining score fields, but you can't use that scoring campaign now, since the time to trigger it has passed.