What Is the Customers by Location Report?
The Customers by Location report brings Shopify customer addresses and contact details into one export. Review countries, cities, states or provinces, and ZIP or postal codes alongside customer names and IDs to understand where your customer records are concentrated.
Use it to prepare regional customer lists, check missing address details, and organize customer records for your team. The report fields describe customer profiles; they do not include order destinations, spending, order counts, or marketing consent. Count distinct Customer IDs when summarizing customer distribution, and check which date field your selected reporting period uses.
Report Overview
- Report type
- Customer Reports, with customer-level location and contact details.
- Reporting period
- Check the date basis in the report settings before applying a range.
- Data included
- 12 fields covering customer identity, contact information, and address details.
- Best for
- Reviewing geographic distribution, preparing regional lists, and checking address completeness.
- Export and delivery
- Excel, CSV, TXT, or PDF, with scheduled email delivery available daily, weekly, or monthly.
What Can You Learn from Customer Location Data?
1. Where your customer records are concentrated
Group an Excel export by Customer Country and count distinct Customer IDs to compare geographic distribution. This is a customer count, not a revenue ranking.
Example: For example, export contains more distinct customers in Canada than in France.
What you can do: Use the distribution to prioritize regions for further market research.
2. Which cities or regions need a closer look
Country totals can hide local clusters. Customer City and Customer Province let you examine smaller areas within the same country.
Example: For example, US customer list shows a cluster of records in Austin, Texas.
What you can do: Prepare a regional list for planning a local event or customer service coverage.
3. Where location details need cleanup
Blank country, province, or postal code fields can leave customers out of regional summaries. Use Customer ID to trace incomplete records.
Example: For example, record has a city but no country.
What you can do: Review the source record before assigning it to a regional group.
What Should You Check First in This Report?
Check these details before using the export to make regional decisions.
- Distinct customer count: Use Customer ID to avoid counting the same customer more than once if records repeat.
- Location completeness: Review missing countries, cities, provinces, and postal codes before interpreting the distribution.
- Consistent place names: Check abbreviations and alternate spellings before grouping locations in a spreadsheet.
- Reporting scope: Confirm filters, the address source, and any date basis so repeated exports cover comparable records.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Reviewing customer distribution by country | Provides country details and Customer IDs for a distinct-customer summary. |
| Planning a city or regional initiative | Lets you review customer records by city and state or province. |
| Checking incomplete customer addresses | Brings address lines, country, city, province, and postal code into one review. |
| Preparing a regional customer contact list | Pairs location details with names, emails, and phone numbers; check consent separately before marketing. |
| Sharing a recurring location review | Provides a saved report that can be emailed on a regular schedule. |
How to Create This Report in Data Export
Start with the premade Customers by Location report to use its existing field selection.
- Open Data Export in your Shopify admin and find the premade Customers by Location report.
- Open the report and review the customer identity, contact, and address columns.
- Apply available country, city, or province filters as needed. If selecting a date range, first confirm the field it applies to.
- Save the report, generate it, and download your chosen supported format.
- Optionally schedule daily, weekly, or monthly email delivery to the people who need the location review.
Make the Most of This Report
Use these four checks to keep location exports useful and easy to share.
01 / COUNTING
Count customers once: Summarize distinct Customer IDs, rather than assuming every exported row represents a different customer.
02 / POSTAL CODES
Keep codes as text: Import postal codes as text in spreadsheets to preserve leading zeros and letters.
03 / SCOPE
Use comparable settings: Keep the same filters and date basis when comparing exports. Customer address edits can change regional totals.
04 / SHARING
Limit contact details: Remove email, phone, and street-address columns when recipients only need a regional summary.
Frequently Asked Questions
Can I see Shopify customers by country, city, or state?
Yes. The report includes Customer Country, Customer City, and Customer Province. Use available filters or summarize the export to review those areas.
Does this report include customer counts by location?
The report columns contain individual customer details, without a separate customer-count field. Count distinct Customer IDs by location in your spreadsheet to build a summary.
Does it show customer shipping or billing addresses?
They are customer address fields. Check the address source in the report settings; the fields alone do not show where orders were delivered.
Can I use the email list for regional marketing?
You can prepare a location-based contact list, but the listed fields do not include marketing consent. Check consent and suppression preferences in your marketing system before sending a campaign.
Can I export and schedule this report?
Yes. The report supports Excel, CSV, TXT, and PDF exports, plus daily, weekly, or monthly scheduled emails. Review recipients and remove unnecessary contact details before sharing.