Google Trends Top Daily Terms Data Warehouse

Multiple sets of the top 25 Google Trend searches a day dating back to 2017 broken up into fact tables by US or International Top or Rising. The dataset automatically refreshes every few days and is available on the Snowflake Marketplace.

Tables included:

• Top Search Terms Fact - A fact table with a row per search term, week, and DMA (U.S.) for the top 25 search terms per day that includes the score for the top search terms for each DMA.

• Top Rising Search Terms Fact - A fact table with a row per search term, week, and DMA (U.S.) for the top rising 25 search terms per day, including the score and percent gain for the rising top search terms for each DMA.

• Top International Search Terms Fact - A fact table with a row per search term, week, and Country Region (International) for the top 25 search terms per day that includes the score for the top search terms for each Country Region.

• Top International Rising Search Terms Fact - A fact table with a row per search term, week, and Country Region (International) for the top rising 25 search terms per day that includes the score and percent gain for the rising top search terms for each Country Region.

• Week Dimension - A dimensional date table at the week grain with common date-related attributes including holidays included in a week.

• Designated Market Area Dimension (DMA) - A U.S.-specific location dimensional table for Nielsen’s Designated Market Areas®. Join this dimension to the "Top"/non-International fact tables. A designated market area (DMA), also referred to as a media market, is a region of the United States that is used to define television and radio markets.

• Region Dimension - An International breakdown of country codes and regions in a dimensional table to join the International fact tables.

High-Value Fields Included:

• Search Term - Human readable identifier

• Score - Index from 0-100 (100 being the best) that denotes how popular this term was for a DMA or region during the current week, relative to the other weeks in the same time series for this term. A value of 100 is the peak popularity for the term.

• Percent gain - Percentage gain at which term rose compared to previous weeks. Only included in the "rising" fact tables.

• Latitude & Longitude - For Both Designated Market Areas (DMAs) and International Regions

本数据集包含自2017年起每日的前25名谷歌趋势（Google Trend）搜索词数据，按美国/国际的热门搜索、飙升搜索分类划分为事实表。该数据集每数日自动更新，可在Snowflake数据市场获取。

包含以下数据表：
• 热门搜索词事实表（Top Search Terms Fact）：针对每日前25名搜索词，按搜索词、周次、美国指定市场区域（DMA）生成行级事实表，包含各DMA的热门搜索词热度分值。
• 飙升搜索词事实表（Top Rising Search Terms Fact）：针对每日前25名飙升搜索词，按搜索词、周次、美国指定市场区域（DMA）生成行级事实表，包含各DMA的飙升搜索词热度分值与涨幅百分比。
• 国际热门搜索词事实表（Top International Search Terms Fact）：针对每日前25名国际搜索词，按搜索词、周次、国家/地区（国际）生成行级事实表，包含各国家/地区的热门搜索词热度分值。
• 国际飙升搜索词事实表（Top International Rising Search Terms Fact）：针对每日前25名国际飙升搜索词，按搜索词、周次、国家/地区（国际）生成行级事实表，包含各国家/地区的飙升搜索词热度分值与涨幅百分比。
• 周维度表（Week Dimension）：以周为粒度的日期维度表，包含常见日期相关属性，当周内的节假日也纳入其中。
• 指定市场区域维度表（Designated Market Area Dimension，简称DMA）：针对美国尼尔森（Nielsen）指定市场区域（Nielsen’s Designated Market Areas®）的专属位置维度表，可与非国际类的热门/飙升搜索词事实表进行关联。指定市场区域（DMA，又称媒体市场）是用于定义美国电视与广播市场的地理区域。
• 地区维度表（Region Dimension）：包含国家代码与地区划分的国际维度表，可与国际类搜索词事实表进行关联。

包含以下高价值字段：
• 搜索词（Search Term）：供人类识别的可读标识符
• 热度分值（Score）：取值范围为0-100（100为最高分），用于表征该搜索词在当前周内，相对于该词同期时间序列中其他周次的热门程度，分值100代表该词的热度峰值。
• 涨幅百分比（Percent gain）：该搜索词相较于前几周的涨幅占比，仅在“飙升”类事实表中包含该字段。
• 经纬度：覆盖美国指定市场区域（DMAs）与国际地区两类地理范围

搜集汇总

背景与挑战

背景概述

该数据集收集了自2017年以来每日Google趋势的前25个搜索词，按美国或国际的Top与Rising类别分表存储，包含搜索词、得分、百分比增长和地理位置等关键字段。数据每几天自动更新，并通过Snowflake Marketplace提供，涵盖7个表格以支持多维分析。