Facebook Ads Raw Data Guide
This guide shows you how to use the raw data coming from this specific data source APIs, so we can support you achieve your reporting needs. In this guide, some recommendations are provided as well as examples of use cases for the most commonly used fields. If you’d like to dig deeper into the raw data from each API, we recommend you to refer to our integrations documentation which provides links to each API documentation. For more guidance on how to build your reports and BI metrics, please inquire us about the Beginners Journey, Data Modelling Guide, Marketing Attribution and/or BI Metrics Guide.
Note: There may be several ways to achieve the use cases that has been indicated below, but these columns are the ones commonly used for most of the use cases we've encountered.
Most Used Tables
|
Table Name |
Description |
|
ads_insights |
Provides insights on your advertising performance. Allows for deduped metrics across child objects, sorting of metrics, and async reporting. |
|
ad_creative |
Format which provides layout and contains content for the ad. To see available ad creatives, visit Ads Guide. The guide also contains information on size requirements for each ad unit. |
Most Used Fields
|
Column Name |
Description |
Use Cases |
Table Name |
|
account_name |
The name of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing. |
to breakdown your ads metrics by the advertising accounts |
ads_insights |
|
ad_name |
The name of the ad you're viewing in reporting. |
Use for breaking down your ads metrics by the ad |
ads_insights |
|
ad_id |
The unique ID of the ad you're viewing in reporting. |
Use for breaking down your ads metrics by the ad |
ads_insights |
|
adset_name |
The name of the ad set you're viewing in reporting. An ad set is a group of ads that share the same budget, schedule, delivery optimization and targeting. |
Use for breaking down your ads metrics by the adgroup |
ads_insights |
|
campaign_id |
The unique ID number of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads |
Use for breaking down your ads metrics by campaign |
ads_insights |
|
campaign_name |
The name of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads |
Use for breaking down your ads metrics by campaign |
ads_insights |
|
clicks |
The number of clicks on your ads. |
Measure the amount of clicks generated by a specific ad, adgroup or campaign |
ads_insights |
|
spend |
The estimated total amount of money you've spent on your campaign, ad set or ad during its schedule. This metric is estimated. |
Measure the amount you spent on advertising, for calculating ROAS, etc. |
ads_insights |
|
date_start |
The start date for your data. This is controlled by the date range you've selected for your reporting view. |
For analyzing ad performance overtime, grouping by metrics by time frames, or joining on sales data for a daily summary analysis and other advanced analysis. |
ads_insights |
|
impressions |
The number of times your ads were on screen |
It can be used for calculating the CTR, among other conversion rates. |
ads_insights |