Marketo Configuration Follow
The following steps are completed inside your Marketo account. Please provide this information to your internal Marketo team to perform these tasks.
- Login to Marketo with an admin account.
- Create a Rest API User.
- Go to “Admin,” then to “Users and Roles” and click the “Roles” tab.
- Click “New Role”.
- Give the role a name, such as Fuel Cycle API.
- Under Permissions, select the following:
- Access Admin
- Access API
- Access Lead Database
- Access Marketing Activities
- Save this new role.
- Return to the “Users” tab and select “Invite New User”.
- Under Step 1: Info...
- Enter an email address for the user.
- Give the user a descriptive name, such as “Fuel Cycle API User”.
- Reason is optional, but is useful to describe the user to other account members.
- Leave Access Expires blank and then click Next.
- Under Step 2: Permissions...
- Select the API Role you just created
- Click “API Only” and click Next.
- Under Step 3: Message...
- Click “Send” to complete user creation.
Note: Invitation is not required for an API-only user.
- Click “Send” to complete user creation.
- Create a New Service
- Go to the "Admin" menu.
- Go to "LaunchPoint".
- Click on the "New" menu
- Select "New Service".
- Give your service a descriptive name
- Select “Custom” from the Service dropdown menu.
- Under "Settings", enter a description
- Select the new user you created above from the "API Only User" dropdown menu and click on "Create".
- Click “View Details”.
- Copy the Client ID and Client Secret to someplace safe, which you will give to the person who will enter the information inside Fuel Cycle.
- Find REST API Endpoint.
- Go to the "Admin" menu, then to "Web Services".
- Under REST API, locate the "Endpoint" value then copy and save. This will need to be given to the person who will enter the information inside Fuel Cycle.
- You are done with this portion of the setup. Please give the Client ID, Client Secret, and REST API Endpoint to your internal Fuel Cycle team member.
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 Marketo 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.
- Create a connection to Marketo inside Fuel Cycle.
- Login to Fuel Cycle.
- Click the Exchange tab at the top.
- Click the Marketo card.
- Click the Configure button.
- From the settings page, enter the following details that you saved from the Marketo steps outlined above:
- Account Nickname: This is for internal use only and can be any name you want to give it
- Client ID
- Client Secret
- REST API Endpoint
Use only the first part of the REST API Endpoint that ends with .com (remove the /rest part at the end).Example:
The full REST API is http://831-SSl-993.mktorest.com/rest but only enter the following: http://831-SSl-993.mktorest.com
- You can then choose what type of data sync options you want to enable for the community:
- Pull Data from Marketo: When this option is selected, you need to create a Custom Object called FC_EXPORT then add all profile data you want to be pulled from Marketo to Fuel Cycle as fields to this custom object.
- Push Data to Marketo: When this option is selected, you need to create a Custom Object called FC_IMPORT then create a field for each Fuel Cycle profile point that you want to push into Marketo.
- Click the Test Connection button to verify the connection between Fuel Cycle and Marketo works.
- Once the test is successful, you can Save the configuration.
- The configuration is now done. Additional steps are needed to choose the data to include in the sync, as outlined in the next section.
Setting up Profile Data to Sync
Pull Data
Steps 1-13 are done inside your Marketo account. Please provide this information to your internal Marketo team to perform these tasks.
- Once the connection is saved in Fuel Cycle, create a Custom Object in Marketo and place the Marketo profile data you want to pull into Fuel Cycle.
- Login into Marketo with an admin account.
- Go to “Admin,” then “Marketo Custom Objects”
- Click “New Custom Object”
- Enter the following values in the appropriate fields. Please note: These must be exactly as outlined below.
- Display Name: FC_EXPORT
- API NAME: FC_EXPORT_c
- Plural Name: FC_EXPORTs
- Description (ok to leave blank)
- Show in Lead Detail: Show
- Click “Save” and you’ll see your new custom object.
- Now go to “Field” and click “New Field” making sure “FC_EXPORT” is selected on the right
- Enter the following exactly as shown below:
- Display Name: emailAddress
- API Name: emailAddress
- Description (ok to leave blank)
- Data Type: Link
- Link Object: Lead
- Link Field: Email Address
- Dedupe Field: Yes
- Click “Save” to create the field. This field will be used to match Marketo leads to Fuel Cycle members
- You can now add additional fields that you want to export (pull) into Fuel Cycle.
- Work with your Fuel Cycle team to determine the profile data you want to pull not Fuel Cycle.
- For additional fields added to this custom object, set the Data Type as "Text"
- When done adding fields, you need to approve the custom object. Return to the “Marketo Custom Objects” tab and make sure the FC_EXPORT object is selected in the right column.
- Click the “Custom Object Actions” dropdown and select “Approve Object”
- Your custom object is now ready to export data into Fuel Cycle.
- Every 24 hours, Fuel Cycle will pull all data from FC_EXPORT into Fuel Cycle. The sync will occur every 24 hours at midnight Pacific.
- You can return to Exchange > Marketo to view the date and time the most recent pull sync occurred.
- In addition, you can click the “Available Fields” link to view all of the fields that have been pulled from Marketo.
- All data that comes from Marketo will be imported as qualitative data, which may not be useful inside Fuel Cycle for all fields.
- 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.
- You can click the # of Values link to view a list of all values.
- 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.
- EXAMPLE USE CASE:
- You have a field called “Loyalty Tier” from Marketo with only 3 possible values for “Platinum,” “Gold,” and “Silver.”
- You want to be able to create a dynamic group of all members in the Platinum tier.
- 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).
- You can then create a dynamic group of all members with the loyalty tier as Platinum.
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.
- 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.
- All imported data (either qualitative or 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
- Select the Fuel Cycle profile point data that you want to push to Marketo.
- To do this, go to Members > P2 Engine and click to edit a profile point you want to push to Marketo.
- 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.
- Continue to enable the option for all profile points you want to push to Marketo.
- When done, make sure to click the “Refresh Data” button to save all changes to the Profile Points.
- Now, you need to create a Custom Object and Fields in Marketo where the Fuel Cycle data will be pushed.
- First, return to Exchange > Marketo and locate the “Profile Points” link next to the Push status:
- When you click the link, a file will download listing all profile points. You will need to use this when creating fields in Marketo as outlined below.
- The following steps are done inside your Marketo account. Please provide this information to your internal Marketo team to perform these tasks.
- Login into Marketo with an admin account.
- Go to “Admin,” then “Marketo Custom Objects”
- Click “New Custom Object”
- Give the fields the following values. Please note: These must be exactly as outlined below.
- Display Name: FC_IMPORT
- API NAME: FC_IMPORT_c
- Plural Name: FC_IMPORTs
- Description (ok to leave blank)
- Show in Lead Detail: Show
- Click “Save” and you’ll see your new custom object.
- Now go to “Field” and click “New Field” making sure “FC_IMPORT” is selected on the right
- Enter the following exactly as shown below:
- Display Name: emailAddress
- API Name: emailAddress
- Description (ok to leave blank)
- Data Type: Link
- Link Object: Lead
- Link Field: Email Address
- Dedupe Field: Yes
- Click “Save” to create the field. This field will be used to match Marketo leads to Fuel Cycle members.
- You must now create a field for each Profile Point you want to push into Marketo from Fuel Cycle with the Data Type “text”.
- Open the profile point file you downloaded from Fuel Cycle to use as a reference for each field to create.
You must create a field for EVERY profile point listed in the CSV file from Fuel Cycle. If you do not have a corresponding field for each profile point in the CSV, the job will fail and no data will import into Marketo.
- You will need to use the same naming convention and enter the value in the “API Name” column in the CSV file.
- Example: If the API NAME in the document is “maritalStatus” enter as follows:
-
- Display Name: maritalStatus (this is case sensitive)
- API Name: maritalStatus
- Data Type: text
-
- Open the profile point file you downloaded from Fuel Cycle to use as a reference for each field to create.
- Continue to create a new field for each profile point in the CSV file.
- When done adding fields, you need to approve the custom object for the changes to take effect. Return to the “Marketo Custom Objects” tab and make sure the FC_IMPORT object is selected in the right column.
- Click the “Custom Object Actions” dropdown and select “Approve Object”.
- Your custom object is now ready to accept data pushed from Fuel Cycle.
- Every 24 hours, Fuel Cycle will push all profile point data into FC_IMPORT. The sync will occur every 24 hours at midnight Pacific.
- You can return to Fuel Cycle Exchange > Marketo to view the date and time the most recent push sync occurred.
Troubleshooting
Failed Sync Job
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 case the job continues to fail, please check all settings to verify the connection is still working. Use the Test Connection button to verify the connection is working properly.
Missing Profile Point Data in FC_IMPORT
When new profile points are added to Fuel Cycle that you want to use in Marketo, you MUST add a new field into the FC_IMPORT custom object with the reference name of the profile point. Please check the following:
- Go to Fuel Cycle > Exchange > Marketo and click to download the latest profile point CSV.
- Return to Marketo and go to the FC_IMPORT custom object.
- Click on the Fields and verify all API Names in the CSV file have a corresponding field in the custom object.
- If you make any changes or add new fields, make sure to approve the changes to the custom object.
- The next time the job runs, the data will be pushed correctly.
If you change the Question Reference of a profile point in Fuel Cycle, you will also need to change the API Name in Marketo to match the new reference. It’s recommended you don’t edit references of profile points after they are created to ensure the link between Marketo and Fuel Cycle doesn’t break.
Comments
0 comments
Please sign in to leave a comment.