Sales By Geography

 Return to Introduction  Previous page  Next page

The ‘Sales by geography’ section allows you to get information about the geography of your sales. Namely, you can find out, what products from this or that category (or the whole store) were purchased by the customers coming from a certain location, how many items of each product were purchased and what the total sum of purchases was. According to your needs, information about your customers’ location can be gathered from either billing or shipping address provided in the order.

To get information about the purchases made by the customers coming from a certain location, do the following:

1. Select the period.

2. Select the categories you want to include into the search results.

3. Select which address to use - shipping or billing.

<br> 'Sales by geography' search filters


'Sales by geography' search filters

4. Select countries and states to be included into the report.

important

The conditions set by the ‘Country’ and ‘State’ fields are applied consecutively. First, the application scans all the customer addresses of the type selected in the ‘Use address’ select box in the processed/completed orders pertaining to the period, picking only the addresses located in the countries selected in the ‘Country’ field. After that, it picks from the set of addresses collected at the previous stage only the ones located in the states selected in the ‘State’ field. The said above implies that, if you want to use states, you need to select just one country in the ‘Country’ field, and the state(s) selected in the ‘State’ field must be part of it (For example, you cannot find out the number of purchases from Russian Federation and California, USA together in one search. If you select both Russian Federation and United States in the field ‘Country’, and California in the field ‘State’, you will be shown just the purchases from California, USA, Although there might be some orders from Russian Federation, they will be ignored, as there is no state named ‘California’ in Russian Federation).

5. Select 'Quantity' or 'Total' to sort by.

6. Click 'Search'.

Example.

You want to know how many purchases were made at your store in the period April 1, 2006 – April 16, 2007 by residents of USA (You want the search to be based on the billing address). Do the following:

1. Specify the beginning of the period: April 1, 2006.

2. Specify the end of the period: April 16, 2007.

3. As you are interested in all the sales made at your store, click on the ‘check all’ link to select all the categories.

4. Select United States in the field ‘Country’.

5. Select the ‘Split by product options’ check box for product variants to be displayed on separate lines.

6. Select Total in the ‘Sort by’ select box for the search results to be sorted by the total amount.

7. Click on 'Search'.

The results displayed to you will look something like this:

<br> 'Sales by geography' report results


'Sales by geography' report results

If you want to find out how many purchases were made in the same period by residents of just one American state, California, set the search parameters exactly as in the example above, but select California in the field ‘State’ (in addition to United States selected in the field ‘Country’).