---
name: content-performance-dashboard
description: "Build Blog Performance Dashboard from Google Analytics. Use when marketing pulls blog traffic reports out of GA4 by hand each month, so trends are hard to compare over time."
---

# Build Blog Performance Dashboard from Google Analytics

Marketing pulls blog traffic reports out of GA4 by hand each month, so trends are hard to compare over time.

## When to use this skill

- The user wants to set up or run this workflow: "Build Blog Performance Dashboard from Google Analytics".
- The user describes this problem: Marketing pulls blog traffic reports out of GA4 by hand each month, so trends are hard to compare over time.

## At a glance

- Category: Content
- Difficulty: Beginner
- Time saved: 3 hours per week. This figure is an estimate, not a measured result.

## Tools

Options separated by "or" are alternatives; use whichever the user already has.

- Google Analytics 4
- Zapier
- Google Sheets

## Steps

1. Connect GA4 to Zapier using Google Analytics integration
2. Set up weekly trigger to pull top 20 blog posts by pageviews
3. Include metrics: pageviews, avg time on page, bounce rate
4. Write data to Google Sheets with timestamp
5. Create chart in Google Sheets to visualize month-over-month trends

## Template outline

Field names, thresholds, and message text are starting points to adapt.

~~~text
Zapier Setup:
1. Schedule: Weekly on Monday 9 AM
2. Google Analytics 4: Run Report
   - Dimensions: Page path
   - Metrics: Pageviews, Avg engagement time, Bounce rate
   - Filter: Page path contains "/blog/"
   - Limit: 20
3. Google Sheets: Create multiple rows (one per post)
4. Add timestamp column for historical tracking
~~~

## Guardrails

- Work only in the user's own accounts and workspaces, with their credentials.
- Confirm with the user before any step that writes to a CRM, sends email or messages, spends credits, or moves money.
- Treat every hours, cost, and threshold figure as a starting assumption and replace it with the user's numbers.
- Do not invent data, prices, or results. If a vendor price matters, check the vendor's current pricing page.

## Source

https://gtmplaybooks.io/playbooks/content-performance-dashboard/