Integrate API Connector

• Data Stream Type: Choose the Data Stream Type into which the data will be mapped as described in the ‘Extended Properties’ section.

Prerequisites

Provide your Organization ID and API Key. Complete the following steps in order to retrieve these:

1. Log into Integrate and navigate to ‘Organization Settings’.
2. Click ‘Generate New Key’ in the top-right corner.
3. Input your Organization ID and API Key into the Authentication box.

Setup Requirements

The Integrate connector is a report-based connector. Select a report from the ‘Report’ dropdown, populated with report name values that are of actual reports already created in Integrate. You can find the Reports in Integrate by navigating to Analytics > Reports

Extended Properties

Data Stream Type - Select the Data Stream Type into which the data will be mapped. You can map into the following Data Stream Types:

• Ads
• CRM
• CRM Leads
• Conversion Tag
• Generic

Details

The names of the Unmapped File Fields match the names in the report file you download from Integrate. It isn’t compulsory to map all the available fields - you can map only the fields you need.

How to QA

• Create the desired report in the Integrate UI for the required date range and then process the relevant Data Stream in Marketing Cloud Intelligence for the exact same date range. Not all reports are subject of date range - some provide lifetime data. For example, the Leads Report provides lifetime leads data. In such instances follow the same steps, but note that no matter which date range you process, the same data is retrieved.
• Create a Report/Table Widget/Pivot Table within Marketing Cloud Intelligence containing the exact same Dimensions and Measurements for the same date range.
• Compare the Measurement Totals and make sure they’re aligned.
• To ensure that you have mapped correctly in terms of Entity relationships, filter the Integrate report for a certain Dimension value and make sure that the list of associated Dimensions seen in the Integrate report corresponds to that seen in Intelligence when the same filtering is applied. Under the above filtering, make sure that the Measurement values are aligned as well.