Tableau Wireframe · As of 19 Mar 2026, 12:36 pm
Viewing as Sachin Jadhav

Digital Dashboard

Tableau · Ad Performance + Campaign Drilldown · Salesforce CRM + Meta Ads + Google Ads

Refresh | Edit
Date · Source · Campaign · Media Buy · Launch · Project

Date:

→

Source:

Campaign:

Media Buy:

Launch:

Project:

Digital Lead Performance · Ad Performance TABLEAU · SCORECARD SHEET · Salesforce CRM + Meta Ads + Google Ads

Impressions

Meta + Google

Clicks

Meta + Google

Sessions

Website / GA4

Session Rate

--%

Sessions ÷ Clicks

CTR

--%

Clicks ÷ Impressions

CPC

₹ --

Spend ÷ Clicks

CPM

₹ --

Spend ÷ Impr × 1000

Lead Rate

--%

Leads ÷ Clicks

Leads

13,165

View Report (Hourly LTD)

OTP Leads

3,449

26.2% of total leads

Non-OTP DB Leads

9,716

73.8% of total leads

No. of App

158

View Report (APP Internal)

BA2 (Bookings)

View Report (Opportunity)

No. of VC Done

1,343

View Report (Digital VC Done)

Lead → VC Conv. Rate

10.2%

VC Done ÷ Leads

Campaign Analysis — Drilldown Pivot: Source → Campaign → Ad Group → Creative TABLEAU · DRILLDOWN PIVOT · Google Ads + Meta Ads + Salesforce CRM · Date from top filter

Drill Level: WoW = vs prior week · DoD = vs prior day

All Campaigns · All-in & Media Spend / Impr / Clicks / Sessions / CTR / CPC / CPM · Leads · VC · App · BA2 · OTP · WoW / DoD Drilldown Pivot · Tableau

Source / Campaign / Ad Group / Creative	Platform	Media Buy	Ads / Media Metrics								Leads			VC			App			Revenue			OTP Split		Trend
Source / Campaign / Ad Group / Creative	Platform	Media Buy	All-in Spend (₹)	Media Spend (₹)	Impr.	Clicks	Sessions	CTR %	CPC (₹)	CPM (₹)	Leads	CPL (₹)	Lead Rate %	VC	Cost/VC (₹)	VC Rate %	App	CPAPP (₹)	App Rate %	BA2	GTN %	Revenue (₹)	OTP	Non-OTP	WoW %	DoD %
Google	Google	Paid	--	--	--	--	--	--%	--	--	2,037	--	--%	131	--	6.4%	34	--	--%	--	--%	--	~534	~1,503	▲ 12%	▼ 4%
Demand Gen	Google	Paid	--	--	--	--	--	--%	--	--	801	--	--%	~80	--	10.0%	~22	--	--%	--	--%	--	~210	~591	▲ 9%	▲ 2%
above_1cr	Google	Paid	--	--	--	--	--	--%	--	--	--	--	--%	174	--	--%	--	--	--%	--	--%	--	--	--	--	--
Creative A — Video 30s	Google	Paid	--	--	--	--	--	--%	--	--	--	--	--%	--	--	--%	--	--	--%	--	--%	--	--	--	--	--
Creative B — Static Image	Google	Paid	--	--	--	--	--	--%	--	--	--	--	--%	--	--	--%	--	--	--%	--	--%	--	--	--	--	--
asc_signals	Google	Paid	--	--	--	--	--	--%	--	--	--	--	--%	1	--	--%	--	--	--%	--	--%	--	--	--	--	--
Creative A — Carousel	Google	Paid	--	--	--	--	--	--%	--	--	--	--	--%	--	--	--%	--	--	--%	--	--%	--	--	--	--	--
feature	Google	Paid	--	--	--	--	--	--%	--	--	--	--	--%	1	--	--%	--	--	--%	--	--%	--	--	--	--	--
Creative A — Video 15s	Google	Paid	--	--	--	--	--	--%	--	--	--	--	--%	--	--	--%	--	--	--%	--	--%	--	--	--	--	--
Direct Website	Google	Paid	--	--	--	--	--	--%	--	--	422	--	--%	~51	--	12.1%	~12	--	--%	--	--%	--	~111	~311	▲ 15%	▲ 6%
DirectWebsite	Google	Paid	--	--	--	--	--	--%	--	--	--	--	--%	4	--	--%	45	--	--%	--	--%	--	--	--	--	--
Creative A — Responsive Search	Google	Paid	--	--	--	--	--	--%	--	--	--	--	--%	--	--	--%	--	--	--%	--	--%	--	--	--	--	--
Search	Google	Paid	--	--	--	--	--	--%	--	--	424	--	--%	--	--	--%	--	--	--%	--	--%	--	~111	~313	▼ 3%	▬ 0%
brand	Google	Paid	--	--	--	--	--	--%	--	--	--	--	--%	--	--	--%	--	--	--%	--	--%	--	--	--	--	--
hoabl [Exact]	Google	Paid	--	--	--	--	--	--%	--	--	--	--	--%	--	--	--%	--	--	--%	--	--%	--	--	--	--	--
Buy	Google	Paid	--	--	--	--	--	--%	--	--	--	--	--%	2	--	--%	2	--	--%	--	--%	--	--	--	--	--
buy plot in bangalore [Broad]	Google	Paid	--	--	--	--	--	--%	--	--	--	--	--%	--	--	--%	--	--	--%	--	--%	--	--	--	--	--
Pay2 / Lookalike	Google	Paid	--	--	--	--	--	--%	--	--	390	--	--%	--	--	--%	--	--	--%	--	--%	--	~102	~288	▲ 7%	▼ 2%
Pay2 Main Ad Group	Google	Paid	--	--	--	--	--	--%	--	--	--	--	--%	--	--	--%	--	--	--%	--	--%	--	--	--	--	--
Creative A — Lookalike Banner	Google	Paid	--	--	--	--	--	--%	--	--	--	--	--%	--	--	--%	--	--	--%	--	--%	--	--	--	--	--
Meta	Meta	Paid	--	--	--	--	--	--%	--	--	497	--	--%	44	--	8.9%	14	--	--%	--	--%	--	~130	~367	▼ 8%	▲ 3%
Meta-interest	Meta	Paid	--	--	--	--	--	--%	--	--	442	--	--%	~36	--	8.1%	~12	--	--%	--	--%	--	~116	~326	▼ 6%	▲ 4%
fb-agr-designations	Meta	Paid	--	--	--	--	--	--%	--	--	--	--	--%	--	--	--%	4	--	--%	--	--%	--	--	--	--	--
Creative A — Image Ad	Meta	Paid	--	--	--	--	--	--%	--	--	--	--	--%	--	--	--%	--	--	--%	--	--%	--	--	--	--	--
Creative B — Video Reel	Meta	Paid	--	--	--	--	--	--%	--	--	--	--	--%	--	--	--%	--	--	--%	--	--%	--	--	--	--	--
Remarketing	Meta	Paid	--	--	--	--	--	--%	--	--	55	--	--%	~8	--	14.5%	~2	--	--%	--	--%	--	~14	~41	▲ 5%	▬ 0%
custom	Meta	Paid	--	--	--	--	--	--%	--	--	--	--	--%	1	--	--%	1	--	--%	--	--%	--	--	--	--	--
Creative A — Retargeting Video	Meta	Paid	--	--	--	--	--	--%	--	--	--	--	--%	--	--	--%	--	--	--%	--	--%	--	--	--	--	--
Lookalike (Meta)	Meta	Paid	--	--	--	--	--	--%	--	--	--	--	--%	--	--	--%	--	--	--%	--	--%	--	--	--	--	--
fb-agr-lookalike	Meta	Paid	--	--	--	--	--	--%	--	--	--	--	--%	--	--	--%	1	--	--%	--	--%	--	--	--	--	--
Creative A — Lookalike Image	Meta	Paid	--	--	--	--	--	--%	--	--	--	--	--%	--	--	--%	--	--	--%	--	--%	--	--	--	--	--
Grand Total	—	—	--	--	--	--	--	--%	--	--	13,165	--	--%	1,343	--	10.2%	158	--	--%	--	--%	--	3,449	9,716	▲ 6%	▼ 1%

▶ = expandable · Source rows roll up the campaigns beneath them (FB1) · WoW / DoD trend shown at Source & Campaign level (FB2) · Column sequence per latest spec: All-in + Media Spend → Leads/CPL/Rate → VC/Cost-per-VC/Rate → App/CPAPP/Rate → BA2/GTN/Revenue → OTP/Non-OTP (FB3) · Spend, Impr, Clicks, CTR, CPC, CPM = pending Meta/Google Ads integration · CRM columns live from Salesforce

VC Done by Ad GroupHorizontal Bar

above_1cr

174

DirectWebsite

fb-agr-design.

custom

View Report (Ad Group Digital VC Done)

App Leads by Ad GroupHorizontal Bar

DirectWebsite

fb-agr-design.

brand

Buy

fb-agr-lookalike

View Report (APP_Internal_Digital)

Keyword Analysis — Google Ads TABLEAU · PIVOT TABLE · Google Ads keyword report → CRM match via UTM keyword param

Keyword × Ad Group · Spend / Impr / Clicks / CTR / CPC / Leads / OTP / Non-OTP / App / VC · CPLPivot Table · Tableau

Keyword	Ad Group	Match	Google Ads Metrics							CRM (Salesforce)					ROI & Efficiency
Keyword	Ad Group	Match	Spend (₹)	Impr.	Clicks	Sessions	CTR%	CPC(₹)	CPM(₹)	Leads	OTP	Non-OTP	App	VC	CPL (₹)	Lead Rate%	L→VC%	OTP%
hoabl	brand	Exact	--	--	--	--	--%	--	--	--	--	--	--	--	--	--%	--%	--%
hoabl plots	brand	Phrase	--	--	--	--	--%	--	--	--	--	--	--	--	--	--%	--%	--%
buy plot in bangalore	Buy	Broad	--	--	--	--	--%	--	--	--	--	--	--	--	--	--%	--%	--%
plots above 1 crore	above_1cr	Exact	--	--	--	--	--%	--	--	--	--	--	--	--	--	--%	--%	--%
luxury plots bangalore	brand-location	Phrase	--	--	--	--	--%	--	--	--	--	--	--	--	--	--%	--%	--%
gated community plots	feature	Phrase	--	--	--	--	--%	--	--	--	--	--	--	--	--	--%	--%	--%
— Rows auto-populate from Google Ads keyword report · Joined via UTM keyword parameter · Tableau Top N by CPL / Leads —

Match type: Exact / Phrase / Broad · Non-OTP = Leads − OTP · Keyword→CRM join requires UTM keyword param · Sort CPL asc = most efficient first

Digital Management Reporting Dashboard — Platform Roll-upTABLEAU · CROSS-TAB · Spend / Leads / VD / App / Net per Platform

Platform	All-in Spends	Media Spends	Leads	VDs	VD%	App%	CPL	CPVD	CPA	Net	GTN%	CPNet
Google	₹ 0	₹ 0	83	0	0%	0%	₹ 0	₹ 0	-	0	0%	₹ 0
Search	₹ 0		43	0	0%	-	₹ 0	-	-		0%	₹ 0
Demand Gen	₹ 0		40	0	0%	-	₹ 0	-	-		0%	₹ 0
Meta	₹ 0	₹ 0	128	0	0%	-	₹ 0	-	-	0	0%	₹ 0
Meta-interest	₹ 0		82	0	0%	-	₹ 0	-	-		0%	₹ 0
Lookalike	₹ 0		46	0	0%	-	₹ 0	-	-		0%	₹ 0
Pay U			0	0	0%	-	₹ 0				0%	₹ 0
Remarketing	₹ 0		0	0	0%	-	₹ 0	-	-		0%	₹ 0
Razorpay	₹ 0		0	0	0%	-	₹ 0	-	-		0%	₹ 0
Advantage+			0	0	0%	-	₹ 0	-	-		0%	₹ 0
Direct Website	₹ 0		32	0	0%	-	₹ 0	-	-		0%	₹ 0
Inshorts	₹ 0		0	0	0%	-	₹ 0	-	-		0%	₹ 0
whatsapp	₹ 0		0	0	0%	-	₹ 0	-	-		0%	₹ 0
Other	₹ 0		1	0	0%	-	₹ 0	-	-		0%	₹ 0
Non Campaign	₹ 0		-	18	0%	0%	₹ 0	₹ 0	-		0%	₹ 0
Total	₹ 0	₹ 0	244	18	7%	0%	₹ 0	₹ 0	₹ 0	0	0%	#DIV/0!

FB7 · VD = Video Done / Video Call · GTN = Gross-to-Net · CPNet = Cost per Net booking · Spend & Ads figures pending integration · Source: Digital Management Reporting model

Digital Management Reporting Dashboard — Project-wise Roll-upTABLEAU · CROSS-TAB · Cost / Leads / VD / App / BA2 / Net / Revenue per Project

Project	Total Cost	Spends (All in)	Media Spends	Telecaller Spends	Leads	VDs	VD%	CPL	Cost / App	Digital Apps	App%	BA2	GTN%	Cost / Net	Digital Revenue	CAC%
The Sarayu Reserve Q1	₹ 1,07,37,657	₹ 85,83,586	₹ 68,95,000	₹ 21,54,071	3,159	185	6%	₹ 2,717	₹ 4,76,866	18	10%	7	39%	₹ 12,26,227	₹ 11,00,00,000	9.80%
GOG Villas	₹ 42,53,234	₹ 40,03,671	₹ 32,16,058	₹ 2,49,563	1,633	66	4%	₹ 2,452	₹ 8,00,734	5	8%	1	20%	₹ 40,03,671	₹ 3,30,00,000	12.90%
Vrindavan Global 1.0	₹ 91,45,306	₹ 81,34,177	₹ 65,34,000	₹ 10,11,129	3,703	354	10%	₹ 2,197	₹ 2,08,569	39	11%	14	36%	₹ 5,81,013	₹ 22,00,00,000	4.20%
OGR 1.0	₹ 99,68,356	₹ 87,51,413	₹ 70,29,812	₹ 12,16,943	3,966	546	14%	₹ 2,207	₹ 1,38,911	63	12%	22	35%	₹ 3,97,791	₹ 21,00,00,000	4.70%
Golden Traingle (NCR)	₹ 1,86,28,218	₹ 1,69,26,283	₹ 1,35,96,500	₹ 17,01,935	5,303	253	5%	₹ 3,192	₹ 2,22,714	76	30%	31	41%	₹ 5,46,009	₹ 14,20,00,000	13.10%
Mission Blue Zone (MMR)	₹ 1,86,28,218	₹ 1,69,26,283	₹ 1,35,96,500	₹ 17,01,935	5,306	481	9%	₹ 3,192	₹ 2,22,714	84	17%	35	42%	₹ 5,46,009	₹ 14,31,00,000	0.00%
Vrindavan Navratna 2.0	₹ 74,20,551	₹ 60,01,663	₹ 48,21,000	₹ 14,18,888	1,832	198	11%	₹ 3,276	₹ 3,33,426	18	9%	7	39%	₹ 8,57,380	₹ 12,00,00,000	6.20%
OGR 2.0	₹ 1,44,18,461	₹ 1,22,52,239	₹ 98,41,946	₹ 21,66,222	4,730	668	14%	₹ 2,590	₹ 1,42,468	86	13%	52	60%	₹ 2,35,620	₹ 54,60,00,000	2.60%
Khopoli	₹ 1,93,99,016	₹ 1,74,28,600	₹ 1,40,40,000	₹ 19,70,416	3,500	500	14%	₹ 4,980	₹ 2,32,381	75	15%	38	51%	₹ 4,58,647	₹ 25,00,00,000	7.80%
Nagpur 1.0	₹ 1,29,73,383	₹ 1,17,06,422	₹ 94,03,504	₹ 12,66,961	3,161	310	10%	₹ 3,703	₹ 2,92,661	40	13%	18	45%	₹ 6,50,357	₹ 13,50,00,000	9.60%
The Sarayu Reserve Q2	₹ 66,94,477	₹ 56,99,908	₹ 45,78,607	₹ 9,94,569	2,093	74	4%	₹ 2,723	₹ 28,49,954	2	3%	1	50%	₹ 56,99,908	₹ 2,00,00,000	33.50%
Alibaug	₹ 80,97,809	₹ 76,14,258	₹ 61,16,361	₹ 4,83,551	2,657	80	3%	₹ 2,866	-	0	0%	0	0%	-	₹ 0	-
The Sarayu Reserve Q3	₹ 32,80,283	₹ 27,80,864	₹ 22,33,805	₹ 4,99,419	668	51	8%	₹ 4,163	-	0	0%	0	0%	-	₹ 0	-
Total	₹ 12,50,16,749	₹ 10,98,83,082	₹ 8,82,66,593	₹ 1,51,33,667	41,711	3,766	9%	₹ 2,634	₹ 2,17,160	506	13%	226	45%	₹ 4,86,208	₹ 1,92,91,00,000	6.50%

Project-wise roll-up · VD = Video Done · BA2 = stage-2 bookings · GTN = Gross-to-Net · CAC = Customer Acquisition Cost % · NCR + MMR share a combined spend block (merged cells) · Source: Digital Management Reporting tracker (image4 reference)

Weekly Overview & Business FunnelTABLEAU · Time-series Cross-Tab + Funnel

Weekly OverviewCross-Tab · Week buckets

Timelines	Total	30 Mar–05 Apr	06 Apr–12 Apr
Spends (All in)	₹ 917,170	₹ 416,756	₹ 500,414
Media Spends	₹ 736,742	₹ 334,771	₹ 401,971
Leads	244	118	126
Lead to VD %	7%	2%	13%
VDs	18	2	16
VD to App %	0%	0%	0%
Apps	0	0	0
Con Ref	0
Net	0	0	0
GTN%
CPL	₹ 3,759	₹ 3,532	₹ 3,972
CPVD	₹ 50,954	₹ 208,378	₹ 31,276
CPApp	#DIV/0!	#DIV/0!	#DIV/0!

Period totals · CPVD improves W2 as VDs scale 2 → 16

Business FunnelFunnel · Lead → VD → App → Net

Leads

244

100%

VDs (Video Done)

7% of leads

Apps

0% of VDs

Net Bookings

0% of Apps

Lead → VD

244 → 18

VD → App

18 → 0

CPL (period)

₹ 3,759

All-in ÷ Leads

FB7 · Funnel stages from Weekly Overview totals · Net & GTN pending booking sync

Lead Flow Dashboard

Tableau · Lead · Disposition · VC · App · Region · Hourly · Salesforce CRM

Refresh | Edit
Date · Source · Campaign · Disposition · City · Ad Group

Date:

→

Source:

Campaign:

Disposition:

City:

Ad Group:

Lead Flow · VC · App — Key MetricsTABLEAU · SCORECARD · Salesforce CRM · Live

Total Leads

13,165

All sources LTD

OTP Verified Leads

3,449

26.2% OTP rate

VC Done

1,343

10.2% lead→VC rate

VC Confirmed

982

Dispo: VC Confirmed

No. of App

158

APP Internal report

Not Connected

2,743

20.8% of total leads

DNC

308

2.3% DNC rate

Peak Lead Hour

10–12 pm

1,345 leads · daily peak

Share WA

558

4.2% of leads

Follow Up

128

Pending follow-up

Call Back

110

Requested callback

OTP / Non-OTP Split

26% / 74%

3,449 OTP · 9,716 Non-OTP

VC Proposed

Awaiting confirmation

Lead Flow — Hourly · Source · DispositionTABLEAU · Bar / H-Bar · Salesforce CRM · Click any bar to cross-filter

Lead: Hourly Lead FlowBar · Peak hour labelled

12–6am
~400

6–8am
535

8–10am
~800

10–12pm
1,345 ▲

12–2pm
~780

2–4pm
~690

4–6pm
~615

6–10pm
~640

10pm+
~400

View Report (Hourly LTD) · Peak: 10–12 pm · Reference line = daily average

Lead: UTM Source & CampaignH-Bar · Action filter active

Source

DirectWebsite

7,286

google

6,811

facebook

158

sync-media

Top Campaigns

Demand gen

801

424

Meta-interest

442

DirectWebsite

422

Pay2

390

View Report (UTM Report) · Click bar → cross-filter all below

Lead: DispositionH-Bar · Tableau action filter

Not Connected

2,743

VC Confirmed

982

Share WA

558

DNC

308

Open

286

Follow Up

128

Call Back

110

YTC

VC Proposed

View Report (Disposition for dashboard) · As of 19 Mar 2026, 12:36 pm

Region-wise Leads · VC · Apps | Disposition Trend (WoW / DoD)TABLEAU · Cross-Tab · Salesforce CRM + APP Internal

Region-wise: Leads · VC · AppsCross-Tab · Top regions · India map toggle

Region / City	Leads	VC Done	Apps	VC %	App %
Bangalore	1,840	410	38	22.3%	2.1%
Delhi-NCR	1,050	190	22	18.1%	2.1%
Ahmedabad	138	28	4	20.3%	2.9%
Agra	123	22	3	17.9%	2.4%
Chandigarh	110	18	2	16.4%	1.8%
Amravati	97	14	2	14.4%	2.1%
Akola	88	11	1	12.5%	1.1%
Chennai	66	9	1	13.6%	1.5%
Amritsar	39	5	0	12.8%	0.0%
Others	8,214	636	85	7.7%	1.0%
Total	13,165	1,343	158	10.2%	1.2%

FB4 · View Report (Live Launch City Lead Report · Digital VC Done · APP_Internal_Digital) · Tableau parameter: table ↔ India choropleth

Disposition — Count · WoW · DoDCross-Tab · Disposition rows · Trend cols

Disposition	Count	% of Leads	WoW %	DoD %
Not Connected	2,743	20.8%	▼ 6%	▼ 2%
VC Confirmed	982	7.5%	▲ 12%	▲ 4%
Share WA	558	4.2%	▲ 8%	▲ 1%
DNC	308	2.3%	▼ 3%	▬ 0%
Open	286	2.2%	▲ 5%	▼ 1%
Follow Up	128	1.0%	▲ 9%	▲ 3%
Call Back	110	0.8%	▼ 4%	▲ 2%
YTC	58	0.4%	▲ 7%	▬ 0%
VC Proposed	41	0.3%	▲ 15%	▲ 6%
Lost	—	—	▬ 0%	▬ 0%

FB6 · Rows = disposition (replacing metrics) · WoW = vs prior week · DoD = vs prior day · View Report (Disposition for dashboard)

Campaign × Disposition HeatmapCross-Tab · Conditional colour

Campaign	Not Conn.	DNC	Foll. Up	VC Conf.	Share WA	Open
Demand Gen	401	8	34	85	95	55
Direct Web	210	5	22	51	48	40
Meta-interest	198	12	18	36	42	30
Search	190	6	20	--	40	28
Remarketing	22	2	5	8	6	4
Pay2	175	5	18	--	38	26

Colour intensity = lead count · High DNC % flagged red · View Report (Disposition for dashboard)

App — Campaign & Ad Group BreakdownTABLEAU · H-Bar · APP Internal

App: Campaign WiseH-Bar

Other

Demand Gen

Direct Website

Meta-interest

Lookalike

Google Search

View Report (APP_Internal_Digital_Campaign)

App: Ad Group WiseH-Bar · Top 8

DirectWebsite

fb-agr-desig.

brand

brand-location

Buy

fb-agr-lookalike

View Report (APP_Internal_Digital)