Google trends visualizer code#

Upload your clean CSV and Google Fusion tables can automagically generate these lat/long coordinates for you, and even map them or let you then export them. Use Google Fusion tables to automatically look this up.If you are just looking to do a static info graphic by state you can skip this step. In order to put something on a dynamic map you need a latitude and longitude coordinate for each row of data you want plotted. This is how Charity Water tells their story of impact very effectively. You can include links to content, photos, or other interesting details if you want to create a story map that shows where different events happened.

Google trends visualizer code#

Using just a ZIP code or City is enough to randomly create a lat/long that wonвЂ™t reveal too much data.

Make sure there is a ZIP code or address in one of the columns.

Pull the data to excel (or database of your choosing) and make sure it is consistently organized and uniform in the units being used.

Crisis Text Line Trends вЂ“ open and anonymized data around where CTL receivesВ crisis textsВ by type and location.

Programmatic data вЂ“ this data would come from your internal databases and, if anonymized, can be used to tell your story.

and вЂ“ shows representatives and voting records on all issues/bills.

Google Trends вЂ“ trends gives comparative data for a particular search and lets you pull these rankings (manually) by state.

Google Analytics вЂ“ your web traffic can be exported in aggregate and you can pull this by location as a CSV or a KML map file.

вЂ“ this site houses tons of data sets across areas such as transportation, health that can easily be exported to CSV.

Some sources you may or may not have considered: Often the most valuable insights come from combining different data sets. Which emotions do you want to evoke and what would a next step be for someone that wantвЂ™s to take action? I love Simon SinekвЂ™s approach to thinking about this.ДЇind the data you need to tell your story. Start with вЂwhyвЂ™Дefine the narrative you hope to build around the visualization and the message that you want to resonate with the people that look at it.

In order to guard against this kind of #datafail, here are some tips, ideas, and tools to create a useful map visualization map for your nonprofit. Before launching into a fun afternoon of data visualization for your organization, it is important to ask the fundamental question вЂ“ why? Why are we creating this graphic and what is the intended outcome for the work? I love a good map as much as the next person but if the data behind the map is poorly collected and the story the map tells is poorly conceived, I am afraid all you may have done is to create a bit of data porn.