LLM Prompts

Google Analytics 4 (GA4) Report Automation for Digital Marketers

Automates GA4 report creation using ChatGPT, saving time and improving data analysis.

The method

Use these prompts in ChatGPT to automate GA4 report generation. Input specific KPIs, timeframes, and dimensions. Refine prompts based on output. Ideal for weekly/monthly performance reviews and identifying trends. Copy and paste the multiple prompts below and follow instruction.

The prompts

Prompt 1
I need a report on website traffic from GA4 for the past month. Please focus on the following KPIs: Sessions, Users, Bounce Rate, and Conversion Rate. Break down the data by traffic source (organic, paid, referral, direct) and provide insights on which sources performed best and worst. Also highlight any significant changes compared to the previous month. What are the top 5 landing pages based on conversion rate, and how can we improve the performance of the bottom 5 landing pages?
Prompt 2
Generate a GA4 report analyzing user engagement for our mobile app over the last quarter. The key metrics to track are: Active Users (DAU, MAU), Session Duration, and Screen Views per Session. Segment the data by user demographics (age, gender) and device type (iOS, Android). Identify any drop-off points in the user journey and suggest strategies to improve user retention. Also, what are the most popular app features, and how can we promote underutilized features to increase overall engagement? Provide actionable recommendations based on the data.
Prompt 3
Create a custom GA4 report focused on e-commerce performance for the holiday season. Track the following metrics: Revenue, Transactions, Average Order Value, and Conversion Rate. Segment the data by product category and marketing campaign. Identify the top-selling products and the most effective marketing campaigns driving sales. Also, analyze the customer purchase journey to identify any bottlenecks or areas for improvement in the checkout process. What are the top 3 product categories with the highest return rate, and how can we address the issues causing returns for those categories?