Facebook Ads — Docs

Renta supports data export from Facebook Ads to following directions:

  • Google BigQuery
  • Clickhouse
  • SQL Server
  • Google Spreadsheets
  • Google Analytics

Integration creating in DWH

  1. Go to integrations catalog
  2. Select Facebook Ads
  3. Add a Facebook account that has the access to the necessary Business Manager or Advertising account.
  4. Specify the destination you have to import the data into
  5. Go to the settings screen and set necessary configuration:
  • Go to integrations catalog

If there are many advertising accounts available, then you can choose the necessary one here.

  • Report type

Each Report Type has its own parameters and metrics collection.

Report type Description
Statistics report

Main report type. Contains information about costs for ad campaigns.

Campaign report

Returns the ad campaigns status and settings

Ads report

Returns the advertisements status and settings

  • Parameters

Full parameters and metrics list is available in the “data structure” part.

Parameters are the dimensions and metrics that are available in Facebook Ads API. You should specify parameters that are necessary for uploading. Renta will form the table, which will automatically update by the given update settings.

The order of the chosen parameters in Rentas interface will be similar to tables column sequence.

  • Data range type

Choose the uploading period. You can specify any historical time interval.

Point in the “from” field the date, starting from which data needs to be uploaded, and in the “to” field point the end date in that period. For instance, if “yesterday” will be pointed in “to” field, then data for upcoming days will be added to the table automatically.

On this page are described all available settings for data updating.

Data Updating

Following updating settings are available for Facebook Ads:

  • Update time
  • Overwrite period
  • Compulsory update with “update” button

Here are the updating data details:

Data Structure

Report type Statistics report

Parameters Description Type Data type
Campaign name Parameters description Dimension String
Ad Parameters description Dimension String
cost Parameters description Dimension Int
impressions Parameters description Dimension Int
ad id Parameters description Dimension String
clicks Parameters description Metrics Int
productIds Products identificator appropriate to
ERP-system and
product feed
Dimension Array
For Google Sheets,
SQL Server: string

Report type Campaign report

Parameters Description Type Data type
Campaign name Parameters description Dimension String
Ad Parameters description Dimension String
cost Parameters description Dimension Int