Access Facebook Ads in Excel


Statistics

Facebook Ads are made up of four levels:

  • Account
  • Campaign
  • Ad set
  • Ads

The Facebook Ads Connector allows users to extract statistics about each of the four levels in a specified date interval.

Level Breakdowns

Level - Break down an object based on the sub items in the lower levels. For example, extracting statistics for a campaign broken down by each ad belonging to the campaign.

Period Increment - Break down an object based on smaller time increments. For example, extracting statistics for a campaign broken down by each month or day.


Actions

Extract the number of Total or Unique actions for a particular object from each of the four levels.


Reach Frequency

Extract the reach for each identified frequency for a particular object from each of the four levels.


Statistics Breakdown

Extract statistics broken down by one of many methods or demographics for a particular object from each of the four levels. Available breakdowns:

  • Device
  • Age
  • Gender
  • Age & Gender
  • Country
  • Region
  • Placement
  • Publisher Platform

It is also possible to combine one of the methods or demographics with Period Increment.


Metrics

  • Impressions
  • Reach
  • Spent
  • Clicks
  • Website Clicks
  • App Store Clicks
  • Social Impressions
  • Social Reach
  • Social Spent
  • Social Clicks
  • Actions
  • Actions Value
  • Cost per Action
  • CPC
  • Frequency

Access

To use the Facebook Ads Connector you need a token. We recommend creating a "long-lived" token according to this excellent guide. The token is valid for 60 days and is entered in the Settings menu inside the connector.


Contribute

This connector suite is open-sourced on GitHub.


See

Official Documentation

Related Functions


Get help with this function in the community →