Profit Table

The Bloom Profit Table breaks down your Shopify store's revenue, costs, marketing spend, contribution margins, and net profit for any date range.

What is a Profit Table?

The Profit Table in Bloom Analytics provides a complete breakdown of profitability, from Gross Merchandise Value (GMV) to Net Profit, for any selected period. It is built for ecommerce merchants who need to see exactly where money is made or lost, with each major revenue and cost component laid out in a clear, structured format. You can filter results by date range and group them by day, week, or month, so it supports both high-level trend analysis and granular performance review.

How it Works

Reading the Table

Each column represents a time period based on the selected grouping, ending with a Total column that sums the entire date range. Each row represents a key metric, and some rows are expandable to reveal relevant sub-metrics. Negative values (such as markdowns, refunds, and discounts) appear with a minus sign, and all values display in the currency of your Bloom account.

Metric Tiers (The Profit Waterfall)

The Profit Table is organized as a top-to-bottom profit waterfall. It starts from top-line revenue and subtracts one layer of cost at each tier until it reaches Net Profit:

1. Revenue metrics

2. Cost metrics

3. Contribution margins (CM1, CM2, CM3)

4. Marketing performance metrics

5. Operating expenses and Net Profit

How Refunds are Reported

Bloom follows Shopify's refund logic and offers two reporting modes:

1. Shopify-style refund reporting (default): refunds are shown based on the date the refund was issued, matching Shopify Analytics and Shopify Finance Reports.

2. Original Order Date refund mode (optional, recommended): refunds are attributed to the month the original order was placed rather than the refund date.

To switch modes, see How to use it.

Data Available

Revenue Metrics

Metric	Definition
GMV (Gross Merchandise Value)	Total value of products based on the compare-at price (original price), usually higher than the sale price. Formula: GMV = Σ (Compare-at Price × Quantity Ordered).
Price Cut (Markdown)	The difference between the compare-at price and the actual sale price, the total price cut applied versus original prices. Shown as a negative value. Formula: Markdown = Σ ((Compare-at Price - Variant Price) × Quantity Ordered).
Price Cut %	Markdown as a percentage of GMV. Formula: Price Cut % = (Price Cut ÷ GMV) × 100.
Gross Revenue	Total value of product sales after markdowns but before discounts and refunds. Formula: Gross Revenue = GMV + Price Cut (Markdown), where markdowns are negative.
Gross Orders	Total number of orders placed within the selected date range.
Gross AOV	Average spend per order. Formula: Gross AOV = Gross Revenue ÷ Gross Orders.
Net Orders	True order volume after removing fully refunded orders. Formula: Net Orders = Gross Orders - Refunded Orders.
Net AOV	Average amount earned per successful order after refunds and discounts. Formula: Net AOV = Net Revenue ÷ Net Orders.
% of New Customer Orders	Share of orders from first-time customers. Formula: % New Customer Orders = (New Customer Orders ÷ Gross Orders) × 100.
Discounts	Total value of all reductions applied at checkout, including line-item and order-level discounts. Reduces Gross Revenue to Net Revenue. Shown as a negative value.
Discounted Orders %	Share of orders with at least one discount applied. Formula: Discounted Orders % = (Number of Orders with Discounts ÷ Gross Orders) × 100.
Discount Value %	Share of potential revenue lost to discounts. Formula: Discount Value % = (Discounts ÷ Gross Revenue) × 100.
Returns and Refunds	Total value of refunded and returned items in the period. Bloom follows Shopify refund logic and offers two reporting modes (see How refunds are reported).
Return Value %	Share of Gross Revenue returned or refunded. Formula: Return Value % = (Refund Value ÷ Gross Revenue) × 100.
% of Orders Returned	Share of orders that resulted in a return or refund. Formula: % of Orders Returned = (Number of Returned Orders ÷ Gross Orders) × 100.
Shipping Revenue	Total shipping or delivery charges collected from customers at checkout.
% of Gross Revenue from Shipping	Share of Gross Revenue from shipping charges. Formula: % of Gross Revenue from Shipping = (Shipping Revenue ÷ Gross Revenue) × 100.
Net Revenue	Actual earnings after discounts and refunds, plus shipping revenue. Unlike Shopify Net Sales, Bloom includes shipping revenue and excludes taxes. Formula: Net Revenue = Gross Revenue - Discounts - Refunds + Shipping Revenue.
Taxes	Total tax collected on orders (Sales Tax, GST, VAT, Municipal or County Tax). Not merchant revenue; remitted to the government.
Duties and Tips	Total import duties, customs fees, or tips collected. Not product revenue; collected on the merchant's behalf or for staff.
Total Revenue	Complete amount collected from customers: Net Revenue plus taxes, duties, and tips. Matches Shopify's Total Sales. Formula: Total Revenue = Net Revenue + Taxes + Duties & Tips.

Cost Metrics

Metric	Definition
COGS (Cost of Goods Sold)	Total direct cost of producing the products sold in the period. Includes only costs directly tied to making or acquiring products; excludes indirect costs like marketing or salaries.
Product Cost	Pulled automatically from Shopify if entered in product settings, or uploaded in bulk in Cost Settings. Directly affects margin and profitability metrics.
Other COGS	Additional direct costs of selling products not included in the product cost itself. Uploaded in Cost Settings.
Order Fulfillment Costs	Total cost to process, package, ship, and deliver orders, covering every step from preparing the product to handling returns and processing payments.
Shipping Cost	Actual shipping cost retrieved automatically from Shopify Shipping or external shipping partners.
Handling Cost	Cost of preparing items for shipment (picking, packing, packaging materials, general handling). Estimated per product or order type in Cost Settings.
Return Handling Cost	Cost of processing returns (receiving, inspecting, repackaging, restocking, or disposal). Estimated in Cost Settings.
Tariff Cost	Import or export duties on cross-border goods, varying by country and product classification. Estimated rates set in Cost Settings.
Payment Processing Fees (Gateway Cost)	Transaction fees retrieved automatically for Shopify Payments. Other gateways (PayPal, Stripe, regional processors) and their estimated fees can be added manually.

Marketing Spend

Metric	Definition
Marketing Spend	Total spend across all paid channels to attract visitors, drive conversions, and grow revenue. A foundational input for CAC, MPR, and aMPR. Includes Meta Ads, Google Ads, Snapchat Ads, TikTok Ads, Pinterest Ads, Amazon Ads, and Non-Ad Marketing Costs.
Meta Ads	Ad spend attributed to Meta.
Google Ads	Ad spend attributed to Google.
TikTok Ads	Ad spend attributed to TikTok.
Snapchat Ads	Ad spend attributed to Snapchat.
Pinterest Ads	Ad spend attributed to Pinterest.
Reddit Ads	Ad spend attributed to Reddit
Partners Ads	The amount spent on affiliate advertising through Partner-ads (commission plus network fee).
Non-Ad Marketing Cost	Custom non-ad marketing costs added under Operating Expenses (such as influencer partnerships, promotional materials, sponsorships, and affiliate payouts).

Contribution Margin Metrics

Metric	Definition
CM1 (Gross Profit)	Amount earned after covering the direct cost of products sold. A higher CM1 indicates stronger product-level profitability. Formula: Gross Profit (CM1) = Total Revenue - Product Cost.
Gross Margin (CM1) %	Percentage of each revenue dollar retained after product cost. Around 75% or higher is generally strong. Formula: Gross Margin (CM1%) = Gross Profit ÷ Total Revenue.
CM2	Profit after product cost and all order fulfillment costs (shipping, handling, tariffs, returns processing, Amazon fees, payment processing fees). Formula: CM2 = Total Revenue - Product Cost - Order Fulfillment Costs.
CM2 %	Share of Net Revenue remaining after product and fulfillment costs. 60% or more is typically healthy. Formula: CM2% = CM2 ÷ Total Revenue.
CM3	Profit after product cost, fulfillment, and marketing spend. A clear indicator of operational profitability before fixed overheads. Formula: CM3 = Total Revenue - Product Cost - Order Fulfillment Costs - Marketing Spend.
CM3 %	CM3 as a share of Net Revenue. A healthy range is generally 30% to 45%. Formula: CM3% = CM3 ÷ Total Revenue.

Marketing Performance Metrics

Metric	Definition
MER (Marketing Efficiency Ratio)	How efficiently marketing spend turns into revenue. Higher is better. Formula: MER = Net Revenue ÷ Total Marketing Spend.
aMER (Acquisition MER)	How efficiently marketing spend brings in new-customer revenue. Formula: aMER = Net Revenue from New Customers ÷ Total Marketing Spend.
New Customers	Total customers who made their first purchase during the period.
Gross profit BEROAS	Minimum return the store needs on ad spending to cover product costs and avoid a loss. A BEROAS of 1 signifies that ad expenditure precisely covers product costs. Any BEROAS value greater than 1 indicates profitability. Formula: BEROAS = Total Revenue ÷ profit after fulfillment
Contribution Margin BEROAS	Minimum ROAS needed to cover variable costs, including product costs, fulfillment, and marketing spend. It helps measure profitability before fixed operating expenses
Net profit BEROAS	Minimum ROAS needed to cover all business costs and break even after accounting for product costs, fulfillment, payment fees, salaries, rent, and operating expenses.
15 % NP Target ROAS	ROAS required to achieve a 15% net profit margin. It represents the ad spend to revenue efficiency needed to cover all costs and retain 15% of revenue as profit.
CAC (Cost per New Customer)	Average cost to acquire a new customer. Lower is more cost-effective. Formula: CAC = Total Marketing Spend ÷ Number of New Customer Orders.
MPR (Marketing Profit Ratio)	Profit generated per dollar of marketing spend. Higher is stronger. Formula: MPR = CM2 ÷ Total Marketing Spend.
aMPR (Acquisition MPR)	CM2 from new-customer orders generated per dollar of marketing spend. Formula: aMPR = CM2 from New Customer Orders ÷ Total Marketing Spend.
First-Order Contribution Margin	Measures the profit generated from new customers. It shows whether revenue from new customers covers your advertising costs and indicates if acquiring new customers is profitable. Formula: Net Revenue of New Customers - COGS + Total Ad Spend.
First-Order Contribution Margin per New Customer	Measures the average profit generated per new customer on their first order.This helps you understand how much profit each new customer contributes after accounting for product costs and ad spend, and evaluate the efficiency of your customer acquisition efforts. Formula: First-order Contribution ÷ Number of New Customers.
% of Sales on Marketing	Share of Net Revenue reinvested into marketing. Formula: % of Sales on Marketing = Total Marketing Spend ÷ Net Revenue.

Operating Expenses

Metric	Definition
Operating Expenses	Total cost to run the business day to day, both fixed and variable. Components: Salaries, Rent, Maintenance, Amazon Charges, Professional Fees, Interest Payments, Custom Taxes, Other Expenses, Channel Fee. All except Amazon Charges (which sync automatically) can be added or updated in Cost Settings.
% of Sales on Operating Expenses	Share of Net Revenue used to cover operating expenses. A lower percentage indicates stronger operational efficiency. Formula: % of Sales on Operating Expenses = Total Operating Expenses ÷ Net Revenue.

Net Profit Metrics

Metric	Definition
Net Profit	Final profit after subtracting Operating Expenses from CM3. The clearest indicator of true profitability. Formula: Net Profit = CM3 - Operating Expenses.
Net Profit Margin (%)	Share of Net Revenue remaining as profit after all costs. Most ecommerce brands aim for 10% to 20%. Formula: Net Profit Margin (%) = Net Profit ÷ Total Revenue.
Cost of Goods Sold %	For e-commerce brands, the ideal range for the cost of goods sold (COGS) as a percentage of Net Revenue is typically between 25% and 35%. This suggests the selling price is three to four times the product's cost.
Cost to Serve Orders %	Cost to fulfill orders typically accounts for an average of 10% of Net Revenue for most brands. These fulfillment expenses comprise the combined costs of handling, gateway fees, and shipping..
Cost to Acquire Customers %	Share of Total Revenue spent on marketing to acquire customers. Growth brands often near 25%, mature brands under 20%. Formula: Cost to Acquire Customers % = Marketing Spend ÷ Net Revenue.
Cost to Operate Business %	Share of Total Revenue spent on overheads (salaries, rent, professional fees, maintenance, platform fees, other). Typically around 15%. Formula: Cost to Operate Business % = Operating Expenses ÷ Net Revenue.

How to Use it

1. Set the date range for the period you want to analyze.

2. Choose the grouping: day, week, or month.

3. Expand any row that has sub-metrics to see its breakdown.

4. Add or upload your cost inputs in Cost Settings so calculations are accurate: product cost, other COGS, handling, return handling, tariffs, payment gateway fees, and operating expenses. Set custom shipping rules in Shipping Settings.

5. Choose your refund reporting mode: keep the default Shopify-style reporting, or switch to the optional Original Order Date mode.

6. Read the Total column for the full-period summary across all metrics.