Seamlessly Integrating Adobe Analytics and Salesforce (SFDC): A Guide to Custom Solutions

How to Achieve Two-Way Integration Between Adobe Analytics and Salesforce

Integrating Adobe Analytics with Salesforce (SFDC) offers a powerful way to unify your data for actionable insights. While no ready-made connector exists in Adobe's Data Connectors library, custom solutions can bridge this gap. Here’s what you need to know and the methods you can leverage.

Sending Data from Adobe Analytics to SFDC

There are several ways to export data from Adobe Analytics to Salesforce:

1. Data Warehouse API

   • Utilize the Data Warehouse API to programmatically send data into Salesforce.

2. Reporting API

   • Use Adobe Analytics' Reporting API to fetch data and push it to Salesforce.

3. Data Extract Reports

   • Create data extract reports, then inject them into Salesforce manually or through automation.

4. Data Warehouse Reports

   • Generate reports from Adobe’s Data Warehouse and integrate them into Salesforce.

5. Data Feeds

   • Schedule hourly or daily raw data exports (each row represents a hit, and each column is a variable).

   • Export these files to an FTP server and inject them into Salesforce.

Sending Data from SFDC to Adobe Analytics

To import data from Salesforce into Adobe Analytics, consider the following methods:

1. Data Source API

   • Leverage Adobe’s Data Source API to push Salesforce data into Analytics seamlessly.

2. Data Source FTP

   • Export Salesforce data to an FTP server, then import it into Adobe Analytics using Data Sources.

Pro Tip: Perform a Proof of Concept (POC)

Before implementing a solution, conduct a Proof of Concept (POC) to evaluate the dimensions and metrics to be imported and exported. This step ensures you choose the most efficient method tailored to your integration needs.

Final Thoughts

A custom integration between Adobe Analytics and Salesforce requires thoughtful planning and execution. By leveraging the right APIs, reports, and data feeds, you can create a robust two-way data exchange. Whether you're exporting valuable analytics insights to Salesforce or importing customer data into Adobe Analytics, the right approach ensures seamless alignment of your data strategy.