Report Studio datasets, metrics and templates

Report Studio has curated datasets with named metrics and dimensions so you pick business words, not column names.

বাংলায়: রিপোর্ট স্টুডিওর Data পিকার থেকে প্রি-বিল্ট ডেটাসেট বেছে নিন। প্রতিটিতে বেশ কয়েকটি মেট্রিক এবং ডাইমেনশন আছে। Templates বাটন থেকে ৩২টি রেডিমেড টেমপ্লেট খুঁজে নিন যা বিভিন্ন ক্যাটেগরিতে সাজানো।

Where to find it: Sidebar › Reports › Report Studio › Data picker (in the builder panel on the right) and Templates button (at the top)

Curated datasets

Sales & profit

One row per non-cancelled order.

Metrics: Orders, Booked sales, Realised revenue, Gross profit, Cost of goods, Courier fees, Return fees, Units, Average order value, Gross margin, Delivery rate, Customers.

Dimensions: Day, Week, Month, Hour of day, Day of week, Status, Source, Courier, Payment method, City.

Orders

Every order, cancelled included.

Metrics: Orders, Total sales, Average order value, Discounts, Shipping charged, Cash collected, Advance payments, Courier charges, Cancelled orders, Delivered orders, Returned orders, Return rate, Cancellation rate, Customers.

Dimensions: Day, Week, Month, Hour of day, Day of week, Status, Source, Marketing channel, Courier, Courier status, Payment method, City, Customer, Order type, UTM source, UTM campaign.

Product sales

One row per product line, cancelled orders excluded.

Metrics: Units sold, Product sales, Orders, Gross profit, Gross margin, Average selling price, Units on returned orders.

Dimensions: Product, Variant, SKU, Day, Week, Month, Hour of day, Day of week, Order status, City, Source, Courier.

Ad spend

Daily Meta spending.

Metrics: Ad cost (with tax), Spend (before tax), Spend (account currency), Campaigns, Days with spend.

Dimensions: Day, Week, Month, Campaign, Ad set, Platform.

Expenses

Metrics: Expenses, Entries. Cancelled expenses excluded.

Dimensions: Day, Week, Month, Category, Vendor.

Customers

Metrics: Customers, Average courier success, Courier orders on record.

Dimensions: Day, Week, Month, City, Customer.

Returns

Metrics: Returns, Received back.

Dimensions: Day, Week, Month, Reason, Courier, Status.

Inventory

Stock right now; ignores date range.

Metrics: Products, Available, In stock, Reserved, Damaged, Stock value at cost, Stock value at price, Out of stock.

Dimensions: Product, SKU, Status, Vendor, Product type.

Store visits

Storefront activity.

Metrics: Sessions, Visitors, Page views, Product views, Added to cart, Checkouts started.

Dimensions: Day, Week, Month, Page, UTM source, Device, Event.

All data

Raw tables (Order items, Order profit, Status changes, Order activity, Returned items, Refunds, Parcels, Payment links, Payment attempts, Variant options, Categories, Collections, Collection products, Reviews, Locations, Stock by location, Stock movements, Meta campaigns, Meta ad sets, Meta ads, Recurring expenses, Store orders).

Ready-made templates (32 total)

Press Templates at the top.

Sales (8)

Sales over time, Sales by source, Sales by city, Sales by payment method, Average order value over time, Orders by hour of day, Orders by status, Discounts over time.

Profit (4)

Net profit over time (SQL), Gross margin over time, Costs over time, Expenses by category.

Products (4)

Sales by product, Product margins, Sales by variant, Products on returned orders.

Inventory (2)

Stock value by product, Low stock.

Fulfilment (3)

Delivery rate by courier, Return rate by city, Return reasons.

Marketing (4)

Ad spend and ROAS over time (SQL), Ad spend by campaign, Campaign ROAS (SQL), Sales by UTM campaign.

Customers (5)

Best customers (SQL), New vs returning customers (SQL), New customer records over time, Customers by city.

Website (2)

Store sessions over time, Top pages.

Metric definitions

Orders: count of non-cancelled orders.

Booked sales: sum of order totals when placed.

Realised revenue: cash on Delivered orders.

Total sales: sum of all order totals.

Average order value: sales ÷ orders.

Discounts: sum of discount amounts.

Units: quantities on delivered orders.

Gross profit: revenue − cost − courier fees − return fees.

Gross margin: gross profit ÷ revenue.

Cost of goods: quantity × cost price.

Courier fees: courier fee on delivered orders.

Return fees: courier fee on returned parcels.

Expenses: sum of non-cancelled expenses.

Net profit: gross profit − ad cost − expenses.

Delivery rate: delivered ÷ settled.

Delivered: count in Delivered.

Returned: count in Returned or Return Pending.

Return rate: returned ÷ settled.

Ad cost: sum of daily spend with tax.

Customers: count of distinct customers.

Stock value: available × cost price.

Available: stock − reserved.

In stock: stock quantity.

Reserved: units reserved for orders.

Sessions: distinct visitor sessions.

Visitors: unique visitors.

Page views: pages viewed.

Dimension definitions

Time: Day, Week, Month, Hour of day (0–23), Day of week (Saturday=0, Friday=6).

Date columns: grouped by business zone (default Asia/Dhaka).

Order: Status, Source, Courier, Payment method, City, Customer, Order type, UTM source, UTM campaign.

Product: Product name, Variant, SKU, Product type, Vendor.

Category: Expense category, Return reason.

Other: Campaign, Ad set, Platform, Page, Device, Event.

Other ways people ask this

• report studio datasets মানে কি
• what metrics can i use
• sales dataset এ মেট্রিক
• কোন টেমপ্লেট দিয়ে লাভ রিপোর্ট বানাব
• gross margin কিভাবে গণনা হয়
• inventory ডেটাসেট
• customer metrics কি কি আছে
• report templates list
• ad spend metric কিভাবে কাজ করে
• dimensions কি

Related pages

• Report Studio — how to build and save reports
• Ask Kyo or write SQL — using code to write reports

Checked against the product on 2026-10-02.