Edit on GitHub
Verizon Media link
Updated November 1, 2023
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.
Featureslink
| 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 | 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 | check | |
| 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 | API configuration |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking |
Setup guidelink
Follow our step-by-step Verizon Media setup guide to connect Verizon Media with your destination using Fivetran connectors.
Schema informationlink
This schema applies to all Verizon Media connectors
Accounts Schemalink
To zoom, open the ERD in a new window.Report Tableslink
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_REPORTlink
| 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_REPORTlink
| 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_REPORTlink
| 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_REPORTlink
| 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_REPORTlink
| 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_REPORTlink
| 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_REPORTlink
| 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_REPORTlink
| 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_REPORTlink
| 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_REPORTlink
| 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_REPORTlink
| 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_REPORTlink
| 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_REPORTlink
| 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_REPORTlink
| 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_REPORTlink
| 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 noteslink
The default retention period for Verizon Media reporting tables is 400 days. However, for
PERFORMANCE_STATS_HOURLY_REPORTandSLOT_PERFORMANCE_HOURLY_REPORTreport 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_countingcolumn is empty. We sync the skipped rows after thefact_conversion_countingcolumn is populated with the final values to avoid duplicate data rows.