🐙 Promptpack: Using Code Interpreter to crack your marketing funnel
Our first Promptpack for businesses
Recently, I introduced you to Code Interpreter1 — a powerful feature that allows ChatGPT to write, run and iterate Python code within the browser. In today’s Promptpack, I will showcase high-level examples of how it can be applied to some marketing activities.
This post is especially dedicated to all business owners and marketers among our readers — I hope it is helpful!
Before we get going, I recommend perusing the initial introduction to the Code Interpreter. This will provide a foundational understanding as we navigate forward👇
Today I’ll take you through a proof of concept of how to use ChatGPT’s Advanced Data Analysis for all four parts of the marketing funnel: awareness, consideration, conversion and loyalty.
In these examples, the prompts help pull out a high-level narrative from the data, from which you and your marketing team can dive deeper. The Advanced Data Analysis feature won’t find complex patterns on its own, but it can be a powerful ally in helping you detect and understand them.
We’ll provide initial prompts to kick off the conversation, but ChatGPT’s power is its ability as an interlocutor. A good conversation should spark new thoughts and ideas within you, so please keep the conversation going after the first prompt!
Before we start, some quick tips:
Ensure the Advanced Data Analysis feature is activated within your ChatGPT settings.
In the examples provided, I use synthetic data generated by ChatGPT. If you wish to follow along using your own data, Advanced Data Analysis can help you merge different data sources (like social media and traffic) into a single dataset. Refer to step 3 in our introductory guide for guidance.
Before uploading proprietary data to ChatGPT, review your internal business rules. Encourage your business to check out ChatGPT Enterprise, if there are concerns about uploading data.
Ensure you do not upload any data containing personal identifying information.
The prompts below provide a broad overview of the data. I recommend asking follow-ups and more detailed questions to delve deeper into the data.
Stage 1: Awareness 👀
This is the first tier of the marketing funnel, the moment when potential customers first encounter your brand or product.
Advanced Data Analysis: To accurately assess the impact of our awareness strategies, we are going to look at our website visits data with Code Interpreter. To get started, upload your dataset containing website visits and channel spend data.
Given the attached website visits and spend dataset for our digital marketing channels:
1. Analyse the volume of website visits from different sources over the given period. Identify any consistent trends or notable spikes/dips. Provide a visualisation.
3. Provide a detailed spend analysis for the different channels. Identify which channels are receiving the most investment and assess the cost-effectiveness of this spend.
4. Calculate and visualise the ROI for different channels, determining which channels offer the most value for our marketing investments.
5. Based on the insights, recommend any strategic changes or areas of focus to optimise our digital marketing efforts.