How to Use eBay Orders Geographic Distribution: Step-by-Step Tutorial
By MCP Analytics Team | Published , updated
Discover where your customers are located and which geographic regions drive the most revenue for your eBay business
Introduction to eBay Orders Geographic Distribution
Understanding where your eBay customers are located is crucial for making strategic business decisions. Geographic distribution analysis reveals which regions generate the most revenue, where to focus marketing efforts, how to optimize shipping strategies, and where to expand your product offerings.
As an eBay seller, every order you ship carries a destination, so you already hold location data about your buyers. It only becomes useful once you count it. By analyzing your orders' geographic distribution, you can answer critical questions like:
- Which states or countries generate the most revenue?
- Which markets might be worth testing, given how few orders they send today?
- Should you offer region-specific shipping options?
- Where should you focus your advertising budget?
- Which regions have the highest average order values?
This tutorial will walk you through the complete process of analyzing your eBay orders' geographic distribution, from data extraction to actionable insights. Whether you're a small seller or managing a large eBay business, understanding your customer geography is essential for growth.
The figures in the examples below come from a small synthetic data set generated for this tutorial (600 made-up orders). They are not from a real store, and your numbers will differ.
Prerequisites and Data Requirements
What You'll Need Before Starting
Before diving into geographic distribution analysis, ensure you have the following:
1. eBay Seller Account Access
You need an active eBay seller account with access to Seller Hub. eBay offers downloadable order reports there. Menu names and report options change, so follow eBay's current Seller Hub help for the exact path.
2. Sufficient Order History
For meaningful geographic insights, the more completed orders you have, the more stable the regional shares are; with only a few dozen orders, a handful of buyers can change the ranking, so stay at country level. A few months of history is enough to rank regions, but it cannot show a full seasonal cycle: for that you need at least a year of orders.
3. Data Export Permissions
Ensure your eBay account has permissions to export order data. Most standard seller accounts include this feature, but if you're managing someone else's account, verify you have the necessary access rights.
4. Spreadsheet Software or Analysis Tool
You'll need Microsoft Excel, Google Sheets, or Python with pandas. The worked examples below use Python so that every number can be re-run; the same grouping can be done with a pivot table.
Required Data Fields
Column names differ between eBay exports and change over time, so rename the columns in the code below to match your file. The fields this tutorial uses are:
Order Number, Sale Date, Buyer Username, Buyer Name, Buyer Email,
Shipping Address Line 1, Shipping Address Line 2, City, State/Province,
Postal Code, Country, Item Title, Quantity, Sale Price, Shipping Cost,
Total Price, Payment Status, Shipping Status
The geographic fields (City, State/Province, Postal Code, Country) are critical for this analysis. Without these fields, you won't be able to accurately determine customer locations.
Step-by-Step Geographic Distribution Analysis
Steps: 1. Get your orders | 2. Export with location fields | 3. Clean the data | 4. Group by state | 5. Key metrics | 6. Chart. To skip the code, upload your export.
Step 1: Get Your Orders Data from eBay
Open your eBay Seller Hub and find the orders report that lets you download your order history. The labels on the menus and download controls change over time and were not re-checked for this tutorial, so use eBay's current Seller Hub help rather than a click path copied from an article.
Expected Outcome: You can see a way to download orders for a date range you choose.
Step 2: Export Orders Data with Geographic Information
Download the orders as a CSV for the period you want to analyze. Make sure the file includes the buyer's shipping city, state or province, postal code and country, plus the order number, the price paid and the payment status. If a geographic column is missing, the matching analysis below is not possible, so re-export before going further.
Expected Outcome: A CSV file on your computer with one row per order, including the location columns.
Step 3: Prepare and Clean Your Data
Raw exports need cleaning before you count anything. Three problems are common: cancelled or unpaid orders, blank countries, and the same place written several ways ("USA", "US" and "United States"; "CA" and "California"). Standardize with a lookup table, not by truncating text: taking the first two letters of a state name turns "Texas" into "TE" and "New York" into "NE", which silently corrupts the grouping.
The block below builds a synthetic export, then applies the cleaning. With your own file, replace the synthetic block with a read of your CSV.
import numpy as np
import pandas as pd
# Synthetic stand-in for an eBay orders export (600 made-up orders).
# With your own file, replace this block with:
# raw = pd.read_csv('ebay_orders.csv')
rng = np.random.default_rng(7)
n = 600
raw = pd.DataFrame({
'Order Number': [f'ORD-{i:04d}' for i in range(n)],
'State/Province': rng.choice(
['CA', 'California', 'TX', 'Texas', 'FL', 'NY',
'new york', 'PA', 'VT', ''],
n, p=[.18, .07, .13, .06, .13, .09, .05, .10, .04, .15]),
'Country': rng.choice(
['United States', 'USA', 'US', 'Canada',
'United Kingdom', 'UK', ''],
n, p=[.5, .15, .15, .06, .04, .04, .06]),
'Total Price': rng.gamma(4.0, 25.0, n).round(2),
'Payment Status': rng.choice(
['Paid', 'Payment Received', 'Cancelled'],
n, p=[.7, .22, .08]),
})
# pd.read_csv turns blank cells into NaN, so mimic that here.
raw = raw.replace('', np.nan)
# 1. Keep paid orders, then those with a country. fillna('') comes
# before .str.strip(): on a NaN, .str.strip() returns NaN and
# NaN != '' is True, so blank countries would slip through.
paid = raw[raw['Payment Status'].isin(['Paid', 'Payment Received'])]
country = paid['Country'].fillna('').str.strip()
no_country = paid[country == '']
print(f"Paid orders without a country (excluded): "
f"{len(no_country)}, ${no_country['Total Price'].sum():,.2f}")
df = paid[country != ''].copy()
# 2. Standardize country names to ISO codes
country_map = {'United States': 'US', 'USA': 'US', 'US': 'US',
'United Kingdom': 'GB', 'UK': 'GB',
'Canada': 'CA'}
df['Country'] = df['Country'].str.strip()
df['Country'] = df['Country'].map(country_map).fillna(df['Country'])
# 3. Standardize states with a lookup (taking the first two letters
# of a name is wrong: "Texas" would become "TE")
state_map = {'california': 'CA', 'texas': 'TX',
'new york': 'NY', 'n.y.': 'NY'}
st = df['State/Province'].fillna('').str.strip()
df['State'] = st.str.lower().map(state_map).fillna(st.str.upper())
print(f"Raw rows: {len(raw)}, kept after filters: {len(df)}")
print(df['Country'].value_counts().to_string())
Expected Output
Paid orders without a country (excluded): 33, $3,134.44
Raw rows: 600, kept after filters: 520
Country
US 438
GB 51
CA 31
In a spreadsheet, the same standardizing is a formula such as =IF(OR(A2="United States",A2="USA"),"US",A2); note the leading equals sign and that OR is a function.
Expected Outcome: A cleaned dataset where paid orders use consistent country and state codes. Orders that still have no state are counted and reported with their revenue, not guessed. Check the filter against blanks: in a real CSV an empty cell is read as NaN, and calling .str.strip() on NaN gives NaN, which is not equal to an empty string, so the blank row would pass the filter. That is why the code fills blanks with an empty string first.
Step 4: Analyze Geographic Distribution
Group the cleaned orders by state and count orders, revenue and average order value (AOV = revenue divided by orders). A pivot table with State as the row field and Count of Order Number and Sum of Total Price as values gives the same result.
us = df[df['Country'] == 'US']
no_state = us[us['State'] == '']
print(f"US orders with no state (excluded): {len(no_state)} of "
f"{len(us)}, ${no_state['Total Price'].sum():,.2f} revenue")
us = us[us['State'] != '']
by_state = us.groupby('State').agg(
orders=('Order Number', 'nunique'),
revenue=('Total Price', 'sum'),
).reset_index()
by_state['aov'] = by_state['revenue'] / by_state['orders']
by_state['revenue_share_pct'] = (
100 * by_state['revenue'] / by_state['revenue'].sum())
by_state = by_state.sort_values('revenue', ascending=False)
print(by_state.round(1).head(6).to_string(index=False))
Expected Output
US orders with no state (excluded): 64 of 438, $6,428.86 revenue
State orders revenue aov revenue_share_pct
CA 108 10633.2 98.5 27.6
TX 79 8077.1 102.2 21.0
NY 62 6145.6 99.1 16.0
FL 56 6054.6 108.1 15.7
PA 46 4867.4 105.8 12.6
VT 23 2748.8 119.5 7.1
On this synthetic data, California leads on revenue and Vermont has the highest AOV on the fewest orders. A high AOV built on 23 orders is a weaker signal than one built on a hundred, so look at order counts next to every average.
Expected Outcome: A table of states ranked by revenue, with orders, AOV and revenue share beside each. The table covers only US orders that have a state; the line above it shows how many orders and how much revenue were left out, so state shares are shares of the included revenue, not of all revenue.
Step 5: Calculate Key Geographic Metrics
Two numbers summarize the table: how concentrated revenue is in the top few states, and how order counts compare once you adjust for population. Orders per 100,000 people measures how many orders arrive relative to a region's size. It counts repeat purchases, so it is not the share of residents who are your customers; for that, count unique buyers instead of orders.
top3 = by_state.head(3)
print(f"Top 3 states: ${top3['revenue'].sum():,.2f} of ${by_state['revenue'].sum():,.2f} "
f"({100 * top3['revenue'].sum() / by_state['revenue'].sum():.1f}%)")
# Orders per 100,000 people. Populations here are made-up round numbers; use current census figures.
population = {'CA': 39_500_000, 'VT': 650_000}
for s, pop in population.items():
o = int(by_state.loc[by_state['State'] == s, 'orders'].iloc[0])
print(f"{s}: {o} orders, {o / pop * 100_000:.2f} orders per 100k people")
Expected Output
Top 3 states: $24,855.91 of $38,526.64 (64.5%)
CA: 108 orders, 0.27 orders per 100k people
VT: 23 orders, 3.54 orders per 100k people
The populations in the code are round placeholders, not census figures; use current census numbers for your own regions. Vermont's rate is higher than California's here, but 23 orders is a small base, so treat it as a question to investigate, not as proof that your products resonate more there.
Expected Outcome: A concentration figure for your top regions and a population-adjusted rate to compare small and large markets.
Step 6: Create Geographic Visualizations
A chart does not need a plotting library to be useful. This plain pandas text bar chart reuses the state table from Step 4 and prints one mark per 2 percent of revenue share:
# Text bar chart: one '#' per 2% of revenue share, plain pandas.
for _, r in by_state.head(6).iterrows():
bar = '#' * int(round(r['revenue_share_pct'] / 2))
print(f"{r['State']:>3} {bar} {r['revenue_share_pct']:.1f}%")
Expected Output
CA ############## 27.6%
TX ########## 21.0%
NY ######## 16.0%
FL ######## 15.7%
PA ###### 12.6%
VT #### 7.1%
This does not draw a map or a scatter plot. If you want a choropleth by state or an orders-versus-revenue scatter (many small orders versus fewer large ones), build them from the same by_state table in the plotting or spreadsheet tool you already use.
Expected Outcome: Clear visual representations that make it easy to communicate findings to stakeholders or use for strategic planning.
Interpreting Your Geographic Distribution Results
Understanding the Patterns
Once you have your geographic distribution data, interpretation is key. Here's how to extract actionable insights from your results:
Identifying Your Core Markets
Your core markets are regions that meet these criteria:
- Top 20% in total revenue contribution
- Above-average order frequency
- Consistent orders over time (not one-time spikes)
These markets deserve priority in your business strategy. For example, if California represents 30% of your revenue with consistent monthly orders, it's a core market that warrants dedicated attention: perhaps California-specific promotions or optimized shipping options.
Spotting Growth Opportunities
Look for regions with these characteristics:
- Growing order volume month-over-month
- High average order values but low total volume
- Large population but underrepresentation in your customer base
These are hypotheses to test, not established opportunities. In your own data, a state with a large population but only moderate representation in your orders is a candidate for a small, time-boxed marketing test; compare its orders before and after, and keep in mind that an increase may have other causes.
Recognizing Decline Signals
Watch for warning signs in previously strong regions:
- Decreasing order volume over 3+ consecutive months
- Falling average order values
- Increasing return rates (if you have that data)
These trends may indicate increased competition, changing customer preferences, or shipping issues that need addressing.
Benchmarking Against Population
Raw order counts can be misleading: a state may show high order volume simply because it has a large population. The orders-per-100,000 figure from Step 5 adjusts for that. Read it as order intensity, since repeat buyers raise it without adding customers, and compare it only between regions with enough orders for the rate to be stable.
Seasonal and Temporal Patterns
Analyze how geographic distribution changes over time. You might discover:
- Seasonal shifts (e.g., more cold-weather state orders in winter for certain products)
- Holiday shopping patterns varying by region
- Back-to-school timing differences between states
Understanding these patterns allows you to time your marketing and inventory decisions regionally. For a more comprehensive understanding of how to interpret patterns in data, explore our guide on A/B testing statistical significance, which provides frameworks applicable to geographic analysis as well.
Implementing Geographic Insights
Optimize Shipping Strategies
Use your geographic data to make shipping more efficient and customer-friendly:
Regional Shipping Tiers
If you notice high order volumes from specific regions, consider:
- Offering free shipping thresholds tailored to regional average order values
- Negotiating better rates with carriers for your high-volume zones
- Setting up regional fulfillment centers if volume justifies it
Expedited Shipping Options
For regions with high average order values, promote premium shipping options. Whether those buyers want faster delivery is something to test, for example by offering the option to one region and comparing uptake.
Target Marketing Campaigns
Geographic insights should directly inform your advertising strategy:
eBay Promoted Listings
Check which location options your advertising tools offer. Where you can weight budget by region, consider allocating more to:
- Your largest current markets, to keep serving
- High-potential markets showing growth signals
- Regions with high AOV for maximum return on ad spend
External Advertising
If you run Google Ads or Facebook ads driving traffic to your eBay listings, use geo-targeting to focus on your best-performing states or cities.
Inventory and Product Strategy
Let geography guide your product decisions:
- Regional Preferences: If certain products sell better in specific regions, stock more inventory for those areas
- Climate-Based Products: Push cold-weather items to northern states, outdoor summer gear to sunbelt regions
- Local Trends: Research regional trends and preferences to inform new product additions
Similar to how businesses analyze fulfillment strategies, understanding geographic distribution helps optimize operations: learn more about performance optimization in our Amazon FBA vs FBM performance analysis, which offers parallel insights for eBay sellers.
Sources
- Wilson, E. B. (1927). "Probable inference, the law of succession, and statistical inference." Journal of the American Statistical Association. Background on why a share or rate built on a small count is uncertain, which is why the tables above show order counts beside every average. doi.org/10.1080/01621459.1927.10502953
All figures in the worked examples come from the synthetic data generated by the code on this page (seed 7). eBay export columns and menus change, so check eBay's current Seller Hub help for your file.
Run It on Your Own eBay Export
Export your orders from eBay as a CSV and upload it at MCP Analytics, then ask the question in plain language; the report names the method. Nothing connects to your eBay account.
Next Steps with eBay Geographic Analysis
Advanced Analysis Techniques
Once you've mastered basic geographic distribution, consider these advanced approaches:
Cohort Analysis by Region
Track customer behavior by acquisition geography. Do customers from certain regions have higher lifetime values or return rates?
Competitive Geographic Mapping
Research where your competitors are strong and identify markets where you have an advantage or opportunity to gain ground.
Zip Code Level Analysis
For very large eBay businesses, drill down to postal code level to identify micro-markets within major metropolitan areas.
Integration with Other Analytics
Geographic distribution becomes even more powerful when combined with other data:
- Product Performance: Which products sell best in which regions?
- Customer Segmentation: Create buyer personas by geographic segment
- Profitability Analysis: Calculate profit margins by region accounting for shipping costs
- Customer Lifetime Value: Determine if certain regions produce more valuable long-term customers
For sellers looking to modernize their analytics approach, explore our insights on AI-first data analysis pipelines to understand how machine learning can enhance geographic and other e-commerce analyses.
Regular Review
Geographic distribution isn't a one-time analysis. Establish a regular review schedule:
- Monthly: Quick review of major shifts in top 10 regions
- Quarterly: Comprehensive analysis including trend identification and strategy adjustments
- Annually: Deep dive including competitive benchmarking and long-term strategic planning
At each review, look for a core market that has dropped sharply from the previous month, or a new region that has appeared in your top 10. Choose the size of change that matters for your volume; small regions swing a lot from month to month.
Common Issues and Solutions
Issue 1: Missing or Incomplete Location Data
Problem: Many orders in your export have blank city, state, or country fields.
Causes:
- International orders where eBay doesn't capture complete address data
- Buyers using eBay's Global Shipping Program (location shows as domestic shipping center, not actual buyer location)
- Data export settings not including all address fields
Solutions:
- Re-export data ensuring all address fields are selected in export settings
- For Global Shipping Program orders, check whether your export has a separate field for the buyer's own country, and use it instead of the shipping address if it does
- Accept that some share of the data will be incomplete; report how many orders you excluded alongside the results
- For future orders, encourage buyers to complete full address information
Issue 2: Inconsistent Geographic Naming
Problem: The same location appears multiple times with different spellings (e.g., "NY", "N.Y.", "New York", "new york").
Solutions:
In a spreadsheet, with the state in cell A2, one formula standardizes a few known variants (Excel compares text without regard to case) and a lookup against a table handles more:
=IF(OR(A2="NY",A2="N.Y.",A2="New York"),"NY",A2)
=VLOOKUP(A2,StandardizationTable,2,FALSE)
Create a standardization table mapping all variations to official abbreviations. Whatever tool you use, check its output for variants it missed.
Issue 3: Skewed Results from Business Buyers
Problem: A few business buyers placing large orders in specific regions distort your geographic distribution.
Solutions:
- Segment analysis: Run separate reports for business buyers and individual consumers
- Use median instead of mean for average order value calculations to reduce outlier impact
- Create a "B2B-excluded" version of your analysis for consumer market insights
- Track both total revenue and number of unique buyers per region
Issue 4: Low Order Volume Makes Patterns Unclear
Problem: With only 50-100 orders, geographic distribution seems random with no clear patterns.
Solutions:
- Extend your analysis period to 6-12 months to gather more data
- Analyze at a higher geographic level (country or region rather than state or city)
- Look for directional indicators rather than definitive conclusions
- Combine with qualitative data: ask customers where they're from and why they purchased
- Focus on order concentration: even with limited data, you can see if orders cluster in certain areas
Issue 5: Data Privacy and International Regulations
Problem: Concerns about storing or analyzing customer location data given GDPR, CCPA, and other privacy regulations.
Solutions:
- Aggregate data to regional level rather than storing individual addresses
- Use anonymization: remove customer names and emails before analysis
- Check that any tool you use to analyze the data fits the data protection rules that apply to you
- Delete raw data after extracting aggregated insights
- Check whether your privacy policy needs to mention geographic analysis
Issue 6: Results Don't Match Your Expectations
Problem: Your geographic distribution doesn't align with where you thought your customers were located.
This is actually valuable information:
- You've discovered your actual market, which may differ from your target market
- This disconnect suggests opportunities: either double down on unexpected strong markets or investigate why target markets aren't converting
- Verify your data is correct, then adjust your business strategy to reality
- Consider whether your unexpected markets suggest a product positioning opportunity
Conclusion
Understanding your eBay orders' geographic distribution transforms vague hunches into data-driven strategies. By following this tutorial, you've learned how to extract eBay data, clean and prepare it for analysis, calculate key geographic metrics, interpret patterns, and most importantly, translate insights into concrete business actions.
Geographic distribution analysis isn't just about knowing where customers are. It's about understanding where to focus your limited resources for maximum impact. Whether that means optimizing shipping for your core markets, launching targeted campaigns in growth regions, or adjusting inventory based on regional demand, these insights directly impact your bottom line.
Remember that geographic patterns evolve over time. Markets that are strong today may shift as competition changes, products evolve, and economic conditions fluctuate. Make geographic analysis a regular part of your eBay business review process, not a one-time exercise.
Ready to put these techniques into practice? Try the analysis on your own export and see where your biggest opportunities lie.
Explore more: eBay Seller Analytics: all tools, tutorials, and guides →
Not sure which plan? Compare plans →