If I'm reading your question right, you could try constraints when you change program/campaign statuses so that they only move forward. So add a constraint to the flow step, if status is not clicked, responded, unsubscribed, new status = opened. Otherwise "do nothing".
Let me know if that works.
Hi Darrell -
Thanks! That is helpful. This specific question is more on the SFDC side. See below.
Lead A goes through campaign 1 and clicks the campaign. Using program statuses in SFDC, the lead with have 100% opened and 100% clicked.
I will allow the lead to run through these statuses again in Marketo the next time they are sent the campaign (once every 6 months). Currently, if Lead A only opens campaign 1 the next time they run through, the lead would then have 100% opened and 0% clicked in SFDC. My goals is to average out the stats in SFDC for all sends. So I would like the leads stats to appear as 100% opened and 50% clicked in SFDC using program statuses.
How can I left SFDC know that the same lead is running through a specific status for a second time, and to average out these stats (without creating a specific field for every status in every campaign).
I appreciate any advise you have!