cotera

GA4 Weekly Traffic Report

Pull your GA4 traffic data, compare it to last week, and get a clear summary of what changed and why it matters.

Weekly reportingTraffic analysisSource/medium breakdownWeek-over-week trends

The Challenge

Every week someone on the team opens GA4, clicks through the same reports, copies numbers into a spreadsheet, and tries to figure out what actually changed. Half the time the date ranges are off. The other half, the comparison is missing context. By the time the report is done, the meeting where you needed it has already started.

What This Prompt Does

Find Your Properties

Lists available GA4 properties so you can pick the right one

Pull Traffic Data

Runs reports for sessions, users, pageviews, bounce rate, and duration

Compare Week-over-Week

Calculates percentage changes against the prior 7 days for every metric

Surface Top Movers

Identifies the biggest changes in sources, pages, and overall traffic

The Prompt

The Prompt

Task

Use @Google Analytics/List PropertiesName it "Google Analytics/List Properties" and call it with @Google Analytics/List Properties to find available GA4 properties, then use @Google Analytics/Run ReportName it "Google Analytics/Run Report" and call it with @Google Analytics/Run Report to pull the last 7 days of traffic data. Compare to the prior 7 days and surface the most important changes.

Input

The user will provide:

  1. Their GA4 property ID (or ask to list properties first)
  2. Any specific metrics or dimensions they care about (optional)

Example: "Pull a weekly traffic report for property 123456789"

Context

Metrics to Pull

Run a report for the last 7 days with these metrics:

  • sessions, totalUsers, newUsers
  • screenPageViews, bounceRate, averageSessionDuration

Break down by these dimensions:

  • sessionSourceMedium (for traffic sources)
  • pagePath (for top pages)
  • date (for day-over-day trends)

Comparison Strategy

  1. First list properties if the user hasn't provided a property ID
  2. Run the main report for the last 7 days broken down by date
  3. Run the same report for the prior 7 days (days 8-14 ago)
  4. Run a source/medium breakdown for the last 7 days
  5. Run a top pages report for the last 7 days
  6. Calculate week-over-week percentage changes for each metric
  7. Identify the biggest movers in traffic sources and pages

Analysis Guidelines

  • Flag any metric that changed more than 20% week-over-week
  • Highlight the top 5 traffic sources by sessions
  • Show the top 10 pages by pageviews
  • Note any sources that appeared or disappeared compared to prior week

Output

Weekly Traffic Summary:

  • Total sessions, users, pageviews with week-over-week change
  • Bounce rate and avg session duration with change

Top Traffic Sources:

  • Top 5 sources by sessions with week-over-week comparison
  • Any new sources that appeared this week

Top Pages:

  • Top 10 pages by pageviews
  • Pages with biggest traffic increases or decreases

Key Takeaways:

  • 3-5 bullet points on notable trends, spikes, or drops

Example Usage

Try asking:

  • →"Pull a weekly traffic report for property 123456789 and compare to last week"
  • →"List my GA4 properties and then generate a traffic summary for the main site"
  • →"What were our top traffic sources this week vs last week?"