RCE Question - Is there a way to map Program Status to Pipeline?

[Robert_Stanley]

Our Marketo instance has an integration with a Video Hosting platform that can tell us what % of each video users are watching - 25%, 50%, etc.... which we breakdown into Program Statues. It would be nice to see if there is a correlation between videos being watched more than 50%, say, (or users that are highly engaged) to Pipeline.  I looked in the Program Opportunity Report but I don't see a Dimension for Program Status.  Does anyone have any thoughts on ways this might be doable?

Thanks!

[Gerard_Donnell4]

Hi Robert Stanley​,

How do you convert the % to status'? Do you have a numeric field in your database storing that number? If so, can you not add that field to RCE with Custom Field Sync in the admin area under RCE and then use that rather than the Program Status' to filter your report with.

Thanks,

Gerard

[Dan_Stevens_]

These usually come over as custom activities (we do the same thing with our Brightcove integration). So whenever someone watches a video for certain percentages, we score them accordingly. If you captured this into a field, it would constantky be written over. Which is why the idea of program statuses is desired here (within their individual video content programs).

[Gerard_Donnell4]

Thanks for the further explanation Dan Stevens​, that makes complete sense.

Don't know how you could pull that detail into RCE reliably then if it is getting overwritten each time a person watches a video and pulling program status is not an option

[Dan_Stevens_]

Yeah, it’s almost like two reports are needed (program performance report as well) and then exported to Excel to do additional transformation/analysis of the data.

[Robert_Stanley]

Thanks guys, appreciate the responses!