Verizon Media
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 |
|
|
Custom Data |
check |
AD_HISTORY table. All fields with prefix custom_ in the
AD_EXTENSION_HISTORY , AD_GROUP_HISTORY , ADVERTISER_HISTORY , CAMPAIGN_HISTORY , KEYWORD_HISTORY , SHARED_SITELINK_HISTORY , and SHARED_SITELINK_SETTING tables. |
Data Blocking |
check |
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 |
check |
Connector level |
History |
check |
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. |
API Configurable |
check |
|
Priority-first sync |
|
|
dbt Package |
|
|
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 ERD in 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.