eCommerce Analytics

Last week in Weather Marketing we talked about ways to use freely available temperature and precipitation data to make sure you’re not marketing parkas to your customers in Texas. The rub was that the National Oceanic and Atmospheric Administration dosn’t exactly make the data available in the friendliest of formats. 

We’ve put our data manipulation skills to work and reworked the data in a way that will make it easy to import into a database table or append to your customer file. The following files provide the average annual and seasonal temperature (in Fahrenheit) and precipitation (in inches) for each state and for the US as a whole. It also lists standard deviation for each value in case you want to go super-nerdy on your analysis.

Have at it in the format of your choice!

Comma separated value: temp_and_precip_by_state.csv

Excel 2007: temp_and_precip_by_state.xlsx

It is a wintry, slushy mess in Boston today. Rivers of ice cold water line every street and each passing car sprays pedestrians unfortunate enough to have to walk to work.

I am one of these pedestrians. Worse, as a Boston transplant, I am woefully ill-equipped to stay dry. At this moment my feet and legs are soaked and I have never been more willing to part with money for a good pair of boots.  Really, I’m ready to buy right now. It’s urgent.

Read Weather Marketing »