Facebook Ads Insights Data Export

What is Facebook Ads Insights?

Facebook Ads is an online advertising platform developed by Facebook, where advertisers pay to display ads based on the keywords used in a user’s search query.

Facebook Ads report give you post-click performance metrics for users who clicked on your Facebook Ads and then came to your website, or installed and started using your mobile app.

How to add a Facebook Ads Source in Electrik.AI?

Follow these steps to connect your Facebook Ads account to Electrik.AI

Step 1: Ensure you have following prerequisites to create a Facebook Ads Connection in Electrik.AI

a. Facebook Ads Account User Id and Password.

b. Access to Facebook Ads.

Step 2: Sign-in into your Electrik.AI account

Step 3: Select IO in Electrik.AI dashboard

Select IO in Electrik.AI dashboard

Step 4: Select the Connections tab in the left most navigation bar & click on “Add” action button.

Select-the-Connections-tab-in-the-left-most-navigation-bar-click-on-Add-action-

Step 5: The Source default tab is selected just click on “Facebook Ads Insights” connection.

Step 6 The Source default tab is selected just click on “FBAds” connection-ElectrikAI

Step 6: Provide your Facebook Ads account User Id and Password.

Step 7 Provide your Facebook Ads account User Id and Password-ElectrikAI

Step 7: Allow Electrik.AI to access your Facebook Ads account.

Step 8 Allow access your Facebook Ads account-ElectrikAI

Step 8: Select the Ads Account from the dropdown whose data you wish to export.

Step 9 Select the Ads Account from the dropdown-ElectrikAI

Step 9: Click on Save button on the top.

Step 10 Click on Save button on the top-ElectrikAI

Congratulations, you have successfully created a Facebook Ads Connection in Electrik.AI.

Congratulations, you have successfully created a Facebook Ads Connection-ElectrikAI

What are the supported Data Destinations?

Electrik.AI supports the following databases to export Facebook Ads Data. It is important to note that Electrik.AI itself is not a destination. A destination is required to export data from various marketing data sources using Electrik.AI

PostgreSQL Data Destination-Eletrik.AI
MySQL Data Destination-Electrik.AI
AzureSQL Data Destination-Eletrik.AI
Google Big Query Data Destination-Elecrik.AI

How to export Facebook Ads Data ?

Electrik.AI creates a data flow (or ETL process) that exports Facebook Ads data to a target database or data warehouse. This process runs daily at scheduled time and exports data for the previous day.

Follow these steps to create a Data Flow from Facebook Ads to Database

Step 1: Ensure you have the following prerequisites.

1. Access to Facebook Ads.

2. Facebook Ads Account User Id and Password.

3. Access to a Database of your choice (PostgreSQL, MySQL, Azure SQL, BigQuery.)

4. Database Connection Details such as Host, Port, DB Name, DB User, DB Password.

Step 2: Sign-in into your Electrik.AI account.

Step 3: Select IO in Electrik.AI dashboard.

Select IO in Electrik.AI dashboard-ElectrikAI

Step 4: Click on Add button to create a Facebook Ads – Facebook Ads Performance Data Extractor Flow.

Step 5: Select Facebook Ads Connection present in the list of available sources.

Flow Step 5 Select Facebook Ads Connection-ElectrikAI

Step 6: Select your existing Facebook Ads connection in Electrik.AI.

Step 6 Select your existing Facebook Ads connection in ElectrikAI

To Configure a new connection, refer to this link.

Step 7: Click on a database of your choice from list of available destinations.
In this example we are choosing My SQL. 

Step 7 select destination mysql-ElectrikAI

Step 8: Select your existing MySQL connection in Electrik.AI.
To Configure a new connection, refer to this link.

Step 8 Select existing mysql-ElectrikAI

Step 9: a. Electrik.AI now supports 4 reports, choose the desired type to get the appropriate data. In this example we are choosing Campaign Insights.

Electrik.AI now supports 4 reports

b. Review the Data Source, Data Destination, Database Schema, Report Name, Provide Success Notification Email, Failure Notification Email.

Success Notification Email: Enter a valid Email ID to receive the Flow Success Email Notification.
Failure Notification Email: Enter a valid Email ID to receive the Flow Failure Email Notification.
Note: By Default, Electrik.AI uses the signed-in user’s Email Id.

c. Click “Save and Proceed” to continue.

Step 9 Review the Data Source-ElectrikAI

Note: By Default, Electrik.AI chooses an existing Database Schema to load your Facebook Ads Report. You can create a new schema in your database by selecting the “Create New Schema” radio button.

Step 10: Congratulations, Flow is created. Please wait while you are redirected to Flow Details Screen.

Step 10 Congratulations, Flow is created-ElectrikAI

You have now successfully setup Facebook Ads Performance Report to MySQL Database flow in Electrik.AI

You have now successfully setup Facebook Ads Performance Report to MySQL Database flow in Electrik.AI

Your Facebook Ads data will start loading after 24 hours in your Database.

Facebook Ads data will start loading after 24 hours-ElectrikAI

Facebook Ads Data Schema

The Ad Insights report includes all statistics aggregated at the ad level.
IndexCategoryElectrik.AI Column NameDescriptionSample Value
1Dimensionaccount_currencyCurrency that is used by your ad account.USD
2Dimensionaccount_idThe ID number of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing.441760000000000
3Dimensionaccount_nameThe name of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing.Electrik.AI
4Metricsaction_valuesThe total value of all conversions attributed to your ads. 
5MetricsactionsThe 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]
6Metricsactions_link_clickactions_link_click11
7Metricsactions_landing _page_viewactions_ landing_page _view4
8Metricsactions_post_ engagementactions_post_ engagement150
9Metricsactions_page_ engagementactions_page _engagement150
10Metricsactions_video _viewactions_video _view139
11Metricsad_click_actionsad_click_actions 
12Dimensionad_idThe unique ID of the ad you're viewing in reporting.23845273720540100
13Metricsad_impression _actionsad_impression _actions 
14Dimensionad_nameThe name of the ad you're viewing in reporting.Video Ad
15Dimensionadset_idThe 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.23845273720 500600
16Dimensionadset_nameThe 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.GA Interest Audience
17Dimensionage_targetingage_targeting 
18Metricsauction_bidauction_bid 
19Metricsauction_ competitivenessauction_ competitiveness 
20Metricsauction_max_ competitor_bidauction_max_ competitor_bid 
21Dimensionbuying_typeThe method by which you pay for and target ads in your campaigns: through dynamic auction bidding, fixed-price bidding, or reach and frequency buying. This field is currently only visible at the campaign level.AUCTION
22Dimensioncampaign_idThe unique ID number of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads.23885273720480700
23Dimensioncampaign_nameThe name of the ad campaign #you're viewing in reporting. Your campaign contains ad sets and ads.Evergreen_EAI_ BrandAwareness
24Metricscanvas_avg_view _percentThe average percentage of the Instant Experience that people saw. An Instant Experience is a screen that opens after someone interacts with your ad on a mobile device. It may include a series of interactive or multimedia components, including video, images product catalog and more. 
25Metricscanvas_avg_ view_timeThe average total time, in seconds, that people spent viewing an Instant Experience.An Instant Experience is a screen that opens after someone interacts with your ad on a mobile device. It may include a series of interactive or multimedia components, including video, images product catalog and more. 
26Metricscatalog_segment _actionsThe number of actions performed attributed to your ads promoting your catalog segment, broken down by action type. 
27Metricscatalog_segment _valueThe total value of all conversions from your catalog segment attributed to your ads. 
28Metricscatalog_segment_ value_mobile_purchase_ roasThe total return on ad spend (ROAS) from mobile app purchases for your catalog segment. 
29Metricscatalog_segment_ value_omni_purchase _roasThe total return on ad spend (ROAS) from all purchases for your catalog segment. 
30Metricscatalog_segment_ value_website_purchase _roasThe total return on ad spend (ROAS) from website purchases for your catalog segment. 
31MetricsclicksThe number of clicks on your ads.11
32Metricsconversion_ valuesconversion_ values 
33Metricsconversionsconversions 
34Metricsconverted_product _quantityThe number of products purchased which are recorded by your merchant partner's pixel or app SDK for a given product ID and driven by your ads. Has to be used together with converted product ID breakdown. 
35Metricsconverted_product _valueThe value of purchases recorded by your merchant partner's pixel or app SDK for a given product ID and driven by your ads. Has to be used together with converted product ID breakdown. 
36Metricscost_per_15_sec_ video_viewcost_per_15_sec _video_view0.038
37Metricscost_per_2_sec_ continuous_video_viewcost_per_2_sec_ continuous_video_view 
38Metrics cost_per_action _typeThe average cost of a relevant action.[action_type: landing_page_view, value:1.14],[action _type:video_view, value:0.032806], [action_type:link _click, value:0.414545], [action_type: post_engagement, value:0.0304], [action_type: page_engagement, value:0.0304]
39Metricscost_per _action_type_ link_clickcost_per_action_ type_link_click0.414545
40Metricscost_per_ action_type_landing _page_viewcost_per_ action_type_ landing_page _view1.14
41Metricscost_per_ action_type _post_ engagementcost_per_ action_type _post_engagement0.0304
42Metricscost_per_ action_type _page_engagementcost_per_ action_type _page_engagement0.0304
43Metricscost_per_ action_type_ video_viewcost_per_ action_type_ video_view0.032806
44Metricscost_per_ad _clickcost_per_ad _click 
45Metricscost_per_ conversioncost_per_ conversion 
46Metricscost_per_dda_ countby_convscost_per_dda_ countby_convs 
47Metricscost_per_inline _link_clickThe average cost of each inline link click.0.414545
48Metricscost_per_inline_ post_engagementThe average cost of each inline post engagement.0.414545
49Metricscost_per_one_ thousand_ad_ impressioncost_per_one_ thousand_ad_ impression 
50Metricscost_per_ outbound_clickThe average cost for each outbound click.0.414545
51Metricscost_per_ store_visit _actioncost_per _store_visit_ action 
52Metricscost_per_ thruplayThe average cost for each ThruPlay. This metric is in development.0.038
53Metricscost_per_ unique_action_ typeThe average cost of each unique action. This metric is estimated.[action_type: landing_page_view, value:1.14], [action_type:video_view, value:0.035077], [action_type:link_click, value:0.414545], [action_type:post _engagement, value:0.034286], [action_type:page _engagement, value:0.034286]
54Metricscost_per_unique_ action_type_link _clickcost_per _unique_ action_type _link_click0.414545
55Metricscost_per_unique_ action_type _video_viewcost_per_unique_ action_type _video_view0.035077
56Metricscost_per _unique_ action_type _post_engagementcost_per_unique_ action_type _post_engagement0.034286
57Metricscost_per_unique_ action_type _page_engagementcost_per_unique_ action_type _page_engagement0.034286
58Metricscost_per_ unique_action_ type_landing_ page_viewcost_per _unique_action_type_ landing_page _view1.14
59Metricscost_per _unique_clickThe average cost for each unique click (all). This metric is estimated.0.414545
60Metricscost_per_ unique_inline_ link_clickThe average cost of each unique inline link click. This metric is estimated.0.414545
61Metricscost_per_ unique_outbound _clickThe average cost for each unique outbound click. This metric is estimated.0.414545
62MetricscpcThe average cost for each click (all).0.414545
63MetricscpmThe average cost for 1,000 impressions.8.39779
64MetricscppThe average cost to reach 1,000 people. This metric is estimated.9.519833
65Dimensioncreated_timecreated_time29-07-2020
66MetricsctrThe percentage of times people saw your ad and performed a click (all). 2.025783
67Dimensiondate_startThe start date for your data. This is controlled by the date range you've selected for your reporting view. 2020-08-01
68Dimensiondate_stopThe end date for your data. This is controlled by the date range you've selected for your reporting view.2020-08-01
69Metricsdda_countby _convsdda_countby _convs 
70Metricsestimated_ad_ recall_rate_lower_ boundestimated_ad_ recall_rate_lower_ bound 
71Metricsestimated_ad_ recall_rate_upper_ boundestimated_ad_ recall_rate_upper_ bound 
72Metricsestimated_ad_ recallers_lower_ boundestimated_ad_ recallers_lower_ bound 
73Metricsestimated_ad_ recallers_upper_ boundestimated_ad_ recallers_upper_ bound 
74MetricsfrequencyThe average number of times each person saw your ad. This metric is estimated.1.133612
75Metricsfull_view_ impressionsThe number of Full Views on your Page's posts as a result of your ad. 
76Metricsfull_view_ reachThe number of people who performed a Full View on your Page's post as a result of your ad. 
77Dimensiongender_targetinggender_targeting 
78MetricsimpressionsThe number of times your ads were on screen.543
79Metricsinline_link_ click_ctrThe percentage of time people saw your ads and performed an inline link click.2.025783
80Metricsinline_link_ clicksThe 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.11
81Metricsinline_post_ engagementThe total number of actions that people take involving your ads. Inline post engagements use a fixed 1-day-click attribution window.11
82Metricsinstant_experience _clicks_to_openinstant_experience _clicks_to_open 
83Metricsinstant_experience _clicks_to_startinstant_experience _clicks_to_start 
84Metricsinstant_experience _outbound_clicksinstant_experience _outbound_clicks 
85Metricsinteractive_ component_tapinteractive_ component_tap 
86Dimensionlabelslabels 
87Dimensionlocationlocation 
88Metricsmobile_app_ purchase_roasThe total return on ad spend (ROAS) from mobile app purchases. This is based on the value that you assigned when you set up the app event. 
89DimensionobjectiveThe 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
90Metricsoutbound_clicksThe number of clicks on links that take people off Facebook-owned properties.11
91Metricsoutbound_clicks_ ctrThe percentage of times people saw your ad and performed an outbound click.2.025783
92Metricspurchase_roasThe 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. 
93Metricsqualifying_question_ qualify_answer_ratequalifying_ question_qualify_ answer_rate 
94MetricsreachThe 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. This metric is estimated.479
95Metricssocial_spendThe total amount you've spent so far for your ads showed with social information. (ex: Jane Doe likes this). 
96MetricsspendThe estimated total amount of money you've spent on your campaign, ad set or ad during its schedule. This metric is estimated.4.56
97Metricsstore_visit_ actionsstore_visit_ actions[action_type: store_visit, value:0]
98Metricsunique_actionsThe number of people who took an action that was attributed to your ads. This metric is estimated.[action_type: landing_page_view, value:4],[action_ type:video_view, value:130], [action_type:link_click, value:11], [action_type:post_ engagement, value:133], [action_type:page_ engagement, value:133]
99Metricsunique_actions_ link_clickunique_actions _link_click11
100Metricsunique_actions_ landing_page_viewunique_actions _landing_page_view4
101Metricsunique_actions_ post_engagementunique_actions_ post_engagement133
102Metricsunique_actions_ page_engagementunique_actions_ page_engagement133
103Metricsunique_actions_ video_viewunique_actions_ video_view130
104Metricsunique_clicksThe number of people who performed a click (all). This metric is estimated.11
105Metricsunique_ctrThe percentage of people who saw your ad and performed a unique click (all). This metric is estimated.2.296451
106Metricsunique_inline_link_ click_ctrThe percentage of times people saw your ad and performed a link click. Inline click-through rate uses a fixed 1-day-click attribution window. This metric is estimated.2.296451
107Metricsunique_inline_ link_clicksThe number of people who performed an inline link click. This metric is estimated.11
108Metricsunique_link_ clicks_ctrThe percentage of people who saw your ad and performed a link click. This metric is estimated.2.296451
109Metricsunique_outbound _clicksThe number of people who performed an outbound click. This metric is estimated.11
110Metricsunique_outbound_ clicks_ctrThe percentage of people who saw your ad and performed an outbound click. This metric is estimated.2.296451
111Metricsunique_video_view _15_secunique_video_view _15_sec111
112Dimensionupdated_timeupdated_time03-08-2020
113Metricsvideo_15_sec_ watched_actionsvideo_15_sec_ watched_actions120
114Metricsvideo_30_sec_ watched_actionsThe number of times your video played for at least 30 seconds,or for nearly its total length if it's shorter than 30 seconds.For each impression of a video, we'll count video views separately and exclude any time spent replaying the video.117
115Metricsvideo_avg_time_ watched_actionsThe average time a video was played, including any time spent replaying the video for a single impression.2
116Metricsvideo_continuous_2_ sec_watched_actionsvideo_continuous_2_ sec_watched_actions 
117Metricsvideo_p100_ watched_actionsThe number of times your video was played at 100% of its length, including plays that skipped to this point.116
118Metricsvideo_p25_ watched_actionsThe number of times your video was played at 25% of its length, including plays that skipped to this point.151
119Metricsvideo_p50_ watched_actionsThe number of times your video was played at 50% of its length, including plays that skipped to this point.129
120Metricsvideo_p75_ watched_actionsThe number of times your video was played at 75% of its length, including plays that skipped to this point.121
121Metricsvideo_p95_ watched_actionsThe number of times your video was played at 95% of its length, including plays that skipped to this point.118
122Metricsvideo_play_ actionsThe number of times your video starts to play. This is counted for each impression of a video and excludes replays. This metric is in development.398
123Metricsvideo_play_ curve_actionsA video-play based curve graph that illustrates the percentage of video plays that reached a given second. Entries 0 to 14 represent seconds 0 thru 14. Entries 15 to 17 represent second ranges [15 to 20), [20 to 25), and [25 to 30). Entries 18 to 20 represent second ranges [30 to 40), [40 to 50), and [50 to 60). Entry 21 represents plays over 60 seconds.[100, 54, 39, 35, 34, 32, 31, 2, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0]
124Metricsvideo_play_ retention_0_to_15s_ actionsvideo_play_ retention_0_to_ 15s_actions 
125Metricsvideo_play_ retention_20_to_ 60s_actionsvideo_play_ retention_20_to_ 60s_actions 
126Metricsvideo_play_ retention_graph_ actionsvideo_play_ retention_graph_ actions 
127Metricsvideo_time_ watched_actionsvideo_time_ watched_actions 
128Metricswebsite_ctrThe percentage of times people saw your ad and performed a link click.2.025783
129Metricswebsite_purchase _roasThe total return on ad spend (ROAS) from website purchases. This is based on the value of all conversions recorded by the Facebook pixel on your website and attributed to your ads. 
130Metricswish_bidwish_bid 
131Electrik.AIsha_idHashed primary key4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
132Electrik.AIsnapshot_dtDate on which the data is captured2019-06-09  
133Electrik.AIetl_orgOrganization IdElectrik AI
134Electrik.AIetl_projectProject IdPR000333
135Electrik.AIetl_create_utc_ dttmRecord loaded/created Timestamp in UTC27-10-2020 22:49
136Electrik.AIetl_update_utc_ dttmRecord Update Timestamp in UTC27-10-2020 22:49
137Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC27-10-2020 22:28
138Electrik.AIetl_flow_nmEAI Flow CodeAD_INSIGHT
139Electrik.AIetl_flow_ instance_idEAI Flow Execution Instance IdFL00AD-201909101 44445424196
The Ad Insights report includes all statistics aggregated at the ad level.
IndexCategoryElectrik.AI Column NameDescriptionSample Value
1Dimensionaccount_currencyCurrency that is used by your ad account.USD
2Dimensionaccount_idThe ID number of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing.1207858389393050
3Dimensionaccount_nameThe name of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing.Electrik.AI
4Metricsaction_valuesThe total value of all conversions attributed to your ads.
5MetricsactionsThe total number of actions people took that are attributed to your ads. Actions may include engagement, clicks or conversions.[action_type: video_view, value:139], [action_type: link_click, value:11], [action_type: landing_page _view, value:4] ,[action_ type:post_ engagement, value:150], [action_ type:page_ engagement, value:150]
6Metricsactions_link_ clickactions_ link_click11
7Metricsactions_ post_engagementactions_ post_engagement150
8Metricsactions_ page_engagementactions_ page_engagement150
9Metricsactions_ video_viewactions_ video_view139
10Metricsactions_ landing_page_viewactions_ landing_page_view4
11Metricsad_click_ actionsad_click_ actions
12Dimensionad_idThe unique ID of the ad you're viewing in reporting.
13Metricsad_impression_ actionsad_impression_ actions
14Dimensionad_nameThe name of the ad you're viewing in reporting.
15Dimensionadset_idThe 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.23845273720 500700
16Dimensionadset_nameThe 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.GA Interest Audience
17Dimensionage_targetingage_targeting
18Dimensionbuying_typeThe method by which you pay for and target ads in your campaigns: through dynamic auction bidding, fixed-price bidding, or reach and frequency buying. This field is currently only visible at the campaign level.AUCTION
19Dimensioncampaign_idThe unique ID number of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads.2384527372 0480700
20Dimensioncampaign_nameThe name of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads.Evergreen_EAI_ BrandAwareness
21Metricscanvas_avg_ view_percentThe average percentage of the Instant Experience that people saw. An Instant Experience is a screen that opens after someone interacts with your ad on a mobile device. It may include a series of interactive or multimedia components, including video, images product catalog and more.
22Metricscanvas_avg_ view_timeThe average total time, in seconds, that people spent viewing an Instant Experience. An Instant Experience is a screen that opens after someone interacts with your ad on a mobile device. It may include a series of interactive or multimedia components, including video, images product catalog and more.
23Metricscatalog_ segment_actionsThe number of actions performed attributed to your ads promoting your catalog segment, broken down by action type.
24Metricscatalog_ segment_valueThe total value of all conversions from your catalog segment attributed to your ads.
25Metricscatalog_segment_ value_mobile_ purchase_roasThe total return on ad spend  (ROAS) from mobile app purchases for your catalog segment.
26Metricscatalog_ segment_value _omni_purchase _roasThe total return on ad  spend (ROAS) from all purchases for your catalog segment.
27Metricscatalog_segment _value_website_ purchase_roasThe total return on ad  spend (ROAS) from website purchases for your catalog segment.
28MetricsclicksThe number of clicks on your ads.11
29Metricsconversion_ valuesconversion_ values
30Metricsconversionsconversions
31Metricsconverted_ product_quantityThe number of products purchased which are recorded by your merchant partner's pixel or app SDK for a given product ID and driven by your ads. Has to be used together with converted product ID breakdown.
32Metricsconverted_product_ valueThe value of purchases recorded by your merchant partner's pixel or app SDK for a given product ID and driven by your ads. Has to be used together with converted product ID breakdown.
33Metricscost_per_15 _sec_video_viewcost_per_15 _sec_video_view0.038
34Metricscost_per_2_sec_ continuous_video_ viewcost_per _2_sec_continuous _video_view
35Metricscost_per_ action_typeThe average cost of a relevant action.[action_type: video_view, value: 0.032806],[action_ type:link_click, value:0.414545], [action_type: landing_page_ view, value: 1.14],[action_ type:post_ engagement, value:0.0304], [action_type: page_engagement, value:0.0304]
36Metricscost_per_ action_type_ link_clickcost_per_ action_type_link _click0.414545
37Metricscost_per_ action_type _landing_page _viewcost_per _action_type _landing_page _view1.14
38Metricscost_per _action_type_ post_engagementcost_per_ action_type_ post_engagement0.0304
39Metricscost_per _action_type_ page_engagementcost_per_ action_type_page_ engagement0.0304
40Metricscost_per_action_ type_video_viewcost_per_action_ type_video_view0.032806
41Metricscost_per_ad_ clickcost_per_ad_ click
42Metricscost_per_ conversioncost_per_ conversion
43Metricscost_per_dda_ countby_convscost_per_dda_ countby_convs
44Metricscost_per_inline_ link_clickThe average cost of each inline link click.0.414545
45Metricscost_per_inline_ post_engagementThe average cost of each inline post engagement.0.414545
46Metricscost_per_one_ thousand_ad_ impressioncost_per_one_ thousand_ad_ impression
47Metricscost_per_outbound _clickThe average cost for each outbound click.0.414545
48Metricscost_per_store_ visit_actioncost_per_store_ visit_action
49Metricscost_per_ thruplayThe average cost for each ThruPlay. This metric is in development.0.038
50Metricscost_per_unique_ action_typeThe average cost of each unique action. This metric is estimated.[action_ type:video_view, value:0.035077] ,[action_type: link_click, value:0.414545], [action_type: landing_page_view, value:1.14], [action_type:post_ engagement, value:0.034286], [action_type: page_engagement, value:0.034286]
51Metricscost_per_unique_ action_type_ link_clickcost_per _unique_ action_type_ link_click0.414545
52Metricscost_per _unique_ action_type_ landing _page_viewcost_per_ unique_action_ type_video_view1.14
53Metricscost_per_unique_ action_type_ video_viewcost_ per_unique_ action_type_ post_engagement0.035077
54Metricscost_per _unique_action _type_post_ engagementcost_per _unique_action _type_page_ engagement0.034286
55Metricscost_per_ unique_action_ type_page_ engagementcost_per_ unique_action_ type_landing _page_view0.034286
56Metricscost_per_unique _clickThe average cost for each unique click (all). This metric is estimated.0.414545
57Metricscost_per_ unique_inline_ link_clickThe average cost of each unique inline link click. This metric is estimated.0.414545
58Metricscost_per_ unique_outbound_ clickThe average cost for each unique outbound click. This metric is estimated.0.414545
59MetricscpcThe average cost for each click (all).0.414545
60MetricscpmThe average cost for 1,000 impressions.8.39779
61MetricscppThe average cost to reach 1,000 people. This metric is estimated.9.519833
62Dimensioncreated_timecreated_time29-07-2020
63MetricsctrThe percentage of times people saw your ad and performed a click (all).2.025783
64Dimensiondate_startThe start date for your data. This is controlled by the date range you've selected for your reporting view.01-08-2020
65Dimensiondate_stopThe end date for your data. This is controlled by the date range you've selected for your reporting view.01-08-2020
66Metricsdda_countby _convsdda_countby _convs
67Metricsestimated_ad _recall_rate_lower _boundestimated _ad_recall _rate_lower _bound
68Metricsestimated_ad_recall_ rate_upper_boundestimated_ad_recall_ rate_upper_bound
69Metricsestimated_ad_ recallers_lower_boundestimated_ad_ recallers_lower_bound
70Metricsestimated_ad_ recallers_upper_boundestimated_ad_ recallers_upper_bound
71MetricsfrequencyThe average number of times each person saw your ad. This metric is estimated.1.133612
72Metricsfull_view_ impressionsThe number of Full Views on your Page's posts as a result of your ad.
73Metricsfull_view_reachThe number of people who performed a Full View on your Page's post as a result of your ad.
74Dimensiongender_targetinggender_targeting
75MetricsimpressionsThe number of times your ads were on screen.543
76Metricsinline_link_ click_ctrThe percentage of time people saw your ads and performed an inline link click.2.025783
77Metricsinline_link _clicksThe 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.11
78Metricsinline_post_ engagementThe total number of actions that people take involving your ads. Inline post engagements use a fixed 1-day-click attribution window.11
79Metricsinstant_experience _clicks_to_openinstant_experience _clicks_to_open
80Metricsinstant_experience _clicks_to_startinstant_experience _clicks_to_start
81Metricsinstant_experience _outbound_clicksinstant_experience _outbound_clicks
82Metricsinteractive_ component_tapinteractive_ component_tap
83Dimensionlabelslabels
84Dimensionlocationlocation
85Metricsmobile_app_ purchase_roasThe total return on ad spend (ROAS) from mobile app purchases. This is based on the value that you assigned when you set up the app event.
86DimensionobjectiveThe 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
87Metricsoutbound_clicksThe number of clicks on links that take people off Facebook-owned properties.11
88Metricsoutbound_clicks _ctrThe percentage of times people saw your ad and performed an outbound click.2.025783
89Metricspurchase_roasThe 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.
90Metricsqualifying_question _qualify_answer_ratequalifying_question _qualify_answer_rate
91MetricsreachThe 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. This metric is estimated.479
92Metricssocial_spendThe total amount you've spent so far for your ads showed with social information. (ex: Jane Doe likes this).0
93MetricsspendThe estimated total amount of money you've spent on your campaign, ad set or ad during its schedule. This metric is estimated.4.56
94Metricsstore_visit_ actionsstore_visit_ actions[action_type: store_visit, value:0]
95Metricsunique_actionsThe number of people who took an action that was attributed to your ads. This metric is estimated.[action_type: video_view, value: 130],[action_type: link_click, value: 11],[action_type: landing_page_view, value:4],[action_ type:post_engagement, value:133],[action_ type:page_engagement, value:133]
96Metricsunique_actions_ link_clickunique_actions_ link_click11
97Metricsunique_actions_ landing_page_viewunique_actions_ landing_page_view4
98Metricsunique_actions_ post_engagementunique_actions_ post_engagement133
99Metricsunique_actions_ page_engagementunique_actions_ page_engagement133
100Metricsunique_actions_ video_viewunique_actions_ video_view130
101Metricsunique_clicksThe number of people who performed a click (all). This metric is estimated.11
102Metricsunique_ctrThe percentage of people who saw your ad and performed a unique click (all). This metric is estimated.2.296451
103Metricsunique_inline_ link_click_ctrThe percentage of times people saw your ad and performed a link click. Inline click-through rate uses a fixed 1-day -click attribution window. This metric is estimated.2.296451
104Metricsunique_inline_ link_clicksThe number of people who performed an inline link click. This metric is estimated.11
105Metricsunique_link_clicks _ctrThe percentage of people who saw your ad and performed a link click. This metric is estimated.2.296451
106Metricsunique_outbound_ clicksThe number of people who performed an outbound click. This metric is estimated.11
107Metricsunique_outbound _clicks_ctrThe percentage of people who saw your ad and performed an outbound click. This metric is estimated.2.296451
108Metricsunique_video_ view_15_secunique_video_ view_15_sec111
109Metricsupdated_timeupdated_time03-08-2020
110Metricsvideo_15_sec_ watched_actionsvideo_15_sec_ watched_actions120
111Metricsvideo_30_sec_ watched_actionsThe number of times your video played for at least 30 seconds, or for nearly its total length if it's shorter than 30 seconds. For each impression of a video, we'll count video views separately and exclude any time spent replaying the video.117
112Metricsvideo_avg_time_ watched_actionsThe average time a video was played, including any time spent replaying the video for a single impression.2
113Metricsvideo_continuous_2 _sec_watched_actionsvideo_continuous_2_ sec_watched_actions
114Metricsvideo_p100_ watched_actionsThe number of times your video was played at 100% of its length, including plays that skipped to this point.116
115Metricsvideo_p25_ watched_actionsThe number of times your video was played at 25% of its length, including plays that skipped to this point.151
116Metricsvideo_p50_ watched_actionsThe number of times your video was played at 50% of its length, including plays that skipped to this point.129
117Metricsvideo_p75_ watched_actionsThe number of times your video was played at 75% of its length, including plays that skipped to this point.121
118Metricsvideo_p95_ watched_actionsThe number of times your video was played at 95% of its length, including plays that skipped to this point.118
119Metricsvideo_play_actionsThe number of times your video starts to play. This is counted for each impression of a video, and excludes replays. This metric is in development.398
120Metricsvideo_play_ curve_actionsA video-play based curve graph that illustrates the percentage of video plays that reached a given second. Entries 0 to 14 represent seconds 0 thru 14. Entries 15 to 17 represent second ranges [15 to 20), [20 to 25), and [25 to 30). Entries 18 to 20 represent second ranges [30 to 40), [40 to 50), and [50 to 60). Entry 21 represents plays over 60 seconds.
121Metricsvideo_play_retention _0_to_15s_actionsvideo_play_retention _0_to_15s_actions
122Metricsvideo_play_retention _20_to_60s_actionsvideo_play_retention _20_to_60s_actions
123Metricsvideo_play_retention_ graph_actionsvideo_play_retention_ graph_actions
124Metricsvideo_time_ watched_actionsvideo_time_ watched_actions
125Metricswebsite_ctrThe percentage of times people saw your ad and performed a link click.2.025783
126Metricswebsite_purchase_roasThe total return on ad  spend (ROAS) from website purchases. This is based on the value of all conversions recorded by the Facebook pixel on your website and attributed to your ads.
127Electrik.AIsha_idHashed primary key4d7a30ffb7e17809271 acabafbb50c2694c14878f35 2013ca5b0c997a777b454
128Electrik.AIsnapshot_dtDate on which the data is captured2019-06-09
129Electrik.AIetl_orgOrganization IdElectrik AI
130Electrik.AIetl_projectProject IdPR000333
131Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC27-10-2020 22:49
132Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC27-10-2020 22:49
133Electrik.AIetl_start_ utc_dttmEAI Flow Start Timestamp in UTC27-10-2020 22:28
134Electrik.AIetl_flow_nmEAI Flow CodeADSET_ INSIGHT
135Electrik.AIetl_flow_ instance_idEAI Flow Execution Instance IdFL00AD-20190 910144445424196
The Ad Insights report includes all statistics aggregated at the ad level.
IndexCategoryElectrik.AI Column NameDescriptionSample Value
Dimension account_currencyCurrency that is used by your ad account.USD 
Dimension account_id The ID number of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing.120785838 9393050
Dimension account_name The name of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing. Electrik.AI 
Metrics action_values The total value of all conversions attributed to your ads.  
Metrics actions The total number of actions people took that are attributed to your ads. Actions may include engagement, clicks or conversions. [action_type: video_view, value:139], [action_type: link_click, value:11], [action_type: landing_page _view, value:4], [action_type:post_ engagement, value:150], [action_ type:page_ engagement, value:150]
Metrics actions_link _clickactions_ link_click11 
Metrics actions_landing _page_viewactions_landing _page_view
Metrics actions_post_ engagementactions_post_ engagement150 
Metrics actions_page_ engagementactions_page_ engagement150 
10 Metrics actions_video _viewactions_video _view139 
11 Metrics ad_click_ actionsad_click_ actions  
12 Dimension ad_id The unique ID of the ad you're viewing in reporting.  
13 Metrics ad_impression_ actionsad_impression_ actions  
14 Dimension ad_name The name of the ad you're viewing in reporting.  
15 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.   
16 Dimension 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.  
17 Dimension age_targeting age_targeting   
18 Metrics auction_bid auction_bid 
19 Metrics auction_ competitivenessauction_ competitiveness
20 Metrics auction_max_ competitor_bidauction_max_ competitor_bid
21 Dimension buying_type The method by which you pay for and target ads in your campaigns: through dynamic auction bidding, fixed-price bidding, or reach and frequency buying. This field is currently only visible at the campaign level. AUCTION 
22 Dimension campaign_id The unique ID number of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads. 238452737 20480700
23 Dimension campaign_name The name of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads. Evergreen_EAI _BrandAwareness
24 Metrics canvas_avg_ view_percentThe average percentage of the Instant Experience that people saw. An Instant Experience is a screen that opens after someone interacts with your ad on a mobile device. It may include a series of interactive or multimedia components, including video, images product catalog and more.   
25 Metrics canvas_avg_ view_timeThe average total time, in seconds, that people spent viewing an Instant Experience. An Instant Experience is a screen that opens after someone interacts with your ad on a mobile device. It may include a series of interactive or multimedia components, including video, images product catalog and more.   
26 Metrics catalog_segment _actionsThe number of actions performed attributed to your ads promoting your catalog segment, broken down by action type.   
27 Metrics catalog_segment _valueThe total value of all conversions from your catalog segment attributed to your ads.   
28 Metrics catalog_segment _value_mobile_ purchase_roasThe total return on ad spend (ROAS) from mobile app purchases for your catalog segment.  
29 Metrics catalog_segment_ value_omni_purchase _roasThe total return on ad spend  (ROAS) from all purchases for your catalog segment.  
30 Metrics catalog_segment _value_website _purchase_roasThe total return on ad  spend (ROAS) from website purchases for your catalog segment.  
31 Metrics clicks The number of clicks on your ads.11 
32 Metrics conversion_ valuesconversion_ values  
33 Metrics conversions conversions   
34 Metrics converted_product _quantityThe number of products purchased which are recorded by your merchant partner's pixel or app SDK for a given product ID and driven by your ads. Has to be used together with converted product ID breakdown.   
35 Metrics converted_ product_valueThe value of purchases recorded by your merchant partner's pixel or app SDK for a given product ID and driven by your ads. Has to be used together with converted product ID breakdown.  
36 Metrics cost_per_15 _sec_video_viewcost_per_15_ sec_video_view0.038 
37 Metrics cost_per_2_sec_ continuous_video _viewcost_per_2_sec_ continuous_video _view  
38 Metrics cost_per_ action_typeThe average cost of a relevant action.[action_type: video_view, value:0.032806] ,[action_type :link_click, value:0.414545], [action_type: landing_page _view,value: 1.14],[action _type:post _engagement, value:0.0304], [action_type: page_engagement, value:0.0304]
39 Metrics cost_per_ action_type_ link_clickcost_per_action _type_link_click0.414545 
40 Metrics cost_per_action _type_landing_page _viewcost_per_action _type_landing_page _view1.14 
41 Metrics cost_per_action _type_post _engagementcost_per_action _type_post _engagement0.0304 
42 Metrics cost_per _action_type_ page_engagementcost_per_ action_type_ page_engagement0.0304 
43 Metrics cost_per _action_type_ video_viewcost_per _action_type_ video_view0.032806 
44 Metrics cost_per_ ad_clickcost_per_ ad_click  
45 Metrics cost_per_ conversioncost_per_ conversion  
46 Metrics cost_per_dda _countby_convscost_per_dda _countby_convs  
47 Metrics cost_per_inline _link_clickThe average cost of each inline link click.0.414545 
48 Metrics cost_per_inline _post_engagementThe average cost of each inline post engagement.0.414545 
49 Metrics cost_per_one_ thousand_ad_ impressioncost_per_one_ thousand_ad_ impression  
50 Metrics cost_per_ outbound_clickThe average cost for each outbound click. 0.414545 
51 Metrics cost_per_ store_visit_ actioncost_per_ store_visit_ action  
52 Metrics cost_per_ thruplayThe average cost for each ThruPlay. This metric is in development.0.038 
53 Metrics cost_per_unique _action_typeThe average cost of each unique action. This metric is estimated. [action_type: video_view, value:0.035077], [action_type: link_click, value:0.414545], [action_type: landing_page _view, value: 1.14],[action _type:post_ engagement, value:0.034286], [action_type: page_engagement, value:0.034286]
54 Metrics cost_per_ unique_action_ type_link_clickcost_per_ unique_action_ type_link_click0.414545 
55 Metrics cost_per_unique _action_type_ landing_page_viewcost_per_unique _action_type_ video_view1.14 
56 Metrics cost_per_unique _action_type_video _viewcost_per_ unique_action_ type_post_ engagement0.035077 
57 Metrics cost_per_ unique_action_ type_post_ engagementcost_per_ unique_action_ type_page_ engagement0.034286 
58 Metrics cost_per_unique _action_type_page _engagementcost_per_ unique_action_ type_landing_ page_view0.034286 
59 Metrics cost_per_ unique_clickThe average cost for each unique click (all). This metric is estimated. 0.414545 
60 Metrics cost_per_ unique_inline_ link_clickThe average cost of each unique inline link click. This metric is estimated. 0.414545 
61 Metrics cost_per_ unique_outbound_ clickThe average cost for each unique outbound click. This metric is estimated.0.414545 
62 Metrics cpc The average cost for each click (all).00-01-1900 
63 Metrics cpm The average cost for 1,000 impressions.8.39779 
64 Metrics cpp The average cost to reach 1,000 people. This metric is estimated. 09-01-1900 
65 Metrics created_time created_time 29-07-2020 
66 Metrics ctr The percentage of times people saw your ad and performed a click (all). 2.025783 
67 Dimension date_start The start date for your data. This is controlled by the date range you've selected for your reporting view.01-08-2020 
68 Dimension date_stop The end date for your data. This is controlled by the date range you've selected for your reporting view.01-08-2020 
69 Metrics dda_countby_convs dda_countby_convs   
70 Metrics estimated_ad_recall _rate_lower_boundestimated_ad_recall _rate_lower_bound  
71 Metrics estimated_ad_recall _rate_upper_boundestimated_ad_recall _rate_upper_bound  
72 Metrics estimated_ad_ recallers_lower_boundestimated_ad_ recallers_lower_bound  
73 Metrics estimated_ad_ recallers_upper_boundestimated_ad_ recallers_upper_bound  
74 Metrics frequency The average number of times each person saw your ad. This metric is estimated. 1.133612 
75 Metrics full_view_ impressionsThe number of Full Views on your Page's posts as a result of your ad.   
76 Metrics full_view_reach The number of people who performed a Full View on your Page's post as a result of your ad.   
77 Metrics gender_targeting gender_targeting   
78 Metrics impressions The number of times your ads were on screen. 543 
79 Metrics inline_link_ click_ctrThe percentage of time people saw your ads and performed an inline link click.2.025783 
80 Metrics inline_link_ clicksThe 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. 11 
81 Metrics inline_post_ engagementThe total number of actions that people take involving your ads. Inline post engagements use a fixed 1-day-click attribution window. 11 
82 Metrics instant_experience_ clicks_to_openinstant_experience_ clicks_to_open  
83 Metrics instant_experience_ clicks_to_startinstant_experience_ clicks_to_start  
84 Metrics instant_experience _outbound_clicksinstant_experience _outbound_clicks  
85 Metrics interactive_ component_tapinteractive_ component_tap  
86 Dimension labels labels   
87 Dimension location location   
88 Metrics mobile_app_ purchase_roasThe total return on ad spend (ROAS) from mobile app purchases. This is based on the value that you assigned when you set up the app event.   
89 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 
90 Metrics outbound_clicks The number of clicks on links that take people off Facebook-owned properties.11 
91 Metrics outbound_clicks_ctr The percentage of times people saw your ad and performed an outbound click. 2.025783 
92 Metrics 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.  
93 Metrics qualifying_question _qualify_answer_ratequalifying_question _qualify_answer_rate  
94 Metrics 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. This metric is estimated. 479 
95 Metrics social_spend The total amount you've spent so far for your ads showed with social information. (ex: Jane Doe likes this). 
96 Metrics spend The estimated total amount of money you've spent on your campaign, ad set or ad during its schedule. This metric is estimated.4.56 
97 Metrics store_visit_ actionsstore_visit_ actions[action_type: store_visit, value:0]
98 Metrics unique_actions The number of people who took an action that was attributed to your ads. This metric is estimated.[action_type: video_view, value:130], [action_type: link_click, value:11], [action_type: landing_page _view, value:4], [action_type: post_engagement, value:133], [action_type: page_engagement, value:133]
99 Metrics unique_clicks The number of people who performed a click (all). This metric is estimated. 11 
100 Metrics unique_actions_ link_clickunique_actions_ link_click11 
101 Metrics unique_actions_ landing_page_viewunique_actions_ landing_page_view
102 Metrics unique_actions_ post_engagementunique_actions_ post_engagement133 
103 Metrics unique_actions_ page_engagementunique_actions_ page_engagement133 
104 Metrics unique_actions_ video_viewunique_actions_ video_view130 
105 Metrics unique_ctr The percentage of people who saw your ad and performed a unique click (all). This metric is estimated.2.296451 
106 Metrics unique_inline_ link_click_ctrThe percentage of times people saw your ad and performed a link click. Inline click-through rate uses a fixed 1-day-click attribution window. This metric is estimated. 2.296451 
107 Metrics unique_inline_ link_clicksThe number of people who performed an inline link click. This metric is estimated.11 
108 Metrics unique_link_ clicks_ctrThe percentage of people who saw your ad and performed a link click. This metric is estimated. 2.296451 
109 Metrics unique_outbound _clicksThe number of people who performed an outbound click. This metric is estimated.11-01-1900 
110 Metrics unique_outbound_ clicks_ctrThe percentage of people who saw your ad and performed an outbound click. This metric is estimated. 2.296451 
111 Metrics unique_video _view_15_secunique_video _view_15_sec111 
112 Dimension updated_time updated_time 03-08-2020 
113 Metrics video_15_sec_ watched_actionsvideo_15_sec_ watched_actions120 
114 Metrics video_30_sec_ watched_actionsThe number of times your video played for at least 30 seconds, or for nearly its total length if it's shorter than 30 seconds. For each impression of a video, we'll count video views separately and exclude any time spent replaying the video. 117 
115 Metrics video_avg_time_ watched_actionsThe average time a video was played, including any time spent replaying the video for a single impression.
116 Metrics video_continuous_ 2_sec_watched_actionsvideo_continuous_ 2_sec_watched_actions  
117 Metrics video_p100_ watched_actionsThe number of times your video was played at 100% of its length, including plays that skipped to this point. 116 
118 Metrics video_p25_watched _actionsThe number of times your video was played at 25% of its length, including plays that skipped to this point.151 
119 Metrics video_p50_ watched_actionsThe number of times your video was played at 50% of its length, including plays that skipped to this point. 129 
120 Metrics video_p75_ watched_actionsThe number of times your video was played at 75% of its length, including plays that skipped to this point. 121 
121 Metrics video_p95_ watched_actionsThe number of times your video was played at 95% of its length, including plays that skipped to this point.118 
122 Metrics video_play_ actionsThe number of times your video starts to play. This is counted for each impression of a video and excludes replays. This metric is in development.398 
123 Metrics video_play_curve _actionsA video-play based curve graph that illustrates the percentage of video plays that reached a given second. Entries 0 to 14 represent seconds 0 thru 14. Entries 15 to 17 represent second ranges [15 to 20), [20 to 25), and [25 to 30). Entries 18 to 20 represent second ranges [30 to 40), [40 to 50), and [50 to 60). Entry 21 represents plays over 60 seconds.  
124 Metrics video_play_retention _0_to_15s_actionsvideo_play_retention _0_to_15s_actions  
125 Metrics video_play_retention_ 20_to_60s_actionsvideo_play_retention_ 20_to_60s_actions  
126 Metrics video_play_retention_ graph_actionsvideo_play_retention_ graph_actions  
127 Metrics video_time_ watched_actionsvideo_time_ watched_actions  
128 Metrics website_ctr The percentage of times people saw your ad and performed a link click. 1900-01-02 
129 Metrics website_purchase _roasThe total return on ad spend (ROAS) from website purchases. This is based on the value of all conversions recorded by the Facebook pixel on your website and attributed to your ads.  
130 Metrics wish_bid wish_bid 
131 Electrik.AI sha_id Hashed primary key 4d7a30ffb7e178 09271acabafbb50c2 694c14878f352013 ca5b0c997a777b454
132 Electrik.AI snapshot_dt Date on which the data is captured 43625 
133 Electrik.AI etl_org Organization Id Electrik AI 
134 Electrik.AI etl_project Project Id PR000333 
135 Electrik.AI etl_create_utc_dttm Record loaded/created Timestamp in UTC 27-10-2020 22:49
136 Electrik.AI etl_update_utc_dttm Record Update Timestamp in UTC 27-10-2020 22:49
137 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 27-10-2020 22:28
138 Electrik.AI etl_flow_nm EAI Flow CodeCAMPAIGN_ INSIGHT
139 Electrik.AI etl_flow_ instance_idEAI Flow Execution Instance Id FL00AD-20190 910144445424196
The Ad Insights report includes all statistics aggregated at the ad level.
IndexCategoryElectrik.AI Column NameDescriptionSample Value
Dimension account_currencyCurrency that is used by your ad account.USD 
Dimension account_id The ID number of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing.120785838 9393050
Dimension account_name The name of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing. Electrik.AI 
Metrics action_values The total value of all conversions attributed to your ads.  
Metrics actions The total number of actions people took that are attributed to your ads. Actions may include engagement, clicks or conversions. [action_type: video_view, value:139], [action_type: link_click, value:11], [action_type: landing_page _view, value:4], [action_type:post_ engagement, value:150], [action_ type:page_ engagement, value:150]
Metrics actions_link _clickactions_ link_click11 
Metrics actions_landing _page_viewactions_landing _page_view
Metrics actions_post_ engagementactions_post_ engagement150 
Metrics actions_page_ engagementactions_page_ engagement150 
10 Metrics actions_video _viewactions_video _view139 
11 Metrics ad_click_ actionsad_click_ actions  
12 Dimension ad_id The unique ID of the ad you're viewing in reporting.  
13 Metrics ad_impression_ actionsad_impression_ actions  
14 Dimension ad_name The name of the ad you're viewing in reporting.  
15 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.   
16 Dimension 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.  
17 Dimension age_targeting age_targeting   
18 Metrics auction_bid auction_bid 
19 Metrics auction_ competitivenessauction_ competitiveness
20 Metrics auction_max_ competitor_bidauction_max_ competitor_bid
21 Dimension buying_type The method by which you pay for and target ads in your campaigns: through dynamic auction bidding, fixed-price bidding, or reach and frequency buying. This field is currently only visible at the campaign level. AUCTION 
22 Dimension campaign_id The unique ID number of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads. 238452737 20480700
23 Dimension campaign_name The name of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads. Evergreen_EAI _BrandAwareness
24 Metrics canvas_avg_ view_percentThe average percentage of the Instant Experience that people saw. An Instant Experience is a screen that opens after someone interacts with your ad on a mobile device. It may include a series of interactive or multimedia components, including video, images product catalog and more.   
25 Metrics canvas_avg_ view_timeThe average total time, in seconds, that people spent viewing an Instant Experience. An Instant Experience is a screen that opens after someone interacts with your ad on a mobile device. It may include a series of interactive or multimedia components, including video, images product catalog and more.   
26 Metrics catalog_segment _actionsThe number of actions performed attributed to your ads promoting your catalog segment, broken down by action type.   
27 Metrics catalog_segment _valueThe total value of all conversions from your catalog segment attributed to your ads.   
28 Metrics catalog_segment _value_mobile_ purchase_roasThe total return on ad spend (ROAS) from mobile app purchases for your catalog segment.  
29 Metrics catalog_segment_ value_omni_purchase _roasThe total return on ad spend  (ROAS) from all purchases for your catalog segment.  
30 Metrics catalog_segment _value_website _purchase_roasThe total return on ad  spend (ROAS) from website purchases for your catalog segment.  
31 Metrics clicks The number of clicks on your ads.11 
32 Metrics conversion_ valuesconversion_ values  
33 Metrics conversions conversions   
34 Metrics converted_product _quantityThe number of products purchased which are recorded by your merchant partner's pixel or app SDK for a given product ID and driven by your ads. Has to be used together with converted product ID breakdown.   
35 Metrics converted_ product_valueThe value of purchases recorded by your merchant partner's pixel or app SDK for a given product ID and driven by your ads. Has to be used together with converted product ID breakdown.  
36 Metrics cost_per_15 _sec_video_viewcost_per_15_ sec_video_view0.038 
37 Metrics cost_per_2_sec_ continuous_video _viewcost_per_2_sec_ continuous_video _view  
38 Metrics cost_per_ action_typeThe average cost of a relevant action.[action_type: video_view, value:0.032806] ,[action_type :link_click, value:0.414545], [action_type: landing_page _view,value: 1.14],[action _type:post _engagement, value:0.0304], [action_type: page_engagement, value:0.0304]
39 Metrics cost_per_ action_type_ link_clickcost_per_action _type_link_click0.414545 
40 Metrics cost_per_action _type_landing_page _viewcost_per_action _type_landing_page _view1.14 
41 Metrics cost_per_action _type_post _engagementcost_per_action _type_post _engagement0.0304 
42 Metrics cost_per _action_type_ page_engagementcost_per_ action_type_ page_engagement0.0304 
43 Metrics cost_per _action_type_ video_viewcost_per _action_type_ video_view0.032806 
44 Metrics cost_per_ ad_clickcost_per_ ad_click  
45 Metrics cost_per_ conversioncost_per_ conversion  
46 Metrics cost_per_dda _countby_convscost_per_dda _countby_convs  
47 Metrics cost_per_inline _link_clickThe average cost of each inline link click.0.414545 
48 Metrics cost_per_inline _post_engagementThe average cost of each inline post engagement.0.414545 
49 Metrics cost_per_one_ thousand_ad_ impressioncost_per_one_ thousand_ad_ impression  
50 Metrics cost_per_ outbound_clickThe average cost for each outbound click. 0.414545 
51 Metrics cost_per_ store_visit_ actioncost_per_ store_visit_ action  
52 Metrics cost_per_ thruplayThe average cost for each ThruPlay. This metric is in development.0.038 
53 Metrics cost_per_unique _action_typeThe average cost of each unique action. This metric is estimated. [action_type: video_view, value:0.035077], [action_type: link_click, value:0.414545], [action_type: landing_page _view, value: 1.14],[action _type:post_ engagement, value:0.034286], [action_type: page_engagement, value:0.034286]
54 Metrics cost_per_ unique_action_ type_link_clickcost_per_ unique_action_ type_link_click0.414545 
55 Metrics cost_per_unique _action_type_ landing_page_viewcost_per_unique _action_type_ video_view1.14 
56 Metrics cost_per_unique _action_type_video _viewcost_per_ unique_action_ type_post_ engagement0.035077 
57 Metrics cost_per_ unique_action_ type_post_ engagementcost_per_ unique_action_ type_page_ engagement0.034286 
58 Metrics cost_per_unique _action_type_page _engagementcost_per_ unique_action_ type_landing_ page_view0.034286 
59 Metrics cost_per_ unique_clickThe average cost for each unique click (all). This metric is estimated. 0.414545 
60 Metrics cost_per_ unique_inline_ link_clickThe average cost of each unique inline link click. This metric is estimated. 0.414545 
61 Metrics cost_per_ unique_outbound_ clickThe average cost for each unique outbound click. This metric is estimated.0.414545 
62 Metrics cpc The average cost for each click (all).00-01-1900 
63 Metrics cpm The average cost for 1,000 impressions.8.39779 
64 Metrics cpp The average cost to reach 1,000 people. This metric is estimated. 09-01-1900 
65 Metrics created_time created_time 29-07-2020 
66 Metrics ctr The percentage of times people saw your ad and performed a click (all). 2.025783 
67 Dimension date_start The start date for your data. This is controlled by the date range you've selected for your reporting view.01-08-2020 
68 Dimension date_stop The end date for your data. This is controlled by the date range you've selected for your reporting view.01-08-2020 
69 Metrics dda_countby_convs dda_countby_convs   
70 Metrics estimated_ad_recall _rate_lower_boundestimated_ad_recall _rate_lower_bound  
71 Metrics estimated_ad_recall _rate_upper_boundestimated_ad_recall _rate_upper_bound  
72 Metrics estimated_ad_ recallers_lower_boundestimated_ad_ recallers_lower_bound  
73 Metrics estimated_ad_ recallers_upper_boundestimated_ad_ recallers_upper_bound  
74 Metrics frequency The average number of times each person saw your ad. This metric is estimated. 1.133612 
75 Metrics full_view_ impressionsThe number of Full Views on your Page's posts as a result of your ad.   
76 Metrics full_view_reach The number of people who performed a Full View on your Page's post as a result of your ad.   
77 Metrics gender_targeting gender_targeting   
78 Metrics impressions The number of times your ads were on screen. 543 
79 Metrics inline_link_ click_ctrThe percentage of time people saw your ads and performed an inline link click.2.025783 
80 Metrics inline_link_ clicksThe 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. 11 
81 Metrics inline_post_ engagementThe total number of actions that people take involving your ads. Inline post engagements use a fixed 1-day-click attribution window. 11 
82 Metrics instant_experience_ clicks_to_openinstant_experience_ clicks_to_open  
83 Metrics instant_experience_ clicks_to_startinstant_experience_ clicks_to_start  
84 Metrics instant_experience _outbound_clicksinstant_experience _outbound_clicks  
85 Metrics interactive_ component_tapinteractive_ component_tap  
86 Dimension labels labels   
87 Dimension location location   
88 Metrics mobile_app_ purchase_roasThe total return on ad spend (ROAS) from mobile app purchases. This is based on the value that you assigned when you set up the app event.   
89 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 
90 Metrics outbound_clicks The number of clicks on links that take people off Facebook-owned properties.11 
91 Metrics outbound_clicks_ctr The percentage of times people saw your ad and performed an outbound click. 2.025783 
92 Metrics 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.  
93 Metrics qualifying_question _qualify_answer_ratequalifying_question _qualify_answer_rate  
94 Metrics 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. This metric is estimated. 479 
95 Metrics social_spend The total amount you've spent so far for your ads showed with social information. (ex: Jane Doe likes this). 
96 Metrics spend The estimated total amount of money you've spent on your campaign, ad set or ad during its schedule. This metric is estimated.4.56 
97 Metrics store_visit_ actionsstore_visit_ actions[action_type: store_visit, value:0]
98 Metrics unique_actions The number of people who took an action that was attributed to your ads. This metric is estimated.[action_type: video_view, value:130], [action_type: link_click, value:11], [action_type: landing_page _view, value:4], [action_type: post_engagement, value:133], [action_type: page_engagement, value:133]
99 Metrics unique_clicks The number of people who performed a click (all). This metric is estimated. 11 
100 Metrics unique_actions_ link_clickunique_actions_ link_click11 
101 Metrics unique_actions_ landing_page_viewunique_actions_ landing_page_view
102 Metrics unique_actions_ post_engagementunique_actions_ post_engagement133 
103 Metrics unique_actions_ page_engagementunique_actions_ page_engagement133 
104 Metrics unique_actions_ video_viewunique_actions_ video_view130 
105 Metrics unique_ctr The percentage of people who saw your ad and performed a unique click (all). This metric is estimated.2.296451 
106 Metrics unique_inline_ link_click_ctrThe percentage of times people saw your ad and performed a link click. Inline click-through rate uses a fixed 1-day-click attribution window. This metric is estimated. 2.296451 
107 Metrics unique_inline_ link_clicksThe number of people who performed an inline link click. This metric is estimated.11 
108 Metrics unique_link_ clicks_ctrThe percentage of people who saw your ad and performed a link click. This metric is estimated. 2.296451 
109 Metrics unique_outbound _clicksThe number of people who performed an outbound click. This metric is estimated.11-01-1900 
110 Metrics unique_outbound_ clicks_ctrThe percentage of people who saw your ad and performed an outbound click. This metric is estimated. 2.296451 
111 Metrics unique_video _view_15_secunique_video _view_15_sec111 
112 Dimension updated_time updated_time 03-08-2020 
113 Metrics video_15_sec_ watched_actionsvideo_15_sec_ watched_actions120 
114 Metrics video_30_sec_ watched_actionsThe number of times your video played for at least 30 seconds, or for nearly its total length if it's shorter than 30 seconds. For each impression of a video, we'll count video views separately and exclude any time spent replaying the video. 117 
115 Metrics video_avg_time_ watched_actionsThe average time a video was played, including any time spent replaying the video for a single impression.
116 Metrics video_continuous_ 2_sec_watched_actionsvideo_continuous_ 2_sec_watched_actions  
117 Metrics video_p100_ watched_actionsThe number of times your video was played at 100% of its length, including plays that skipped to this point. 116 
118 Metrics video_p25_watched _actionsThe number of times your video was played at 25% of its length, including plays that skipped to this point.151 
119 Metrics video_p50_ watched_actionsThe number of times your video was played at 50% of its length, including plays that skipped to this point. 129 
120 Metrics video_p75_ watched_actionsThe number of times your video was played at 75% of its length, including plays that skipped to this point. 121 
121 Metrics video_p95_ watched_actionsThe number of times your video was played at 95% of its length, including plays that skipped to this point.118 
122 Metrics video_play_ actionsThe number of times your video starts to play. This is counted for each impression of a video and excludes replays. This metric is in development.398 
123 Metrics video_play_curve _actionsA video-play based curve graph that illustrates the percentage of video plays that reached a given second. Entries 0 to 14 represent seconds 0 thru 14. Entries 15 to 17 represent second ranges [15 to 20), [20 to 25), and [25 to 30). Entries 18 to 20 represent second ranges [30 to 40), [40 to 50), and [50 to 60). Entry 21 represents plays over 60 seconds.  
124 Metrics video_play_retention _0_to_15s_actionsvideo_play_retention _0_to_15s_actions  
125 Metrics video_play_retention_ 20_to_60s_actionsvideo_play_retention_ 20_to_60s_actions  
126 Metrics video_play_retention_ graph_actionsvideo_play_retention_ graph_actions  
127 Metrics video_time_ watched_actionsvideo_time_ watched_actions  
128 Metrics website_ctr The percentage of times people saw your ad and performed a link click. 1900-01-02 
129 Metrics website_purchase _roasThe total return on ad spend (ROAS) from website purchases. This is based on the value of all conversions recorded by the Facebook pixel on your website and attributed to your ads.  
130 Metrics wish_bid wish_bid 
131 Electrik.AI sha_id Hashed primary key 4d7a30ffb7e178 09271acabafbb50c2 694c14878f352013 ca5b0c997a777b454
132 Electrik.AI snapshot_dt Date on which the data is captured 43625 
133 Electrik.AI etl_org Organization Id Electrik AI 
134 Electrik.AI etl_project Project Id PR000333 
135 Electrik.AI etl_create_utc_dttm Record loaded/created Timestamp in UTC 27-10-2020 22:49
136 Electrik.AI etl_update_utc_dttm Record Update Timestamp in UTC 27-10-2020 22:49
137 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 27-10-2020 22:28
138 Electrik.AI etl_flow_nm EAI Flow CodeCAMPAIGN_ INSIGHT
139 Electrik.AI etl_flow_ instance_idEAI Flow Execution Instance Id FL00AD-20190 910144445424196