Google Trends Top Daily Terms Data Warehouse through 2023

Multiple sets of the top 25 Google Trend searches a day dating back to **2017 through 2023** broken up into fact tables by US or International Top or Rising. The dataset is static and free to use.

<p><br/></p>

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

原始信息汇总

数据集详情

数据集标题

Dataplex Consulting & Data Products : Google Trends Top Daily Terms Data Warehouse through 2023

数据集描述

该数据集包含2023年Google Trends每日热门搜索词的数据仓库。

搜集汇总

背景与挑战

背景概述

该数据集包含2017至2023年期间Google每日搜索排名前25的热词数据，分为美国本土和国际市场的Top及Rising四类事实表，涵盖搜索词、热度得分、涨幅百分比等核心指标，并附带周维度、DMA区域等辅助维度表。