AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
2.9K members online now
2.9K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Suggestion for a Weather Data Source for G.A. Data Studio Report

Follower ✭ ✭ ☆
# 1
Follower ✭ ✭ ☆

I would like to utilize a source of weather along with Google Analytics data in a viz. I am new and not sure how it might be best integrated. I want to try out at least two data sources on a viz. 

I'd very much appreciate ideas and data source suggestions. 

 

Many thanks!

1 Expert replyverified_user

Re: Suggestion for a Weather Data Source for G.A. Data Studio Report

[ Edited ]
Rising Star
# 2
Rising Star

openweathermap.org

See this excellent example: http://www.simoahava.com/analytics/send-weather-data-to-google-analytics-in-gtm-v2/

_________________________________________________________________________
Director of Marketing | Nehmedia | Partner Profile

Re: Suggestion for a Weather Data Source for G.A. Data Studio Report

Follower ✭ ✭ ☆
# 3
Follower ✭ ✭ ☆
Hi Phillip - I don't seen an example at that link. I see a lot of discussion and many posts talking about different versions of it not working. What is it that you'd like me to see?

Re: Suggestion for a Weather Data Source for G.A. Data Studio Report

Rising Star
# 4
Rising Star
Sorry - didn't mean to link to the comment - the article itself is the example. The openweather.org API is where you can get the current weather.
_________________________________________________________________________
Director of Marketing | Nehmedia | Partner Profile

Re: Suggestion for a Weather Data Source for G.A. Data Studio Report

Follower ✭ ✭ ☆
# 5
Follower ✭ ✭ ☆
Thanks, Phillip. I did nose around and find what you're referring to.
It seemed complicated to follow their instructions. I have never created an API before.
I suppose you have done it - how long did it take you?

I am game to try it.

I do need some data that I can overlay that is over 2 years old. I don't know what else there might be besides weather (or if open data goes back more than two years) Any other data ideas are appreciated!

Re: Suggestion for a Weather Data Source for G.A. Data Studio Report

Rising Star
# 6
Rising Star
I combined weather data with booking conversions - it didn't take too long. But I'm a programmer as well as a marketer - I would recommend finding some local technical talent.

You really can't do much retroactively. You may be better off exporting your GA data and creating reports offline in a database or Excel.
_________________________________________________________________________
Director of Marketing | Nehmedia | Partner Profile

Re: Suggestion for a Weather Data Source for G.A. Data Studio Report

Follower ✭ ✭ ☆
# 7
Follower ✭ ✭ ☆
Thanks!
i think I'll leave this open in case anyone else has any good ideas.