Renta
Renta
  • Product
    Product
    • First-party tracking

      Powerful server-side solution for collect and connect customer data

    • Marketing ETL

      Create secure customer’s data pipelines to any data warehouses

    • ETL Add-on for Google Sheets

      The easiest way to collect your marketing data into spreadsheets

  • Resources
    Resources
    • Blog

      Stories on how to use customer data for company growth

    • Documentation

      Learn how to install, set up, and use Renta tools.

  • Pricing
  • Book a demo
  • Sign in
Sign up for free
  • Product
    Product
    • First-party tracking

      Powerful server-side solution for collect and connect customer data

    • Marketing ETL

      Create secure customer’s data pipelines to any data warehouses

    • ETL Add-on for Google Sheets

      The easiest way to collect your marketing data into spreadsheets

  • Resources
    Resources
    • Blog

      Stories on how to use customer data for company growth

    • Documentation

      Learn how to install, set up, and use Renta tools.

  • Pricing
  • Book a demo
  • Sign in
Sign up for free
Renta
Documentation
ETL pipelines
Facebook Ads Source
  • Integration creating in a data warehouse (DWH)
    • Ad account
    • Report type
    • Parameters
    • Data range type
    • Integration name
    • Table name
    • Update time
    • Overwrite period
  • Integration creating in Google Spreadsheets
  • Data Structure

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)

  1. Go to the integrations catalog;

  2. Select Facebook;

  3. Add a Facebook account that has the necessary data;

  4. Choose the added Facebook account;

  5. Specify the destination you want to import the data into;

  6. 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:

  1. Install the extension Renta Spreadsheets Add-on.

  2. Then go to Google Sheets and in the Tools tab select Renta

  3. 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
Product
  • Marketing ETL
  • First-party data streaming
  • ETL Add-on for Google Sheets
Popular data pipelines
  • Salesforce → Bigquery
  • Google Ads → Bigquery
  • Facebook Ads → Bigquery
Resources
  • Blog
  • Documentation
  • Privacy policy
  • [EBOOK] A modern data analytics stack in a post-cookie world
  • Enhanced Ecommerce Tracking via Google Tag Manager
  • Facebook Conversions API: Everything Marketers Need to Know

RENTA CDP LIMITED. All rights reserved.

Language: