tl;dr
Flex Tables are Klar's most flexible analysis layer — use them when you want to break down data along your own dimensions rather than a pre-built view
They work like pivot tables: pick up to two dimensions, apply filters, and the table shows your metrics for every combination
The second dimension nests under the first — so you can answer questions like "which product performs best in which country?"
Three Flex Tables exist in Klar: Revenue & Profit, Marketing, and Influencer
Sorting, exporting (XLSX), and saving views are all supported
When to use a Flex Table
Standard reports give you a fixed view of your data. Flex Tables are for when you have a specific question that requires a custom breakdown — for example:
Which product SKU has the best CM2 margin?
Which country generates the most new customer revenue for a specific product?
Which marketing channel has the lowest CAC for new customers?
Which influencer drives the highest-LTV customers?
If the answer requires combining two dimensions, Flex Tables are the right tool.
The three Flex Tables
Revenue & Profit Flex Table — profitability metrics broken down by product, SKU, country, order type, customer segment, and more. Supports bundled/unbundled product views and per-order or per-item display.
Marketing Flex Table — UTM last-click performance data by channel, campaign, source, medium, and customer type. The right table for day-to-day channel and campaign analysis.
Influencer Flex Table — influencer performance broken down by creator, discount code, product, and customer type. Built on top of your Influencer Sheet or CRM data.
How dimensions work
Each Flex Table has two dimension slots. The first dimension defines the rows — every distinct value gets its own row. The second dimension nests underneath, splitting each first-dimension row into sub-rows.
Example: Set Dimension 1 to Product SKU and you see profitability metrics per product. Add Dimension 2 as Shipping Country and each product row expands to show its metrics broken down by country — so you can immediately see which product-country combination is your most profitable.
The columns (metrics) are pre-defined per Flex Table but remain consistent regardless of which dimensions you choose.
Filters
Use filters to narrow the data before the table calculates. You can filter on most available dimensions — product, channel, country, customer type, date range, and more.
Filters support AND logic (all conditions must be true) and OR logic (any condition can be true), so you can do things like "show me all products in Germany OR Austria" or "show me new customers who bought Product A AND used a discount code."
Display options
Most Flex Tables have additional display controls above the table. These vary per table:
Revenue & Profit Flex Table
Total / Per Order / Per Item — switch between aggregate totals or normalised per-order and per-item views
Bundled / Unbundled — show bundle products as-is, or split them into their component SKUs (requires Unbundling setup)
Marketing Flex Table
All Customers / New Customers / Returning Customers — scope the metrics to a specific customer type
Sorting, exporting, and saving views
Sorting — click any column header to sort by that metric ascending or descending.
Export XLSX — download the current table view as a spreadsheet for further analysis or reporting.
Views — save your current configuration (dimensions, filters, display options) as a named view so you can return to it without rebuilding it each time. Useful for recurring analyses you run weekly or monthly.