Set Up MC Intelligence Reports for MI
Set up the MC Intelligence Reports connection to start the flow of report data into Marketing Intelligence (MI).
Before you begin:
- Complete Create an API Service Account. You use the service account ID, private key, and discovery endpoint from the API service account when you configure the connector.
-
In Marketing Intelligence, on the Data Management tab, click New Pipeline.
-
Select the MC Intelligence Reports connector tile.
-
Name your connection, and enter the service account ID, private key, and discovery endpoint from the prerequisite step.
-
After authenticating, select your account, workspace, and the report you want to ingest.
Make sure that your MCI report meets these requirements:
- The report is in .csv format.
- The report includes a date field.
- If the report includes cost fields, the report also includes a currency field.
-
On the mapping screen, map source fields from your MCI report to the target MI semantic data model fields.
-
Validate the mapping, and then save and deploy the pipeline.
-
Monitor processing progress in the Pipeline Deployment Monitor. Click the status link for your pipeline to view details.