Wednesday, November 20, 2024

SearchResearch Challenge (11/20/24): How to look at more trend data?

 Limits in your searching can be so annoying... 

Scales to get relative and absolute weights.
P/C Jean Poussin, from Wikipedia. (CC BY-SA 3.0)

... and there are times when you'd like to look at the data, but the tools just don't quite let you do the analysis you'd like to do. 

This week, I happened to be looking at which of the most common holidays in the US created the most search traffic.  Why? As you know, many people look to Google search traffic as an approximation for the level of interest in a topic, and I wanted to know which of the holidays occupies more mental space in the brains of US citizens?  Christmas?  Thanksgiving?  The Super Bowl?  Or.. what?  

To figure this out, I really needed to compare multiple search queries at the same time.  Sounds great.  

But there's a problem: How can I create a chart like this, with more than 5 variables?  (Google Trends only allows you to compare 5 different queries!)  

As you can see, here I'm showing 6 different holidays on the same chart.  This is a "Relative Search Volume" chart, and not the absolute numbers.  When Google computes such charts, the measure with the largest volume will be normalized to 100%.  All of the other data is based off of that. 


So... the obvious Challenge is this: 

1.  How can you get more than 5 search volumes compared side-by-side?  

And a corresponding question: 

2. Since these are all relative values, are these BIG numbers, or relatively small ones?  How would you know?  

Tell us what you think the answers to the Challenge are in the comments.  What clever method did you use to get to 6, 7, or more variables on the same Google Trends chart?  

Keep Searching! 



3 comments:

  1. I searched [google trends more than 5 words] a Keyword is the key. Different articles and how to use them.

    You make the comparison and then you use sheets to make those 2 or more 5 items comparisons in just one.

    Maybe there's a better new solution. I'll keep Searching!

    Also thinking. In Dr. Russell's list: The Super Bowl is a different comparison. That is Christmas and Thanksgiving are Holidays. Super Bowl is not so maybe comparison is searching using only those three a good way to find out answer? I'll try that too

    ReplyDelete
  2. ¯\_(ツ)_/¯ I have NO frame of reference for this - export to spreadsheets?
    https://youtu.be/Kkd2PkbCdSc?si=qTTF2OpOqO6exxH-
    see comments too -
    https://digitaljobstobedone.com/2017/07/10/how-do-you-compare-large-numbers-of-items-in-google-trends/

    #2 - LLN -
    https://www.investopedia.com/terms/l/lawoflargenumbers.asp
    https://en.wikipedia.org/wiki/Law_of_large_numbers
    CLT -
    https://www.investopedia.com/terms/c/central_limit_theorem.asp
    https://www.embibe.com/exams/comparing-very-large-and-very-small-numbers/

    ReplyDelete
    Replies
    1. trend tutorials -
      https://www.youtube.com/@GoogleSearchCentral/search?query=trends

      Delete