Looker Studio Executive Dashboard Specification
Specify a dashboard for leaders from business questions.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
[VERIFY] is an editorial flag, not a blank to fill. Wherever the prompt shows [VERIFY], check that item against a reliable source before you use it.
Write a specification for an executive dashboard in Looker Studio. Leaders and the decisions they make: [LEADERS_AND_DECISIONS]. KPIs and targets: [KPIS_AND_TARGETS]. Data sources and refresh needs: [SOURCES_AND_REFRESH]. Constraints on who may see what: [ACCESS_RULES]. Keep to eight KPIs, each with an owner and a decision. For each give the definition, formula, data source and field, filter, comparison, target, and threshold colours with text labels, and the action if it moves outside its threshold (who explains and by when). Variance to target: actual 92 against target 100 is -8 percent. Example row (invented): Net new customers, new paying customers minus cancellations in the month, billing source, target 120, actual 108, variance -10 percent, status amber. Describe page flow (summary, then drill-down pages, navigation), date controls and default periods, ownership of each metric, and the data refresh schedule [VERIFY]. Add a one-page KPI dictionary, a review calendar (weekly by the team, monthly by leaders, quarterly review of the KPI list), three questions the dashboard cannot answer with where to look instead, and a review checklist: numbers match the finance report, definitions published, access reviewed.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.
See an example result (fictional data)
Invented KPI row. Net new customers: definition new paying customers minus cancellations in the month; source billing system; target 120; actual 108; variance -12 (-10 percent); status amber (amber from -5 to -15 percent). Owner: head of growth. Commentary box: 'Cancellations were 22 against 15 in the plan, concentrated in the smallest plan.' Data timing note: billing data final on working day 3. Review: monthly leadership meeting, 10 minutes for this page. Variance check: 108 less 120 is -12, and -12 / 120 is -10 percent; the thresholds for amber and red are placeholders to confirm with the owner.
Illustrative only, made-up data. Your results will differ and must be reviewed.