360° Report

Introduction

360° report serves the purpose of having one report available to show data for all organizations that the user has access to, allowing to compare data across organizations and have a single view on the whole business. It consists of descriptive and predictive analytics and when used in conjunction with data used by Appxite partners, it can lead to decision making and higher revenue in the future.

360° Report shows data across all platforms available to a specific user, as long as they are permitted to see this report. Includes such measures as: revenue, cost orders, subscriptions, allowing users to analyze and compare data on all of their companies in a single report.

In this article:

Landing Page
Deep Dive
Growth & Loss
Recurring Revenue

NOTE! Report can be found under platform reports section, and will show data from all the platforms available to a specific user, regardless in which platform they are viewing the report in.
The user roles which have access to this report are Distributor Admin, Seller Admin and 360° Report Viewer roles.
For additional details and user permissions, refer to the following article: User Permissions and Roles: A Guide for Distributors, Sellers, and Customers.

Landing Page

When you open the report, the first thing you will notice that it leads to 2 pages:

Deep Dive - analyze and compare performance across multiple measures and dimensions. Forecast current trends, group data in a custom hierarchy and export it for further analysis.
Growth & Loss - quickly identify significant changes and their causes.
Recurring Revenue - analyze the trajectory of your business, see recurring revenue, projected future revenue, gross profit, and identify emerging patters.

Select one based on the preferences:

Deep Dive

Deep Dive page is all-in-one resource where you can see data for all or some measures (eg. revenue, cost, orders, subscriptions) grouped by different entities. The advantage of the report is that you can see the data for all organizations you have access to, so in case you have multiple distributors or resellers trading in Appxite you can see all of their analytics from one URL.

It consists of the following sections:

Time Periods
Filters Section
Currency Selection
Invoice Status Selection
Selected Measures
Compare/Forecast Choice
Diagram
Selected Groups and Orders
'How to Use' Section

For description of each section, refer to the paragraphs below:

Time Periods

Here you choose the time period you are interested to get the data from, either the entire year(s) or fraction of the year.

Filters Section

Narrow down your results by specifying the following filters:

Parent Org (sells to Persp. Org) - all organizations that you buy from. Either vendors, distributors or sellers.
Perspective Org - all organizations you have access to under Distributor or Seller Admin roles.
Perspective Org Role - Perspective Org can have multiple roles which can be analyzed individually or filtered using Perspective Org Role groups.
Child Org (buys from Persp. Org) - all organizations that you sell to. Either sellers or end customers.
Child Org Country - country or multiple countries of organizations that you sell to.
End Customer (Current) - end customer or multiple end customer organization(s).
Vendor / Product / Offer - vendor(s) / product(s) / offer(s) of your choice.

Currency Selection

Here you have a choice to see the figures in either USD or EURO or any other currency set up in the platform.

Invoice Status Selection

Here you have a choice to see the figures coming from invoices in status either verified or new or both.

Selected Measures

The following measure are available to include in the report: Revenue, Cost, Gross Profit, Orders, Subscriptions and Seats. Revenue, Cost, Gross Profit data is taken from invoices; orders, subscriptions and seats from orders and subscriptions respectively. There are various ways in how the measure values can be displayed in the report.

Measure name (e.g. Cost) = Value of the selected measure in the selected period.
PP = Value of the measure from the previous period.
PoP/Pop % = Period on Period / Period on Period %. Shows either Month-on-Month changes or Year-on-Year changes depending if years or months are currently filtered.
MA = Moving Average e.g., MA12 = Moving Average, 12 months. Note - works best when there are no month-to-month interruptions in data.

NOTE! You can have selected multiple measures at once and based on your selection, the data in the diagrams and tabular form will get auto populated on the screen.

NOTE 2! By selecting any point of time or multiple points of time or any other singular or multiplied data in one place of the report, all diagrams and tables presented will get cross-filtered based on your selection. It is very convenient way to work with large data sets when needed to narrow down your results.

Compare/Forecast Choice

Switch between "Compare (multiple)" and "Forecast (single)" to show forecast.

NOTE! Only 1 measure can be shown at a time under Forecast.

Diagram

This diagram is not static and will change to show revenue, cost or whatever else is the first measure selected and also is based on the filters and time periods, such as vendor or particular offer(s). It is purpose is to show comparison across multiple years for the same month.

Selected Groups and Orders

Use "Select Groups & Order" to select which data to group the table by. Selecting multiple values creates hierarchy in the order of selection.

Use "Drill on: Rows" to navigate in the next level in group hierarchy. Use "Drill on: Columns" to navigate to the next level in Date hierarchy (from Year to Year-month).

'How to Use' Section

This section consists of most relevant information in regard how to use the report so can be used as the reference by any users without need to access the external knowledge.

Growth & Loss

This page has some similar sections as Deep Dive but it serves different purpose. It is used to display beside each other two groups based on the selected measures to help business leaders to see and make decisions regarding profits and selling portfolios.

This page consists of the following sections:

Filters Section- same functionality as already described
Currency Selection- same functionality as already described
Invoice Status Selection - same functionality as already described
Measure/Year/Month
Measure by Date Diagram
Selected Groups #1 and #2
Actual Value, Highest Growth and Highest Loss Visuals
'How to Use' Section - same functionality as already described

For description of each section not described, refer to the paragraphs below:

Measure/Year/Month

Select the perspective month and use 'Select Measure' to choose which calculation to show.
The month you have chosen here will be selected as the month against all the growth and loss will be calculated when comparing with the previous calendar month. Eg. If you selected March 2024, it will be chosen as the base month and growth and loss will be calculated vs February 2024.

NOTE! If you select the current month, the data may be incomplete.

Measure by Date Diagram

Based on your filter selection it shows the measure for specific time period and other criteria's, such as offer or vendor selection.

NOTE! Same principles apply as before, selecting any data within any of the diagrams cross-filters specific data as per the desired outcome.

Selected Groups #1 and #2

Use 'Select Group #1' and 'Select Group #2' to select which data to group the table by. Group #1 changes top visual and Group #2 changes bottom visual

Actual Value, Highest Growth and Highest Loss Visuals

The first diagram on the left is used to visual the actual value within the base month.
The purpose of last two, as names indicates, are used to visualizing patterns when comparing between two groups based on the selected base month against the previous one. You can click on specific loss or growth lines to cross-filter the other visual for more insights.

Recurring Revenue

Recurring Revenue Report is used to track recurring revenue of your business. You can view the current and past trends of recurring revenue to understand the general direction of the business, and get insights about projected future revenue. The report also includes gross profit shown as projected and historical values. It enables account managers and business leaders to make timely decisions about business direction and set KPI's for performance.

It consists of the following sections:

Filters Section
Currency Selection - same functionality as already described
Invoice Status Selection - same functionality as already described
Churned / Gained stats
ARR and 12M RT Revenue - Actual & Projection
ARR Change by Customer
ARR Customer Summary
Actual: Projected by Year
Time Periods - same functionality as already described
Aggregated Annual Totals
Revenue, Projected Revenue
Gross Profit
'How to Use' Section - same functionality as already described

For description of each section not described, refer to the paragraphs below:

Filters Section

Same functionality as already described with the addition of two filters:

License / Usage Based - choose to show projections for either recurring License Based and/or Usage Based subscriptions.
Projected Monthly Usage Increase - adjust the expected monthly increase for Usage Based subscriptions by changing the Custom Rate slider.

Churned / Gained Stats

These stats are designed to compare on customers which were gained and lost and revenue associated with these:

Churned / New Customers (YTD) - customers lost or gained since the start of the year within the current filter context, as follows:

- Churned - customer which had subscriptions in January and have no subscriptions now
- New - customers which had no subscriptions in January and have subscriptions now.

NOTE! In the selected context, for example, when only usage-based subscriptions are shown, a churned customer is a customer who initially had a usage-based subscription but they no longer do. However, they may still have license-based subscriptions.

2. ARR Lost (to Churned) / Gained (from New) (YTD) - expected revenue lost or gained due to churned or new customers (since the start of the year) for the upcoming 12 months.

3. ARR change (total) (YTD) - expected revenue change for the upcoming 12 months.

ARR and 12M RT Revenue - Actual & Projection

This diagram illustrates what was and is the projected revenue along with the actual revenue for the past months as follows:

ARR - Annual Recurring Revenue - expected revenue for the upcoming 12 months. Projection is based on today's prices, auto-renew status and revenue from previous month's usage based subscriptions.
Actual Revenue, RT12 - actual Rolling Total revenue over the previous 12 months.
Projected + Actual Revenue, RT12 - sum of projected and actual Rolling Total revenue over the previous 12 months.
Actual Gross Profit, RT12 - total gross profit over the previous 12 months.
Projected + Actual Gross Profit, RT 12 - sum of projected and actual Rolling Total gross profit over the previous 12 months.

ARR Change by Customer

This list displays ARR data broken down by individual customers and calculates the total year-over-year change in ARR.

ARR Customer Summary

This tab provides a consolidated overview of the data presented in the “ARR Change by Customer” tab.

Actual: Projected by Year

This table presents a summarized comparison of projected revenue and gross profit on a yearly basis, including year-over-year changes and corresponding percentage variations.

Aggregated Annual Totals

The totals use the data from the diagram 'ARR and 12M RT Revenue - Actual & Projection' and present these in aggregated manners as actual revenue or projected revenue or the sum of both (depending on chosen date) and Growth totals and Growths difference when comparing one year to the previous one.

Revenue, Projected Revenue

This diagram shows the actual and projected revenue for the past / incoming months divided based on usage or license based subscriptions (divided further on monthly and yearly billing cycles).

Gross Profit, Projected Gross Profit

This diagram illustrates the actual and projected gross profit for both past and upcoming months, following the same logic used for Actual and Projected Revenue shown above.

Limitations

360° Report is based on aggregated totals and the data from Appxite platform is synced to the Reporting database overnight therefore there might be 24h latency in regard to getting most up-to-date information. Additionally, there might some delays in getting the particular sections of the reports refreshed since the amount of data to process is high. In case you encounter any further issues with data you are seeing or with navigating through out different sections of this report, please submit the ticket with Appxite Support Team for the assistance.

Summary

The article guides Seller and Distributor Admins through the process of accessing, navigating, and using 360° Report.
This report shows data across all platforms in one place and is used to facilitate business operations decisions based on the data stored in Appxite Reporting database. This data can be visualized directly in the report, exported in many different formats or used in connection with any external applications your system is currently built on.

Make sure to check our knowledge articles on Platform and Reporting APIs if you are interested in getting the data shown in the report programmatically.

360° Report

Landing Page