Weekly WordPress traffic digest in Slack

Build a deterministic code workflow that posts a weekly WordPress traffic digest to Slack every Monday at 9am ET. The trigger is cron.

Step 1: WordPress List Posts. Query the configured WordPress site for posts with status=publish and a published date in the last 7 days. For each post, capture title, slug, full URL, author name, and categories.

Step 2: Google Analytics Batch Run Reports against the configured GA4 property for the same 7-day window. Request the metrics pageViews, totalUsers, averageSessionDuration, and engagementRate, dimensioned by pagePath. Use a pagePath filter scoped to the slugs collected in step 1 so we only pull rows for those posts. Include the prior 7-day window as a second report in the batch so we can compute a week-over-week delta.

Step 3: Join the WordPress list and the GA4 rows on URL/slug. For posts with no GA row, fill metrics with 0. Sort by pageViews. Pick the top N performers and the bottom N performers, where N is a configurable input that defaults to 3. For each post, compute the week-over-week delta in pageViews against the prior period rows returned in step 2. Format a single Slack message: a short header (date range, total posts published, total pageviews), then a Top Performers section and an Underperformers section, each line showing title, author, pageviews, engagement rate, and the WoW delta with an up or down arrow.

Step 4: Slack Send a Message to the configured channel with the formatted recap. Use Slack mrkdwn so titles link to the post URL.

Configurable inputs: WordPress site (credential picker), GA4 property ID, target Slack channel, and the number of top and bottom posts to surface (default 3 and 3). The schedule (Monday 9am ET) should also be editable.

Integrations to use: wordpress, google-analytics, slack. Keep every step deterministic — no LLM nodes. If GA returns no rows for the period, still post a short Slack message saying which posts shipped and that no traffic data is available yet.