Posts

Sales Dashboard

Sales Dashboard

The Sales Dashboard in PaySketch lets you easily manage and track PayPal sales. All sales made through your PayPal account will be automatically pulled into PaySketch after you have connected PaySketch with your PayPal account using the PayPal API Signature. All sale transactions will be listed in a grid, along with details showing up on the right. A trend chart and highlights about the sales provide precise indicators to the past and current health of sales, which will help you foresee and forecast your future sales.

To navigate to the Sales Dashboard, select Sales from the Dashboard dropdown menu. This is how it looks:-

Sales Dashboard

Sales Dashboard Sections

The Sales Dashboard has the following sections:-

Header

The Header section in the sales dashboard gives you quick insight into sales through PayPal. It shows the current account balance, the most recent sale amount, total sales in the month and total sales overall since when the PaySketch has been configured to pull data from PayPal.

Sales Dashboard Header

Notifications

The notifications area in the Sales dashboard contains a message/ warning/ error area, a Send Money button, an internet connectivity indicator and background activity cum process indicator.

Sales Dashboard Notifications

Filters

The filters section is similar to the one in the Transactions Dashboard. Users can filter and search all sales through PayPal using the transaction status, date range and real-time search box filters. Filtered results automatically appear in the data section.

Sales Dashboard Filters

Data

The Data section of Sales Dashboard can be divided into 4 primary components:-

  1. Trend Chart
  2. Highlights
  3. Sales Transactions
  4. Transaction Details

Trend Chart

The trend chart in the dashboard shows Sales trends over a period of time. By default, when the dashboard loads all the data, the sales trend is segmented by Months. Trends help analyze PayPal sales performance, peaks and lows, market penetration, and the overall value that the business bring in a period of time. The data in the trend chart is directly linked to all search criterias – so you can see live changing trends as you search for sales transactions on PaySketch.

Trends can be dynamically configured by simply clicking on the time slots by which the trends need to be groups. Sales trends can be groups by Days, Weeks, Months and Years.

Highlights

Highlights is high-level numeric spotlight focused on bringing you the most important sales indicators. Highlights show sales, average revenue per sale, refunds and statues of all transactions by means of a pie chart. Highlights are dynamic and sensitive to search – so which you search for transactions between a particular date, you can see the highlights respond to search. For example, you can figure out the total sales, refunds and status distribution of your online sales between 2 dates. Or you could simply search for transactions for a set of particular customers by typing in their names and view the revenue  contribution and refund requests from them.

One can also download the trend chart with the highlights by simply clicking on the download button shown right below the sales trend.

Sales Dashboard Trend Chart

Sales Transactions

The Sales transactions show up in a grid, reverse sorted by the date of purchase. The grid also reflect changes to the data and is automatically refreshed as newer sales happen and the dashboard revisited. Filtering data through real time search or by inbuilt transaction status and date range filers also show their results in this section of the sales dashboard. The data presented is paginated and this configuration can be changed or disabled from the Settings Dashboard.

Details

Details for each sale will show up right next to the transactions grid, one sale at a time. The data in this section gets changed as one browses through different sales transactions as shown in the grid. Details have 3 fixed and a variable components which are shown depending on the type of transaction whose details have been requested for.

The fixed components are:-

  • Details
    • Buyer’s name
    • Buyer’s email address
    • Transaction time
    • Transaction ID
    • Transaction Status
    • Transaction Type
    • Amount
    • Transaction Fee
    • Net Amount
  • Order Details – shows the details of the product purchased – name, quantity, amount, tax and total.
  • Transaction Details – shows further details about the transaction such as multiple statuses and charges.

The variable component is:-

  • Related Transactions – shows up in case the transaction in question has other transactions related to it. This happens in case of refunds, reversals, chargebacks etc.

Footer

The footer section of the sales dashboard reflects indicators for all sales transactions that show up in the sales grid. The footer contains information such as:-

  1. Total Sales – which are listed in the grid. This helps in case you have broad search parameter and would like to know the number of sales made.
  2. Sales – Amount of gross sales made.
  3. Net Credit – reflects the net sales.
  4. Fees – shows the total fees charged via PayPal for processing the sales orders.

Sales Dashboard Footer

Use cases

Using the Sales Dashboard in PaySketch, you can:-

  • Export PayPal sales, all or a part of it.
  • Generate profit report for sales through PayPal
  • Generate Monthly PayPal sales report
  • Track total sales through PayPal
  • Download PayPal sales report in CSV instantly, without waiting
  • Do a lot of slicing and dicing with the data to analyze PayPal sales

Summary Dashboard

Summary Dashboard

The Summary Dashboard is imminently visible as you open PaySketch. It is what we refer to as the ‘landing page’ of the product. The primary focus of the Summary Dashboard is to give you a complete insight into your PayPal account really quickly. This helps you keep track of milestones and provides a great health indicator of your online sales through PayPal.

This is how the Summary Dashboard looks like

PaySketch Summary Dashboard

The Summary Dashboard is segmented sections, each of represents a business vertical:-

  1. Sales
  2. Fee/Debits
  3. Payments
  4. Customers
  5. Products
  6. Geographic Insights

Sales

The Sales section is focused on PayPal Sales. To help you make quick decisions it includes a lot of actionable performance indicators such as :-

  1. Total Sales – Shows the total amount of sales that has been generated through your PayPal account from the time since when the PayPal account has been configured to connect to PaySketch till the last synchronization. By default, the amount shows up sales that has taken place in your account’s primary currency.
  2. Cleared Sales – Shows the total amount of sale transactions that are in completed or cleared state. This amount excludes all figures that account for pending, failed, canceled or reversed transactions.
  3. Subscriptions – This figure shows the net contribution of subscription based products/services to your business.
  4. Net Sales – Show the amount that remains after all PayPal transaction charges and service fees. This helps you figure out the total amount of actual revenue that you have made via online sales through PayPal, after paying all transaction fees.
  5. Pending – Many a times, you would receive payments via electronic checks or have payments are put on hold. This KPI accounts for all such sales which are still pending.

All statistics exclude Failed and Canceled payments. All the Sales indicators help you retrospect and forecast your online sales. They also provide you with valuable data such as the net earnings and the total fee.

Fees/Debit

The Fees/Debit section of the Dashboard is come right next and is focused on all the fees and charges around your PayPal Sales. This section includes:-

  1. Fees – Shows the total amount of fees that has been charged by PayPal for processing your online sales payments from across the world. This figure includes all transaction fixed and variable fees charged for processing each sales transaction.
  2. Refunds – Shows the amount and the number of refunds that have been processed through your PayPal account corresponding to the online sales through PayPal.
  3. Reversed – This KPI shows total number and amount of sales that have been reversed from your PayPal account.
  4. Chargebacks – Shows the amount and the number of chargebacks that were charged to your PayPal account for online sales.
  5. Failed – Stats around Failed or Canceled payments find place in this indicator.

Chargebacks and Refunds are good indicators of how well your products are being received (and perceived) by customers. A high number of chargebacks and refunds are red signals and demand immediate attention.

Payments

The Payments section of the Summary Dashboard shows all statistics around payments that have been made from your PayPal account.

  1. Payments – Shows the total amount of payments that have gone out from your PayPal account.
  2. Recent – Shows the last payment amount.
  3. Subscriptions – Shows the total amount of payments made for subscriptions/pre-approved payments.
  4. Refunded - Shows the total amount that has been refunded back to your account for payments that you had made.
  5. Withdraws - This indicator shows the total number and amount of bank withdraws that have been made from your PayPal account.

Customers

This section of the Summary Dashboard relays important information about Customers. It is crucial to understand how customers look at your products, how well they find them, when are the most likely to order and at what frequencies are you connecting with your customers. There are 5 important pieces of useful customer highlights that one can count upon while taking a bird’s eye view of all customers across the board.

  1. Customers – Customer count is shown for this part of the indicator. It is the total number of unique customers who have contributed towards the total sales.
  2. Repeat – Customer loyalty and retention are one of the key factors to market success. Customer Loyalty can be judged by looking at this parameter. The more returning customers you have in proportion to total customers, the more your products are loved.
  3. LTV (Life time value) - Show how much each customer, on an average has contributed towards to total sales of all products
  4. Pear Order Time – Show the peak time when most of the orders (by number) are processed. This indicator helps you realize the most important times when your online product sales – through website, email or invoicing should never have any order related issues. The peak time is when you can expect most of your customers purchasing and hence should be the most error free, without glitches website or business uptime.
  5. Order Frequency – The number of days, hours, minutes and seconds between each order is what this indicator shows. A large order frequency means that the average time interval between any 2 orders is high.

Hover over any of the indicators to gain more insight, like the one shown belowPeak order time

Products

The Products section immediately follows the Sales section. Products are what you sell online to make a successful business and valuable data around your products help you measure, gauge and act upon their market performance. While designing PaySketch, we looked at the best key performance indicators for product which can deliver simple yet impacting analytics so that you can take your product sales to the next level. The Products section comprises of 2 fragments:-

Highlights

Highlights gain quick attention and lets you easily figure out just the right data you need to know about your products market performance:-

  1. Products - Shows the total number of unique products that have ever been sold online through your PayPal account since when you had configured PaySketch to connect and bring in PayPal data from your account.
  2. Products Sold – Shows the total number of product sales.
  3. Highest Selling Product – A bright indicator which quickly tells you the best selling of all the products in your portfolio. Remember, this is best selling when we account for the number of times it has been sold and not be its revenue contribution. Hovering over the best selling product, you will know the exact number of times it has been sold and the total revenue that it has contributed to your online sales.Highest selling product
  4. Least Selling Product – This indicator comes in handy to know which one of the products is the least selling of all. It may not be the least contributing, but in numbers all other products have sold equally or more than the one that gets listed. It should be fine if the product is a newly introduced one, otherwise, poor marketing, visibility or falling market demand could be possible reasons.
  5. Most Refunded Product – The product listed under this domain is the one that has been refunded the most. It may be because customers often find issues with this product or it could very well be one of the highest selling products and proportionally has a refund rate. If its not, then this indicator warns for the same and customer feedback could help improve the same.

Performance by Revenue

Product performance can also be measured by the revenue contribution of the products. On the Summary Dashboard, the top 5 contributors and the 5 least contributing products to the overall sales revenue are listed with their share of the same. There are 2 sections for both topline and bottomline products:-

  1. Grid – shows the top 5 / least 5 performers, their revenue contribution and the quantities sold
  2. Chart – the charts of each type organizes the slice of each contributor with respect to its segment i.e. each chart slice of top 5 performers depicts their individual performance when results are isolated to the 5 participant products. Hovering over the slices will show further information like the percentage contribution of the product towards the Total Sales.Product performance

Geographic Insights

The Geographic Insights section focuses on mapping sales to different parts of the world and showing performance indicators such as:-

  1. Countries – Total number of countries to which you have sold products/services to.
  2. Max Customers - This indicator points out the country from which you have the maximum number of customers.
  3. Min Customers - Lists the country from which there have been the least count of customers.
  4. Max Sales – Shows the country from which there have been the maximum amount of sales (in the selected currency).
  5. Min Sales - Lists the country from which your business has received the least sales for the selected currency and timeframe.