Verizon Media Sunset

Verizon Media (formerly known as Yahoo Gemini) offers you information about the performance of your Verizon Media Ads. You can find more information about it on Verizon Media's documentation page.

Features

Feature Name	Supported	Notes
Capture deletes
History mode		`AD_HISTORY`, `AD_EXTENSION_HISTORY`, `AD_GROUP_HISTORY`, `AD_URL_TAG_HISTORY`,_`CAMPAIGN_HISTORY`, `KEYWORD_HISTORY`, `KEYWORD_URL_TAG_HISTORY`,`SHARED_SITELINK_HISTORY`,`SHARED_SITELINK_URL_TAG_HISTORY`, and `TARGETING_ATTRIBUTE_HISTORY` tables only.
Custom data		`AD_HISTORY` table.<br/>All fields with prefix `custom_` in the <br/>`AD_EXTENSION_HISTORY`, `AD_GROUP_HISTORY`, `ADVERTISER_HISTORY`, `CAMPAIGN_HISTORY`, `KEYWORD_HISTORY`, `SHARED_SITELINK_HISTORY`, and `SHARED_SITELINK_SETTING` tables.
Data blocking		Column level and table level. All the report tables: `CAMPAIGN_BID_PERFORMANCE_STATS_REPORT`, `CONVERSION_RULES_STATS_REPORT`, `KEYWORD_STATS_REPORT`, `PERFORMANCE_STATS_DAILY_REPORT`, `PERFORMANCE_STATS_HOURLY_REPORT`, `PRODUCT_AD_PERFORMANCE_STATS_DAILY_REPORT`, `PRODUCT_ADS_REPORT`, `SEARCH_STATS_REPORT`, `SITE_PERFORMANCE_STATS_REPORT`, `SLOT_PERFORMANCE_STATS_DAILY_REPORT`, `SLOT_PERFORMANCE_STATS_HOURLY_REPORT` and `USER_STATS_REPORT`.
Column hashing
Re-sync		Connector level
API configurable
Priority-first sync
Fivetran data models
Private networking
Authorization via API

Setup guide

Follow our step-by-step Verizon Media setup guide to connect Verizon Media with your destination using Fivetran connectors.

Schema information

This schema applies to all Verizon Media connectors

Accounts Schema

To zoom, open the ERD in a new window.

Report Tables

In the following section, COLUMN lists the title of every column in each table and REFERENCE tells you which table and column you can join the current table with.

AD_EXTENSION_DETAIL_REPORT

COLUMN	REFERENCE
ad_extn_id 🔑	AD_EXTENSION_HISTORY
ad_group_id 🔑	AD_GROUP_HISTORY
ad_id 🔑	AD_HISTORY
advertiser_id 🔑	ADVERTISER_HISTORY
campaign_id 🔑	CAMPAIGN_HISTORY
day 🔑
device_type 🔑
keyword_id 🔑	KEYWORD_HISTORY
average_call_duration
average_cost-per-install
average_cpc
average_cpm
average_position
call_conversion
clicks
conversions
ctr
destination_url
impressions
max_bid
pricing_type
spend

ADJUSTMENT_STATS_REPORT

COLUMN	REFERENCE
advertiser_id 🔑	ADVERTISER_HISTORY
campaign_id 🔑	CAMPAIGN_HISTORY
day 🔑
source_name 🔑
adjustment_type
average_position
clicks
conversions
impressions
is_adjustment
pricing_type
spend

CAMPAIGN_BID_PERFORMANCE_STATS_REPORT

COLUMN	REFERENCE
ad_group_id 🔑	AD_GROUP_HISTORY
advertiser_id 🔑	ADVERTISER_HISTORY
campaign_id 🔑	CAMPAIGN_HISTORY
day 🔑
supply_type
group_or_site
group
bid_modifier
average_bid
modified_bid
impressions
clicks
post_click_conversions
post_impression_conversions
conversions
cost
ctr
average_cpc

CALL_EXTENSION_STATS_REPORT

COLUMN	REFERENCE
ad_group_id 🔑	AD_GROUP_HISTORY
advertiser_id 🔑	ADVERTISER_HISTORY
campaign_id 🔑	CAMPAIGN_HISTORY
day 🔑
call_duration
call_end_time
call_start_time
call_status
caller_area_code
caller_name
caller_number

CONVERSION_RULES_STATS_REPORT

COLUMN	REFERENCE
ad_group_id 🔑	AD_GROUP_HISTORY
advertiser_id 🔑	ADVERTISER_HISTORY
campaign_id 🔑	CAMPAIGN_HISTORY
keyword_id 🔑	KEYWORD_HISTORY
day🔑
source_name 🔑
category_name
conversion_device
conversion_value
conversions
landing_page_type
post_click_conversion_value
post_click_conversions
post_view_conversions
price_type
rule_id
rule_name

KEYWORD_STATS_REPORT

COLUMN	REFERENCE
ad_group_id 🔑	AD_GROUP_HISTORY
advertiser_id 🔑	ADVERTISER_HISTORY
campaign_id 🔑	CAMPAIGN_HISTORY
ad_id 🔑	AD_HISTORY
day 🔑
device_type 🔑
keyword_id 🔑	KEYWORD_HISTORY
source_name 🔑
average_cpc
average_cpm
average_position
clicks
conversions
ctr
impressions
max_bid
post_click_conversions
post_impression_conversions
spend
total_conversions

PERFORMANCE_STATS_DAILY_REPORT

COLUMN	REFERENCE
ad_group_id 🔑	AD_GROUP_HISTORY
ad_id 🔑	AD_HISTORY
advertiser_id 🔑	ADVERTISER_HISTORY
campaign_id 🔑	CAMPAIGN_HISTORY
day 🔑
device_type 🔑
source_name 🔑
ad_extn_clicks
ad_extn_conversions
ad_extn_impressions
ad_extn_spend
average_cpc
average_cpm
average_position
click_outs
click_outs_rate
clicks
conversions
cost_per_video_view
ctr
forward_rate
forwards
impressions
max_bid
opens
post_click_conversions
post_impression_conversions
pricing_type
save_rate
saves
spend
total_conversions
video_100
video_25
video_50
video_75
video_after_30_seconds_view
video_closed
video_skipped
video_starts
video_views

PERFORMANCE_STATS_HOURLY_REPORT

COLUMN	REFERENCE
ad_group_id 🔑	AD_GROUP_HISTORY
ad_id 🔑	AD_HISTORY
advertiser_id 🔑	ADVERTISER_HISTORY
campaign_id 🔑	CAMPAIGN_HISTORY
day 🔑
device_type 🔑
hour 🔑
source_name 🔑
ad_extn_clicks
ad_extn_conversions
ad_extn_impressions
ad_extn_spend
average_cpc
average_cpm
average_position
click_outs
click_outs_rate
clicks
conversions
cost_per_video_view
ctr
forward_rate
forwards
impressions
max_bid
opens
post_click_conversions
post_impression_conversions
pricing_type
save_rate
saves
spend
total_conversions
video_100
video_25
video_50
video_75
video_after_30_seconds_view
video_closed
video_skipped
video_starts
video_views

PRODUCT_AD_PERFORMANCE_DAILY_REPORT

COLUMN	REFERENCE
ad_group_id 🔑	AD_GROUP_HISTORY
advertiser_id 🔑	ADVERTISER_HISTORY
campaign_id 🔑	CAMPAIGN_HISTORY
day 🔑
device_type 🔑
product_ad_id 🔑
source_name 🔑
ad_extn_clicks
ad_extn_conversions
ad_extn_impressions
ad_extn_spend
average_cpc
average_cpm
average_position
click_outs
click_outs_rate
clicks
conversions
cost_per_video_view
ctr
forward_rate
forwards
impressions
max_bid
opens
post_click_conversions
post_impression_conversions
pricing_type
save_rate
saves
spend
total_conversions
video_100%_complete
video_25%_complete
video_50%_complete
video_75%_complete
video_after_30_seconds_view
video_closed
video_skipped
video_starts
video_views

PRODUCT_ADS_REPORT

COLUMN	REFERENCE
ad_group_id 🔑	AD_GROUP_HISTORY
advertiser_id 🔑	ADVERTISER_HISTORY
campaign_id 🔑	CAMPAIGN_HISTORY
category_id 🔑
day 🔑
device_type 🔑
average_cpc
brand
category_name
category_path
clicks
ctr
custom_label_0
custom_label_1
custom_label_2
custom_label_3
custom_label_4
impressions
parent_category_id
product_id
product_name
product_type
source
spend
total_conversions

SEARCH_STATS_REPORT

COLUMN	REFERENCE
ad_group_id 🔑	AD_GROUP_HISTORY
ad_id 🔑	AD_HISTORY
advertiser_id 🔑	ADVERTISER_HISTORY
campaign_id 🔑	CAMPAIGN_HISTORY
day 🔑
device_type 🔑
keyword_id 🔑
average_cpc
average_position
click_share
clicks
conversion_share
conversions
ctr
delivered_match_type
destination_url
impression_share
impressions
max_bid
post_click_conversions
post_impression_conversions
search_term
spend

SLOT_PERFORMANCE_DAILY_REPORT

COLUMN	REFERENCE
ad_group_id 🔑	AD_GROUP_HISTORY
ad_id 🔑	AD_HISTORY
advertiser_id 🔑	ADVERTISER_HISTORY
campaign_id 🔑	CAMPAIGN_HISTORY
day 🔑
ad_format_name
ad_slot_type
card_id
card_position
clicks
ctr
impressions
post_click_conversions
pricing_type
rendered_type
source
spend
tile_position

SLOT_PERFORMANCE_HOURLY_REPORT

COLUMN	REFERENCE
ad_group_id 🔑	AD_GROUP_HISTORY
ad_id 🔑	AD_HISTORY
advertiser_id 🔑	ADVERTISER_HISTORY
campaign_id 🔑	CAMPAIGN_HISTORY
day 🔑
hour 🔑
ad_format_name
ad_slot_type
card_id
card_position
clicks
ctr
impressions
post_click_conversions
pricing_type
rendered_type
source
spend
tile_position

SITE_PERFORMANCE_STATS_REPORT

COLUMN	REFERENCE
ad_group_id 🔑	AD_GROUP_HISTORY
advertiser_id 🔑	ADVERTISER_HISTORY
campaign_id 🔑	CAMPAIGN_HISTORY
day 🔑
average_bid
average_cpc
clicks
conversions
cost
ctr
group
group_or_site
impressions
modified_bid
post_click_conversions
post_impression_conversions
supply_type

USER_STATS_REPORT

COLUMN	REFERENCE
ad_group_id 🔑	AD_GROUP_HISTORY
ad_id 🔑	AD_HISTORY
advertiser_id 🔑	ADVERTISER_HISTORY
audience_id 🔑
campaign_id 🔑	CAMPAIGN_HISTORY
day 🔑
device_type 🔑
keyword_id 🔑	KEYWORD_HISTORY
source_name 🔑
ad_extn_clicks
ad_extn_impressions
ad_extn_spend
age
audience_name
audience_status
audience_type
average_position
city
city_woeid
clicks
conversions
cost_per_video_view
country
country_woeid
dma_woeid
engagement_rate
engagements
follow_rate
follows
gender
impressions
landing_page_type
like_rate
likes
location_type
paid_engagement_rate
paid_engagements
post_click_conversions
post_impression_conversions
pricing_type
reblog_rate
reblogs
spend
state
state_woeid
total_conversions
video_100%_complete
video_25%_complete
video_50%_complete
video_75%_complete
video_after_30_seconds_view
video_closed
video_skipped
video_starts
video_views
zip
zip_woeid

Sync notes

The default retention period for Verizon Media reporting tables is 400 days. However, for PERFORMANCE_STATS_HOURLY_REPORT and SLOT_PERFORMANCE_HOURLY_REPORT report type, retention period is only 15 days. See Verizon Media's documentation for more information.
We skip the rows of a table if the fact_conversion_counting column is empty. We sync the skipped rows after the fact_conversion_counting column is populated with the final values to avoid duplicate data rows.