How to Create a Quarterly Sales by Territory Report in Google Analytics with AI

Knowing where your sales are coming from isn't just a fun fact, it's the bedrock of a smart sales and marketing strategy. Google Analytics is packed with the location data you need, but getting it into a clean, useful "quarterly sales by territory" report often feels like a full-time job. This guide will show you how to skip the headache of manual export-and-merge cycles and create this vital report using the power of AI.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Standard GA Reports Fall Short for Sales Territory Analysis

Google Analytics 4 is an incredibly powerful tool for understanding website behavior. You can see which countries, regions, and cities send you the most traffic, how long users stay, and which pages they visit. But when your sales manager asks, "How did the Midwest territory perform against quota this quarter?" the standard reports start to show their cracks.

Here's where the disconnect happens:

• It's Web-Centric, Not Sales-Centric: GA4 is built to measure user interactions like sessions, pageviews, and engagement rates. While you can track 'purchase' events and revenue, GA rarely tells the whole story. The final sales data often lives in a separate system like Shopify, Stripe, or your CRM (Salesforce, HubSpot, etc.).
• Connecting the Dots is Manual: To get a true territory report, you need to combine web behavior from GA4 with actual sales data from another platform. This means downloading a CSV of user locations from Google Analytics, another CSV of sales data from your CRM, and then trying to stitch them together in a spreadsheet.
• Manual Reporting is a Time Sink: This process of exporting, cleaning, and merging data isn't just tedious, it's a huge time drain. Many marketing and sales teams spend hours every month - or even every week - pulling the same manual reports. It’s a common bottleneck where by the time the data is ready, the opportunity to act on it might have passed.

Gathering the Right Data for Your Report

Before you build your report, you need to know what ingredients you're working with. A comprehensive sales by territory analysis relies on pulling specific metrics from a few different places. At a minimum, you'll need the following:

From Google Analytics 4:

• Location Data: This is the foundation of your report. You’ll be looking for dimensions like Country, Region (state/province), and City. This tells you where your website visitors are physically located.
• Traffic Source Data: To add more context, you'll want to know how users from each territory found you. Key dimensions include Session source / medium, which can tell you if a location responds better to organic search, paid ads, or social media.
• Revenue & Conversion Data: The most important piece from GA4 is the purchase event and its associated value (Total revenue). This metric links website activity directly to e-commerce sales.

From Your CRM or E-commerce Platform:

• Finalized Sales Data: While GA4 e-commerce tracking is great, the untouchable source of truth is typically your sales platform. For B2B companies, this is your CRM like Salesforce, where manually closed deals are tracked. For e-commerce, it’s Shopify or a payment processor like Stripe, which tracks every dollar, including refunds or adjustments that GA might miss.
• Territory Definitions: Your company likely has its own definitions for sales territories (e.g., "Pacific Northwest" or "South East"). This information almost always lives in your CRM, assigned to sales reps and accounts.

The core challenge isn't finding this data, it's getting it all to talk to each other in one cohesive report.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

The Old School Method: Building the Report in a Spreadsheet

Before AI streamlined this process, the only way to get this report was with some serious spreadsheet work. Understanding this manual process is useful because it highlights just how much time and energy you can save with a modern approach.

Step 1: Export Data from Google Analytics

First, you would login to your GA4 property and navigate to the reports section. You'd typically build an exploration report.

1. Go to Explore and create a new blank report.
2. In the 'Variables' column, import 'Region' or 'Country' as your primary dimension.
3. 'Total Users' and 'Total revenue' go in as your metrics.
4. Set your date range to the last complete quarter (e.g., April 1 - June 30).
5. Drag the dimensions and metrics into the 'Rows' and 'Values' sections in the main 'Tab Settings' panel.
6. Once the table populates, find the export icon (a sheet with a down arrow) and download the file as a CSV.

Now you have one piece of the puzzle.

Example Export (GA4 Data):

Region,Total Users,Total revenue California,10450,85200.00 Texas,8750,67100.00 New York,8100,79500.00 Florida,7500,55300.00

Step 2: Export Data from Your Sales System

Next, you would navigate to your CRM or e-commerce platform. Let's use Salesforce as an example.

1. Go to the reports tab in Salesforce.
2. Create a new report for "Opportunities" or "Orders" filtering for deals "Closed Won" within the same quarter.
3. Add columns for the 'Deal Amount' and the billing state/region.
4. Run the report and export the data as another CSV.

Step 3: The Pain of Merging in a Spreadsheet

Now comes the hard part. Open both CSV files in Google Sheets or Excel. Your goal is to combine them into a single master sheet where each territory has its GA revenue and CRM revenue side-by-side.

You'll need to use a function like VLOOKUP or INDEX(MATCH). You'd use the 'Region' column as the common lookup key to pull CRM sales data into your GA export sheet.

Immediately, you’ll run into problems. 'California' in GA4 might be listed as 'CA' in Salesforce. Inconsistent naming conventions will break your formulas, forcing you to spend time cleaning and standardizing the data before you can even begin analyzing it.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 4: Building Your Pivot Table

After a lot of cleaning and coffee, let's assume you have a functioning master sheet. Now you create a pivot table.

• Select all your data.
• Go to Insert > Pivot Table.
• Drag 'Region' into the 'Rows' section.
• Drag 'Total revenue' and 'Total revenue (CRM)' into the 'Values' section, ensuring they are set to SUM.

Finally, you have a summary table. Now you just need to visualize it.

Step 5: Visualizing the Data

Select your pivot table data and insert a bar chart, pie chart, or a map chart if your spreadsheet tool supports it. You can finally see your results. The whole process probably took a few hours, and if your boss has a follow-up question, you have to start all over again.

The Modern Method: Create Your Report in Seconds with AI

The manual process is fragile, time-consuming, and simply not scalable. AI-powered analytics tools change the whole equation. Instead of being a data janitor who wrangles spreadsheets, you become an analyst who finds insights.

The process is far simpler.

Step 1: Connect Your Data Sources (Once)

The first and only setup step is connecting your data sources. In a modern AI analytics platform, this is a painless, one-time task. You simply authorize access to your Google Analytics account, your Salesforce account, your Shopify store, and anything else you use. One-click integrations handle all the complex API work, syncing your data securely in the background and keeping it up to date. No more CSVs, ever.

Step 2: Ask For Your Report in Plain English

This is where the magic happens. Instead of clicking through menus and writing formulas, you just ask for what you want, like you’re talking to a data analyst on your team.

You use simple, conversational prompts:

• “Show me a bar chart of total revenue by state for last quarter.”
• “Create a table of our top 10 cities by sales in Q2 from Shopify.”
• “Build a US map visualizing Salesforce revenue by billing state.”

The AI understands the request, knows where the data lives (in GA, Salesforce, or Shopify), and generates the chart or report instantly. What used to take hours of manual labor now takes seconds.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 3: Instantly Drill Down with Follow-Up Questions

The biggest advantage is the difference between a static report and a dynamic conversation. Once your initial chart is created, you can keep asking questions to dig deeper.

• After getting a sales map, you might ask: “Which traffic sources drove the most revenue in California?”
• If you see a spike in Texas, you could ask: “Compare sales in Texas this quarter to last quarter.”
• If a region is underperforming, you could ask: “Show me all the campaigns we ran targeting Florida last quarter.”

This transforms reporting from a chore into an exploration. You can follow your curiosity, test hypotheses, and uncover insights in real-time without having to go back and rebuild your report from scratch each time.

How to Squeeze Value From Your Territory Report

Once you have an easily accessible report, you can shift your focus from building it to using it strategically. Here are a few things to look for:

• Find Your Strongholds: Identify which territories are consistently your top performers. What can you learn from them? Can you replicate that success elsewhere?
• Spot Underperforming Areas: Compare marketing activity with sales results. If a territory receives a lot of website traffic and ad spend but has low sales, there might be a problem with messaging, product fit, or local competition.
• Discover Hidden Opportunities: Are you seeing organic sales growth from a territory you aren’t even targeting? This is a clear signal to investigate further and potentially allocate more marketing resources there.
• Inform Sales Quotas and Marketing Budgets: Use historical performance from your reports to set realistic and data-driven quarterly goals for sales reps and allocate marketing spend more effectively.
• Optimize Your Ad Spend: Pinpoint the regions that not only convert but convert with the highest average order value (AOV). You might discover that even though New York generates more traffic, customers in Georgia spend more per transaction, making it a more profitable target for ad dollars.

Final Thoughts

Building a quarterly sales by territory report is a fundamental activity for any business that wants to grow intelligently. The difference between spending hours in spreadsheets and seconds with a natural language prompt is enormous, allowing you to focus on strategy instead of report preparation.

At our company, we built Graphed to solve this exact problem. We got tired of the manual data wrangling and knew there had to be an easier way. We let you connect your Google Analytics, Shopify, Salesforce, and other accounts in just a few clicks. From there, you can ask for dashboards and reports in plain English, turning a multi-hour ordeal into a quick, real-time conversation with your data.