Index | Category | Electrik.AI Column Name | Description | Sample Value |
1 | Dimension | account_currency | Currency that is used
by your ad account | USD |
2 | Dimension | account_id | The ID number of your
ad account | 4.4177E+14 |
3 | Dimension | account_name | The name of your ad account | iCEDQ |
4 | Dimension | actions | The total number of actions
people took that are
attributed to your ads.
Actions may include
engagement, clicks
or conversions | [action_type:
link_click, value:26],
[action_type:
landing_page_view,
value:3],[action_type
:post_engagement,
value:26],
[action_type:
page_engagement,
value:26] |
5 | Metric | actions_link_click | actions link click | |
6 | Metric | actions_landing_page_view | actions landing page view | |
7 | Metric | actions_post_engagement | actions post engagement | |
8 | Metric | actions_page_engagement | actions page engagement | |
9 | Metric | actions_video_view | actions video view | |
10 | Dimension | ad_id | The Facebook Advertising
assigned unique identifier of
an ad | 2.3844E+16 |
11 | Dimension | ad_name | The ad name | Image Ad |
12 | Dimension | adset_id | The unique ID 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 | 2.3844E+16 |
13 | Dimension | adset_name | The name of the ad set | Drive Traffic |
14 | Dimension | buying_type | Payment method for
and target ads. This
field is currently only
visible at the campaign
level | AUCTION |
15 | Dimension | campaign_id | The Facebook Advertising
assigned identifier of a
campaign | 2.3844E+16 |
16 | Dimension | campaign_name | The campaign name | iCEDQ Branding |
17 | Dimension | canvas_avg_view_percent | canvas avg view percent | |
18 | Dimension | canvas_avg_view_time | canvas avg view time | |
19 | Dimension | clicks | Clicks are what you pay for.
Clicks typically include a
customer clicking an ad on
a search results page or
on a website on the search
network. Clicks can also
come from other sources
(for example, spiders,
robots, and test servers) | 33 |
20 | Dimension | conversion_rate_ranking | conversion rate ranking | ABOVE_AVERAGE |
21 | Dimension | conversion_values | The total value of all
conversions attributed to
your ads | |
22 | Dimension | conversions | The number of conversions.
Conversions are measured
by adding a small bit of code
to your website pages so
that a visitor's progress
through your site can be tracked | |
23 | Dimension | cost_per_action_type | The average cost of a relevant action | [action_type:
link_click, value:0.852692]
,[action_type:
landing_page_view,
value:7.39],
[action_type:
post_engagement,
value:0.852692],
[action_type
:page_engagement,
value:0.852692] |
24 | Metric | cost_per_action_type_
link_click | cost per action type link click | |
25 | Metric | cost_per_action_type_
landing_page_view | cost per action type
landing page view | |
26 | Metric | cost_per_action_type_
post_engagement | cost per action type post
engagement | |
27 | Metric | cost_per_action_type_
page_engagement | cost per action type page
engagement | |
28 | Metric | cost_per_action_
type_video_view | cost per action type video
view | |
29 | Dimension | cost_per_conversion | cost per conversion | |
30 | Dimension | cost_per_estimated_
ad_recallers | cost per estimated ad
recallers | |
31 | Metric | cost_per_inline_
link_click | cost per inline link click | 0.852692 |
32 | Metric | cost_per_inline_
post_engagement | cost per inline
post engagement | 0.852692 |
33 | Metric | cost_per_outbound_click | cost per outbound click | [action_type:
outbound_click,
value:0.852692] |
34 | Metric | cost_per_thruplay | cost per thruplay | [action_type:
video_view, value:
0.252222] |
35 | Dimension | cost_per_unique_action_type | cost per unique action type | [action_type:
link_click,
value:0.852692],
[action_type:
landing_page_view,
value:7.39],
[action_type:
post_engagement,
value:0.852692],
[action_type:
page_engagement,
value:0.852692] |
36 | Metric | cost_per_unique_action_
type_link_click | cost per unique action
type link click | |
37 | Metric | cost_per_unique_action_
type_video_view | cost per unique action
type video view | |
38 | Metric | cost_per_unique_action_
type_post_engagement | cost per unique action
type post engagement | |
39 | Metric | cost_per_unique_action_
type_page_engagement | cost per unique action
type page engagement | |
40 | Metric | cost_per_unique_action_
type_landing_page_view | cost per unique action
type landing page view | |
41 | Metric | cost_per_unique_click | cost per unique click | 0.671818 |
42 | Metric | cost_per_unique_
inline_link_click | cost per unique
inline link click | 0.852692 |
43 | Metric | cost_per_unique_
outbound_click | cost per unique
outbound click | [action_type:
outbound_click,
value:0.8868] |
44 | Metric | cpc | The average cost
for each click (all) | 0.671818 |
45 | Metric | cpm | The average cost
for 1,000 impressions | 7.089862 |
46 | Metric | cpp | The average cost
to reach 1,000 people | 7.858915 |
47 | Metric | ctr | The click-through rate
(CTR) is the number of times
an ad was clicked, divided by
the number of times the ad
was shown (impressions). The
formula for calculating CTR
is (Clicks / Impressions) x
100 | 1.055325 |
48 | | date_start | The start date for your data | 9/6/2019 |
49 | | date_stop | The end date for your data | 9/6/2019 |
50 | Dimension | engagement_rate_ranking | engagement rate ranking | BELOW_
AVERAGE_35 |
51 | Dimension | estimated_ad_recall_rate | estimated ad recall rate | |
52 | Dimension | estimated_ad_recallers | estimated ad recallers | |
53 | Metric | frequency | The average number of
times each person saw your ad | 1.108472 |
54 | Dimension | full_view_impressions | The number of Full Views
on your Page's posts as a
result of your ad | |
55 | Dimension | full_view_reach | The number of people
who performed a Full View
on your Page's post as a
result of your ad | |
56 | Metric | impressions | The number of times
your ads were on screen | 3127 |
57 | Metric | inline_link_click_ctr | The percentage of time
people saw your ads and
performed an inline link
click | 0.831468 |
58 | Metric | inline_link_clicks | The number of clicks on
links to select destinations
or experiences, on or off
Facebook-owned properties.
Inline link clicks use a
fixed 1-day-click
attribution window | 26 |
59 | Metric | inline_post_engagement | The total number of
actions that people take
involving your ads. Inline
post engagements use a
fixed 1-day-click attribution
window | 26 |
60 | Metric | instant_experience_
clicks_to_open | instant experience
clicks to open | 0 |
61 | Metric | instant_experience_
clicks_to_start | instant experience
clicks to start | 0 |
62 | Metric | instant_experience_
outbound_clicks | instant experience
outbound clicks | 0 |
63 | Dimension | mobile_app_
purchase_roas | mobile app purchase roas | |
64 | Dimension | objective | The objective reflecting
the goal you want to achieve
with your advertising. It may
be different from the selected
objective of the campaign in
some cases | LINK_CLICKS |
65 | Metric | outbound_clicks | The number of clicks on
links that take people off
Facebook-owned properties | [action_type:
outbound_click,
value:26] |
66 | Metric | outbound_clicks_ctr | The percentage of times
people saw your ad and
performed an outbound click | [action_type:
outbound_click,
value:0.831468] |
67 | Dimension | purchase_roas | The total return on ad
spend (ROAS) from
purchases. This is based on
information received from
one or more of your
connected Facebook
Business Tools and
attributed to your ads | |
68 | Dimension | quality_ranking | quality ranking | BELOW_
AVERAGE_20 |
69 | Dimension | reach | The number of people who
saw your ads at least once.
Reach is different from
impressions, which may
include multiple views of
your ads by the same people | 2821 |
70 | Dimension | relevance_score | Your relevance score
estimates how well your ad
is resonating with the people
you want to reach. The
higher your ad's relevance
score, the better it's
considered to be performing | [score:4, status:OK] |
71 | Metric | social_spend | The total amount you've
spent so far for your ads
showed with social information | 0 |
72 | Metric | spend | The estimated total
amount of money you've
spent on your campaign,
ad set or ad during its
schedule | 22.17 |
73 | Dimension | unique_actions | The number of people
who took an action that
was attributed to your ads | [action_type:
link_click,value:26],
[action_type:
landing_page_view,
value:3],[action_type:
post_engagement,
value:26],
[action_type:
page_engagement,
value:26] |
74 | Metric | unique_actions_link_click | unique actions link click | 26 |
75 | Metric | unique_actions_
landing_page_view | unique actions
landing page view | 3 |
76 | Metric | unique_actions_
post_engagement | unique actions
post engagement | 26 |
77 | Metric | unique_actions_
page_engagement | unique actions
page engagement | 26 |
78 | Metric | unique_actions_
video_view | unique actions video view | |
79 | Metric | unique_clicks | The number of people
who performed a click (all) | 33 |
80 | Metric | unique_ctr | The percentage of
people who saw your ad
and performed a unique click (all) | 1.169798 |
81 | Metric | unique_inline_link_click_ctr | The percentage of times
people saw your ad and
performed a link click.
Inline click-through
rate uses a fixed
1-day-click attribution
window | 0.921659 |
82 | Metric | unique_inline_link_clicks | The number of people who
performed an inline link click | 26 |
83 | Metric | unique_link_clicks_ctr | The percentage of people
who saw your ad and
performed a link click | 0.921659 |
84 | Metric | unique_outbound_clicks | The number of people who
performed an outbound click | [action_type:
outbound_click,
value:25] |
85 | Metric | unique_outbound_clicks_ctr | The percentage of people
who saw your ad and
performed an outbound click | [action_type:
outbound_click,
value:0.886211] |
86 | Metric | video_30_sec_watched_actions | The number of times your
video played for at least 30
seconds, or for nearly its
total length(if shorter than
30 seconds) | [action_type:
video_view,
value:12] |
87 | Metric | video_avg_time_watched_actions | The average time a video
was played, including any
time spent replaying the
video for a single
impression | [action_type:
video_view,
value:12] |
88 | Metric | video_p100_watched_actions | The number of times your
video was played at 100% of
its length, including plays
that skipped to this point | [action_type:
video_view, value:12] |
89 | Metric | video_p25_watched_actions | The number of times your
video was played at 25% of
its length, including plays
that skipped to this point | [action_type:
video_view, value:12] |
90 | Metric | video_p50_watched_actions | The number of times your
video was played at 50% of
its length, including plays
that skipped to this point | [action_type:
video_view, value:12] |
91 | Metric | video_p75_watched_actions | The number of times your
video was played at 75% of
its length, including plays
that skipped to this point | [action_type:
video_view, value:12] |
92 | Metric | video_play_actions | The number of times your
video starts to play per
impression of a video | [action_type:
video_view, value:12] |
93 | Dimension | video_play_curve_actions | A video-play based curve
graph that illustrates the
percentage of video plays
that reached a given second | [action_type:
video_view, value:
[100, 38, 11, 7,
5, 4, 2, 2, 2, 2,
1, 1, 1, 1, 1, 1,
1, 0, 0, 0, 0, 0]] |
94 | Dimension | video_thruplay_
watched_actions | video thruplay
watched actions | |
95 | Metric | website_ctr | The percentage of times
people saw your ad and
performed a link click | [action_type:
link_click, value:
0.831468] |
96 | Dimension | website_purchase_roas | The total return on ad spend
(ROAS) from website
purchases. The value of all
conversions recorded by the
Facebook pixel on your
website and attributed
to your ads | |
97 | Electrik.AI | snapshot_dt | Date on which the data
is captured | 9/6/2019 |
98 | Electrik.AI | etl_org | Organization Id | torana_2 |
99 | Electrik.AI | etl_project | Project Id | test_i_2 |
100 | Electrik.AI | etl_create_utc_dttm | Record loaded/created
Timestamp in UTC | 08:02.6 |
101 | Electrik.AI | etl_update_utc_dttm | Record Update
Timestamp in UTC | 08:02.6 |
102 | Electrik.AI | etl_start_utc_dttm | EAI Flow Start
Timestamp in UTC | 45:06.5 |
103 | Electrik.AI | etl_flow_nm | EAI Flow Code | AD_INSIGHT |
104 | Electrik.AI | etl_flow_instance_id | EAI Flow Execution
Instance Id | FL00AD-2019091
0144445424196 |