Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| TIME | Year | year | dim | |
| Year of week (Sun-Sat) | yearOfWeek | dim | ||
| Year of week (Mon-Sun) | yearOfWeekIso | dim | ||
| Year & month | yearMonth | dim | ||
| Month | month | dim | ||
| Year & week (Sun-Sat) | yearWeek | dim | ||
| Year & week (Mon-Sun) | yearWeekIso | dim | ||
| Week (Sun-Sat) | week | dim | ||
| Week (Mon-Sun) | weekIso | dim | ||
| Day of month | dayOfMonth | dim | ||
| Day of week (Sun-Sat) | dayOfWeekName | dim | ||
| Day of week (Mon-Sun) | dayOfWeekNameIso | dim | ||
| Date | date | dim | The date when someone created the ad. This is not the same time as when the ad ran | |
| AD | Ad ID | id | dim | ID for the archived ad object |
| Ad creative bodies | ad_creative_body | dim | Text displayed in the ad. Different text variations separated with a semicolon | |
| Ad creative link captions | ad_creative_link_caption | dim | If an ad contains links, the text that appears in the link. Different text variations separated with a semicolon | |
| Ad creative link descriptions | ad_creative_link_description | dim | If an ad contains links, any text descriptions that appears next to the links, such as a caption or description. Different text variations separated with a semicolon | |
| Ad creative link titles | ad_creative_link_title | dim | If an ad contains links, any titles provided. Different text variations separated with a semicolon | |
| Ad delivery start time | ad_delivery_start_time | dim | Date an time when an advertiser wants Facebook to start delivering an of the ad. Provided in UTC | |
| Ad delivery stop time | ad_delivery_stop_time | dim | The time when an advertiser wants to stop delivery of their ad. If this is blank, Facebook runs the ad until the advertiser stops it or they spend their entire campaign budget. In UTC | |
| Ad snapshot URL | ad_snapshot_url | dim | String with URL link which displays the archived ad. This displays uncompressed images and videos from the ad | |
| Publisher platforms | publisher_platforms | dim | A list of platforms where the archived ad appeared, such as Facebook or Instagram | |
| ACCOUNT | Page ID | page_id | dim | ID of the Facebook Page that ran the ad |
| Page name | page_name | dim | Name of the Facebook Page that ran the ad | |
| Link to page | page_url | dim | Link to the Facebook Page that ran the ad | |
| Funding entity | funding_entity | dim | A string containing the name of the person, company, or entity that provided funding for the ad. Provided by the purchaser of the ad | |
| Currency | currency | dim | The currency used to pay for the ad, as an ISO currency code | |
| AUDIENCE | Reach: females aged 18-24 | demographic_distribution_female_18_24 | dim | Percentage of reached people belonging to this demographic group |
| Reach: females aged 25-34 | demographic_distribution_female_25_34 | dim | Percentage of reached people belonging to this demographic group | |
| Reach: females aged 35-44 | demographic_distribution_female_35_44 | dim | Percentage of reached people belonging to this demographic group | |
| Reach: females aged 45-54 | demographic_distribution_female_45_54 | dim | Percentage of reached people belonging to this demographic group | |
| Reach: females aged 55-64 | demographic_distribution_female_55_64 | dim | Percentage of reached people belonging to this demographic group | |
| Reach: females aged 65+ | demographic_distribution_female_65 | dim | Percentage of reached people belonging to this demographic group | |
| Reach: males aged 18-24 | demographic_distribution_male_18_24 | dim | Percentage of reached people belonging to this demographic group | |
| Reach: males aged 25-34 | demographic_distribution_male_25_34 | dim | Percentage of reached people belonging to this demographic group | |
| Reach: males aged 35-44 | demographic_distribution_male_35_44 | dim | Percentage of reached people belonging to this demographic group | |
| Reach: males aged 45-54 | demographic_distribution_male_45_54 | dim | Percentage of reached people belonging to this demographic group | |
| Reach: males aged 55-64 | demographic_distribution_male_55_64 | dim | Percentage of reached people belonging to this demographic group | |
| Reach: males aged 65+ | demographic_distribution_male_65 | dim | Percentage of reached people belonging to this demographic group | |
| Demographic distribution of reach | demographic_distribution | dim | The demographic distribution of people reached by the ad | |
| Region distribution of reach | region_distribution | dim | Regional distribution of people reached by the ad. Provided as a percentage and where regions are at a sub-country level | |
| PERFORMANCE | Potential reach: lower bound | potential_reach_lower_bound | dim | This is an estimate of the size of the audience that's eligible to see this ad. It's based on targeting criteria, ad placements and how many people were shown ads on Facebook apps and services in the past 30 days. This is not an estimate of how many people will actually see this ad, and the number may change over time. It isn't designed to match population or census estimates |
| Potential reach: upper bound | potential_reach_upper_bound | dim | This is an estimate of the size of the audience that's eligible to see this ad. It's based on targeting criteria, ad placements and how many people were shown ads on Facebook apps and services in the past 30 days. This is not an estimate of how many people will actually see this ad, and the number may change over time. It isn't designed to match population or census estimates | |
| Impressions: lower bound | impressions_lower_bound | dim | The number of times the ad created an impression. In ranges of: <1000, 1K-5K, 5K-10K, 10K-50K, 50K-100K, 100K-200K, 200K-500K, >1M | |
| Impressions: upper bound | impressions_upper_bound | dim | The number of times the ad created an impression. In ranges of: <1000, 1K-5K, 5K-10K, 10K-50K, 50K-100K, 100K-200K, 200K-500K, >1M | |
| Spend: lower bound | spend_lower_bound | dim | Amount of money spent running the ad. This is reported in ranges: <100, 100-499, 500-999, 1K-5K, 5K-10K, 10K- 50K, 50K-100K, 100K-200K, 200K-500K, >1M | |
| Spend: upper bound | spend_upper_bound | dim | Amount of money spent running the ad. This is reported in ranges: <100, 100-499, 500-999, 1K-5K, 5K-10K, 10K- 50K, 50K-100K, 100K-200K, 200K-500K, >1M | |
| TIME | Year | year | dim | |
| Year of week (Sun-Sat) | yearOfWeek | dim | ||
| Year of week (Mon-Sun) | yearOfWeekIso | dim | ||
| Year & month | yearMonth | dim | ||
| Month | month | dim | ||
| Year & week (Sun-Sat) | yearWeek | dim | ||
| Year & week (Mon-Sun) | yearWeekIso | dim | ||
| Week (Sun-Sat) | week | dim | ||
| Week (Mon-Sun) | weekIso | dim | ||
| Day of month | dayOfMonth | dim | ||
| Day of week (Sun-Sat) | dayOfWeekName | dim | ||
| Day of week (Mon-Sun) | dayOfWeekNameIso | dim | ||
| Date | date | dim | The date when someone created the ad. This is not the same time as when the ad ran | |
| AD | Ad ID | id | dim | ID for the archived ad object |
| Ad creative bodies | ad_creative_body | dim | Text displayed in the ad. Different text variations separated with a semicolon | |
| Ad creative link captions | ad_creative_link_caption | dim | If an ad contains links, the text that appears in the link. Different text variations separated with a semicolon | |
| Ad creative link descriptions | ad_creative_link_description | dim | If an ad contains links, any text descriptions that appears next to the links, such as a caption or description. Different text variations separated with a semicolon | |
| Ad creative link titles | ad_creative_link_title | dim | If an ad contains links, any titles provided. Different text variations separated with a semicolon | |
| Ad delivery start time | ad_delivery_start_time | dim | Date an time when an advertiser wants Facebook to start delivering an of the ad. Provided in UTC | |
| Ad delivery stop time | ad_delivery_stop_time | dim | The time when an advertiser wants to stop delivery of their ad. If this is blank, Facebook runs the ad until the advertiser stops it or they spend their entire campaign budget. In UTC | |
| Ad snapshot URL | ad_snapshot_url | dim | String with URL link which displays the archived ad. This displays uncompressed images and videos from the ad | |
| Publisher platforms | publisher_platforms | dim | A list of platforms where the archived ad appeared, such as Facebook or Instagram | |
| ACCOUNT | Page ID | page_id | dim | ID of the Facebook Page that ran the ad |
| Page name | page_name | dim | Name of the Facebook Page that ran the ad | |
| Link to page | page_url | dim | Link to the Facebook Page that ran the ad | |
| Funding entity | funding_entity | dim | A string containing the name of the person, company, or entity that provided funding for the ad. Provided by the purchaser of the ad | |
| Currency | currency | dim | The currency used to pay for the ad, as an ISO currency code | |
| AUDIENCE | Reach: females aged 18-24 | demographic_distribution_female_18_24 | dim | Percentage of reached people belonging to this demographic group |
| Reach: females aged 25-34 | demographic_distribution_female_25_34 | dim | Percentage of reached people belonging to this demographic group | |
| Reach: females aged 35-44 | demographic_distribution_female_35_44 | dim | Percentage of reached people belonging to this demographic group | |
| Reach: females aged 45-54 | demographic_distribution_female_45_54 | dim | Percentage of reached people belonging to this demographic group | |
| Reach: females aged 55-64 | demographic_distribution_female_55_64 | dim | Percentage of reached people belonging to this demographic group | |
| Reach: females aged 65+ | demographic_distribution_female_65 | dim | Percentage of reached people belonging to this demographic group | |
| Reach: males aged 18-24 | demographic_distribution_male_18_24 | dim | Percentage of reached people belonging to this demographic group | |
| Reach: males aged 25-34 | demographic_distribution_male_25_34 | dim | Percentage of reached people belonging to this demographic group | |
| Reach: males aged 35-44 | demographic_distribution_male_35_44 | dim | Percentage of reached people belonging to this demographic group | |
| Reach: males aged 45-54 | demographic_distribution_male_45_54 | dim | Percentage of reached people belonging to this demographic group | |
| Reach: males aged 55-64 | demographic_distribution_male_55_64 | dim | Percentage of reached people belonging to this demographic group | |
| Reach: males aged 65+ | demographic_distribution_male_65 | dim | Percentage of reached people belonging to this demographic group | |
| Demographic distribution of reach | demographic_distribution | dim | The demographic distribution of people reached by the ad | |
| Region distribution of reach | region_distribution | dim | Regional distribution of people reached by the ad. Provided as a percentage and where regions are at a sub-country level | |
| PERFORMANCE | Potential reach: lower bound | potential_reach_lower_bound | dim | This is an estimate of the size of the audience that's eligible to see this ad. It's based on targeting criteria, ad placements and how many people were shown ads on Facebook apps and services in the past 30 days. This is not an estimate of how many people will actually see this ad, and the number may change over time. It isn't designed to match population or census estimates |
| Potential reach: upper bound | potential_reach_upper_bound | dim | This is an estimate of the size of the audience that's eligible to see this ad. It's based on targeting criteria, ad placements and how many people were shown ads on Facebook apps and services in the past 30 days. This is not an estimate of how many people will actually see this ad, and the number may change over time. It isn't designed to match population or census estimates | |
| Impressions: lower bound | impressions_lower_bound | dim | The number of times the ad created an impression. In ranges of: <1000, 1K-5K, 5K-10K, 10K-50K, 50K-100K, 100K-200K, 200K-500K, >1M | |
| Impressions: upper bound | impressions_upper_bound | dim | The number of times the ad created an impression. In ranges of: <1000, 1K-5K, 5K-10K, 10K-50K, 50K-100K, 100K-200K, 200K-500K, >1M | |
| Spend: lower bound | spend_lower_bound | dim | Amount of money spent running the ad. This is reported in ranges: <100, 100-499, 500-999, 1K-5K, 5K-10K, 10K- 50K, 50K-100K, 100K-200K, 200K-500K, >1M | |
| Spend: upper bound | spend_upper_bound | dim | Amount of money spent running the ad. This is reported in ranges: <100, 100-499, 500-999, 1K-5K, 5K-10K, 10K- 50K, 50K-100K, 100K-200K, 200K-500K, >1M |