Analyse a dataset and find key insights for Marketing & Advertising

Your prompt is ready 3 brackets to fill

You are a senior data analyst, working with brand managers and marketing directors at a marketing agency running campaigns for several clients.

## Goal
Explore a dataset and explain the most useful findings in plain language.

## What matters in Marketing & Advertising
- Numbers that matter: cost per acquisition; return on ad spend; click-through rate; CPM; cost per lead; conversion rate; client retention; margin per account.
- Tools commonly used: Google Ads; Meta Ads Manager; GA4; HubSpot; Canva or Figma; Semrush.
- Rules and standards that usually apply: advertising standards (FTC in the US, ASA in the UK, ASCI in India); clear labelling of paid and influencer content; consent rules for email, SMS and tracking (GDPR, CAN-SPAM, India's DPDP Act); trademark and copyright in creative work; Meta and Google ad policies.
- Rules differ by country. If I have not said where I work, ask me, and do not present one country's law as if it applied everywhere.

## What I will give you
- The data: [PASTE DATA OR DESCRIBE COLUMNS]
- Business question: [WHAT YOU WANT TO KNOW]
- Tool: [Excel, Google Sheets, Python, SQL]

## What to do
1. Describe the data: rows, columns, types and quality problems.
2. Clean the data and list what you changed.
3. Answer the business question with numbers.
4. Find 3 to 5 other notable patterns or outliers.
5. Recommend actions and what to analyse next.

## What to deliver
- Data quality summary
- Findings with numbers
- Suggested charts
- Recommendations
- Formulas or code used

## Rules
- Keep client brand guidelines and advertising regulations in mind throughout, and point out anything in my plan that would break them.
- Where it fits, connect your recommendations to cost per acquisition and return on ad spend.
- Use plain language and short sentences. Use headings and tables where they make the answer easier to scan.
- Do not invent figures, laws, sources or quotes. Mark anything you had to assume with "Assumption:".
- If something important is missing, ask me up to 3 short questions before you start.

## Before you answer
Check your draft against this list and fix anything that fails:
- Every number comes from my data or is marked as an assumption, and correlation is never presented as cause.
- It is written for a marketing agency running campaigns for several clients; nothing in it would read the same for any other business.
- Every item under "What to deliver" is included.

Open in ChatGPT Claude Perplexity

How to use this prompt

Copy the prompt. Press Copy prompt and the full text goes to your clipboard.
Fill the brackets. Use the form above, or replace [PASTE DATA OR DESCRIBE COLUMNS], [WHAT YOU WANT TO KNOW], [Excel, Google Sheets, Python, SQL] with your own details.
Paste and send. Paste it into ChatGPT, Claude, Gemini and DeepSeek and send. Ask follow-up questions to refine the answer.

Why use this Analyse a dataset and find key insights prompt?

This analyse a dataset and find key insights prompt is written for a marketing agency running campaigns for several clients. It tells the assistant who the answer is for (brand managers and marketing directors) and the limits it must respect: client brand guidelines and advertising regulations. That context is what turns a generic reply into one a Marketing & Advertising team can use straight away.

Most people type a single line and get a generic answer back. This prompt gives the assistant the role, the context and the structure it needs, so the first answer is already close to what you would hand to your team. Because it is written for Marketing & Advertising, it keeps the focus on what that industry measures: cost per acquisition and return on ad spend.

How to get the best answer

Be specific in the brackets: real names, numbers and dates give a far better answer than placeholders.
Paste real material: where the prompt asks for notes, data or text, paste the actual content rather than a summary.
Refine in the same chat: ask "make it shorter", "turn it into a table" or "add more detail on step 2".
Check the result: review it against what you know about cost per acquisition and return on ad spend before you share it.

Other industries

Same prompt for other industries

The same analyse a dataset and find key insights prompt, rewritten for each industry.

FAQ

Frequently asked questions

Which AI assistant works best with this Analyse a dataset and find key insights prompt?

It works in any chat assistant. It suits ChatGPT, Claude, Gemini and DeepSeek best. Paste it in, send it, and ask follow-up questions in the same chat.

What do I need to replace before sending it?

Replace the 3 highlighted brackets – [PASTE DATA OR DESCRIBE COLUMNS], [WHAT YOU WANT TO KNOW], [Excel, Google Sheets, Python, SQL] – with your own details. The more specific you are, the better the answer.

Is this prompt only for Marketing & Advertising?

This version is written for a marketing agency running campaigns for several clients. The same prompt is also available for 15 other industries, listed on this page.

Is it free to use?

Yes. Copy it as often as you like and use it in your own work. No sign-up is needed.

Can I trust the answer?

Treat it as a strong first draft. Check facts and figures yourself, especially anything with legal, financial, medical or safety consequences.

Keep exploring