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

Facebook Ads Data Schema

IndexCategoryElectrik.AI Column Name Description Sample Value
1Dimensionaccount_currencyCurrency that is used
by your ad account
USD
2Dimensionaccount_idThe ID number of your
ad account
4.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 ad
2.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
targeting
2.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
level
AUCTION
15Dimensioncampaign_idThe Facebook Advertising
assigned identifier of a
campaign
2.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_click
cost per action type link click
25Metriccost_per_action_type_
landing_page_view
cost per action type
landing page view
26Metriccost_per_action_type_
post_engagement
cost per action type post
engagement
27Metriccost_per_action_type_
page_engagement
cost per action type page
engagement
28Metriccost_per_action_
type_video_view
cost per action type video
view
29Dimensioncost_per_conversioncost per conversion
30Dimensioncost_per_estimated_
ad_recallers
cost per estimated ad
recallers
31Metriccost_per_inline_
link_click
cost per inline link click0.852692
32Metriccost_per_inline_
post_engagement
cost per inline
post engagement
0.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_click
cost per unique action
type link click
37Metriccost_per_unique_action_
type_video_view
cost per unique action
type video view
38Metriccost_per_unique_action_
type_post_engagement
cost per unique action
type post engagement
39Metriccost_per_unique_action_
type_page_engagement
cost per unique action
type page engagement
40Metriccost_per_unique_action_
type_landing_page_view
cost per unique action
type landing page view
41Metriccost_per_unique_clickcost per unique click0.671818
42Metriccost_per_unique_
inline_link_click
cost per unique
inline link click
0.852692
43Metriccost_per_unique_
outbound_click
cost 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 impressions
7.089862
46MetriccppThe average cost
to reach 1,000 people
7.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
100
1.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 ad
1.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 screen
3127
57Metricinline_link_click_ctrThe percentage of time
people saw your ads and
performed an inline link
click
0.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 window
26
59Metricinline_post_engagementThe total number of
actions that people take
involving your ads. Inline
post engagements use a
fixed 1-day-click attribution
window
26
60Metricinstant_experience_
clicks_to_open
instant experience
clicks to open
0
61Metricinstant_experience_
clicks_to_start
instant experience
clicks to start
0
62Metricinstant_experience_
outbound_clicks
instant experience
outbound clicks
0
63Dimensionmobile_app_
purchase_roas
mobile 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 cases
LINK_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 people
2821
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 information
0
72MetricspendThe estimated total
amount of money you’ve
spent on your campaign,
ad set or ad during its
schedule
22.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_view
unique actions
landing page view
3
76Metricunique_actions_
post_engagement
unique actions
post engagement
26
77Metricunique_actions_
page_engagement
unique actions
page engagement
26
78Metricunique_actions_
video_view
unique 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
window
0.921659
82Metricunique_inline_link_clicksThe number of people who
performed an inline link click
26
83Metricunique_link_clicks_ctrThe percentage of people
who saw your ad and
performed a link click
0.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_actions
video 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 captured
9/6/2019
98Electrik.AIetl_orgOrganization Idtorana_2
99Electrik.AIetl_projectProject Idtest_i_2
100Electrik.AIetl_create_utc_dttmRecord loaded/created
Timestamp in UTC
08:02.6
101Electrik.AIetl_update_utc_dttmRecord Update
Timestamp in UTC
08:02.6
102Electrik.AIetl_start_utc_dttmEAI Flow Start
Timestamp in UTC
45:06.5
103Electrik.AIetl_flow_nmEAI Flow CodeAD_INSIGHT
104Electrik.AIetl_flow_instance_idEAI Flow Execution
Instance Id
FL00AD-2019091
0144445424196