Ads Data Hub table schema - Advertisers

Сегмент по интересам

близость
affinity_category string
Категория близости.
affinity_id int
Идентификатор близости.
affinity_name string
Родственное имя.

Возрастная группа

возрастная группа
age_group_id int
Идентификатор возрастной группы.
age_group_name string
Название возрастной группы.

Браузер

браузер
browser_id int
Идентификатор браузера.
browser_name string
Имя браузера.
major_version string
Основная версия браузера (полная версия).
minor_version string
Незначительная версия браузера (инкрементная или десятичная версия).

Город

город
city_id int
Уникальный идентификатор города.
city_name string
Название города.
country_code string
Двухсимвольный код страны.
metro_code string
Код города.

Информация об учетной записи передачи данных Менеджера кампаний 360

cm_dt_account_info
account_id int
Уникальный идентификатор аккаунта.
timezone_name string
Часовой пояс аккаунта.

Передача данных Менеджера кампаний 360 Active View плюс

cm_dt_active_view_plus
event struct
event.active_view_audible_impressions int
Active View: показы Audible
event.active_view_audible_time_msec int
Active View: время воспроизведения со звуком (в миллисекундах)
event.active_view_audible_visible_time_msec int
Active View: время воспроизведения слышимым и видимым (в миллисекундах)
event.active_view_background_count int
Active View: показы в фоновом режиме
event.active_view_complete_viewable_impressions int
Active View: показы, видимые по завершении
event.active_view_eligible_impressions int
Подходил ли показ для измерения видимости. Показ засчитывается, если (а) креатив объявления содержит тег Active View и (б) этот тег успешно взаимодействует с серверами Google Платформа для маркетинга во время показа.
event.active_view_first_quartile_viewable_audible_impressions int
Active View: видимые и слышимые показы в первом квартиле
event.active_view_first_quartile_viewable_impressions int
Active View: видимые показы в первом квартиле
event.active_view_fullscreen_count int
Active View: показы в полноэкранном режиме
event.active_view_impressions_audible_and_visible_at_completion int
Active View: показы слышны и видны по завершении
event.active_view_impressions_visible10_seconds int
Active View: показы в течение 10 секунд
event.active_view_measurable_impressions int
Можно ли было измерить показ с помощью Active View.
event.active_view_midpoint_viewable_audible_impressions int
Active View: видимые и слышимые показы в середине
event.active_view_midpoint_viewable_impressions int
Active View: показы видны в середине
event.active_view_plus_measurable_count int
Active View Plus: отслеживаемые показы
event.active_view_start_viewable_audible_impressions int
Active View: видимые и слышимые показы при запуске
event.active_view_start_viewable_impressions int
Active View: показы, видимые при запуске
event.active_view_third_quartile_viewable_audible_impressions int
Active View: видимые и слышимые показы в третьем квартиле
event.active_view_third_quartile_viewable_impressions int
Active View: видимые показы в третьем квартиле
event.active_view_tos_msec int
Active View: время на экране (в миллисекундах)
event.active_view_viewable_impressions int
Был ли показ видимым.
event.active_view_visible_time_msec int
Active View: время видимости видео (в миллисекундах)
event.activity_count int
Активность Количество
event.activity_id int
Идентификатор тега Floodlight, связанного с событием-конверсией.
event.ad_id int
Уникальный идентификатор рекламного места.
event.advertiser_id int
Уникальный идентификатор рекламодателя
event.browser_platform_id string
ID типа браузера.
event.browser_version string
Версия браузера/платформы
event.campaign_id int
Уникальный идентификатор кампании Менеджера кампаний 360.
event.city_id int
Идентификатор города
event.conversion_id int
Указывает, было ли сопоставлено действие как пост-клик (значение 1), пост-показ (значение 2) или несовпадение (значение 0).
event.country_code string
Страна
event.creative_version string
Номер версии креатива.
event.dma_region_id int
Идентификатор выделенной рыночной зоны (США/Канада).
event.dv360_ad_position int
Определяет позицию объявления на странице, если она известна. 1 — выше сгиба, 2 — ниже сгиба.
event.dv360_advertiser_id int
Числовой идентификатор рекламодателя в Дисплее и Видео 360, связанный с событием, например 164332.
event.dv360_adx_page_categories string
Категории страниц AdX в DV360
event.dv360_attributed_inventory_source_external_id string
Внешний идентификатор атрибутированного источника инвентаря, который Дисплей и Видео 360 выбрал как наиболее подходящий из доступных рекламодателю, связанных с событием просмотра на основе минимальной цены и типа аукциона.
event.dv360_attributed_inventory_source_is_public string
True, если источник инвентаря доступен всем покупателям. Ложь в противном случае.
event.dv360_auction_id string
Строка, используемая для объединения событий между типами просмотр/клик/конверсия, например "ABCDEFGH_abcdefgh-0123456789". Не предполагайте какой-либо порядок, структуру или значение значения аукциона_id.
event.dv360_bid_price_advertiser_currency int
Цена заявки, отправляемая на биржу в нано валюты рекламодателя. Вы можете разделить на 1 000 000 000, чтобы увидеть цену предложения в долларах США. Цена ставки – это значение, которое позиция присваивает показу до корректировки аукциона первой цены. Для позиции с фиксированной ценой за тысячу показов это фиксированная цена за тысячу показов позиции на момент назначения ставки. Несмотря на то, что ставка отправляется на биржи как значение CPM, цена ставки представлена ​​в виде цены за показ для согласованности с другими показателями.
event.dv360_bid_price_partner_currency int
Цена предложения отправляется на биржу в нано валюты партнера. Вы можете разделить на 1 000 000 000, чтобы увидеть цену предложения в долларах США. Цена ставки – это значение, которое позиция присваивает показу до корректировки аукциона первой цены. Для позиции с фиксированной ценой за тысячу показов это фиксированная цена за тысячу показов позиции на момент назначения ставки. Несмотря на то, что ставка отправляется на биржи как значение CPM, цена ставки представлена ​​в виде цены за показ для согласованности с другими показателями.
event.dv360_bid_price_usd int
Цена предложения, отправленная на биржу в нанодолларах США. Вы можете разделить на 1 000 000 000, чтобы увидеть цену предложения в долларах США. Цена ставки – это значение, которое позиция присваивает показу до корректировки аукциона первой цены. Для позиции с фиксированной ценой за тысячу показов это фиксированная цена за тысячу показов позиции на момент назначения ставки. Несмотря на то, что ставка отправляется на биржи как значение CPM, цена ставки представлена ​​в виде цены за показ для согласованности с другими показателями.
event.dv360_billable_cost_advertiser_currency int
Общая сумма денег, выставленная партнеру, включая стоимость рекламы и расходы партнера, в валюте рекламодателя в нано.
event.dv360_billable_cost_partner_currency int
Общая сумма денег, выставленная партнеру, включая стоимость рекламы и расходы партнера, в валюте партнера в нано.
event.dv360_billable_cost_usd int
Общая сумма денег, выставленная партнеру, включая стоимость рекламы и расходы партнера, в нанодолларах США.
event.dv360_browser_timezone_offset_minutes int
Разница в минутах между активным часовым поясом в браузере пользователя и GMT-12, например 1320, представляет собой часовой пояс браузера GMT+10.
event.dv360_campaign_id int
Уникальный идентификатор связанной кампании Display & Video 360.
event.dv360_city_id int
Числовой идентификатор Display & Video 360, определяющий наиболее вероятный город показа.
event.dv360_country_code string
Двухбуквенный код страны ISO 3166-1, определяющий наиболее вероятную страну показа, например «США».
event.dv360_cpm_fee_1_advertiser_currency int
event.dv360_cpm_fee_1_partner_currency int
event.dv360_cpm_fee_1_usd int
event.dv360_cpm_fee_2_advertiser_currency int
event.dv360_cpm_fee_2_partner_currency int
event.dv360_cpm_fee_2_usd int
event.dv360_cpm_fee_3_advertiser_currency int
event.dv360_cpm_fee_3_partner_currency int
event.dv360_cpm_fee_3_usd int
event.dv360_cpm_fee_4_advertiser_currency int
event.dv360_cpm_fee_4_partner_currency int
event.dv360_cpm_fee_4_usd int
event.dv360_cpm_fee_5_advertiser_currency int
event.dv360_cpm_fee_5_partner_currency int
event.dv360_cpm_fee_5_usd int
event.dv360_creative_id int
Числовой идентификатор в Дисплее и Видео 360 для креатива, связанного с событием, например 367487.
event.dv360_data_fees_advertiser_currency int
event.dv360_data_fees_partner_currency int
event.dv360_data_fees_usd int
event.dv360_device_type int
Числовое значение идентифицированного типа устройства. 0 = компьютер, 1 = другое, 2 = смартфон, 3 = планшет, 4 = Smart TV, 5 = подключенный телевизор, 6 = телевизионная приставка, 7 = подключенное устройство.
event.dv360_exchange_id string
Числовой идентификатор Display & Video 360 для аукциона, запросившего рекламу.
event.dv360_insertion_order_id int
Числовой идентификатор заказа на размещение в Дисплее и Видео 360, связанного с событием, например 1079941.
event.dv360_isp_id int
Числовой идентификатор в Дисплее и Видео 360 наиболее вероятного поставщика услуг Интернета для показа. Это значение может отсутствовать.
event.dv360_language string
Код ISO-639-1 или «zh_CN» (китайский (упрощенный)), «zh_TW» (китайский (традиционный)) или «другой», представляющий язык, связанный с событием просмотра.
event.dv360_line_item_id int
Числовой идентификатор в Display & Video 360 для позиции, связанной с событием, например 1155785.
event.dv360_matching_targeted_keywords string
Строка, разделенная запятыми, содержащая список целевых ключевых слов, соответствующих странице, связанной с событием просмотра, например "яблоко, апельсин, банан". Хотя страница, связанная с событием просмотра, может соответствовать многим ключевым словам, будут включены только те, на которые был направлен таргетинг; если список ключевых слов большой, мы можем установить ограничение на количество возвращаемых ключевых слов.
event.dv360_matching_targeted_segments string
Разделенные пробелом идентификаторы целевых списков пользователей, которые соответствуют посетителю, например "-4 456". Если посетитель находится в списке пользователей, на которого не нацелена реклама, связанная с этим событием, он не будет включен сюда.
event.dv360_media_cost_advertiser_currency int
Сумма, уплаченная за показ в нано валюты рекламодателя, вы можете разделить на 1 000 000 000, чтобы увидеть ее в валюте. Это значение может быть равно нулю.
event.dv360_media_cost_partner_currency int
Сумма, уплаченная за показ в нано валюте партнера, вы можете разделить на 1 000 000 000, чтобы увидеть ее в валюте. Это значение может быть равно нулю.
event.dv360_media_cost_usd int
Сумма, уплаченная за показ в нано долларах США, вы можете разделить на 1 000 000 000, чтобы увидеть ее в валюте. Это значение может быть равно нулю.
event.dv360_media_fee_1_advertiser_currency int
event.dv360_media_fee_1_partner_currency int
event.dv360_media_fee_1_usd int
event.dv360_media_fee_2_advertiser_currency int
event.dv360_media_fee_2_partner_currency int
event.dv360_media_fee_2_usd int
event.dv360_media_fee_3_advertiser_currency int
event.dv360_media_fee_3_partner_currency int
event.dv360_media_fee_3_usd int
event.dv360_media_fee_4_advertiser_currency int
event.dv360_media_fee_4_partner_currency int
event.dv360_media_fee_4_usd int
event.dv360_media_fee_5_advertiser_currency int
event.dv360_media_fee_5_partner_currency int
event.dv360_media_fee_5_usd int
event.dv360_mobile_make_id int
Числовой идентификатор производителя мобильного телефона. Это значение может отсутствовать.
event.dv360_mobile_model_id int
Числовой идентификатор мобильной модели. Это значение может отсутствовать.
event.dv360_net_speed int
Числовой идентификатор Display & Video 360, представляющий скорость сети, связанную с событием просмотра. 1=Коммутируемый доступ, 2=EDGE/2G, 3=UMTS/3G, 4=Базовый DSL, 5=HSDPA/3.5G, 6=Широкополосный/4G, 7=Неизвестно.
event.dv360_operating_system_id int
Идентификатор операционной системы.
event.dv360_request_time int
Временная метка Unix в микросекундах (1/1 000 000 секунды), указывающая, когда мы получили запрос объявления, например, 1330403779608570 представляет вторник, 28 февраля 2012 г., 04:36:19.608570. Несмотря на то, что это значение одинаково для всех представлений, кликов и конверсий, даже оно не может быть уникальным — используйте аукционный идентификатор для присоединения к событиям.
event.dv360_revenue_advertiser_currency int
Общая сумма в нано в валюте рекламодателя, внесенная партнерским аккаунтом за событие просмотра. Это значение может быть равно нулю.
event.dv360_revenue_partner_currency int
Общая сумма в валюте партнера в нано, внесенная партнерским аккаунтом за событие просмотра. Это значение может быть равно нулю.
event.dv360_revenue_usd int
Общая сумма в нанодолларах США, внесенная партнерским счетом за событие просмотра. Это значение может быть равно нулю.
event.dv360_site_id int
Числовой идентификатор в Дисплее и Видео 360 для наиболее конкретного универсального сайта, который соответствует URL.
event.dv360_state_region_id int
Идентификатор региона DV360
event.dv360_url string
Необработанный URL-адрес, взятый из запроса ставки, полученного от биржи, например "http://www.example.com". Поскольку некоторые биржи маскируют URL-адрес в своих запросах ставок, это значение может быть: «source_url_hidden».
event.dv360_view_state string
Заполняется для обернутых тегов. (Две записи о показах, когда происходят оба события.) Возможные значения: "ВНЕШНИЙ", DV360 возвращает завернутый тег; "ВНУТРЕННЯЯ", тег объявления, обернутый в публикацию; "3PAS_MERGED", обернутый тег, отслеживаемый CM; "3PAS_OUTER", отслеживание ping отправлено в CM, но нет ответа, третья сторона заблокировала показ рекламы.
event.dv360_zip_postal_code string
DV360 Почтовый индекс
event.event_sub_type string
Содержит дополнительную информацию, связанную с событием — это «VIEW» и «CLICK» для событий просмотра и нажатия, но может быть «POSTVIEW», «POSTCLICK» или пустым для событий конверсии.
event.event_time int
Время в микросекундах с 01 января 1970 г. 00:00:00 UTC.
event.event_type string
Содержит "VIDEO_ACTIVE_VIEW_SESSION".
event.floodlight_config_id int
Уникальный идентификатор конфигурации Floodlight.
event.impression_id string
Идентификатор показа
event.interaction_time_utc_seconds string
Время взаимодействия
event.landing_page_url_id int
Уникальный идентификатор URL целевой страницы.
event.operating_system_id int
ID операционной системы.
event.ord_value string
Порядковый идентификатор рекламодателя, если он соответствует данному типу активности. Передается в паре "ключ-значение" ord= (также используется для хранения идентификатора заказа клиента в тегах продаж)
event.other_data string
Сохраняет данные пары "ключ-значение" из строки действия, которая не помечена иным образом. (Любая пара "ключ-значение", которая НЕ является "src=", "type=", "cat=", "ord=", "u=", "cost=", "qty=", "tran=", "a =" или "b="). (Можно использовать для дальнейшей разбивки продукта, также известной как «Пользовательские переменные Floodlight»)
event.placement_id int
Уникальный идентификатор страницы сайта/места размещения, на котором показывалось объявление.
event.platform_type_id int
Идентификатор, который сопоставляется с платформой, на которой произошло событие. Возможные значения: 30000: настольный компьютер, 30001: смартфон высокого класса, 30002: планшет, 30003: смартфон среднего класса, 30004: подключенный телевизор, 30005: неизвестно, 30006: телевизионная приставка.
event.rendering_id int
Уникальный идентификатор креатива для передачи данных. Не соответствует UI-Creative-ID.
event.rich_media_event_counters int
Значение счетчика MET (значение ecn=).
event.rich_media_event_id int
Идентификатор события MET для мультимедийной рекламы.
event.rich_media_event_timers double
Время в микросекундах с 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_id int
Идентификатор типа мультимедийного события.
event.segment_value_1 int
Значение сегмента 1
event.site_id int
Уникальный идентификатор сайта, на котором показывалась реклама.
event.state string
Идентификатор штата или провинции пользователя (США/Канада)
event.tran_value string
Значение ТРАН
event.u_value string
U Значение
event.zip_code string
Почтовый индекс (США/Канада).
network_id int
Идентификатор сети.
user_id opaque
Идентификатор отслеживания (он основан на файлах cookie браузера пользователя или идентификаторе мобильного устройства, но не раскрывает их). Это поле может быть обнулено по соображениям конфиденциальности. Идентификаторы пользователей поддерживают подсчет и объединение (между таблицами в ADH). Их нельзя экспортировать или преобразовать как обычные типы данных.

Действия по передаче данных в Менеджере кампаний 360 (устарело)

cm_dt_activities
device_id_md5 string
ID устройства, хешированный MD5; может быть предоставлена ​​утилита для сопоставления необработанных идентификаторов устройств.
event struct
event.active_view_audible_impressions int
Active View: показы Audible
event.active_view_audible_time_msec int
Active View: время воспроизведения со звуком (в миллисекундах)
event.active_view_audible_visible_time_msec int
Active View: время воспроизведения слышимым и видимым (в миллисекундах)
event.active_view_background_count int
Active View: показы в фоновом режиме
event.active_view_complete_viewable_impressions int
Active View: показы, видимые по завершении
event.active_view_eligible_impressions int
Подходил ли показ для измерения видимости. Показ засчитывается, если (а) креатив объявления содержит тег Active View и (б) этот тег успешно взаимодействует с серверами Google Платформа для маркетинга во время показа.
event.active_view_first_quartile_viewable_audible_impressions int
Active View: видимые и слышимые показы в первом квартиле
event.active_view_first_quartile_viewable_impressions int
Active View: видимые показы в первом квартиле
event.active_view_fullscreen_count int
Active View: показы в полноэкранном режиме
event.active_view_impressions_audible_and_visible_at_completion int
Active View: показы слышны и видны по завершении
event.active_view_impressions_visible10_seconds int
Active View: показы в течение 10 секунд
event.active_view_measurable_impressions int
Можно ли было измерить показ с помощью Active View.
event.active_view_midpoint_viewable_audible_impressions int
Active View: видимые и слышимые показы в середине
event.active_view_midpoint_viewable_impressions int
Active View: показы видны в середине
event.active_view_plus_measurable_count int
Active View Plus: отслеживаемые показы
event.active_view_start_viewable_audible_impressions int
Active View: видимые и слышимые показы при запуске
event.active_view_start_viewable_impressions int
Active View: показы, видимые при запуске
event.active_view_third_quartile_viewable_audible_impressions int
Active View: видимые и слышимые показы в третьем квартиле
event.active_view_third_quartile_viewable_impressions int
Active View: видимые показы в третьем квартиле
event.active_view_tos_msec int
Active View: время на экране (в миллисекундах)
event.active_view_viewable_impressions int
Был ли показ видимым.
event.active_view_visible_time_msec int
Active View: время видимости видео (в миллисекундах)
event.activity_count int
Активность Количество
event.activity_id int
Идентификатор тега Floodlight, связанного с событием-конверсией.
event.activity_revenue double
Доход от деятельности
event.ad_id int
Уникальный идентификатор рекламного места.
event.advertiser_id int
Уникальный идентификатор рекламодателя
event.browser_platform_id string
ID типа браузера.
event.browser_version string
Версия браузера/платформы
event.campaign_id int
Уникальный идентификатор кампании Менеджера кампаний 360.
event.city_id int
Идентификатор города
event.conversion_id int
Указывает, было ли сопоставлено действие как пост-клик (значение 1), пост-показ (значение 2) или несовпадение (значение 0).
event.country_code string
Страна
event.creative_version string
Номер версии креатива.
event.dma_region_id int
Идентификатор выделенной рыночной зоны (США/Канада).
event.dv360_ad_position int
Определяет позицию объявления на странице, если она известна. 1 — выше сгиба, 2 — ниже сгиба.
event.dv360_advertiser_id int
Числовой идентификатор рекламодателя в Дисплее и Видео 360, связанный с событием, например 164332.
event.dv360_adx_page_categories string
Категории страниц AdX в DV360
event.dv360_attributed_inventory_source_external_id string
Внешний идентификатор атрибутированного источника инвентаря, который Дисплей и Видео 360 выбрал как наиболее подходящий из доступных рекламодателю, связанных с событием просмотра на основе минимальной цены и типа аукциона.
event.dv360_attributed_inventory_source_is_public string
True, если источник инвентаря доступен всем покупателям. Ложь в противном случае.
event.dv360_auction_id string
Строка, используемая для объединения событий между типами просмотр/клик/конверсия, например "ABCDEFGH_abcdefgh-0123456789". Не предполагайте какой-либо порядок, структуру или значение значения аукциона_id.
event.dv360_bid_price_advertiser_currency int
Цена заявки, отправляемая на биржу в нано валюты рекламодателя. Вы можете разделить на 1 000 000 000, чтобы увидеть цену предложения в долларах США. Цена ставки – это значение, которое позиция присваивает показу до корректировки аукциона первой цены. Для позиции с фиксированной ценой за тысячу показов это фиксированная цена за тысячу показов позиции на момент назначения ставки. Несмотря на то, что ставка отправляется на биржи как значение CPM, цена ставки представлена ​​в виде цены за показ для согласованности с другими показателями.
event.dv360_bid_price_partner_currency int
Цена предложения отправляется на биржу в нано валюты партнера. Вы можете разделить на 1 000 000 000, чтобы увидеть цену предложения в долларах США. Цена ставки – это значение, которое позиция присваивает показу до корректировки аукциона первой цены. Для позиции с фиксированной ценой за тысячу показов это фиксированная цена за тысячу показов позиции на момент назначения ставки. Несмотря на то, что ставка отправляется на биржи как значение CPM, цена ставки представлена ​​в виде цены за показ для согласованности с другими показателями.
event.dv360_bid_price_usd int
Цена предложения, отправленная на биржу в нанодолларах США. Вы можете разделить на 1 000 000 000, чтобы увидеть цену предложения в долларах США. Цена ставки – это значение, которое позиция присваивает показу до корректировки аукциона первой цены. Для позиции с фиксированной ценой за тысячу показов это фиксированная цена за тысячу показов позиции на момент назначения ставки. Несмотря на то, что ставка отправляется на биржи как значение CPM, цена ставки представлена ​​в виде цены за показ для согласованности с другими показателями.
event.dv360_billable_cost_advertiser_currency int
Общая сумма денег, выставленная партнеру, включая стоимость рекламы и расходы партнера, в валюте рекламодателя в нано.
event.dv360_billable_cost_partner_currency int
Общая сумма денег, выставленная партнеру, включая стоимость рекламы и расходы партнера, в валюте партнера в нано.
event.dv360_billable_cost_usd int
Общая сумма денег, выставленная партнеру, включая стоимость рекламы и расходы партнера, в нанодолларах США.
event.dv360_browser_id int
Числовой идентификатор Display & Video 360, идентифицирующий браузер, связанный с этим событием.
event.dv360_browser_timezone_offset_minutes int
Разница в минутах между активным часовым поясом в браузере пользователя и GMT-12, например 1320, представляет собой часовой пояс браузера GMT+10.
event.dv360_campaign_id int
Уникальный идентификатор связанной кампании Display & Video 360.
event.dv360_city_id int
Числовой идентификатор Display & Video 360, определяющий наиболее вероятный город показа.
event.dv360_country_code string
Двухбуквенный код страны ISO 3166-1, определяющий наиболее вероятную страну показа, например «США».
event.dv360_cpm_fee_1_advertiser_currency int
event.dv360_cpm_fee_1_partner_currency int
event.dv360_cpm_fee_1_usd int
event.dv360_cpm_fee_2_advertiser_currency int
event.dv360_cpm_fee_2_partner_currency int
event.dv360_cpm_fee_2_usd int
event.dv360_cpm_fee_3_advertiser_currency int
event.dv360_cpm_fee_3_partner_currency int
event.dv360_cpm_fee_3_usd int
event.dv360_cpm_fee_4_advertiser_currency int
event.dv360_cpm_fee_4_partner_currency int
event.dv360_cpm_fee_4_usd int
event.dv360_cpm_fee_5_advertiser_currency int
event.dv360_cpm_fee_5_partner_currency int
event.dv360_cpm_fee_5_usd int
event.dv360_creative_id int
Числовой идентификатор в Дисплее и Видео 360 для креатива, связанного с событием, например 367487.
event.dv360_data_fees_advertiser_currency int
event.dv360_data_fees_partner_currency int
event.dv360_data_fees_usd int
event.dv360_device_type int
Числовое значение идентифицированного типа устройства. 0 = компьютер, 1 = другое, 2 = смартфон, 3 = планшет, 4 = Smart TV, 5 = подключенный телевизор, 6 = телевизионная приставка, 7 = подключенное устройство.
event.dv360_exchange_id string
Числовой идентификатор Display & Video 360 для аукциона, запросившего рекламу.
event.dv360_insertion_order_id int
Числовой идентификатор заказа на размещение в Дисплее и Видео 360, связанного с событием, например 1079941.
event.dv360_isp_id int
Числовой идентификатор в Дисплее и Видео 360 наиболее вероятного поставщика услуг Интернета для показа. Это значение может отсутствовать.
event.dv360_language string
Код ISO-639-1 или «zh_CN» (китайский (упрощенный)), «zh_TW» (китайский (традиционный)) или «другой», представляющий язык, связанный с событием просмотра.
event.dv360_line_item_id int
Числовой идентификатор в Display & Video 360 для позиции, связанной с событием, например 1155785.
event.dv360_matching_targeted_keywords string
Строка, разделенная запятыми, содержащая список целевых ключевых слов, соответствующих странице, связанной с событием просмотра, например "яблоко, апельсин, банан". Хотя страница, связанная с событием просмотра, может соответствовать многим ключевым словам, будут включены только те, на которые был направлен таргетинг; если список ключевых слов большой, мы можем установить ограничение на количество возвращаемых ключевых слов.
event.dv360_matching_targeted_segments string
Разделенные пробелом идентификаторы целевых списков пользователей, которые соответствуют посетителю, например "-4 456". Если посетитель находится в списке пользователей, на которого не нацелена реклама, связанная с этим событием, он не будет включен сюда.
event.dv360_media_cost_advertiser_currency int
Сумма, уплаченная за показ в нано валюты рекламодателя, вы можете разделить на 1 000 000 000, чтобы увидеть ее в валюте. Это значение может быть равно нулю.
event.dv360_media_cost_partner_currency int
Сумма, уплаченная за показ в нано валюте партнера, вы можете разделить на 1 000 000 000, чтобы увидеть ее в валюте. Это значение может быть равно нулю.
event.dv360_media_cost_usd int
Сумма, уплаченная за показ в нано долларах США, вы можете разделить на 1 000 000 000, чтобы увидеть ее в валюте. Это значение может быть равно нулю.
event.dv360_media_fee_1_advertiser_currency int
event.dv360_media_fee_1_partner_currency int
event.dv360_media_fee_1_usd int
event.dv360_media_fee_2_advertiser_currency int
event.dv360_media_fee_2_partner_currency int
event.dv360_media_fee_2_usd int
event.dv360_media_fee_3_advertiser_currency int
event.dv360_media_fee_3_partner_currency int
event.dv360_media_fee_3_usd int
event.dv360_media_fee_4_advertiser_currency int
event.dv360_media_fee_4_partner_currency int
event.dv360_media_fee_4_usd int
event.dv360_media_fee_5_advertiser_currency int
event.dv360_media_fee_5_partner_currency int
event.dv360_media_fee_5_usd int
event.dv360_mobile_make_id int
Числовой идентификатор производителя мобильного телефона. Это значение может отсутствовать.
event.dv360_mobile_model_id int
Числовой идентификатор мобильной модели. Это значение может отсутствовать.
event.dv360_net_speed int
Числовой идентификатор Display & Video 360, представляющий скорость сети, связанную с событием просмотра. 1=Коммутируемый доступ, 2=EDGE/2G, 3=UMTS/3G, 4=Базовый DSL, 5=HSDPA/3.5G, 6=Широкополосный/4G, 7=Неизвестно.
event.dv360_operating_system_id int
Идентификатор операционной системы.
event.dv360_request_time int
Временная метка Unix в микросекундах (1/1 000 000 секунды), указывающая, когда мы получили запрос объявления, например, 1330403779608570 представляет вторник, 28 февраля 2012 г., 04:36:19.608570. Несмотря на то, что это значение одинаково для всех представлений, кликов и конверсий, даже оно не может быть уникальным — используйте аукционный идентификатор для присоединения к событиям.
event.dv360_revenue_advertiser_currency int
Общая сумма в нано в валюте рекламодателя, внесенная партнерским аккаунтом за событие просмотра. Это значение может быть равно нулю.
event.dv360_revenue_partner_currency int
Общая сумма в валюте партнера в нано, внесенная партнерским аккаунтом за событие просмотра. Это значение может быть равно нулю.
event.dv360_revenue_usd int
Общая сумма в нанодолларах США, внесенная партнерским счетом за событие просмотра. Это значение может быть равно нулю.
event.dv360_site_id int
Числовой идентификатор в Дисплее и Видео 360 для наиболее конкретного универсального сайта, который соответствует URL.
event.dv360_state_region_id int
Идентификатор региона DV360
event.dv360_url string
Необработанный URL-адрес, взятый из запроса ставки, полученного от биржи, например "http://www.example.com". Поскольку некоторые биржи маскируют URL-адрес в своих запросах ставок, это значение может быть: «source_url_hidden».
event.dv360_view_state string
Заполняется для обернутых тегов. (Две записи о показах, когда происходят оба события.) Возможные значения: "ВНЕШНИЙ", DV360 возвращает завернутый тег; "ВНУТРЕННЯЯ", тег объявления, обернутый в публикацию; "3PAS_MERGED", обернутый тег, отслеживаемый CM; "3PAS_OUTER", отслеживание ping отправлено в CM, но нет ответа, третья сторона заблокировала показ рекламы.
event.dv360_zip_postal_code string
DV360 Почтовый индекс
event.event_sub_type string
Содержит дополнительную информацию, связанную с событием — это «VIEW» и «CLICK» для событий просмотра и нажатия, но может быть «POSTVIEW», «POSTCLICK» или пустым для событий конверсии.
event.event_time int
Время в микросекундах с 01 января 1970 г. 00:00:00 UTC.
event.event_type string
Содержит сведения, связанные с событием. Это "ПРОСМОТР" и "КЛИК" для событий просмотра и клика, но может быть "КОНВЕРСИЯ" или пустое значение для событий конверсии.
event.floodlight_config_id int
Уникальный идентификатор конфигурации Floodlight.
event.impression_id string
Идентификатор показа
event.interaction_time_utc_seconds string
Время взаимодействия
event.landing_page_url_id int
Уникальный идентификатор URL целевой страницы.
event.operating_system_id int
ID операционной системы.
event.ord_value string
Порядковый идентификатор рекламодателя, если он соответствует данному типу активности. Передается в паре "ключ-значение" ord= (также используется для хранения идентификатора заказа клиента в тегах продаж)
event.other_data string
Сохраняет данные пары "ключ-значение" из строки действия, которая не помечена иным образом. (Любая пара "ключ-значение", которая НЕ является "src=", "type=", "cat=", "ord=", "u=", "cost=", "qty=", "tran=", "a =" или "b="). (Можно использовать для дальнейшей разбивки продукта, также известной как «Пользовательские переменные Floodlight»)
event.placement_id int
Уникальный идентификатор страницы сайта/места размещения, на котором показывалось объявление.
event.rendering_id int
Уникальный идентификатор креатива для передачи данных. Не соответствует UI-Creative-ID.
event.rich_media_event_counters int
Значение счетчика MET (значение ecn=).
event.rich_media_event_id int
Идентификатор события MET для мультимедийной рекламы.
event.rich_media_event_timers double
Время в микросекундах с 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_id int
Идентификатор типа мультимедийного события.
event.segment_value_1 int
Значение сегмента 1
event.site_id int
Уникальный идентификатор сайта, на котором показывалась реклама.
event.state string
Идентификатор штата или провинции пользователя (США/Канада)
event.tran_value string
Значение ТРАН
event.u_value string
U Значение
event.zip_code string
Почтовый индекс (США/Канада).
network_id int
Идентификатор сети.
user_id opaque
Идентификатор отслеживания (он основан на файлах cookie браузера пользователя или идентификаторе мобильного устройства, но не раскрывает их). Это поле может быть обнулено по соображениям конфиденциальности. Идентификаторы пользователей поддерживают подсчет и объединение (между таблицами в ADH). Их нельзя экспортировать или преобразовать как обычные типы данных.

Атрибуция действий по передаче данных Менеджера кампаний 360

cm_dt_activities_attributed
event struct
event.activity_id int
Идентификатор тега Floodlight, связанного с событием-конверсией.
event.ad_id int
Уникальный идентификатор рекламного места.
event.advertiser_id int
Уникальный идентификатор рекламодателя
event.attribution_model_config_id int
Идентификатор модели атрибуции, отображаемый в пользовательском интерфейсе CM.
event.browser_platform_id string
ID типа браузера.
event.browser_version string
Версия браузера/платформы
event.campaign_id int
Уникальный идентификатор кампании Менеджера кампаний 360.
event.city_id int
Идентификатор города
event.conversion_event_id string
Уникальный идентификатор события-конверсии.
event.country_code string
Страна
event.creative_version string
Номер версии креатива.
event.dma_region_id int
Идентификатор выделенной рыночной зоны (США/Канада).
event.dv360_ad_position int
Определяет позицию объявления на странице, если она известна. 1 — выше сгиба, 2 — ниже сгиба.
event.dv360_advertiser_id int
Числовой идентификатор рекламодателя в Дисплее и Видео 360, связанный с событием, например 164332.
event.dv360_adx_page_categories string
Категории страниц AdX в DV360
event.dv360_attributed_inventory_source_external_id string
Внешний идентификатор атрибутированного источника инвентаря, который Дисплей и Видео 360 выбрал как наиболее подходящий из доступных рекламодателю, связанных с событием просмотра на основе минимальной цены и типа аукциона.
event.dv360_attributed_inventory_source_is_public string
True, если источник инвентаря доступен всем покупателям. Ложь в противном случае.
event.dv360_auction_id string
Строка, используемая для объединения событий между типами просмотр/клик/конверсия, например "ABCDEFGH_abcdefgh-0123456789". Не предполагайте какой-либо порядок, структуру или значение значения аукциона_id.
event.dv360_bid_price_advertiser_currency int
Цена заявки, отправляемая на биржу в нано валюты рекламодателя. Вы можете разделить на 1 000 000 000, чтобы увидеть цену предложения в долларах США. Цена ставки – это значение, которое позиция присваивает показу до корректировки аукциона первой цены. Для позиции с фиксированной ценой за тысячу показов это фиксированная цена за тысячу показов позиции на момент назначения ставки. Несмотря на то, что ставка отправляется на биржи как значение CPM, цена ставки представлена ​​в виде цены за показ для согласованности с другими показателями.
event.dv360_bid_price_partner_currency int
Цена предложения отправляется на биржу в нано валюты партнера. Вы можете разделить на 1 000 000 000, чтобы увидеть цену предложения в долларах США. Цена ставки – это значение, которое позиция присваивает показу до корректировки аукциона первой цены. Для позиции с фиксированной ценой за тысячу показов это фиксированная цена за тысячу показов позиции на момент назначения ставки. Несмотря на то, что ставка отправляется на биржи как значение CPM, цена ставки представлена ​​в виде цены за показ для согласованности с другими показателями.
event.dv360_bid_price_usd int
Цена предложения, отправленная на биржу в нанодолларах США. Вы можете разделить на 1 000 000 000, чтобы увидеть цену предложения в долларах США. Цена ставки – это значение, которое позиция присваивает показу до корректировки аукциона первой цены. Для позиции с фиксированной ценой за тысячу показов это фиксированная цена за тысячу показов позиции на момент назначения ставки. Несмотря на то, что ставка отправляется на биржи как значение CPM, цена ставки представлена ​​в виде цены за показ для согласованности с другими показателями.
event.dv360_billable_cost_advertiser_currency int
Общая сумма денег, выставленная партнеру, включая стоимость рекламы и расходы партнера, в валюте рекламодателя в нано.
event.dv360_billable_cost_partner_currency int
Общая сумма денег, выставленная партнеру, включая стоимость рекламы и расходы партнера, в валюте партнера в нано.
event.dv360_billable_cost_usd int
Общая сумма денег, выставленная партнеру, включая стоимость рекламы и расходы партнера, в нанодолларах США.
event.dv360_browser_id int
Числовой идентификатор Display & Video 360, идентифицирующий браузер, связанный с этим событием.
event.dv360_browser_timezone_offset_minutes int
Разница в минутах между активным часовым поясом в браузере пользователя и GMT-12, например 1320, представляет собой часовой пояс браузера GMT+10.
event.dv360_campaign_id int
Уникальный идентификатор связанной кампании Display & Video 360.
event.dv360_city_id int
Числовой идентификатор Display & Video 360, определяющий наиболее вероятный город показа.
event.dv360_country_code string
Двухбуквенный код страны ISO 3166-1, определяющий наиболее вероятную страну показа, например «США».
event.dv360_cpm_fee_1_advertiser_currency int
event.dv360_cpm_fee_1_partner_currency int
event.dv360_cpm_fee_1_usd int
event.dv360_cpm_fee_2_advertiser_currency int
event.dv360_cpm_fee_2_partner_currency int
event.dv360_cpm_fee_2_usd int
event.dv360_cpm_fee_3_advertiser_currency int
event.dv360_cpm_fee_3_partner_currency int
event.dv360_cpm_fee_3_usd int
event.dv360_cpm_fee_4_advertiser_currency int
event.dv360_cpm_fee_4_partner_currency int
event.dv360_cpm_fee_4_usd int
event.dv360_cpm_fee_5_advertiser_currency int
event.dv360_cpm_fee_5_partner_currency int
event.dv360_cpm_fee_5_usd int
event.dv360_creative_id int
Числовой идентификатор в Дисплее и Видео 360 для креатива, связанного с событием, например 367487.
event.dv360_data_fees_advertiser_currency int
event.dv360_data_fees_partner_currency int
event.dv360_data_fees_usd int
event.dv360_device_type int
Числовое значение идентифицированного типа устройства. 0 = компьютер, 1 = другое, 2 = смартфон, 3 = планшет, 4 = Smart TV, 5 = подключенный телевизор, 6 = телевизионная приставка, 7 = подключенное устройство.
event.dv360_exchange_id string
Числовой идентификатор Display & Video 360 для аукциона, запросившего рекламу.
event.dv360_insertion_order_id int
Числовой идентификатор заказа на размещение в Дисплее и Видео 360, связанного с событием, например 1079941.
event.dv360_isp_id int
Числовой идентификатор в Дисплее и Видео 360 наиболее вероятного поставщика услуг Интернета для показа. Это значение может отсутствовать.
event.dv360_language string
Код ISO-639-1 или «zh_CN» (китайский (упрощенный)), «zh_TW» (китайский (традиционный)) или «другой», представляющий язык, связанный с событием просмотра.
event.dv360_line_item_id int
Числовой идентификатор в Display & Video 360 для позиции, связанной с событием, например 1155785.
event.dv360_matching_targeted_keywords string
Строка, разделенная запятыми, содержащая список целевых ключевых слов, соответствующих странице, связанной с событием просмотра, например "яблоко, апельсин, банан". Хотя страница, связанная с событием просмотра, может соответствовать многим ключевым словам, будут включены только те, на которые был направлен таргетинг; если список ключевых слов большой, мы можем установить ограничение на количество возвращаемых ключевых слов.
event.dv360_matching_targeted_segments string
Разделенные пробелом идентификаторы целевых списков пользователей, которые соответствуют посетителю, например "-4 456". Если посетитель находится в списке пользователей, на которого не нацелена реклама, связанная с этим событием, он не будет включен сюда.
event.dv360_media_cost_advertiser_currency int
Сумма, уплаченная за показ в нано валюты рекламодателя, вы можете разделить на 1 000 000 000, чтобы увидеть ее в валюте. Это значение может быть равно нулю.
event.dv360_media_cost_partner_currency int
Сумма, уплаченная за показ в нано валюте партнера, вы можете разделить на 1 000 000 000, чтобы увидеть ее в валюте. Это значение может быть равно нулю.
event.dv360_media_cost_usd int
Сумма, уплаченная за показ в нано долларах США, вы можете разделить на 1 000 000 000, чтобы увидеть ее в валюте. Это значение может быть равно нулю.
event.dv360_media_fee_1_advertiser_currency int
event.dv360_media_fee_1_partner_currency int
event.dv360_media_fee_1_usd int
event.dv360_media_fee_2_advertiser_currency int
event.dv360_media_fee_2_partner_currency int
event.dv360_media_fee_2_usd int
event.dv360_media_fee_3_advertiser_currency int
event.dv360_media_fee_3_partner_currency int
event.dv360_media_fee_3_usd int
event.dv360_media_fee_4_advertiser_currency int
event.dv360_media_fee_4_partner_currency int
event.dv360_media_fee_4_usd int
event.dv360_media_fee_5_advertiser_currency int
event.dv360_media_fee_5_partner_currency int
event.dv360_media_fee_5_usd int
event.dv360_mobile_make_id int
Числовой идентификатор производителя мобильного телефона. Это значение может отсутствовать.
event.dv360_mobile_model_id int
Числовой идентификатор мобильной модели. Это значение может отсутствовать.
event.dv360_net_speed int
Числовой идентификатор Display & Video 360, представляющий скорость сети, связанную с событием просмотра. 1=Коммутируемый доступ, 2=EDGE/2G, 3=UMTS/3G, 4=Базовый DSL, 5=HSDPA/3.5G, 6=Широкополосный/4G, 7=Неизвестно.
event.dv360_operating_system_id int
Идентификатор операционной системы.
event.dv360_request_time int
Временная метка Unix в микросекундах (1/1 000 000 секунды), указывающая, когда мы получили запрос объявления, например, 1330403779608570 представляет вторник, 28 февраля 2012 г., 04:36:19.608570. Несмотря на то, что это значение одинаково для всех представлений, кликов и конверсий, даже оно не может быть уникальным — используйте аукционный идентификатор для присоединения к событиям.
event.dv360_revenue_advertiser_currency int
Общая сумма в нано в валюте рекламодателя, внесенная партнерским аккаунтом за событие просмотра. Это значение может быть равно нулю.
event.dv360_revenue_partner_currency int
Общая сумма в валюте партнера в нано, внесенная партнерским аккаунтом за событие просмотра. Это значение может быть равно нулю.
event.dv360_revenue_usd int
Общая сумма в нанодолларах США, внесенная партнерским счетом за событие просмотра. Это значение может быть равно нулю.
event.dv360_site_id int
Числовой идентификатор в Дисплее и Видео 360 для наиболее конкретного универсального сайта, который соответствует URL.
event.dv360_state_region_id int
Идентификатор региона DV360
event.dv360_url string
Необработанный URL-адрес, взятый из запроса ставки, полученного от биржи, например "http://www.example.com". Поскольку некоторые биржи маскируют URL-адрес в своих запросах ставок, это значение может быть: «source_url_hidden».
event.dv360_view_state string
Заполняется для обернутых тегов. (Две записи о показах, когда происходят оба события.) Возможные значения: "ВНЕШНИЙ", DV360 возвращает завернутый тег; "ВНУТРЕННЯЯ", тег объявления, обернутый в публикацию; "3PAS_MERGED", обернутый тег, отслеживаемый CM; "3PAS_OUTER", отслеживание ping отправлено в CM, но нет ответа, третья сторона заблокировала показ рекламы.
event.dv360_zip_postal_code string
DV360 Почтовый индекс
event.event_sub_type string
Содержит дополнительную информацию, связанную с событием — это «VIEW» и «CLICK» для событий просмотра и нажатия, но может быть «POSTVIEW», «POSTCLICK» или пустым для событий конверсии.
event.event_time int
Время в микросекундах с 01 января 1970 г. 00:00:00 UTC.
event.event_type string
Содержит «CONVERSION» или «MODELED_CONVERSION» для событий преобразования.
event.floodlight_config_id int
Уникальный идентификатор конфигурации Floodlight.
event.interaction_time_utc_seconds string
Время взаимодействия
event.landing_page_url_id int
Уникальный идентификатор URL целевой страницы.
event.operating_system_id int
ID операционной системы.
event.ord_value string
Порядковый идентификатор рекламодателя, если он соответствует данному типу активности. Передается в паре "ключ-значение" ord= (также используется для хранения идентификатора заказа клиента в тегах продаж)
event.other_data string
Сохраняет данные пары "ключ-значение" из строки действия, которая не помечена иным образом. (Любая пара "ключ-значение", которая НЕ является "src=", "type=", "cat=", "ord=", "u=", "cost=", "qty=", "tran=", "a =" или "b="). (Можно использовать для дальнейшей разбивки продукта, также известной как «Пользовательские переменные Floodlight»)
event.placement_id int
Уникальный идентификатор страницы сайта/места размещения, на котором показывалось объявление.
event.rendering_id int
Уникальный идентификатор креатива для передачи данных. Не соответствует UI-Creative-ID.
event.rich_media_event_counters int
Значение счетчика MET (значение ecn=).
event.rich_media_event_id int
Идентификатор события MET для мультимедийной рекламы.
event.rich_media_event_timers double
Время в микросекундах с 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_id int
Идентификатор типа мультимедийного события.
event.segment_value_1 int
Значение сегмента 1
event.site_id int
Уникальный идентификатор сайта, на котором показывалась реклама.
event.state string
Идентификатор штата или провинции пользователя (США/Канада)
event.total_conversions double
Сумма ценности конверсии в нано, начисляемая связанному событию. Для действий по продажам Floodlight может регистрировать более одной конверсии на событие. Например, вы можете настроить Floodlight для подсчета количества приобретенных товаров как количества конверсий для одного события. (Двойное значение int event.activity_count в activity_events)
event.total_conversions_revenue double
Сумма выручки в USD megas, зачисленная на атрибут. Вы можете умножить на 1 000 000, чтобы увидеть сумму в долларах. (Атрибутированная версия event.activity_revenue в activity_events)
event.total_transaction_count double
Количество транзакций или срабатываний тега активности в нано, зачисленных на атрибутированное событие.
event.tran_value string
Значение ТРАН
event.u_value string
U Значение
event.zip_code string
Почтовый индекс (США/Канада).
network_id int
Идентификатор сети.
user_id opaque
Идентификатор отслеживания (он основан на файлах cookie браузера пользователя или идентификаторе мобильного устройства, но не раскрывает их). Это поле может быть обнулено по соображениям конфиденциальности. Идентификаторы пользователей поддерживают подсчет и объединение (между таблицами в ADH). Их нельзя экспортировать или преобразовать как обычные типы данных.

События переноса данных Менеджера кампаний 360

cm_dt_activities_events
event.activity_count int
event.activity_id int
Идентификатор тега Floodlight, связанного с событием-конверсией.
event.activity_revenue double
event.browser_platform_id string
ID типа браузера.
event.browser_version string
Версия браузера/платформы
event.conversion_event_id int
Уникальный идентификатор события-конверсии.
event.cookie_consented_floodlight_impressions int
Количество показов Floodlight, в которых пользователи дали согласие на отслеживание файлов cookie.
event.country_code string
Страна
event.duplicate_floodlight_impressions int
Количество повторяющихся показов Floodlight. Показы могут дублироваться, когда пользователи дают согласие на странице конверсии.
event.event_time int
Время в микросекундах с 01 января 1970 г. 00:00:00 UTC.
event.floodlight_config_id int
Уникальный идентификатор конфигурации Floodlight.
event.ord_value string
Порядковый идентификатор рекламодателя, если он соответствует данному типу активности. Передается в паре "ключ-значение" ord= (также используется для хранения идентификатора заказа клиента в тегах продаж)
event.other_data string
Сохраняет данные пары "ключ-значение" из строки действия, которая не помечена иным образом. (Любая пара "ключ-значение", которая НЕ является "src=", "type=", "cat=", "ord=", "u=", "cost=", "qty=", "tran=", "a =" или "b="). (Можно использовать для дальнейшей разбивки продукта, также известной как «Пользовательские переменные Floodlight»)
event.state string
Идентификатор штата или провинции пользователя (США/Канада)
network_id int
Идентификатор сети.
user_id opaque
Идентификатор отслеживания (он основан на файлах cookie браузера пользователя или идентификаторе мобильного устройства, но не раскрывает их). Это поле может быть обнулено по соображениям конфиденциальности. Идентификаторы пользователей поддерживают подсчет и объединение (между таблицами в ADH). Их нельзя экспортировать или преобразовать как обычные типы данных.

Категория действия по передаче данных в Менеджере кампаний 360

cm_dt_activity_category
account_id int
Уникальный идентификатор аккаунта.
activity string
Определяемое пользователем имя интерфейса отчета категории для тегов Floodlight.
activity_group_id int
ID группы, к которой принадлежит данный рекламодатель. Рекламодатель может быть членом только одной группы.
activity_id int
Уникальный идентификатор действия Floodlight.
activity_sub_type string
Пользовательская строка, соответствующая значению cat= из тега Floodlight.
activity_type string
Определяемая пользователем строка, соответствующая значению type= из тега Floodlight.
advertiser_id int
Уникальный идентификатор рекламодателя.
floodlight_config_id int
Уникальный идентификатор конфигурации Floodlight.
tag_counting_method_id int
Определяемый пользователем тип — описание типа тега Floodlight. Ключ: 1 - стандартный, 2 - уникальный, 3 - пользовательский, 4 - целое число транзакций только для тегов продаж, 5 - целое число проданных товаров.

Campaign Manager 360 Data Transfer activity type

cm_dt_activity_type
account_id int
Unique ID of the account.
activity_group string
Name for this activity group.
activity_group_id int
ID of the group to which this advertiser belongs. An advertiser may be a member of only one group.
activity_type string
User defined string corresponding to type= value from Floodlight tag.
advertiser_id int
Unique ID of the advertiser.
floodlight_config_id int
Unique ID of the floodlight configuration.

Campaign Manager 360 Data Transfer ad

cm_dt_ad
account_id int
Unique ID of the account.
ad string
User defined ad name.
ad_click_url string
Click through URL of Click Ad type creatives only (aka Click Commands)
ad_comments string
User defined ad level comments.
ad_id int
Unique ID of the ad.
ad_type string
Type of ad. Possible values are: Standard, Interstitial, Static Click, Dynamic Click, Tracking, In-Steam Video, DART Search, Affiliate, PInclusion, Product feeds, Natural Search, Default, Interstitial Default, InStream Default, Ad Brand-neutral
ad_type_id int
Unique ID of the ad type.
advertiser_id int
Unique ID of the advertiser.
campaign_id int
The unique ID of the Campaign Manager 360 campaign.
creative_size string
The creative size in pixels: width x height. Empty size is represented by "0X0".
floodlight_config_id int
Unique ID of the floodlight configuration.

Campaign Manager 360 Data Transfer Ad placement assignments

cm_dt_ad_placement_assignment
account_id int
Unique ID of the account.
ad_id int
Unique ID of the ad.
advertiser_id int
Unique ID of the advertiser.
floodlight_config_id int
Unique ID of the floodlight configuration.
placement_id int

Campaign Manager 360 Data Transfer Advertiser

cm_dt_advertiser
account_id int
Unique ID of the account.
advertiser string
User entered name of the advertiser.
advertiser_group string
User specified group to which this advertiser belongs. An advertiser may be a member of only one group.
advertiser_group_id int
Group ID to which this advertiser belongs. An advertiser may be a member of only one group.
advertiser_id int
Unique ID of the advertiser.
floodlight_config_id int
Unique ID of the floodlight configuration.

Campaign Manager 360 Data Transfer asset

cm_dt_asset
account_id int
Unique ID of the account.
asset string
Name of the creative asset.
asset_category string
Category of the creative asset.
asset_id int
Unique ID of the asset.
asset_orientation string
Screen orientation of the asset.

Campaign Manager 360 Data Transfer audience segments

cm_dt_audience_segments
account_id int
Unique ID of the account.
advertiser_id int
Unique ID of the advertiser.
audience_segment string
Name of the audience segment.
audience_segment_id int
Unique ID of the audience segment.
floodlight_config_id int
Unique ID of the floodlight configuration.

Campaign Manager 360 Data Transfer browser

cm_dt_browser
browser_platform string
browser_platform_id int
Browser / Platform ID

Campaign Manager 360 Data Transfer campaign

cm_dt_campaign
account_id int
Unique ID of the account.
advertiser_id int
Unique ID of the advertiser.
billing_invoice_code string
The code entered in the billing invoice.
campaign string
User entered campaign name.
campaign_end_date int
Campaign end date as YYYYMMDD.
campaign_id int
The unique ID of the Campaign Manager 360 campaign.
campaign_start_date int
Campaign start date as YYYYMMDD.
floodlight_config_id int
Unique ID of the floodlight configuration.

Campaign Manager 360 Data Transfer city

cm_dt_city
city string
The city name
city_id int
Unique ID of the city.

Campaign Manager 360 Data Transfer clicks

cm_dt_clicks
event.operating_system_id int
ID of the operating system.
event struct
event.active_view_audible_impressions int
Active View: Impressions Audible
event.active_view_audible_time_msec int
Active View: Play Time Audible (milliseconds)
event.active_view_audible_visible_time_msec int
Active View: Play Time Audible and Visible (milliseconds)
event.active_view_background_count int
Active View: Impressions In Background
event.active_view_complete_viewable_impressions int
Active View: Impressions Visible at Completion
event.active_view_eligible_impressions int
Whether the impression was eligible to measure viewability. An impression is eligible if (a) the ad's creative has an Active View tag and (b) the tag successfully communicates with Google Marketing Platform servers at the time of the impression.
event.active_view_first_quartile_viewable_audible_impressions int
Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressions int
Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_count int
Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completion int
Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_seconds int
Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressions int
Whether the impression was measurable with Active View.
event.active_view_midpoint_viewable_audible_impressions int
Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressions int
Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_count int
Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressions int
Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressions int
Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressions int
Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressions int
Active View: Impressions Visible at Third Quartile
event.active_view_tos_msec int
Active View: Time on Screen (milliseconds)
event.active_view_visible_time_msec int
Active View: Video Visible Time (milliseconds)
event.activity_count int
Activity Quantity
event.activity_id int
The ID of the Floodlight tag related to the conversion event.
event.activity_revenue double
Activity Revenue
event.ad_id int
Unique ID of the ad placement.
event.advertiser_id int
Unique ID of the advertiser
event.audience_segment_id int
Unique ID of the audience segment.
event.browser_platform_id string
ID of the browser type.
event.browser_version string
Browser/Platform Version
event.campaign_id int
The unique ID of the Campaign Manager 360 campaign
event.city_id int
City ID
event.conversion_id int
Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0).
event.country_code string
Country
event.creative_version string
Creative version number.
event.dma_region_id int
Designated Market Area ID (US/Canada).
event.dv360_ad_position int
Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_id int
The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categories string
DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_id string
The external ID of the attributed inventory source that Display & Video 360 selected as the best match from those accessible to the advertiser related to the view event based on floor price and auction type.
event.dv360_attributed_inventory_source_is_public string
True if inventory source is available to all buyers. False otherwise.
event.dv360_auction_id string
A string used to join events among view/click/conversion types, for example"ABCDEFGH_abcdefgh-0123456789". Do not assume any ordering, structure or meaning to the auction_id value.
event.dv360_bid_price_advertiser_currency int
The bid price sent to the exchange in advertiser currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_partner_currency int
The bid price sent to the exchange in partner currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_usd int
The bid price sent to the exchange in USD nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics..
event.dv360_billable_cost_advertiser_currency int
The total amount of money billed to the partner, including the media cost and partner costs, in advertiser currency nanos.
event.dv360_billable_cost_partner_currency int
The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.
event.dv360_billable_cost_usd int
The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.
event.dv360_browser_id int
The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutes int
The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.
event.dv360_campaign_id int
The unique ID of the linked Display & Video 360 campaign.
event.dv360_city_id int
The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_code string
2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_cpm_fee_1_advertiser_currency int
event.dv360_cpm_fee_1_partner_currency int
event.dv360_cpm_fee_1_usd int
event.dv360_cpm_fee_2_advertiser_currency int
event.dv360_cpm_fee_2_partner_currency int
event.dv360_cpm_fee_2_usd int
event.dv360_cpm_fee_3_advertiser_currency int
event.dv360_cpm_fee_3_partner_currency int
event.dv360_cpm_fee_3_usd int
event.dv360_cpm_fee_4_advertiser_currency int
event.dv360_cpm_fee_4_partner_currency int
event.dv360_cpm_fee_4_usd int
event.dv360_cpm_fee_5_advertiser_currency int
event.dv360_cpm_fee_5_partner_currency int
event.dv360_cpm_fee_5_usd int
event.dv360_creative_id int
The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_data_fees_advertiser_currency int
event.dv360_data_fees_partner_currency int
event.dv360_data_fees_usd int
event.dv360_device_type int
The numerical value of the identified device type. 0 = Computer, 1 = Other, 2 = Smart Phone, 3 = Tablet, 4 = Smart TV, 5 = Connected TV, 6 = Set Top Box, 7 = Connected Device.
event.dv360_exchange_id string
The Display & Video 360 numerical ID for the exchange that requested the ad.
event.dv360_insertion_order_id int
The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.
event.dv360_isp_id int
The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_language string
The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.
event.dv360_line_item_id int
The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.
event.dv360_matching_targeted_keywords string
A comma separated string containing a list of targeted keywords matching the page related to the view event, for example "apple,orange,banana". Although the page related to the view event may match many keywords, only those which were targeted will be included; if the list of keywords is large we may impose a limit to the number of keywords returned.
event.dv360_matching_targeted_segments string
Space-separated IDs of targeted user lists that match the visitor, for example "-4 456". If the visitor is in a user list that is not targeted by the ad associated with this event it will not be included here.
event.dv360_media_cost_advertiser_currency int
The amount paid for the impression in advertiser currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_partner_currency int
The amount paid for the impression in the partner currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_usd int
The amount paid for the impression in USD nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_fee_1_advertiser_currency int
event.dv360_media_fee_1_partner_currency int
event.dv360_media_fee_1_usd int
event.dv360_media_fee_2_advertiser_currency int
event.dv360_media_fee_2_partner_currency int
event.dv360_media_fee_2_usd int
event.dv360_media_fee_3_advertiser_currency int
event.dv360_media_fee_3_partner_currency int
event.dv360_media_fee_3_usd int
event.dv360_media_fee_4_advertiser_currency int
event.dv360_media_fee_4_partner_currency int
event.dv360_media_fee_4_usd int
event.dv360_media_fee_5_advertiser_currency int
event.dv360_media_fee_5_partner_currency int
event.dv360_media_fee_5_usd int
event.dv360_mobile_make_id int
The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_id int
The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speed int
The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.
event.dv360_operating_system_id int
DV60 operating system ID
event.dv360_request_time int
A Unix timestamp in microseconds (1/1,000,000 second) for when we received the ad request, for example1330403779608570 represents Tuesday February 28th 2012 04:36:19.608570. Although this value is consistent across the view, click and conversion even it is not guaranteed to be unique - use auction_id to join events
event.dv360_revenue_advertiser_currency int
The total amount in advertiser currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_partner_currency int
The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_usd int
The total amount in USD nanos made by the partner account for the view event. This value may be zero.
event.dv360_site_id int
The Display & Video 360 numerical ID for the most specific universal site that matches the url.
event.dv360_state_region_id int
DV360 Region ID
event.dv360_url string
The raw URL taken from the bid request received from the exchange, for example "http://www.example.com". As some exchanges mask the URL in their bid requests this value may be: "source_url_hidden"
event.dv360_view_state string
Populated for wrapped tags. (Two impression records when both events occur.) Possible values are: "OUTER", DV360 returned wrapped tag; "INNER", ad served post wrapped tag; "3PAS_MERGED", wrapped tag tracked by CM; "3PAS_OUTER", tracking ping sent to CM but no response, 3rd party blocked ad serving.
event.dv360_zip_postal_code string
DV360 ZIP/Postal Code
event.dynamic_profile string
Studio dynamic profile name.
event.dynamic_profile_id int
Studio dynamic profile ID.
event.event_sub_type string
Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
event.event_time int
Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_type string
Contains "CLICK".
event.feed array
Feed ID.
event.feed_reporting_dimension1 array
event.feed_reporting_dimension2 array
event.feed_reporting_dimension3 array
event.feed_reporting_dimension4 array
event.feed_reporting_dimension5 array
event.feed_reporting_dimension6 array
event.feed_reporting_label array
Dynamic Feed Reporting Label.
event.floodlight_config_id int
Unique ID of the floodlight configuration.
event.impression_id string
Impression ID
event.interaction_time_utc_seconds string
Interaction Time
event.landing_page_url_id int
Unique ID of the landing page URL.
event.operating_system_id int
ID of the operating system.
event.ord_value string
The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)
event.other_data string
Stores key-value data from the activity string which is not otherwise labeled. (Any key-value that is NOT "src=", "type=", "cat=", "ord=", "u=", "cost=", "qty=", "tran=", "a=", or "b="). (Can be used for further product breakdown aka "Custom Floodlight Variables")
event.placement_id int
Unique ID for the site page / placement where the ad ran.
event.platform_type_id int
Identifier that maps to the platform on which the event occured. Possible values are: 30000: desktop, 30001: high-end smartphone, 30002: tablet, 30003: mid-range smartphone, 30004: connected TV, 30005: unknown, 30006: set top box.
event.rendering_id int
Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_counters int
MET Counter Value (the ecn= value).
event.rich_media_event_id int
MET Event ID for the Rich Media ad.
event.rich_media_event_timers double
Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_id int
ID of Rich Media Event Type.
event.segment_value_1 int
Segment Value 1
event.site_id int
Unique ID for the site where the ad ran.
event.state string
ID for user's state or province (US/Canada)
event.tran_value string
TRAN Value
event.u_value string
U Value
event.zip_code string
Postal-Code (US/Canada).
network_id int
The network ID.
user_id opaque
The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons. User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

Campaign Manager 360 Data Transfer creative

cm_dt_creative
account_id int
Unique ID of the account.
advertiser_id int
Unique ID of the advertiser.
creative string
Creative Name as entered into the Campaign Manager 360 interface.
creative_id int
The Creative ID in Campaign Manager 360 UI.
creative_image_url string
Location of creative image (Does not apply to rich media).
creative_last_modified_date int
Unix epoch timestamp (milliseconds) of the last time this creative was modified.
creative_size string
The creative size in pixels: width x height. Empty size is represented by "0X0".
creative_type string
The type of creative.
creative_type_id int
creative_version int
Used for change management to capture different versions
floodlight_config_id int
Unique ID of the floodlight configuration.
rendering_id int
Unique ID of the creative for Data Transfer. This isn't the creative ID in the Campaign Manager 360 UI.

Campaign Manager 360 Data Transfer creative ad assignment

cm_dt_creative_ad_assignment
account_id int
Unique ID of the account.
ad_click_url string
Click through URL of Click Ad type creatives only (aka Click Commands)
ad_id int
Unique ID of the ad.
advertiser_id int
Unique ID of the advertiser.
creative_end_date int
Rotation end date and time in milliseconds since 1970-01-01 00:00:00 UTC.
creative_group1 string
User defined value from creative group 1.
creative_group1_id int
Unique ID of creative group 1.
creative_group2 string
User defined value from creative group 2.
creative_group2_id int
Unique ID of creative group 2.
creative_id int
The Creative ID in Campaign Manager 360 UI.
creative_rotation_type string
Rotation type.
creative_rotation_type_id int
Id of the rotation type.
creative_start_date int
Rotation start date and time in Unix epoch time (milliseconds).
floodlight_config_id int
Unique ID of the floodlight configuration.

Campaign Manager 360 Data Transfer custom creative field

cm_dt_custom_creative_field
account_id int
Unique ID of the account.
advertiser_id int
Unique ID of the advertiser.
creative_field_id int
The Creative ID in Campaign Manager 360 UI.
creative_field_name string
User defined name associated to a particular custom creative field.
creative_field_number int
Slot ID assigned to this custom creative field (typically IDs from 1-20).
creative_field_value string
User defined value as available option to named field.
creative_field_value_id int
ID of the user defined creative value.
creative_id int
The Creative ID in Campaign Manager 360 UI.
floodlight_config_id int
Unique ID of the floodlight configuration.

Campaign Manager 360 Data Transfer custom floodlight variable

cm_dt_custom_floodlight_variable
account_id int
Unique ID of the account.
advertiser_id int
Unique ID of the advertiser.
floodlight_config_id int
Unique ID of the floodlight configuration.
floodlight_variable_id int
Unique ID of the floodlight variable.
floodlight_variable_name string
User defined name of the custom floodlight variable.

Campaign Manager 360 Data Transfer custom rich media

cm_dt_custom_rich_media
account_id int
Unique ID of the account.
advertiser_id int
Unique ID of the advertiser.
floodlight_config_id int
Unique ID of the floodlight configuration.
rich_media_event_id int
ID of the rich media event.
rich_media_event_name string
Name of the rich media event.
rich_media_event_type string
Possible values are: "Timer", "Exit", or "Counter".
rich_media_event_type_id int
ID of the rich media event type.

Campaign Manager 360 Data Transfer designated market area

cm_dt_designated_market_area
dma_region string
dma_region_id int

Campaign Manager 360 Data Transfer impressions

cm_dt_impressions
event struct
event.active_view_audible_impressions int
Active View: Impressions Audible
event.active_view_audible_time_msec int
Active View: Play Time Audible (milliseconds)
event.active_view_audible_visible_time_msec int
Active View: Play Time Audible and Visible (milliseconds)
event.active_view_background_count int
Active View: Impressions In Background
event.active_view_complete_viewable_impressions int
Active View: Impressions Visible at Completion
event.active_view_eligible_impressions int
Whether the impression was eligible to measure viewability. An impression is eligible if (a) the ad's creative has an Active View tag and (b) the tag successfully communicates with Google Marketing Platform servers at the time of the impression.
event.active_view_first_quartile_viewable_audible_impressions int
Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressions int
Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_count int
Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completion int
Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_seconds int
Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressions int
Whether the impression was measurable with Active View.
event.active_view_midpoint_viewable_audible_impressions int
Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressions int
Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_count int
Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressions int
Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressions int
Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressions int
Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressions int
Active View: Impressions Visible at Third Quartile
event.active_view_tos_msec int
Active View: Time on Screen (milliseconds)
event.active_view_visible_time_msec int
Active View: Video Visible Time (milliseconds)
event.activity_count int
Activity Quantity
event.activity_id int
The ID of the Floodlight tag related to the conversion event.
event.activity_revenue double
Activity Revenue
event.ad_id int
Unique ID of the ad placement.
event.advertiser_id int
Unique ID of the advertiser
event.audience_segment_id int
Unique ID of the audience segment
event.browser_platform_id string
ID of the browser type.
event.browser_version string
Browser/Platform Version
event.campaign_id int
The unique ID of the Campaign Manager 360 campaign
event.city_id int
City ID
event.conversion_id int
Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0).
event.country_code string
Country
event.creative_version string
Creative version number.
event.dma_region_id int
Designated Market Area ID (US/Canada).
event.dv360_ad_position int
Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_id int
The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categories string
DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_id string
The external ID of the attributed inventory source that Display & Video 360 selected as the best match from those accessible to the advertiser related to the view event based on floor price and auction type.
event.dv360_attributed_inventory_source_is_public string
True if inventory source is available to all buyers. False otherwise.
event.dv360_auction_id string
A string used to join events among view/click/conversion types, for example"ABCDEFGH_abcdefgh-0123456789". Do not assume any ordering, structure or meaning to the auction_id value.
event.dv360_bid_price_advertiser_currency int
The bid price sent to the exchange in advertiser currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_partner_currency int
The bid price sent to the exchange in partner currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_usd int
The bid price sent to the exchange in USD nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics..
event.dv360_bid_request_publisher_id string
The publisher id in the publisher.id field of bid request.
event.dv360_billable_cost_advertiser_currency int
The total amount of money billed to the partner, including the media cost and partner costs, in advertiser currency nanos.
event.dv360_billable_cost_partner_currency int
The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.
event.dv360_billable_cost_usd int
The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.
event.dv360_browser_id int
The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutes int
The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.
event.dv360_campaign_id int
The unique ID of the linked Display & Video 360 campaign.
event.dv360_city_id int
The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_code string
2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_cpm_fee_1_advertiser_currency int
event.dv360_cpm_fee_1_partner_currency int
event.dv360_cpm_fee_1_usd int
event.dv360_cpm_fee_2_advertiser_currency int
event.dv360_cpm_fee_2_partner_currency int
event.dv360_cpm_fee_2_usd int
event.dv360_cpm_fee_3_advertiser_currency int
event.dv360_cpm_fee_3_partner_currency int
event.dv360_cpm_fee_3_usd int
event.dv360_cpm_fee_4_advertiser_currency int
event.dv360_cpm_fee_4_partner_currency int
event.dv360_cpm_fee_4_usd int
event.dv360_cpm_fee_5_advertiser_currency int
event.dv360_cpm_fee_5_partner_currency int
event.dv360_cpm_fee_5_usd int
event.dv360_creative_id int
The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_data_fees_advertiser_currency int
event.dv360_data_fees_partner_currency int
event.dv360_data_fees_usd int
event.dv360_device_type int
The numerical value of the identified device type. 0 = Computer, 1 = Other, 2 = Smart Phone, 3 = Tablet, 4 = Smart TV, 5 = Connected TV, 6 = Set Top Box, 7 = Connected Device.
event.dv360_exchange_id string
The Display & Video 360 numerical ID for the exchange that requested the ad.
event.dv360_insertion_order_id int
The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.
event.dv360_isp_id int
The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_language string
The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.
event.dv360_line_item_id int
The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.
event.dv360_matching_targeted_keywords string
A comma separated string containing a list of targeted keywords matching the page related to the view event, for example "apple,orange,banana". Although the page related to the view event may match many keywords, only those which were targeted will be included; if the list of keywords is large we may impose a limit to the number of keywords returned.
event.dv360_matching_targeted_segments string
Space-separated IDs of targeted user lists that match the visitor, for example "-4 456". If the visitor is in a user list that is not targeted by the ad associated with this event it will not be included here.
event.dv360_media_cost_advertiser_currency int
The amount paid for the impression in advertiser currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_partner_currency int
The amount paid for the impression in the partner currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_usd int
The amount paid for the impression in USD nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_fee_1_advertiser_currency int
event.dv360_media_fee_1_partner_currency int
event.dv360_media_fee_1_usd int
event.dv360_media_fee_2_advertiser_currency int
event.dv360_media_fee_2_partner_currency int
event.dv360_media_fee_2_usd int
event.dv360_media_fee_3_advertiser_currency int
event.dv360_media_fee_3_partner_currency int
event.dv360_media_fee_3_usd int
event.dv360_media_fee_4_advertiser_currency int
event.dv360_media_fee_4_partner_currency int
event.dv360_media_fee_4_usd int
event.dv360_media_fee_5_advertiser_currency int
event.dv360_media_fee_5_partner_currency int
event.dv360_media_fee_5_usd int
event.dv360_mobile_make_id int
The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_id int
The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speed int
The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.
event.dv360_operating_system_id int
event.dv360_request_time int
A Unix timestamp in microseconds (1/1,000,000 second) for when we received the ad request, for example1330403779608570 represents Tuesday February 28th 2012 04:36:19.608570. Although this value is consistent across the view, click and conversion even it is not guaranteed to be unique - use auction_id to join events
event.dv360_revenue_advertiser_currency int
The total amount in advertiser currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_partner_currency int
The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_usd int
The total amount in USD nanos made by the partner account for the view event. This value may be zero.
event.dv360_site_id int
The Display & Video 360 numerical ID for the most specific universal site that matches the url.
event.dv360_state_region_id int
DV360 Region ID
event.dv360_supply_chain_complete boolean
Indicates whether the DV360 supply chain object is complete in the bid request.
event.dv360_supply_chain_domain array
The domain in the DV360 supply path, the order is the same as the order in the supply chain JSON.
event.dv360_supply_chain_seller_id array
Array of strings. The seller ID in the DV360 supply path, the order is the same as the order in the supply chain JSON.
event.dv360_url string
The raw URL taken from the bid request received from the exchange, for example "http://www.example.com". As some exchanges mask the URL in their bid requests this value may be: "source_url_hidden"
event.dv360_view_state string
Populated for wrapped tags. (Two impression records when both events occur.) Possible values are: "OUTER", DV360 returned wrapped tag; "INNER", ad served post wrapped tag; "3PAS_MERGED", wrapped tag tracked by CM; "3PAS_OUTER", tracking ping sent to CM but no response, 3rd party blocked ad serving.
event.dv360_zip_postal_code string
DV360 ZIP/Postal Code
event.dynamic_profile string
Studio dynamic profile name.
event.dynamic_profile_id int
Studio dynamic profile ID.
event.event_sub_type string
Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
event.event_time int
Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_type string
Contains "VIEW".
event.feed array
Feed ID.
event.feed_reporting_dimension1 array
event.feed_reporting_dimension2 array
event.feed_reporting_dimension3 array
event.feed_reporting_dimension4 array
event.feed_reporting_dimension5 array
event.feed_reporting_dimension6 array
event.feed_reporting_label array
Dynamic Feed ID.
event.floodlight_config_id int
Unique ID of the floodlight configuration.
event.impression_id string
Impression ID
event.interaction_time_utc_seconds string
Interaction Time
event.landing_page_url_id int
Unique ID of the landing page URL.
event.operating_system_id int
ID of the operating system.
event.ord_value string
The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)
event.other_data string
Stores key-value data from the activity string which is not otherwise labeled. (Any key-value that is NOT "src=", "type=", "cat=", "ord=", "u=", "cost=", "qty=", "tran=", "a=", or "b="). (Can be used for further product breakdown aka "Custom Floodlight Variables")
event.placement_id int
Unique ID for the site page / placement where the ad ran.
event.platform_type_id int
Identifier that maps to the platform on which the event occured. Possible values are: 30000: desktop, 30001: high-end smartphone, 30002: tablet, 30003: mid-range smartphone, 30004: connected TV, 30005: unknown, 30006: set top box.
event.referrer_url string
Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.
event.rendering_id int
Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_counters int
MET Counter Value (the ecn= value).
event.rich_media_event_id int
MET Event ID for the Rich Media ad.
event.rich_media_event_timers double
Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_id int
ID of Rich Media Event Type.
event.segment_value_1 int
Segment Value 1
event.site_id int
Unique ID for the site where the ad ran.
event.state string
ID for user's state or province (US/Canada)
event.tran_value string
TRAN Value
event.u_value string
U Value
event.zip_code string
Postal-Code (US/Canada).
network_id int
The network ID.
user_id opaque
The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons. User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

Campaign Manager 360 Data Transfer keyword value

cm_dt_keyword_value
account_id int
Unique ID of the account.
ad_id int
Unique ID of the ad.
advertiser_id int
Unique ID of the advertiser.
floodlight_config_id int
Unique ID of the floodlight configuration.
keyword string
Targeted key/value pair.

Campaign Manager 360 Data Transfer landing page url

cm_dt_landing_page_url
account_id int
Unique ID of the account.
landing_page_url string
The URL a user was sent to when they clicked on an ad.
landing_page_url_id int
Unique ID of the landing page URL.

Campaign Manager 360 Data Transfer operating system

cm_dt_operating_system
operating_system string
operating_system_id int
Unique ID of OS just for Data Transfer. Operating System IDs in DT files that are greater than 22 have a direct match in this table. For DT file Operating System IDs less than 23, you must raise 2 to the power of the Operating System ID in the Data Transfer file to find its corresponding match in this table. Match Table Operating System ID = 2 ^ DT file operating system ID. For example 2 ^ 12 = 8192 (Linux).
cm_dt_paid_search
ad_id int
Unique ID of the ad.
advertiser_id int
Unique ID of the advertiser.
campaign_id int
The unique ID of the Campaign Manager 360 campaign.
floodlight_config_id int
Unique ID of the floodlight configuration.
paid_search_ad_group string
User defined keyword group.
paid_search_ad_group_id int
Unique ID of the keyword group.
paid_search_ad_id int
Unique ID associated with a Search Ads 360 ad.
paid_search_bid_strategy string
User defined keyword bid strategy. Returns a value of "(not set)" if empty.
paid_search_bid_strategy_id int
ID of the keyword bid strategy.
paid_search_campaign string
User defined name of campaign as entered into Search Ads 360.
paid_search_campaign_id int
ID of the Search Ads 360 campaign.
paid_search_keyword string
User defined keyword value as entered into Search Ads 360.
paid_search_keyword_id int
Unique ID from Search Ads 360. Uses the "long" format
paid_search_landing_page_url string
User defined landing page URL as entered into Search Ads 360.
paid_search_legacy_keyword_id int
Unique ID from Search Ads 360. Uses the "short" format in which the leading 43* is removed.
paid_search_match_type string
User selected

Campaign Manager 360 Data Transfer placement

cm_dt_placement
account_id int
Unique ID of the account.
activity_id int
Unique ID of the Floodlight activity.
advertiser_id int
Unique ID of the advertiser.
campaign_id int
The unique ID of the Campaign Manager 360 campaign.
content_category string
User defined content category.
content_category_id int
ID of content category.
flighting_activated boolean
Indicates whether this is a flighted (billing) placement.
floodlight_config_id int
Unique ID of the floodlight configuration.
package_roadblock_id int
package_roadblock_type string
package_roadblock_type_id int
placement string
placement_cap_cost_option int
User entered cost capping amount.
placement_cost_structure string
placement_end_date int
End date of the flight in 'YYYYMMDD' format.
placement_id int
placement_start_date int
Start date of the flight in 'YYYYMMDD' format.
placement_strategy string
User defined placement strategy.
placement_strategy_id int
ID of the placement strategy.
site_id int
Unique ID of the site.
site_keyname string

Campaign Manager 360 Data Transfer placement cost

cm_dt_placement_cost
account_id int
Unique ID of the account.
advertiser_id int
Unique ID of the advertiser.
floodlight_config_id int
Unique ID of the floodlight configuration.
placement_comments string
User entered placement pricing comments.
placement_end_date int
End date of the flight in 'YYYYMMDD' format.
placement_id int
Placement ID
placement_rate int
Purchased rate expressed in nanos of the network's currency. 1 nano = 1 billionth. 1 nano USD = $0.000000001.
placement_start_date int
Start date of the flight in 'YYYYMMDD' format.
placement_total_booked_units int
The number of purchased units.

Campaign Manager 360 Data Transfer rich media

cm_dt_rich_media
event struct
event.active_view_audible_impressions int
Active View: Impressions Audible
event.active_view_audible_time_msec int
Active View: Play Time Audible (milliseconds)
event.active_view_audible_visible_time_msec int
Active View: Play Time Audible and Visible (milliseconds)
event.active_view_background_count int
Active View: Impressions In Background
event.active_view_complete_viewable_impressions int
Active View: Impressions Visible at Completion
event.active_view_eligible_impressions int
Whether the impression was eligible to measure viewability. An impression is eligible if (a) the ad's creative has an Active View tag and (b) the tag successfully communicates with Google Marketing Platform servers at the time of the impression.
event.active_view_first_quartile_viewable_audible_impressions int
Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressions int
Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_count int
Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completion int
Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_seconds int
Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressions int
Whether the impression was measurable with Active View.
event.active_view_midpoint_viewable_audible_impressions int
Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressions int
Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_count int
Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressions int
Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressions int
Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressions int
Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressions int
Active View: Impressions Visible at Third Quartile
event.active_view_tos_msec int
Active View: Time on Screen (milliseconds)
event.active_view_viewable_impressions int
Whether the impression was viewable.
event.active_view_visible_time_msec int
Active View: Video Visible Time (milliseconds)
event.activity_count int
Activity Quantity
event.activity_id int
The ID of the Floodlight tag related to the conversion event.
event.activity_revenue double
Activity Revenue
event.ad_id int
Unique ID of the ad placement.
event.advertiser_id int
Unique ID of the advertiser
event.browser_platform_id string
ID of the browser type.
event.browser_version string
Browser/Platform Version
event.campaign_id int
The unique ID of the Campaign Manager 360 campaign
event.city_id int
City ID
event.conversion_id int
Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0).
event.country_code string
Country
event.creative_version string
Creative version number.
event.dma_region_id int
Designated Market Area ID (US/Canada).
event.dv360_ad_position int
Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_id int
The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categories string
DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_id string
The external ID of the attributed inventory source that Display & Video 360 selected as the best match from those accessible to the advertiser related to the view event based on floor price and auction type.
event.dv360_attributed_inventory_source_is_public string
True if inventory source is available to all buyers. False otherwise.
event.dv360_auction_id string
A string used to join events among view/click/conversion types, for example"ABCDEFGH_abcdefgh-0123456789". Do not assume any ordering, structure or meaning to the auction_id value.
event.dv360_bid_price_advertiser_currency int
The bid price sent to the exchange in advertiser currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_partner_currency int
The bid price sent to the exchange in partner currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_usd int
The bid price sent to the exchange in USD nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics..
event.dv360_billable_cost_advertiser_currency int
The total amount of money billed to the partner, including the media cost and partner costs, in advertiser currency nanos.
event.dv360_billable_cost_partner_currency int
The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.
event.dv360_billable_cost_usd int
The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.
event.dv360_browser_id int
The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutes int
The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.
event.dv360_campaign_id int
The unique ID of the linked Display & Video 360 campaign.
event.dv360_city_id int
The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_code string
2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_cpm_fee_1_advertiser_currency int
event.dv360_cpm_fee_1_partner_currency int
event.dv360_cpm_fee_1_usd int
event.dv360_cpm_fee_2_advertiser_currency int
event.dv360_cpm_fee_2_partner_currency int
event.dv360_cpm_fee_2_usd int
event.dv360_cpm_fee_3_advertiser_currency int
event.dv360_cpm_fee_3_partner_currency int
event.dv360_cpm_fee_3_usd int
event.dv360_cpm_fee_4_advertiser_currency int
event.dv360_cpm_fee_4_partner_currency int
event.dv360_cpm_fee_4_usd int
event.dv360_cpm_fee_5_advertiser_currency int
event.dv360_cpm_fee_5_partner_currency int
event.dv360_cpm_fee_5_usd int
event.dv360_creative_id int
The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_data_fees_advertiser_currency int
event.dv360_data_fees_partner_currency int
event.dv360_data_fees_usd int
event.dv360_device_type int
The numerical value of the identified device type. 0 = Computer, 1 = Other, 2 = Smart Phone, 3 = Tablet, 4 = Smart TV, 5 = Connected TV, 6 = Set Top Box, 7 = Connected Device.
event.dv360_exchange_id string
The Display & Video 360 numerical ID for the exchange that requested the ad.
event.dv360_insertion_order_id int
The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.
event.dv360_isp_id int
The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_language string
The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.
event.dv360_line_item_id int
The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.
event.dv360_matching_targeted_keywords string
A comma separated string containing a list of targeted keywords matching the page related to the view event, for example "apple,orange,banana". Although the page related to the view event may match many keywords, only those which were targeted will be included; if the list of keywords is large we may impose a limit to the number of keywords returned.
event.dv360_matching_targeted_segments string
Space-separated IDs of targeted user lists that match the visitor, for example "-4 456". If the visitor is in a user list that is not targeted by the ad associated with this event it will not be included here.
event.dv360_media_cost_advertiser_currency int
The amount paid for the impression in advertiser currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_partner_currency int
The amount paid for the impression in the partner currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_usd int
The amount paid for the impression in USD nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_fee_1_advertiser_currency int
event.dv360_media_fee_1_partner_currency int
event.dv360_media_fee_1_usd int
event.dv360_media_fee_2_advertiser_currency int
event.dv360_media_fee_2_partner_currency int
event.dv360_media_fee_2_usd int
event.dv360_media_fee_3_advertiser_currency int
event.dv360_media_fee_3_partner_currency int
event.dv360_media_fee_3_usd int
event.dv360_media_fee_4_advertiser_currency int
event.dv360_media_fee_4_partner_currency int
event.dv360_media_fee_4_usd int
event.dv360_media_fee_5_advertiser_currency int
event.dv360_media_fee_5_partner_currency int
event.dv360_media_fee_5_usd int
event.dv360_mobile_make_id int
The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_id int
The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speed int
The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.
event.dv360_operating_system_id int
event.dv360_request_time int
A Unix timestamp in microseconds (1/1,000,000 second) for when we received the ad request, for example1330403779608570 represents Tuesday February 28th 2012 04:36:19.608570. Although this value is consistent across the view, click and conversion even it is not guaranteed to be unique - use auction_id to join events
event.dv360_revenue_advertiser_currency int
The total amount in advertiser currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_partner_currency int
The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_usd int
The total amount in USD nanos made by the partner account for the view event. This value may be zero.
event.dv360_site_id int
The Display & Video 360 numerical ID for the most specific universal site that matches the url.
event.dv360_state_region_id int
DV360 Region ID
event.dv360_url string
The raw URL taken from the bid request received from the exchange, for example "http://www.example.com". As some exchanges mask the URL in their bid requests this value may be: "source_url_hidden"
event.dv360_view_state string
Populated for wrapped tags. (Two impression records when both events occur.) Possible values are: "OUTER", DV360 returned wrapped tag; "INNER", ad served post wrapped tag; "3PAS_MERGED", wrapped tag tracked by CM; "3PAS_OUTER", tracking ping sent to CM but no response, 3rd party blocked ad serving.
event.dv360_zip_postal_code string
DV360 ZIP/Postal Code
event.event_sub_type string
Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
event.event_time int
Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_type string
Contains "RICH_MEDIA_INTERACTION".
event.floodlight_config_id int
Unique ID of the floodlight configuration.
event.impression_id string
Impression ID
event.interaction_time_utc_seconds string
Interaction Time
event.landing_page_url_id int
Unique ID of the landing page URL.
event.operating_system_id int
ID of the operating system.
event.ord_value string
The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)
event.other_data string
Stores key-value data from the activity string which is not otherwise labeled. (Any key-value that is NOT "src=", "type=", "cat=", "ord=", "u=", "cost=", "qty=", "tran=", "a=", or "b="). (Can be used for further product breakdown aka "Custom Floodlight Variables")
event.placement_id int
Unique ID for the site page / placement where the ad ran.
event.platform_type_id int
Identifier that maps to the platform on which the event occured. Possible values are: 30000: desktop, 30001: high-end smartphone, 30002: tablet, 30003: mid-range smartphone, 30004: connected TV, 30005: unknown, 30006: set top box.
event.rendering_id int
Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_counters int
MET Counter Value (the ecn= value).
event.rich_media_event_id int
MET Event ID for the Rich Media ad.
event.rich_media_event_timers double
Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_id int
ID of Rich Media Event Type.
event.segment_value_1 int
Segment Value 1
event.site_id int
Unique ID for the site where the ad ran.
event.state string
ID for user's state or province (US/Canada)
event.tran_value string
TRAN Value
event.u_value string
U Value
event.zip_code string
Postal-Code (US/Canada).
network_id int
The network ID.
user_id opaque
The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons. User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

Campaign Manager 360 Data Transfer site

cm_dt_site
account_id int
Unique ID of the account.
site string
The name of the site.
site_directory string
Global unique name for this site.
site_directory_id int
Global unique ID for this site.
site_id int
Unique ID of the site.

Campaign Manager 360 Data Transfer state

cm_dt_state
region string
Abbreviated state/province name.
region_full_name string
Region name in English.

Campaign Manager 360 paths

cm_paths
floodlight_config_id int
Unique ID of the floodlight configuration. ID
network_id int
The network ID.
partner_id int
Unique ID of the partner.
path record
Row containing event path for a given user.
path.events repeated struct
path.events.active_view_eligible_impressions int
Active View eligible impressions
path.events.active_view_measurable_impressions int
Active View measurable impressions
path.events.active_view_viewable_impressions int
Active View viewable impressions
path.events.activity_count int
Activity count
path.events.activity_id int
The ID of the Floodlight tag related to the conversion event.
path.events.activity_revenue double
Activity revenue
path.events.ad_id int
Unique ID of the ad placement.
path.events.advertiser_id int
Unique ID of the advertiser
path.events.audience_segment_id int
Unique ID of the audience segment.
path.events.browser_platform_id string
Browser platform ID
path.events.browser_version string
Browser version
path.events.campaign_id int
The unique ID of the Campaign Manager 360 campaign
path.events.city_id int
City ID
path.events.conversion_id int
Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0).
path.events.country_code string
2-letter ISO 3166-1 country code.
path.events.creative_version string
Creative version number.
path.events.dma_region_id int
DMA region ID
path.events.dv360_ad_position int
Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
path.events.dv360_advertiser_id int
The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
path.events.dv360_adx_page_categories string
Contains the Ad Exchange page category IDs separated by a space, for example "65 189". The categories may not be mutually exclusive.
path.events.dv360_attributed_inventory_source_external_id string
The external ID of the attributed inventory source that Display & Video 360 selected as the best match from those accessible to the advertiser related to the view event based on floor price and auction type.
path.events.dv360_attributed_inventory_source_is_public string
True if inventory source is available to all buyers. False otherwise.
path.events.dv360_auction_id string
A string used to join events among view/click/conversion types, for example"ABCDEFGH_abcdefgh-0123456789". Do not assume any ordering, structure or meaning to the auction_id value.
path.events.dv360_bid_price_advertiser_currency int
The bid price sent to the exchange in advertiser currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
path.events.dv360_bid_price_partner_currency int
The bid price sent to the exchange in partner currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
path.events.dv360_bid_price_usd int
The bid price sent to the exchange in USD nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
path.events.dv360_billable_cost_advertiser_currency int
The total amount of money billed to the partner, including the media cost and partner costs, in advertiser currency nanos.
path.events.dv360_billable_cost_partner_currency int
The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.
path.events.dv360_billable_cost_usd int
The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.
path.events.dv360_browser_id int
DV360 browser ID
path.events.dv360_browser_timezone_offset_minutes int
The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.
path.events.dv360_city_id int
The Display & Video 360 numerical ID identifying the best-guess city of the impression.
path.events.dv360_country_code string
2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
path.events.dv360_cpm_fee_1_advertiser_currency int
The CPM 1 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_cpm_fee_1_partner_currency int
The CPM 1 fee in partner currency nanos. This value may be zero.
path.events.dv360_cpm_fee_1_usd int
The CPM 1 fee in USD nanos. This value may be zero.
path.events.dv360_cpm_fee_2_advertiser_currency int
The CPM 2 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_cpm_fee_2_partner_currency int
The CPM 2 fee in partner currency nanos. This value may be zero.
path.events.dv360_cpm_fee_2_usd int
The CPM 2 fee in USD nanos. This value may be zero.
path.events.dv360_cpm_fee_3_advertiser_currency int
The CPM 3 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_cpm_fee_3_partner_currency int
The CPM 3 fee in partner currency nanos. This value may be zero.
path.events.dv360_cpm_fee_3_usd int
The CPM 3 fee in USD nanos. This value may be zero.
path.events.dv360_cpm_fee_4_advertiser_currency int
The CPM 4 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_cpm_fee_4_partner_currency int
The CPM 4 fee in partner currency nanos. This value may be zero.
path.events.dv360_cpm_fee_4_usd int
The CPM 4 fee in USD nanos. This value may be zero.
path.events.dv360_cpm_fee_5_advertiser_currency int
The CPM 5 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_cpm_fee_5_partner_currency int
The CPM 5 fee in partner currency nanos. This value may be zero.
path.events.dv360_cpm_fee_5_usd int
The CPM 5 fee in USD nanos. This value may be zero.
path.events.dv360_creative_id int
The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
path.events.dv360_data_fees_advertiser_currency int
The cost of any data that was used to target this impression, in advertiser currency nanos.
path.events.dv360_data_fees_partner_currency int
The cost of any data that was used to target this impression, in partner currency nanos.
path.events.dv360_data_fees_usd int
The cost of any data that was used to target this impression, in USD nanos
path.events.dv360_device_type int
The numerical value of the identified device type. 0 = Computer, 1 = Other, 2 = Smart Phone, 3 = Tablet, 4 = Smart TV, 5 = Connected TV, 6 = Set Top Box, 7 = Connected Device.
path.events.dv360_exchange_id string
The Display & Video 360 numerical ID for the exchange that requested the ad.
path.events.dv360_insertion_order_id int
The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.
path.events.dv360_isp_id int
The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
path.events.dv360_language string
The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.
path.events.dv360_line_item_id int
The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.
path.events.dv360_matching_targeted_keywords string
A comma separated string containing a list of targeted keywords matching the page related to the view event, for example "apple,orange,banana". Although the page related to the view event may match many keywords, only those which were targeted will be included; if the list of keywords is large we may impose a limit to the number of keywords returned.
path.events.dv360_matching_targeted_segments string
Space-separated IDs of targeted user lists that match the visitor, for example "-4 456". If the visitor is in a user list that is not targeted by the ad associated with this event it will not be included here.
path.events.dv360_media_cost_advertiser_currency int
The amount paid for the impression in advertiser currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
path.events.dv360_media_cost_partner_currency int
The amount paid for the impression in the partner currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
path.events.dv360_media_cost_usd int
The amount paid for the impression in USD nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
path.events.dv360_media_fee_1_advertiser_currency int
The Media Fee 1 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_media_fee_1_partner_currency int
The Media Fee 1 fee in partner currency nanos. This value may be zero.
path.events.dv360_media_fee_1_usd int
The Media Fee 1 fee in USD nanos. This value may be zero.
path.events.dv360_media_fee_2_advertiser_currency int
The Media Fee 2 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_media_fee_2_partner_currency int
The Media Fee 2 fee in partner currency nanos. This value may be zero.
path.events.dv360_media_fee_2_usd int
The Media Fee 2 fee in USD nanos. This value may be zero.
path.events.dv360_media_fee_3_advertiser_currency int
The Media Fee 3 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_media_fee_3_partner_currency int
The Media Fee 3 fee in partner currency nanos. This value may be zero.
path.events.dv360_media_fee_3_usd int
The Media Fee 3 fee in USD nanos. This value may be zero.
path.events.dv360_media_fee_4_advertiser_currency int
The Media Fee 4 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_media_fee_4_partner_currency int
The Media Fee 4 fee in partner currency nanos. This value may be zero.
path.events.dv360_media_fee_4_usd int
The Media Fee 4 fee in USD nanos. This value may be zero.
path.events.dv360_media_fee_5_advertiser_currency int
The Media Fee 5 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_media_fee_5_partner_currency int
The Media Fee 5 fee in partner currency nanos. This value may be zero.
path.events.dv360_media_fee_5_usd int
The Media Fee 5 fee in USD nanos. This value may be zero.
path.events.dv360_mobile_model_id int
The numerical ID for the mobile model. This value may be missing.
path.events.dv360_net_speed int
The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.
path.events.dv360_request_time int
A Unix timestamp in microseconds (1/1,000,000 second) for when we received the ad request, for example1330403779608570 represents Tuesday February 28th 2012 04:36:19.608570. Although this value is consistent across the view, click and conversion even it is not guaranteed to be unique - use auction_id to join events
path.events.dv360_revenue_advertiser_currency int
DV360 revenue advertiser currency
path.events.dv360_revenue_partner_currency int
DV360 revenue partner currency
path.events.dv360_revenue_usd int
DV360 revenue usd
path.events.dv360_site_id int
The Display & Video 360 numerical ID for the most specific universal site that matches the url.
path.events.dv360_state_region_id int
An integer matching the state/region integer available in reporting and targeting.
path.events.dv360_url string
The raw URL taken from the bid request received from the exchange, for example "http://www.example.com". As some exchanges mask the URL in their bid requests this value may be: "source_url_hidden"
path.events.dv360_view_state string
Populated for wrapped tags. (Two impression records when both events occur.) Possible values are: "OUTER", DV360 returned wrapped tag; "INNER", ad served post wrapped tag; "3PAS_MERGED", wrapped tag tracked by CM; "3PAS_OUTER", tracking ping sent to CM but no response, 3rd party blocked ad serving.
path.events.dv360_zip_postal_code string
The postal code identifying the best-guess postal area of the impression if known, for example "98033". Do not assume uniqueness across different countries.
path.events.event_sub_type string
Event sub type
path.events.event_time int
Time in microseconds since 1970-01-01 00:00:00 UTC.
path.events.event_type string
Contains details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "CONVERSION" or "MODELED_CONVERSION" for conversion events.
path.events.floodlight_config_id int
Unique ID of the floodlight configuration. ID
path.events.impression_id string
Impression ID
path.events.interaction_time_utc_seconds string
The activity's associated (aka 'matched') click or impression time in microseconds since 1970-01-01 00:00:00 UTC.
path.events.landing_page_url_id int
Landing page url ID
path.events.operating_system_id int
ID of the operating system.
path.events.ord_value string
The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)
path.events.other_data string
Stores key-value data from the activity string which is not otherwise labeled. (Any key-value that is NOT "src=", "type=", "cat=", "ord=", "u=", "cost=", "qty=", "tran=", "a=", or "b="). (Can be used for further product breakdown aka "Custom Floodlight Variables")
path.events.placement_id int
Unique ID for the site page / placement where the ad ran.
path.events.referrer_url string
Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.
path.events.rendering_id int
Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
path.events.rich_media_event_counters int
Rich media event counters
path.events.rich_media_event_id int
MET Event ID for the Rich Media ad.
path.events.rich_media_event_timers double
Rich media event timers
path.events.rich_media_event_type_id int
ID of Rich Media Event Type.
path.events.segment_value_1 int
Segment value 1
path.events.site_id int
Site ID
path.events.state string
State
path.events.tran_value string
Tran value
path.events.u_value string
U value
path.events.zip_code string
Postal-Code (US/Canada).
user_id opaque
The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons. User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

DV360 Data Transfer Active View plus

dv360_dt_active_view_plus
event struct
event.active_view_audible_impressions int
Active View: Impressions Audible
event.active_view_audible_time_msec int
Active View: Play Time Audible (milliseconds)
event.active_view_audible_visible_time_msec int
Active View: Play Time Audible and Visible (milliseconds)
event.active_view_background_count int
Active View: Impressions In Background
event.active_view_complete_viewable_impressions int
Active View: Impressions Visible at Completion
event.active_view_eligible_impressions int
Whether the impression was eligible to measure viewability. An impression is eligible if (a) the ad's creative has an Active View tag and (b) the tag successfully communicates with Google Marketing Platform servers at the time of the impression.
event.active_view_first_quartile_viewable_audible_impressions int
Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressions int
Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_count int
Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completion int
Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_seconds int
Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressions int
Whether the impression was measurable with Active View.
event.active_view_midpoint_viewable_audible_impressions int
Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressions int
Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_count int
Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressions int
Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressions int
Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressions int
Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressions int
Active View: Impressions Visible at Third Quartile
event.active_view_tos_msec int
Active View: Time on Screen (milliseconds)
event.active_view_viewable_impressions int
Whether the impression was viewable.
event.active_view_visible_time_msec int
Active View: Video Visible Time (milliseconds)
event.activity_count int
Activity Quantity
event.activity_id int
The ID of the Floodlight tag related to the conversion event.
event.activity_revenue double
Activity Revenue
event.ad_id int
Unique ID of the ad placement.
event.advertiser_id int
Unique ID of the advertiser
event.browser_platform_id string
ID of the browser type.
event.browser_version string
Browser/Platform Version
event.campaign_id int
The unique ID of the Campaign Manager 360 campaign
event.city_id int
City ID
event.conversion_id int
Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0).
event.country_code string
Country
event.creative_version string
Creative version number.
event.dma_region_id int
Designated Market Area ID (US/Canada).
event.dv360_ad_position int
Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_id int
The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categories string
DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_id string
The external ID of the attributed inventory source that Display & Video 360 selected as the best match from those accessible to the advertiser related to the view event based on floor price and auction type.
event.dv360_attributed_inventory_source_is_public string
True if inventory source is available to all buyers. False otherwise.
event.dv360_auction_id string
A string used to join events among view/click/conversion types, for example"ABCDEFGH_abcdefgh-0123456789". Do not assume any ordering, structure or meaning to the auction_id value.
event.dv360_bid_price_advertiser_currency int
The bid price sent to the exchange in advertiser currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_partner_currency int
The bid price sent to the exchange in partner currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_usd int
The bid price sent to the exchange in USD nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics..
event.dv360_billable_cost_advertiser_currency int
The total amount of money billed to the partner, including the media cost and partner costs, in advertiser currency nanos.
event.dv360_billable_cost_partner_currency int
The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.
event.dv360_billable_cost_usd int
The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.
event.dv360_browser_id int
The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutes int
The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.
event.dv360_campaign_id int
The unique ID of the linked Display & Video 360 campaign.
event.dv360_city_id int
The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_code string
2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_cpm_fee_1_advertiser_currency int
event.dv360_cpm_fee_1_partner_currency int
event.dv360_cpm_fee_1_usd int
event.dv360_cpm_fee_2_advertiser_currency int
event.dv360_cpm_fee_2_partner_currency int
event.dv360_cpm_fee_2_usd int
event.dv360_cpm_fee_3_advertiser_currency int
event.dv360_cpm_fee_3_partner_currency int
event.dv360_cpm_fee_3_usd int
event.dv360_cpm_fee_4_advertiser_currency int
event.dv360_cpm_fee_4_partner_currency int
event.dv360_cpm_fee_4_usd int
event.dv360_cpm_fee_5_advertiser_currency int
event.dv360_cpm_fee_5_partner_currency int
event.dv360_cpm_fee_5_usd int
event.dv360_creative_id int
The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_data_fees_advertiser_currency int
event.dv360_data_fees_partner_currency int
event.dv360_data_fees_usd int
event.dv360_device_type int
The numerical value of the identified device type. 0 = Computer, 1 = Other, 2 = Smart Phone, 3 = Tablet, 4 = Smart TV, 5 = Connected TV, 6 = Set Top Box, 7 = Connected Device.
event.dv360_exchange_id string
The Display & Video 360 numerical ID for the exchange that requested the ad.
event.dv360_insertion_order_id int
The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.
event.dv360_isp_id int
The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_language string
The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.
event.dv360_line_item_id int
The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.
event.dv360_matching_targeted_keywords string
A comma separated string containing a list of targeted keywords matching the page related to the view event, for example "apple,orange,banana". Although the page related to the view event may match many keywords, only those which were targeted will be included; if the list of keywords is large we may impose a limit to the number of keywords returned.
event.dv360_matching_targeted_segments string
Space-separated IDs of targeted user lists that match the visitor, for example "-4 456". If the visitor is in a user list that is not targeted by the ad associated with this event it will not be included here.
event.dv360_media_cost_advertiser_currency int
The amount paid for the impression in advertiser currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_partner_currency int
The amount paid for the impression in the partner currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_usd int
The amount paid for the impression in USD nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_fee_1_advertiser_currency int
event.dv360_media_fee_1_partner_currency int
event.dv360_media_fee_1_usd int
event.dv360_media_fee_2_advertiser_currency int
event.dv360_media_fee_2_partner_currency int
event.dv360_media_fee_2_usd int
event.dv360_media_fee_3_advertiser_currency int
event.dv360_media_fee_3_partner_currency int
event.dv360_media_fee_3_usd int
event.dv360_media_fee_4_advertiser_currency int
event.dv360_media_fee_4_partner_currency int
event.dv360_media_fee_4_usd int
event.dv360_media_fee_5_advertiser_currency int
event.dv360_media_fee_5_partner_currency int
event.dv360_media_fee_5_usd int
event.dv360_mobile_make_id int
The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_id int
The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speed int
The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.
event.dv360_operating_system_id int
event.dv360_request_time int
A Unix timestamp in microseconds (1/1,000,000 second) for when we received the ad request, for example1330403779608570 represents Tuesday February 28th 2012 04:36:19.608570. Although this value is consistent across the view, click and conversion even it is not guaranteed to be unique - use auction_id to join events
event.dv360_revenue_advertiser_currency int
The total amount in advertiser currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_partner_currency int
The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_usd int
The total amount in USD nanos made by the partner account for the view event. This value may be zero.
event.dv360_site_id int
The Display & Video 360 numerical ID for the most specific universal site that matches the url.
event.dv360_state_region_id int
DV360 Region ID
event.dv360_url string
The raw URL taken from the bid request received from the exchange, for example "http://www.example.com". As some exchanges mask the URL in their bid requests this value may be: "source_url_hidden"
event.dv360_view_state string
Populated for wrapped tags. (Two impression records when both events occur.) Possible values are: "OUTER", DV360 returned wrapped tag; "INNER", ad served post wrapped tag; "3PAS_MERGED", wrapped tag tracked by CM; "3PAS_OUTER", tracking ping sent to CM but no response, 3rd party blocked ad serving.
event.dv360_zip_postal_code string
DV360 ZIP/Postal Code
event.event_sub_type string
Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
event.event_time int
Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_type string
Contains "VIDEO_ACTIVE_VIEW_SESSION".
event.floodlight_config_id int
Unique ID of the floodlight configuration.
event.impression_id string
Impression ID
event.interaction_time_utc_seconds string
Interaction Time
event.landing_page_url_id int
Unique ID of the landing page URL.
event.operating_system_id int
ID of the operating system.
event.ord_value string
The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)
event.other_data string
Stores key-value data from the activity string which is not otherwise labeled. (Any key-value that is NOT "src=", "type=", "cat=", "ord=", "u=", "cost=", "qty=", "tran=", "a=", or "b="). (Can be used for further product breakdown aka "Custom Floodlight Variables")
event.placement_id int
Unique ID for the site page / placement where the ad ran.
event.platform_type_id int
Identifier that maps to the platform on which the event occured. Possible values are: 30000: desktop, 30001: high-end smartphone, 30002: tablet, 30003: mid-range smartphone, 30004: connected TV, 30005: unknown, 30006: set top box.
event.rendering_id int
Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_counters int
MET Counter Value (the ecn= value).
event.rich_media_event_id int
MET Event ID for the Rich Media ad.
event.rich_media_event_timers double
Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_id int
ID of Rich Media Event Type.
event.segment_value_1 int
Segment Value 1
event.site_id int
Unique ID for the site where the ad ran.
event.state string
ID for user's state or province (US/Canada)
event.tran_value string
TRAN Value
event.u_value string
U Value
event.zip_code string
Postal-Code (US/Canada).
network_id int
The network ID.
user_id opaque
The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons. User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

DV360 Data Transfer activities (deprecated)

dv360_dt_activities
device_id_md5 string
MD5-hashed device ID. Utility will be provided to hash raw device IDs to match.
event struct
event.active_view_audible_impressions int
Active View: Impressions Audible
event.active_view_audible_time_msec int
Active View: Play Time Audible (milliseconds)
event.active_view_audible_visible_time_msec int
Active View: Play Time Audible and Visible (milliseconds)
event.active_view_background_count int
Active View: Impressions In Background
event.active_view_complete_viewable_impressions int
Active View: Impressions Visible at Completion
event.active_view_eligible_impressions int
Whether the impression was eligible to measure viewability. An impression is eligible if (a) the ad's creative has an Active View tag and (b) the tag successfully communicates with Google Marketing Platform servers at the time of the impression.
event.active_view_first_quartile_viewable_audible_impressions int
Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressions int
Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_count int
Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completion int
Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_seconds int
Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressions int
Whether the impression was measurable with Active View.
event.active_view_midpoint_viewable_audible_impressions int
Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressions int
Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_count int
Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressions int
Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressions int
Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressions int
Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressions int
Active View: Impressions Visible at Third Quartile
event.active_view_tos_msec int
Active View: Time on Screen (milliseconds)
event.active_view_viewable_impressions int
Whether the impression was viewable.
event.active_view_visible_time_msec int
Active View: Video Visible Time (milliseconds)
event.activity_count int
Activity Quantity
event.activity_id int
The ID of the Floodlight tag related to the conversion event.
event.activity_revenue double
Activity Revenue
event.ad_id int
Unique ID of the ad placement.
event.advertiser_id int
Unique ID of the advertiser
event.browser_platform_id string
ID of the browser type.
event.browser_version string
Browser/Platform Version
event.campaign_id int
The unique ID of the Campaign Manager 360 campaign
event.city_id int
City ID
event.conversion_id int
Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0).
event.country_code string
Country
event.creative_version string
Creative version number.
event.dma_region_id int
Designated Market Area ID (US/Canada).
event.dv360_ad_position int
Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_id int
The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categories string
DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_id string
The external ID of the attributed inventory source that Display & Video 360 selected as the best match from those accessible to the advertiser related to the view event based on floor price and auction type.
event.dv360_attributed_inventory_source_is_public string
True if inventory source is available to all buyers. False otherwise.
event.dv360_auction_id string
A string used to join events among view/click/conversion types, for example"ABCDEFGH_abcdefgh-0123456789". Do not assume any ordering, structure or meaning to the auction_id value.
event.dv360_bid_price_advertiser_currency int
The bid price sent to the exchange in advertiser currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_partner_currency int
The bid price sent to the exchange in partner currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_usd int
The bid price sent to the exchange in USD nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics..
event.dv360_billable_cost_advertiser_currency int
The total amount of money billed to the partner, including the media cost and partner costs, in advertiser currency nanos.
event.dv360_billable_cost_partner_currency int
The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.
event.dv360_billable_cost_usd int
The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.
event.dv360_browser_id int
The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutes int
The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.
event.dv360_campaign_id int
The unique ID of the linked Display & Video 360 campaign.
event.dv360_city_id int
The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_code string
2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_cpm_fee_1_advertiser_currency int
event.dv360_cpm_fee_1_partner_currency int
event.dv360_cpm_fee_1_usd int
event.dv360_cpm_fee_2_advertiser_currency int
event.dv360_cpm_fee_2_partner_currency int
event.dv360_cpm_fee_2_usd int
event.dv360_cpm_fee_3_advertiser_currency int
event.dv360_cpm_fee_3_partner_currency int
event.dv360_cpm_fee_3_usd int
event.dv360_cpm_fee_4_advertiser_currency int
event.dv360_cpm_fee_4_partner_currency int
event.dv360_cpm_fee_4_usd int
event.dv360_cpm_fee_5_advertiser_currency int
event.dv360_cpm_fee_5_partner_currency int
event.dv360_cpm_fee_5_usd int
event.dv360_creative_id int
The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_data_fees_advertiser_currency int
event.dv360_data_fees_partner_currency int
event.dv360_data_fees_usd int
event.dv360_device_type int
The numerical value of the identified device type. 0 = Computer, 1 = Other, 2 = Smart Phone, 3 = Tablet, 4 = Smart TV, 5 = Connected TV, 6 = Set Top Box, 7 = Connected Device.
event.dv360_exchange_id string
The Display & Video 360 numerical ID for the exchange that requested the ad.
event.dv360_insertion_order_id int
The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.
event.dv360_isp_id int
The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_language string
The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.
event.dv360_line_item_id int
The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.
event.dv360_matching_targeted_keywords string
A comma separated string containing a list of targeted keywords matching the page related to the view event, for example "apple,orange,banana". Although the page related to the view event may match many keywords, only those which were targeted will be included; if the list of keywords is large we may impose a limit to the number of keywords returned.
event.dv360_matching_targeted_segments string
Space-separated IDs of targeted user lists that match the visitor, for example "-4 456". If the visitor is in a user list that is not targeted by the ad associated with this event it will not be included here.
event.dv360_media_cost_advertiser_currency int
The amount paid for the impression in advertiser currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_partner_currency int
The amount paid for the impression in the partner currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_usd int
The amount paid for the impression in USD nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_fee_1_advertiser_currency int
event.dv360_media_fee_1_partner_currency int
event.dv360_media_fee_1_usd int
event.dv360_media_fee_2_advertiser_currency int
event.dv360_media_fee_2_partner_currency int
event.dv360_media_fee_2_usd int
event.dv360_media_fee_3_advertiser_currency int
event.dv360_media_fee_3_partner_currency int
event.dv360_media_fee_3_usd int
event.dv360_media_fee_4_advertiser_currency int
event.dv360_media_fee_4_partner_currency int
event.dv360_media_fee_4_usd int
event.dv360_media_fee_5_advertiser_currency int
event.dv360_media_fee_5_partner_currency int
event.dv360_media_fee_5_usd int
event.dv360_mobile_make_id int
The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_id int
The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speed int
The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.
event.dv360_operating_system_id int
event.dv360_request_time int
A Unix timestamp in microseconds (1/1,000,000 second) for when we received the ad request, for example1330403779608570 represents Tuesday February 28th 2012 04:36:19.608570. Although this value is consistent across the view, click and conversion even it is not guaranteed to be unique - use auction_id to join events
event.dv360_revenue_advertiser_currency int
The total amount in advertiser currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_partner_currency int
The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_usd int
The total amount in USD nanos made by the partner account for the view event. This value may be zero.
event.dv360_site_id int
The Display & Video 360 numerical ID for the most specific universal site that matches the url.
event.dv360_state_region_id int
DV360 Region ID
event.dv360_url string
The raw URL taken from the bid request received from the exchange, for example "http://www.example.com". As some exchanges mask the URL in their bid requests this value may be: "source_url_hidden"
event.dv360_view_state string
Populated for wrapped tags. (Two impression records when both events occur.) Possible values are: "OUTER", DV360 returned wrapped tag; "INNER", ad served post wrapped tag; "3PAS_MERGED", wrapped tag tracked by CM; "3PAS_OUTER", tracking ping sent to CM but no response, 3rd party blocked ad serving.
event.dv360_zip_postal_code string
DV360 ZIP/Postal Code
event.event_sub_type string
Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
event.event_time int
Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_type string
Contains details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "CONVERSION" or blank for conversion events.
event.floodlight_config_id int
Unique ID of the floodlight configuration.
event.impression_id string
Impression ID
event.interaction_time_utc_seconds string
Interaction Time
event.landing_page_url_id int
Unique ID of the landing page URL.
event.operating_system_id int
ID of the operating system.
event.ord_value string
The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)
event.other_data string
Stores key-value data from the activity string which is not otherwise labeled. (Any key-value that is NOT "src=", "type=", "cat=", "ord=", "u=", "cost=", "qty=", "tran=", "a=", or "b="). (Can be used for further product breakdown aka "Custom Floodlight Variables")
event.placement_id int
Unique ID for the site page / placement where the ad ran.
event.rendering_id int
Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_counters int
MET Counter Value (the ecn= value).
event.rich_media_event_id int
MET Event ID for the Rich Media ad.
event.rich_media_event_timers double
Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_id int
ID of Rich Media Event Type.
event.segment_value_1 int
Segment Value 1
event.site_id int
Unique ID for the site where the ad ran.
event.state string
ID for user's state or province (US/Canada)
event.tran_value string
TRAN Value
event.u_value string
U Value
event.zip_code string
Postal-Code (US/Canada).
network_id int
The network ID.
user_id opaque
The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons. User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

DV360 Data Transfer activities attributed

dv360_dt_activities_attributed
event struct
event.activity_id int
The ID of the Floodlight tag related to the conversion event.
event.ad_id int
Unique ID of the ad placement.
event.advertiser_id int
Unique ID of the advertiser
event.attribution_model_config_id int
Attribution model ID as displayed in DV360 UI.
event.browser_platform_id string
ID of the browser type.
event.browser_version string
Browser/Platform Version
event.campaign_id int
The unique ID of the Campaign Manager 360 campaign
event.city_id int
City ID
event.conversion_event_id string
Unique ID of the conversion event.
event.country_code string
Country
event.creative_version string
Creative version number.
event.dma_region_id int
Designated Market Area ID (US/Canada).
event.dv360_ad_position int
Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_id int
The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categories string
DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_id string
The external ID of the attributed inventory source that Display & Video 360 selected as the best match from those accessible to the advertiser related to the view event based on floor price and auction type.
event.dv360_attributed_inventory_source_is_public string
True if inventory source is available to all buyers. False otherwise.
event.dv360_auction_id string
A string used to join events among view/click/conversion types, for example"ABCDEFGH_abcdefgh-0123456789". Do not assume any ordering, structure or meaning to the auction_id value.
event.dv360_bid_price_advertiser_currency int
The bid price sent to the exchange in advertiser currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_partner_currency int
The bid price sent to the exchange in partner currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_usd int
The bid price sent to the exchange in USD nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics..
event.dv360_billable_cost_advertiser_currency int
The total amount of money billed to the partner, including the media cost and partner costs, in advertiser currency nanos.
event.dv360_billable_cost_partner_currency int
The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.
event.dv360_billable_cost_usd int
The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.
event.dv360_browser_id int
The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutes int
The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.
event.dv360_campaign_id int
The unique ID of the linked Display & Video 360 campaign.
event.dv360_city_id int
The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_code string
2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_cpm_fee_1_advertiser_currency int
event.dv360_cpm_fee_1_partner_currency int
event.dv360_cpm_fee_1_usd int
event.dv360_cpm_fee_2_advertiser_currency int
event.dv360_cpm_fee_2_partner_currency int
event.dv360_cpm_fee_2_usd int
event.dv360_cpm_fee_3_advertiser_currency int
event.dv360_cpm_fee_3_partner_currency int
event.dv360_cpm_fee_3_usd int
event.dv360_cpm_fee_4_advertiser_currency int
event.dv360_cpm_fee_4_partner_currency int
event.dv360_cpm_fee_4_usd int
event.dv360_cpm_fee_5_advertiser_currency int
event.dv360_cpm_fee_5_partner_currency int
event.dv360_cpm_fee_5_usd int
event.dv360_creative_id int
The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_data_fees_advertiser_currency int
event.dv360_data_fees_partner_currency int
event.dv360_data_fees_usd int
event.dv360_device_type int
The numerical value of the identified device type. 0 = Computer, 1 = Other, 2 = Smart Phone, 3 = Tablet, 4 = Smart TV, 5 = Connected TV, 6 = Set Top Box, 7 = Connected Device.
event.dv360_exchange_id string
The Display & Video 360 numerical ID for the exchange that requested the ad.
event.dv360_insertion_order_id int
The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.
event.dv360_isp_id int
The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_language string
The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.
event.dv360_line_item_id int
The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.
event.dv360_matching_targeted_keywords string
A comma separated string containing a list of targeted keywords matching the page related to the view event, for example "apple,orange,banana". Although the page related to the view event may match many keywords, only those which were targeted will be included; if the list of keywords is large we may impose a limit to the number of keywords returned.
event.dv360_matching_targeted_segments string
Space-separated IDs of targeted user lists that match the visitor, for example "-4 456". If the visitor is in a user list that is not targeted by the ad associated with this event it will not be included here.
event.dv360_media_cost_advertiser_currency int
The amount paid for the impression in advertiser currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_partner_currency int
The amount paid for the impression in the partner currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_usd int
The amount paid for the impression in USD nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_fee_1_advertiser_currency int
event.dv360_media_fee_1_partner_currency int
event.dv360_media_fee_1_usd int
event.dv360_media_fee_2_advertiser_currency int
event.dv360_media_fee_2_partner_currency int
event.dv360_media_fee_2_usd int
event.dv360_media_fee_3_advertiser_currency int
event.dv360_media_fee_3_partner_currency int
event.dv360_media_fee_3_usd int
event.dv360_media_fee_4_advertiser_currency int
event.dv360_media_fee_4_partner_currency int
event.dv360_media_fee_4_usd int
event.dv360_media_fee_5_advertiser_currency int
event.dv360_media_fee_5_partner_currency int
event.dv360_media_fee_5_usd int
event.dv360_mobile_make_id int
The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_id int
The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speed int
The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.
event.dv360_operating_system_id int
Operating System ID.
event.dv360_request_time int
A Unix timestamp in microseconds (1/1,000,000 second) for when we received the ad request, for example1330403779608570 represents Tuesday February 28th 2012 04:36:19.608570. Although this value is consistent across the view, click and conversion even it is not guaranteed to be unique - use auction_id to join events
event.dv360_revenue_advertiser_currency int
The total amount in advertiser currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_partner_currency int
The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_usd int
The total amount in USD nanos made by the partner account for the view event. This value may be zero.
event.dv360_site_id int
The Display & Video 360 numerical ID for the most specific universal site that matches the url.
event.dv360_state_region_id int
DV360 Region ID
event.dv360_url string
The raw URL taken from the bid request received from the exchange, for example "http://www.example.com". As some exchanges mask the URL in their bid requests this value may be: "source_url_hidden"
event.dv360_view_state string
Populated for wrapped tags. (Two impression records when both events occur.) Possible values are: "OUTER", DV360 returned wrapped tag; "INNER", ad served post wrapped tag; "3PAS_MERGED", wrapped tag tracked by CM; "3PAS_OUTER", tracking ping sent to CM but no response, 3rd party blocked ad serving.
event.dv360_zip_postal_code string
DV360 ZIP/Postal Code
event.event_sub_type string
Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
event.event_time int
Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_type string
Contains "CONVERSION" or "MODELED_CONVERSION".
event.floodlight_config_id int
Unique ID of the floodlight configuration.
event.interaction_time_utc_seconds string
Interaction Time
event.landing_page_url_id int
Unique ID of the landing page URL.
event.operating_system_id int
ID of the operating system.
event.ord_value string
The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)
event.other_data string
Stores key-value data from the activity string which is not otherwise labeled. (Any key-value that is NOT "src=", "type=", "cat=", "ord=", "u=", "cost=", "qty=", "tran=", "a=", or "b="). (Can be used for further product breakdown aka "Custom Floodlight Variables")
event.placement_id int
Unique ID for the site page / placement where the ad ran.
event.rendering_id int
Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_counters int
MET Counter Value (the ecn= value).
event.rich_media_event_id int
MET Event ID for the Rich Media ad.
event.rich_media_event_timers double
Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_id int
ID of Rich Media Event Type.
event.segment_value_1 int
Segment Value 1
event.site_id int
Unique ID for the site where the ad ran.
event.state string
ID for user's state or province (US/Canada)
event.total_conversions double
The amount of conversion credit in nanos credited to the attributed event. For sales activities, Floodlight might count more than one conversion per event. For example, you can set up Floodlight to count the number of items purchased as the number of conversions for a single event. (The double value of the int event.activity_count in activities_events)
event.total_conversions_revenue double
The amount of revenue in USD megas credited to the attributed. You can multiply by 1,000,000 to see it as a dollar amount. (The attributed version of event.activity_revenue in activities_events)
event.total_transaction_count double
The number of transactions or activity tag fires in nanos credited to the attributed event.
event.tran_value string
TRAN Value
event.u_value string
U Value
event.zip_code string
Postal-Code (US/Canada).
network_id int
The network ID.
user_id opaque
The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons. User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

DV360 Data Transfer advertiser

dv360_dt_advertiser
dv360_advertiser string
Name of the advertiser.
dv360_advertiser_id int
Unique ID of the advertiser.
dv360_partner_id int
Unique ID of the partner.

DV360 Data Transfer campaign

dv360_dt_campaign
dv360_advertiser_id int
Unique ID of the advertiser.
dv360_campaign string
Name of the campaign
dv360_campaign_id int
The unique ID of the Display & Video 360 campaign.
dv360_partner_id int
Unique ID of the partner.

DV360 Data Transfer clicks

dv360_dt_clicks
event struct
event.active_view_audible_impressions int
Active View: Impressions Audible
event.active_view_audible_time_msec int
Active View: Play Time Audible (milliseconds)
event.active_view_audible_visible_time_msec int
Active View: Play Time Audible and Visible (milliseconds)
event.active_view_background_count int
Active View: Impressions In Background
event.active_view_complete_viewable_impressions int
Active View: Impressions Visible at Completion
event.active_view_eligible_impressions int
Whether the impression was eligible to measure viewability. An impression is eligible if (a) the ad's creative has an Active View tag and (b) the tag successfully communicates with Google Marketing Platform servers at the time of the impression.
event.active_view_first_quartile_viewable_audible_impressions int
Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressions int
Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_count int
Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completion int
Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_seconds int
Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressions int
Whether the impression was measurable with Active View.
event.active_view_midpoint_viewable_audible_impressions int
Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressions int
Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_count int
Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressions int
Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressions int
Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressions int
Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressions int
Active View: Impressions Visible at Third Quartile
event.active_view_tos_msec int
Active View: Time on Screen (milliseconds)
event.active_view_viewable_impressions int
Whether the impression was viewable.
event.active_view_visible_time_msec int
Active View: Video Visible Time (milliseconds)
event.activity_count int
Activity Quantity
event.activity_id int
The ID of the Floodlight tag related to the conversion event.
event.activity_revenue double
Activity Revenue
event.ad_id int
Unique ID of the ad placement.
event.advertiser_id int
Unique ID of the advertiser
event.audience_segment_id int
Unique ID of the audience segment.
event.browser_platform_id string
ID of the browser type.
event.browser_version string
Browser/Platform Version
event.campaign_id int
The unique ID of the Campaign Manager 360 campaign
event.city_id int
City ID
event.conversion_id int
Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0).
event.country_code string
Country
event.creative_version string
Creative version number.
event.dma_region_id int
Designated Market Area ID (US/Canada).
event.dv360_ad_position int
Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_id int
The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categories string
DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_id string
The external ID of the attributed inventory source that Display & Video 360 selected as the best match from those accessible to the advertiser related to the view event based on floor price and auction type.
event.dv360_attributed_inventory_source_is_public string
True if inventory source is available to all buyers. False otherwise.
event.dv360_auction_id string
A string used to join events among view/click/conversion types, for example"ABCDEFGH_abcdefgh-0123456789". Do not assume any ordering, structure or meaning to the auction_id value.
event.dv360_bid_price_advertiser_currency int
The bid price sent to the exchange in advertiser currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_partner_currency int
The bid price sent to the exchange in partner currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_usd int
The bid price sent to the exchange in USD nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics..
event.dv360_billable_cost_advertiser_currency int
The total amount of money billed to the partner, including the media cost and partner costs, in advertiser currency nanos.
event.dv360_billable_cost_partner_currency int
The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.
event.dv360_billable_cost_usd int
The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.
event.dv360_browser_id int
The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutes int
The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.
event.dv360_campaign_id int
The unique ID of the linked Display & Video 360 campaign.
event.dv360_city_id int
The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_code string
2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_cpm_fee_1_advertiser_currency int
event.dv360_cpm_fee_1_partner_currency int
event.dv360_cpm_fee_1_usd int
event.dv360_cpm_fee_2_advertiser_currency int
event.dv360_cpm_fee_2_partner_currency int
event.dv360_cpm_fee_2_usd int
event.dv360_cpm_fee_3_advertiser_currency int
event.dv360_cpm_fee_3_partner_currency int
event.dv360_cpm_fee_3_usd int
event.dv360_cpm_fee_4_advertiser_currency int
event.dv360_cpm_fee_4_partner_currency int
event.dv360_cpm_fee_4_usd int
event.dv360_cpm_fee_5_advertiser_currency int
event.dv360_cpm_fee_5_partner_currency int
event.dv360_cpm_fee_5_usd int
event.dv360_creative_id int
The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_data_fees_advertiser_currency int
event.dv360_data_fees_partner_currency int
event.dv360_data_fees_usd int
event.dv360_device_type int
The numerical value of the identified device type. 0 = Computer, 1 = Other, 2 = Smart Phone, 3 = Tablet, 4 = Smart TV, 5 = Connected TV, 6 = Set Top Box, 7 = Connected Device.
event.dv360_exchange_id string
The Display & Video 360 numerical ID for the exchange that requested the ad.
event.dv360_insertion_order_id int
The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.
event.dv360_isp_id int
The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_language string
The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.
event.dv360_line_item_id int
The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.
event.dv360_matching_targeted_keywords string
A comma separated string containing a list of targeted keywords matching the page related to the view event, for example "apple,orange,banana". Although the page related to the view event may match many keywords, only those which were targeted will be included; if the list of keywords is large we may impose a limit to the number of keywords returned.
event.dv360_matching_targeted_segments string
Space-separated IDs of targeted user lists that match the visitor, for example "-4 456". If the visitor is in a user list that is not targeted by the ad associated with this event it will not be included here.
event.dv360_media_cost_advertiser_currency int
The amount paid for the impression in advertiser currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_partner_currency int
The amount paid for the impression in the partner currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_usd int
The amount paid for the impression in USD nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_fee_1_advertiser_currency int
event.dv360_media_fee_1_partner_currency int
event.dv360_media_fee_1_usd int
event.dv360_media_fee_2_advertiser_currency int
event.dv360_media_fee_2_partner_currency int
event.dv360_media_fee_2_usd int
event.dv360_media_fee_3_advertiser_currency int
event.dv360_media_fee_3_partner_currency int
event.dv360_media_fee_3_usd int
event.dv360_media_fee_4_advertiser_currency int
event.dv360_media_fee_4_partner_currency int
event.dv360_media_fee_4_usd int
event.dv360_media_fee_5_advertiser_currency int
event.dv360_media_fee_5_partner_currency int
event.dv360_media_fee_5_usd int
event.dv360_mobile_make_id int
The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_id int
The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speed int
The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.
event.dv360_operating_system_id int
event.dv360_request_time int
A Unix timestamp in microseconds (1/1,000,000 second) for when we received the ad request, for example1330403779608570 represents Tuesday February 28th 2012 04:36:19.608570. Although this value is consistent across the view, click and conversion even it is not guaranteed to be unique - use auction_id to join events
event.dv360_revenue_advertiser_currency int
The total amount in advertiser currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_partner_currency int
The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_usd int
The total amount in USD nanos made by the partner account for the view event. This value may be zero.
event.dv360_site_id int
The Display & Video 360 numerical ID for the most specific universal site that matches the url.
event.dv360_state_region_id int
DV360 Region ID
event.dv360_url string
The raw URL taken from the bid request received from the exchange, for example "http://www.example.com". As some exchanges mask the URL in their bid requests this value may be: "source_url_hidden"
event.dv360_view_state string
Populated for wrapped tags. (Two impression records when both events occur.) Possible values are: "OUTER", DV360 returned wrapped tag; "INNER", ad served post wrapped tag; "3PAS_MERGED", wrapped tag tracked by CM; "3PAS_OUTER", tracking ping sent to CM but no response, 3rd party blocked ad serving.
event.dv360_zip_postal_code string
DV360 ZIP/Postal Code
event.event_sub_type string
Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
event.event_time int
Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_type string
Contains "CLICK".
event.floodlight_config_id int
Unique ID of the floodlight configuration.
event.impression_id string
Impression ID
event.interaction_time_utc_seconds string
Interaction Time
event.landing_page_url_id int
Unique ID of the landing page URL.
event.operating_system_id int
ID of the operating system.
event.ord_value string
The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)
event.other_data string
Stores key-value data from the activity string which is not otherwise labeled. (Any key-value that is NOT "src=", "type=", "cat=", "ord=", "u=", "cost=", "qty=", "tran=", "a=", or "b="). (Can be used for further product breakdown aka "Custom Floodlight Variables")
event.placement_id int
Unique ID for the site page / placement where the ad ran.
event.platform_type_id int
Identifier that maps to the platform on which the event occured. Possible values are: 30000: desktop, 30001: high-end smartphone, 30002: tablet, 30003: mid-range smartphone, 30004: connected TV, 30005: unknown, 30006: set top box.
event.rendering_id int
Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_counters int
MET Counter Value (the ecn= value).
event.rich_media_event_id int
MET Event ID for the Rich Media ad.
event.rich_media_event_timers double
Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_id int
ID of Rich Media Event Type.
event.segment_value_1 int
Segment Value 1
event.site_id int
Unique ID for the site where the ad ran.
event.state string
ID for user's state or province (US/Canada)
event.tran_value string
TRAN Value
event.u_value string
U Value
event.zip_code string
Postal-Code (US/Canada).
network_id int
The network ID.
user_id opaque
The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons. User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

DV360 Data Transfer impressions

dv360_dt_impressions
event struct
event.active_view_audible_impressions int
Active View: Impressions Audible
event.active_view_audible_time_msec int
Active View: Play Time Audible (milliseconds)
event.active_view_audible_visible_time_msec int
Active View: Play Time Audible and Visible (milliseconds)
event.active_view_background_count int
Active View: Impressions In Background
event.active_view_complete_viewable_impressions int
Active View: Impressions Visible at Completion
event.active_view_eligible_impressions int
Whether the impression was eligible to measure viewability. An impression is eligible if (a) the ad's creative has an Active View tag and (b) the tag successfully communicates with Google Marketing Platform servers at the time of the impression.
event.active_view_first_quartile_viewable_audible_impressions int
Active View: Impressions Visible and Audible at First Quartile
event.active_view_first_quartile_viewable_impressions int
Active View: Impressions Visible at First Quartile
event.active_view_fullscreen_count int
Active View: Impressions Full-Screen
event.active_view_impressions_audible_and_visible_at_completion int
Active View: Impressions Audible and Visible at Completion
event.active_view_impressions_visible10_seconds int
Active View: Impressions Visible 10 Seconds
event.active_view_measurable_impressions int
Whether the impression was measurable with Active View.
event.active_view_midpoint_viewable_audible_impressions int
Active View: Impressions Visible and Audible at Midpoint
event.active_view_midpoint_viewable_impressions int
Active View: Impressions Visible at Midpoint
event.active_view_plus_measurable_count int
Active View Plus: Measurable Impressions
event.active_view_start_viewable_audible_impressions int
Active View: Impressions Visible and Audible at Start
event.active_view_start_viewable_impressions int
Active View: Impressions Visible at Start
event.active_view_third_quartile_viewable_audible_impressions int
Active View: Impressions Visible and Audible at Third Quartile
event.active_view_third_quartile_viewable_impressions int
Active View: Impressions Visible at Third Quartile
event.active_view_tos_msec int
Active View: Time on Screen (milliseconds)
event.active_view_viewable_impressions int
Whether the impression was viewable.
event.active_view_visible_time_msec int
Active View: Video Visible Time (milliseconds)
event.activity_count int
Activity Quantity
event.activity_id int
The ID of the Floodlight tag related to the conversion event.
event.activity_revenue double
Activity Revenue
event.ad_id int
Unique ID of the ad placement.
event.advertiser_id int
Unique ID of the advertiser
event.audience_segment_id int
Unique ID of the audience segment.
event.browser_platform_id string
ID of the browser type.
event.browser_version string
Browser/Platform Version
event.campaign_id int
The unique ID of the Campaign Manager 360 campaign
event.city_id int
City ID
event.conversion_id int
Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0).
event.country_code string
Country
event.creative_version string
Creative version number.
event.dma_region_id int
Designated Market Area ID (US/Canada).
event.dv360_ad_position int
Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
event.dv360_advertiser_id int
The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
event.dv360_adx_page_categories string
DV360 Adx Page Categories
event.dv360_attributed_inventory_source_external_id string
The external ID of the attributed inventory source that Display & Video 360 selected as the best match from those accessible to the advertiser related to the view event based on floor price and auction type.
event.dv360_attributed_inventory_source_is_public string
True if inventory source is available to all buyers. False otherwise.
event.dv360_auction_id string
A string used to join events among view/click/conversion types, for example"ABCDEFGH_abcdefgh-0123456789". Do not assume any ordering, structure or meaning to the auction_id value.
event.dv360_bid_price_advertiser_currency int
The bid price sent to the exchange in advertiser currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_partner_currency int
The bid price sent to the exchange in partner currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
event.dv360_bid_price_usd int
The bid price sent to the exchange in USD nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics..
event.dv360_bid_request_publisher_id string
The publisher id in the publisher.id field of bid request.
event.dv360_billable_cost_advertiser_currency int
The total amount of money billed to the partner, including the media cost and partner costs, in advertiser currency nanos.
event.dv360_billable_cost_partner_currency int
The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.
event.dv360_billable_cost_usd int
The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.
event.dv360_browser_id int
The Display & Video 360 numerical ID identifying the browser related to this event.
event.dv360_browser_timezone_offset_minutes int
The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.
event.dv360_campaign_id int
The unique ID of the linked Display & Video 360 campaign.
event.dv360_city_id int
The Display & Video 360 numerical ID identifying the best-guess city of the impression.
event.dv360_country_code string
2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
event.dv360_cpm_fee_1_advertiser_currency int
event.dv360_cpm_fee_1_partner_currency int
event.dv360_cpm_fee_1_usd int
event.dv360_cpm_fee_2_advertiser_currency int
event.dv360_cpm_fee_2_partner_currency int
event.dv360_cpm_fee_2_usd int
event.dv360_cpm_fee_3_advertiser_currency int
event.dv360_cpm_fee_3_partner_currency int
event.dv360_cpm_fee_3_usd int
event.dv360_cpm_fee_4_advertiser_currency int
event.dv360_cpm_fee_4_partner_currency int
event.dv360_cpm_fee_4_usd int
event.dv360_cpm_fee_5_advertiser_currency int
event.dv360_cpm_fee_5_partner_currency int
event.dv360_cpm_fee_5_usd int
event.dv360_creative_id int
The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
event.dv360_data_fees_advertiser_currency int
event.dv360_data_fees_partner_currency int
event.dv360_data_fees_usd int
event.dv360_device_type int
The numerical value of the identified device type. 0 = Computer, 1 = Other, 2 = Smart Phone, 3 = Tablet, 4 = Smart TV, 5 = Connected TV, 6 = Set Top Box, 7 = Connected Device.
event.dv360_exchange_id string
The Display & Video 360 numerical ID for the exchange that requested the ad.
event.dv360_insertion_order_id int
The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.
event.dv360_isp_id int
The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
event.dv360_language string
The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.
event.dv360_line_item_id int
The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.
event.dv360_matching_targeted_keywords string
A comma separated string containing a list of targeted keywords matching the page related to the view event, for example "apple,orange,banana". Although the page related to the view event may match many keywords, only those which were targeted will be included; if the list of keywords is large we may impose a limit to the number of keywords returned.
event.dv360_matching_targeted_segments string
Space-separated IDs of targeted user lists that match the visitor, for example "-4 456". If the visitor is in a user list that is not targeted by the ad associated with this event it will not be included here.
event.dv360_media_cost_advertiser_currency int
The amount paid for the impression in advertiser currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_partner_currency int
The amount paid for the impression in the partner currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_cost_usd int
The amount paid for the impression in USD nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
event.dv360_media_fee_1_advertiser_currency int
event.dv360_media_fee_1_partner_currency int
event.dv360_media_fee_1_usd int
event.dv360_media_fee_2_advertiser_currency int
event.dv360_media_fee_2_partner_currency int
event.dv360_media_fee_2_usd int
event.dv360_media_fee_3_advertiser_currency int
event.dv360_media_fee_3_partner_currency int
event.dv360_media_fee_3_usd int
event.dv360_media_fee_4_advertiser_currency int
event.dv360_media_fee_4_partner_currency int
event.dv360_media_fee_4_usd int
event.dv360_media_fee_5_advertiser_currency int
event.dv360_media_fee_5_partner_currency int
event.dv360_media_fee_5_usd int
event.dv360_mobile_make_id int
The numerical ID for the mobile make. This value may be missing.
event.dv360_mobile_model_id int
The numerical ID for the mobile model. This value may be missing.
event.dv360_net_speed int
The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.
event.dv360_operating_system_id int
event.dv360_request_time int
A Unix timestamp in microseconds (1/1,000,000 second) for when we received the ad request, for example1330403779608570 represents Tuesday February 28th 2012 04:36:19.608570. Although this value is consistent across the view, click and conversion even it is not guaranteed to be unique - use auction_id to join events
event.dv360_revenue_advertiser_currency int
The total amount in advertiser currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_partner_currency int
The total amount in partner currency nanos made by the partner account for the view event. This value may be zero.
event.dv360_revenue_usd int
The total amount in USD nanos made by the partner account for the view event. This value may be zero.
event.dv360_site_id int
The Display & Video 360 numerical ID for the most specific universal site that matches the url.
event.dv360_state_region_id int
DV360 Region ID
event.dv360_supply_chain_complete boolean
Indicates whether the supply chain object is complete in the bid request.
event.dv360_supply_chain_domain array
The domain in the supply path, the order is the same as the order in the supply chain JSON.
event.dv360_supply_chain_seller_id array
Array of strings. The seller ID in the supply path, the order is the same as the order in the supply chain JSON.
event.dv360_url string
The raw URL taken from the bid request received from the exchange, for example "http://www.example.com". As some exchanges mask the URL in their bid requests this value may be: "source_url_hidden"
event.dv360_view_state string
Populated for wrapped tags. (Two impression records when both events occur.) Possible values are: "OUTER", DV360 returned wrapped tag; "INNER", ad served post wrapped tag; "3PAS_MERGED", wrapped tag tracked by CM; "3PAS_OUTER", tracking ping sent to CM but no response, 3rd party blocked ad serving.
event.dv360_zip_postal_code string
DV360 ZIP/Postal Code
event.event_sub_type string
Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events.
event.event_time int
Time in microseconds since 1970-01-01 00:00:00 UTC.
event.event_type string
Contains "VIEW".
event.floodlight_config_id int
Unique ID of the floodlight configuration.
event.impression_id string
Impression ID
event.interaction_time_utc_seconds string
Interaction Time
event.landing_page_url_id int
Unique ID of the landing page URL.
event.operating_system_id int
ID of the operating system.
event.ord_value string
The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)
event.other_data string
Stores key-value data from the activity string which is not otherwise labeled. (Any key-value that is NOT "src=", "type=", "cat=", "ord=", "u=", "cost=", "qty=", "tran=", "a=", or "b="). (Can be used for further product breakdown aka "Custom Floodlight Variables")
event.placement_id int
Unique ID for the site page / placement where the ad ran.
event.rendering_id int
Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
event.rich_media_event_counters int
MET Counter Value (the ecn= value).
event.rich_media_event_id int
MET Event ID for the Rich Media ad.
event.rich_media_event_timers double
Time in microseconds since 1970-01-01 00:00:00 UTC.rs
event.rich_media_event_type_id int
ID of Rich Media Event Type.
event.segment_value_1 int
Segment Value 1
event.site_id int
Unique ID for the site where the ad ran.
event.state string
ID for user's state or province (US/Canada)
event.tran_value string
TRAN Value
event.u_value string
U Value
event.zip_code string
Postal-Code (US/Canada).
network_id int
The network ID.
user_id opaque
The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons. User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

DV360 Data Transfer insertion order

dv360_dt_insertion_order
dv360_advertiser_id int
Unique ID of the advertiser.
dv360_campaign_id int
The unique ID of the Display & Video 360 campaign.
dv360_insertion_order string
Name of the insertion order.
dv360_insertion_order_id int
Unique ID of the insertion order.
dv360_partner_id int
Unique ID of the partner.

DV360 Data Transfer line item

dv360_dt_line_item
dv360_advertiser_id int
Unique ID of the advertiser.
dv360_campaign_id int
The unique ID of the Display & Video 360 campaign.
dv360_insertion_order_id int
Unique ID of the insertion order.
dv360_line_item string
Name of the line item.
dv360_line_item_id int
Unique ID of the line item.
dv360_partner_id int
Unique ID of the partner.

DV360 paths

dv360_paths
dv360_paths.floodlight_config_id int
Unique ID of the floodlight configuration. ID
network_id int
The network ID.
partner_id int
Unique ID of the partner.
path record
Row containing event path for a given user.
path.events repeated struct
path.events.active_view_eligible_impressions int
Active View eligible impressions
path.events.active_view_measurable_impressions int
Active View measurable impressions
path.events.active_view_viewable_impressions int
Active View viewable impressions
path.events.activity_count int
Activity count
path.events.activity_id int
The ID of the Floodlight tag related to the conversion event.
path.events.activity_revenue double
Activity revenue
path.events.ad_id int
Unique ID of the ad placement.
path.events.advertiser_id int
Unique ID of the advertiser
path.events.audience_segment_id int
Unique ID of the audience segment.
path.events.browser_platform_id string
Browser platform ID
path.events.browser_version string
Browser version
path.events.campaign_id int
The unique ID of the Campaign Manager 360 campaign
path.events.city_id int
City ID
path.events.conversion_id int
Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0).
path.events.country_code string
2-letter ISO 3166-1 country code.
path.events.creative_version string
Creative version number.
path.events.dma_region_id int
DMA region ID
path.events.dv360_ad_position int
Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold.
path.events.dv360_advertiser_id int
The Display & Video 360 numerical ID for the advertiser related to the event, for example 164332.
path.events.dv360_adx_page_categories string
Contains the Ad Exchange page category IDs separated by a space, for example "65 189". The categories may not be mutually exclusive.
path.events.dv360_attributed_inventory_source_external_id string
The external ID of the attributed inventory source that Display & Video 360 selected as the best match from those accessible to the advertiser related to the view event based on floor price and auction type.
path.events.dv360_attributed_inventory_source_is_public string
True if inventory source is available to all buyers. False otherwise.
path.events.dv360_auction_id string
A string used to join events among view/click/conversion types, for example"ABCDEFGH_abcdefgh-0123456789". Do not assume any ordering, structure or meaning to the auction_id value.
path.events.dv360_bid_price_advertiser_currency int
The bid price sent to the exchange in advertiser currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
path.events.dv360_bid_price_partner_currency int
The bid price sent to the exchange in partner currency nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
path.events.dv360_bid_price_usd int
The bid price sent to the exchange in USD nanos. You can divide by 1,000,000,000 to see bid price in USD. Bid price is the value that the line item assigns to the impression, prior to first-price auction adjustments. For a fixed-CPM line item, this is the line item's fixed CPM at the time of the bid. Although the bid is sent to exchanges as a CPM value, bid price is represented as a cost per impression value for consistency with other metrics.
path.events.dv360_billable_cost_advertiser_currency int
The total amount of money billed to the partner, including the media cost and partner costs, in advertiser currency nanos.
path.events.dv360_billable_cost_partner_currency int
The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos.
path.events.dv360_billable_cost_usd int
The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos.
path.events.dv360_browser_id int
DV360 browser ID
path.events.dv360_browser_timezone_offset_minutes int
The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10.
path.events.dv360_city_id int
The Display & Video 360 numerical ID identifying the best-guess city of the impression.
path.events.dv360_country_code string
2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US".
path.events.dv360_cpm_fee_1_advertiser_currency int
The CPM 1 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_cpm_fee_1_partner_currency int
The CPM 1 fee in partner currency nanos. This value may be zero.
path.events.dv360_cpm_fee_1_usd int
The CPM 1 fee in USD nanos. This value may be zero.
path.events.dv360_cpm_fee_2_advertiser_currency int
The CPM 2 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_cpm_fee_2_partner_currency int
The CPM 2 fee in partner currency nanos. This value may be zero.
path.events.dv360_cpm_fee_2_usd int
The CPM 2 fee in USD nanos. This value may be zero.
path.events.dv360_cpm_fee_3_advertiser_currency int
The CPM 3 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_cpm_fee_3_partner_currency int
The CPM 3 fee in partner currency nanos. This value may be zero.
path.events.dv360_cpm_fee_3_usd int
The CPM 3 fee in USD nanos. This value may be zero.
path.events.dv360_cpm_fee_4_advertiser_currency int
The CPM 4 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_cpm_fee_4_partner_currency int
The CPM 4 fee in partner currency nanos. This value may be zero.
path.events.dv360_cpm_fee_4_usd int
The CPM 4 fee in USD nanos. This value may be zero.
path.events.dv360_cpm_fee_5_advertiser_currency int
The CPM 5 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_cpm_fee_5_partner_currency int
The CPM 5 fee in partner currency nanos. This value may be zero.
path.events.dv360_cpm_fee_5_usd int
The CPM 5 fee in USD nanos. This value may be zero.
path.events.dv360_creative_id int
The Display & Video 360 numerical ID for the creative related to the event, for example 367487.
path.events.dv360_data_fees_advertiser_currency int
The cost of any data that was used to target this impression, in advertiser currency nanos.
path.events.dv360_data_fees_partner_currency int
The cost of any data that was used to target this impression, in partner currency nanos.
path.events.dv360_data_fees_usd int
The cost of any data that was used to target this impression, in USD nanos
path.events.dv360_device_type int
The numerical value of the identified device type. 0 = Computer, 1 = Other, 2 = Smart Phone, 3 = Tablet, 4 = Smart TV, 5 = Connected TV, 6 = Set Top Box, 7 = Connected Device.
path.events.dv360_exchange_id string
The Display & Video 360 numerical ID for the exchange that requested the ad.
path.events.dv360_insertion_order_id int
The Display & Video 360 numerical ID for the insertion order related to the event, for example 1079941.
path.events.dv360_isp_id int
The Display & Video 360 numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing.
path.events.dv360_language string
The ISO-639-1 code or "zh_CN" (Chinese (simplified)), "zh_TW" (Chinese (traditional)) or "other" representing the language related to the view event.
path.events.dv360_line_item_id int
The Display & Video 360 numerical ID for the line item related to the event, for example 1155785.
path.events.dv360_matching_targeted_keywords string
A comma separated string containing a list of targeted keywords matching the page related to the view event, for example "apple,orange,banana". Although the page related to the view event may match many keywords, only those which were targeted will be included; if the list of keywords is large we may impose a limit to the number of keywords returned.
path.events.dv360_matching_targeted_segments string
Space-separated IDs of targeted user lists that match the visitor, for example "-4 456". If the visitor is in a user list that is not targeted by the ad associated with this event it will not be included here.
path.events.dv360_media_cost_advertiser_currency int
The amount paid for the impression in advertiser currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
path.events.dv360_media_cost_partner_currency int
The amount paid for the impression in the partner currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
path.events.dv360_media_cost_usd int
The amount paid for the impression in USD nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero.
path.events.dv360_media_fee_1_advertiser_currency int
The Media Fee 1 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_media_fee_1_partner_currency int
The Media Fee 1 fee in partner currency nanos. This value may be zero.
path.events.dv360_media_fee_1_usd int
The Media Fee 1 fee in USD nanos. This value may be zero.
path.events.dv360_media_fee_2_advertiser_currency int
The Media Fee 2 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_media_fee_2_partner_currency int
The Media Fee 2 fee in partner currency nanos. This value may be zero.
path.events.dv360_media_fee_2_usd int
The Media Fee 2 fee in USD nanos. This value may be zero.
path.events.dv360_media_fee_3_advertiser_currency int
The Media Fee 3 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_media_fee_3_partner_currency int
The Media Fee 3 fee in partner currency nanos. This value may be zero.
path.events.dv360_media_fee_3_usd int
The Media Fee 3 fee in USD nanos. This value may be zero.
path.events.dv360_media_fee_4_advertiser_currency int
The Media Fee 4 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_media_fee_4_partner_currency int
The Media Fee 4 fee in partner currency nanos. This value may be zero.
path.events.dv360_media_fee_4_usd int
The Media Fee 4 fee in USD nanos. This value may be zero.
path.events.dv360_media_fee_5_advertiser_currency int
The Media Fee 5 fee in advertiser currency nanos. This value may be zero.
path.events.dv360_media_fee_5_partner_currency int
The Media Fee 5 fee in partner currency nanos. This value may be zero.
path.events.dv360_media_fee_5_usd int
The Media Fee 5 fee in USD nanos. This value may be zero.
path.events.dv360_mobile_model_id int
The numerical ID for the mobile model. This value may be missing.
path.events.dv360_net_speed int
The Display & Video 360 numerical ID representing the network speed related to the view event. 1=Dial-up, 2=EDGE/2G, 3=UMTS/3G, 4=Basic DSL, 5=HSDPA/3.5G, 6=Broadband/4G, 7=Unknown.
path.events.dv360_request_time int
A Unix timestamp in microseconds (1/1,000,000 second) for when we received the ad request, for example1330403779608570 represents Tuesday February 28th 2012 04:36:19.608570. Although this value is consistent across the view, click and conversion even it is not guaranteed to be unique - use auction_id to join events
path.events.dv360_revenue_advertiser_currency int
DV360 revenue advertiser currency
path.events.dv360_revenue_partner_currency int
DV360 revenue partner currency
path.events.dv360_revenue_usd int
DV360 revenue usd
path.events.dv360_site_id int
The Display & Video 360 numerical ID for the most specific universal site that matches the url.
path.events.dv360_state_region_id int
An integer matching the state/region integer available in reporting and targeting.
path.events.dv360_url string
The raw URL taken from the bid request received from the exchange, for example "http://www.example.com". As some exchanges mask the URL in their bid requests this value may be: "source_url_hidden"
path.events.dv360_view_state string
Populated for wrapped tags. (Two impression records when both events occur.) Possible values are: "OUTER", DV360 returned wrapped tag; "INNER", ad served post wrapped tag; "3PAS_MERGED", wrapped tag tracked by CM; "3PAS_OUTER", tracking ping sent to CM but no response, 3rd party blocked ad serving.
path.events.dv360_zip_postal_code string
The postal code identifying the best-guess postal area of the impression if known, for example "98033". Do not assume uniqueness across different countries.
path.events.event_sub_type string
Event sub type
events.event_time int
Time in microseconds since 1970-01-01 00:00:00 UTC.
path.events.event_type string
Contains details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "CONVERSION" or "MODELED_CONVERSION" for conversion events.
path.events.floodlight_config_id int
Unique ID of the floodlight configuration. ID
path.events.impression_id string
Impression ID
path.events.interaction_time_utc_seconds string
The activity's associated (aka 'matched') click or impression time in microseconds since 1970-01-01 00:00:00 UTC.
path.events.landing_page_url_id int
Landing page url ID
path.events.operating_system_id int
ID of the operating system.
path.events.ord_value string
The advertiser's ordinal ID, if relevant for a given activity type. Passed in the 'ord=' key-value (also used for storing the client's Order-ID in sales tags)
path.events.other_data string
Stores key-value data from the activity string which is not otherwise labeled. (Any key-value that is NOT "src=", "type=", "cat=", "ord=", "u=", "cost=", "qty=", "tran=", "a=", or "b="). (Can be used for further product breakdown aka "Custom Floodlight Variables")
path.events.placement_id int
Unique ID for the site page / placement where the ad ran.
path.events.referrer_url string
Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.
path.events.rendering_id int
Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID.
path.events.rich_media_event_counters int
Rich media event counters
path.events.rich_media_event_id int
MET Event ID for the Rich Media ad.
path.events.rich_media_event_timers double
Rich media event timers
path.events.rich_media_event_type_id int
ID of Rich Media Event Type.
path.events.segment_value_1 int
Segment value 1
path.events.site_id int
Site ID
path.events.state string
State
path.events.tran_value string
Tran value
path.events.u_value string
U value
path.events.zip_code string
Postal-Code (US/Canada).
user_id opaque
The tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons. User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

DV360 YouTube Active View

dv360_youtube_active_views
impression_data.adgroup_id int
ID of the Display & Video 360 YouTube ad group. Used as a join key in any adh.dv360_youtube_* table.
impression_data.advertiser_id int
Unique ID of the advertiser.
impression_data.campaign_id int
Unique ID of the campaign.
impression_data.creative_id int
Unique ID of the creative.
impression_data.insertion_order_id int
The Display & Video 360 numerical ID for the insertion order related to the event, eg 1079941.
impression_data.line_item_id int
The Display & Video 360 numerical ID for the line item related to the event, eg 1155785.
impression_data.partner_id int
Unique ID of the partner.
impression_id string
Unique ID of the impression.
num_active_view_viewable_impression int
1 = impression is active view eligible, 0 = impression isn't active view eligible.
query_id struct
Unique identifier for query has multiple parts.
query_id.process_id int
Integer that identifies the process on the machine that generated the event.
query_id.server_ip int
The IPv4 address of the server that managed the ad request. Used to identify unique events for joins.
query_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
view_id struct
Unique ID for view has multiple parts.
view_id.process_id int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
view_id.server_ip int
The IPv4 address of the server that generated this event.
view_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.

DV360 YouTube ad group

dv360_youtube_adgroup
adgroup_id int
ID of DV360 ad group. Joins with adgroup_id in any adh.dv360_youtube table.
adgroup_name string
Ad group name.
adgroup_status string
The ad group. Possible values are: "status", "paused", or "enabled".
adgroup_type string
The ad group type. Possible values are: VIDEO_TRUE_VIEW_IN_STREAM, VIDEO_NON_SKIPPABLE_IN_STREAM, VIDEO_BUMPER, VIDEO_TRUE_VIEW_IN_DISPLAY.
advertiser_id int
Unique ID of the advertiser.
campaign_id int
Unique ID of the campaign.
insertion_order_id int
Unique ID of the insertion order.
line_item_id int
Unique ID of the line item.
partner_id int
Unique ID of the partner.

DV360 YouTube advertiser

dv360_youtube_advertiser
advertiser_id int
Unique ID of the advertiser.
advertiser_name string
Name of the advertiser.
advertiser_timezone string
The DV360 advertiser time zone default set in account settings.
partner_id int
Unique ID of the partner.

DV360 YouTube campaign

dv360_youtube_campaign
advertiser_id int
Unique ID of the advertiser.
campaign_id int
Unique ID of the campaign.
campaign_name string
Name of the campaign
partner_id int
Unique ID of the partner.

DV360 YouTube clicks

dv360_youtube_clicks
advertiser_click_cost_local_micros double
The advertiser's cost in local currency micros.
advertiser_click_cost_usd double
The advertiser's click cost in dollars.
click_id struct
Unique identifier for click has multiple parts. Joins with click_id in any adh.dv360_youtube table.
click_id.process_id int
Integer that identifies the process on the machine that generated the event.
click_id.server_ip int
The IPv4 address of the server that generated this event.
click_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
click_type int
The click type.
impression_data.adgroup_id int
ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
impression_data.advertiser_id int
Unique ID of the advertiser.
impression_data.campaign_id int
Unique ID of the campaign.
impression_data.creative_id int
Joins with creative_id in any adh.dv360_youtube table.
impression_data.insertion_order_id int
Unique ID of the insertion order.
impression_data.line_item_id int
Unique ID of the line item.
impression_data.partner_id int
Unique ID of the partner.
impression_id string
Unique identifier for impression.
is_trueview bool
True if the event was a TrueView view. False if the event was not a TrueView view.
query_id struct
Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table.
query_id.process_id int
Integer that identifies the process on the machine that generated the event.
query_id.server_ip int
The IPv4 address of the server that generated this event.
query_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
user_id opaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

DV360 YouTube conversions

dv360_youtube_conversions
click_id struct
Unique identifier for click has multiple parts. Joins with click_id in any adh.dv360_youtube table.
click_id.process_id int
Integer that identifies the process on the machine that generated the event.
click_id.server_ip int
The IPv4 address of the server that generated this event.
click_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
conversion_id struct
Unique identifier for conversion has multiple parts.
conversion_id.process_id int
Integer that identifies the process on the machine that generated the event.
conversion_id.server_ip int
The IPv4 address of the server that generated this event.
conversion_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
conversion_type int
The type of conversion.
impression_data.adgroup_id int
ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
impression_data.advertiser_id int
Unique ID of the advertiser.
impression_data.campaign_id int
Unique ID of the campaign.
impression_data.creative_id int
Joins with creative_id in any adh.dv360_youtube table.
impression_data.insertion_order_id int
Unique ID of the insertion order.
impression_data.line_item_id int
Unique ID of the line item.
impression_data.partner_id int
Unique ID of the partner.
impression_id string
Unique identifier for impression.
label string
Name of conversion event.
query_id struct
Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table.
query_id.process_id int
Integer that identifies the process on the machine that generated the event.
query_id.server_ip int
The IPv4 address of the server that generated this event.
query_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
user_id opaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

DV360 YouTube creative

dv360_youtube_creative
adgroup_id int
ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
advertiser_id int
Multiple Display & Video 360 "advertisers" generally exist underneath a single partner. Vendor client IDs are saved here.
campaign_id int
Group of insertion Orders. Default targeting settings & cross-campaign frequency caps.
creative_id int
Vendor client IDs are saved here.
creative_name string
The name of the Display & Video 360 creative.
creative_type int
Enum corresponding to the creative type.
insertion_order_id int
Group of line item IDs. Frequency caps, pacing settings, partner costs, and default targeting criteria for line items.
is_masthead boolean
True if this is a masthead creative.
line_item_id int
Line items consist of a budget, a bid, and targeting. For YouTube buys, line items are identical to Campaigns in Google Ads. ADH linking happens here. Reporting IDs are saved here.
partner_id int
Represents agencies, trading desks, or large individual advertisers.
third_party_vast_url string
URL used for VAST (Video Ad Serving Template) redirect creatives. Formatting doesn't match yt_reserve_creative.third_party_vast_url.
video_message struct
Multipart identifier for video data.
video_message.video_ad_duration int
Duration of the video in milliseconds.
video_message.youtube_video_id string
Video ID string representation as it appears on YouTube watch url.

DV360 YouTube creative conversions

dv360_youtube_creative_conversions
advertiser_cost_local_micros double
The advertiser's cost in local currency micros.
advertiser_cost_usd double
The advertiser's click cost in dollars.
click_id struct
Unique identifier for click has multiple parts. Joins with click_id in any adh.dv360_youtube table.
click_id.process_id int
Integer that identifies the process on the machine that generated the event.
click_id.server_ip int
The IPv4 address of the server that generated this event.
click_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
conversion_id struct
Unique identifier for conversion has multiple parts.
conversion_id.process_id int
Integer that identifies the process on the machine that generated the event.
conversion_id.server_ip int
The IPv4 address of the server that generated this event.
conversion_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
conversion_type int
The type of conversion.
impression_data.adgroup_id int
ID of the DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
impression_data.advertiser_id int
Unique ID of the advertiser.
impression_data.campaign_id int
Unique ID of the campaign.
impression_data.creative_id int
Joins with creative_id in any adh.dv360_youtube table.
impression_data.insertion_order_id int
Unique ID of the insertion order.
impression_data.line_item_id int
Unique ID of the line item.
impression_data.partner_id int
Unique ID of the partner.
impression_id string
Unique identifier for impression.
label string
Name of conversion event.
num_clicks int
Number of clicks.
num_video_views int
Number of video views.
query_id struct
Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table.
query_id.process_id int
Integer that identifies the process on the machine that generated the event.
query_id.server_ip int
The IPv4 address of the server that generated this event.
query_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
user_id opaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

DV360 YouTube impressions

dv360_youtube_impressions
active_view_data int
Whether the impression was enabled for active view measurement.
adgroup_id int
ID of DV360 YouTube ad group. Joins with adgroup_id in any adh.dv360_youtube table.
advertiser_id int
Unique ID of the advertiser.
advertiser_impression_cost_local_micros double
The advertiser's local currency in micros.
advertiser_impression_cost_usd double
The advertiser's impression cost in dollars.
affinity array
ID of affinity group. Joins with affinity_id in adh.affinity table. Does not support YouTube line items.
app_id string
Numerical identifier for the app's ID. Combined with the app_store_id, users can look up more information about the app. For example, 284815942 is the ID of Google's search app on Apple's App store. It only populates for Google Display Network (GDN) and Google Video Partner (GVP), which can be identified as INVENTORY_TYPE = OTHER. You can look up the app name by joining with the mobile_app_info table.
app_store_id int64
Numerical identifier corresponding to the app store which the app belongs to. eg 1 = "Apple App Store", 2 = "Google Play", or 8 = "PlayStation Store". It only populates for Google Display Network (GDN) and Google Video Partner (GVP), which can be identified as INVENTORY_TYPE = OTHER. You can look up the app store name by joining with the mobile_app_info table.
browser string
Possible values are: "Chrome", "Cobalt", "Dalvik", "Edge", "Firefox", "IE", "Opera", "Other", "Safari", "Samsung Browser", "Roku", "Silk", "Unknown", "Yandex"
campaign_id int
Unique ID of the campaign.
content_url string
URL of the page on which ad appeared. Part of the url is removed for privacy.
creative_id int
Joins with creative_id in any adh.dv360_youtube table.
demographics struct
demographics.age_group int
Code for age group. Joins with age_group_id in adh.age_group table.
demographics.gender int
Code for gender. Joins with gender_id in adh.gender table.
device_height int
Device height in px.
device_width int
Device width in px.
format_category string
YouTube ad format. Possible values are AUDIO, DISPLAY, VIDEO, UNSPECIFIED.
impression_id string
Unique identifier for impression.
in_market array
ID of in-market group. Joins with in_market_id in adh.in_market table. Does not support YouTube line items.
insertion_order_id int
Unique ID of the insertion order.
inventory_type enum
The inventory type. Possible values: YOUTUBE, YOUTUBE TV, YOUTUBE_MUSIC, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network.
is_app_traffic boolean
true if the event happened in a native app.
line_item_id int
Unique ID of the line item.
location struct
Unique identifier for location has multiple parts
location.country string
location.geo_city_id int
Code for city. Joins with city_id in adh.city table.
location.geo_metro int
Code for metro region. Joins with metro_id in adh.metro table.
location.geo_region string
Region as string eg US-CA.
mobile_browser_class int
Type of browser. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser table.
num_active_view_eligible_impression int
1 when impression is active view eligible; 0 when impression is not active view eligible.
num_active_view_measurable_impression int
1 when impression is active view measurable; 0 when impression is not active view measurable.
operating_system string
Possible values are: "Android", "AppleTV", "Chrome OS", "Fire OS", "Google TV", "iOS", "Linux", "Mac", "Unknown", "PlayStation", "Roku", "Tizen", "Xbox", "Windows", "Windows Phone"
partner_id int
Unique ID of the partner.
physical_screen_height int
Device screen height in mm.
physical_screen_width int
Device screen width in mm.
publisher_domain string
Domain of the page on which ad appeared.
query_id struct
Unique identifier for query has multiple parts. Joins with query_id in any adh.dv360_youtube table.
query_id.process_id int
The processing ID.
query_id.server_ip int
The IPv4 address of the server that generated this event.
query_id.time_usec int
The query time in microseconds.
query_language string
Language used by user.
user_id opaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

DV360 YouTube insertion order

dv360_youtube_insertion_order
advertiser_id int
Unique ID of the advertiser.
campaign_id int
Unique ID of the campaign.
insertion_order_id int
Unique ID of the insertion order.
insertion_order_name string
Name of the insertion order.
partner_id int
Unique ID of the partner.

DV360 YouTube line item

dv360_youtube_lineitem
advertiser_id int
Unique ID of the advertiser.
campaign_id int
The Display & Video 360 numerical ID for the campaign related to the event, eg 164332.
insertion_order_id int
The Display & Video 360 numerical ID for the insertion order related to the event, eg 1079941.
line_item_end_time int
Unix timestamp in microseconds (1/1,000,000 second) for when the line item ended, eg 1330403779608570
line_item_id int
The Display & Video 360 numerical ID for the line item related to the event, eg 1155785.
line_item_name string
The Display & Video 360 name for the line item related to the event, eg 164332.
line_item_reservation_type enum
Reservation type for a Display & Video 360 line item. Can be one of "Programmatic", "InstantReserve", or "None" (meaning standard auction).
line_item_start_time int
Unix timestamp in microseconds (1/1,000,000 second) for when the line item started, eg 1330403779608570
line_item_status int
Integer indicating the status of the line item. 3 = ACTIVE. 5 = PAUSED. 7 = DELETED.
partner_id int
Unique ID of the partner.

Freewheel impressions

freewheel_impressions
browser string
Possible values are: "Chrome", "Cobalt", "Dalvik", "Edge", "Firefox", "IE", "Opera", "Other", "Safari", "Samsung Browser", "Roku", "Silk", "Unknown", "Yandex"
format_category string
YouTube ad format. Possible values are AUDIO, DISPLAY, VIDEO, UNSPECIFIED.
operating_system string
Possible values are: "Android", "AppleTV", "Chrome OS", "Fire OS", "Google TV", "iOS", "Linux", "Mac", "Unknown", "PlayStation", "Roku", "Tizen", "Xbox", "Windows", "Windows Phone"

Gender

gender
gender_id int
Gender identifier.
gender_name string
Gender name. Possible values are: "male", "female", or "unknown".
google_ads_active_views
impression_data.ad_group_creative_id int
ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
impression_data.adgroup_id int
ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
impression_data.campaign_id int
Unique ID of the campaign.
impression_data.customer_id int
ID of Google Ads customer. Joins with customer_id in any adh.google_ads table.
impression_id string
Unique identifier for impression.
num_active_view_viewable_impression int
1 when impression is active view eligible; 0 when impression is not active view eligible.
query_id struct
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_id int
The processing ID.
query_id.server_ip int
The IPv4 address of the server that generated this event.
query_id.time_usec int
The query time in microseconds.
view_id struct
Unique identifier for view_id has multiple parts.
view_id.process_id int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
view_id.server_ip int
The IPv4 address of the server that generated this event.
view_id.time_usec int
Integer that identifies the process on the machine that generated the event.
google_ads_adgroup
adgroup_id int
ID of Google Ads ad group. Used as a join key in adh.google_ads table.
adgroup_name string
Name of the ad group in Google Ads.
adgroup_status string
The ad group. Possible values are: "status", "paused", or "enabled".
adgroup_type string
The ad group type. Possible values are: "VIDEO_TRUE_VIEW_IN_STREAM", "VIDEO_OUTSTREAM", "VIDEO_TRUE_VIEW_IN_DISPLAY", "VIDEO_BUMPER_IN_STREAM", "VIDEO_NON_SKIPPABLE_IN_STREAM", "DISPLAY", "SEARCH", "YOUTUBE_AUDIO", or "OTHER".
campaign_id int
Unique ID of the campaign.
customer_id int
Google Ads account ID. Joins with customer_id in any adh.google_ads table.
label_ids array<int64>
Label IDs. Joins with label_id in the adh.google_ads_label table.
google_ads_adgroupcreative
ad_group_creative_id INT64
ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
adgroup_creative_status STRING
The status of the creative within the ad group.
adgroup_id INT64
ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
creative_id INT64
A unique identifier for the creative, specific to the ad group containing it. Joins with creative_id in any adh.google_ads table.
customer_id INT64
Google Ads account ID. Joins with customer_id in any adh.google_ads table.
label_ids array<int64>
Label IDs. Joins with label_id in the adh.google_ads_label table.
google_ads_campaign
advertising_channel_type string
The primary serving target for ads within the campaign. It can be set only when a campaign is newly created in Google Ads. Possible values are: "SEARCH", "DISPLAY", "VIDEO", or "OTHER".
campaign_id int
Unique ID of the campaign.
campaign_name string
Campaign name.
campaign_status int
Campaign status. 3 = ACTIVE. 5 = PAUSED. 7 = DELETED.
customer_id int
Joins with customer_id in any adh.google_ads table.
end_time int
Timestamp when the campaign ends in milliseconds.
label_ids array<int64>
Label IDs. Joins with label_id in the adh.google_ads_label table.
reservation_type enum
The type of the reservation. Can be either "InstantReserve" or "None" (meaning standard auction).
start_time int
Timestamp when the campaign begins in milliseconds.
google_ads_clicks
advertiser_click_cost_local_micros double
The advertiser's cost in local currency micros.
advertiser_click_cost_usd double
The advertiser's click cost in dollars.
click_id struct
Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
click_id.process_id int
Integer that identifies the process on the machine that generated the event.
click_id.server_ip int
The IPv4 address of the server that generated this event.
click_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
click_type int
The click type.
impression_data.ad_group_creative_id int
ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
impression_data.adgroup_id int
ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
impression_data.campaign_id int
Unique ID of the campaign.
impression_data.customer_id int
ID of Google Ads customer. Joins with customer_id in any adh.google_ads table.
impression_id string
Unique identifier for impression.
is_trueview bool
True if the event was a TrueView view. False if the event was not a TrueView view.
query_id struct
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_id int
Integer that identifies the process on the machine that generated the event.
query_id.server_ip int
The IPv4 address of the server that generated this event.
query_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
user_id opaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.
google_ads_clicks_audience
advertiser_click_cost_local_micros double
The advertiser's cost in local currency micros.
advertiser_click_cost_usd double
The advertiser's click cost in dollars.
click_id struct
Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
click_id.process_id int
Integer that identifies the process on the machine that generated the event.
click_id.server_ip int
The IPv4 address of the server that generated this event.
click_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
click_type int
The click type.
impression_id string
Unique identifier for impression.
is_trueview bool
True if the event was a TrueView view. False if the event was not a TrueView view.
query_id struct
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_id int
Integer that identifies the process on the machine that generated the event.
query_id.server_ip int
The IPv4 address of the server that generated this event.
query_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
user_id opaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.
google_ads_conversions
click_id struct
Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
click_id.process_id int
Integer that identifies the process on the machine that generated the event.
click_id.server_ip int
The IPv4 address of the server that generated this event.
click_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
conversion_id struct
Unique identifier for conversion has multiple parts.
conversion_id.process_id int
Integer that identifies the process on the machine that generated the event.
conversion_id.server_ip int
The IPv4 address of the server that generated this event.
conversion_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
conversion_type int
The type of conversion.
impression_data.ad_group_creative_id int
ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
impression_data.adgroup_id int
ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
impression_data.campaign_id int
Unique ID of the campaign.
impression_data.customer_id int
ID of Google Ads customer. Joins with customer_id in any adh.google_ads table.
impression_id string
Unique identifier for impression.
label string
Name of conversion event.
query_id struct
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_id int
Integer that identifies the process on the machine that generated the event.
query_id.server_ip int
The IPv4 address of the server that generated this event.
query_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
user_id opaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.
google_ads_conversions_audience
click_id struct
Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
click_id.process_id int
Integer that identifies the process on the machine that generated the event.
click_id.server_ip int
The IPv4 address of the server that generated this event.
click_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
conversion_id struct
Unique identifier for conversion has multiple parts.
conversion_id.process_id int
Integer that identifies the process on the machine that generated the event.
conversion_id.server_ip int
The IPv4 address of the server that generated this event.
conversion_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
conversion_type int
The type of conversion.
impression_id string
Unique identifier for impression.
label string
Name of conversion event.
query_id struct
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_id int
Integer that identifies the process on the machine that generated the event.
query_id.server_ip int
The IPv4 address of the server that generated this event.
query_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
user_id opaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.
google_ads_creative
creative_id int
Joins with creative_id in any adh.google_ads table.
creative_name string
Creative name.
creative_type int
Creative type.
customer_id int
Google Ads account ID. Joins with customer_id in any adh.google_ads table.
template_id int
Template ID of the creative.
video_message struct
Multipart identifier for video data.
video_message.video_ad_duration int
Duration of the video in milliseconds.
video_message.youtube_video_id string
Video id string representation as it appears on YouTube watch url.
google_ads_creative_conversions
advertiser_cost_local_micros double
The advertiser's cost in local currency micros.
advertiser_cost_usd double
The advertiser's click cost in dollars.
click_id struct
Unique identifier for click has multiple parts. Joins with click_id in any adh.google_ads table.
click_id.process_id int
Integer that identifies the process on the machine that generated the event.
click_id.server_ip int
The IPv4 address of the server that generated this event.
click_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
conversion_id struct
Unique identifier for conversion has multiple parts.
conversion_id.process_id int
Integer that identifies the process on the machine that generated the event.
conversion_id.server_ip int
The IPv4 address of the server that generated this event.
conversion_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
conversion_type int
The type of conversion.
impression_data.ad_group_creative_id int
ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
impression_data.adgroup_id int
ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
impression_data.campaign_id int
Unique ID of the campaign.
impression_data.customer_id int
ID of Google Ads customer. Joins with customer_id in any adh.google_ads table.
impression_id string
Unique identifier for impression.
label string
Name of conversion event.
num_clicks int
Number of clicks.
num_video_views int
Number of video views.
query_id struct
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_id int
Integer that identifies the process on the machine that generated the event.
query_id.server_ip int
The IPv4 address of the server that generated this event.
query_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
user_id opaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.
google_ads_creative_vendor_metadata
creative_id int
The Creative ID in Campaign Manager 360 UI.
legacy_pixel string
vendor_string string
google_ads_customer
customer_company_name string
Company name.
customer_id int
Google Ads account ID. Joins with customer_id in any adh.google_ads table.
customer_name string
Google Ads account name.
customer_timezone string
Google Ads account setting for time zone.
external_customer_id int
Google Ads account ID.
mcc_ids array
My Client Center: dashboard view in Google Ads that is provided to large advertisers and third-party agencies who manage and optimize multiple Google Ads accounts.
google_ads_impressions
active_view_data int
Whether the impression was enabled for active view measurement.
ad_group_creative_id int
ID for creative trafficked in given ad group. Joins with ad_group_creative_id in any adh.google_ads table.
adgroup_id int
ID of Google Ads ad group. Joins with adgroup_id in any adh.google_ads table.
advertiser_impression_cost_local_micros double
The advertiser's local currency in micros.
advertiser_impression_cost_usd double
The advertiser's impression cost in dollars.
affinity array
ID of affinity group. Joins with affinity_id in adh.affinity table. Does not support YouTube line items.
app_id string
Numerical identifier for the app's ID. Combined with the app_store_id, users can look up more information about the app. For example, 284815942 is the ID of Google's search app on Apple's App store. It only populates for Google Display Network (GDN) and Google Video Partner (GVP), which can be identified as INVENTORY_TYPE = OTHER. You can look up the app name by joining with the mobile_app_info table.
app_store_id int64
Numerical identifier corresponding to the app store which the app belongs to. eg 1 = "Apple App Store", 2 = "Google Play", or 8 = "PlayStation Store". It only populates for Google Display Network (GDN) and Google Video Partner (GVP), which can be identified as INVENTORY_TYPE = OTHER. You can look up the app store name by joining with the mobile_app_info table.
browser string
Possible values are: "Chrome", "Cobalt", "Dalvik", "Edge", "Firefox", "IE", "Opera", "Other", "Safari", "Samsung Browser", "Roku", "Silk", "Unknown", "Yandex"
campaign_id int
Unique ID of the campaign.
content_url string
URL of the page on which ad appeared. Part of the url is removed for privacy.
customer_id int
ID of Google Ads customer.Joins with customer_id in any adh.google_ads table.
demographics struct
demographics.age_group int
Code for age group. Joins with age_group_id in adh.age_group table.
demographics.gender int
Code for gender. Joins with gender_id in adh.gender table.
device_height int
Device height in px.
device_width int
Device width in px.
format_category string
YouTube ad format. Possible values are AUDIO, DISPLAY, VIDEO, UNSPECIFIED.
impression_id string
Unique identifier for impression.
in_market array
ID of in-market group. Joins with in_market_id in adh.in_market table. Does not support YouTube line items.
inventory_type enum
The inventory type. Possible values: YOUTUBE, YOUTUBE TV, YOUTUBE_MUSIC, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network.
is_app_traffic boolean
true if the event happened in a native app. FALSE if the event happened in HTML5 app or webview.
location struct
Unique identifier for location has multiple parts
location.country string
location.geo_city_id int
Code for city. Joins with city_id in adh.city table.
location.geo_metro int
Code for metro region. Joins with metro_id in adh.metro table.
location.geo_region string
Region as string eg US-CA.
mobile_browser_class int
Type of device. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_class table.
num_active_view_eligible_impression int
1 when impression is active view eligible; 0 when impression is not active view eligible.
num_active_view_measurable_impression int
1 when impression is active view measurable; 0 when impression is not active view measurable.
operating_system string
Possible values are: "Android", "AppleTV", "Chrome OS", "Fire OS", "Google TV", "iOS", "Linux", "Mac", "Unknown", "PlayStation", "Roku", "Tizen", "Xbox", "Windows", "Windows Phone"
operating_system_version_ids array
(Deprecated) Use operating_system instead. ID of OS. Joins with operating_system_version_id in adh.os_version table.
physical_screen_height int
Device screen height in mm.
physical_screen_width int
Device screen width in mm.
publisher_domain string
Domain of the page on which ad appeared.
query_id struct
Unique identifier for query has multiple parts. Joins with query_id in any adh.google_ads table.
query_id.process_id int
The processing ID.
query_id.server_ip int
The IPv4 address of the server that generated this event.
query_id.time_usec int
The query time in microseconds.
query_language string
Language used by user.
user_id opaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.
google_ads_label
customer_id int
Joins with customer_id in any adh.google_ads table.
description string
Label description.
label_id int64
Label ID. Joins with label_ids in adh.google_ads tables that contain label_ids.
label_name string
Label name.
status int
Label status. 1 = ENABLED. 2 = DELETED.

In-market segment

in_market
in_market_category string
The category of market vertical.
in_market_id int
In-market identifier.
in_market_name string
A more specific in-market name based on category.

Metro

metro
country_code string
Two character country code.
metro_id int
Metro identifier.
metro_name string
Metro name.

Mobile app info

mobile_app_info
app_id string
Numerical identifier for the app's ID. Combined with the app_store_id, users can look up more information about the app. For example, 284815942 is the ID of Google's search app on Apple's App store. It only populates for Google Display Network (GDN) and Google Video Partner (GVP), which can be identified as INVENTORY_TYPE = OTHER. You can look up the app name by joining with the mobile_app_info table.
app_name string
The name of the app as it appears in the app store.
app_store_id int64
Numerical identifier corresponding to the app store which the app belongs to. eg 1 = "Apple App Store", 2 = "Google Play", or 8 = "PlayStation Store". It only populates for Google Display Network (GDN) and Google Video Partner (GVP), which can be identified as INVENTORY_TYPE = OTHER. You can look up the app store name by joining with the mobile_app_info table.
app_store_name string
The name of the app store.

Mobile browser class

mobile_browser_class
mobile_browser_class_id int
Mobile browser class identifier.
mobile_browser_class_name string
Name of the mobile browser class.

Partner Sold - Cross Sell Active Views

partner_sold_cross_sell_active_views
impression_id string
Unique identifier for impression.

Partner Sold - Cross Sell clicks

partner_sold_cross_sell_clicks
impression_id string
Unique identifier for impression.

Partner Sold - Cross Sell conversions

partner_sold_cross_sell_conversions
impression_id string
Unique identifier for impression.

Partner Sold - Cross Sell impressions

partner_sold_cross_sell_impressions
browser string
Possible values are: "Chrome", "Cobalt", "Dalvik", "Edge", "Firefox", "IE", "Opera", "Other", "Safari", "Samsung Browser", "Roku", "Silk", "Unknown", "Yandex"
format_category string
YouTube ad format. Possible values are AUDIO, DISPLAY, VIDEO, UNSPECIFIED.
impression_id string
Unique identifier for impression.
operating_system string
Possible values are: "Android", "AppleTV", "Chrome OS", "Fire OS", "Google TV", "iOS", "Linux", "Mac", "Unknown", "PlayStation", "Roku", "Tizen", "Xbox", "Windows", "Windows Phone"

Region

region
country_code string
Two character country code.
region_id int
Region identifier.
region_name string
Region name.

YouTube Reserve Active Views

yt_reserve_active_views
impression_data.creative_id int
The ID of the creative.
impression_data.line_item_id int
Line item id for this impression.
impression_data.media_plan_id int
ID of the YouTube Reserve media plan.
impression_data.order_id int
impression_id string
Unique identifier for impression.
num_active_view_viewable_impression int
1 when impression is active view viewable; 0 when impression is not active view viewable.
query_id struct
Unique identifier for query has multiple parts.
query_id.process_id int
Integer that identifies the process on the machine that generated the event.
query_id.server_ip int
The IPv4 address of the server that generated this event.
query_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
view_id struct
Unique identifier for view has multiple parts.
view_id.process_id int
Integer that identifies the process on the machine that generated the event.
view_id.server_ip int
The IPv4 address of the server that generated this event.
view_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.

YouTube Reserve clicks

yt_reserve_clicks
click_id struct
Unique identifier for click has multiple parts.
click_id.process_id int
Integer that identifies the process on the machine that generated the event.
click_id.server_ip int
The IPv4 address of the server that generated this event.
click_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
click_type int
The click type.
impression_data.creative_id int
The ID of the creative.
impression_data.line_item_id int
Line item id for this impression.
impression_data.media_plan_id int
ID of the YouTube Reserve media plan.
impression_data.order_id int
impression_id string
Unique identifier for impression.
query_id struct
Unique identifier for query has multiple parts.
query_id.process_id int
Integer that identifies the process on the machine that generated the event.
query_id.server_ip int
The IPv4 address of the server that generated this event.
query_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
user_id opaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

YouTube Reserve conversions

yt_reserve_conversions
click_id struct
Unique identifier for click has multiple parts.
click_id.process_id int
Integer that identifies the process on the machine that generated the event.
click_id.server_ip int
The IPv4 address of the server that generated this event.
click_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
conversion_id struct
Unique identifier for conversion has multiple parts.
conversion_id.process_id int
Integer that identifies the process on the machine that generated the event.
conversion_id.server_ip int
The IPv4 address of the server that generated this event.
conversion_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
conversion_type int
The type of conversion.
impression_data.creative_id int
The ID of the creative.
impression_data.line_item_id int
Line item id for this impression.
impression_data.media_plan_id int
ID of the YouTube Reserve media plan.
impression_data.order_id int
impression_id string
Unique identifier for impression.
label string
Name of conversion event.
query_id struct
Unique identifier for query has multiple parts.
query_id.process_id int
Integer that identifies the process on the machine that generated the event.
query_id.server_ip int
The IPv4 address of the server that generated this event.
query_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
user_id opaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

YouTube Reserve creative

yt_reserve_creative
creative_format_type string
Some formats map directly to a type. Other types have multiple formats like: html, image, or video.
creative_id int
The ID of the creative.
creative_name string
Name of the creative.
creative_type string
The type of creative.
dcm_beacons array
Multipart identifier for Campaign Manager 360 tracking pixel for ad.
is_masthead boolean
True if this is a masthead creative.
skippable_ad_type string
Possible values are: "SKIPPABLE", "NOT_SKIPPABLE", "UNKNOWN", or "OTHER".
third_party_vast_url string
VAST url of the creative if the creative is a third party hosted video. Doesn't support creatives from programmatic items. Formatting doesn't match dv360_youtube_creative.third_party_vast_url
video_message struct
Multipart identifier for video data.
video_message.video_ad_duration int
Duration of the video in milliseconds.
video_message.youtube_channel_id string
Id of the channel that provides this video.
video_message.youtube_video_id string
Video id string representation as it appears on YouTube watch url.

YouTube Reserve creative conversions

yt_reserve_creative_conversions
click_id struct
Unique identifier for click has multiple parts.
click_id.process_id int
Integer that identifies the process on the machine that generated the event.
click_id.server_ip int
The IPv4 address of the server that generated this event.
click_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
conversion_id struct
Unique identifier for conversion has multiple parts.
conversion_id.process_id int
Integer that identifies the process on the machine that generated the event.
conversion_id.server_ip int
The IPv4 address of the server that generated this event.
conversion_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
conversion_type int
The type of conversion.
impression_data.creative_id int
ID of the creative.
impression_data.line_item_id int
Line item ID for this impression.
impression_data.media_plan_id int
ID of the YouTube Reserve media plan.
impression_data.order_id int
ID of Display & Video 360 customer. Joins with customer_id in any adh.dv360 table.
label string
Name of conversion event.
query_id struct
Unique identifier for query has multiple parts.
query_id.process_id int
Integer that identifies the process on the machine that generated the event.
query_id.server_ip int
The IPv4 address of the server that generated this event.
query_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
user_id opaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

YouTube Reserve impressions

yt_reserve_impressions
active_view_data int
Whether the impression was enabled for active view measurement.
affinity array
ID of affinity group. Joins with affinity_id in adh.affinity table. Does not support YouTube line items.
browser string
Possible values are: "Chrome", "Cobalt", "Dalvik", "Edge", "Firefox", "IE", "Opera", "Other", "Safari", "Samsung Browser", "Roku", "Silk", "Unknown", "Yandex"
content_url string
URL of the page on which ad appeared. Part of the url is removed for privacy.
creative_id int
The ID of the creative.
demographics struct
Unique identifier for demographics, which has multiple parts: age_group, gender.
demographics.age_group int
Code for age group. Joins with age_group_id in adh.age_group table.
demographics.gender int
Code for gender. Joins with gender_id in adh.gender table.
device_height int
Device height in px.
device_width int
Device width in px.
format_category string
YouTube ad format. Possible values are AUDIO, DISPLAY, VIDEO, UNSPECIFIED.
impression_id string
Unique identifier for impression.
in_market array
ID of in-market group. Joins with in_market_id in adh.in_market table. Does not support YouTube line items.
inventory_type enum
The inventory type. Possible values: YOUTUBE, YOUTUBE TV, YOUTUBE_MUSIC, SEARCH, GMAIL, OTHER. Other refers to either the Google Display or Video network.
is_app_traffic boolean
true if the event happened in a native app. FALSE if the event happened in HTML5 app or webview.
line_item_id int
Line item id for this impression.
location struct
Unique identifier for location, which has multiple parts: geo_city_id, geo_metro, geo_region.
location.country string
Two-letter code for country, for example "US".
location.geo_city_id int
Code for city. Joins with city_id in adh.city table.
location.geo_metro int
Code for metro region. Joins with metro_id in adh.metro table.
location.geo_region string
Region as string, eg US-CA.
media_plan_id int
ID of the YouTube Reserve media plan.
mobile_browser_class int
Type of device. Possible values are: desktop, tablet, smart tv consoles, or mobile. Joins with mobile_browser_class_id in adh.mobile_browser_class table.
num_active_view_eligible_impression int
1 when impression is active view eligible; 0 when impression is not active view eligible.
num_active_view_measurable_impression int
1 when impression is active view measurable; 0 when impression is not active view measurable.
operating_system string
Possible values are: "Android", "AppleTV", "Chrome OS", "Fire OS", "Google TV", "iOS", "Linux", "Mac", "Unknown", "PlayStation", "Roku", "Tizen", "Xbox", "Windows", "Windows Phone"
order_id int
ID of the Google Ad Manager order.
physical_screen_height int
Device screen height in mm.
physical_screen_width int
Device screen width in mm.
publisher_domain string
Domain of page on which ad appeared.
query_id struct
Unique identifier for query, which has multiple parts: process_id, server_ip, time_usec.
query_id.process_id int
ID of the process on the machine that generated the event.
query_id.server_ip int
IP address of the server that generated the event.
query_id.time_usec int
The number of microseconds since the epoch as an int64: 1e6 * (unix time) + microseconds.
query_language string
Language used by user.
user_id opaque
User IDs support counting and joining (across tables in ADH). They can't be exported or cast as conventional datatypes.

YouTube Reserve line item

yt_reserve_lineitem
cost_per_unit int
Cost per unit served in micros
cost_type string
Cost per click, conversion, impression, and Active View.
creative_id array
Array of creative ids for this line item. Joins with creative_id in any adh.yt table.
end_time timestamp
Time the line item stopped being served.
line_item_id int
Ad Manager line item serving.
line_item_name string
Ad Manager line item name.
order_id int
Ad Manager Order identifier used for serving.
order_name string
Name of the insertion order.
programmatic boolean
true if the line item was programmatic.
start_time timestamp
Time the line item started to be served.
value_cost_per_unit int
The value cost per unit of the line item.

YouTube Reserve order

yt_reserve_order
advertiser_id int
Unique ID of the advertiser.
advertiser_name string
User entered name of the advertiser.
advertiser_timezone string
The YouTube Reserve advertiser time zone default set in account settings.
media_plan_id int
ID of the YouTube Reserve media plan.
media_plan_name string
Name of the YouTube Reserve media plan.
order_id int
Ad Manager Order identifier used for serving.
order_name string
Name of Ad Manager order