Articles for "CSV"

How can I load historical weather data into Google Sheets?

In this article, I’m going to show you how to easily load historical weather data into Google sheets.  We’ll walk through the process step-by-step showing you how to construct the query in Visual Crossing Weather and then use the query URL to import the weather results into Google Sheets. Also see our companion article that …

Bulk weather forecast data retrieval for multiple locations

Visual Crossing provides the ability to retrieve up to 16 day forecasts for any world wide location based on address, zipcode/postcode or latitude and longitude. In this article we discuss how to retrieve the full weather forecast for multiple locations in a single request. This makes it easy to import weather forecast information for many …

How to use weather forecasts to optimize Google Ads

Google Ads and other online advertising has become essential to every business. While it is obvious that every business needs to advertise online, business that have no online sales ability still find it valuable to reach out to potential customers while they are browsing the internet. Even businesses that are very local in their reach …

How to use weather forecasts to manage visual marketing and inventory

How to use weather forecasts to manage visual marketing and inventory

Use case: Manage the displays and local advertising for a chain of shoe stores based on weather forecasts. Ever since the inception of the retail trade, retailers have been using visual marketing techniques such as window displays, shelf layout and end-caps to entice customers. Intelligently managed product displays can attract customers into the store and …

How We Process the NOAA Integrated Surface Database Historical Weather Data

How We Process the NOAA Integrated Surface Database Historical Weather Data

We use a lot of sources for our weather data. One of the richest sources of historical weather data is the Integrated Surface Database (ISD) from NOAA. The amount of data available is impressive. Hourly or sub-hourly weather records for 1000s of weather stations that are, in some cases, over 100 years old. However obtaining and manipulating …