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

Creating a quarterly sales by territory report shouldn't feel like a chore. This simple report is one of the most powerful tools a sales leader can have, showing you exactly which regions are hitting their numbers and which ones need more support. This article will walk you through how to build this report in Looker, first the traditional way, and then show you how a modern AI approach can get you the same insights in a fraction of the time.

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 a Sales by Territory Report Is a Must-Have

Dumping all your sales data into a single number is like looking at a map without any borders - you see the big picture, but you miss all the critical details. A sales by territory report breaks down your performance geographically, giving you the context you need to make smarter, more focused decisions.

Here’s why it’s so essential:

• Pinpoint Your Powerhouses and Problem Areas: Instantly see which sales territories are your strongest performers and which are lagging. Are certain regions consistently outperforming others? Is a typically strong territory suddenly struggling? This report makes those trends impossible to ignore.
• Allocate Resources Effectively: Once you know where you're winning and losing, you can allocate resources more strategically. A high-performing region might be ready for more investment, like hiring another sales rep. An underperforming one might need better marketing support, additional training, or a revised strategy.
• Set Realistic and Motivating Goals: With historical data broken down by territory, you can set smarter, data-informed sales targets for the next quarter. You’ll have a clear baseline for what’s possible in each region, helping you create targets that are both challenging and achievable.
• Identify Untapped Market Potential: Sometimes a surprising territory pops up with unexpected growth. This report can reveal emerging markets you haven’t fully focused on, giving you a chance to double down on an area with promising momentum.

Without this report, you're essentially flying blind. You might be celebrating an overall revenue increase while completely missing that your top territory is masking serious issues in three other regions. This level of detail is a non-negotiable for any sales team looking to scale efficiently.

Prepping Your Data for a Perfect Report

Before you jump into Looker, remember that any report is only as good as the data behind it. Garbage in, garbage out. A little bit of prep work ensures your final report is accurate and trustworthy. For a sales by territory report, you’ll want to make sure your underlying data source (likely your CRM, like Salesforce or HubSpot) has the following information readily available and clean:

• Deal or Sales Amount: This is the most obvious one - the revenue generated from a sale. Ensure this is tracked consistently for all closed deals.
• Close Date: This essential timestamp allows you to group sales by day, week, month, and most importantly for this report, by quarter. Without it, you can’t perform any time-based analysis.
• Territory / Region Info: This is the core of the report. Territory data might be stored as a country, state, city, or even a custom-defined region. The key is that it's a standard field attached to each contact or deal record, so you can group your sales accurately.
• Deal Stage or Status: You need a way to filter your report to only show deals that are "Closed Won." Including deals that are still in the pipeline will throw off your numbers and give you a wildly optimistic and inaccurate view of actual performance.

Making sure these fields are reliably populated in your CRM will save you countless headaches when you start building reports in Looker or any other BI tool.

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

How to Manually Build the Report in Looker

Looker is a powerful BI tool that gives you incredible control over your data. Building this report the traditional way involves a series of clicks and selections to define exactly what you want to see. Don't worry, it's a straightforward process once you know the steps and what you're trying to accomplish.

Step 1: Get Started in an Explore

In Looker, reporting starts in an "Explore." An Explore is essentially a curated starting point for asking questions of your data. Think of it as a logical grouping of data fields related to a specific part of your business, like deals, website traffic, or support tickets. For this report, you’ll want to find an Explore related to your sales data, likely named something like "Sales Deals," "Opportunities," or "CRM Data."

Step 2: Add Your Dimensions

Dimensions are the “who, what, where, and when” of your data. They are the fields you use to group and categorize your numbers. For this report, you need two key dimensions:

• Territory: Find the dimension that contains your geographical data. It might be called "Region," "Country," "State," or a custom name your company uses. Add it to your report.
• Close Quarter: Next, you'll need the time dimension. Locate the field for the deal's close date. Looker often automatically provides different timeframes for date fields. Choose "Quarter" to group all your sales into their respective quarters.

Step 3: Add Your Measure

While dimensions categorize your data, measures are the numbers - the things you want to count, sum up, or average. In this case, your core measure is sales revenue.

• Total Sale Amount: Find the measure representing the value of your deals, which is likely named something like "Sum of Amount" or "Total Revenue." Add this to your report.

At this point, you've told Looker to *"Show me the Sum of Sales Amount" grouped by "Territory" and "Close Quarter."

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: Set Your Filters

Now, you need to tell Looker what data to include and exclude so you get a clean, accurate report.

• Deal Status: You only want to see closed business, so add a filter on the "Deal Stage" field and set it to match "Closed Won."
• Date Range: To narrow your report to a specific quarterly or yearly view, add a filter on the "Close Quarter" dimension. You could filter for "last 4 quarters" or a specific year like "is in the year 2024."

Step 5: Run & Visualize

Click the "Run" button. Looker will process your request and spit out a data table with your results. While the table is useful, a visual is a much easier representation of what your sales by territory looks like for the quarter.

Some sales by territory visualization options in Looker:

• Bar Chart: Great for a classic view comparing performance across different territories. You can easily spot the high and low performers here with just a quick look.
• Map Chart: If your territories are tied to actual geographic locations (like states or countries), a map visualization can be a visually impactful way to see where your revenue is coming from at a glance.
• Table: Although we recommend a bar or map, a simple table is also valuable because it lays out the precise numbers clearly. It’s also popular to pivot your data where territories are rows and quarters are columns to see year-over-year trends for each region.

Congratulations! You’ve built your report. Now you can save it as a "Look" or add it to a dashboard to monitor ongoing performance. This process works, but it requires knowing where to click, which filters to apply, and how Looker structures its Explores - and as you may know...that involves a learning curve.

The Faster Way: Using AI to Build your Report

Imagine skipping almost all of the manual steps above and simply telling Looker what you want to see. This is the power of using AI for business intelligence. Instead of clicking through menus and dragging fields, you can use plain English to describe the report you need, and the AI translates it for you. This conversational approach changes the game entirely. Instead of clicking and selecting your different data, you simply give it straightforward instructions, like:

Show me total sales by territory as a bar chart for last quarter

The AI understands the request, knows which dimensions and measures to pull, automatically applies the correct filters (like Deal Status = "Closed Won" and the correct date range), and generates the exact visualization you asked for. In seconds.

This method breaks down the barrier to entry. You don’t need to be a Looker power user with deep knowledge of your company's LookML data model. Anyone on the sales team - from a rep to a VP - can get the answers they need just by asking. You can also get more granular and dynamic with your questions:

• "What were the top 5 territories by sales in Q2 2024?"
• "Compare sales in the West region vs. the East region for the last 6 months"
• "Which territory had the highest month-over-month growth last quarter?"
• "Show me total deal counts per territory next to sum of sales amount"

Each question builds upon the last, allowing you to follow your curiosity and drill down into insights without ever getting lost in menus. It transforms reporting from a static, task-based activity into interactive analysis that helps you uncover hidden opportunities and solve your business's problems.

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

Final Thoughts

Crafting a quarterly sales by territory report is a fundamental activity for any results-driven sales organization. You can build it by pulling data into a spreadsheet, meticulously navigating Looker's interface to select your dimensions and measures manually, or you can leverage AI to sidestep the learning curve and simply ask for what you need - the result matters.

At Graphed, we’ve built an AI data analyst that allows your entire team to embrace this faster, more intuitive way of working with data. By connecting your sources, we empower you to have a conversation and ask questions like "create a dashboard comparing sales performance by territory for our different sales teams." No steep learning curve...no waiting on a data analyst to get the basics right. We just offer a faster and easier way for teams to get straight to the insights and quickly see what moves the needle so those numbers trend more and more upward in the right direction. Just like it should be.

Graphed is committed to revolutionizing your business analytics experience.