Salesforce additional campaign member status mapping

[TTram]

Hi, 

We have a secondary field besides the campagin member status in Salesforce that we would like to use in reporting & workflows. 

Is there a way to map this addtional custom camapgin field in Hubspot and use in workflows to update that feild? 

Thanks. 

[Sweely]

That's a very common challenge when dealing with the native HubSpot and Salesforce integration, and karstenkoehler is generally right that the default setup only handles the primary Campaign Member Status.

The good news is, while the out-of-the-box integration doesn't directly support mapping additional custom fields on the Salesforce Campaign Member object to the HubSpot Contact record, you absolutely can build a more robust, custom solution using the various APIs and supporting tools, especially since you're on the Enterprise tier which unlocks powerful features like custom code workflows and custom objects.

The reason this kind of solution is so powerful is that it moves beyond the simple, fixed field-to-field mapping of the native connector and uses programmatic logic to handle complex object relationships.

One of the most elegant and scalable workarounds involves using a combination of the Salesforce API and the HubSpot API, mediated by a custom workflow or an external serverless function, which is where a solution involving Google Tag Manager (GTM) and something like Stape or Google Cloud Platform (GCP) comes into play for a holistic data strategy.

The core idea is to bypass the native connector's limitation by fetching the specific custom data you need from Salesforce and pushing it into a standard HubSpot Contact property, or even a custom object in HubSpot, that is specifically designed to mirror the Salesforce Campaign Member object.

For instance, you could use a HubSpot workflow with a custom-coded action that is triggered when a contact is added to a Salesforce Campaign.

This custom action would use the Salesforce API to query the specific Salesforce Campaign Member record for that contact and pull not just the default status, but also your additional custom field's value.

Once you have this value, the same custom action can use the HubSpot API to write that data into a corresponding, custom property on the HubSpot Contact record, or a related custom object.

Adding a service like Stape, which specializes in server-side tracking, or a service like Google Cloud Platform, in conjunction with Google Tag Manager, offers a way to handle data synchronization in reverse or for web event data.

For example, if you wanted to trigger an update in Salesforce based on a significant website action, GTM could capture a Standard Event like a sign-up or a video completion.

This event is then sent to your server-side container (hosted on Stape or GCP), which can act as the middleware.

The middleware can then use its robust logic to check the user's HubSpot ID, find the associated Salesforce ID, and use the Salesforce API to create or update a Campaign Member record, including setting your custom field's value.

This separates your critical API calls from the browser and allows for more reliable and controlled data flow, ensuring that your secondary campaign member status is fully utilized for segmentation, reporting, and enrollment in HubSpot workflows, closing the loop between your sales and marketing systems effectively.

This comment was generated with the assistance of an AI tool, incorporating my expertise in integrations.

[karstenkoehler · Accepted solution]

Hi @TTram,

As far as I know, no, this is not possible. We just get the default campaign status, unfortunately.

Best regards!