Section 01

Marketing dashboards show numbers. Gemini can help turn them into a written report.

Marketing teams collect large amounts of performance data across different analytics platforms, but executives and other stakeholders rarely look at dashboards or raw spreadsheets directly. Someone has to take those figures and regularly turn them into a written update that explains what happened and why it matters.

Gemini can act as a writing assistant for this step. Give it your finalised data tables, and it can organise the information to highlight the key results and notable changes — turning rows of numbers into a smooth, readable narrative ready to share.

Key insight: Gemini does not access your analytics platforms or calculate metrics on its own. You provide the finished data, and it turns those figures into a written narrative.

Example: Traffic by channel (last month)

38%

Channel A
Organic

27%

Channel B
Paid Search

21%

Channel C
Social

14%

Channel D
Email

A table like this is the kind of input you would give Gemini — it would turn these figures into a short written summary of which channels are driving traffic and how that compares to the previous period.

Campaign performance summaries

Turn cost and return data into a brief, readable update for leadership.

Traffic and conversion commentary

Highlight monthly or quarterly changes across your main acquisition channels.

Periodic stakeholder reports

Summarise marketing performance in plain language, without heavy jargon.

Without Gemini

Spend hours interpreting tables and writing similar updates for every channel, leaving less time to work on the campaigns themselves.

With Gemini

Turn raw numbers into a written draft right away, so the team can focus on strategy and budget discussions with stakeholders.

Creating marketing reports with Gemini works best as a structured workflow that keeps the figures accurate from source to final document.

Export the marketing metrics

Pull traffic, conversion and cost figures from your tracking tools or ad platforms for the period you need.

Organise a simple table

Arrange the numbers in a clean, plain layout so the data is easy for Gemini to read.

Generate the narrative summary

Paste the table into your prompt and ask Gemini to draft a report for your intended audience.

Check every figure manually

Review the generated text to confirm every value matches your original data source.

Finalise and share the report

Add the verified text to your final document and distribute it to stakeholders.

Note: Gemini does not know about external market factors, seasonal effects or sudden economic shifts that might explain a spike or drop in traffic — that context needs to come from you.

These prompts help turn marketing data tables into written summaries and trend commentary, with clear limits on what Gemini should add.

Prompt 1 — Summary from a data table

Act as a marketing analyst and write a professional summary for stakeholders based on the following data table (traffic, conversions, and CPA per channel): [Insert Table]. Organise the text with clear bullet points and subheadings. Crucial instruction: Do not invent any numbers, percentages, or trends that are not explicitly provided in the table.

Prompt 2 — Commentary on a trend

Analyse the following conversion performance data for a specific channel over the last two months: [Insert Data]. Generate a brief written commentary highlighting the main changes in the trend. Crucial instruction: Describe only the explicit facts visible in the numbers. Do not invent or assume external causes for this trend if they are not provided in the text.

Before sharing a marketing report with stakeholders

Metric matching: does every figure and percentage match the source spreadsheet exactly?

Channel definitions: are platform and campaign names correctly linked to the right data points?

Formal tone: is the language objective and appropriate for a leadership audience?

Key takeaways: are the top-performing channels and main results clear at a glance?

Placeholders: have all bracketed fields been replaced with real campaign details?

Important: Human review is essential before any report goes out. When describing trends, be careful not to confuse correlation with causation — two metrics moving together does not mean one caused the other.