Facebook Ads Source
Renta supports data export from Facebook to the following destinations:
Snowflake
Google BigQuery
Amazon S3
Clickhouse
SQL Server
Google Spreadsheets
Integration creating in a data warehouse (DWH)
Go to the integrations catalog;
Select Facebook;
Add a Facebook account that has the necessary data;
Choose the added Facebook account;
Specify the destination you want to import the data into;
Go to the settings screen and set the necessary configuration
Ad account
An ad account that has required for uploading data.
Report type
The report type consists of the unique set of parameters and metrics available for uploading to DWH. Each Report Type has its own parameters and metrics collection
| Name | Description |
|---|---|
| Statistics_Report | Main report type. Contains data about the costs of an advertising campaign. |
| Campaign_Report | Retrieves status and settings of ad campaign. |
| Ad_Report | Retrieves status and settings of ad. |
Parameters
Parameters contain the list of parameters and metrics available for export. Specify the parameters required for uploading.
As a result, Renta will create the table that will contain the selected parameters data. The order of the selected parameters in the Rentas interface will match to the order of the table columns.
Data range type
Choose the inserting period. You can specify any historical time interval.
To select the necessary time, enter the date from which you want to start uploading data in the “From” field, then enter the end date in the “To” field.
If you want the data in the table to be updated daily and supplemented with new days, then enter “Yesterday” in the “To” field.
Detailed instructions for working with a date range.
Integration name
There is an auto-generated name for your integration and here you can edit it as much as you like.
Both Cyrillic and Latin are permitted, but not more than 100 symbols.
The integration name is displayed on the Integration List page.
Table name
There is an auto-generated name for your table and here you can edit it as much as you like.
Only Latin is permitted, with numbers and “_” symbol.
Update time
You can specify any update time that you need. Users choose early morning integration updates most often, for example 5 AM.
In that case, your integration will update in the period from 5 AM to 6 AM.
Integrations are updated according to the time zone selected in your profile settings.
Overwrite period
The data overwrite period is a retrospective update of data for the selected period.
For instance, you choose the overwrite period “Last 7 days” – it means that all data for the last 7 days will be deleted and inserted once again with updated data.
Note: this tab appears only if parameters like Day/Date/Time Period etc have been chosen.
Integration creating in Google Spreadsheets
Take advantage of the free extension available in the Google Workspace Marketplace. In order to do it:
Install the extension Renta Spreadsheets Add-on.
Then go to Google Sheets and in the Tools tab select Renta
Press the Run button.
After that, a workspace with integration settings will open in the right sidebar. Detailed instructions for creating an integration are available at this link. Please note that all integrations created in Google Spreadsheets are also available for management in the web version of Renta.
Data Structure
| Name | Description | Type |
|---|---|---|
| id | Unique ID for an ad creative | STRING |
| account_id | The ID number of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing | STRING |
| 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 | STRING |
| bid_amount | Bid amount for this ad which will be used in auction instead of the ad set bid_amount, if specified. Any updates to the ad set bid_amount will overwrite this value with the new ad set value. | INTEGER |
| budget_rebalance_flag | Whether to automatically rebalance budgets daily for all the adsets under this campaign. | BIT |
| campaign_id | The unique ID number of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads | STRING |
| configured_status | If this status is PAUSED, all its active ad sets and ads will be paused and have an effective status CAMPAIGN_PAUSED | STRING |
| created_time | Created Time | DATE |
| preview_shareable_link | A link that enables users to preview ads in different placements | STRING |
| effective_status | Effective Status | STRING |
| issues_info.level | Indicate level of issue, could be ad set or campaign | ARRAY(STRING) |
| issues_info.error_code | Error code for the issue | ARRAY(INTEGER) |
| issues_info.error_summary | Error summary for this ad set with issue | ARRAY(STRING) |
| issues_info.error_message | Error message for this ad set with issue | ARRAY(STRING) |
| issues_info.error_type | Issues for this campaign that prevented it from deliverying | ARRAY(STRING) |
| source_ad_id | The source ad id that this ad is copied from | STRING |
| name | Campaign's name | STRING |
| status | If this status is PAUSED, all its active ad sets and ads will be paused and have an effective status CAMPAIGN_PAUSED. The field returns the same value as 'configured_status', and is the suggested one to use | STRING |
| updated_time | Updated Time. If you update spend_cap, this will not automatically update this field | DATE |
| account_currency | Currency that is used by your ad account. | STRING |
| account_id | The ID number of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing. | STRING |
| account_name | The name of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing. | STRING |
| ad_id | The unique ID of the ad you're viewing in reporting. | STRING |
| ad_name | The name of the ad you're viewing in reporting. | STRING |
| 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. | STRING |
| 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. | STRING |
| campaign_id | The unique ID number of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads. | STRING |
| campaign_name | The name of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads. | STRING |
| date_start | The start date for your data. This is controlled by the date range you've selected for your reporting view | DATE |
| date | Date of data | DATE |
| canvas_avg_view_percent | The average percentage of the Facebook Canvas that people saw. Canvas is a screen that opens on mobile after a person clicks the Canvas link in your ad. It may include a series of interactive or multimedia components, including video, images, product catalogs and more. | FLOAT |
| canvas_avg_view_time | The average total time, in seconds, that people spent viewing a Facebook Canvas. Canvas is a screen that opens on mobile after a person clicks the Canvas link in your ad. It may include a series of interactive or multimedia components, including video, images, product catalogs and more. | FLOAT |
| clicks | The number of clicks on your ads. | FLOAT |
| cost_per_estimated_ad_recallers | The average cost for each estimated ad recall lift. This metric is only available for assets in the Brand Awareness Objective. | FLOAT |
| cost_per_inline_link_click | The average cost of each inline link click | FLOAT |
| cost_per_inline_post_engagement | The average cost of each inline post engagement | FLOAT |
| cost_per_action_type | The average cost of a relevant action | FLOAT |
| cost_per_unique_click | The average cost for each unique click (all) | FLOAT |
| cost_per_unique_inline_link_click | The average cost of each unique inline link click | FLOAT |
| cpc | The average cost for each click (all) | FLOAT |
| cpm | The average cost for 1,000 impressions. | FLOAT |
| cpp | The average cost to reach 1,000 people. This metric is estimated | FLOAT |
| ctr | The percentage of times people saw your ad and performed a click (all). | FLOAT |
| estimated_ad_recall_rate | The rate at which an estimated number of additional people, when asked, would remember seeing your ads within 2 days. This metric is only available for assets in the Brand Awareness Objective. | FLOAT |
| frequency | The average number of times each person saw your ad. This metric is estimated | FLOAT |
| impressions | The number of times your ads were on screen | FLOAT |
| inline_link_click_ctr | The percentage of time people saw your ads and performed an inline link click. | FLOAT |
| 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. | FLOAT |
| 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. | FLOAT |
| objective | The objective you selected for your campaign. Your objective reflects the goal you want to achieve with your advertising. | STRING |
| 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. | FLOAT |
| social_impressions | The number of times your ads were viewed when displayed with social information, which shows Facebook friends who engaged with your Facebook Page or ad. | FLOAT |
| social_spend | The total amount you've spent so far for your ads showed with social information. (ex: Jane Doe likes this). | FLOAT |
| spend | The estimated total amount of money you've spent on your campaign, ad set or ad during its schedule. | FLOAT |
| total_action_value | The total value of all conversions attributed to your ads. | FLOAT |
| actions | The number of actions people took that are attributed to your ads. Actions may include engagement, clicks or conversions. | FLOAT |
| unique_actions | The number of people who took an action that was attributed to your ads. | FLOAT |
| unique_clicks | The number of people who performed a click (all). | FLOAT |
| unique_ctr | The percentage of people who saw your ad and performed a unique click (all). | FLOAT |
| 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. | FLOAT |
| unique_inline_link_clicks | The number of people who performed an inline link click. | FLOAT |
| unique_link_clicks_ctr | The percentage of people who saw your ad and performed a link click. | FLOAT |
| app_engagement | Number of times someone generate app_story or engage with content as app_use, app_install, or credit_spent. | FLOAT |
| app_story | FLOAT | |
| commerce_event | This parameter is entirely deprecated. | FLOAT |
| page_engagement | Number of times users perform any of the following actions in the context of the specified page: checkin, comment, follow, like, page post like, mention, post on page, share a post, answer a question. Plus the number of times users perform any of the following actions in the context of the specified page: click a link, view a photo, play a native FB video. | FLOAT |
| page_engagement.cpa | Cost per page engagement. | FLOAT |
| page_engagement.unique | Unique page engagements. | FLOAT |
| page_story | The number of people who engaged with page stories. | FLOAT |
| post_engagement | Number of times somone takes one of these actions in a specific post: comment, follow question, like, share, claim offer, answer question. Includes the number of times someone perform these actions: click a link, page like, view photo, play a video hosted on Facebook or an inline Youtube video play. For non-embedded videos use link_click. | FLOAT |
| post_engagement.cpa | Cost per post engagement. | FLOAT |
| post_engagement.unique | Unique post engagement. | FLOAT |
| instagram_profile_engagement | The number of people who engaged with instagram profile. | FLOAT |
| post_story | The number of people who engaged with post stories. | FLOAT |
| offsite_conversion | FLOAT | |
| offsite_conversion.cpa | The number of people with offsite conversions. | FLOAT |
| offsite_conversion.unique | The estimated number of people with offsite conversions. | FLOAT |
| onsite_conversion | The number of people with onsite conversions. | FLOAT |
| mobile_app_retention | The number of people who performed mobile app retention. | FLOAT |
| mobile_app_roas | The number of people who generated mobile app purchase ROAS. | FLOAT |
| offsite_engagement | FLOAT | |
| offline_conversion | Nubmer of offline conversions. | FLOAT |
| store_visit_with_dwell | The number of people visited your stores, attributed to your ads with `Dwell time`. | FLOAT |
| add_to_cart | The estimated number of people who added items to their cart. | FLOAT |
| complete_registration | The estimated number of people who completed registration. | FLOAT |
| purchase | The estimated number of people who completed at least one purchase. | FLOAT |
| search | The number of people who searched. | FLOAT |
| view_content | The number of people who viewed content. | FLOAT |
| initiate_checkout | The number of people who initiated checkouts. | FLOAT |
| add_payment_info | The estimated number of people who submitted payment info. | FLOAT |
| add_to_wishlist | The estimated number of people who added items to their wishlist. | FLOAT |
| lead | The estimated number of people with lead events. | FLOAT |
| lead_cpa | Cost per lead. | FLOAT |
| omni_app_install | The estimated number of completed app installs across all channels. | FLOAT |
| video_30_sec_watched_actions | The number of times your video was watched for an aggregate of at least 30 seconds, or for nearly its total length, whichever happened first. | FLOAT |
| video_p100_watched_actions | The number of times your video was watched at 100% of its length, including watches that skipped to this point. | FLOAT |
| video_p95_watched_actions | The number of times your video was watched at 95% of its length, including watches that skipped to this point. | FLOAT |
| Href | Identifies sections within a document. | STRING |
| utm_source | It's the value of utm parameter that contains the ad URL. | STRING |
| utm_medium | It's the value of utm parameter that contains the ad URL. | STRING |
| utm_campaign | It's the value of utm parameter that contains the ad URL. | STRING |
| utm_content | It's the value of utm parameter that contains the ad URL. | STRING |
| utm_term | It's the value of utm parameter that contains the ad URL. | STRING |
| id | Campaign's ID | STRING |
| account_id | ID of the ad account that owns this campaign | STRING |
| bid_strategy | Bid strategy for this campaign | STRING |
| boosted_object_id | The id of boosted objects. | STRING |
| budget_rebalance_flag | Whether to automatically rebalance budgets daily for all the adsets under this campaign. | BIT |
| budget_remaining | The amount of remaining budget. | FLOAT |
| buying_type | Buying type | STRING |
| can_create_brand_lift_study | If we can create a new automated brand lift study for the ad set. | BIT |
| can_use_spend_cap | Whether the campaign can set the spend cap | BIT |
| configured_status | If this status is PAUSED, all its active ad sets and ads will be paused and have an effective status CAMPAIGN_PAUSED. Prefer using 'status' instead of this. | STRING |
| created_time | Created Time | DATE |
| daily_budget | The daily budget of the campaign | FLOAT |
| effective_status | Effective Status | STRING |
| issues_info.level | Issues for this campaign that prevented it from deliverying | ARRAY(STRING) |
| issues_info.error_code | Issues for this campaign that prevented it from deliverying | ARRAY(INTEGER) |
| issues_info.error_summary | Issues for this campaign that prevented it from deliverying | ARRAY(STRING) |
| issues_info.error_message | Issues for this campaign that prevented it from deliverying | ARRAY(STRING) |
| issues_info.error_type | Issues for this campaign that prevented it from deliverying | ARRAY(STRING) |
| last_budget_toggling_time | Last budget toggling time | DATE |
| lifetime_budget | The lifetime budget of the campaign | FLOAT |
| name | Campaign's name | STRING |
| objective | Campaign's objective | STRING |
| source_campaign_id | The source campaign id that this campaign is copied from | STRING |
| spend_cap | A spend cap for the campaign, such that it will not spend more than this cap. Expressed as integer value of the subunit in your currency. | FLOAT |
| start_time | Start Time | DATE |
| status | Status | STRING |
| stop_time | Stop Time | DATE |
| topline_id | Topline ID | STRING |
| updated_time | Updated Time | DATE |