Google Trends Top Daily Terms Data Warehouse

About the Dataset

The Google Trends Top Daily Terms Data Warehouse is a free comprehensive collection of the top 25 Google Trend searches per day, covering the period from 2017 through 2023. This dataset offers valuable insights into search trends, broken down into fact tables for both US and International Top and Rising searches. Key features include:

• Static, free-to-use dataset

• Available on the Snowflake Marketplace

• Covers daily top searches from 2017 to 2023

• Separate fact tables for US and International trends

• Includes both top and rising search terms

Dataset Features

• Comprehensive Coverage: Daily top 25 Google Trend searches from 2017 to 2023

• Geographical Breakdown: Separate data for US and International searches

• Trend Analysis: Includes both top and rising search terms

• Scoring System: Search terms scored on a scale of 0-100

• Temporal Granularity: Data organized at the weekly level

• Regional Insights: US data broken down by Designated Market Areas (DMAs)

• International Scope: Global data categorized by country and region

Data Quality and Maintenance

• Static Dataset: The dataset is not actively updated but provides a comprehensive historical view

• Standardized Format: Consistent data structure across all fact tables

• Dimensional Tables: Includes dimension tables for weeks, DMAs, and international regions for easy analysis

Business Applications

1. Market Analysis:

   • Track consumer trends and preferences

   • Inform marketing strategies

   • Optimize digital campaigns

2. Quantitative Analysis:

   • Measure relative popularity of search terms over time

   • Gain insights into consumer behavior

   • Identify patterns and trends for data-driven decision making

3. Location Planning:

   • Understand regional differences in consumer behavior

   • Inform expansion strategies

   • Optimize operations and marketing efforts across different locations

Example Use Cases

1. Analyze celebrity popularity trends across different regions and time periods

2. Track the impact of major events (e.g., lottery jackpots) on search behavior

3. Identify rising search terms during specific holiday periods

4. Compare search trends for specific topics across different countries and regions

Data Structure

The dataset consists of the following main tables:

• Fact Tables:

  • Top Search Terms Fact

  • Top Rising Search Terms Fact

  • Top International Search Terms Fact

  • Top International Rising Search Terms Fact

• Dimension Tables:

  • Week Dimension

  • Designated Market Area (DMA) Dimension

  • Region Dimension

Key fields include:

• Search Term

• Score (0-100 index)

• Percent gain (for rising terms)

• Date

• Location (DMA or International Region)

Entity Relationship Diagram

Sample Queries

1. Find weeks, countries, and regions where "Selena Gomez" was a top trending term in 2022:

SELECT r.country_name,
       r.name AS region_name,
       w.date_at,
       st.search_term,
       f.score
FROM dwv.fct_top_int_search_terms f
JOIN dwv.dim_week w ON f.week_id = w.id
JOIN dwv.dim_search_terms st ON f.search_term_id = st.id
JOIN dwv.dim_int_region r ON f.region_id = r.id
WHERE year = 2022
  AND st.search_term = 'Selena Gomez'
ORDER BY 1,2,3;

1. Return weeks and DMAs where "Mega Millions" had a search score of 100 in 2022:

SELECT r.name AS dma_name,
       w.date_at,
       st.search_term,
       f.score,
       holiday_list
FROM dwv.fct_top_search_terms f
JOIN dwv.dim_week w ON f.week_id = w.id
JOIN dwv.dim_search_terms st ON f.search_term_id = st.id
JOIN dwv.dim_dma r ON f.dma_id = r.id
WHERE w.year = 2022
  AND st.search_term = 'Mega Millions'
  AND f.score = 100
ORDER BY date_at;

Support and Contact

For questions, support, or custom data solutions, please contact Dataplex Consulting & Data Products:

• Email: [e-mail]

About Dataplex

Dataplex Consulting & Data Products is a leading provider of high-quality, turnkey data products and consulting services. With over 20 years of experience serving businesses of all sizes, including Fortune 500 companies, Dataplex offers:

• Top-notch, easily accessible data products

• Automatic quality checks and active monitoring

• Data pipelines designed for seamless ingestion

• Expertise in data architecture, integration, and warehouse design

• Proven track record in enhancing data management and boosting revenue

Dataplex specializes in helping companies become more data-driven, offering practical solutions tailored to each client's unique needs.