Sample result
Marketing Dashboard Builder for Restaurants
The owner asked this:«I post three times a week and pay 300,000 a month on Meta. No idea what brings people in and what is wasted money.»
① The census and the indicator dictionary
Census of the machine at Sazón de Origen: 3 pieces a week with no dish named in 2 of them · 300,000 a month on Meta with no result declared before paying · a WhatsApp base with no signup count · no door question at the table.
| Indicator | Formula | Source | Frequency | Owner | Target |
|---|---|---|---|---|---|
| Pieces posted vs plan | posted / planned | calendar + networks | weekly | manager | 3 of 3 |
| Reading per piece | named dish orders, 7 days against the previous 7 | POS | weekly | manager | the row must be fillable |
| Cost per new guest | spend / attributed first-timers | Meta + door question | weekly | owner | below the margin a first-timer leaves |
| Owned-base signups | WhatsApp + email signups | list + register | weekly | cashier | PENDING — baseline missing |
SUPUESTO: the cost-per-new-guest target is set against the contribution margin of the average ticket the house declared, not against a «benchmark» industry cost per guest, which shifts by city and by season. If the real margin were lower, the target drops and the Meta spend hits the cut rule sooner.
② The verdict on the current mix
| What | Figure | Verdict |
|---|---|---|
| Meta (messages) | 300,000 a month, 41 messages, 9 attributed tables | Under watch for 30 days: cost per guest lands well above the margin that table leaves. New ad with the dish named; if it does not drop, it gets cut by written rule |
| «Ambience» carousel | no dish and no channel named | Cut: it cannot be read, and a piece that cannot be read does not count as done |
| Stock video, Tuesday 7 a.m. | sancocho orders up at 7 days | Stays and repeats: the only piece with a reading |
| Owned base | no count | Still unmeasured: enters the board this week with the cashier as owner |
Warning written into the board: sancocho is the highest food cost dish on the menu. Pushing it fills the dining room and thins the margin; that decision is taken in plain sight, not by accident.
The full example has 1 more part(s): you see them inside the library, with your account.