We Automate SnowflakeDB Data Cloud Cost Saving. Sign Our Free 7 Days No Risk Trail Now
[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 Medias documentation page”, ., Features, Featurexa0Namexa0xa0xa0xa0, 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 Medias 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. , n]
Every week, we'll be sending you curated materials handpicked by professionals. Plus, you'll be the first to know about our latest data!
Copyright 2023 IT Strategists, Inc.  All Rights Reserved. Community site to educate and connect Snowflake users, not part of Snowflake Inc.