To import CJ Affiliate (Commission Junction) data into Adobe Commerce Intelligence, simply follow the steps below and attach the resulting file to a support ticket. Adobe will set up the data table your account and allow you to continue uploading data independently.
In your CJ Affiliate account, go to the Reports
tab.
In the Performance
tab, select Report Options
.
Set Performance By
equal to Program
, Trend
equal to Daily
, and Date Range
equal to the date range being audited.
Select Run Report
.
In the File Format
dropdown, select CSV
. Click Download.
After you have downloaded the file, you can upload the file to your Commerce Intelligence Data Warehouse.
This creates a table in your Commerce Intelligence Data Warehouse that you can continue to upload fresh data into periodically. When uploading the file, follow the formatting requirements listed in Using the File Uploader.