You are here:
Create a Facebook Ads Data Stream in Marketing Cloud Intelligence
To pull data and create reports for Facebook ads, create a Facebook Ads data stream.
Required Editions
| User Permissions Needed | |
|---|---|
| To create an API data stream: | Admin |
To create a Facebook Ads API data stream, you need:
- A valid Facebook user with View or Manage permissions
- Access to the Ads account
- On the Connect and Mix tab, expand Data Streams.
- Click Add New.
- Select Facebook Ads connector.
- In the General section, select the account that you want to pull data for.
- To add a new data source authentication, click Add New and enter your Facebook Ads credentials.
- Set the time period for the initial data fetch. You can process data up to the past 180 days.
-
In the Extended Properties section, you can set these properties:
-
To retrieve conversion and revenue data in addition to the default delivery data, select
Get Conversions. These fields are added and mapped to the Conversion
Tag data stream type:
Post Impression Revenue Post Click Revenue Revenue - To show conversions and revenue based on their conversion date and not the impression or click date, select Report Conversions on Conversion Date.
- To retrieve all archived entities in Facebook Ads, select Get Archived Entities.
-
To add a higher level of granularity to your data report, select a breakdown from the
dropdown. (You can select only one breakdown per Facebook Ads API data stream.)
Country Adds the Country dimension to the dataset. Age and Gender Adds ‘Age’ and ‘Gender’ to the report. (These dimensions aren’t mapped automatically.) Placement Breaks down the data according to ad placement for example, Facebook Desktop News Feed or Instagram Mobile News Feed. Selecting placement adds ‘Strategy Key’ and ‘Strategy Name’ to your report. Placement & Impression Device Adds these dimensions to the dataset:
- Device Category
- Strategy Key
- Strategy Name
- To determine how Revenue and Total Conversion are calculated, select an attribution setting from the dropdown. The default is 7-day click.
-
To retrieve conversion and revenue data in addition to the default delivery data, select
Get Conversions. These fields are added and mapped to the Conversion
Tag data stream type:
- To change the mapping, click Mapping. You can also access mapping by clicking Map to Model at the bottom of the Create New Stream page.
-
To define advanced settings, at the bottom of the screen, click Advanced
Settings.
Retrieve Data Hourly pulls data from the Facebook Ads API every hour. Include Today's Data in Retrieval pulls the most recent data available by Facebook Ads, retrieving data with 0 lag days. (The time of day can affect the data being pulled, resulting in an incomplete dataset for today’s date. ) - Click Create.
-
Quality check your data:
- Create a report in Facebook Ads platform for the selected date range.
- Process the relevant data stream in Marketing Cloud Intelligence filtered to the same date range.
- Create an identical report or pivot table in Marketing Cloud Intelligence with the same date range, dimensions, and measurements.
- Compare and make sure that the measurement totals are aligned.
- Now compare the conversions data. Go to Ads Manager.
- Click Reports and select Export table data.
- Select the format of the exported file, and click Export.
- Compare the Facebook Ads conversions to Marketing Cloud Intelligence conversions.
Conversion metrics in Marketing Cloud Intelligence are transposed. For example, in Facebook Ads platform, each conversion type has a measurement: Lead, Purchase, View Content. In Marketing Cloud Intelligence, to align with the data model and other platforms, the type of the conversion is returned as a value of a Conversion Tag Category dimension, while the metric values of all conversions are available in the Total Conversions metric.
Did this article solve your issue?
Let us know so we can improve!

