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
Market Analysis:
Track consumer trends and preferences
Inform marketing strategies
Optimize digital campaigns
Quantitative Analysis:
Measure relative popularity of search terms over time
Gain insights into consumer behavior
Identify patterns and trends for data-driven decision making
Location Planning:
Understand regional differences in consumer behavior
Inform expansion strategies
Optimize operations and marketing efforts across different locations
Example Use Cases
Analyze celebrity popularity trends across different regions and time periods
Track the impact of major events (e.g., lottery jackpots) on search behavior
Identify rising search terms during specific holiday periods
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
Find weeks, countries, and regions where "Selena Gomez" was a top trending term in 2022:
Return weeks and DMAs where "Mega Millions" had a search score of 100 in 2022:
Support and Contact
For questions, support, or custom data solutions, please contact Dataplex Consulting & Data Products:
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.
Last updated