How to Track Unit Economics per SKU in Zoho Analytics

Why SKU-Level Unit Economics Matter

Aggregate P&L tells you if the business is profitable. SKU-level unit economics tells you which products are making money and which are destroying margin. Many sellers report discovering that their top-selling product is actually one of their least profitable after accounting for high return rates or expensive ad spend to drive those sales.

The formula is simple in theory:

Contribution Margin per Unit = Selling Price - COGS - Channel Fees - Shipping Cost - Returns Allocation - Ad Spend Allocation

The hard part is getting those numbers into one place, at the SKU level, automatically. That's where Zoho Analytics comes in.

Step 1: Get Your Data Sources Right

SKU-level unit economics requires data from multiple systems. In the Zoho ecosystem, you'll pull from:

• Zoho Books — revenue per invoice line item (SKU + quantity + selling price), COGS from purchase orders or inventory valuation
• Zoho Inventory — landed cost per item (purchase price + freight + duties), current stock valuation, warehouse-level cost data
• Channel data — Amazon referral fees per ASIN, Shopify transaction fees, eBay final value fees (these come via your settlement reconciliation process or integration tool)
• Ad platforms — Google Ads, Meta Ads, Amazon Sponsored Products spend allocated by product or campaign

Zoho Analytics can connect to Zoho Books and Zoho Inventory natively — no setup required beyond enabling the connector. For ad platform data, you'll use Zoho Analytics' built-in connectors for Google Ads and Facebook Ads, or import CSV data for Amazon Advertising.

Step 2: Build the Data Model in Zoho Analytics

Once your data sources are connected, you need to join them. In Zoho Analytics, this is done through Query Tables (SQL-like joins) or the Data Blending feature.

Key Joins

1. Invoice Line Items (Zoho Books) → Items (Zoho Inventory). Join on Item ID or SKU. This gives you selling price per unit alongside landed cost per unit.
2. Items → Purchase Orders (Zoho Inventory). This lets you pull actual purchase cost (not just standard cost) for landed cost accuracy.
3. Invoice Line Items → Channel Fee Data. If you've set up proper channel integration, fees are recorded as line items or journal entries in Zoho Books. Join on order reference or invoice number.
4. Items → Ad Spend (from Google/Meta/Amazon connectors). This is the trickiest join. Ad spend is usually at the campaign or ad group level, not the SKU level. You'll need to allocate it — more on that below.

Ad Spend Allocation

Unless you run one ad campaign per SKU (unlikely), you need an allocation methodology:

• Revenue-weighted allocation: If SKU A generates 30% of a campaign's attributed revenue, it gets 30% of the campaign's spend. This is the most common approach.
• Unit-weighted allocation: Divide campaign spend equally across units sold from that campaign. Simpler but less accurate for mixed-price catalogs.
• Direct attribution: If you use single-SKU campaigns (common in Amazon Sponsored Products), the spend maps directly. Build a lookup table of campaign → SKU for this.

Step 3: Build the Dashboard

With the data model in place, create a Zoho Analytics dashboard with these key views:

• SKU Profitability Table: A sortable table showing SKU, units sold, gross revenue, COGS, channel fees, shipping, returns, ad spend, contribution margin ($ and %). Sort by margin to find winners and losers.
• Margin Distribution Chart: A histogram or scatter plot of contribution margin % across all SKUs. This immediately shows whether you have a margin concentration problem.
• Trend by SKU: Line chart of contribution margin over time for your top 10 SKUs. Look for margin erosion — it often happens gradually as COGS or ad costs creep up.
• Bottom 10 SKUs: A focused view of your lowest-margin products. These are candidates for price increases, cost renegotiation, reduced ad spend, or discontinuation.

Step 4: Automate Refresh and Alerts

Zoho Analytics supports scheduled data refreshes — set your connectors to sync daily. More importantly, set up alerts:

• Margin below threshold: Alert when any SKU's contribution margin drops below a target (e.g., 20%).
• Return rate spike: Alert when a SKU's return rate exceeds the category average by more than 2x.
• Ad spend efficiency: Alert when a SKU's ad cost exceeds its contribution margin (you're paying to lose money).

These alerts can fire via email or push to Zoho Cliq (Zoho's team chat) so your team catches problems before they compound.

What This Looks Like in Practice

We've seen ecommerce businesses discover that 30-40% of their SKUs have negative contribution margin once ad spend and returns are factored in. The typical response is to kill or restructure those products, which immediately improves overall margin — often by several percentage points — without increasing revenue.

That kind of insight is only possible when you track unit economics at the SKU level. Aggregate reporting hides it. Zoho Analytics, combined with clean data from a properly configured Zoho One stack, makes it accessible for businesses that can't justify a full data warehouse and BI team.