Merging Weather Data with Google Analytics
How does weather affect your website’s conversions?
Before you can answer this question, you're going to need some way of merging your Google Analytics with Weather data.
Here's Simo Ahava's blog on the subject:
As Simo points out, this is not an optimal solution - a couple of problems are API rate limits and the sheer inefficiency of a method that repeatedly polls the same API endpoint. Good luck if you have more than say 10K visits per day!
The big plus here is that you can get historic weather data joined with your historic analytics data.
- weather.weatherCategory (e.g. Snow, Rain, Clear etc)
- weather.weatherDescription (more detail for the category)
- weather.sunrise (time at the nearest station)
- weather.temperature (edited)
See it in action
Example dataset in BigQuery: