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. 

NameDescription
Statistics_ReportMain report type. Contains data about the costs of an advertising campaign.
Campaign_ReportRetrieves status and settings of ad campaign.
Ad_ReportRetrieves 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. 

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

NameDescriptionType
idUnique ID for an ad creativeSTRING
account_idThe ID number of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billingSTRING
adset_idThe 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 targetingSTRING
bid_amountBid 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_flagWhether to automatically rebalance budgets daily for all the adsets under this campaign.BIT
campaign_idThe unique ID number of the ad campaign you're viewing in reporting. Your campaign contains ad sets and adsSTRING
configured_statusIf this status is PAUSED, all its active ad sets and ads will be paused and have an effective status CAMPAIGN_PAUSEDSTRING
created_timeCreated TimeDATE
preview_shareable_linkA link that enables users to preview ads in different placementsSTRING
effective_statusEffective StatusSTRING
issues_info.levelIndicate level of issue, could be ad set or campaignARRAY(STRING)
issues_info.error_codeError code for the issueARRAY(INTEGER)
issues_info.error_summaryError summary for this ad set with issueARRAY(STRING)
issues_info.error_messageError message for this ad set with issueARRAY(STRING)
issues_info.error_typeIssues for this campaign that prevented it from deliveryingARRAY(STRING)
source_ad_idThe source ad id that this ad is copied fromSTRING
nameCampaign's nameSTRING
statusIf 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 useSTRING
updated_timeUpdated Time. If you update spend_cap, this will not automatically update this fieldDATE
account_currencyCurrency that is used by your ad account.STRING
account_idThe ID number of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing.STRING
account_nameThe name of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing.STRING
ad_idThe unique ID of the ad you're viewing in reporting.STRING
ad_nameThe name of the ad you're viewing in reporting.STRING
adset_idThe 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_nameThe 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_idThe unique ID number of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads.STRING
campaign_nameThe name of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads.STRING
date_startThe start date for your data. This is controlled by the date range you've selected for your reporting viewDATE
dateDate of dataDATE
canvas_avg_view_percentThe 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_timeThe 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
clicksThe number of clicks on your ads.FLOAT
cost_per_estimated_ad_recallersThe 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_clickThe average cost of each inline link clickFLOAT
cost_per_inline_post_engagementThe average cost of each inline post engagementFLOAT
cost_per_action_typeThe average cost of a relevant actionFLOAT
cost_per_unique_clickThe average cost for each unique click (all)FLOAT
cost_per_unique_inline_link_clickThe average cost of each unique inline link clickFLOAT
cpcThe average cost for each click (all)FLOAT
cpmThe average cost for 1,000 impressions.FLOAT
cppThe average cost to reach 1,000 people. This metric is estimatedFLOAT
ctrThe percentage of times people saw your ad and performed a click (all).FLOAT
estimated_ad_recall_rateThe 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
frequencyThe average number of times each person saw your ad. This metric is estimatedFLOAT
impressionsThe number of times your ads were on screen.FLOAT
inline_link_click_ctrThe percentage of time people saw your ads and performed an inline link click.FLOAT
inline_link_clicksThe 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_engagementThe total number of actions that people take involving your ads. Inline post engagements use a fixed 1-day-click attribution window.FLOAT
objectiveThe objective you selected for your campaign. Your objective reflects the goal you want to achieve with your advertising.STRING
reachThe 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_impressionsThe 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_spendThe total amount you've spent so far for your ads showed with social information. (ex: Jane Doe likes this).FLOAT
spendThe estimated total amount of money you've spent on your campaign, ad set or ad during its schedule.FLOAT
total_action_valueThe total value of all conversions attributed to your ads.FLOAT
actionsThe number of actions people took that are attributed to your ads. Actions may include engagement, clicks or conversions.FLOAT
unique_actionsThe number of people who took an action that was attributed to your ads.FLOAT
unique_clicksThe number of people who performed a click (all).FLOAT
unique_ctrThe percentage of people who saw your ad and performed a unique click (all).FLOAT
unique_inline_link_click_ctrThe 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_clicksThe number of people who performed an inline link click.FLOAT
unique_link_clicks_ctrThe percentage of people who saw your ad and performed a link click.FLOAT
app_engagementNumber of times someone generate app_story or engage with content as app_use, app_install, or credit_spent.FLOAT
app_storyFLOAT
commerce_eventThis parameter is entirely deprecated.FLOAT
page_engagementNumber 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.cpaCost per page engagement.FLOAT
page_engagement.uniqueUnique page engagements.FLOAT
page_storyThe number of people who engaged with page stories.FLOAT
post_engagementNumber 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.cpaCost per post engagement.FLOAT
post_engagement.uniqueUnique post engagement.FLOAT
instagram_profile_engagementThe number of people who engaged with instagram profile.FLOAT
post_storyThe number of people who engaged with post stories.FLOAT
offsite_conversionFLOAT
offsite_conversion.cpaThe number of people with offsite conversions.FLOAT
offsite_conversion.uniqueThe estimated number of people with offsite conversions.FLOAT
onsite_conversionThe number of people with onsite conversions.FLOAT
mobile_app_retentionThe number of people who performed mobile app retention.FLOAT
mobile_app_roasThe number of people who generated mobile app purchase ROAS.FLOAT
offsite_engagementFLOAT
offline_conversionNubmer of offline conversions.FLOAT
store_visit_with_dwellThe number of people visited your stores, attributed to your ads with `Dwell time`.FLOAT
add_to_cartThe estimated number of people who added items to their cart.FLOAT
complete_registrationThe estimated number of people who completed registration.FLOAT
purchaseThe estimated number of people who completed at least one purchase.FLOAT
searchThe number of people who searched.FLOAT
view_contentThe number of people who viewed content.FLOAT
initiate_checkoutThe number of people who initiated checkouts.FLOAT
add_payment_infoThe estimated number of people who submitted payment info.FLOAT
add_to_wishlistThe estimated number of people who added items to their wishlist.FLOAT
leadThe estimated number of people with lead events.FLOAT
lead_cpaCost per lead.FLOAT
omni_app_installThe estimated number of completed app installs across all channels.FLOAT
video_30_sec_watched_actionsThe 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_actionsThe number of times your video was watched at 100% of its length, including watches that skipped to this point.FLOAT
video_p95_watched_actionsThe number of times your video was watched at 95% of its length, including watches that skipped to this point.FLOAT
HrefIdentifies sections within a document.STRING
utm_sourceIt's the value of utm parameter that contains the ad URL.STRING
utm_mediumIt's the value of utm parameter that contains the ad URL.STRING
utm_campaignIt's the value of utm parameter that contains the ad URL.STRING
utm_contentIt's the value of utm parameter that contains the ad URL.STRING
utm_termIt's the value of utm parameter that contains the ad URL.STRING
idCampaign's IDSTRING
account_idID of the ad account that owns this campaignSTRING
bid_strategyBid strategy for this campaignSTRING
boosted_object_idThe id of boosted objects.STRING
budget_rebalance_flagWhether to automatically rebalance budgets daily for all the adsets under this campaign.BIT
budget_remainingThe amount of remaining budget.FLOAT
buying_typeBuying typeSTRING
can_create_brand_lift_studyIf we can create a new automated brand lift study for the ad set.BIT
can_use_spend_capWhether the campaign can set the spend capBIT
configured_statusIf 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_timeCreated TimeDATE
daily_budgetThe daily budget of the campaignFLOAT
effective_statusEffective StatusSTRING
issues_info.levelIssues for this campaign that prevented it from deliveryingARRAY(STRING)
issues_info.error_codeIssues for this campaign that prevented it from deliveryingARRAY(INTEGER)
issues_info.error_summaryIssues for this campaign that prevented it from deliveryingARRAY(STRING)
issues_info.error_messageIssues for this campaign that prevented it from deliveryingARRAY(STRING)
issues_info.error_typeIssues for this campaign that prevented it from deliveryingARRAY(STRING)
last_budget_toggling_timeLast budget toggling timeDATE
lifetime_budgetThe lifetime budget of the campaignFLOAT
nameCampaign's nameSTRING
objectiveCampaign's objectiveSTRING
source_campaign_idThe source campaign id that this campaign is copied fromSTRING
spend_capA 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_timeStart TimeDATE
statusStatusSTRING
stop_timeStop TimeDATE
topline_idTopline IDSTRING
updated_timeUpdated TimeDATE