Prompt Almanac

Create intermediate Works with: Any AI

Looker Studio Report Design for Marketing Performance

Structured brief Has example

Plan a one-page report that answers marketing questions.

Open in ChatGPTOpen in Claude

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.

Rate this prompt

Loading ratings…

Design a Looker Studio report for marketing performance. Questions stakeholders ask: [QUESTIONS]. Data sources available (analytics, ads, email, spreadsheet): [DATA_SOURCES]. Fields in each source: [FIELDS]. Audience and how often they look: [AUDIENCE].

Propose the page layout: a title and date range control, scorecards for key metrics, trend charts, a breakdown table and filters. For each element give the data source, dimension, metric, chart type, sort, comparison period and the question it answers. Define every metric in a note on the report, for example conversion rate as conversions divided by sessions: 48 divided by 1,600 is 3.0 percent. Limit the number of charts and set a colour approach. Accessibility: contrast, text size, and labels that do not rely on colour only.

Test plan: check each number against the source platform for the same dates and note differences from sampling, time zones or definitions. Mark feature names and chart options [VERIFY]. Keep each page to one purpose, and say which pages to build first if time is short. Put the definitions on the report page itself, not in a separate document that nobody opens.

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 report. Scorecards: sessions 13,800, conversions 400, conversion rate 400 / 13,800 = 2.9 percent, cost per conversion 600 / 400 = 1.50. Trend: sessions by week for 12 weeks with the previous period as a dotted line. Table: channels with sessions, conversions, conversion rate; top row Organic search 5,200 sessions, 180 conversions (3.5 percent); lowest Paid social 1,900 sessions, 28 conversions (1.5 percent). Definition note on the page: a conversion is a submitted contact form. Test: totals for the last 7 days match the source platform within 2 percent.

Illustrative only, made-up data. Your results will differ and must be reviewed.

Related prompts