Connector Improvement: previous versions of Journey objects in Salesforce Marketing Cloud
Currently, when a new version of a "journey" is created in Salesforce Marketing Cloud, our fivetran connector increments a value in the "version" column and overwrites the previous attributes which changed.
I'm requesting that instead of this update, fivetran would instead insert a new row. Essentially, this means changing the PK of the table from (Id) to (Id, version).
An alternative would be to enable history mode on the Journey table, like we can do in the Salesforce connector.
-
Agreed, Fivetran pulls the most recent version of a Journey regardless of status (Live, Draft, Closed) which throws off reporting for all email sends since we're only looking for the Live Versions and not recent.
Here is the SFMC Docs around the journey object: https://developer.salesforce.com/docs/marketing/marketing-cloud/guide/getInteractionById.html?q=%2Finteraction%2Fv1%2Finteractions%2Fjourneyhistory%2Fdownload
Please sign in to leave a comment.
Comments
1 comment