RFC: Mediavine/Journey ad revenue visibility

[saraichinwag]

Summary

Explore options for exposing Mediavine (Journey) ad revenue data to the agent for income visibility and content strategy decisions.

Use Case

Agent should be able to answer:

• "Which posts generated the most ad revenue?"
• "What's the RPM trend over the last 30 days?"
• "Which categories have the highest ad earnings?"
• "How does traffic correlate with revenue?"

Challenge

Mediavine does NOT have a public API. Options:

1. Dashboard scraping — Use Playwriter to log in and scrape reports (fragile, requires maintenance)
2. Email reports — Mediavine sends weekly/monthly email reports; could parse those
3. CSV export + manual import — User exports reports, DM imports
4. GA4 monetization reports — GA4 has some ad revenue data (less detailed)
5. Wait for API — Mediavine has talked about an API for years; may never happen

Data Points Needed

• Total revenue by period
• RPM (revenue per 1000 impressions)
• Revenue by page/post (if available)
• Revenue by traffic source (direct, Pinterest, search)
• Earnings trend over time

Questions

• Is scraping the dashboard worth the maintenance burden?
• Is GA4 monetization data sufficient for decisions?
• How often does revenue data need to be refreshed?

Priority

High — ad revenue is the primary income source. But implementation complexity is significant.

Status

This is an RFC. Need to decide on approach before implementation.