You know how much revenue your Shopify store generates. But do you know where it comes from? Which states drive the most orders? Which cities have the highest average order value? Whether your geographic mix is shifting month over month? Upload your Shopify order export and get a complete geographic breakdown — country, state, and city — with trend analysis and AI insights in under 60 seconds.
Why Geographic Analysis Matters for Shopify Stores
Every Shopify store has a geographic fingerprint. Maybe 40% of your revenue comes from California, or maybe three cities in Texas quietly became your fastest-growing market last quarter. Without looking at the data, you are making marketing and logistics decisions based on gut feel instead of evidence.
Geographic analysis answers the questions that actually drive decisions. Where should you concentrate your ad spend? Which regions justify faster shipping options or local fulfillment? Are you over-investing in markets that are already saturated while ignoring regions with growing demand? If you run regional promotions, did they actually move the needle in the target geography?
The problem is that Shopify's built-in analytics give you a top-level view of orders by country, but nothing deeper. You cannot see revenue by state with average order value comparisons, city-level performance rankings, or month-over-month geographic trends. That is exactly what this analysis provides — a multi-level geographic breakdown that turns your raw order export into an actionable regional strategy.
What Data You Need
You need a standard Shopify order export CSV. Go to your Shopify admin, navigate to Orders, and click Export. Select "All orders" or a date range, and choose CSV format. The export includes everything the analysis needs: order ID (the Name column), order date (Created at), billing location fields (Billing Country, Billing Province, Billing City), and the order total (Total).
A few things to know about Shopify exports. Each order with multiple line items appears as multiple rows in the CSV — a three-item order shows up as three rows. The tool handles this automatically by deduplicating to order level, so a $300 order with three products is correctly counted once at $300, not three times at $900. You do not need to clean or preprocess the file.
For meaningful geographic insights, you want at least 50 orders spread across multiple regions. A store with 20 orders all from the same city will produce technically correct results but not actionable ones. The more geographic diversity in your data, the more useful the analysis becomes. Three or more months of data enables the trend analysis, which shows how your geographic mix is shifting over time.
When you upload, you will map your columns: order ID, order date, country, province/state, city, total price, and quantity. For a standard Shopify export, the defaults align directly — Name for order ID, Created at for order date, Billing Country, Billing Province, Billing City for location, and Total for revenue.
How the Report Works
The analysis produces six report slides, each examining your geographic performance from a different angle. Here is what each one tells you and how to use it.
Overview and Data Preparation
The report opens with a summary of your dataset — total orders, total revenue, date range covered, and how many geographic regions are represented. The preprocessing card shows how the tool handled your data: how many raw rows were in the CSV, how many unique orders were identified after deduplication, and whether any records were excluded due to missing location data. This gives you confidence that the numbers in the rest of the report are based on clean, correctly aggregated data. If you see a large number of excluded rows, it usually means some orders had blank billing addresses — common for draft orders or manually created orders.
Geographic Executive Summary
The TL;DR slide is the one you send to your boss. It distills the entire geographic analysis into key findings: your top market by revenue, your fastest-growing region, your highest-AOV geography, and your geographic concentration level. Concentration matters — if your top three cities account for 75% of revenue, your business is highly dependent on those markets. That is both a strength (you know where your customers are) and a risk (losing one market hits hard). The executive summary also includes AI-generated recommendations tailored to your specific data patterns, like whether your geographic mix suggests expansion opportunities or consolidation strategies.
Revenue by Country
The country-level chart shows revenue and order volume broken down by billing country. For many Shopify stores, especially those based in the United States, this chart will show a single dominant country. That is expected — if 98% of your orders come from the US, the country chart confirms it but does not reveal much new. Its real value is for stores with international sales. If you sell to Canada, the UK, Australia, and the US, this chart shows you the revenue split and whether international markets are growing. For single-country stores, move straight to the state and city slides for the actionable insights.
Top Cities Performance
This is often the most revealing slide. The top cities chart ranks your highest-revenue cities and overlays average order value for each one. The combination tells you two different things. High revenue with average AOV means a city drives volume through order count — it has lots of customers. High revenue with high AOV means customers in that city spend more per transaction, possibly buying premium products or larger quantities.
The reverse is equally useful. A city with high AOV but low total revenue means you have a small number of high-value customers there — a prime target for acquisition campaigns to find more customers like them. A city with many orders but low AOV might benefit from upselling or bundling strategies. Every Shopify store's city chart tells a different story, and the AI insights call out the most notable patterns in your specific data.
Geographic Revenue Trends
The trend chart tracks monthly revenue for your top states or provinces over time. This is where you spot shifts in your geographic mix. Maybe California has been your top state for a year, but Texas grew 40% last quarter while California stayed flat. Or maybe a state you ran holiday promotions in spiked in December and dropped back down in January — the promotion drove temporary demand but not retention.
Trends also reveal seasonality by region. A store selling outdoor gear might see Colorado spike in summer and Florida spike in winter. A store selling school supplies will see different states peak based on when school years start. These patterns directly inform when and where to run campaigns, adjust inventory, and allocate marketing budget across regions.
State and Province Analysis
The province analysis card provides a comprehensive comparison of every state or province in your data. It ranks regions by total revenue, order count, and average order value — and crucially, it lets you compare AOV across regions side by side. States where customers spend significantly more per order are worth investigating. Is it because of product mix (they buy more expensive items), cart size (they buy more items per order), or both?
This slide also helps identify underperforming markets. If you run Google Ads targeting Texas but Texas ranks 15th in revenue with below-average AOV, you have a data point that challenges your current ad allocation. Conversely, if a state you have never targeted ranks in the top ten, there is organic demand you could amplify with targeted marketing.
Real-World Use Cases
Regional Marketing Targeting
A DTC apparel brand runs Facebook and Google ads nationally. Their geographic analysis reveals that four states — California, New York, Texas, and Florida — account for 62% of revenue, but Illinois has the highest average order value at $187 compared to a $134 national average. They shift 15% of their ad budget to target Illinois metro areas specifically, hypothesizing that customers there have higher purchase intent. Over the next quarter, Illinois moves from seventh to fourth in total revenue while maintaining its AOV premium.
Shipping Zone Optimization
A home goods Shopify store offers flat-rate shipping everywhere in the US. Geographic analysis shows that 45% of orders ship to the Northeast corridor (New York, New Jersey, Connecticut, Massachusetts). They negotiate a regional rate with their carrier for that zone and introduce free shipping for orders over $75 to that region. The promotion costs less than expected because the density makes per-package costs lower, and Northeast order volume increases 22% in the first month.
Expansion Planning
A specialty food brand based in the Pacific Northwest sees strong organic sales in California and Washington but almost nothing from the Midwest. They run the geographic analysis monthly for six months and notice a slow but steady uptick in orders from Chicago and Minneapolis — small numbers, but consistent growth. They launch a targeted campaign in those cities with localized creative, using the trend data to justify the test budget. Within two months, Chicago enters their top ten cities by revenue.
Seasonal Strategy by Region
An outdoor recreation store uses the geographic trends chart to discover that their Florida revenue peaks in November through February (snowbirds buying gear for mild-winter outdoor activities), while Colorado peaks May through August. They restructure their email marketing calendar to send hiking and camping promotions to Colorado subscribers in spring and to Florida subscribers in fall, instead of running the same national campaigns year-round. Email conversion rates improve by 30% for those segments.
Common Pitfalls
The most common mistake is expecting country-level insights from a single-country store. If 99% of your orders come from the United States, the country bar chart shows one bar. That is correct but not useful — scroll past it to the state and city analysis where the real insights live.
Another pitfall is misreading concentration metrics. High geographic concentration is not inherently bad. A Shopify store selling lobster rolls will naturally concentrate in coastal New England. The question is whether your concentration matches your business model. If you sell nationally but 70% of revenue comes from two cities, you either have an untapped opportunity elsewhere or a very specific customer demographic that clusters geographically.
Watch out for confusing billing address with customer location for B2B orders. If your customers are businesses that bill to a corporate headquarters in Delaware but ship to locations nationwide, the geographic analysis will show Delaware as a top market. For B2B stores, shipping address would be more meaningful, but the standard Shopify export and this analysis use billing address because it is more reliably populated and correct for the vast majority of DTC stores.
When to Use Something Else
If you want to understand what products drive revenue rather than where revenue comes from, use a Shopify order analysis focused on product performance and profitability. If you want to segment customers by purchase behavior — frequency, recency, monetary value — rather than location, RFM segmentation is the right tool. For understanding how your total revenue trends over time without the geographic dimension, a time series analysis provides forecasts and trend decomposition.
Geographic analysis pairs well with these other analyses. Run RFM segmentation to find your best customers, then run geographic analysis to see where they cluster. Or run product profitability analysis to find your highest-margin products, then check which regions buy them most. The geographic lens adds a spatial dimension to insights you already have.
The R Code Behind the Analysis
Every report includes the exact R code used to produce the results — reproducible, auditable, and citable. The analysis handles Shopify's multi-row export format by deduplicating orders on the order ID column and extracting revenue from the Total field. Geographic aggregations use standard R data manipulation with dplyr for grouping and summarization, and ggplot2 for the visualizations. Trend analysis uses monthly aggregation with automatic date parsing from Shopify's timestamp format. No custom black-box algorithms — every step is visible in the code tab of your report, so you can verify the methodology and reproduce results independently.