Salesforce Marketing Cloud

For a downloadable version of this article to share with other people on your team, click here.

How does Salesforce Marketing Cloud for Fuel Cycle work?

Sync your customer data seamlessly between Salesforce Marketing Cloud and Fuel Cycle in a few simple steps. You can choose to push data from Salesforce Marketing Cloud to Fuel Cycle and pull Fuel Cycle profile point data into Salesforce Marketing Cloud. Once setup, the data is synced every 24 hours.

Push Data

When push data is enabled, an additional option will be available in Profile Points for “Push to CRMs.” All profile points set to Push to CRMs will be pushed to a data extension in Salesforce Marketing Cloud called “FC_IMPORT.” The data can be synced to users in Salesforce Marketing Cloud based on matching email address.

Pull Data

When pull data is enabled, any Salesforce Marketing Cloud data added to the data extension “FC_EXPORT” will be pulled into Fuel Cycle where it will be synced to members based on matching email address. The data can used as a source in profile points where they can then be added to member exports and used for segmentation in dynamic groups.

Please Note

We are only able to match users based on email address at this time. If you have users inside Salesforce Marketing Cloud without an email address, we cannot match those users inside Fuel Cycle.

Salesforce Marketing Cloud Configuration Steps

The following steps are done inside your Salesforce Marketing Cloud account. Please provide this information to your internal Salesforce team to perform these tasks.

  1. Login to Salesforce Marketing Cloud
  2. Create a Package
    1. Hover over the username in the upper right-hand corner, then “Administration” > “Account” > “Installed Packages”
    2. Click the “New” button to create a start new package
    3. Name the package whatever you prefer and provide an option description, then click Save.
    4. Now, click to Add a Component
    5. Select “API Integration” and click Next
    6. On this screen, scroll down to the “Data” section and select “Read” and “Write” under the “Data Extensions” subhead and Save.
    7. From this screen, copy and save the following fields, which will need to be given to the person who will enter the information inside Fuel Cycle:

      1. Client ID
      2. Client Secret
        Please Note

        This information should be handled securely, and should be treated as seriously as a username and password as it provides access to information on the account.

  3. Retrieve FTP Account details
    1. If you are unfamiliar with FTP in Salesforce Marketing Cloud, click here for more information.
    2. Hover over the username in the upper right-hand corner, and then click “Administration” > “Account” > “FTP Accounts”
    3. If you don’t have an FTP user yet, proceed to create one.
    4. Once you have an FTP user, copy and save the following fields, which will need to be given to the person who will enter the information inside Fuel Cycle:
      1. FTP URL
      2. FTP Username
      3. FTP Password (if you don’t know your FTP password, click the dropdown button next to the FTP details and click “Edit” then create a new password)
        IMPORTANT

        FTP Passwords expire every 90 days. You will need to update the password in both Salesforce and in Fuel Cycle settings every 90 days.

  4. You are done with this portion of the setup. Please give the Client ID, Client Secret, FTP URL, FTP Username and FTP Password to your internal Fuel Cycle team member.
    Please Note

    You will need to work with your Fuel Cycle team after the setup is complete inside Fuel Cycle to determine the data that should be pushed from Salesforce Marketing Cloud to Fuel Cycle (details outlined below). Your Fuel Cycle team will work with you when that step is ready.

Fuel Cycle Configuration Steps

The following steps are done inside your Fuel Cycle account. Please provide this information to your internal Fuel Cycle team to perform these tasks.

  1. Login to the Fuel Cycle Admin
  2. Navigate to Exchange and click the “Configure” button on the Salesforce Marketing Cloud card
  3. From the settings page, enter the following details provided to you from your Salesforce team (based on the steps outlined above):
    1. Account Nickname: This is for internal use only and can be any name you want to give it
    2. Client ID
    3. Client Secret
    4. FTP URL
    5. FTP Username
    6. FTP Password
  4. You can then choose what type of data sync options you want to enable for the community:
    1. Pull Data from Salesforce Marketing Cloud: When this option is selected, a new Data Extension will automatically be created in your account called “FC_EXPORT.” You will need to return to Salesforce Marketing Cloud and add any data you want pulled into Fuel Cycle to that data extension (see “Setting up Profile Data to Sync” section below for details on how to do this).
    2. Push Data to Salesforce Marketing Cloud: When this option is selected, a new Data Extension will automatically be created in your account called “FC_IMPORT.” All profile points set to “Push to CRMs” will be pushed to that data extension inside Salesforce. Marketing Cloud (see “Setting up Profile Data to Sync” section below for details on how to do this).
  5. Click the “Test Connection” button to verify the connection between Fuel Cycle and Salesforce works.
  6. Once the test is successful, you can Save the configuration.
  7. The configuration is now done, but additional steps are needed to choose the data to include in the sync (see below).

Setting up Profile Data to Sync

Pull Data

  1. Once the connection is saved in Fuel Cycle, a new data extension called “FC_EXPORT” will automatically be created in your Salesforce Marketing Cloud account.
  2. Work with your internal Salesforce Marketing Cloud team to determine the profile data inside your Salesforce Marketing Cloud account that you want to pull into Fuel Cycle.
  3. Once you know what data you want to pull, have your internal Salesforce team add those fields to the FC_EXPORT Data Extension inside Salesforce Marketing Cloud.
  4. Every 24 hours, Fuel Cycle will pull all data from the FC_EXPORT data extension into Fuel Cycle. The sync will occur every 24 hours at midnight Pacific.
  5. You can return to Fuel Cycle admin and click Exchange, then Salesforce Marketing Cloud to view the date and time the most recent pull sync occurred.
  6. In addition, you can click the “Available Fields” link to view all of the fields that have been pulled from Salesforce Marketing Cloud.
  7. All data that comes from Salesforce Marketing Cloud will be imported as qualitative data, which may not be useful inside Fuel Cycle for all fields.
    1. When you click the “Available Fields” link, you’ll be taken to a page where you can view all imported fields including the total number of values imported from each field.

      1. You can click the # of Values link to view a list of all values.
      2. If you have a field that you want to convert into a Quantitative data source, click the “Convert to Quantitative” link and the field will be converted so that you can use it as a source for quantitative profile points. This is valuable because you can then use the data for dynamic grouping.
        1. EXAMPLE USE CASE:
          1. You have a field called “Loyalty Tier” with only 3 possible values for “Platinum,” “Gold,” and “Silver.”
          2. You want to be able to create a dynamic group of all members in the Platinum tier.
          3. To achieve this, convert the field to Quantitative and then create a new profile point with Loyalty Tier as the source (since the field has been converted, you can map it like a survey question).
          4. You can then create a dynamic group of all members with the loyalty tier as Platinum.
            IMPORTANT

            Once a field has been converted to Quantitative, it cannot be changed back to Qualitative. Make sure you want to convert the field before clicking the link.

    2. All imported data (as either qualitative and quantitative) can be used as a source in profile points. By adding it as a source to profile points, the data can then be added to member exports, pushed as embedded data to Alchemer or Qualtrics and can be used in dynamic grouping logic.

Push Data

  1. Once the connection is saved in Fuel Cycle, a new data extension called “FC_IMPORT” will automatically be created in your Salesforce Marketing Cloud account.
  2. You will need to select the Fuel Cycle profile point data that you want to push to Salesforce Marketing Cloud.
  3. To do this, inside Fuel Cycle admin go to Members > P2 Engine and click to edit a profile points you want to push to Salesforce Marketing Cloud.
  4. You’ll see a new option for “Push to CRMS” in the first tab. Simply select this option and click the Save button to enable the push for that profile point.
    1. Continue to enable the option for all profile points you want to push to Salesforce Marketing Cloud.
    2. When done, make sure to click the “Refresh Data” button to save all changes to the Profile Points.
  5. Every 24 hours, Fuel Cycle will push all profile points set to Push to CRMs to the FC_IMPORT data extension in Salesforce Marketing Cloud. The sync will occur every 24 hours at midnight Pacific.
  6. Work with your Internal Salesforce Marketing Cloud team so they know about this data being pushed from Fuel Cycle and can use it inside Salesforce Marketing Cloud for your business and marketing needs.

Troubleshooting Connection Issues

If a sync job has failed, you’ll see a red warning icon and the date and time when the sync failed in red. There are many reasons a sync might fail and there are often no details available as to why. We will continue to attempt to run the sync job every 24 hours. In many cases, if there is a failure, it will work the next time the job runs. Once it runs successfully, the warning icon will no longer display to let you know it’s working properly.

In the case of the job continuing to fail, please check all settings to verify the connection is still working. Keep in mind that the FTP password must be reset in Salesforce Marketing Cloud every 90 days. Check that the FTP Password is still active and if not, reset the password and change it in Fuel Cycle. Use the Test Connection button to verify the connection is working properly.

Updated on October 5, 2021

Was this article helpful?

Related Articles