• Compound Leverage
  • Posts
  • Create a Marketing Analyst with AI: Build a GPT in Under 10 Minutes

Create a Marketing Analyst with AI: Build a GPT in Under 10 Minutes

Automate your marketing analysis with a GPT

Compound Leverage

Issue #006

Stoic Wisdom of the Day

“It is not that we have a short time to live, but that we waste a lot of it. Life is long enough, and a sufficiently generous amount has been given to us for the highest achievements if it were all well invested."

- Seneca

Do you wish you could analyze marketing campaign data in minutes to learn what’s working and what’s not without downloading data into spreadsheets?

I was looking for a smarter, faster, and cheaper way to get the answers to my marketing campaign questions and learn from my experiments.

My goal for the marketing analysis was to measure doubling patterns of key results to learn where compounding was non-existent, negative, and positive.

The problem? It took forever. I'd spend hours poring over spreadsheets to spot trends and insights.

That's when I had an idea: What if I could create an AI assistant to do the analysis?

I decided to build a Custom GPT to analyze the data and perform the analysis—an invisible data scientist.

In just 15 minutes, I built a Custom GPT inside ChatGPT that serves as my data scientist. It analyzes campaign data, finds trends, and even gives expert advice.

Here's how I created a GPT inside ChatGPT that looks through campaign data, finds trends, and gives me expert advice—in 15 minutes.

Let’s walk through the process.

Step 1. Create

Head to ChatGPT (with a Plus subscription), hit “Explore GPTs,” and then select "Create GPT."

Start with a conversation. Send prompts to the GPT builder for market analysis tasks. Here is a list of tasks to get you started:

  • Analyze OKR performance

  • Measure the impact of workflow actions

  • Perform data science activities

  • Predict outcomes

  • Do sentiment analysis on data

  • Give it the ability to use ChatGPT or Claude (Claude is better at statistical analysis), depending on which LLM was best for the requested task.

Step 2. Configure

  • Go to the "Configure" tab.

  • Turn on web browsing, data analysis, and code generation.

  • If you want, give it access to Dall-E to create images.

  • Import knowledge data for the marketing analyst. (You can import up to 20 files up to 500MB each)

Here's the magic: create an "Action" to connect your GPT to Zapier AI Actions (in beta). This is how you'll get your GPT to talk to Claude AI.

Step 3. The Claude Connection with GPT Actions

  • In Zapier, create a new AI Action that sends prompts to Claude.

    • Create a Claude Send Prompt Action (Requires Claude Connection with API key)

    • Enable the Action

Troubleshooting Tip: If you get an error, update the version number in the code to 3.1.0.

Step 4. The Final Step

  • Copy the Zapier instructions for your Actions, then add them to your GPT instructions. This tells it what to do with the data it gets from Claude.

  • Click this link to download the Zapier instruction template. It will help you get started and update the Actions you setup and want to enable section at the bottom of the instructions

  • Set the parameters for the Zapier action(s) you want to include in the GPT.

  • Hit "Create" (or "Update" if you're editing an existing GPT) and start using the marketing assistant.

Closing Thoughts

That's it! Your GPT marketing analyst is ready to go—no more endless reports or spreadsheets. Ask the GPT for insights whenever you need them.

Why spend time reviewing reporting data when a GPT can do it?

GPTs give us new ways to get things done.

Try creating a GPT to save time on a key result task and see how it frees up your time.

Have a great 4th of July.


Here are three ways to begin doubling your output with AI automation experiments whenever ready.

  1. Automate analyzing and writing proposals with AI: Get a free AI Proposal Checklist with a “step-by-step how to” email course to get started.

  2. Schedule an Introductory AI Automation Strategic Thinking Session: Book a 1-on-1 AI automation session for an initial AI automation analysis to uncover ways to double your output on a key goal. Limited slots are available.

  3. One-click newsletter signup here.

Join the conversation

or to participate.