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

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.