Эта страница переведена с помощью Cloud Translation API.

Ads Data Hub table schema - Agencies

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

близость
`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_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_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_isp_id`	`int` Числовой идентификатор в Дисплее и Видео 360 наиболее вероятного поставщика услуг Интернета для показа. Это значение может отсутствовать.
`event.dv360_language`	`string` Код ISO-639-1 или «zh_CN» (китайский (упрощенный)), «zh_TW» (китайский (традиционный)) или «другой», представляющий язык, связанный с событием просмотра.
`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_revenue_advertiser_currency`	`int` Общая сумма в нано в валюте рекламодателя, внесенная партнерским аккаунтом за событие просмотра. Это значение может быть равно нулю.
`event.dv360_revenue_partner_currency`	`int` Общая сумма в валюте партнера в нано, внесенная партнерским аккаунтом за событие просмотра. Это значение может быть равно нулю.
`event.dv360_revenue_usd`	`int` Общая сумма в нанодолларах США, внесенная партнерским счетом за событие просмотра. Это значение может быть равно нулю.
`event.dv360_state_region_id`	`int` Идентификатор региона DV360
`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.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_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_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_isp_id`	`int` Числовой идентификатор в Дисплее и Видео 360 наиболее вероятного поставщика услуг Интернета для показа. Это значение может отсутствовать.
`event.dv360_language`	`string` Код ISO-639-1 или «zh_CN» (китайский (упрощенный)), «zh_TW» (китайский (традиционный)) или «другой», представляющий язык, связанный с событием просмотра.
`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_revenue_advertiser_currency`	`int` Общая сумма в нано в валюте рекламодателя, внесенная партнерским аккаунтом за событие просмотра. Это значение может быть равно нулю.
`event.dv360_revenue_partner_currency`	`int` Общая сумма в валюте партнера в нано, внесенная партнерским аккаунтом за событие просмотра. Это значение может быть равно нулю.
`event.dv360_revenue_usd`	`int` Общая сумма в нанодолларах США, внесенная партнерским счетом за событие просмотра. Это значение может быть равно нулю.
`event.dv360_state_region_id`	`int` Идентификатор региона DV360
`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.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_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_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_isp_id`	`int` Числовой идентификатор в Дисплее и Видео 360 наиболее вероятного поставщика услуг Интернета для показа. Это значение может отсутствовать.
`event.dv360_language`	`string` Код ISO-639-1 или «zh_CN» (китайский (упрощенный)), «zh_TW» (китайский (традиционный)) или «другой», представляющий язык, связанный с событием просмотра.
`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_revenue_advertiser_currency`	`int` Общая сумма в нано в валюте рекламодателя, внесенная партнерским аккаунтом за событие просмотра. Это значение может быть равно нулю.
`event.dv360_revenue_partner_currency`	`int` Общая сумма в валюте партнера в нано, внесенная партнерским аккаунтом за событие просмотра. Это значение может быть равно нулю.
`event.dv360_revenue_usd`	`int` Общая сумма в нанодолларах США, внесенная партнерским счетом за событие просмотра. Это значение может быть равно нулю.
`event.dv360_state_region_id`	`int` Идентификатор региона DV360
`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.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 - целое число проданных товаров.

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

cm_dt_activity_type
`account_id`	`int` Уникальный идентификатор аккаунта.
`activity_group`	`string` Имя для этой группы действий.
`activity_group_id`	`int` ID группы, к которой принадлежит данный рекламодатель. Рекламодатель может быть членом только одной группы.
`activity_type`	`string` Определяемая пользователем строка, соответствующая значению type= из тега Floodlight.
`advertiser_id`	`int` Уникальный идентификатор рекламодателя.
`floodlight_config_id`	`int` Уникальный идентификатор конфигурации Floodlight.

Объявление о передаче данных Менеджера кампаний 360

cm_dt_ad
`account_id`	`int` Уникальный идентификатор аккаунта.
`ad`	`string` Пользовательское имя объявления.
`ad_click_url`	`string` Переход по URL-адресу только объявлений типа Click Ad (иначе Click Commands)
`ad_comments`	`string` Определяемые пользователем комментарии на уровне объявления.
`ad_id`	`int` Уникальный идентификатор объявления.
`ad_type`	`string` Тип объявления. Возможные значения: «Стандартный», «Межстраничный», «Статический клик», «Динамический клик», «Отслеживание», «Видео In-Steam», «Поиск DART», «Аффилиат», «PInclusion», «Фиды продуктов», «Обычный поиск», «По умолчанию», «Интерстициальный по умолчанию», «InStream по умолчанию», «Без бренда».
`ad_type_id`	`int` Уникальный идентификатор типа объявления.
`advertiser_id`	`int` Уникальный идентификатор рекламодателя.
`campaign_id`	`int` Уникальный идентификатор кампании Менеджера кампаний 360.
`creative_size`	`string` Размер креатива в пикселях: ширина x высота. Пустой размер представлен как «0X0».
`floodlight_config_id`	`int` Уникальный идентификатор конфигурации Floodlight.

Передача данных Менеджера кампаний 360: назначения размещения объявлений

cm_dt_ad_placement_assignment
`account_id`	`int` Уникальный идентификатор аккаунта.
`ad_id`	`int` Уникальный идентификатор объявления.
`advertiser_id`	`int` Уникальный идентификатор рекламодателя.
`floodlight_config_id`	`int` Уникальный идентификатор конфигурации Floodlight.
`placement_id`	`int`

Рекламодатель по передаче данных Менеджера кампаний 360

cm_dt_advertiser
`account_id`	`int` Уникальный идентификатор аккаунта.
`advertiser`	`string` Пользователь ввел имя рекламодателя.
`advertiser_group`	`string` Указанная пользователем группа, к которой принадлежит этот рекламодатель. Рекламодатель может быть членом только одной группы.
`advertiser_group_id`	`int` Идентификатор группы, к которой принадлежит этот рекламодатель. Рекламодатель может быть членом только одной группы.
`advertiser_id`	`int` Уникальный идентификатор рекламодателя.
`floodlight_config_id`	`int` Уникальный идентификатор конфигурации Floodlight.

Объект передачи данных Менеджера кампаний 360

cm_dt_asset
`account_id`	`int` Уникальный идентификатор аккаунта.
`asset`	`string` Название объекта объявления.
`asset_category`	`string` Категория объекта объявления.
`asset_id`	`int` Уникальный идентификатор актива.
`asset_orientation`	`string` Ориентация экрана актива.

Сегменты аудитории Менеджера кампаний 360 по передаче данных

cm_dt_audience_segments
`account_id`	`int` Уникальный идентификатор аккаунта.
`advertiser_id`	`int` Уникальный идентификатор рекламодателя.
`audience_segment`	`string` Название сегмента аудитории.
`audience_segment_id`	`int` Уникальный идентификатор сегмента аудитории.
`floodlight_config_id`	`int` Уникальный идентификатор конфигурации Floodlight.

Браузер передачи данных Менеджера кампаний 360

cm_dt_browser
`browser_platform`	`string`
`browser_platform_id`	`int` Идентификатор браузера/платформы

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

cm_dt_campaign
`account_id`	`int` Уникальный идентификатор аккаунта.
`advertiser_id`	`int` Уникальный идентификатор рекламодателя.
`billing_invoice_code`	`string` Код, указанный в счете-фактуре.
`campaign`	`string` Пользователь ввел название кампании.
`campaign_end_date`	`int` Дата окончания кампании в формате ГГГГММДД.
`campaign_id`	`int` Уникальный идентификатор кампании Менеджера кампаний 360.
`campaign_start_date`	`int` Дата начала кампании в формате ГГГГММДД.
`floodlight_config_id`	`int` Уникальный идентификатор конфигурации Floodlight.

Город передачи данных Менеджера кампаний 360

cm_dt_city
`city`	`string` Название города
`city_id`	`int` Уникальный идентификатор города.

Клики по передаче данных Менеджера кампаний 360

cm_dt_clicks
`event.operating_system_id`	`int` ID операционной системы.
`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_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.audience_segment_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_auction_id`	`string` Строка, используемая для объединения событий между типами просмотр/клик/конверсия, например "ABCDEFGH_abcdefgh-0123456789". Не предполагайте какой-либо порядок, структуру или значение значения аукциона_id.
`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_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_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_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_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_state_region_id`	`int` DV360 Region ID
`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.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_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_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_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_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_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_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_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.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 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_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).

Campaign Manager 360 Data Transfer paid search

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_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_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_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_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_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_state_region_id`	`int` DV360 Region ID
`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.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_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_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_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_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_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_state_region_id`	`int` DV360 Region ID
`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.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_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_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_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_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_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_state_region_id`	`int` DV360 Region ID
`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.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_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_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_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_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_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_state_region_id`	`int` DV360 Region ID
`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.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_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_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_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_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_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_state_region_id`	`int` DV360 Region ID
`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.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_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_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_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_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_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_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_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.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

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 ad group

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 ad group creative

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

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

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

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

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

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

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

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

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

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

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

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.
`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