Sign up for free
Functions

GET_ACCOUNT_INSIGHTS_FACEBOOK_ADS

Get metrics such as clicks, CPC, CTR, and CPM about your Ad accounts by date.

People
Social
icon of Facebook AdsFacebook Ads
Not a big fan of functions?
Use the Actions Wizard to configure any action in Rows without functions.

Parameter List

Syntax
GET_ACCOUNT_INSIGHTS_FACEBOOK_ADS(account_name, 
[fields]
, 
[breakdowns]
, 
[date_range]
, 
[aggregation_period]
)
account_name

Name or ID of your Facebook Ads account. For example: "Personal Ads account".

[optional] fields

Range of fields to retrieve about the ad account. For example: '["clicks","country"]'. By default, it returns the most common metrics about the ad account. For a complete list of possible fields, see the Facebook Marketing API documentation.

Selected options:
Account Currency
Account Name
Actions
Action Values
Account ID
Auction Bid
Auction Competitiveness
Buying Type
Conversions
Conversions Values
Country
CPC
CTR
CPM
CPP
Clicks
Impressions
Mobile Purchase ROAS
Purchase ROAS
Social spend
Spend
Reach
Updated Time
Website Purchase ROAS
[optional] breakdowns

Range of values to break down the results into different sets. For example: '["device_platform"]'. For a complete list of possible breakdowns, see the Facebook Insights API Breakdowns documentation.

Selected options:
Ad Format Asset
Age
App ID
Body Asset
Call_to_action Asset
Country
Description Asset
Gender
Image Asset
Impression Device
Link_url Asset
Product ID
Region
Skan Conversion ID
Title Asset
Video Asset
DMA
Frequency Value
Hourly Stats Aggregated by advertiser time zone
Hourly Stats Aggregated by audience time zone
Place Page ID
Publisher Platform
Platform Position
Device Platform
[optional] date_range

Date range to get insights for. For example: ">2019", ">2019-11-01" or "[2010-01-01;2019-01-01]". By default, you get insights for the current month.

[optional] aggregation_period

Groups account insights by time period. By default, it will group the account stats for the whole period. 1 breaks down that data by day,7 by week and monthly by calendar month.

Selected options:
daily
weekly
monthly
More details

Access this page to check how you can find the account name or account ID.

Examples

GET_ACCOUNT_INSIGHTS_FACEBOOK_ADS("adidas", "clicks", A1:A2, ">2021-07-01") returns insights about `clicks` and `country` about the `adidas` ad account. The values will be sorted by country and region.