“”

AppExchange Chat: Salesforce Data Mapping

Define how AppExchange Chat data integrates with your company’s systems and business processes.

In this guide, you'll learn how to map AppExchange Chat data into Salesforce. Once you’ve configured data mapping, AppExchange Chat conversations and chatbot interactions can create leads, contacts, and events in your Salesforce org. 

Here’s what we’ll cover:

  1. Data Mapping Basics 
  2. Data to basic Required Fields
  3. Data Mapping for Complicated Data Types
  4. Mapping Checkbox Data
  5. Mapping Hidden Field Data
  6. Salesforce Campaign Setup and Mapping

Data Mapping Basics

When prospects participate in conversations or chatbot experiences, AppExchange Chat captures information that can be used to create leads, contacts, and other Salesforce records. The process of transforming that information into records is called data mapping, and it starts by identifying standard and custom fields on key Salesforce objects. Use the following table to determine which lead fields you'd like to map to. Then repeat the process for contacts.

AppExchange Chat, Field Mappings into Salesforce
Use this table with your Qualified Consultant to note required Lead fields.

Map Data to Common and Required Fields

After you identify the lead and contact fields you want to map, you can start data mapping. At a minimum, you should map data from common and required fields for leads and contacts. 

  1. Log in to your Qualified dashboard.
  2. On the bottom left, click the gear icon.
  3. Under Salesforce, click Lead Mapping.
  4. Add the lead fields that you identified for mapping. 
  5. Click Save
  6. Under Salesforce, click Contact Mapping.
  7. Add the contact fields that you identified for mapping.
  8. Click Save.
AppExchange Chat, Contact and Lead Mappings
Lead and Contact Mapping within your Qualified Account Settings
If you don't see the visitor field that you'd like to match up with your Salesforce field, you can create it on the fly by selecting "Create Field" in the drop down menu. We’ll automatically create the Visitor Field for you and match it up with your Salesforce field for mapping purposes.
AppExchange Chat, Mapping Basic Fields
Select your Salesforce Fields and Qualified Fields for mapping.

Please note: There are some Salesforce field data types that Qualified cannot map into at this time: Lookup Fields, Multi-Select Picklists, and Formula Fields.

Mapping Data to More Complicated Data Types

After you map common and required fields, you can consider mapping more complicated data types. Mapping standard fields such as name, company, and email is a great start - and it's likely your business has at least a few additional fields specific to your business needs that we'll want to map as well. First, let’s talk about data types.

What's a data type? Here, data type is the type, or “flavor”, of data that a Salesforce field accepts as valid. For example,Company is a text field, meaning it accepts a string of characters. Similarly, Email is an email field, which accepts only valid email addresses

Next, let's look at an example of a more complex (but common) data type: picklists. In Salesforce, fields like Company Size or Industry commonly have default values set by a Salesforce admin. If you want to map AppExchange Chat data into these fields, it's a good idea to allow only the values set by your Salesforce admin. That way, when you select the field in Salesforce, the mapping automatically pulls in these values. Here’s an example.

AppExchange Chat, Mapping Values into Salesforce
Qualified will pull in your Picklist values automatically.

Map Checkbox Data

Checkboxes are another important and commonly used Salesforce field type. Mapping AppExchange Chat data to a checkbox can be a bit more complex than other fields, as it is always either true (checked) or false (unchecked) and frequently triggers workflows within Salesforce orgs.

Before you map a checkbox, note the two options available for data mapping: default value or fixed value. A default value allows you to map a value to a field only if the field is already empty. Because checkbox fields in Salesforce are never empty (that is, they are always true or false), we suggest avoiding this mapping option in most cases. In contrast, a fixed value allows you to override whatever is in the checkbox field with a predetermined value. In this example, the fixed value is true.

AppExchange Chat, Field Mappings into Salesforce
Set your checkbox field to be default or fixed value.

To mark a checkbox as true, you must select true as your fixed value. This will ensure each time a lead or contact is created or updated in Salesforce that box is marked as true.

Map Hidden Field Data

Another common practice is to hardcode some field values when leads are created in Salesforce. For example, this approach is favored when you want the system setting field values according to your defined rules, instead of sales reps setting the values manually. For leads, this typically occurs with the Lead Source field. In AppExchange Chat, setting a hardcoded ("hidden") value for Lead Source lets you see that a lead originated from a live conversation or chatbot interaction. This information is often useful for reporting by marketing managers and sales managers.

AppExchange Chat, Mapping Hidden Values in Salesforce
Create a hidden Salesforce field in Qualified by selecting hidden field type in Qualified.

Create a Salesforce Campaign for AppExchange Chat

To help you track the leads and other data that originates from AppExchange Chat, we suggest creating a campaign in Salesforce. You can name the campaign anything you like, but we recommend including "AppExchange Chat" so it’s clear where the lead came from. Follow these steps to create a campaign in Salesforce.

1. Log in to your Salesforce org.
2. Click the App Launcher, and then click Marketing.
3. Click Campaigns.
4. Click New.
5. Assign the following field values. You can leave the other field blank.
a. Active: Checked
b. Type: Web Conversations
c. Status: In Progress
d. Start Date: Today’s date, or leave blank.
6. Click Save.

AppExchange Chat, Creating a Campaign in Salesforce
Creating your Campaign in Salesforce to connect to Qualified.

Configure Campaign Attribution in the Qualified Dashboard

After you configure a campaign for AppExchange Chat in Salesforce, add the campaign to the Qualified dashboard. 

  1. Log in to your Qualified dashboard.
  2. On the bottom left, click the gear icon.
  3. Under Salesforce, click Lead Mapping
  4. Under Salesforce Campaigns, click Add Campaign. 
  5. Select the campaign that you created for AppExchange Chat.
  6. Click Save.
AppExchange Chat, Mapping to a Salesforce Campaign
Creating your Campaign Attribution in Salesforce.

Next, repeat the process for contacts.

  1. Under Salesforce, click Contact Mapping
  2. Under Salesforce Campaigns, click Add Campaign. 
  3. Select the campaign that you created for AppExchange Chat.
  4. Click Save.

Once this is set, we'll now know which Salesforce Campaign(s) to associate your Leads or Contacts to by default.

To associate AppExchange Chat prospects with a Pardot Source Campaign, use the Pardot Prospect mapping area.

Verify Lead Source Configuration

Accurate lead source values help you understand where your leads are coming from. Before you finish setting up campaign attribution, verify that the Lead Source field in Salesforce is populated correctly when AppExchange Chat creates a lead. 

  1. In your Qualified Dashboard, under Salesforce, click Lead Mapping.
  2. Find the Lead Source field. If you don’t see the field, add it by clicking the plus icon and browsing to Lead Source.
  3. Verify that the default value is set to Website Conversation. If not, set the value.

AppExchange Chat, Field Mapping for Lead Source
Verify that AppExchange Chat leads are associated with a default Lead Source value.

Summary

You just learned how to map lead, contact, and campaign data from AppExchange Chat to Salesforce. We also explored how to map hidden fields into Salesforce for reporting purposes by sales and marketing managers.

Next Steps

Continue in your education with AppExchange Chat:

Request a live demo

See Qualified in action on your website. Request a live demo and one of our reps will contact you immediately, or talk to us right now.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Free custom demo
Live on your site