Program Success Date Use

1. Capture which programs each member is in via a field in Marketo, which we can add as a column in a report to export.

The only way to maintain such a field is to call a webhook, with a webhook-compatible service can add/delete active entries in response to Add To Program/Remove From Program activities. Otherwise you could continuously concatenate {{Program.Name}} to a history-type field, but never remove entries.

The "how many" can be a score field.

I'd question how feasible this whole setup would be over the lifetime of your instance, though, because even the largest text field can only hold 32K of data. When storing full program names, this will add up. If you prune the list so entries are aged out as the field grows too big, this would work.

Hi @Sanford Whiteman‌,

Thank you for the quick reply. I do not have visibility on the proposed solution of using the webhook.

If there is any document or an example, that would be helpful to visualize the solution.

We have 14 programs across the entirety of the member lifecycle.  Each program uses a range of logic to pull the correct people in to the program, and there is no over-arching logic or decision which sits above these programs to determine which campaign a member should be part of. Also, there is no single view to see how many programs/touch points we have had with the member.

Possible approach that we are thinking is:

1. Create 12 x new fields to capture program participation.

2. Smart Campaigns to capture historical participation 

3. Smart campaigns to capture future participation

4. Smart campaign to count the total number of programs a member is in using a score token, which adds +1 each time a member runs through a new program.

I am not sure if this is a good way to solve this problem. Any suggestion or feedback would be helpful.