Loading
Salesforce now sends email only from verified domains. Read More
Help Agent Performance DegradationRead More
Integrate and Analyze Marketing Data with Marketing Cloud Intelligence
Table of Contents
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

          Search all of Salesforce Help
          Create a Facebook Ads Custom Data Stream in Marketing Cloud Intelligence

          Create a Facebook Ads Custom Data Stream in Marketing Cloud Intelligence

          To create a Facebook ads custom report, create a Facebook ads custom data stream.

          Required Editions

          User Permissions Needed
          To create an API data stream: Admin

          To create a Facebook Ads Custom API data stream, you need a valid Facebook user account with ‘View’ or ‘Manage’ access to the Ads Account.

          1. On the Connect and Mix tab, expand Data Streams.
          2. Click Add New.
          3. Select the Facebook Ads Custom connector.
          4. In the General section, enter your credentials, and select the account that you want to pull data for.
          5. To add a data source authentication, click Add New and enter your Facebook credentials.
          6. To add a template, select a template from the dropdown menu.
          7. Set the time period for the initial data fetch. You can process data up to the past 180 days.
          8. In the Extended Properties section, you can set these properties:
            1. Select the data stream type you want to map your data to. Only one data stream type is selected for a Facebook Ads custom API data stream.
            2. Set the granularity from the Level dropdown. The level setting determines the lowest level of granularity you want to retrieve. (Granularity affects the measurement values, in relation to the Facebook Ads manager view.)
            3. Set the Date Resolution granularity. When selecting Aggregated, the data is retrieved without the Day dimension, so add a date in the mapping screen.
            4. Select the custom dimensions you want to retrieve, separated by a comma. For more information on the syntax and limitations, see Meta Developer Documentation: Insights API.
              Note
              Note The lowest level of granularity is set in the Level section, and any custom dimensions added on a lower level of granularity won’t affect the data. For example, if you set Campaign-Level as the lowest level of granularity, adding Ads attributes to the list of dimensions won’t have any effect, since the measurements retrieved are on the campaign level.
            5. Select the custom measurements you want to retrieve, separated by a comma. Some fields indicate that there are a group of measurements listed under one name. For example, actions. The measurements are listed in the list link.

              To retrieve specific measurements from a group, place the names inside curly brackets ({}) after the group name and separated by a semicolon (;).

              To retrieve all the available data for the specified measurement group, omit the curly brackets.

              Select at least one dimension and any related dimensions to the selected measurements. For example, if you’re retrieving the Cost or Revenue measurements, add the currency dimension so the currency measurements are converted correctly.

              If you want to retrieve offline purchases, you can use the following syntax: "actions{offline_conversion.purchase}"

            6. When retrieving conversion and revenue measurements, the API pulls data for 1 day, 7 day and 28 day conversions. Map the conversion and revenue measurements that correlate to the conversion attribution window you set in Facebook Ads.
            7. To add a breakdown, enter the breakdown fields you want to apply to the data. For example, to see age and gender, enter: age,gender. Some Breakdown fields can’t be combined. For more information see the Facebook Developer page Combining Breakdowns.
            8. To apply an Action Breakdown to your data, for example: action_type, enter the action breakdown. To prevent discrepancies or duplications when using Action Breakdowns, place the measurements in the measurements section.
            9. Conversions in Facebook are reported based on the impression or click date. To configure your report to show conversions based on their conversion date, select Report Conversions on Conversion Date.
            10. To retrieve all archived entities in Facebook Ads, select Get Archived Entities (Disabled with Adset Level).
          9. To change the mapping, click Mapping. Otherwise, you can always access mapping by selecting Map to Model at the bottom of the Create New Stream page.
          10. To define advanced settings, at the bottom of the screen, select Advanced Settings.
          11. Click Create.
          12. Quality check your data.
            1. Create a report for Facebook Post Insights for the required date range.
            2. Process the relevant data stream in Marketing Cloud Intelligence, filtered to the same date range.
            3. Create an identical report or pivot table in Marketing Cloud Intelligence with the same date range, dimensions, and measurements.
            4. Compare the measurement totals to make sure that they’re aligned.
            5. In your Ads Manager, click Reports, and then select Export table data.
            6. Select the format of the exported file, and then click Export.
            7. Compare the Facebook Ads conversions to Marketing Cloud Intelligence conversions.

              Conversion metrics in Marketing Cloud Intelligence are transposed. For example, in Facebook Ads platform, there is a measurement for each conversion type: 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.

              There isn’t a view on the Facebook platform that matches the Conversions in the Conversion Date report. To quality-check your data, compare the totals of Entities from Campaigns that have ended.

           
          Loading
          Salesforce Help | Article