Facebook Ads Data Model
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
4
Last Updated:3/16/17
5
Title:
Expected Facebook Ads Data Model
6
Blendo (Apirise Inc.)
https://www.blendo.co/knowledge-category/integrations/
7
8
ResourceTable NameDescription
9
CampaignscampaignsThe table contains information about your Campaigns. A campaign is a grouping of ad sets which are organized by the same business objective. Each campaign has an objective that must be valid across the ad sets within that campaign.
10
AdSetadsetsAn ad set is a group of ads that share the same daily or lifetime budget, schedule, bid type, bid info, and targeting data. Ad sets enable you to group ads according to your criteria, and you can retrieve the ad-related statistics that apply to a set.
11
AdsadsAn ad object contains the data necessary to visually display an ad and associate it with a corresponding ad set. Each ad is associated with an ad set and all ads in a set have the same daily or lifetime budget, schedule, and targeting. Creating multiple ads in each ad set will let us optimize their delivery based on variations in images, links, video, text or placements.
12
Ad Insightsad_insightsInsights provide a single, consistent interface to retrieve an ad's statistics.
13
Account Insightsaccount_insightsAggregated insights for the whole account.
14
Ad Insights Unique Actionsinsights_unique_actionsThe number of people who took an action that was attributed to your ads.
15
Ad Insights Actionsinsights_actionsThe average cost of each unique action.
16
Ad Insights Action valuesinsights_action_valuesThe total value of all conversions attributed to your ads.
17
Account Insights Unique Actionsaccount_insights_unique_actionsThe number of people who took an action that was attributed to your ads. Aggregated over your account. For details on this table check insights_unique_actions
18
Account Insights Actionsaccount_insights_actionsThe average cost of each unique action. Aggregated over your account.for details on this table check insights_actions
19
Account Insights Action valuesaccount_insights_action_valuesThe total value of all conversions attributed to your ads.Aggregated over your account. For details on this table check insights_action_values
20
Ad Conversion Specsad_conversion_specsThis is a derivative table that complements the ads table. It holds information related to conversions.
21
Ad Insights (Age/Gender)ad_age_genderThis table contains the Ad Insights aggregated per age and per gender. It contains the same information as ad_insights with the addition of an age and gender column.
22
Ad Insights (Country)ad_countryThis table contains the ad Insights aggregated per country. It contains the same information as ad_insights with the addition of a column named "country".
23
Ad Insights (Placement/Device)ad_placement_deviceThis table contains the ad Insights aggregated per country. It contains the same information as ad_insights with the addition of a column named "placement" and a column named "device".
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu