How do I use Join with Salesforce conversion data?
AdStage Join allows marketers to connect paid ad performance data with Salesforce lead conversion data in order to discover how many down-funnel conversions come from each network, campaign, ad set, or ad.
How does it work?
Join works by connecting your Salesforce (SFDC) conversion data with the paid ad account, campaign, ad group, and ad from which the conversion came via UTM parameters. Simply create a UTM report in SFDC (details below) that includes the lead data you want to "join" with your paid ad data, and use this report to drive your Join custom conversion.
Follow the steps in AdStage Join to pair your SFDC report and ad accounts together, choose a level of granularity, and then schedule how frequently you want AdStage to join your data.
Once you click save your Join task can be found in the Join table. Join will run and start mapping data at the scheduled time, based on the join levels you set. When the task has run, you can jump into the log to see the results.
Then, implement your newly joined custom conversion in your Report dashboards and Automate tasks by searching for the custom conversion by name in the Fields section.
What are some common ways to use Join?
Show how marketing efforts contribute directly to each portion of the funnel (web analytics, down-funnel metrics)
Prove campaign, ad, etc. ROI or ROAS (Return on Ad Spend)
Automatically pause/enable campaigns or adjust bids based on down-funnel metrics
How do I set up a Join task?
Step 1: Login to salesforce.com and create a UTM report that includes the following columns/objects:
Created date. You will use this in Step 4 of creating your Join task
Tracking parameters (e.g. utm_campaign, utm_content, customID, etc.)
Conversions (whether it’s leads, opportunities, etc.)
Conversion value (if needed)
Step 2: Navigate back to AdStage and click on Join by hovering over the Data Management Icon on the left-hand sidebar.
Step 3: Click the “Create New” button on the top right-hand side.
Step 4: Choose Salesforce as your conversion source.
Step 5: Select "Created_Date" as your Conversion Date, then choose the SFDC report you want and enter a name and description for the custom conversion. Pick a Conversion Value from the drop-down on the right.
Step 6: Select the ad account(s) you want to join with your SFDC report data.
Step 7: Select the Join levels of granularity you’d like to use for this custom conversion.
Step 8: Match your SFDC keys with your network keys by selecting the corresponding options from the drop-down boxes on the right-hand side.
Step 9: Choose a lookback window for which AdStage will pull conversion data, a “use data from” time range, and frequency for how often AdStage will pull conversion data.
Step 10: Name your Join task and click Save.
Best Practices and Other Notes
Custom conversions created in Join can only be accessed in cross-network widgets.
The user who connects Salesforce to AdStage must have access to the Salesforce report you're planning on using in your Join task. In addition, the Salesforce user must have the permission "API Enabled." Salesforce has some documentation on permissions here.
Have questions about Join? Please reach out to us at support@adstage.io