Facebook Source

Renta поддерживает экспорт данных из Facebook в следующие пункты назначения:

  • Google BigQuery
  • Clickhouse
  • SQL Server
  • Google Spreadsheets
  • Google Analytics

Создание интеграции в хранилище данных (DWH)

  1. Перейдите в каталог интеграций;
  2. Выберите Facebook;
  3. Добавьте аккаунт Facebook, в котором находятся необходимые данные;
  4. Выберите добавленный аккаунт Facebook;
  5. Укажите место назначения, в которое вы хотите импортировать данные;
  6. Перейдите на экран настроек и установите необходимую конфигурацию:

Ad account

Рекламный аккаунт, содержащий необходимые для выгрузки данные.

Report type

Тип отчета — состоит из уникального набора параметров и метрик, доступных для выгрузки в DWH. Каждый тип отчета соответствует одноименному методу API Facebook. 

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

Параметры — содержат список параметров и метрик, доступных для экспорта. Укажите необходимые для выгрузки параметры.

В результате Renta создаст таблицу, которая будет содержать данные выбранных параметров. Порядок выбранных параметров в интерфейсе будет соответствовать порядку столбцов таблицы.

Date range type

Диапазон дат — укажите период, за который необходимо экспортировать данные. Вы можете указать любой исторический временной интервал.

Чтобы выбрать необходимое время, введите в поле «From» дату, с которой вы хотите начать выгрузку данных, затем введите дату окончания в поле «To».

Если вы хотите, чтобы данные в таблице обновлялись ежедневно и дополнялись новыми днями, тогда в поле «To» укажите «Yesterday».
Подробная инструкция по работе с диапазоном дат

Integration name

Имя интеграции — при создании интеграции автоматически генерируется её имя. В этом поле вы можете переименовать название интеграции. Разрешены как кириллица, так и латиница, но не более 100 символов.

Название интеграции отображается на странице Integration List.

Table name

Имя таблицы — при создании интеграции автоматически генерируется имя таблицы, которая будет создана в DWH. В этом поле вы можете переименовать её.

Разрешена только латиница, цифры и символ «_».

Update time

Время обновления — вы можете указать любое время обновления, которое вам нужно. Рента обновляет интеграции ежедневно в интервале выбранного часа. 

Обычно наши пользователи выбирают время обновления интеграций рано утром, например, в 5 утра. В этом случае ваша интеграция будет обновляться в период с 5 утра до 6 утра. 

Обновление интеграций происходит по часовому поясу, выбранном в настройках вашего профайла. 

Overwrite period

Период перезаписи данных — это ретроспективное обновление данных за выбранный период.

Например, вы выбираете период перезаписи «Последние 7 дней» — это означает, что все данные за последние 7 дней будут удалены из таблицы и вставлены снова с обновленными данными.

Примечание: данная настройка доступна только в том случае, если был выбран параметр с типом date или dateTime. 

Создание интеграции в Google Spreadsheets

Воспользуйтесь бесплатным расширением, доступным в Google Workspace Marketplace. Для этого:

  1. Установите расширение Renta Spreadsheets Add-on.
  2. Затем зайдите в Google Sheets, и во вкладке Tools выберите Renta, после чего нажмите кнопку Run. 

После чего в правом сайдбаре откроется рабочая область с настройками интеграций. Подробная инструкция по созданию интеграции доступна по данной ссылке. Обратите внимание, что все созданные интеграции в Google Spreadsheets также доступны для управления в веб-версии Renta. 

Структура данных

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