cotera

GA4 Weekly Performance Report

Pull your GA4 data, analyze the trends, and get a formatted weekly summary delivered straight to Slack. No more manual dashboard screenshots.

Automated reportingTraffic analysisPerformance tracking

The Challenge

Every Monday morning, someone on the marketing team logs into GA4, pulls up a handful of reports, screenshots them, writes some commentary, and posts it all in Slack. It takes an hour or more, and the format is different every week. The numbers are there, but the insights get lost in the manual work.

What This Prompt Does

Discover Metrics

Checks what metrics and dimensions are available for your GA4 property

Pull Analytics Data

Runs GA4 reports for traffic, sources, and device breakdown

Analyze Trends

Identifies top traffic days, leading sources, and device patterns

Deliver to Slack

Sends a clean, formatted summary to your chosen Slack channel

The Prompt

The Prompt

Task

Pull the last 7 days of GA4 analytics data using @Google Analytics/Run ReportName it "Google Analytics/Run Report" and call it with @Google Analytics/Run Report and generate a clear, formatted weekly performance summary. Then send it to Slack using @Slack/Send MessageName it "Slack/Send Message" and call it with @Slack/Send Message.

Before running the report, use @Google Analytics/Get MetadataName it "Google Analytics/Get Metadata" and call it with @Google Analytics/Get Metadata to discover what metrics and dimensions are available for the property.

Input

The user will provide their GA4 property ID and a Slack channel name.

Example: "Property ID: 123456789, send to #marketing-reports"

Context

Metrics to Pull

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

  • totalUsers, newUsers, sessions
  • screenPageViews, bounceRate, averageSessionDuration
  • conversions (if available)

Break down by these dimensions:

  • date (for day-over-day trends)
  • sessionSource (for traffic sources)
  • deviceCategory (for device breakdown)

Analysis Strategy

  1. First use Get Metadata to confirm which metrics are available
  2. Run the main report with date dimension for daily trends
  3. Run a second report with sessionSource dimension for source breakdown
  4. Run a third report with deviceCategory for device split
  5. Calculate week-over-week changes where possible
  6. Format everything into a readable Slack message

Output

Weekly Performance Summary (formatted for Slack):

Traffic Overview:

  • Total users, sessions, and page views for the week
  • Day with highest traffic
  • Day with lowest traffic

Top Traffic Sources:

  • Top 5 sources by sessions
  • Which sources drove the most users

Device Breakdown:

  • Desktop vs mobile vs tablet split

Key Takeaways:

  • 2-3 bullet points highlighting notable trends or changes

Example Usage

Try asking:

  • →"Generate a weekly performance report for property 123456789 and post it to #marketing-reports"
  • →"Pull last week's GA4 data for our main property and summarize traffic trends"
  • →"Send me a weekly GA4 summary with traffic sources and device breakdown"