Apple Search Ads. Подключение коннектора
Дата:
Шаг 1. Для подключения источника данных Apple Search Ads необходимо скачать API ключи. Для это зайдите в Настройка аккаунта (https://app.searchads.apple.com/cm/app/settings/users).
Шаг 2. В настройках аккаунта в разделе "API" вставьте скопированный из кабинета "GOOD.BI" публичный ключ и нажмите кнопку "Сохранить". Вам будут выданы идентификаторы ключей.
Шаг 3. Укажите выданные идентификаторы в личном кабинете "GOOD.BI". Нажмите на кнопку "Проверить ключи".
Шаг 4. Выберите проект и нажмите кнопку "Подключить выбранные".
Коннектор подключен!
Описание таблиц в базе данных
Каждый источник данных создает набор таблиц в вашей базе данных
Во вкладках ниже вы сможете найти шаблон имени таблицы и описание создаваемых колонок в таблице
Название таблицы:
apple_{}
| Название колонки | Описание |
|---|---|
date |
Date |
campaignId |
Campaign ID |
campaignName |
Campaign Name |
adGroupId |
Ad Group ID |
adGroupCreativeSetId |
Ad Group Creative Set ID |
creativeSetId |
Creative Set ID |
adFormat |
Ad format |
impressions |
Impressions |
taps |
Taps |
installs |
Installs |
newDownloads |
Enumerated app downloads from new users |
redownloads |
Enumerated reinstalls |
latOnInstalls |
installs from users who have Limit Ad Tracking (LAT) in an enabled state on their devices |
ttr |
The tap-through rate (TTR) is the number of times users tap your ad divided by the total impressions your ad receives |
avgCPA |
Average cost-per-acquisition (CPA) is the total spend divided by the number of installs within the same time period. |
avgCPT |
Average cost-per-tap (CPT) is the ratio of spend over taps |
localSpend |
Total spend of a campaign |
conversionRate |
Conversion rate |
Название таблицы:
apple_{}_ad_params
| Название колонки | Описание |
|---|---|
adGroupId |
Ad Group ID |
adGroupName |
Name of the ad group |
adGroupStartTime |
Scheduled start date and time for the ad group |
adGroupEndTime |
Scheduled end date and time for the ad group |
adGroupStatus |
Status of the ad group |
adGroupDeleted |
Indicator of whether the ad group is soft-deleted |
campaignId |
Campaign ID |
campaignName |
Campaign Name |
campaignStartTime |
Campaign Start Time |
campaignEndTime |
Campaign End Time |
campaignStatus |
Campaign status |
campaignDeleted |
Indicator of whether campaign is stopped |
adamId |
Adam ID in App Store |
adChannelType |
Channel type |
Название таблицы:
apple_{}_campaign_params
| Название колонки | Описание |
|---|---|
id |
Наш внутренний ид. Не используйте этот столбец |
adamId |
Your unique App Store app identifier |
adChannelType |
The channel type of an ad in a campaign |
billingEvent |
The type of billing event for a campaign: TAPS, IMPRESSIONS |
name |
The name of the campaign, which is unique within an organization |
orgId |
The identifier of the organization that owns the campaign |
displayStatus |
The status of the campaign: RUNNING, ON_HOLD, PAUSED, DELETED |
deleted |
The indicator of whether the campaign is soft-deleted |
modificationTime |
The date and time of the most recent modification |
creationTime |
The date and time of creation |
servingStatus |
The status of the campaign: RUNNING, NOT_RUNNING |
status |
The user-controlled status: ENABLED, PAUSED |
startTime |
The scheduled start time and date for the campaign |
endTime |
The scheduled stop time and date for the campaign |