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-ElectrikAI

Step 4: Select the Connections tab in the left most panel.

Step 4 Select the Connections Icon in the left most panel-ElectrikAI

Step 5: Click on “Add” action button.

Step 5 Click on “Add” button the top-ElectrikAI

Step 6: 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 7: Provide your Facebook Ads account User Id and Password.

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

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

Step 8 Allow access your Facebook Ads account-ElectrikAI

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

Step 9 Select the Ads Account from the dropdown-ElectrikAI

Step 10: 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 4 Flow Add Button-ElectrikAI

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: Review the Data Source, Data Destination, Database Schema, Provide Success Notification Email, Failure Notification Email. Click “Save and Proceed” to continue.
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.

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
IndexCategoryElectrik.AI Column Name Description Sample Value
1Dimensionaccount_currencyCurrency that is used by your ad accountUSD
2Dimensionaccount_idThe ID number of your ad account4.4177E+14
3Dimensionaccount_nameThe name of your ad accountiCEDQ
4DimensionactionsThe 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]
5Metricactions_link_clickactions link click
6Metricactions_landing_page_viewactions landing page view
7Metricactions_post_engagementactions post engagement
8Metricactions_page_engagementactions page engagement
9Metricactions_video_viewactions video view
10Dimensionad_idThe Facebook Advertising assigned unique identifier of an ad2.3844E+16
11Dimensionad_nameThe ad  nameImage Ad
12Dimensionadset_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 targeting2.3844E+16
13Dimensionadset_nameThe name of the ad setDrive Traffic
14Dimensionbuying_typePayment method for and target ads. This field is currently only visible at the campaign levelAUCTION
15Dimensioncampaign_idThe Facebook Advertising assigned identifier of a campaign2.3844E+16
16Dimensioncampaign_nameThe campaign nameiCEDQ Branding
17Dimensioncanvas_avg_view_percentcanvas avg view percent
18Dimensioncanvas_avg_view_timecanvas avg view time
19DimensionclicksClicks 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
20Dimensionconversion_rate_rankingconversion rate rankingABOVE_AVERAGE
21Dimensionconversion_valuesThe total value of all conversions attributed to your ads
22DimensionconversionsThe 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
23Dimensioncost_per_action_typeThe 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]
24Metriccost_per_action_type_ link_clickcost per action type link click
25Metriccost_per_action_type_ landing_page_viewcost per action type landing page view
26Metriccost_per_action_type_ post_engagementcost per action type post engagement
27Metriccost_per_action_type_ page_engagementcost per action type page engagement
28Metriccost_per_action_ type_video_viewcost per action type video view
29Dimensioncost_per_conversioncost per conversion
30Dimensioncost_per_estimated_ ad_recallerscost per estimated ad recallers
31Metriccost_per_inline_ link_clickcost per inline link click0.852692
32Metriccost_per_inline_ post_engagementcost per inline post engagement0.852692
33Metriccost_per_outbound_clickcost per outbound click[action_type: outbound_click, value:0.852692]
34Metriccost_per_thruplaycost per thruplay[action_type: video_view, value: 0.252222]
35Dimensioncost_per_unique_action_typecost 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]
36Metriccost_per_unique_action_ type_link_clickcost per unique action type link click
37Metriccost_per_unique_action_ type_video_viewcost per unique action type video view
38Metriccost_per_unique_action_ type_post_engagementcost per unique action type post engagement
39Metriccost_per_unique_action_ type_page_engagementcost per unique action type page engagement
40Metriccost_per_unique_action_ type_landing_page_viewcost per unique action type landing page view
41Metriccost_per_unique_clickcost per unique click0.671818
42Metriccost_per_unique_ inline_link_clickcost per unique inline link click0.852692
43Metriccost_per_unique_ outbound_clickcost per unique outbound click[action_type: outbound_click, value:0.8868]
44MetriccpcThe average cost for each click (all)0.671818
45MetriccpmThe average cost for 1,000 impressions7.089862
46MetriccppThe average cost to reach 1,000 people7.858915
47MetricctrThe 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 1001.055325
48date_startThe start date for your data9/6/2019
49date_stopThe end date for your data9/6/2019
50Dimensionengagement_rate_rankingengagement rate rankingBELOW_ AVERAGE_35
51Dimensionestimated_ad_recall_rateestimated ad recall rate
52Dimensionestimated_ad_recallersestimated ad recallers
53MetricfrequencyThe average number of times each person saw your ad1.108472
54Dimensionfull_view_impressionsThe number of Full Views on your Page's posts as a result of your ad
55Dimensionfull_view_reachThe number of people who performed a Full View on your Page's post as a result of your ad
56MetricimpressionsThe number of times your ads were on screen3127
57Metricinline_link_click_ctrThe percentage of time people saw your ads and performed an inline link click0.831468
58Metricinline_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 window26
59Metricinline_post_engagementThe total number of actions that people take involving your ads. Inline post engagements use a fixed 1-day-click attribution window26
60Metricinstant_experience_ clicks_to_openinstant experience clicks to open0
61Metricinstant_experience_ clicks_to_startinstant experience clicks to start0
62Metricinstant_experience_ outbound_clicksinstant experience outbound clicks0
63Dimensionmobile_app_ purchase_roasmobile app purchase roas
64DimensionobjectiveThe objective reflecting the goal you want to achieve with your advertising. It may be different from the selected objective of the campaign in some casesLINK_CLICKS
65Metricoutbound_clicksThe number of clicks on links that take people off Facebook-owned properties[action_type: outbound_click, value:26]
66Metricoutbound_clicks_ctrThe percentage of times people saw your ad and performed an outbound click[action_type: outbound_click, value:0.831468]
67Dimensionpurchase_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
68Dimensionquality_rankingquality rankingBELOW_ AVERAGE_20
69DimensionreachThe 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 people2821
70Dimensionrelevance_scoreYour 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]
71Metricsocial_spendThe total amount you've spent so far for your ads showed with social information0
72MetricspendThe estimated total amount of money you've spent on your campaign, ad set or ad during its schedule22.17
73Dimensionunique_actionsThe 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]
74Metricunique_actions_link_clickunique actions link click26
75Metricunique_actions_ landing_page_viewunique actions landing page view3
76Metricunique_actions_ post_engagementunique actions post engagement26
77Metricunique_actions_ page_engagementunique actions page engagement26
78Metricunique_actions_ video_viewunique actions video view
79Metricunique_clicksThe number of people who performed a click (all)33
80Metricunique_ctrThe percentage of people who saw your ad and performed a unique click (all)1.169798
81Metricunique_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 window0.921659
82Metricunique_inline_link_clicksThe number of people who performed an inline link click26
83Metricunique_link_clicks_ctrThe percentage of people who saw your ad and performed a link click0.921659
84Metricunique_outbound_clicksThe number of people who performed an outbound click[action_type: outbound_click, value:25]
85Metricunique_outbound_clicks_ctrThe percentage of people who saw your ad and performed an outbound click[action_type: outbound_click, value:0.886211]
86Metricvideo_30_sec_watched_actionsThe 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]
87Metricvideo_avg_time_watched_actionsThe average time a video was played, including any time spent replaying the video for a single impression[action_type: video_view, value:12]
88Metricvideo_p100_watched_actionsThe 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]
89Metricvideo_p25_watched_actionsThe 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]
90Metricvideo_p50_watched_actionsThe 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]
91Metricvideo_p75_watched_actionsThe 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]
92Metricvideo_play_actionsThe number of times your video starts to play per impression of a video[action_type: video_view, value:12]
93Dimensionvideo_play_curve_actionsA 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]]
94Dimensionvideo_thruplay_ watched_actionsvideo thruplay watched actions
95Metricwebsite_ctrThe percentage of times people saw your ad and performed a link click[action_type: link_click, value: 0.831468]
96Dimensionwebsite_purchase_roasThe 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
97Electrik.AIsnapshot_dtDate on which the data is captured9/6/2019
98Electrik.AIetl_orgOrganization Idtorana_2
99Electrik.AIetl_projectProject Idtest_i_2
100Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC08:02.6
101Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC08:02.6
102Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC45:06.5
103Electrik.AIetl_flow_nmEAI Flow CodeAD_INSIGHT
104Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL00AD-2019091 0144445424196