MDP Create a Facebook Ads Data Stream

To create and manage ads on Facebook programmatically, create a Facebook Ads data stream.

1. On the Import tab, expand Data Streams Lists.
2. Click Add New.
3. Select Facebook Ads connector.
4. In the General section, select the account that you want to pull data for.
5. To add a new data source authentication, click Add New and enter your Facebook Ads credentials.
6. Set the time period for the initial data fetch. You can process data up to the past 180 days.
7. 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.
8. 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.
9. 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. )
10. Click Create.
11. Quality check your data:
    • Create a report in Facebook Ads platform for the selected date range.
    • Process the relevant data stream in MDP filtered to the same date range.
    • Create an identical report or pivot table in MDP with the same date range, dimensions, and measurements.
    • Compare and make sure that the measurement totals are aligned.
    • Compare the conversions data.
      1. Go to Ads Manager.
      2. Click Reports and select Export table data.
      3. Select the format of the exported file, and click Export.
      4. Compare the Facebook Ads conversions to MDP conversions.

         Conversion metrics in MDP are transposed. For example, in Facebook Ads platform, each conversion type has a measurement: Lead, Purchase, View Content. In MDP, 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.