Reporting

Reporting

Operations Reporting

The UltraCart platform features a variety of robust reports to help you manage your e-commerce business.  The reporting menu is broken down into two sections:

  • Tools
  • Reports

Tools

The tools section allows you to manage any reports that you have scheduled and pickup asynchronous reports.

ToolDescription
Scheduled Reports

Allows you to manage the reports that you have previously scheduled.

Report PickupThis screen allows you to pickup reports that the system has run asynchronously.  Some reports process large amounts of information and are run by UltraCart in the background.  When a report completes an email is sent to the user letting them know that they can pickup the completed report. 

Scheduling Reports

Only a few reports have the option to Schedule Reports to run automatically in the future.  The Custom Period Sales report does. The following shows the completed Schedule Report at the bottom of the screen. This is completed after your configure the details of the report.


Once you've completed the form, click the Generate Report button. Scheduled Reports will be emailed to the addresses you indicated (see above).

Report Pickup

If the report covers a large date range you can expect some wait time and can obtain the report in the Report Pickup area.  You'll receive an email when it's completed.

Simply click the download button to obtain the report. You may be prompted to Save the file or Open depending on how you configure the report.  Click the Delete button when the report is no longer needed.  If you don't see your report a click of the refresh button may bring it up but only if it's completed.  Again, you should receive an email when completed.

Reports

The reports section is where you can access the different store level reports that are available. 

Simply click on the report name to be taken to the required form for completion.

Below is a description of each of the reports:

ReportDescription
Abandon Lead ReportThis report shows any customers that put information in and clicked the buy button, but did not complete it for a number or reasons.
Advertising SourcesThis report shows what your customer chose as advertising sources if you have advertising sources turned on here.
Auto Order Active ReportThis report provides a breakdown of each auto order item for the specified reporting period. The report provides the following details:
 

Active
Test Order
In Accounts Receivable
Refunded
Net Active - Total Auto Orders excluding; Accounts Receivable, Tests & Refunded.
New
Canceled
Disabled

Auto Order Declining Payments Report

This report provides a list of all active auto orders that registered a decline on next rebill.

The report contains the following columns:

  1. original_order_id
  2. next_attempt
  3. failure_reason
  4. most_recent_rebill
  5. edit
Auto Order Profit ReportThis report provides a section for each auto order item with the following columns:

Age (Months)
Customers
$ Net During Month
$ Net Through Month
Avg. Customer Value
# Rebills During Month
$ Rebilled During Month
# Rebills Through Month
$ Rebilled Through Month
# Refunds During Month
$ Refunded During Month
# Refunds Through Month
$ Refunded Through Month

The rows show the breakdown of each month. So the first row is the first month, second row is the second month, and so on.

 
Auto Order Rebill Value ReportThis report shows the value of each auto order-able item over time.  It is useful for understanding the lifespan of a typical continuity customer.
Auto Order Status ReportThis report provides a comprehensive snapshot of the status of each auto orders for each auto order item.
ChargebackThis report provides an overview of chargebacks being processed via the Chargeback processing tool.
ChurnThe report provides a snapshot of the customer "churn".
Cost Entry ReportThis report provides a snapshot of the profit made from each sale, that can be used to them perform a deeper profit analysis.
Coupon Usage ReportThe coupon usage report provides a breakdown of the orders in which coupons were applied.  
Current Period SalesThe same details as the "Custom Period Sales" report, but date range is automatically set for month-to-date (whereas the custom period sales report provides "begin" and "end" date fields to define the time frame for the reporting period.)

Custom Period Sales

This your main sales report. This one shows sales for the specified period and also details refunds during the period as well as accumulated refunds.
(See: Understanding the Period Sales reports and refund reporting)
Customer Item Purchase ReportThis report generates a summary of the items purchased by each customer within a given time period. It also breaks the information down by regular vs auto order sales of the item. For each item there is a detailed page which shows the sales detail for the given item by email.
Customer Web Browser UsageThe report provides a list of web browser families that the customer's are using when placing their orders, along with the count of each browser family, for the reporting period.
Customer Screen SizeThis report provides a breakdown of the device screen size associated with each order placed during the reporting period.
Cohort Customer Report

The Cohort Customer report groups customers by time periods and shows how those customers behaved following their initial purchase.  It helps answer these business questions such as:

  • What is the lifetime value ( LTV) of customers who purchased more than 12 months ago?
  • Track LTV of auto order items
  • Is that particular Facebook campaign profitable?
  • What is the quality of the traffic generated by a particular affiliate?
  • Can I afford to pay a particular affiliate more if they demand it?
  • What percentage of my auto order (recurring) customers remain after 90 days?
Customer ValueThis report allows you to see repeat customer analysis, to see the number of orders a customer has placed and much more.
Email CampaignsThis report provides activity details regarding email campaigns, the report provides a breakdown of emails sent, bounces, opt outs, as well as the number of clicked links.
Expiring Card Before RenewalThis report provides a list of auto orders that have an expiring credit card on file for the rebill.
Gift Certificate UsageThe "Gift Certificate Usage" report provides a breakdown of purchases of gift certificates and their usage, including remaining balance.
Integration Logs - AllProvides a snapshot view of the integration logs unfiltered.
(See also "Integration Log Health Report" for automated email notification of critical issues.)
Integration Logs - Critical

Provides a snapshot view of the integration logs filtered on critical errors.

(See also "Integration Log Health Report" for automated email notification of critical issues.)

Integration Logs - Errors

Provides a snapshot view of the integration logs filtered on all errors/warnings.

(See also "Integration Log Health Report" for automated email notification of critical issues.)

Inventory Planning ReportThis report provides a breakdown of the inventory settings and inventory allocation details for each item sold during the specified reporting period(s). The table columns are:

  • Item ID
  • Description
  • Inventory
  • Allocated to PO
  • Allocated to SC
  • Available to Allocate
  • Pre-order
  • Track Inventory Shipped (for reporting date range)
  • Sales (for reporting date range)
Item Gross Margin ReportThis report provides the following columns:
  • Catalog Group
  • Item #
  • Description,Total

The report will provide a summary with these details:

  • Subtotal
  • Shipping, Total
  • COGS, Gross Margin
  • Gross Margin %
  • Units Sold
Item InventoryThis report provides a snapshot of the item inventory.
Item Sales



Each item sold during the reporting period is listed and provides the following details regarding each order that contained the item

  • Date 
  • Pricing Tier 
  • Company 
  • Name 
  • Email 
  • Phone
  • Address 
  • City 
  • State 
  • Zip 
  • Country 
  • Quantity 
  • Unit Price 
  • Total Price 
  • Discounted
  • Refunded 
  • Net

Order location

This report is reporting on orders that are processed to the completed orders location.

Merchant CommentsThe merchant comments report the merchant comments logged for orders during the reporting period.
M&M Avg. Qty Per Order

The Mix-and-Match Average Quantity per order report provides a break down for sales related to each Mix-and-Match group.

The report provides the following column details for each M&M group:

  • Type
  • Order Count
  • Units Sold
  • Average

The rows to this section will be:

  • retail
  • non-retail
  • total

For more about Mix-And Match groups: Mix and Match Groups

New Customer Report

Here's a report that will give you a listing of "new" customers within a certain date range.  In addition to the customers name, It will also show the following order information:

  • Customer's Email Address
  • Order Count (that took place within your specified date range)
  • Order Id's of each order

A summary will also be shown at the bottom of the report (worksheet)

  • Total New Customers
  • Total Customers
  • % of New Customers
  • Total New Customer Orders
  • Total Orders
  • % of Orders From New customers
  • The date range you specified (reminder)
Order Comment ReportThis report provides the orderID and any associated merchant comment for the order.
Order Emails

This report provides the email address of all customers that opt-ed into the mailing list during the checkout (the checkbox field "Please contact me about updates and specials offers").

NOTE: Only the email address is returned in the report. You can perform a general order export that contains the Mailing List = Y or N column using the export orders tool.

Order IP Report

This report provides the IP address and creation date associated with each order.

  • Order ID 

  • IP Address 

  • Creation Date

Order Merchant Note Report

This report provides the orderID and the merchant comment along with the order total details:

  • Order ID
  • Subtotal
  • Shipping
  • Tax
  • Total
  • Merchant Notes ***

Merchant notes***

The merchant notes may contain import order details including:

  • Fraud rules triggered by the order
  • Note regarding the Auto Closing of Upsell After offers
  • Hand entered merchant notes regarding the order.
Pack Report

This report provides details regarding the packing fulfillment process, the following columns appear in the report:

  • User ID
  • Order Count
  • Item Count
  • Line Count
  • Item Cost
Packed By

This report provides a list of orderId's along with the user that processed the orders:

  • Order ID
  • User ID
  • Date
Pick Report

This report provides details regarding accrued packing fulfillment pick fees. You'll enter in the fulfillment service pick fees including:



The following columns appear in the generated report:

  • User ID
  • Order Count
  • Item Count
  • Line Count
  • Item Cost
Problem ItemsThe auto order problem item report shows auto orders that are failing to rebill due to an item configuration or inventory issue.
Projected Auto Order Sales

With this report you'll specify a date some point into the future. The generated report will show each auto order that is scheduled to run during the reporting period. The output contains multiple worksheets:

1st Worksheet: "Projected Auto Orders Sales"

  • Original Item ID
  • Rebill Item ID
  • Units (sold)
  • Total Sales (Gross $ amount)

2nd Worksheet: "Summary by Week and Month"

  • Original Item ID
  • Rebill Item ID
  • Units (sold)
  • Total Sales (Gross $ amount)

* = Partially completed time period.

3rd Worksheet: "Customers on Auto Order Report"

  • Order ID
  • First Name
  • Last Name
  • Email 
  • Next Shipment (Date: mm/dd/yyyy)
  • Next Attempt (Date: mm/dd/yyyy)
  • Next Item ID


Projected Sales with LTV Cap

The Projected Sales with LTV Cap report provides a breakdown of the long term value of your auto order items.

The spreadsheet will provide multiple worksheets:

  1. Overall - An overall summary in the first worksheet.

  2. Index - An index of of all the auto order items.

  3. Auto Order Item - A separate worksheet summarizing each auto order item

  4. By_Order_Id - A summary of the orders sorted by orderID.

  5. Item_Rebill_Value - Provides the rebill value for each item.

Refund Report

The refund report contains the following columns:

  • Order ID
  • Name
  • Email
  • Payment Date
  • Refund Date
  • Subtotal
  • Subtotal Refunded
  • Tax
  • Tax Refunded
  • Shipping
  • Shipping Refunded
  • Total
  • Total Refunded
  • Refund By User
  • Merchant Notes
Rotating Transaction Gateways

This report provides a snapshot view of the activity in each of the rotating gateways. The report provides the following columns (with the rows representing each rotating gateway):

Code (rotating gateway code)
Daily current (amount of sales so far)
Maximum (configured maximum amount for processing per month)
Resets

Monthly Current (amount of sales so far)
Maximum (configured maximum amount for processing per month)
Resets

Auto Order Daily Current (amount of sales so far)
Maximum (configured maximum amount for processing per month)
Resets

Trial Daily Current
Maximum

Trial Monthly Current
Maximum

(Month, Year) Chargebacks

Safety Stock ReportSafety stock is an industry standard term for the lowest amount of inventory that is safe to have on hand before reordering. UltraCart allows you to configured the desired and reorder inventory level for each item on a per distribution center basis. After configuring these two thresholds you can rely on UltraCart to tell you when to reorder product and how much.
Please see the help doc regarding Safety Stock Reporting
Sales By State/ZipThis report provides a breakdown of the sales for the reporting period by zip code. You'll provide a date range, and optionally can list specific item IDs for the report (otherwise all items sold would be listed in the report.)

The generated report contains the following columns: 
  • Item ID 
  • Zip 
  • Quantity
 
Sales Rep Report

If you've configured Sales Reps (See: Quickbooks terms and lists configuration page) then this report will provide details regarding orders attributed to the sales representative.

The generated report contains the following columns:

  • Rep.
  • Orders
  • Subtotal
  • Shipping
  • Tax
  • Total
Shipping Cost

This report provides the following details for the reporting period:

  • Shipping Method
  • Count
  • Total
Upsell Report

This is a comprehensive report details in the breakdown of the upsells triggered with a column for each day of the reporting period. The rows provide the following details for each days upsells:

Sales Info (section)

  • Total Product Revenue
  • Total Shipping Revenue
  • Total Tax Revenue
  • Total Revenue
  • Total Upsell Revenue

Order Info (section)

  • Total Orders
  • BEOE Orders
  • Auto Order Rebills
  • Orders Through Upsell Path
  • Orders With Upsells
  • Upsell Percentage
  • Avg. Revenue

Products Sold (section)
* = Includes Upsell Units

Upsell Products Sold (section)

Orders With Number of Upsells (section)

Number of Orders By Path (section)


User Searches

This report provides a list of the user searches, with the following columns:

  • Description
  • Search Count
  • Average Result Count

Note

This list shows you the searches that customers are performing on your website. If you see an interesting search that produced no search results, you may need to increase the content of your items so that customers can find what they are looking for.

Volume Discount Report

This report provides the following columns:

  •  Item ID 
  • Description 
  • Quantity 
  • Discount

Running a report

Once you've located the report you need, click the report name (link).  You'll be presented with a form to complete which defines data ranges and possibly some filters.  Most reports only require a few fields to be completed but some are a little more complex and require several.  The Current Period Sales reports requires none given that it will produce data that has occurred in the Current Period. 

The following is an example of the "Sales by Zip" Report form with the 3 fields completed.

The last step would be to click the run report button.  This particular report would become available almost immediately due to the short date range (3 months).