01Top
MR Jewels · Case Study Engagement closed — Bengaluru Google Ads 530-183-4495 · Shopify · Merchant Center 5383672764 September 2026
Performance marketing · Premium imitation jewellery D2C

Seven weeks
on the account

A two-year-old Google Ads account, ₹62.9 lakh spent, 30 campaigns, 80% on Shopping. I took it over on 1 August 2026. Three campaigns launched, a conversion fix that cut store CPC 66%, 24 build documents, and a measurement audit that found ₹12.56 crore of value that never existed. This is the full record — the wins, the data, the mistakes, and what was handed over.

Pitch 29 Jul 2026Live on account 1 Aug 2026Last build 3 Sep 2026Closed Sep 2026
Gross sales · Aug
₹1.07 Cr
1,960 orders · +21.8% MoM
Google billed · Aug
₹10.88 L
Largest month ever · +143%
Store CPC after fix
−66%
₹38.60 → ₹13.13
Showroom actions · Aug
1,356
543 in the 25 months before
Phantom conv. value
₹12.56 Cr
11.8× the company's revenue
Documents delivered
24
Specs, audits, reports, plans
01

What I inherited

9 Jul 2024 – 31 Jul 2026

Run by a previous team for 25 months before me. None of the history below is my work — it is the starting line.

All-time spend
₹62.9 L
30 campaigns
Conversions
7,020
CPA ₹896
Purchases
5,028
AOV ₹5,609
PMax return
24.3×
On 8.1% of budget
Shopping share
80.9%
CPA ₹1,146
Search share
1.0%
CPA ₹73 — cheapest
Share of spend against share of conversions · all time
Share of spendShare of conversions

Shopping took four rupees in five and returned under two-thirds of the conversions. Search and PMax did the opposite on 9% of the money.

₹1,146 vs ₹73

Shopping CPA against Search CPA. 15.6× the cost on 80× the budget. The money sat on interruption, not captured intent.

Shopping₹50,87,326₹1,146 CPA
Demand Gen₹6,30,049₹1,588 CPA
Performance Max₹5,09,053₹386 CPA
Search₹63,348₹73 CPA
Account₹62,89,776₹896 CPA
The business around the ad account · trailing 12 months to Jul 2026
Revenue, net of returns₹9.21 Cr+190.6% YoY
Orders20,85057 a day
Total ad spend₹2.44 Cr+152.9%
— Meta₹1.91 Cr78.4%
— Google₹52.6 L21.6%
Blended MER3.78×July 2.68×
CAC₹1,168Q2 ₹1,304
Return rate18.9%₹2.22 Cr

Google was the smaller channel. Every Google decision below sits inside a business that is 78% Meta.

Inherited defects · found in the first 17 days
Lead form primary on 13 of 30 campaigns1,992 conversions (28%) were not purchasesCRIT
Search impression share <10% across 26 monthsAuction insights never populatedHIGH
1,042 dead terms ≥₹300₹6,33,931 with zero conversionsHIGH
{ignore} ValueTrack in a live URL₹32,289 of untraceable clicksMED
UAE and Angola leakage₹3,86,549 UAE · ₹11,772 Angola at ₹34.83 CPCMED
Showroom on 0.22% of budgetDirections at ₹32.57 eachOPPORTUNITY
02

Seven weeks, as worked

29 Jul – 3 Sep 2026

Pitch to last build in 37 days. Three campaigns live, eleven asset and ad groups written, twenty-four documents shipped.

Engagement timeline · hover for detail
LaunchedChangedDeliveredIncident
Campaigns launched
3
PMax Store · Brand Search · C04 remarketing
Asset groups written
10
3 store · 2 remarketing · 5 Volume Core
Ad groups built
5
Brand AG01–AG05
Headlines written
120+
75 in Volume Core alone
Search terms read
13.7 L
8.6 L all-time + 5.05 L Aug
Reports published
2
Case study + August report
Every document delivered · 24
All-time Google Ads review + data tables17 Aug · Audit · 32 tablesPUBLISHED17 Aug
Search layer restructure17 Aug · StrategyDELIVERED17 Aug
AG04 Brand Exact + Misspellings build spec17 Aug · Build sheetLIVE17 Aug
Stage 3 non-brand Search campaign20 Aug · Build sheetNOT BUILT20 Aug
Blended business review · 24 months Shopify + Meta + Google21 Aug · ReviewDELIVERED21 Aug
PMax AG02 Bridal & Trousseau build spec21 Aug · Build sheetLIVE21 Aug
AG05 Competitor build spec24 Aug · Build sheetNOT BUILT24 Aug
PMax Store negative keywords24 Aug · Build sheetDELIVERED24 Aug
PMax AG03 Festive & Gifting build spec25 Aug · Build sheetLIVE25 Aug
Account change log25 Aug · OpsDELIVERED25 Aug
Budget vs delivery, Aug 1–2626 Aug · AuditDELIVERED26 Aug
Account command dashboard · HTML + 10-page PDF27 Aug · DashboardDELIVERED27 Aug
Notion daily ops hub · 4 databases27 Aug · OpsDELIVERED27 Aug
Call tracking build spec · Exotel split architecture28 Aug · Build sheetNOT BUILT28 Aug
Road to 100 orders a day28 Aug · PlanDELIVERED28 Aug
Stage 4 remarketing build spec28 Aug · Build sheetLIVE28 Aug
C04 build walkthrough28 Aug · Build sheetLIVE28 Aug
C04 AG02 Cart 8–30d build spec31 Aug · Build sheetDELIVERED31 Aug
Stage 4 scale plan · 50 orders a day31 Aug · PlanDELIVERED31 Aug
Stage 4 campaign structure31 Aug · PlanDELIVERED31 Aug
The August Report · 16 sections, 22 charts1 Sep · ReportPUBLISHED1 Sep
Tracking repair spec + account state correction2 Sep · AuditHANDED OVER2 Sep
Stage 5 PMax Core Movers build spec2 Sep · Build sheetNOT BUILT2 Sep
Volume Core asset group copy · 5 groups3 Sep · Build sheetNOT BUILT3 Sep

"Not built" means specced and handed over but not published before close. Execution after 3 September is not recorded here.

03

The month

August 2026 · sales and marketing

The only full month on the account. The store grew. The account grew four times faster.

Sales — Shopify
Gross sales₹1,06,84,206+21.8%
Discounts−₹5,31,0245.0%
Sales reversals derived−₹21,16,12019.8%
Net revenue₹80,21,93575.1%
Orders1,960+16.1%
Average order value₹5,180+4.9%
Sessions4,20,817+53.3%
Conversion rate0.466%−24.2%
Marketing — Google Ads
Media cost ex-GST₹9,25,231—
Net cost billed₹10,87,899+143.3%
Impressions1,15,59,854—
Clicks1,78,878CTR 1.57%
Average CPC₹5.07₹3.77–9.52
Conversions all2,859.62inflated
Conversions clean, 5–31 Aug408.57₹1,867 CPA
Available funds, 1 Sep₹18,571½ day
Google spend rose 143%. Gross sales rose 21.8%. Every rupee added in August bought roughly a fifth of what the rupee before it bought.
Daily spend · the shape of the month
Daily spend10 Aug · funds exhausted

₹14,900/day to 9 August. ₹533 on the 10th when the balance ran dry — about ₹32,000 of delivery lost. Then ₹33,000–40,000/day to month end. Balance exhausted again on the 31st.

Campaign league · August
CampaignSpendConv.CPACall
S_Tofu_18july Shopping₹4,49,901235.36₹1,912HOLD
Stand_14Jan Shopping₹2,60,3421,231.55₹211FIX
Demand Gen_15jan₹60,98235.00₹1,742WATCH
Search | Brand | Bangalore · mine₹57,24923.77₹2,408CUT
Sales_PMax_CatchAll₹38,806120.96₹321FIX
PMax | Store | Bangalore · mine₹27,025961.97₹28SCALE
Demand Gen | Remarketing · mine₹9,9990.00—WATCH
Brand_3june₹3,09384.98₹36SCALE

Channel split: Shopping ₹7,10,243 · PMax ₹81,602 · Demand Gen ₹73,050 · Search ₹60,336. PMax Store conversions are local actions, not sales.

CPA against spend · bubble = conversions

Dashed = conversion data defective (Section 07).

04

The fix that paid

PMax Store · Indiranagar showroom

The first campaign I launched read zero for 17 days. The problem was not the campaign. It was which conversion Google was told to chase.

−66% CPC

No local action was set to Primary, so Smart Bidding ran blind and bought anonymous clicks at ₹38.60. One goal change on 21–25 Aug. CPC fell to ₹13.13, and to ₹10.13 across 18–25 Aug.

Clicks122 → 1,241×10.2
Impressions17,651 → 51,623×2.9
CTR0.69% → 2.40%×3.5
Average CPC₹38.60 → ₹13.13−66%
Conversions0 → 425.97—
Cost per local action₹38.24Aug 1–25

Aug 1–17 against Aug 1–25, asset group Store & Showroom 01. The highest-value single edit made to the account in the engagement.

Before and after · indexed to before = 100
Aug 1–17Aug 1–25Aug 18–25 only

Bars show change on the right scale: CTR and clicks up, CPC down. 34.06% conversion rate describes local actions — directions, calls, visits — never ₹38 per sale.

Showroom output · August
1,356

local actions on ₹27,025 — 3% of budget.

Driving directions1,153₹23.44 each
Call taps145unmeasured
Store visits modelled58floor
Against the 25 months before
Local actions543 → 1,356×2.5
Driving directions434 → 1,153×2.7
Cost per direction₹32.57 → ₹23.44−28%
Local spend₹14,137 → ₹27,025lifetime → 1 mo
Local share of budget0.22% → 2.9%—

One month produced 2.5× the local actions of the account's whole prior life.

Asset groups I wrote · August
Store & Showroom 01 EXCELLENT15 headlines · 50 themes · 20 images₹22,891₹29 CPA
Bridal & Trousseau 02 EXCELLENT25 search themes₹1,915₹27 CPA
Festive & Gifting 0324 seasonal themes₹2,220₹20 CPA
Inherited Catch All + OpenAd strength Average₹38,806₹287–367

All three new groups landed at ₹20–29. The inherited groups ran 10× higher.

Local intent took 4.3% of August search spend and returned 25% of the conversions — at ₹56 against ₹413 everywhere else. PMax Store wasted 22% of its search spend; the rest of the account wasted 86–94%.
05

The scale test

July → August · ₹6.41 lakh added

Strip out every Google conversion number. Use only Shopify revenue and the billing screen. This is the honest read of what the extra money bought.

2.99× gross

₹6,40,702 of extra spend bought ₹19,14,731 of extra gross sales and 272 extra orders — ₹2,356 per incremental order. After the 19.8% reversal rate: 2.24× net.

Google billed₹4,47,196 → ₹10,87,899+143.3%
Shopify gross sales₹87,69,475 → ₹1,06,84,206+21.8%
Orders1,688 → 1,960+16.1%
Sessions2,74,528 → 4,20,817+53.3%
AOV₹4,938 → ₹5,180+4.9%
Conversion rate0.615% → 0.466%−24.2%

Sessions up 53%, orders up 16%. The new traffic converted a quarter worse. That is buying wider, not better.

Two methods, no shared inputs

Google's clean-period data: 2.73×. Shopify incremental: 2.99×. Within 10% of each other with nothing in common.

Break-even margin · incremental net44.6%2.24×
Break-even margin · incremental gross33.4%2.99×
Break-even margin · clean Google36.7%2.73×

Above ~45% gross margin the scale-up paid. Below 33% it lost money. COGS was never supplied.

06

The two years behind it

Aug 2024 – Aug 2026 · blended

Revenue tripled in a year. Efficiency fell every quarter while it did. My seven weeks sit at the far right of every chart below.

Monthly revenue against total ad spend · Meta + Google
Revenue, net of returnsMeta spendGoogle spend

July 2026 estimated from 17 days on the within-month revenue curve, not linear. Meta spend for August 2026 was never supplied, so August does not appear here.

Blended MER by month · revenue ÷ all ad spend

Dashed line: the 3.50× guard rail I set on 21 Aug. The Stage 3 doc used "hold below 15.0" — Shopify revenue over Google spend only, a trigger that could never fire. Corrected in four documents.

2.68×

July 2026, restated — the worst month in two years, the month before I started.

Q3 20254.51×CAC ₹951
Q4 20253.95×CAC ₹1,056
Q1 20263.92×CAC ₹1,161
Q2 2026 · first contraction3.63×CAC ₹1,304

Google share and MER correlate weakly: months with Google ≥20% of spend averaged 4.01×, the rest 3.60×. r = 0.28 — a reason to test, not a proof.

Shopify gross sales against Google billed · 12 months
Gross salesGoogle billed

Gross peaked at ₹1.22 Cr in Feb 2026. August's ₹1.07 Cr is second-best — on more than double February's Google spend.

Google-only MER · sales ÷ Google billed

August at 9.82× is the floor of the year, against a 19.0× average.

Google billed by month · 26 months

From ₹1,214 in July 2024 to ₹10.88 L in August 2026. Trailing twelve months ₹71.22 L against ₹8.18 L before — 8.7×. August alone exceeds the account's first fifteen months combined. Still funded by manual ₹15,000 netbanking top-ups.

Findings from the 24-month review that changed decisions
The cart, not the trafficSession→cart improved 5.28% → 5.45%. Cart→order collapsed 16.8% → 13.5%. 85 of 100 cart-adds never buy.₹3.3 Cr/yr
Only AOV is working₹3,773 → ₹4,415 while sessions fell 37% from peak. Nobody knew why.+17%
Platforms over-claim 27%Meta ₹8.63 Cr + Google ₹2.19 Cr claimed against ₹8.55 Cr actual Shopify.₹2.28 Cr
Returns post in a batch17 negative days, all between the 18th and 31st. Days 1–17 carry 66.1% of a month's net revenue.−₹92.1 L
Dhanteras does not register2025 Dhanteras ₹2.84 L vs an October median day of ₹2.58 L. The real peak is Nov–Feb weddings.+10%
Stated budget ≠ spendBrief said ₹30 L/month. Meta + Google measured ₹20.3 L. If ₹10 L runs elsewhere, true CAC is ₹1,700+.₹20.3 L
The full blended series
MonthRevenueOrdersReturn %MetaGoogleGoogle %MERCAC
07

What the numbers were hiding

Conversion tracking

Google reported ₹12.56 crore of conversion value in August. The whole company — every channel — took ₹1.07 crore. Most of the engagement's analysis went into finding out which numbers could be trusted.

11.8×

Google claimed 11.8 times the company's revenue. Stand_14Jan booked ₹12.33 Cr between 1 and 4 August — 99.7% of its month — on ₹53,896 of spend.

As reported · full month
₹8.41 L spend · ₹12.56 Cr value149×
1–4 August only
₹78,896 spend · ₹12.35 Cr value1,565×
5–31 August · usable
₹7.63 L · ₹20.79 L · ₹1,867 CPA2.73×
Daily conversion value · four days hold 98.3%
1–4 Aug · disputed5–31 Aug · credible

Strip those four days and the account converts at about 13 a day across five campaigns. That is the real run rate.

The 2 September tracking repair · three real defects, one false alarm
False alarm — "33 lifetime add-to-carts"Read off goal-summary cards, which count primary actions only. Real volume below.26,737firing
D1 · Add-to-cart valueApp action carries ≥₹10,00,00,00,000 across 26,737 events. GA4 control: ₹5,819 per cart.₹3.74 Lper cart
D2 · Purchase counted twiceShopify app tag + GA4 import. ₹4.74 Cr claimed vs ₹2.98 Cr real.1.6×All conv.
D3 · No primary action on two goals35% of Sep 1–2 "conversions" were local actions, not sales.35%not sales
Purchase value accuracyLifetime Google AOV vs store AOV₹5,545 / ₹5,438PASS 2%
Purchase volume plausibilityGoogle orders as share of 28,575 store orders5,368 · 18.8%PASS
gclid survives landingHome + two collections testedno strippingPASS
Auto-tagging · time zone IST · call reportingon · match · onPASS

Two traps left alone on purpose. Google's "Fix it" button would promote add-to-cart to primary — a remarketing campaign would then buy abandonment. "Set up a Begin checkout conversion" would add a third GA4 action to a duplication problem.

A tracking break nobody logged · tracked checkouts as a share of real orders

Coverage fell from 41.9% in December to 2.9% in February, sat at 2–4% until May, and reached 57.0% in August. Orders barely moved. Every conversion-rate trend between February and May is void, and August's checkout "improvement" cannot be separated from the tracking recovering.

The funnel Shopify can see · August

Shopify reports a 0.01% conversion rate: it counted 68 checkouts against 1,960 orders, because 96.5% complete in third-party checkouts that emit no events. The true rate is 0.466%.

Data-quality register at close
Google conversions > store orders79/day reported vs 51–59 real orders/day, early Aug1.4×counting
Three account cost totals₹9.07 L, ₹9.25 L, ₹10.88 L (ex-GST, media, billed)3shown, not picked
Three top-of-page figures61.82%, 61.89%, 54.53%3shown, not picked
Oct 2025 Meta spend conflictMonthly sheet vs daily tracker₹55,794unresolved
₹32.6 L unexplainedGross − returns exceeds total sales by 2.1% most months2.1%unnamed
Orders with a known sourceHeadless checkout strips the referrer3.4%708 of 21,015
Landing page report cost₹75.49 L vs ₹62.91 L account — Shopping double-rows+20%relative only
08

Where the money went

Budget, delivery and the starving campaign

The account ran at 74% of its budget cap. The best campaign used 29% of its own. Budget was never the constraint — allocation was.

Budget cap used · Aug 1–26

Label = cost per conversion. Demand Gen spent 98.5% of its cap for 29 conversions. Sales_PMax_CatchAll used 28.7% at ₹217.

₹217 vs ₹1,568

Sales_PMax_CatchAll against Shopping. 103 conversions, 17.2% of the account, on 3.2% of spend. Shopping took 80.7% of spend for 33.8% of conversions.

Daily cap, all campaigns₹37,600—
Actual spend Aug 1–26₹7,23,369₹27,822/day
Unspent cap₹2,54,23126.0%
Blended cost / conversion₹657incl. local
Excluding local actions₹1,177comparable

The client tracker's TOTAL cell read ₹9,77,600 — that was the cap, not spend. Restated, not silently corrected.

First two days of September · the throttle clears
CampaignTypeCostConv.ValueROASCost/conv
S_Tofu_18julyShopping₹18,5196.15₹40,0972.17₹3,011
Stand_14JanShopping₹16,4043.87₹18,5551.13₹4,243
Sales_PMax_CatchAll · 96.4% of capPMax₹5,7594.00₹20,3353.53₹1,440
Demand Gen_15janDemand Gen₹4,0252.00₹4,6001.14₹2,012
Search | Brand | BangaloreSearch₹4,0201.67₹9,5052.36₹2,404
Demand Gen | Remarketing (C04)Demand Gen₹3,5990.00₹00.00—
PMax | StorePMax₹2,4069.00 local₹0——
Brand_3juneSearch₹372.00₹6,500175.50₹18.52
Account₹54,78318.69 purchases₹99,6011.82₹2,931

Two days is not a CPA window. What is decisive at this grain: CatchAll now spends ₹2,880/day against a ₹2,987 cap, and Shopping takes 64% of spend at 1.68 ROAS. Google claims 17.0% of Shopify's ₹5,86,733 on ~20% of blended spend — coherent.

The brand leak · same brand, same store, same two days
CPC₹0.59 / ₹7.4212.6×
Conversion rate3.17% / 0.31%1/10th
Cost per conversion₹18.52 / ₹2,404130×
Indiranagar brand CPC · Aug₹55.99Bengaluru ₹11.67
22 of 28 postcode rows₹13,6000 conv

Brand_3june (inherited) vs Search | Brand | Bangalore (mine). Brand Broad 01 was buying non-brand traffic. Fix handed over: pause, head-term negatives, rebuild on phrase — ₹41,200/month.

Competitive position · auction insights, August
MR Jewels<10%61.8% top
palmonas.com14.51%65.6%
myntra.com14.12%69.0%
amazon.in10.79%69.8%
giva.co<10%71.6%
kushals.com<10%64.1%

The first auction insights the account ever produced — 26 months had been below Google's 10% reporting floor.

09

The demand side

13.7 lakh search terms read

Two full exports: 8,60,452 unique terms all-time, and 5,05,231 for August alone. The waste was large. The sellers fit on three pages.

All-time terms
8.6 L
2,692 converted · 0.31%
All-time zero-conv spend
₹25.9 L
65.8% of term cost
August terms
5.05 L
43,797 took cost
August zero-conv spend
₹4.99 L
88.5% of named spend
CPA where it works
₹37
1,026 terms · 1,744 conv
Terms = 80% of conv
596
Three pages
Cost per conversion by demand theme · August
Under ₹200₹200–500Over ₹500
Share of each campaign's search spend that converted nothing

The two campaigns recommended from week one — Brand_3june and PMax Store — waste 11% and 22%. Everything else 86–94%.

Intent buckets · all time

Brand: 207 terms, 1.3% of spend, 24.8% of all conversions at ₹46. Competitors: ₹3.62 L at ₹1,215. Buckets overlap.

The negative list, built surgically
Cut · competitor terms, zero conv, ≥₹100₹19,09167 terms
Cut · watches, apparel, bags, bullion, repair₹10,124~1,450
Cut · single terms >₹500, nothing back₹28,94232 terms
Defensible cut, August≈₹50,0005.4%
Keep · competitor terms that convert₹9,777₹87 CPA
Keep and expand · local intent₹24,487₹56 CPA
All-time list · ≥₹300, zero conv₹6,33,9311,042 terms

The remaining ₹4.4 L of August waste is a feed and structure problem. Negatives will not touch it.

Worst terms · August, zero conversions
mr jewels indiranagar · own store, own postcode₹3,167₹117/click
swarovski₹1,712343 clicks
brooch for men₹1,521126 clicks
polki jewellery₹1,492313 clicks
sabyasachi jewellery online₹1,3093 clicks
pendant necklace₹1,28912 clicks
mrjewels bengaluru₹1,04336 clicks
Best converters · all time
mr jewels573.60₹25 CPA
mrjewels128.64₹42
mrj jewellers88.64₹12
brooch for men · top non-brand35.22₹803
joules by radhika · competitor31.87₹780
stone jewellery33.00₹32
hyderabad pearls24.00₹11
10

Catalogue, returns and pages

The largest number was not advertising

₹2.41 crore reversed in twelve months. 8,396 SKUs in the feed, 478 that actually move. The ads pointed at necklaces; the business is built on kadas.

₹2.41 Cr

Reversed over twelve months — 19.8% of gross. About ₹21.2 L in August, twice the Google bill.

Gross sales · 12 months₹12,18,64,994
Discounts−₹62,29,441
Sales reversals−₹2,41,36,654
Net sales₹9,14,98,899
Shipping and taxes+₹35,76,894
Total sales₹9,50,75,792

A quarter recovered is ₹5.3 L a month at zero acquisition cost.

Reversal rate by sales channel

fastrrv3 carries 75.8% of sales at 23.8% reversal — 3.6× the native Online Store. It accounts for ₹2.31 Cr of the ₹2.41 Cr.

Reversal rate by product · SKUs above ₹3 L gross
Deity and animal pendantsOpenable kadas and brooches

Every line above 40% is a deity or animal pendant — they top sell-through at 100% and come back. ₹1,19,134 of August ad spend went to products with a 30%+ reversal history.

Category economics · Aug 2025 – Aug 2026

Bar = gross sales. Label = return rate. Necklace is 20.4% of revenue with the worst returns at 26.9%; brooch the best at 11.7%. Total ₹12.65 Cr, 22,242 units, ASP ₹5,688.

In the feed
8,396
Merchant Center
Never shown
5,562
66% of catalogue
Throttled
5,656
Missing feed fields
80% of value
140
1.7% of SKUs
Zero stock, still live
2,153
37% of variants
Movers · 12+ units/yr
478
8% of variants

₹1,80,256 spent on 1,861 SKUs that returned nothing — 24.9% of Shopping. 5,200 SKUs missing age_group and gender; one feed rule releases ~5,656 products.

Cart-add rate by landing page · product pages 4.50%

The Stage 3 draft sent four ad groups to studs, necklaces and kundan-jewellery — three of the worst pages on the site. Swapped before handover: brooch +73%, earrings +68%, choker-sets +119%.

Shopify's ten biggest sellers · red = share reversed

Seven of ten are kadas or bangles. Only two appear in Google's top-20 spend.

11

Audience, time and place

A phone business with one showroom

A Bengaluru showroom selling to every metro. Mobile carries almost everything. The evening is the strongest block of the week.

Impressions by day and hour · August · 168 cells
LOWHIGHPeak 10PM Sunday · trough 3–5AM

Two peaks a day: midday and 9–11PM. 3–5AM carries 2.4% of impressions — excluded in the Stage 5 schedule.

Device · August spend
Mobile₹8,48,02293.5%
Computers₹49,2335.4%
Tablets₹7,4220.8%
TV screens₹2,7200 conv

Mobile: 96.3% of conversions, 95.1% of 35.6 L store sessions. All-time, desktop converted at 2× mobile (1.42% vs 0.70%) on 7.4% of spend.

Sessions by city · 12 months

Bengaluru is 9.0% of Indian sessions. Hyderabad, Mumbai and Delhi together send 2.6× Bengaluru. Eight metros = 45.9%. 7.4% of sessions come from outside India, led by 97,561 from the US.

Demographics · known audience, all time
FemaleMale

Known for only ~4% of impressions — a signal, not a target. 45–54 leads at 24.6%; men are 45.5%. That is why no asset group was restricted to women: festive jewellery here is often bought for women by men.

12

Attribution and the customer

Who is actually buying

Shopify can name the source of 3.4% of orders. That sliver is biased — and still points the same way as every other method in this study.

Known source
3.4%
708 of 21,015 orders
New customers
79.6%
14,534 new · 3,733 back
Month-1 repeat
12.6%
Decays to ~1% by month 6
Blended AOV
₹5,105
All orders
Google paid CVR
0.004%
7.26 L sessions → 26
kwikchat CVR
0.198%
55× Google paid
Referring channels with orders · sessions against orders
SessionsSessions, CVR <0.01%Orders

Separate scales — read the mismatch, not the heights.

New against returning
Google organic53,207 → 56₹19,996 AOV
Google paid7,26,105 → 26₹7,680 AOV
Instagram organic30,067 → 350.116%
Facebook paid5,35,757 → 370.007%
YouTube paid47,828 → 00 orders

An acquisition treadmill, not a retention business. Four in five customers are new, which is why reversals and first-order cost matter more here than anywhere.

13

What I got wrong

Seven calls, owned

A case study that only lists wins is a sales page. These are the decisions and readings that were wrong, what they cost, and how each was caught.

1

Raised the brand budget against my own spec

On 17 Aug I took Search | Brand | Bangalore from ₹2,000 to ₹3,100 a day. My AG04 spec, written the same day, said cap it at ₹150–200 — measured brand demand was about ₹64 a day. The surplus went into broad match buying non-brand clicks. The campaign was also on Smart Bidding, so the ₹12 ad-group caps did nothing: AG04 ran at ₹36.61.

Cost ₹57,249 at ₹2,408 CPA vs ₹36 on Brand_3juneCaught 24 Aug bid-strategy pre-flight
2

Let spend scale on an unverified value signal

August billing rose 143% while Stand_14Jan and Sales_PMax_CatchAll were reporting impossible value. CatchAll scaled 537% and Stand_14Jan 50% on numbers later shown to be defective. Only S_Tofu's scale-up was sound — its CPC fell to ₹4.67 on a 513% click increase.

Cost MER 19.61× → 9.82×Caught 1 Sep, daily per-campaign exports
3

Carried a false P0 through four documents

"33 lifetime add-to-cart events, purchase tracking broken" came from the original audit and went into the Stage 4 plans, the C04 walkthrough and the blended review. It was read off goal cards that only count primary actions. Add-to-cart fired 26,737 times. A Shopify pixel rebuild and a 7 Sep scaling hard-stop were both built on it.

Cost A week of gated decisionsCaught 2 Sep, reading the conversion actions directly
4

Misread a 100-row sample as a broken export

The top-100 search terms by cost showed zero conversions on every row. I read it as a bad export and drafted a blanket competitor exclusion. The full 5,05,231-term file showed those 70 competitor terms returning 112.5 conversions at ₹87 — among the cheapest in the account.

Cost None — reversed before it shippedCaught 1 Sep, full export
5

Linear-scaled a partial month

The first blended review scaled 17 days of July by 31/17. Returns post in one batch late in the month, so the first 17 days carry 66% of revenue, not 55%. July MER went out as 3.20× and was restated to 2.68× the same day.

Cost One wrong headline, restated in publicRule since Never linear-scale a month here
6

Dated the festive season wrong

The Festive & Gifting spec put Dhanteras on 26 Oct and Diwali on 28 Oct 2026. They fall on 6 and 8 November. The decision held — build early — but the runway was ten days longer than the spec claimed.

Cost None to spendCaught 27 Aug dashboard cross-check
7

Left remarketing running without a stop rule

C04 Demand Gen remarketing went live with a cart audience and three ads. By 2 Sep: ₹11,971, 3,118 clicks, zero purchases, and a second ad group already specced on the same foundation. The 92 view-through conversions argued for patience; the missing stop-or-continue date did not.

Cost ₹11,971Open at close All-conv check pending
Working rules that came out of it

Read the source, not the summary card. Conversion actions, not goal tiles. Full exports, not samples.

Verify the signal before scaling on it. Reconcile Google purchases to Shopify orders weekly; stop if Google claims more than 60%.

Restate in public. Every correction above is written into the document it corrects. Nothing silently fixed.

14

The plans handed over

Stages 3, 4 and 5 · the road to 100

Every plan reached the same conclusion from a different direction: media can add 25–45 orders a day, but the missing 43 sit in the cart.

Stage 4 · 50 Google orders a day by November
August actualNovember plan

Shopping falls from 83% of purchase spend to 17%; PMax rises from 3% to 64%. Purchase media ₹8.13 L → ₹13.34 L. Only ₹5.44 L is new money.

Base case · full budget66.8/day₹665 CPA
Downside · full budget47.1/day₹945 CPA
September gate30–39PMax CPA <₹600
October gate42–58+10 store orders
November47–6750 sustained 7d
Graded on two numbers, side by side
Google purchases/day23.0 → 50the commitment
Shopify orders/day62.9 → 79–89the truth
Blended MER2.85× → 2.9–3.4×floor 3.50×
Blended CAC₹1,549 → ₹1,190–1,410—

CatchAll CPA modelled as ₹217 × (spend ÷ ₹25,821)^k, k 0.35–0.50 — 2.9× to 4.6× degradation assumed, not a flat extrapolation.

Stage 5 · PMax Core Movers · the ramp

One campaign on the 478 movers across eight metros. Four asset groups: earrings 39.7% · kada 37.0% · rings 15.1% · men's brooch 8.2% of orders. Necklace excluded on 26.9% returns and a 1.09% page. Target ₹29,000/day → 25 orders base, 21 downside.

Stage 5 profit gate · ₹29,000/day, 25 orders/day

₹1,17,304 gross/day · ₹97,403 net of 17% returns · net ROAS 3.36×. Break-even at 30% gross margin. The margin figure was never supplied.

Cart→order rate against orders a day · traffic and spend held flat

1,43,983 sessions added to cart in a year; 1,23,133 left. At 25% cart→order the store does 98.6 orders a day on today's traffic.

Three routes to 100 a day
A · buy it3,042 orders/mo at ₹1,500–1,700 CAC₹45–52 L/mobreaks 3.50×
B · fix the cart14.5% → 25% cart→order₹0 media99/day
C · non-brand Search₹1,950/day at ₹300–500 CPA+4–7/dayefficiency layer
Call tracking · specced 28 Aug

PMax Store logged 90 clicks-to-call; the call details report returned no rows. Specced a split build: Google forwarding numbers stay on Search call assets, Exotel numbers go on GBP, website, Meta and offline. Caller number, duration and answer rate for every source.

Stage 3 · non-brand Search

₹800/day ramping to ₹1,950 by week 5. Wave 1: men's brooch, polki & jadau, earrings, kadas. Wave 2 adds rings — 2,549 units a year and no ad group anywhere in the account.

15

Handover

What stays open when I leave

Forty-two issues on the register at the August review. Sixteen were never marketing problems. Here is what the next owner inherits, ranked by money at stake.

Critical
10
Costs money now
High
14
Inside 30 days
Medium
13
This quarter
Low
4
Housekeeping
Account-side
26
Ads, feed, tracking
Business-side
16
Ops, finance, product
1

Attack the reversal rate

₹2.41 Cr a year, concentrated in one checkout and one product family. Get the monthly returns report and an RTO-versus-return split. Test prepaid incentives on the 40%+ pendant lines. Ask why fastrrv3 reverses at 3.6× the native checkout.

Owner Client opsAt stake ~₹5 L/month
2

Finish the tracking repair

Purchase CAPI out of Conversions. Add-to-cart set to no value. Local actions to Secondary, scoped to PMax Store. Enhanced Conversions on. One live test order, then a 7-day Google-vs-Shopify reconciliation. Only then set value to net of reversals.

Owner AccountAt stake Unblocks every bid strategy
3

Move money from Shopping to what works

Raise Sales_PMax_CatchAll in ≤50% steps — 96% of cap at 3.53 ROAS. Put Stand_14Jan (1.13 ROAS) on a 7-day review. Pause Brand Broad 01. Fund Bridal & Festive before 6 Nov.

Owner AccountAt stake ₹41,200/mo brand + ₹4.48 L reallocated
4

Clean the feed

Exclude 2,153 zero-stock variants. One rule defaults age_group, gender, color and releases 5,656 products. Custom labels 0–3 — mover, category, return band, price band — gate Stage 5 and Volume Core. Then the ≈₹50,000 negative list.

Owner AccountAt stake ₹1.80 L dead SKUs + ₹50k/month terms
5

Get the two numbers that decide everything

Gross margin by category — five numbers — and monthly Meta spend. Without margin, no campaign in this study can be called profitable. Without Meta, no blended MER after July exists. And move billing to auto-pay with a three-day balance alert: the account went dark twice in August.

Owner Client financeAt stake Healthy vs insolvent at the same revenue
The account at close · live structure
PMax | Store | Bangalore CoreStore 01 · Bridal 02 · Festive 03 · ₹1,500/dayLIVEmine
Search | Brand | BangaloreAG01–AG04 · ₹3,100/day · Brand Broad 01 to pauseFIXmine
Demand Gen | Remarketing C04AG01 Cart 0–7d · 3 ads · AG02 speccedREVIEWmine
S_Tofu_18july · Stand_14JanShopping · 64% of spendINHERITEDcut
Sales_PMax_CatchAllBest at scale · budget-limitedINHERITEDraise
Brand_3june · Demand Gen_15janBrand benchmark · cold prospectingINHERITEDkeep · cut
Data never received
COGS / gross margin by categorymissingasked 21 Aug
Meta spend, Aug–Sep 2026missingasked 21 Aug
Returns by reason, SKU, paymentmissing—
COD share · remittance days · stock valuemissing—
Checkout step eventsmissing—
Inventory buy plan Nov–Febmissing4.0 months cover

Blended review self-score at the last audit: 68/100 — data quality 72, insight 82, financial clarity 40, decision usefulness 78, actionability 68. One number, COGS, caps it.

The build was good — three new asset groups under ₹30 a conversion, a store campaign that out-produced 25 months in one. What held the account back was the measurement it was steered by, the checkout it sent people to, and two numbers nobody sent.