quick-service restaurant chain, 32 outlets across Delhi NCR, Jaipur and Chandigarh, WordPress site, profiles held by franchisees
Weeks 1–2Location data sourceBuild one master sheet: outlet ID, name, address, phone, hours, coordinates, franchise ownerSingle source of truth for every channel
Weeks 2–5Profile consolidationTransfer franchise-held profiles to the brand's organisation, group by city, bulk verify (needs 10+ locations), close duplicatesEvery outlet verified under brand ownership
Weeks 3–7Outlet pagesGenerate city hubs and outlet pages from master data with unique details: landmarks, delivery radius, menu differences; most common failure: only the address differs32 outlet pages with markup, linked from profiles
Weeks 6–9Review operationsOne review tool across outlets, reply templates, escalation to area managersReply SLA per outlet
Weeks 8–10Branch scorecardLooker Studio comparing interactions, rating and reviews per outlet with city mediansMonthly list of outlets needing action
Where it starts21 of 32 profiles verified, 6 duplicates, no outlet pages; ratings range from 3.6 to 4.5; reporting means exporting each profile
Where it endsBrand-owned profiles, data-driven outlet pages and a branch scorecard. Weekly: interactions per outlet, new reviews per outlet, outlets below city median.