Reporting
  • 05 Sep 2022
  • 8 Minutes to read
  • Dark
    Light
  • PDF

Reporting

  • Dark
    Light
  • PDF

Article Summary

There is a number of default reports on various parameters available for you. But you can also request custom reports to be created by ShopCtrl.
Most reports have a unique authorization item and access to these reports could be granted only to a certain employee role.
You can download the report as pdf, Excel, or csv file. Or email it directly from the report window.

You can also set up a scheduled task of sending auto-generated reports via email at a certain time interval with the Mail Scheduler service.

Sales

Sales overview report

Sales overview report provides an overview of overall and monthly sales per shop and year specified in a shop owner base currency. Report displays the overall year to date and month to date sales.
You can see a total number of orders and sales per month. And average sales per day in a month.
The report is visualized with two column charts, which display the dynamics of total sales per month and year(s) and total count of sales per month and year(s).

Report parameters:

  • Shops
  • Years
  • Order type

sales-overview-report

Invoice stats overview report

Report provides a recap of the total invoices issued per month and per year, calculates the overall invoiced year to date and month to date amounts.
Totals also give an idea of the pending invoices amounts.

Two charts display the dynamics of total invoiced orders amount per month and year(s) and total count of invoices per month and year(s).

Report parameters:

  • Shops
  • Years

invoice-stats-overview-report-1

Product overview report

This report shows top 10 most sold products and top 10 products with highest turnover per year.

Report parameters:

  • Shop
  • Years

product-overview-report

Sold products per day report

A list of products sold per selected shop(s) within defined timeframe.
By default, the period is set to 1 day. Changing a timeframe to a bigger period might take a significant amount of time to load data.

sold-products-per-day-report

Affiliate orders report

The report displays/calculates total summary in base currency of the orders brought to you by different affiliates.

Report parameters:

  • Shops
  • Affiliates
  • Date Range

affiliate-orders-report(2)

Transport costs

The report groups shipped orders by a transport category and summarizes transport costs per carrier.
Report parameters:

  • Date Range
  • Shop

transport-costs-report-1

Cancelled orders

The report tracks all cancelled orders for a given shop(s) and period and displays total sum in base currency.
The report will also give an overview of the factors that led to a lost sale.
The resulting Ratios table shows each cancelation reason and its accompanying percentage.

To create this type of report, create cancel reasons on Configuration-> Statuses > Order cancel reasons page. Add a required step for employees to provide cancel reason when canceling orders on Shop Details page > Order Management tab by enabling Requires a reason on cancelation flag.

Report parameters:

  • Shop
  • Period

cancelled-orders-report

Order credit overview

Order credit overview report prints out a list of credited orders for a given shop(s) and period. Provided that the credit reasons are used while creating returns/refunds, the reasons are also displayed.
How to configure return and credit reasons
Report parameters:

  • Shop
  • Period

order-credit-overview-report

Service Level Reporting

Service level

Service level agreement performance data for the selected shops grouped by employees. This report includes the data about the volume of phone calls, email handling time and number of SLA hours it took to achieve the first time answer.
The summary service level % column gives information about the percent of inquires handled by an employee within SLA hours.

The SLA response time is configured on a shop level. Please check Service Level for more information.

Report parameters:

  • Shop (selection of shops in sales channel pane)
  • Date range

service-level-report

service-level-report-1(1)

Ticket statistics

Report consists of 13 charts on ticket statistics.

ChartDescription
Open ticketsTotal open tickets chart in the specified date range for the selected shop(s)
Expired ticketsTotal expired tickets chart in the specified date range for the selected shop(s)
Closed ticketsTotal closed tickets chart in the specified date range for the selected shop(s)
Follow-up ticketsTotal tickets marked as follow-up per day in the specified date range for the selected shop(s)
Unassigned ticketsTotal count of unassigned tickets per day for the selected shop(s)
Avg ticket open minutesAverage time in minutes tickets spent in open state per category
Avg ticket open minutes by groupAverage time in minutes tickets spent in open state per employee group
Avg first response timeAverage time in minutes till first response grouped by category
VoIP callsNumber of VoIP calls per day in a period
Avg call durationAverage calls duration per day in period
MailsTotal emails exchanged per day in period
Chat conversationsTotal chat conversations per day in period
Chat messagesTotal chat messages per day in period
Contact momentsContact time distribution

ticket-statistics-report-1

Actual support statisticsActual support statistics provide a snapshot of the day with the current support progress. Report accumulates tickets data and chat and VoIP calls requests initiated by both employees and customers. The chart shows the increase in open tickets for the current day.

actual-support-statistics-report

Communication per Order

A list of orders of a certain shop within the selected timeframe with minimum communication count higher than the specified minimum amount.
The most frequently occurring communication counts per order are visualized with the Order communication distribution chart.

Report parameters:

  • Shop
  • Date range
  • Min. Amount - minimum amount of total communication count per order

communications-per-order

Event category report

Report groups communication events like emails and VoIP calls per mail category over all shops selected.

Report parameters:

  • Shop
  • Date range

event-category-report

Event overview report

Report groups communication events like emails and VoIP calls per shop and per category over a chosen period.

Report parameters:

  • Shop
  • Date range

event-overview-report

Events distribution report

Event distribution report contains an area chart displaying events distribution per shop over a year period. The most busy months are highlighted in green.

events-distribution-report

Event forecast report

Event Forecast Report contains a line chart with the total number of events over a year period grouped by shop and month.

event-forecast-report

Events per order report

Report contains the summary of all events, like VoIP calls and emails and calculates the average events per order ratio.

events-per-order-report

Events per sync source

Events per synchronization source report gives an overview of the events that came through synchronization channels.

events-per-syncsource-report

Shop event time

The Shop event time report calculates for a shop(s) average duration of VoIP calls and time spent on mail creation for a specified period.
Report parameters:

  • Shop
  • Date range

shop-event-time-report

Employee performance and activities

Activity journal report

Report summarizes hours spent on different activities by employees for a given period. Activities are registered and tracked on the General > Activities tab.
You can specify either date range or period, level of detail, and a category for which you would like to get a detailed report.

Report parameters:

  • Shop
  • Date range or period
  • Level of detail
  • Category

activity-journal-report

Employee performance report

Employee performance report provides data about total handled phone calls and emails grouped by employee and shop(s).

Report parameters:

  • Shop
  • Date Range
  • Detail (default 3)

employee-performance-report

Employee productivity report

Employee productivity report displays the most detailed overview of the communication happening via email per employee. Report is grouped by employee and provides details of the emails sent and connected tickets closed.

The list of the emails exchanged is provided with a number of sub-reports. To open either of sub-reports, click the corresponding email count in the report:

  • Forwarded Mail
  • Handled Mail
  • New Mail
  • Reply Mail
  • Tickets Closed Detail
  • Total Mail Sent

employee-productivity-report

Sub-report: New emails sent by employee.
employee-productivity-sub-report

Employee overview report

This report displays a recap of events handled by employees with detailed data about phone calls duration and email handling time. It also summarizes the number of closed tickets per employee.
Report data is grouped by employee group. If an employee belongs to several groups, their data is added to each group's total.

Report parameters:

  • Employee group
  • Date Range

employee-overview-report

Employee event time

Employee event time report gives statistics about the total number of events (VoIp calls and emails) handled by employees within the selected timeframe. It also calculates the average time spent handling emails and answering calls.

Report parameters:

  • Employee group
  • Date Range

employee-event-time-report

Reports on communication statistics

Phone - VoIP

Phone calls specification

Detailed report of received and answered calls. Includes in-depth call details, like call duration and destination phone numbers.
Report parameters:

  • Shop
  • Date Range Or Period

phone-calls-specification-report

Phone statistics

Queue statistics daily report.
Provides data about the % of unanswered calls with two graphs visualizing the ratio of lost calls.
By default period is set to the current month.

Report parameters:

  • Shop
  • Date Range Or Period

phone-statistics-report

Phone wait times

Report compares wait time of answered phone calls against predefined normal response time.

Report parameters:

  • Shop
  • Normal response time defined in seconds
  • Date Range

phone-waittimes-report

Reports on Wiki item usage

Wiki item usage

Report gives statistics about the 5 most and 5 least used wiki articles. By default, the current month period is pre-selected.

Report parameters:

  • Time period

wiki-item-usage-report

Reports on inventory, purchasing, and communication with suppliers

Gemiddelde levertijd per leverancier - Average delivery time per supplier

Average delivery time per supplier provides statistics for the last 4 deliveries fulfilled by the supplier.

Gemiddelde-levertijd-per-leverancier-report

Purchase order detail report

The Purchase order detail report provides an opportunity to easily get an overview of a certain purchase order. Including all the details about the provisioned quantities, and yet to be received products.

Report parameters:

  • Purchase order ID

Please note, that report searches not by purchase order code, but by ID. The last could be retrieved by API, or from purchase order grid ID column in UI.

purchase-order-detail-report

Supplier mail statistics

Provides information about the average response time to supplier emails. It also queries in-depth details of mails received and tickets assigned in a separate sub-report.
Report parameters:

  • Date range
  • Shop

supplier-mail-statistics-report

supplier-mail-statistics-sub-report

Product stock expiration report

The Product stock expiration report is a part of the Adwanced warehouse functionality. Products are grouped based on the time left before expiry.

Product_stock_Expiration_report(1)

Configuration reports

Authorization report

The report gives an overview of the existing roles and permissions. The list contains all the fine grained permissions granted to the role.
Please check Understanding Employee Roles and Permissions for more information.

authorization-report


What's Next