ds@mcpanalytics.aiEmail your data and your question and get an answer about your own data, with the method shown.Email your data and question. Get an answer.

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:

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:

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:

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:

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:

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:

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:

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:

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

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.

Try it on your data

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:

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:

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:

Solutions:

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:

Issue 4: Low Order Volume Makes Patterns Unclear

Problem: With only 50-100 orders, geographic distribution seems random with no clear patterns.

Solutions:

Issue 5: Data Privacy and International Regulations

Problem: Concerns about storing or analyzing customer location data given GDPR, CCPA, and other privacy regulations.

Solutions:

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:

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 →

Your turn

Bring your own data and the question you actually need answered.

MCP AnalyticsData science by email Send us your data and your question, and we will reply. ds@mcpanalytics.ai