Company Blog Support
Frank Hagan
posted

Contents

    Back to Top

    Note: Not all images and content apply to ONTRAPORT 5.
    For backwards compatibility, some articles cover legacy features.
    Please Contact Us if you run into any problems.

    Sales Reports

     

    About

    Sales Reports in ONTRAPORT are found in the Sales collection. There are nine categories of reports available with several configuration options for each category. These reports do not require any setup to activate.

     

    Sales Report

    The Sales Report shows cumulative sales for all of your products. Configuration features include:

    • Eleven possible column headings to view the statistics at a glance Show me



    • The Manage Groups menu allows you to create views of the Sales Report based on the 11 fields available Show me



    • Export the data in CSV format: Select one or all of the Products and select Export from the Actions menu Show me


       
      1. You can select one or all fields to export Show me




      2. The Export screen also shows the previously exported files under Export History

     

     

     

    Subscriber Retention

    Subscriber Retention reports provide statistics on open orders, average days on subscription, revenue and the average customer value. Like the Sales Reports described above, you have several ways to view the data:

    • Eight column headings are available to see your data at a glance. Show me




    • Create Groups based on any of the eight fields. Stack field criteria to create meaningful Groups such as Products with an Average Value and Average Customer Value over a certain amount. Show me




    • Export some or all of the data by clicking the column, then selecting the Actions menu. The CSV file is emailed to the email address you specify. The Export History section shows all past exports, ready to download again. Show me




      

    Subscription Sales

    The Subscription Sales report provides information on completed, pending, cancelled subscription orders as well as subscriptions currently in collections.

    • Fourteen column headings show your Subscription Sales data. Show me




    • Groups can be created to give you custom views of your Subscription Sales. Stack the field criteria to create Groups such as the Least Popular Subscriptions. Show me





    • Export: Select the data you want to export and click Export in the Actions menu. Data is emailed to any email address and also saved in the Export History section.  Show me


     

      

    Transaction Logs

    The Transaction Logs report lists individual transactions by Contact. It includes pre-formatted or custom date ranges and Group options to organize your views of the data.

    • Fourteen column headings are available to customize your view Show me




    • Select a pre-formatted or enter a custom date range in the date selection box Show me




    • Select an individual transaction to act on it. In the Actions menu you can Re-run, Refund or Void a transaction, Re-run Commissions, Re-Send Invoices, Email the Contact or Export the selected transactions. Show me




    • Groups help narrow your view of the transactions. Group by any of the fourteen fields, or create custom views using multiple fields to create the Group.

    • Select transactions in any Group, or select all transactions, for any date range, and click Export on the Actions menu to export them. The CSV file that is emailed to you can be manipulated in Excel, OpenOfficeexternal link or LibraOfficeexternal link spreadsheet programs.

     

     

     

    Product Sales Logs

    The Product Sales Log lists each individual sales transaction. Column headings and Group criteria can retrieve any information from the Purchase history (Order Number, Quantity, Partner,etc.), Contact record of the purchaser (Contact fields are exposed), and Product data (Product ID, Price, etc.)

    • Twelve native column headings are available. Three drill down sections exposing all of the fields for the Purchase details, Contact who purchased and Product details provide additional display options.  Show me




      1. Click the right arrow next to the Purchase section to reveal the following transaction-related fields  Show me




      2. Expose all of the Contact fields by clicking the right arrow next to Contact  Show me




      3. The Product right arrow also exposes more fields related to the Product as configured in ONTRAPORT Show me




    • Create Groups using any of the fields listed above for the column headings.

    • Set a custom date range or select one provided in the date selection box  Show me




    • Select any or all of the data, in any Group, and click the Export link in the Actions menu. The export will be emailed to any email address you desire in a CSV file. Prior exports are listed on the Export page for downloading directly.  Show me


     

     

    Customer Value

    This report provides a snapshot of customer value by Contact name.

    • The available fields for column headings are Contact Name, Email, Last Month Total, All Time Total and Current Open Order Total  Show me




    • Create Groups to segment your Customer Value display by any of the fields, Contact Name, Email, Last Month Total, All Time Total or Current Open Order Total. For example, create a Group of Contacts with a current Open Order to view their customer value  Show me




    • Export options are similar to all other Sales Reports. You can export a single record, any Group of records, or all records, with the CSV file emailed to any email you desire.

     

     

    Shipping Collected

    Shipping Collected allows reporting by date range and, as with other reports, can be exported in a CSV file.

    • Thirteen fields relating to the transaction are available as column headings  Show me




    • Create Groups based on any of the thirteen fields mentioned above. You can stack Group criteria to create reports such as "Shipping Collected / Transaction Refunded"  Show me




    • Use the date options drop down to select a custom date range or any of the pre-formatted date ranges  Show me




    • Export any data shown by selecting it, and clicking the Export link in the Actions menu

     

     

     

    Taxes Collected

    With options similar to the Shipping Collected report, Taxes Collected includes the ability to sort by date range and export the result as a CSV file to any email address you desire.

    • Eleven fields relating to the transactions are available as column headings  Show me




    • Create Groups based on the eleven fields. Stack the Group criteria to create reports such as "Taxes Collected / Transaction Refunded"  Show me





    • Select the date range to filter the data further.  Show me




    • Select data and then the Export link in the Actions menu to create a CSV export of the data.

     

     

     

    Open Orders

    The Open Orders report provides information on the upcoming payment plan, subscription payments or the order to be processed at the end of a free trial period.

    • In addition to the Next Payment Date, Payment Amount, and Type of payment, the Open Orders report exposes the Contact information through the use of a drill down field named Contact Show me

      open-columns.pngopen-contact-column.png
       
    • Groups can be created based on the same fields found for column headings

    • The Actions menu allows you to Delete a Subscription, Edit the Open Order or Export records.  Show me

       
       

     

    FAQs

    Q. Can I create a custom report?

    A. Many of our reports allow customization through the use of Groups and date ranges. We do not have a way to create ad hoc, custom reports at this time.

     

    Q. I really want better metrics than these reports give.

    A. The Dashboardexternal link creates metrics!

     

     

    Articles in this section

    Have more questions? Submit a request

    Comments

    Powered by Zendesk