Export, Upload & Prompt!�AI Insights from Your Analytics
Presentation Title
Subtitle
Month, #, Year
Report
Analysis
Idea
Action!
AI and GA4
Low-skill GA4 user
Report
Analysis
Idea
Impact!
AI and GA4
High-skill GA4 user
Report
Analysis
Idea
Impact!
AI and GA4
Low-skill AI user
Report
Analysis
Idea
Impact!
AI and GA4
High-skill AI user
Report
Analysis
Idea
Impact!
AI and GA4
High-skill GA4 / AI user
Report
Analysis
Idea
Impact!
AI and GA4
source: Harvard Business School
AI makes marketers better at technical tasks
AI and GA4
Before you start uploading data…
Check your policies and legal agreements
ChatGPT Plus
8 years to develop
175 billion parameters
$540M per year to train
Koval Manhattan
2 oz Rye�3 dashes Angostura bitters
Splash Rosehip liqueur
Which topics for which channels?
Ask for channel-specific recommendations (GA4)
Topics (page title)
Channel (session source)
Add a filter
EXPORT
Performance
Long date range
Delete these useless rows
Delete columns and rows with low data
This is all we need!
The file
The prompt
Topic / channel fit!
Find gaps in your content strategy
Semantic distance analysis
Which topics have you missed?
Topic
Topic
Topic
Topic
Topic
???
EXPORT
Pages report
Set to Page title
Add a filter
URLs
containing
“blog”
Apply
Delete the first nine rows
Upload the file to AI
Analysis prompt
It finds an issue, �but moves past it
Topics closely related �to articles you’ve �already published
Content that fills gaps
built-in promo advantages
REUSE visuals, examples and data �from the related articles.
SHARE with influencers who contributed
to the related articles.�
NOTIFY editors who linked
to the related articles.
�LINK to the new article
from the related articles.
Which articles should be updated?
Give AI a list of all of them. Ask for suggestions.
Export all of your past articles
It starts the analysis
Prompt includes role, skills, criteria and instructions
These really should be updated!
Conversion rates of specific articles
Which articles are inspiring visitors to subscribe?
The Content Performance Matrix
AI and GA4
Visitors can subscribe from any article.
Blog Post
Thank you page
1000 visits
20 visits
20
1000
2% conversion rate
=
=
Conversion rate
Conversions
Traffic
AI and GA4
Pages report
…with a long date range
Add a filter
…to show only blog posts
Apply
EXPORT
Remove the rows you don’t need
You also don’t need these columns
Traffic to your blog posts!
Pages report
…with a long date range
Add a filter
Apply
EXPORT
…to show only the thank you page
…when blogs were the page referrer
Add a 2nd dimension: Page Referrer
Remove the rows you don’t need
You also don’t need these columns
Remove the rows with very low numbers
Conversions per blog post
Make the headers match for the two files
Upload the files
Prompt with instructions
Check the file!
Looks good!
Ask it to calculate, visualize
Promote these articles everywhere!
Email Campaign Analysis
Traffic and engagement for various topics
Traffic acquisition report
Long date range
Set to Session campaign
Filter…
…to show only
traffic from email
Apply
EXPORT
Delete these first nine rows
Delete the campaigns with low traffic
Add a column, �enter the topics
The GA4 export
The prompt
Some topics are �great for traffic
Other topics are better for engagement
Let’s as for recommendations
What do we think?
Would these ideas work?
Social Media Engagement Analysis
Let AI analyze your top performing social posts
Click here
Creator Mode is required!
Use a big date range and EXPORT
Unstructured and incomplete
Needs:
Two hours later…
The text of each post
The topics
What kind of post?
All of the metrics!
The file
Initial analysis
Prompt
Lovely little chart
Visualization prompt
The phrases that appear most often in top posts!
What language correlates with performance?
Perform a semantic distance analysis. Which subtopics are not represented here but would perform well on this LinkedIn account?
How does word count, use of numbers and emojis correlate with performance?
Using the topics and tone of the posts in this dataset, crate a LinkedIn post that is likely to drive high engagement, comments and reposts.
Summarize the content strategy represented in this dataset.
AI and GA4
Ask it for a style guide prompt
Here’s your training prompt for social content!
Add it to your �shared prompt library!
Keep it simple.
Full funnel campaign analysis
Combine data from the ESP and GA4
Email Metrics vs. Website Metrics
Engagement
rate
Average
engagement time
AI and GA4
Full-Funnel Email Metrics
Engagement
rate
Average
engagement time
AI-generated
Combined Report
AI and GA4
EXPORT
Big date range
Traffic acquisition
Session campaign
Date
Same dates as the ESP report
Filter: Source / medium
contains “email”
EXPORT
Prompt it to
merge the datasets
GA4 Data
ESP Data
No real insights yet...
Prompt it with a role.
Try a Long Shot Prompt
How would Leonardo DaVinci visualize this data? Show your thinking.
What can you tell me about these email campaigns?
What types of insights can you gather from this data?
Make a chart using an unusual visualization method showing unexpected
insights from the data in this dataset
AI and GA4
That is a bit unexpected
Benchmark performance
by topic
Insights that combine �ESP and GA4 data
Correlations between topics and performance across the entire funnel
Recommendations
Prompt
More Strategy Prompts
Suggest changes that would improve the efficiency of this email program
Based on this data, what 5 email subject lines would lead to sales?
Based on this data, what types of campaigns should be sent more often?
What types of campaigns should be abandoned?
You are an expert email marketing strategist. Suggest adjustments to this
Email marketing program based on the data provided.
Predicted performance
Campaign timing analysis
Have AI correlate dates, days and seasonality
Report: Traffic acquisition
Dimension: Session campaign
Secondary dimension: Date
Filter: source medium contains “newsletter”
Average engagement and conversion rates for months and days
When are leads born?
Ask AI to analyze your GA4 “Date” data…
Choose a big date range
But make sure the data is good!
Pages report
Search for the thank you page
Add “Date + hour” secondary dimension
EXPORT
Remove these rows
Also, you don’t need these columns
That looks good
The data
The prompt
Conversions by day of week
Next prompt
Conversions by time of day
Combo prompt
This is when �leads are born!
analysis prompt
Makes sense…
Some interesting ideas!
Look for “Export” buttons
They are more valuable than ever!
EXPORT
EXPORT
EXPORT
EXPORT
Thank you.
Reach out anytime.
Andy Crestodina
Co-founder / CMO
773.353.8301
andy@orbitmedia.com
��