SOLVED

Report on when people were paused in a nurture

Go to solution
Mariana
Level 2

Report on when people were paused in a nurture

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

1 ACCEPTED SOLUTION

Accepted Solutions
Darshil_Shah1
Level 10 - Community Advisor + Adobe Champion

Re: Report on when people were paused in a nurture

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?

 

View solution in original post

2 REPLIES 2
Darshil_Shah1
Level 10 - Community Advisor + Adobe Champion

Re: Report on when people were paused in a nurture

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?

 

emilyghenson
Level 2

Re: Report on when people were paused in a nurture

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