BTL Campaign Dashboard

Ranchi - BTL - Aug 2026

Auto branding rollout across Ranchi, synced live from Google Sheets.

Google Sheets sync — Syncing…

Auto-refreshes every 60s · Last successful sync:

Planned units

800

Across 5 creatives

Installed

250

31% of plan

Remaining

550

Pending installation

Creatives not started

2 of 5

Zero installs so far

Overall installation progress

31%

250 of 800 units live — 550 still to be installed.

Download chart data & summary

Metrics, creative-wise installs and date-wise deployment, plus sync status.

Creative-wise installation

Planned vs installed units per creative

Date-wise deployment

Daily installs and cumulative rollout

Creative-wise performance

Auto branding tab

Ghar par test, Aaram Se

80 / 270 · 30%

Bharosemand reports, Harr Bar - Buy 1 Get 1 Free on Full Body Checkups

40 / 140 · 29%

Bharosemand reports, Harr Bar - Free home sample collection

0 / 130 · 0%

Sahi Report, Bina Deri Buy 1 Get 1 Free on Full Body Checkups

130 / 130 · 100%

Sahi Report, Bina Deri Free home sample collection

0 / 130 · 0%

What's working

"Sahi Report, Bina Deri Buy 1 Get 1 Free on F…" is fully installed at 130 units. It shows the vendor can close a full block quickly when the artwork is ready.

Next action

"Ghar par test, Aaram Se" has the largest open gap at 190 units. Prioritise it to close 550 of 800 pending units.

RWA Health Camp

This tab is currently empty in the sheet, so no camp metrics are available yet. Add rows there and this section can track camp-wise footfall and conversions.