tl;dr
Analyse revenue and profitability across any dimension — think of it as a built-in Pivot Table
Pick one or two dimensions simultaneously to slice and dice your data (by product, channel, discount code, country, and more)
Use the Options menu to switch between Total / Per Order / Per Item views
Drill deeper into CLV and retention patterns using the reports in the Retention section
What can I analyse?
Unlike most Klar reports that surface insights proactively, the Revenue & Profit: Flex Table is built for answering specific questions you already have — like:
How much revenue did a certain voucher code generate?
What's the profitability of different products?
How is revenue developing in a specific geography over time?
It's built for flexible, fast analysis across any combination of dimensions.
Available Dimensions
Select one or two dimensions at the same time to cut the data exactly how you need it. Use the Product Filter at the top right to focus on a specific product subset.
The available dimensions are:
Time
Calendar Date
Calendar Week
Calendar Month
Channel
Channel Name — based on your configuration in the Channel Builder
Channel Group — based on your configuration in the Channel Builder
Channel Category — based on your configuration in the Channel Builder
UTM
UTM Source
UTM Medium
UTM Campaign
UTM Term
UTM Content
Product
Product Title
Product Title & Variant
Product Title (at Checkout)
Product Collection Title
Product Collection ID
Product Variant
Product Type
Product SKU
Product Tag
Product ID
Item Vendor
Variant ID
Order
Order Name
Order ID
Order Tags
Order Type
Order Count
Delivery Date
Fulfillment Location
Sales Channel Name
Financial Status
Payment Method
Payment Gateway
Has Discount
Discount Code
Discount Title
Customer
Customer Type — New vs. Repeat Customer
Customer Tags
Shipping Country
Shipping Type
Attribution / PPS
UTM Source / medium (combined)
PPS Answer
PPS Channel
PPS Question
Campaign
Campaign Phases
Funnel Stage
Options
The Options menu (top right) controls how values are displayed across the report:
Total — absolute values
Per Order — total divided by number of orders
Per Item — total divided by number of items
Options also includes:
Order Date / Return Date — switch whether data is grouped by the order date or the return date
Bundled / Unbundled — choose how bundled products are counted
Metrics
The report has two tabs: Revenue and Profitability.
Revenue tab
Gross Revenue = GMV - Discount Value - Voucher Value + Shipping Revenue
Net Revenue = Gross Revenue - Return Value - Taxes
Gross Orders = Count of Orders excl. Payment Status Voided
Net Orders = Count of Orders excl. Payment Status Voided & Returned
Gross Units = Count of Items excl. Payment Status Voided
Net Units = Count of Items excl. Payment Status Voided & Returned
NC = new customers in the selected period
RC = repeat customers in the selected period
% NC = NC / total orders
Unique Customers = count of distinct customers
Item Return Rate = Returns / Gross Units
Profitability tab
GMV = SUM (Compare At Price, Price)
Price Reductions = GMV - Price
Price Reduction % = Discount Value / GMV
Discount Code Value = Discounts
Discount Code % = Discount Code Value / (GMV - Price Reductions)
Shipping Revenue = Shipping Revenue
Gross Revenue = GMV - Price Reductions - Discount Code Value + Shipping Revenue
Returns = Gross Revenue of Returned Items
Return % = Returns Value / Gross Revenue
Taxes = Tax Value of Non-Returned Items
Tax % = Taxes / Net Revenue
Net Revenue = Gross Revenue - Return Value - Taxes
COGS = Based on Rules or Google Sheet
COGS % = COGS / Net Revenue
CM1 = Net Revenue - COGS
CM1 %= CM1 / Net Revenue
Logistics = based on your logistics cost rules
Logistic % = Logistics Costs / Net Revenue
Transactions = based on your transaction cost rules
Transaction % = Transactions / Net Revenue
CM2 = CM1 - Logistics Costs - Transaction Costs
CM2 % = CM2 / Net Revenue