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