Sales by Country Report

The Sales by Country report shows where your sales are coming from. See a list of countries, along with the number of sales and total revenues from each, during the selected date range.

Running a Report

Follow these steps to run the Sales by Country report:

Log into the Merchant Portal: https://mp.segpay.com
Go to the navigation menu and click Performance Reporting menu > Sales by Country.
Click the date-selector box and choose the time period you want to report on.
Select the Merchant Accounts you want to see in the report.
Select which specific Cash Program(s) you want included in the report.

This groups your websites together by the cash/affiliate program(s) they are associated with, so it may be easier for you to report by cash program instead of selecting URLs in the next step.

Select “None” to include websites that are not associated with any Cash program. The report will include sales associated with the cash program(s) you select here.
Select the types of sales you want included in the report under Transaction Sources:
- Signups: transactions resulting from an initial signup.
- Conversions: transactions that occur when a trial period converts to a full membership.
- Rebills: transactions resulting from recurring subscription charges (includes one-click transactions as well).
Click Select All to include all types of transactions in the report.
Click the URLs menu to see a list of your websites.

If you selected specific cash program(s) in the previous step, you will only see URLs associated with the selected programs. All URLs are selected by default, but you can select only specific sites to be included in the report.
Choose which specific sale you want see by currency if you've had sales in multiple currencies. The choices are: US Dollar (USD), Euros (EUR) or British Pounds (GBP).
Select how you want customer country to be determined:
- Customer Country: Country is taken from the customer’s billing address.
- IP Country: Country is taken from the referring IP address on the customer’s computer/device when the transaction occurred.
Click Generate Report.

By default, results are sorted by Merchant ID, and countries are listed alphabetically under each merchant (if you have more than one). Each row represents a combination of a country and currency type, and displays the number of sales, and total monetary amount, for each of those combinations. If you are viewing multiple currencies, the total sales amount at the bottom of the report will reflect blended currencies.

Customizing Report Results

Many reports have similar elements that can be used to customize the report. See below for some sample elements that are available in this report. Note screen shots may not be an exact match for the data returned on this report.

Choosing from a Saved Report

Most reports have four small icons in the top right corner. The one shaped like a floppy disk lets you save your report filter choices so that you can easily retrieve them later.

Click the save icon.
Type a name for your report filter.

If you choose the same name again it will let you overwrite the old filter. You can also rename and delete your filters.
Click Choose from a saved report to pull up your saved filter.

This can save you time if you run the same report many times. Note saved reports save filters but do not save groupings.

Downloading the Report

To download your report:

Choose the download icon.
Type a name for the report and choose a file format (.csv, .xslx, .pdf).
Click the Download button.
On some reports that return thousands of rows of data you will be given some additional choices for your download. You will see an option to have your report emailed to you.
- Large reports may be emailed to you in a zip archive format.
- Very large reports (usually in PDF format) can require the zip archive to be split into multiple emails for delivery.
Save all attachments to the same folder and open the first one and it will uncompress them together into a single large file.

Report Charts

In the top right corner of your report you will see several small icons. The icon with the waving arrow will allow you to see a chart view of your report.

When viewing each chart type you can use the other dropdown filters to change the way your chart data is represented on the page. Experiment with different options to see which gives you the best view for that chart type.

Result Table Filtering in your Report

Your report data is returned in a tabular grid format. There are several useful controls built into this grid for filtering and sorting your data.

Page Controls and both Horizontal and Vertical Scroll Bars will help you to see data that is too large to fit on the screen.

Use the arrows to advance to a certain page or go all the way to the last page. You can also control how many items display on a single page. Totals are shown to the right.