HubSpot Contact Property "Salesforce Campaign ID"

[CDupuis]

Hi there, does anyone know if there is a way to have the Salesforce Campaign ID (contact property in HubSpot that concatenates a list of all the Salesforce campaign IDs the contact has been enrolled in) to only append the campaign IDs of the campaigns the contact actually responded to/engaged in? 

Context: When we determine our initial distribution list for an event, we add all contacts that we are going to send an invite to as campaign members to the related campaign in Salesforce. From here, if they registered, registered + attended, or registered + did not attend, the campaign member status is updated accordingly and all of these statuses are considered "Responded" - as opposed to the default of "Sent". That being said, is there a way we can configure the HubSpot property of "Salesforce Campaign ID" (the concatenation of all the Salesforce campaigns the contact is enrolled in) to only include the IDs of campaigns that they have actually responded to? 

[LaurenKennedy · Accepted solution]

@CDupuis unfortunately the integration for Salesforce campaigns is fairly limited. This field will show all campaigns that a contact is a member of. The best workaround for this is a Salesforce property that's updated via a flow with all campaigns that meet your criteria. Ideally, you use the native HubSpot property for all campaigns that they've been a member of. Then, a new field in Salesforce for Registered + Attended or Registered + Didn't Attend populated via a Flow and synced to new HubSpot text properties (or multi-select if you want to get savvy & keep things really up to date!).

Here's a blog post showing how to do this! Thanks for the content inspiration. 🙂 

[TiphaineCuisset]

Hi @CDupuis 

Thank you for reaching out.

I want to tag some of our experts here - @Josh @Aakar @LaurenKennedy do you have any thoughts for @CDupuis on this? 

Thank you!

Best

Tiphaine