Renta поддерживает экспорт данных из Facebook в следующие пункты назначения:
- Google BigQuery
- Clickhouse
- SQL Server
- Google Spreadsheets
- Google Analytics
Создание интеграции в хранилище данных (DWH)
- Перейдите в каталог интеграций;
- Выберите Facebook;
- Добавьте аккаунт Facebook, в котором находятся необходимые данные;
- Выберите добавленный аккаунт Facebook;
- Укажите место назначения, в которое вы хотите импортировать данные;
- Перейдите на экран настроек и установите необходимую конфигурацию:
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. Для этого:
- Установите расширение Renta Spreadsheets Add-on.
- Затем зайдите в 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 |