This post was written by Liveli, our master reseller in Australia and New Zealand and featured by Google.
–
Google Analytics is a core component of any business intelligence team’s decision making process. It answers several questions about sources of traffic to your website, tracks the success of your paid ad campaigns and monitors the purchase behavior of your buyers.
But despite the wonderful insights you can glean using Google Analytics, the location data attached to each prospect’s activity is generally underutilized and hidden beneath dashboards and reports. The ‘out of the box’ geovisualization offered in Google Analytics shows no more than a single map of the geographic spread of your website visitors.
However, when you’re willing to dig a little deeper - your Google Analytics data has enormous potential when it is ingested into BigQuery and visualised in CARTO.
The results can show powerful stories about your customers and prospects that were previously undiscoverable. Want to understand what is possible? We have outlined the top three key considerations for analyzing your Google Analytics data in CARTO.
Google Analytics provides geographic data at a city, region, country and sub continent level. For the purposes of being able to perform meaningful spatial analysis on your data, the ‘city’ level is the most worthwhile dataset you can obtain from your Google Analytics console.
City data is useful because it allows you to see how users within a city area are engaging with your content or products. When coupled with your own supplementary data, the insights can be quite compelling.
The Big Red Group, a group of businesses focused on selling travel experiences around the world, uses product location data from their CRM with Google Analytics purchase data to display the unique number of purchases of experiences by city.
Using CARTO Builder, you can simply click on a product location and see lines forming out to the purchase cities - demonstrating how far customers are willing to travel for an experience and how popular these experiences are.
Want to start your spatial analysis journey?
Sign up for a free accountBigQuery is the key interlocker between Google Analytics and CARTO. If you’re using the standard Google Analytics platform, an API is required to bring your data into BigQuery. The good news for Google Analytics 360 users (Google’s advanced business analytics tool) is that your Google Analytics data is automatically ingested into BigQuery as a part of the subscription model.
Once the data is organised in BigQuery, it is then ready for spatial analysis. Using CARTO’s Google BigQuery connector, you can simply enter a SQL query to connect your data & make it available on the CARTO platform - allowing you to easily visualize, perform spatial analyses & build applications.
Performing spatial analyses on your Google Analytics data and supplementary data sets from your business can provide you with incredible insights. Red Balloon, a Big Red Group organization, used CARTO Builder to answer several questions about their online audience.
What are your questions?
Request a live personalized demoLiveli hosted a webinar showing what is possible when you bring your Google Analytics data into CARTO. The results shown in the webinar are beneficial to many industries including food delivery, retail, government and more.
Want to see additional spatial analysis performed on Google Analytics data?
Watch the full webinarIn the retail industry a trade area, also known as a catchment area, is the geographic area from where you draw your customers. There are a number of methods for calculatin...
Use CasesMobility in our cities has been experiencing big changes this year with increases in pedestrianization, bike use, and micromobility options alongside commuting shifts favor...
Use CasesOver 140 million monthly active drivers use Waze every day to save time and navigate roads and freeways more easily. Waze users (aka Wazers) can log accidents, potholes, sl...
Use CasesPlease fill out the below form and we'll be in touch real soon.