AnalyticsEngineBook a call
Video tutorial · GTM basics and analytics

Turn GA4 landing page data into actionable insights with AI

9 minFebruary 2025By John BernalWatch on YouTube
In shortUse a Looker Studio template to export your key GA4 landing page data to a CSV file, then ask an AI tool (like Claude or ChatGPT) to find your best and worst landing pages and how to improve them.

Steps covered in the video

  1. Open the Looker Studio template and connect your GA4 property.
  2. Export the landing page table: total users, share of users, bounce rate, transactions, share of transactions, conversion rate and average session duration.
  3. In Google Sheets, format session duration with =TEXT(E2/1440,"HH:MM:SS").
  4. Ask the AI to calculate median, average, mode, min, max and standard deviation for each metric.
  5. Then ask it which landing pages are best, which are worst, and how to improve them.

Recorded in February 2025. Some screens may look different today.

JB
John Bernal

Tracking and analytics consultant with 10+ years setting up GA4, Google Tag Manager, server-side tracking and ad platform conversions. Stape partner, Top Rated Plus on Upwork. About AnalyticsEngine

Related videos

10:37

Install Google Tag Manager on WordPress

Install GTM on WordPress with a plugin and check it works.

September 2024
4:56

Export and import Google Tag Manager containers

Move tags, triggers and variables between containers in 5 minutes.

February 2024
1:35

Conversion tracking tier list: where does your setup rank?

Rank your tracking from E to SS in 90 seconds. Most accounts land at a C.

October 2026

Rather have someone set it up and keep it working?

Tracking & Analytics Ops is $500 a month per website. I set up your tracking, check it every day, fix what breaks and answer your analytics questions. AI does the daily checks; I make every decision.

See the $500 planBook a 20-min call