Danny Deepak
← All casesResort & eventsElectronic City, BengaluruActive

Gold Coins Club & Resort

Ad spend went up 3.2× in a quarter. Enquiries rose 46%. Bookings fell 13%.

24% → 14%

enquiry-to-booking conversion, Q2 to Q3 2026 Measured

Aqua rooms beside the water court at Gold Coins Club & Resort at dusk
Photo: goldcoinsresort.in (client)
5,621enquiries in the sales CRM, Jan–1 Oct
788bookings won (14%)
₹2.69 Crwon value, as quoted
₹14.3 Crpipeline still open
Level 1

The 60-second story

For the CEO. Read left to right.
  1. 1Problem

    Ad spend rose 3.2x from Q2 to Q3. Enquiries rose 46%. Bookings fell 13%.

  2. 2The leak

    Between enquiry and booking: conversion fell 24% to 14%, profile calls fell 55% May–Aug, and no booking is tied to any ad.

  3. 3How I found it

    Joined CRM, Meta, Google, GA4 and Business Profile by month, then compared quarters before reading any campaign.

  4. 4What I did

    45 Business Profile changes (28 Sep). Sales dashboard. 17 Oct: Search rebuilt to 10 ad groups, 49 negatives, Performance Max on real-lead goals.

  5. 5What changed

    Bookings not yet measurable. Found 52 of 55 Google 'conversions' were map taps: about ₹580 per real lead, not ₹95.

  6. 6Proof

    Sales CRM Jan–1 Oct, Meta and Google exports, GA4, Business Profile May–Oct (read 17 Oct), Google Ads 1–17 Oct.

  7. 7Lesson

    Spend did not cause the drop. Conversion stepped down in June and bookings stayed near 100 a month at any volume.

Level 2

The business first

Before any channel: what they sell, to whom, and how money comes in.
Business model
12-acre resort and events venue: rooms, day-outs, weddings, corporate offsites, celebrations, Sunday brunch. 59 rooms, 2,000-guest lawn.
Industry
Resort and events (hospitality)
Target customer
Families and friend groups within ~15 km (day-outs, rooms); office teams (offsites); couples and parents (weddings); parents (birthdays).
Persona
Bengaluru mobile searcher near Electronic City booking a day-out or room (96-97% of ad clicks on phones; 25-34 the largest known age band).
Geography
Andapura, Electronic City Phase II, Bengaluru 560100; 10 min from E-City.
Commercial objective
Turn existing demand into booked revenue; grow direct bookings and higher-ticket events (weddings, corporate).
How revenue is made
Day-out ticket from ₹1,499 per adult, rooms from ₹3,999 a night, catering from ₹1,199 a plate, quoted corporate and wedding packages. Quoted value logged in Sales CRM. No online payment.
How they convert
Phone, WhatsApp or web form enquiry logged in the Sales CRM, executive follow-up, quote, manual confirmation. No online booking or payment.
● AD SHOWROOMSee all 18 live Gold Coins ads on a phone and a laptop: Search, Performance Max, Meta →
01

What the customer sees: before and after

The same touchpoint on a phone, before my work and after it. Screens are schematic; every change and number comes from the account, the change log or the client report.

Searching "resort near Bangalore for day out"LiveMeasured
Before
Gold Coins Club & ResortResort hotel · 5,406 reviews
Categories
Resort hotel+3 more
Services
None listed
Sunday brunch
Hours not shown
Reviews
20 of the latest 100 unanswered, incl. five 1–2★
After
Gold Coins Club & ResortResort hotel · 5,406 reviews
Categories
Resort hotelConference centreSwimming poolBuffet restaurantAdventure sports
Services
17 services with descriptions and "from" prices
Sunday brunch
11:30 – 15:30
Reviews
All 20 answered, each specific to the guest
Posts
3 posts with tracked page links
  • 45 Business Profile changes, live 28 Sep 2026.
  • Four new categories were still in Google review when checked.
  • Booking impact is not measured yet: Jan–Sep is the baseline.
02

Where the money leaks: the journey

This business's own path from first search to revenue. Tap a stage for the five-step leak card: what was wrong, how I found it, the evidence, what changed, and after.

01Find on Maps and searchImprovedTop 10 on 2 of 14 target searches. Not listed on every event, venue and amenity Maps search. Profile had 0 services and 3 secondary categories.
Stage metricDirections 8,565 in Sep (full month), up from 4,913 in Apr MeasuredGold Coins Performance Dashboard (Business Profile Performance page read 17 Oct; Google Ads 1–17 Oct; PMax 17 Oct)
  1. 1 · What was wrong

    Top 10 on 2 of 14 target searches. Not listed on every event, venue and amenity Maps search. Profile had 0 services and 3 secondary categories.

  2. 2 · How I identified it

    Maps check of 11 searches against 20+ competitors within 20 km; Business Profile field audit.

  3. 3 · Evidence

    Top 10 on 2 of 14 target searches; not listed on 9 Maps searches (event, venue, amenity, broad resort) MeasuredGold Coins revenue audit v3 s14; Business Profile change log s05

  4. 4 · What changed

    4 categories, 17 priced services, brunch hours, 3 linked posts, 20 review replies. Categories in review, posts publishing at time of write-up.

  5. 5 · After

    Secondary categories 3 to 7; services 0 to 17. Rank not re-measured. MeasuredBusiness Profile change log s02 scorecard

02Click an adFlaggedPerformance Max bought 40,621 clicks at ₹1.04 (85% YouTube), 53% of Google spend landing on Google's own profile page. It reported 6,461 'conversions' that were taps. Meta ran 146 campaigns, 99 with no result.
Stage metric₹7.78L ad spend Jan-Sep (Meta ₹6.99L, Google ₹79.3k) MeasuredGold Coins marketing + sales dashboard Investment
  1. 1 · What was wrong

    Performance Max bought 40,621 clicks at ₹1.04 (85% YouTube), 53% of Google spend landing on Google's own profile page. It reported 6,461 'conversions' that were taps. Meta ran 146 campaigns, 99 with no result.

  2. 2 · How I identified it

    Google Ads landing, network and conversion-action reports; Meta campaign export.

  3. 3 · Evidence

    3 tracked leads on ₹79,321 Google spend (₹26.4k each) MeasuredGold Coins marketing + sales dashboard Google Ads

  4. 4 · What changed

    Plan: Meta to 4-5 always-on campaigns; wedding Search only after tracking fix; GA4 key events into Ads. Not yet live. 17 Oct: Search rebuilt (10 ad groups, 49 negatives); Performance Max relaunched counting only calls, WhatsApp and forms.

  5. 5 · After

    Data not availablePlanned for Q4; no post-28 Sep ad data

03Land on the websiteFlaggedEngagement per user fell 91 s (Jun) to 23 s (Sep) as ad traffic rose 5.4x in a month. Price calculator and WhatsApp clicks not set as key events. Mobile LCP 7.6 s (lab).
Stage metric1,086 users priced a day-out; 43 became tracked leads MeasuredGold Coins marketing + sales dashboard Website enquiry funnel
  1. 1 · What was wrong

    Engagement per user fell 91 s (Jun) to 23 s (Sep) as ad traffic rose 5.4x in a month. Price calculator and WhatsApp clicks not set as key events. Mobile LCP 7.6 s (lab).

  2. 2 · How I identified it

    GA4 monthly and weekly series; Lighthouse 12 lab run 25 Sep.

  3. 3 · Evidence

    Engagement 90.8 s Jun to 22.6 s Sep; users 3,798 to 20,962 MeasuredGold Coins marketing + sales dashboard MONTHS

  4. 4 · What changed

    GA4 key events being passed to Ads as primary conversions.

  5. 5 · After

    Data not availableNo post-28 Sep GA4 in sources

04Enquire (phone, WhatsApp, form)Flagged82% of enquiries are logged only as 'IVR'. Google and Business Profile are never recorded as a source.
Stage metric5,621 CRM enquiries Jan-1 Oct MeasuredGold Coins marketing + sales dashboard Sales CRM
  1. 1 · What was wrong

    82% of enquiries are logged only as 'IVR'. Google and Business Profile are never recorded as a source.

  2. 2 · How I identified it

    CRM source column read against Meta lead sheet and ad accounts.

  3. 3 · Evidence

    3 enquiries tagged Meta, 0 Google, of 5,621 MeasuredGold Coins marketing + sales dashboard Where enquiries come from

  4. 4 · What changed

    Dashboard joins CRM with ad and web data. 'How did you hear about us?' field recommended on every call and form.

  5. 5 · After

    Data not availableField not yet live in sources

05Follow up and closeFlaggedBookings held near 90-157 a month while enquiries ranged 272-812. One executive holds 57% of wins; another lost 702 of 1,362 leads.
Stage metricConversion 24% (Q2) to 14% (Q3); 788 bookings of 5,621 MeasuredGold Coins marketing + sales dashboard buildGrowth; Gold Coins marketing + sales dashboard
  1. 1 · What was wrong

    Bookings held near 90-157 a month while enquiries ranged 272-812. One executive holds 57% of wins; another lost 702 of 1,362 leads.

  2. 2 · How I identified it

    Monthly conversion against volume and spend; executive table (anonymised).

  3. 3 · Evidence

    Mar-Sep conversion vs enquiry volume r = -0.94 (n=7) CalculatedGold Coins marketing + sales dashboard SC arrays

  4. 4 · What changed

    Executive-level conversion view in the dashboard; pipeline plan set. No routing change yet (lead routing in build).

  5. 5 · After

    Data not availableNo post-28 Sep CRM beyond 1 Oct (33 enquiries, 9 won)

06Price and book directFlaggedSame room shows 55% cheaper on Yatra. No online booking or payment. Profile booking link got 2 clicks in 6 months against 4,785 website clicks.
Stage metricRoom ₹3,999 direct vs ₹1,780 via Yatra on Google Hotels MeasuredGold Coins revenue audit v3 s07-08
  1. 1 · What was wrong

    Same room shows 55% cheaper on Yatra. No online booking or payment. Profile booking link got 2 clicks in 6 months against 4,785 website clicks.

  2. 2 · How I identified it

    Google Hotels and reseller checks, 25 Sep, 3-4 Oct stay.

  3. 3 · Evidence

    Yatra ₹1,780 vs direct ₹3,999 (-55%); day-out BanBanjara ₹1,260 vs ₹1,499 (-16%) MeasuredGold Coins revenue audit v3 s08

  4. 4 · What changed

    Parity flagged; one rate card proposed; booking engine and gateway in build.

  5. 5 · After

    Data not availableWith management; contracts and commissions not shared

07Stay and reviewNot marketingRating held down by food service delays, waiters at events, approach road, price vs room size.
Stage metric3.9 stars on 5,413 reviews; 720 one- and two-star MeasuredBusiness Profile change log cover; Gold Coins revenue audit v3 s13
  1. 1 · What was wrong

    Rating held down by food service delays, waiters at events, approach road, price vs room size.

  2. 2 · How I identified it

    Review theme read, latest 100 and all-time mix.

  3. 3 · Evidence

    1-2 star = 720 reviews (13%) MeasuredGold Coins revenue audit v3 s13

  4. 4 · What changed

    Replied to all 20 unanswered reviews (latest 100 now 100% replied, was 80%). Service fixes sit with operations.

  5. 5 · After

    Reply rate 80% to 100% (latest 100) MeasuredBusiness Profile change log s02

08MeasureImprovedCost, enquiry, booking and revenue sat in five unconnected sources with different start dates.
Stage metric0 bookings tied to an ad MeasuredGold Coins marketing + sales dashboard Where the next ₹of growth is
  1. 1 · What was wrong

    Cost, enquiry, booking and revenue sat in five unconnected sources with different start dates.

  2. 2 · How I identified it

    Data coverage map by month.

  3. 3 · Evidence

    5 sources, 5 different start dates (CRM Jan, Meta Jan, GBP Apr, GA4 24 May, GSC 7 Sep) MeasuredGold Coins marketing + sales dashboard What was tracked, and when

  4. 4 · What changed

    One marketing + sales dashboard built over all of them.

  5. 5 · After

    1 dashboard over 6 sources MeasuredGold Coins marketing + sales dashboard header

03

Before, what I found, action, after

Verified numbers only. Where an after number does not exist yet, it says so.

Secondary Business Profile categories
Before3 MeasuredBusiness Profile change log s02
What I found

Primary right (Resort hotel); no Conference, Pool, Buffet or Adventure categories.

Action

Added 4 categories; 8 of 10 slots used.

After7 (in Google review) MeasuredBusiness Profile change log s02
Priced services on the profile
Before0 MeasuredBusiness Profile change log s02
What I found

Services tab empty.

Action

17 keyword-led services with descriptions and 'from' prices.

After17 live MeasuredBusiness Profile change log s01
Review reply rate, latest 100
Before80% MeasuredBusiness Profile change log s02
What I found

Templated replies; 20 unanswered including five 1-2 star.

Action

Replied to all 20, each specific to the guest.

After100% MeasuredBusiness Profile change log s02
Joined reporting views
Before0 views joining spend, enquiries and bookings MeasuredGold Coins marketing + sales dashboard coverage
What I found

CRM, Meta, Google, GA4, GBP and Search Console unconnected.

Action

Built marketing + sales dashboard.

After1 dashboard, 6 sources MeasuredGold Coins marketing + sales dashboard header
Profile calls per month (baseline)
Before1,612 (May) to 721 (Aug); 797 in Sep MeasuredGold Coins Performance Dashboard (Business Profile Performance page read 17 Oct; Google Ads 1–17 Oct; PMax 17 Oct)
What I found

Calls fell every month May to Aug while directions rose. September recovered slightly once Google ads restarted.

Action

Phone-line test and WhatsApp routing specced; profile rebuilt.

AfterData not availableDay-30 re-check not yet due
Search ad groups
Before5 (2 with zero clicks) MeasuredGold Coins Performance Dashboard (Business Profile Performance page read 17 Oct; Google Ads 1–17 Oct; PMax 17 Oct)
What I found

Brand searches were caught by generic groups at up to ₹23 a click (₹724).

Action

Rebuilt to 10 ad groups, one responsive ad each, 15 headlines; Brand and Resorts Near Me added.

After10 ad groups live 17 Oct MeasuredGold Coins Performance Dashboard (Business Profile Performance page read 17 Oct; Google Ads 1–17 Oct; PMax 17 Oct)
Negative keywords
Before0; ₹1,614 (31% of spend) on searches like "fun world" and "wonderla" MeasuredGold Coins Performance Dashboard (Business Profile Performance page read 17 Oct; Google Ads 1–17 Oct; PMax 17 Oct)
What I found

Ads showed for other attractions, city hotels and rival resorts.

Action

Added 49 negatives in four themes.

After49 live 17 Oct; spend effect not yet measured MeasuredGold Coins Performance Dashboard (Business Profile Performance page read 17 Oct; Google Ads 1–17 Oct; PMax 17 Oct)
What Google counts as a conversion
Before55 reported, 52 of them map Directions taps MeasuredGold Coins Performance Dashboard (Business Profile Performance page read 17 Oct; Google Ads 1–17 Oct; PMax 17 Oct)
What I found

Real leads were about 9 (5 WhatsApp, 4 calls): ₹580 each, not ₹95.

Action

Performance Max counts only calls, WhatsApp, forms. Search switch recommended.

AfterPMax on real leads; Search switch awaiting the owner's yes MeasuredGold Coins Performance Dashboard (Business Profile Performance page read 17 Oct; Google Ads 1–17 Oct; PMax 17 Oct)
04

From digital to revenue: the strongest verified chain

Verified for 2 of 7 links. The chain breaks at “Enquiries tagged to an ad”, so revenue attribution is unavailable beyond that point.

Ad spend, Jan-Sep (Meta + Google, ex-GST)₹7.78LMeasuredGold Coins marketing + sales dashboard Investment
Enquiries logged in Sales CRM (all channels)5,621MeasuredGold Coins marketing + sales dashboard Sales CRM
Enquiries tagged to an adChain breaks hereData not availableGold Coins marketing + sales dashboard Where enquiries come from
Bookings won (all channels)788 (14.0% of enquiries; 19.5% in Mar-Sep tracked months)CalculatedGold Coins marketing + sales dashboard; Gold Coins marketing + sales dashboard SC
Booking value won, as quoted₹2.69CrMeasuredGold Coins marketing + sales dashboard Won value
Booking value by channelChain breaks hereData not availableCRM has no source field for ads
Invoiced revenue and marginChain breaks hereData not availableNot shared
05

What the history shows

Patterns found by re-reading the full history, not just the months I ran. Each is labelled: measured pattern, correlation, anomaly or seasonality.

Measured pattern

55 Google "conversions", about 9 real leads

Map "Directions" taps were set as a main conversion, so Google bid for people who wanted directions, not a booking. Searches like "fun world bangalore timings" showed up as conversions.

The numbers

1–17 Oct Search: 3,782 impressions, 599 clicks (15.84% CTR), ₹5,229, 55 conversions of which 52 Directions. Real leads ≈9 (5 WhatsApp + 4 click-to-call). ₹95.07 per reported conversion vs ≈₹580 per real lead. GA4 phone_click has never fired.

So whatJudge Google on calls, WhatsApp and forms. Keep Directions as secondary. Fix website call tracking before reading any cost per lead.

Measured pattern

Fewer people see the profile, more of them act

Profile views and search appearances fell year on year, but actions rose, so each view works harder. Almost all views are on a phone, mostly Google Maps.

The numbers

May–Sep 2026 vs 2025: actions +11.0%, directions +12.5%, calls +15.1%, views −30.5%, search appearances −47.1%. Actions per 100 views, Sep: 10.8 (2025) to 15.3 (2026). 414,975 views 1 May–11 Oct, 93.5% on phone; Maps mobile 74.8%. Menu views 0 every month; 2 booking clicks.

So whatThe phone Maps listing is the shop window. Visibility is the falling number: photos, weekly posts, a menu and a booking link come before more ad spend. Most of this period is before my changes (28 Sep), so it is a baseline, not a result.

Anomaly

January: 1,033 enquiries on ₹15k of ads

Jan was the biggest enquiry month of the year on the smallest ad spend of the first half. Q1 brought 84% of Q3's enquiries on 9.5% of Q3's spend. Each extra enquiry has cost more as spend rose, and Meta lead cost climbed from June to September.

The numbers

Jan 1,033 enq (18.5% of 5,588), spend ₹14,959. Q1 1,862 enq / ₹52,766 (₹28 each); Q2 1,512 / ₹1,72,419 (₹114); Q3 2,214 / ₹5,53,134 (₹250). Extra spend per extra enquiry: Q2 to Q3 ₹542; Q1 to Q3 ₹1,421. Correlation of spend with enquiries: r 0.22 (Jan-Sep), 0.61 (Mar-Sep). Meta cost per dated lead: Jun ₹131, Jul ₹635, Aug ₹311, Sep ₹1,070; Aug to Sep Meta spend +81% (₹85,733), leads 340 to 179. Aug to Sep total spend +98%, enquiries -5% (720 to 682), GA4 users 3,872 to 20,962.

So whatDemand was already there before the ads scaled. Find what January was (season, group bookings or a CRM backfill; no 2025 data to test) before reading Q3 as growth. Judge spend on cost per booking once source is tagged. Meta spend is booked at campaign end month, so monthly CPL is rough.

Correlation, not causation

Conversion fell in June, before the spend jump, then flat-lined

Conversion dropped from 32% in May to 20% in June on ₹20.9k of spend, a month before Google Ads began. Jul-Sep sat at 14-15% while spend ranged ₹1.15L-2.28L. Bookings stayed 90-157 a month while enquiries ranged 272-812, so conversion follows volume, not spend. The 14% headline also counts Jan-Feb enquiries that have no status.

The numbers

Conversion Mar 33.1, Apr 24.3, May 32.4, Jun 20.3, Jul 14.9, Aug 14.4, Sep 14.1%. Bookings 90/157/94/117/121/104/96. r(conversion, enquiries) -0.94; r(conversion, spend) -0.68 (n=7). Each extra 100 enquiries added about 5 bookings (slope 0.054). 788/5,621 = 14.0%; Mar-Sep 779/3,998 = 19.5%. June also lost enquiry type on 565 of 575 rows and Meta lead sheet starts that month.

So whatExtra leads were absorbed without extra bookings: look at response speed, routing and capacity before adding spend. Report conversion on tracked months only. Check whether June's CRM or lead-sheet change altered what counts as an enquiry.

Correlation, not causation

Calls fell May to August; ads did not lift Maps

Calls per direction request fell from 28% in April to 9% in September. Calls fell 55% from May to August, before and during the first Google ads, and only recovered 11% in September. Google's own store report credits 18% of Jul–Sep directions to ads. The profile sent thousands of website clicks but only 2 booking-link clicks. An earlier read of September was a part month and has been corrected.

The numbers

Calls/directions Apr 27.9%, May 23.6%, Jun 16.7%, Jul 13.3%, Aug 9.9%, Sep 9.3%. Google spend Jul/Aug/Sep ₹33,001/9,362/36,941; directions 7,538/7,303/8,565; calls 1,004/721/797 (full months, read 17 Oct). Ads store report 4,087 directions of 22,199 (18.4%), 224 store visits, Jul–Sep.

So whatCall loss is not a demand or ad-spend problem. Test the phone line, turn on chat routed to WhatsApp, and judge Performance Max on enquiries, not taps. A booking engine link would give the profile a booking path that is not a reseller.

Measured pattern

Revenue follows ticket size; Meta money sits away from where CRM enquiries sit

Average booking ranged ₹16.6k to ₹57.7k by month, so won value moves with ticket mix, not booking count. July was 45% of Q3 value; July to September ticket fell 20% and bookings 21%. Sales wins 32% of closed leads by count but 68% by value, because lost leads are small. Meta put 63% of spend on corporate and weddings; the CRM types those as 2.4% of enquiries.

The numbers

Avg booking Mar ₹57,710; Apr 24,514; May 16,634; Jun 21,270; Jul 50,534; Aug 35,638; Sep 40,506. Jul ₹61.1L of Q3 ₹1.37Cr. Aug to Sep: spend +98%, bookings -8%, value +5%, value per ad rupee 32.2x to 17.0x. Won 788 vs lost 1,657 (32%); won ₹2.69Cr vs lost ₹1.27Cr (68%); avg won ₹34.1k, avg lost ₹7.7k. Meta: corporate ₹2,47,530 + wedding ₹1,92,519 = 63% of ₹6,99,015; rooms + day-outs ₹33,259 (4.8%). CRM types: rooms + day-outs 3,599 (64%), corporate 54 + wedding 82 = 136 (2.4%); 884 untyped. Meta sheet leads: corporate 308, wedding 221, birthday 407 vs CRM-typed 54, 82, 154.

So whatJudge months on value and cost per booking by product. The CRM types look incomplete (June, 884 untyped), so reconcile the Meta lead sheet to the CRM before moving budget by product. Value by enquiry type is not in the sources.

Measured pattern

One executive is 57% of wins and 57% of open pipeline value

Exec. A handles 28% of leads and books 57% of wins. Win rate on closed leads runs 58% for Exec. A and 14% for Exec. D, who lost 702 of 1,362 leads (42% of all lost). Exec. H has 0 wins from 450 leads. 13 February birthday rows hold 43% of open value. Opens carry no value on 158 leads.

The numbers

Exec. A 1,567 handled (28.5%), 447 won (56.7%), ₹1.22Cr won (45%), open ₹8.13Cr (57% of ₹14.29Cr). Closed-lead win rate: GM 75%, A 58%, F 50%, E 43%, B 40%, C 23%, G 15%, D 14%, H 0%. A+B+D = 71% of leads, 85% of wins. Exec. E: 18 wins at ₹1.35L average, 158 of 200 open with ₹0 value. Open 2,609 = 46% of enquiries; 567 have no status. 13 rows ₹6.2Cr (₹47.7L each) leaves clean open pipeline near ₹8.1Cr. If D matched A's 28.5%: +272 wins, about ₹79L at D's ₹29.2k ticket (assumes equal lead quality).

So whatRouting and hygiene, not media: rebalance load, review the D and H queues, quote or close the ₹0 opens, delete typo rows. One person is a single point of failure for most bookings. Lead assignment rules are not in the sources.

Not a marketing problem

What the data shows ads cannot fix. Saying so early saves budget.

  • Follow-up: bookings stay near 100 a month at any volume; conversion 33% (Mar) to 14% (Sep). Exec. D lost 702 of 1,362 leads; Exec. H won 0 of 450.
  • Pipeline hygiene: 13 birthday rows carry ₹6.2Cr (43% of open value); 567 enquiries have no status; 158 open leads carry ₹0.
  • Rate parity: room ₹1,780 on Yatra vs ₹3,999 direct (-55%); day-out ₹1,260 vs ₹1,499. Contracts and commissions not shared.
  • Rating 3.9 stars held down by food service delays, event waiters, approach road, price vs room size; 720 one- and two-star reviews.
  • Review risk: about 24 of the latest 100 five-star reviews come from accounts with 0-1 reviews; stop any incentivised practice. Management decision.
  • No online booking or payment; Google Hotels shows reseller prices, not the official site.
  • Business name has lowercase 'bangalore' and address line is 96 characters; change needs someone present for video verification (owner call).

Data not available

What would prove more, and does not exist in the sources yet.

  • Enquiry source by channel (82% logged 'IVR'; 3 Meta, 0 Google).
  • Lead timestamps, first-response time, call-answer or missed-call logs, assignment rules.
  • Won value and bookings by enquiry type and by executive per month; which executive holds the 13 February birthday rows.
  • Any 2025 or earlier data: nothing before Jan 2026, so January's spike cannot be tested for seasonality or CRM backfill.
  • Business Profile Jan-Mar 2026 (18 months retained but only Apr-Sep pulled); mid-month values read from a chart, rounded to 10.
  • Daily Meta spend: monthly figures sit in each campaign's end month, so monthly cost ratios swing.
  • Meta lead sheet matched to CRM rows (1,194 unique leads; 237 undated; 13 marked won).
  • Why all Google ads stopped 17 Aug-6 Sep and what Meta did in those weeks.
  • What changed in the CRM or lead sheet in June (565 of 575 untyped; Meta sheet starts).
  • OTA share of revenue, commissions, net rates, direct vs OTA bookings; invoiced revenue and margin.
  • Results of the 17 Oct Search rebuild and Performance Max launch: still in the learning period.
  • Which CRM bookings came from the ≈9 Google leads of 1–17 Oct.
  • Star rating and review count over time (not in the Business Profile Performance report).
Level 3

Implementation and data

For the team that has to run it: every action, test, date and dataset.
06

What I actually did

23 actions found in the project evidence, 11 done or live. Grouped by type, each with its source.

Google Business Profile 6

  • Done

    Accepted Business Profile manager access; audited every field against 11 Maps searches and 20+ competitors

    Business Profile change log s01, s05
  • In testing

    Added 4 categories (Conference Centre, Swimming pool, Buffet restaurant, Adventure Sports Center)

    Business Profile change log s01 (in review)
  • Live

    Added 17 keyword-led services with descriptions and from-prices

    Business Profile change log s01
  • Live

    Added Sunday brunch hours 11:30-15:30

    Business Profile change log s01
  • Live

    Replied to all 20 unanswered reviews in the latest 100

    Business Profile change log s01
  • In testing

    Published 3 posts on new topics with page links and UTM tags

    Business Profile change log s01 (publishing)

Tracking 3

  • In testing

    Passing GA4 key events into Google Ads as primary conversions

    earlier portfolio notes journey Website (in progress)
  • Specced

    Switch the Search primary conversion from Directions to calls, WhatsApp and lead form

    Gold Coins Performance Dashboard (Business Profile Performance page read 17 Oct; Google Ads 1–17 Oct; PMax 17 Oct) (needs owner approval)
  • Specced

    Fix the GA4 phone_click event (never fired), add a profile menu (0 views) and a booking link (2 clicks)

    Gold Coins Performance Dashboard (Business Profile Performance page read 17 Oct; Google Ads 1–17 Oct; PMax 17 Oct)

Paid media 3

  • Live

    Added 49 negative keywords in four themes (amusement parks, city hotels, other resorts, irrelevant)

    Gold Coins Performance Dashboard (Business Profile Performance page read 17 Oct; Google Ads 1–17 Oct; PMax 17 Oct)
  • Live

    Added 7 resort photos (13 crops), 8 callouts, an amenities snippet; fixed the "Weeding" sitelink

    Gold Coins Performance Dashboard (Business Profile Performance page read 17 Oct; Google Ads 1–17 Oct; PMax 17 Oct)
  • In testing

    Launched Performance Max (5 asset groups, 7 official videos, AI text and images off) counting only calls, WhatsApp, forms

    Gold Coins Performance Dashboard (Business Profile Performance page read 17 Oct; Google Ads 1–17 Oct; PMax 17 Oct)

Strategy 2

  • Done

    Revenue audit v3: 25 sections on leaks, pricing, OTA, tracking, 90-day plan

    Gold Coins revenue audit v3
  • Handed over

    Rate-parity control: one rate card, channel manager, weekly Google Hotels check

    Gold Coins revenue audit v3 s08 (with management)

Dashboard 2

  • Live

    Built marketing + sales dashboard joining CRM, Meta, Google Ads, GA4, Search Console, Business Profile

    Gold Coins marketing + sales dashboard; earlier portfolio notes extra
  • Done

    Performance dashboard for the owner: Business Profile, Search and PMax, with every ad drawn on phone and laptop

    Gold Coins Performance Dashboard (Business Profile Performance page read 17 Oct; Google Ads 1–17 Oct; PMax 17 Oct)

Campaign restructure 2

  • Specced

    Meta restructure to 4-5 always-on lead campaigns; wedding Search after tracking fix

    earlier portfolio notes journey Ads (planned Q4)
  • Live

    Rebuilt the Search campaign: 5 to 10 ad groups (Brand, Resorts Near Me and three more new), one responsive ad each with 15 headlines

    Gold Coins Performance Dashboard (Business Profile Performance page read 17 Oct; Google Ads 1–17 Oct; PMax 17 Oct)

SEO 1

  • Done

    Built keyword map: 11 service clusters to landing pages

    Business Profile change log s07

CRM 1

  • Specced

    Recommended 'How did you hear about us?' field on every call and form

    Gold Coins marketing + sales dashboard Data issues

Call tracking 1

  • Specced

    Phone-line test at 11 AM, 4 PM, 8 PM on a Saturday; second number or WhatsApp-routed chat

    Business Profile change log s09

WhatsApp 1

  • Specced

    Review engine: QR cards and WhatsApp review link after every visit

    Business Profile change log s09

Booking system 1

  • Specced

    Website, booking + payment gateway, CRM lead routing, guest app (in build)

    earlier portfolio notes extra built list
Stated by Danny

In build now. Not yet in the project evidence, so no result is claimed.

  • WebsiteFaster pages for rooms, day-outs, weddings and corporate.
  • Booking + payment gatewayBook and pay direct for rooms and day-outs.
  • CRM + lead routingEvery lead to the right executive's WhatsApp in five minutes.
  • Guest appBookings, offers and repeat visits in one app.
07

Tests and what they taught

Not every test worked. Each one changed the next decision.

  1. Hypothesis

    Counting Directions as a conversion makes Google buy map taps, not enquiries

  2. Action

    Read conversion actions and search terms for 1–17 Oct

  3. Result

    Supported: 52 of 55 conversions were Directions; real leads ≈9; ₹1,614 went to other attractions

  4. Learning

    The bidding goal decides who Google brings. Fix the goal before the budget.

  5. Next decision

    Switch primary conversions (owner yes needed); compare cost per real lead after 14 days.

  1. Hypothesis

    Performance Max on real-lead goals gets enquiries cheaper than Search on taps

  2. Action

    Launched 17 Oct with 5 asset groups and calls, WhatsApp, forms as goals

  3. Result

    In the learning period; no results yet

  4. Learning

    None yet.

  5. Next decision

    Read after two weeks; no edits during learning unless something breaks.

  1. Hypothesis

    Google Ads lifted Maps directions and calls

  2. Action

    Compared Jul/Aug/Sep Google spend with profile actions (full months)

  3. Result

    Weak at best. Directions 7,538/7,303/8,565 on spend ₹33k/9k/37k; calls fell May–Aug in ad and no-ad months.

  4. Learning

    Ads credit 18% of directions; most Maps demand is not paid.

  5. Next decision

    Judge ads on enquiries, not taps.

  1. Hypothesis

    Rising ad spend caused the conversion drop

  2. Action

    Plotted monthly conversion against spend and volume, Mar-Sep

  3. Result

    Not supported. Drop began in June on ₹20.9k; Jul-Sep flat at 14-15% across ₹1.15L-2.28L; r -0.94 with enquiry volume.

  4. Learning

    Look at follow-up capacity and CRM changes, not ad quality.

  5. Next decision

    Measure first-response time and executive queues before changing budgets.

  1. Hypothesis

    The profile phone line goes unanswered at peak

  2. Action

    Mystery-shop 11 AM, 4 PM, 8 PM on a Saturday

  3. Result

    Not run as of 1 Oct.

  4. Learning

    None yet.

  5. Next decision

    Run this week; add second number or WhatsApp-routed chat if it rings out.

  1. Hypothesis

    Maps ads on 'banquet hall' and 'conference hall electronic city' win searches the profile cannot

  2. Action

    ₹500/day Search campaign with location assets (week 3)

  3. Result

    Not started.

  4. Learning

    None yet.

  5. Next decision

    Run after profile re-check; compare cost per enquiry.

08

Timeline: interventions and events

My actions sit alongside what the client, the previous team and the market did. Nothing here claims a cause.

  1. Client

    Sales CRM records start: 1,033 enquiries in January on ₹14,959 of ads

    Gold Coins marketing + sales dashboard Timeline
  2. Client

    Booking status first recorded (Jan-Feb show no bookings; dashboard says tracking likely started in March)

    Gold Coins marketing + sales dashboard Enquiries and bookings
  3. Previous team

    Google Ads account created

    Gold Coins marketing + sales dashboard Timeline
  4. Previous team

    GA4 tracking starts on the website

    Gold Coins marketing + sales dashboard Timeline
  5. Client

    Meta lead sheet starts; CRM enquiry type missing for 565 of 575 enquiries; conversion drops 32% to 20%

    Gold Coins marketing + sales dashboard Data issues; client monthly history
  6. Previous team

    First Google ads: Day-Out Search and Performance Max

    Gold Coins marketing + sales dashboard Timeline
  7. Previous team

    Google Ads stop for three weeks (dashboard says 'all ads stop')

    Gold Coins marketing + sales dashboard Timeline; Gold Coins marketing + sales dashboard SPEND_W
  8. Previous team

    New website goes live; ads restart with a YouTube-heavy burst

    Gold Coins marketing + sales dashboard Timeline
  9. Danny

    Revenue audit v3 begins (public-data snapshot 25-26 Sep)

    Gold Coins revenue audit v3 cover
  10. DannyI join

    Engagement starts. 45 Business Profile changes live or in review. Google Ads funds run out; nothing serving.

    User brief; Business Profile change log s01; Gold Coins marketing + sales dashboard Timeline
  11. Danny

    Marketing + sales dashboard live; data cut-off. Oct holds 1 day: 33 enquiries, 9 won.

    client monthly history caveats; user brief
  12. Danny

    Google Ads read for 1–17 Oct: 599 clicks, ₹5,229, 55 "conversions" (52 Directions), ≈9 real leads

    Gold Coins Performance Dashboard (Business Profile Performance page read 17 Oct; Google Ads 1–17 Oct; PMax 17 Oct)
  13. Danny

    Search rebuilt (10 ad groups, 49 negatives, photos, callouts). Performance Max launched on real-lead goals. Dashboard delivered.

    Gold Coins Performance Dashboard (Business Profile Performance page read 17 Oct; Google Ads 1–17 Oct; PMax 17 Oct)
09

The data, month by month

CRM next to the ad accounts, quarter against quarter, before looking at a single campaign.

Nine months of enquiries

Sales CRM, Jan–Sep 2026: 5,588 enquiries. Booking status recorded from March. Measured

More money, more enquiries, fewer bookings

Q3 vs Q2. Bigger bookings, fewer of them. Measured

Conversion halved as spend rose

Bookings ÷ enquiries by month. Mar–Jun 25.7%, Jul–Sep 14.5%. All before my work. Calculated

Ad spend by month

Meta + Google, ₹ thousand. ₹7.78 L Jan–Sep. Meta booked in the month a campaign ended. Measured

One executive books 57% of all wins

Won ÷ handled, Jan–1 Oct. Names withheld. Two others hold ₹4.6 Cr of open pipeline. Calculated

People still come. They stopped calling.

DirectionsCallsWebsite

Business Profile actions, full months (read 17 Oct). Calls 1,612 in May → 721 in August, 797 in September. Measured

The same room, cheaper on an OTA

3–4 Oct stay, captured 25 Sep. Direct prices ex-GST. Measured

10

What I'd do next

SourcesGold Coins sales CRM (read 1 Oct 2026), Meta Ads Manager Jan–1 Oct and lead sheet, Google Ads 13 Jul–1 Oct, GA4 from 24 May, Search Console, Business Profile Apr–Oct (Performance page read 17 Oct), Google Ads 1–17 Oct, Google Hotels and reseller listings (25 Sep), Maps rank checks (26–28 Sep). Sales executives are not named.Evidence labels: Measured, Calculated, Estimated, Assumption, Data not available.

Work with me

Seen a leak in your own numbers?

Send me the symptom. I'll tell you which case is closest and what I'd check first. No deck, no retainer pitch.

danieldeepak3519@gmail.comLinkedInFree 12-point check