Facebook

Attention! The Google BigQuery integration has to be enabled to use this feature.

Importing data from Facebook

After enabling this data source, Facebook advertising costs information for the past 7 days will be uploaded to Google BigQuery once every 24 hours.

Connecting and configuring

The process of connecting data sources is described in detail in the overview.

After authorization you need to set the data source parameters.

(1) The name of the data source. It is displayed in the interface in the list of sources.

For a full picture of advertising costs, you need to add all your active advertising accounts (2) (see the “How to Find Your Facebook Ad Account ID” section to find out where to find the advertising account ID).

Import “Ads Insights” report (3) - enable costs report import, without normalizing the values ​​in the table.

Import normalized costs report (4) - enable normalized costs report import.

To save and enable the data source, click “Save” (5).

The “Disconnect” button (7) is used to revoke the authorization data. The settings are saved.

You can enable or disable the data source at any time (6).

How to Find Your Facebook Ad Account ID

Log in to Facebook with an account that has access to the required company. On the https://business.facebook.com/select/ page, select your company. In the window that opens, you will see all your advertising accounts. In order to quickly copy the ID - click on it.

Where to get data on advertising costs

  • facebookCosts_{ACCOUNT_ID}_{YYYYMMDD} - data for normalized costs
  • facebookCampaignStatistics_{ACCOUNT_ID}_{YYYYMMDD} - data for “Ads Insights” report

Table structure

Field name Type Mode
cost FLOAT REQUIRED
clicks INTEGER NULLABLE
impressions INTEGER NULLABLE
utmTerm STRING NULLABLE
utmCampaign STRING NULLABLE
utmContent STRING NULLABLE
utmMedium STRING REQUIRED
utmSource STRING REQUIRED
currency STRING NULLABLE

Supported substitutions

  • campaign.id
  • adset.id
  • ad.id
  • campaign.name
  • adset.name
  • ad.name
  • site_source_name