Salesforce + Attentive identity boost guide

Add subscriber ID as a UTM to the links in your Salesforce Marketing Cloud emails and share email addresses and subscriber IDs with Attentive. This helps us better identify your email subscribers when they browse your site. By completing the steps in this article, you can increase your text and email message journey volume and revenue.

Add subscriber ID to Salesforce Marketing Cloud email links

To add subscriber ID as a UTM parameter to Salesforce Marketing Cloud links that appear in emails, complete the following steps in Salesforce Marketing Cloud:

1. In Salesforce Marketing Cloud, go to Setup > Data Management > Parameter Management.
2. Expand Web Analytics Connector.
3. Click Edit.
   
4. Add the following UTM parameter to the end of your Brand Tag (emailXtraLinkParameters) Tracking String: &sfmc_id=%%subscriberid%%.
5. Click Save.
6. Sign up for emails on your website and verify that you can see an actual sfmc_id when you click a link in an email.
7. Follow the steps in the sections below to export email addresses and subscriber IDs from Salesforce Marketing Cloud.

Export subscriber email addresses and IDs from Salesforce Marketing Cloud

After you add subscriber ID as a UTM parameter to Salesforce Marketing Cloud links that appear in emails, complete the following steps to export subscriber email addresses as a CSV.

Create a new data extension

Create a new data extension that includes subscriber email addresses and subscriber IDs:

1. In Salesforce Marketing Cloud, go to Email Studio > Email > Subscribers > Data Extensions.
2. Click Create.
   
3. Select Standard Data Extension, then click OK.
4. Complete the fields to create the new data extension. We recommend using Export Subscriber ID as the new data extension’s Name.
5. In Fields (step 3), add two fields:
   • Email address
     • Name: emailAddress
     • Data type: EmailAddress
   • Subscriber ID
     • Name: subscriberID
     • Data type: Number
       
       
       Note: Be sure to export subscriberID, not subscriberKey.
       
6. Click Create.

Create a new automation

Create a new automation to query for active subscriber IDs:

1. Go to Journey Builder > Automation Studio.
2. Click New Automation.
3. Add Schedule as the Starting Source and SQL Query as the Activity.
   
4. Click Choose in the SQL Query panel.
5. Click Create New Query Activity.
6. In the Properties step (step 1), enter Export Subscriber ID as the new activity’s Name, then click Next.
7. In the Query step (step 2), enter the SQL query below, then click Next:
   

   SELECT EmailAddress, SubscriberID
       FROM _subscribers
       WHERE status = 'Active'

   Note: If you’re querying a Child Business Unit in Salesforce, use the query below:

   SELECT EmailAddress, SubscriberID
         FROM ent._subscribers
         WHERE status = 'Active'

   
8. In the Target data extension step (step 3), search for and select Subscriber ID Export. In the Data Action section, select Overwrite, then click Next.
   
9. Click Finish to save the query activity.
10. Click Save to save the new automation.

Run the export subscriber ID automation

Run the automation you created in the previous section:

1. In Salesforce Automation Studio, search for and select Export Subscriber ID.
2. Click Run Once.
   
3. Check the box in the Export Subscriber ID panel, then click Run.
4. Click Run Now.
5. Click the Activity tab to verify that the automation is running.
   

Download CSV of subscriber email addresses and subscriber IDs

Download the CSV of active subscriber email addresses and IDs generated by the automation you created and ran in the previous sections.

1. When the automation finishes running, go to Salesforce Marketing Cloud > Email Studio > Email > Subscribers > Data Extensions.
2. Search for Subscriber ID.
3. Click Records.
4. Click Export.
   
5. In Filename, enter your company’s name.
   
   
   Example: your_company.csv
6. In Notification email address, enter your email address.
   
7. Click Export.

Send CSV to Attentive

After you successfully export a CSV containing subscriber email addresses and IDs, send the CSV to your Attentive CSM via the Box link they provided to you via email. By sharing the data in this CSV with Attentive, we can identify website traffic from emails sent through Salesforce Marketing Cloud and associate that traffic with subscribers in Attentive.