Prompt Library

Gemini dashboard prompts that spec the chart before the pixel

15 copy-paste prompts

Name the audience, paste sample metrics, and get a layout, chart pick, and data contract. Gemini tags missing fields [VERIFY]. You wire the real data.

In short: This page contains 15 copy-paste ready prompts, organized into 5 categories with a description and pro tip for each. The first 5 prompts are free instantly, no signup needed. Hand-curated and tested by the AI Academy team.

By Louis Corneloup · Founder, Techpresso

Last updated September 15, 2026·Hand-curated & tested by the AI Academy team

KPI layout specs

3 prompts

Executive KPI row

1/15

✨ What it does

Gemini specs a four-card KPI row from [METRIC LIST] for [AUDIENCE] and tags missing baselines [VERIFY]. Paste real baselines, then hand the spec to whoever builds the view.

Product: [PRODUCT]. Audience: [AUDIENCE]. Metrics available: [METRIC LIST]. Spec a KPI row: 4 cards, label, format, comparison period, alert threshold. Tag missing baselines [VERIFY]. No invented numbers.

💡

Pro tip: If you cannot name the comparison period, the card will say [VERIFY]. Name it.

SaaS metrics board

2/15

✨ What it does

Gemini layouts a SaaS metrics board from [METRICS] with chart types and tags gaps [VERIFY]. Fill every [VERIFY] slot from your billing export before you ship the board.

Stage: [STAGE]. Metrics paste: [METRICS]. Layout a SaaS board: MRR, churn, CAC, LTV, magic number slots with chart types. Use only pasted values as examples. Tag gaps [VERIFY].

💡

Pro tip: Paste one real MRR number. Gemini uses it as scale, not as gospel.

Ops health scorecard

3/15

✨ What it does

Gemini designs an ops scorecard from [SIGNAL LIST] with RAG rules and tags unknown targets [VERIFY]. Set targets with the team, then publish the scorecard Monday.

Team: [TEAM]. Signals: [SIGNAL LIST]. Design a weekly ops scorecard: green/yellow/red rules per signal, owner column, trend sparkline spec. Tag unknown targets [VERIFY].

💡

Pro tip: RAG without thresholds is decoration. Paste thresholds or accept [VERIFY].

Prompts get you started. Tutorials level you up.

A growing library of 300+ hands-on AI tutorials. New tutorials added every week.

Start 7-Day Free Trial

Chart selection

3 prompts

Pick the right chart

4/15

✨ What it does

Gemini recommends chart types for [QUESTION] from [FIELDS AND TYPES] and tags missing granularity [VERIFY]. Confirm granularity with the data owner, then build the primary chart first.

Question: [QUESTION]. Data shape: [FIELDS AND TYPES]. Recommend primary and secondary chart, axes, filters, and why not the obvious chart. Tag missing granularity [VERIFY].

💡

Pro tip: Say whether the viewer needs comparison or trend. That one word drives the chart pick.

Funnel visualization spec

5/15

✨ What it does

Gemini specs a funnel for [STEPS] with leak callouts and uses [COUNTS] or [VERIFY] for sample data. Paste real step counts, then highlight the leak in your next standup.

Funnel: [FUNNEL NAME]. Steps: [STEPS]. Segments: [SEGMENTS]. Spec horizontal funnel with conversion rates, biggest leak callout, segment toggle. Sample counts from [COUNTS] only or [VERIFY].

💡

Pro tip: List steps in order. Out-of-order steps produce fake leak stories.

Cohort retention heatmap

6/15

✨ What it does

Gemini specs a cohort heatmap from [COHORT TABLE] or tags the table [VERIFY]. Paste your cohort export, then check whether you measure active or revenue retention.

Product: [PRODUCT]. Cohort grain: [WEEK/MONTH]. Retention metric: [METRIC]. Spec heatmap rows, columns, color scale, and summary KPIs. Data from [COHORT TABLE] or [VERIFY].

💡

Pro tip: Active and revenue retention need different labels. Say which one in the first line.

Sales and CRM views

3 prompts

Pipeline dashboard brief

7/15

✨ What it does

Gemini specs a pipeline dashboard from [DEAL PASTE] with forecast formula and tags missing weights [VERIFY]. Load live deals, then confirm stage weights with sales ops.

Stages: [STAGES]. Quota: [QUOTA]. Sample deals: [DEAL PASTE]. Spec pipeline dashboard: stage bars, weighted forecast formula, rep leaderboard columns, top deals table. No invented deal values.

💡

Pro tip: Weighted forecast needs your stage probabilities. Paste them or accept [VERIFY].

Account health panel

8/15

✨ What it does

Gemini specs an account health panel from [ACCOUNT PASTE] and tags unknown signal weights [VERIFY]. Weight the signal that predicts churn for you, then score real accounts.

Health signals: [SIGNALS]. Accounts sample: [ACCOUNT PASTE]. Spec health score formula, at-risk threshold, watchlist filter, segment breakdown chart. Tag unknown weights [VERIFY].

💡

Pro tip: If NPS is in the paste, say whether it is current. Stale NPS becomes [VERIFY].

Rep performance view

9/15

✨ What it does

Gemini specs a rep performance view from [PASTE] with activity-to-outcome ratio. Plug in CRM exports, then review the ratio before coaching conversations.

Activity metrics: [ACTIVITY LIST]. Outcome metrics: [OUTCOME LIST]. Reps: [REP NAMES]. Spec rep selector, quota ring, team comparison bars, activity-to-outcome ratio. Sample from [PASTE] only.

💡

Pro tip: Activity without outcomes rewards busywork. Include at least one outcome metric.

Like these prompts? There are full tutorials behind them.

Learn the workflows, not just the prompts. 300+ easy-to-follow tutorials inside AI Academy — and growing every week.

Try AI Academy Free

Marketing and product analytics

3 prompts

Web analytics overview

10/15

✨ What it does

Gemini specs a web analytics overview from [METRICS] and tags missing prior-period data [VERIFY]. Pull prior period from your tool, then replace every sample value.

Site: [SITE]. Date range: [RANGE]. Metrics: [METRICS]. Spec overview: KPI cards, traffic trend line, source breakdown, top pages table. Tag missing prior-period data [VERIFY].

💡

Pro tip: Name the date range in plain language. Relative ranges confuse handoffs.

Campaign performance board

11/15

✨ What it does

Gemini specs a campaign board from [CAMPAIGN PASTE] and tags missing ROAS inputs [VERIFY]. Paste spend and conversions, then validate ROAS in the sheet before sharing.

Campaigns: [CAMPAIGN PASTE]. KPIs: [KPIS]. Spec board: spend vs plan, CPA by channel, creative table, lift note section. No invented ROAS.

💡

Pro tip: Separate brand and performance campaigns in the paste. Mixed rows skew CPA.

Product engagement dash

12/15

✨ What it does

Gemini specs a product engagement dash from [USAGE] and tags missing event definitions [VERIFY]. Confirm the activation event with analytics, then swap sample arrays for production data.

Activation event: [EVENT]. Features: [FEATURE LIST]. Usage paste: [USAGE]. Spec DAU/WAU/MAU row, feature adoption bars, activation funnel. Tag missing event definitions [VERIFY].

💡

Pro tip: If the event name in the paste differs from the tool, fix the paste first.

Handoff and data contract

3 prompts

Data contract for BI

13/15

✨ What it does

Gemini writes a data contract for [NAME] from [METRIC DEFINITIONS] and tags unknown sources [VERIFY]. Confirm owners with data engineering, then attach the contract to the ticket.

Dashboard: [NAME]. Metrics: [METRIC DEFINITIONS]. Write a data contract: field name, type, source table, refresh cadence, owner, null rule. Tag unknown sources [VERIFY].

💡

Pro tip: Null rules prevent silent zeros. Paste how missing data should display.

Filter and drill spec

14/15

✨ What it does

Gemini specs filters and drill paths from [DIMENSIONS] and tags unknown PII [VERIFY]. Review forbidden combos with security, then implement defaults in the BI tool.

Audience: [AUDIENCE]. Dimensions available: [DIMENSIONS]. Spec default filters, allowed drill paths, and forbidden combos that break privacy. Tag unknown PII fields [VERIFY].

💡

Pro tip: Forbidden combos matter for manager dashboards. Name roles in the paste.

Acceptance checklist

15/15

✨ What it does

Gemini writes a 10-item acceptance checklist from [SPEC PASTE] and tags untestable items [VERIFY]. Run the checklist before you mark the dashboard done.

Dashboard spec: [SPEC PASTE]. Write a 10-item acceptance checklist: numbers match source, filters work, mobile layout, refresh time, accessibility, empty states. Tag untestable items [VERIFY].

💡

Pro tip: Empty states are where executives lose trust. Require them in the checklist.

Free tool

Prompt Optimizer

Turn a rough idea into a structured, professional AI prompt.

Try it free →

Frequently Asked Questions

No. These prompts stay inside Gemini's official product. It only uses official Gemini, including Gems if you have them. If a setting is missing on your plan, the prompt says so.

A current Gemini account. Some features sit on paid plans. The prompts still work as checklists if a feature is off.

Every prompt tells it to use only what you paste and to tag gaps as [VERIFY]. You still check the dashboard spec before you save it.

Yes to copy. Running them needs your Gemini account. Long files fit better on a paid plan.

No. It is a draft of your dashboard spec. You own the facts, the files, and whatever your job or policy requires.

Prompts are the starting line. Tutorials are the finish.

A growing library of 300+ hands-on tutorials on ChatGPT, Claude, Midjourney, and 50+ AI tools. New tutorials added every week.

Start 7-Day Free Trial Explore AI for Marketers

7-day free trial. Cancel anytime.

Browse All Prompt Collections

Popular prompt collections

AI Photo Editing Prompts ChatGPT Jailbreak Prompt Best ChatGPT Prompts Funny Hinge Prompts ChatGPT Caricature Prompts