Linking background campaigns to email programs with API data | Community
Skip to main content
William_Moudry1
Level 2
July 26, 2018
Question

Linking background campaigns to email programs with API data

  • July 26, 2018
  • 1 reply
  • 5688 views

We are using the REST API to extract our activity data (opens, clicks, form fills, etc.) in the hopes that we can do more robust analytics outside of Marketo than is provided by the Analytics module. To do this we need to identify which Programs the activities are related to. From the API we can extract activity data, which includes a Campaign ID, and we can extract Campaign data which includes the Program information (ID and Name). However, the Campaign data only includes Smart Campaigns created in the Marketo front-end. Many of the emails we send are sent from Email Programs, in which case Marketo creates a background campaign that sends the emails out. In the activity data pulled from the API, the Campaign ID included for activities related to Email Program sends is the background Campaign ID. Therefore, we cannot match that ID to the Campaign data we extract because background campaigns are not included - so we cannot match activity for those emails to the ID and name of the Email Program that sent them.

Has anyone else run into this, and is there any work-around that we are missing?

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 27, 2018

It's not just Email Programs that have this problem, but ephemeral campaign IDs are also created when you send an email from the UI (right-click and send).

As far as I know you can only parse the friendly name of the campaign ("Email Batch Program-12345-send-email-campaign").

William_Moudry1
Level 2
July 27, 2018

Thanks, Sanford. That's another case I hadn't thought of. Unfortunately there is no way to systematically link the Program ID in that  campaign friendly name back to the Program Name because there is no list of Programs available in the API. I haven't been able to find any other posts about this issue, but l'd love to know if there are any I've missed. Also, Marketo Support was not able to give me any advice on how to get this information (other than manually looking them up one by one).

William Moudry
SanfordWhiteman
Level 10
July 27, 2018

Sure there is, you can get the folder and program tree via API as well.