Integrating Adobe Analytics (AA) data with Salesforce Einstein Analytics (EA) can be achieved by exporting data from AA and importing it into EA. To accomplish this, you'll need to follow these general steps:
- Export data from Adobe Analytics:
Adobe Analytics provides several methods for exporting data, such as using Data Warehouse, Report Builder, or the Adobe Analytics API. Choose the method that best suits your needs.
For example, using Data Warehouse, you can create a data extract containing the desired metrics and dimensions. Schedule the report to be generated regularly, and have it delivered to an FTP location or sent via email in a format like CSV, TSV, or JSON.
- Prepare the data for import to Salesforce Einstein Analytics:
Before importing the data into EA, you may need to perform some data transformation, such as changing date formats or aggregating the data to match the requirements of EA. You can use tools like Talend, Informatica, or even custom scripts to clean and prepare the data.
- Import data into Salesforce Einstein Analytics:
Once the data is prepared, you can import it into EA. Salesforce provides several options for importing external data, such as Dataflow, Data Sync, or the Einstein Analytics External Data API.
For example, using Data Sync, you can configure the import settings, such as mapping the source data fields to the corresponding EA fields, and scheduling the data sync to run at specific intervals.
- Create datasets and build reports in Einstein Analytics:
After successfully importing the data into EA, create datasets to store the imported data. You can then use these datasets to build reports and dashboards in EA, which will provide insights based on the combined Adobe Analytics and Salesforce data.
Note that the process described above requires manual setup and maintenance. If you are looking for a more automated solution, you can explore third-party tools or services that specialize in integrating Adobe Analytics data with Salesforce Einstein Analytics.