Hi,
Is it possible to create a report/smart list in Marketo to see which people were paused in a nurture and what stream they were?
Thank you
Solved! Go to Solution.
Unfortunately, AFAIK, there's no one direct report that could give the data you're looking for, but you sure can make use of the Activities API endpoints, do some processing, and get the required data.
You can use the Activities API to get the date/time of the "Change Engagement Program Cadence" to Paused state. Use the Describe Activities GET endpoint, get the activity type Id of the "Change Nurture Cadence" activity, and then use it in the bulk Activities extract/regular REST GET Activities API endpoint to get the required data. Unfortunately, "Change Nurture Cadence" doesn't return the stream in which the person was when they were Paused (I'd not assume it to store that activity though!) You can use the same process and extract the "Change Nurture Track" activities and for each person who was Paused, see if they have a "Change Nurture Track" activity after they were paused, if they have, you can reference the first "Change Nurture Track" and refer to the "Previous Track Name" attribute in the response, or in case a person doesn't have any "Change Nurture Track" activity after they were Paused, then it'd mean that they're still in the same stream as they were when their Cadence was updated to Paused state.
Btw, what's the business case for getting this very specific data? Are you just troubleshooting something or want to analyze the nurture program performance based on this data?
Unfortunately, AFAIK, there's no one direct report that could give the data you're looking for, but you sure can make use of the Activities API endpoints, do some processing, and get the required data.
You can use the Activities API to get the date/time of the "Change Engagement Program Cadence" to Paused state. Use the Describe Activities GET endpoint, get the activity type Id of the "Change Nurture Cadence" activity, and then use it in the bulk Activities extract/regular REST GET Activities API endpoint to get the required data. Unfortunately, "Change Nurture Cadence" doesn't return the stream in which the person was when they were Paused (I'd not assume it to store that activity though!) You can use the same process and extract the "Change Nurture Track" activities and for each person who was Paused, see if they have a "Change Nurture Track" activity after they were paused, if they have, you can reference the first "Change Nurture Track" and refer to the "Previous Track Name" attribute in the response, or in case a person doesn't have any "Change Nurture Track" activity after they were Paused, then it'd mean that they're still in the same stream as they were when their Cadence was updated to Paused state.
Btw, what's the business case for getting this very specific data? Are you just troubleshooting something or want to analyze the nurture program performance based on this data?
Hi Mariana,
Darshil's suggestion works perfectly for obtaining existing data for this scenario. Moving forward, I recommend adding static lists to the equation when people are paused in the nurture, and you can even separate them out by stream membership. That way, you have historical membership to pull from and you can pull timeframe smart lists based on when people were added to the various stream pause lists.
Emily Henson
Campaign Operations at Etumos