Facebook. Подключение коннектора
Дата:
Шаг 1. Перейдите во вкладку “Источники данных” и нажмите на кнопку “Плюс”.
Шаг 2. В появившемся окне найдите “Facebook” и нажмите кнопку “Добавить”.
Шаг 3. Предоставьте доступ приложению к Вашему аккаунту.
Шаг 4. Отметьте, данные из каких страниц Вы хотите выгружать в приложение”GOOD.BI”.
Шаг 5. Настройте доступы и нажмите кнопку “Готово”.
Шаг 6. Выберите нужный проект в выпадающем списке, затем кликните на "Подключить выбранные".
Описание таблиц в базе данных
Каждый источник данных создает набор таблиц в вашей базе данных
Во вкладках ниже вы сможете найти шаблон имени таблицы и описание создаваемых колонок в таблице
- Costs
- Actions
- Ad parameters
- Adsets parameters
- Campaign params
- Base Reach schema
- Campaign reach
- Campaign Reach by month
- Campaign Reach by week
- Campaign Reach by day
- Ad reach
- Ad Reach by month
- Ad Reach by week
- Ad Reach by day
- Account reach
- Account Reach by month
- Account Reach by week
- Account Reach by day
Название таблицы:
facebook_{}
| Название колонки | Описание |
|---|---|
date |
Date |
campaign_id |
Campaign ID |
ad_id |
Ad ID |
campaign |
Campaign name |
ad_group |
Ad group name |
impressions |
Impressions |
cost |
Costs |
clicks |
Clicks |
inline_link_clicks |
Link clicks |
reach |
Reach |
frequency |
Frequency of views |
video_30_sec_watched_actions |
Number of views 30 sec of video ads |
video_avg_time_watched_actions |
Average video playback time |
video_p100_watched_actions |
Number of times the video was watched at 100% of its length |
video_p75_watched_actions |
Number of times the video was watched at 75% of its length |
video_p50_watched_actions |
Number of times the video was watched at 50% of its length |
video_p25_watched_actions |
Number of times the video was watched at 25% of its length |
video_p95_watched_actions |
Number of times the video was watched at 95% of its length |
video_play_actions |
Number of starts of video ads |
publisher_platform |
Publisher platform |
platform_position |
Platform position |
device_platform |
Device platform |
Название таблицы:
facebook_{}_actions
| Название колонки | Описание |
|---|---|
ad_id |
Ad ID |
ad_name |
Ad name |
campaign_id |
Campaign ID |
campaign_name |
Campaign name |
date |
Date |
action_type |
Action type |
value |
Number of actions performed |
Название таблицы:
facebook_{}_ad_params
| Название колонки | Описание |
|---|---|
ad_id |
Ad ID |
adlabels |
Ad labels |
adset_id |
Ad group ID |
adset_name |
Ad group name |
bid_amount |
Bid amount |
bid_type |
Bid type |
campaign_id |
Campaign ID |
campaign_name |
Campaign name |
status |
Configured ad status (configure_status) will show the value that, was last set, regardless of campaign status, ad group {ACTIVE, PAUSED, DELETED, ARCHIVED} |
created_time |
Date created |
creative_id |
Ad creative ID |
creative_image_url |
Ad creative image URL |
creative_image_urls |
Ad creative image URLs |
creative_image_hash |
Ad creative image hash |
creative_image_name |
Ad creative name |
creative_image_names |
Ad creative image names |
creative_thumbnail_url |
URL for a thumbnail image for this ad creative |
creative_video_name |
List of image URLs (for carousels) |
creative_video_names |
List of video titles |
creative_video_thumbnail_url |
URL for a video thumbnail |
creative_instagram_permalink_url |
URL for a post on Instagram you want to run as an ad |
creative_object_story_spec_link |
Transition link |
creative_link_url |
Ad creative link |
creative_link_urls |
Ad creative links |
creative_object_story_spec_name |
Ad creative title |
creative_object_story_spec_message |
Ad creative text |
creative_url_tags |
Ad creative UTM-tags |
creative_name |
Ad creative name |
creative_title |
Ad creative title |
creative_body |
Ad creative body |
creative_call_to_action_type |
Ad creative button type |
creative_object_type |
Ad creative type |
creative_content_type |
Ad creative content type |
display_sequence |
Ad order (number) in a campaign |
effective_status |
Ad status. It can be effective either because of its status (configure_status), or because of the status of a campaign, group {ACTIVE, P AUSED, DELETED, PENDING_REVIEW, DISAPPROVED, PREAPPROVED, PENDING_BILLING_INFO, CAMPAIGN_PAUSED, ARCHIVED, ADSET_PAUSED, IN_PROCESS, WITH_ISSUES} |
is_autobid |
Is autobid |
last_updated_by_app_id |
ID of the app updated the ad |
name |
Name |
priority |
Priority |
source_ad_id |
Source Ad ID |
source_ad_name |
Source Ad name |
targeting |
Targeting parameters |
updated_time |
Date updated |
audience_id |
Audience ID |
Название таблицы:
facebook_{}_adsets_params
| Название колонки | Описание |
|---|---|
adset_id |
Ad group ID |
adset_name |
Ad group name |
status |
Ad group status |
created_time |
Date created |
updated_time |
Date updated |
start_time |
Start time |
is_dynamic_creative |
Is dynamic creative |
bid_strategy |
Bidding strategy |
campaign_id |
Campaign ID |
campaign_name |
Campaign name |
effective_status |
Ad status. It can be effective either because of its status (configure_status), or because of the status of a campaign, group {ACTIVE, P AUSED, DELETED, PENDING_REVIEW, DISAPPROVED, PREAPPROVED, PENDING_BILLING_INFO, CAMPAIGN_PAUSED, ARCHIVED, ADSET_PAUSED, IN_PROCESS, WITH_ISSUES} |
optimization_goal |
Optimization goal |
optimization_sub_event |
Optimization sub event |
Название таблицы:
facebook_{}_campaign_params
| Название колонки | Описание |
|---|---|
id |
Наш внутренний ид. Не используйте этот столбец |
name |
Campaign name |
status |
Campaign status |
objective |
Campaign objective |
Название таблицы:
facebook_{}_reach_template
| Название колонки | Описание |
|---|---|
date |
First day of the month |
reach |
Reach |
Название таблицы:
facebook_{}_reach_campaign
| Название колонки | Описание |
|---|---|
date |
First day of the month |
reach |
Reach |
campaign_id |
Campaign ID |
Название таблицы:
facebook_{}_reach_month
| Название колонки | Описание |
|---|---|
date |
First day of the month |
reach |
Reach |
campaign_id |
Campaign ID |
Название таблицы:
facebook_{}_reach_week
| Название колонки | Описание |
|---|---|
date |
First day of the month |
reach |
Reach |
campaign_id |
Campaign ID |
Название таблицы:
facebook_{}_reach_day
| Название колонки | Описание |
|---|---|
date |
First day of the month |
reach |
Reach |
campaign_id |
Campaign ID |
Название таблицы:
facebook_{}_reach_ad
| Название колонки | Описание |
|---|---|
date |
First day of the month |
reach |
Reach |
ad_id |
Ad ID |
Название таблицы:
facebook_{}_ad_reach_month
| Название колонки | Описание |
|---|---|
date |
First day of the month |
reach |
Reach |
ad_id |
Ad ID |
Название таблицы:
facebook_{}_ad_reach_week
| Название колонки | Описание |
|---|---|
date |
First day of the month |
reach |
Reach |
ad_id |
Ad ID |
Название таблицы:
facebook_{}_ad_reach_day
| Название колонки | Описание |
|---|---|
date |
First day of the month |
reach |
Reach |
ad_id |
Ad ID |
Название таблицы:
facebook_{}_reach_account
| Название колонки | Описание |
|---|---|
date |
First day of the month |
reach |
Reach |
account_id |
Account ID |
Название таблицы:
facebook_{}_account_reach_month
| Название колонки | Описание |
|---|---|
date |
First day of the month |
reach |
Reach |
account_id |
Account ID |
Название таблицы:
facebook_{}_account_reach_week
| Название колонки | Описание |
|---|---|
date |
First day of the month |
reach |
Reach |
account_id |
Account ID |
Название таблицы:
facebook_{}_account_reach_day
| Название колонки | Описание |
|---|---|
date |
First day of the month |
reach |
Reach |
account_id |
Account ID |