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 …

Using Historical Weather Data to Investigate the Climate Change impact on Hurricane Barry

Using Historical Weather Data to Investigate the Climate Change impact on Hurricane Barry

As we near the end of the 2019 hurricane season, we look back on Hurricane Barry. As the first hurricane of the season, Hurricane Barry, was a relatively small storm and not nearly as impactful as some that came later. However, understanding it can give us a better understanding of the short-term and long-term impacts …