Missing Email Activity Data | Community
Skip to main content
Vaibhav_Malhotr
New Participant
August 12, 2020
Question

Missing Email Activity Data

  • August 12, 2020
  • 2 replies
  • 2872 views

Email activity raw data download has less numbers than Marketo dashboard. This is a recurring issue. Please help me out.

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

2 replies

SanfordWhiteman
New Participant
August 12, 2020

You'll need to provide a lot more detail.

 

Please provide an example request JSON payload — it isn't clear if you're using the Bulk Export or Bulk Extract endpoint — highlighted using the syntax highlighter of course!

 

Then representative snippets of the response.

 

And screenshots of what exactly you're comparing it to within the Marketo UI.

Vaibhav_Malhotr
New Participant
August 26, 2020

Thanks for the reply. Please see below details:

1.  Please see an attached for the exact dashboard screen I am looking at: The timespan I am looking at is July 01 to July 31, 2020.

 

2. I am using Marketo API JSON request: And I am finding only 361 Opens in activity Data downloaded in Marketo API response. I am downloading data on a daily basis for the last day.

JSON Pay Loadhttps://631-HOT-484.mktorest.com/rest/v1/activities.json?access_token=<TOKEN>&activityTypeIds=8,9,10,11&nextPageToken=<NEXT_PAGE_TOKEN_RECEIVING _FROM_EACH_300_RECORDS_BATCH>

3. e.g. I have attested the above the screen for the following Email: WeeklyEmails-News-07.16.20-Onc.

There is another instance where I found 432 records in API RESPONSE and I can see 450+ in Marketo for EMail: WeeklyEmails-Curbside-07.14.20-Onc.

 

Please let me know if you still need further details

 

 

New Participant
August 12, 2020

Which Marketo dashboard numbers are you comparing it to and in what time frame are you pulling the data from? Keep in mind Marketo has a 90-day data retention period for some activity. You can see the specifics of their data retention policy here

Vaibhav_Malhotr
New Participant
August 26, 2020

Thanks for the reply. Please see below details:

1.  Please see an attached for the exact dashboard screen I am looking at: The timespan I am looking at is July 01 to July 31, 2020.

 

2. I am using Marketo API JSON request: And I am finding only 361 Opens in activity Data downloaded in Marketo API response. I am downloading data on a daily basis for the last day.

JSON Pay Loadhttps://631-HOT-484.mktorest.com/rest/v1/activities.json?access_token=<TOKEN>&activityTypeIds=8,9,10,11&nextPageToken=<NEXT_PAGE_TOKEN_RECEIVING _FROM_EACH_300_RECORDS_BATCH>

3. e.g. I have attested the above the screen for the following Email: WeeklyEmails-News-07.16.20-Onc.

There is another instance where I found 432 records in API RESPONSE and I can see 450+ in Marketo for EMail: WeeklyEmails-Curbside-07.14.20-Onc.

 

We have not passed 90 days yet from July 01,2020. Please let me know if you still need further details. This is quite a priority for us to get a resolution on this.

 

 

SanfordWhiteman
New Participant
August 27, 2020

The stats you're looking at in Marketo use the notion of an implied Open, which means the open-tracking pixel was n't downloaded (so there's no true Opened Email activity) but a link in the email was clicked. Ergo, the end user is assumed to have opened the email in practice, even though the specific moment of the open is not known.