5
$\begingroup$

Does anybody have suggestions on how to de-normalize Google Trends data? The site says that their trends are made with the following metric:

The numbers on the graph reflect how many searches have been done for a particular term, relative to the total number of searches done on Google over time. They don't represent absolute search volume numbers, because the data is normalized and presented on a scale from 0-100. Each point on the graph is divided by the highest point and multiplied by 100. When we don't have enough data, 0 is shown

I've been trying to work backwards from there but realized I need the peak value for each search query, which I don't have. Any thoughts appreciated.

Here's an example Google Trends search: http://www.google.com/trends/explore#q=stack%20exchange&cmpt=q&tz=

$\endgroup$
  • $\begingroup$ I wonder if this question does not suite better for opendata.stackexchange.com ... $\endgroup$ – Tim Apr 25 '15 at 7:12
  • $\begingroup$ I don't think it fits opendata. It's a simple question about a normalization strategy, but unfortunately there is any solution if you don't know the maximal value of the search volume array! $\endgroup$ – stochazesthai Apr 25 '15 at 7:21
5
$\begingroup$

Since the normalization consists in $$ \mathbf{z} = \frac{\mathbf{x}}{\max(\mathbf{x})}, $$ where $\mathbf{x}$ is the vector of search volumes, and $\max(\mathbf{x})$ is the maximal element of $\mathbf{x}$, if you want de-normalized data, you should multiply each element of the normalized vector times the maximal element of $\mathbf{x}$:

$$ \mathbf{x} = \mathbf{z} \times \max(\mathbf{x}). $$

Unfortunately, if you don't know the value of $\max(\mathbf{x})$ you can't de-normalize your data.

$\endgroup$
  • $\begingroup$ Google AdWords provide monthly keyword search volumes. Might be useful a starting point. $\endgroup$ – Gajus Nov 12 '18 at 22:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.