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.
  1. In Marketing Intelligence, on the Data Management tab, click New Pipeline.

  2. Select the MC Intelligence Reports connector tile.

  3. Name your connection, and enter the service account ID, private key, and discovery endpoint from the prerequisite step.

  4. 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.
  5. On the mapping screen, map source fields from your MCI report to the target MI semantic data model fields.

  6. Validate the mapping, and then save and deploy the pipeline.

  7. Monitor processing progress in the Pipeline Deployment Monitor. Click the status link for your pipeline to view details.