D2C Analytics: from CTR to creator ROI

The Overview tab gives you a single-screen health check on your brand. Eight KPI cards show your current-period performance alongside the percentage change from the prior period of equal length.

• Revenue and order count — with MoM change arrows — tell you instantly whether your business is growing or contracting.
• Average Order Value (AOV) is one of the easiest levers to pull. A rising AOV usually means better bundling or upsells are working.
• The dual-axis chart shows revenue (left axis) and order volume (right axis) on the same canvas so you can spot if revenue is growing faster than orders — which is a positive AOV signal.
• The Revenue by Source breakdown shows which channel (Instagram, Shopify, Amazon, Website) drives the most business, not just the most traffic.
• Fulfillment Rate and Return Rate are shown in the secondary KPI row. Both are real-time and based on all-time order data for accuracy.

The Revenue tab is your financial time machine. Toggle between Daily, Weekly, and Monthly granularity to zoom in or out on your revenue trajectory.

• Daily view is best for spotting post-launch spikes, promotion-driven bumps, or dead zones in your posting schedule.
• Weekly view smooths noise and makes trend lines readable — ideal for founder weekly reviews.
• Monthly view is best for board-level reporting and year-over-year comparisons.
• The growth percentage compares your selected period to the preceding period of equal length. A 30-day range always compares to the previous 30 days.
• Revenue by Channel horizontal bars show absolute revenue contribution from each source, making it easy to decide where to invest next.
• AOV per period reveals whether your product mix is shifting. A dropping AOV can signal over-reliance on lower-margin SKUs.

The Content tab surfaces performance data for all posted reels, carousels, stories, and posts within the selected period — helping you understand what your audience actually responds to.

• Engagement Rate = (likes + comments + saves + shares) ÷ views × 100. Saves and shares weigh heavier than likes in the Instagram algorithm, so high engagement rate content gets more organic distribution.
• CTR (Click-Through Rate) = clicks ÷ impressions × 100. This requires click and impression data to be entered per content piece. For organic content, this is typically derived from Instagram Insights.
• Add-to-Cart tracks how many viewers took the next step in the purchase funnel. This is a leading indicator of conversion — rising add-to-cart with flat sales usually means checkout friction.
• The engagement trend chart shows daily views and engagement rate side-by-side. A widening gap between views and engagement rate means you're getting reach without resonance — a signal to revise your content strategy.
• Sort the top content table by Views, Engagement Rate, CTR, or Add-to-Cart to find your true best performers by the metric that matters most to your current goal.
• Content type breakdown (Reels vs. Posts vs. Carousels) shows which format drives the most impact — not just the most output.

CTR and conversion rate are the two most misunderstood metrics in D2C marketing. Here's what they actually measure and how to improve them.

• CTR measures interest — the share of people who saw your content and chose to click. A high CTR with low conversions means your landing page or checkout is the problem, not the content.
• Conversion Rate measures intent-to-purchase — the share of clicks that become orders. For D2C Instagram brands, 1–3% conversion rate on cold traffic is typical; 3–8% on warm/retargeted audiences.
• Add-to-Cart Rate bridges CTR and conversion: it shows how many visitors showed purchase intent. A high add-to-cart rate but low conversion usually means pricing, shipping cost, or trust issues.
• To improve CTR: test different hook angles in your reels, use strong visual contrast, and lead with the problem you solve rather than the product.
• To improve conversion: simplify your checkout, add social proof near the buy button, and reduce shipping cost surprise at checkout.

The Creators tab ranks every influencer you've worked with by views, engagement rate, cost-efficiency, and calculated ROI — so you know exactly who to work with again.

• Creator tiers — Nano (<10K), Micro (10K–100K), Macro (100K–1M), Mega (1M+) — help you benchmark engagement expectations. Nano and micro-influencers almost always outperform macro on engagement rate.
• ROI is calculated as views per rupee spent (total cost = agreed rate + product value). Pure views-per-rupee is a proxy since direct revenue attribution requires UTM tracking.
• Engagement Rate for influencers = (views ÷ follower count) × 100 when individual post engagement data is unavailable — or the direct engagement % you entered.
• Total Cost includes the creator's agreed rate plus the value of any product gifted. Never compare ROI across creators without including product cost.
• Sort by any column to find your best-value creator at any given moment. The leaderboard persists all-time data, not just the selected period.
• Campaign ROI shown in the table reflects the agreedRate and totalConversions fields you track per campaign — fill these in for accurate attribution.

The Operations analytics tab extends the Ops dashboard with trend-line data — showing whether your fulfilment is improving week over week, not just a snapshot of today.

• Fulfillment Rate trend over 4-8 weeks reveals whether operational issues are structural (consistently low) or episodic (spikes during promotions).
• Average Delivery Time (ship → delivered) is your primary customer satisfaction metric for post-purchase experience. Industry average is 3–5 days for metro India.
• Average Packing Time (packed → shipped) is your internal efficiency metric. If this is growing, it means your team is taking longer to hand off to the courier.
• Issue Resolution Time tracks how long it takes to close customer tickets from open to resolved. Under 48 hours is the standard for quality D2C support.
• Returns by Reason categorises your return data so you can take structural action — wrong item returns are a warehouse problem, not-as-described returns are a content/photography problem.
• Pipeline Health shows the real-time distribution of all orders across every stage. A pipeline clogged in PENDING means demand is outpacing your packing capacity.

The Reports tab is where analytics becomes action. It synthesises everything into plain-English insights, a period summary table, and downloadable CSVs.

• Insights are heuristic-based summaries generated from your data — no AI subscription required. They follow proven D2C benchmarks: >8% return rate, <60% fulfilment rate, and engagement benchmarks by creator tier.
• The Period Summary table gives you a single-page snapshot you can screenshot for your weekly ops review or paste into a Slack update for your team.
• Export types: Orders CSV (full order list with shipping data), Content CSV (all posted content with metrics), Creators CSV (influencer database), and Summary CSV (key metrics for your period).
• Monthly Reference rows let you compare any month at a glance without changing the date range filter. Each row loads independently.
• The structured insight data is designed to be AI-ready — you can copy the period summary and paste it into Claude or GPT for deeper analysis or report generation.