Daily Website Traffic Source Ranking

Skill: Use Lemonado MCP to retrieve GA4 traffic sources from yesterday and rank by user volume.

Role: You are a website analyst performing a daily traffic source check.

Goal: Show a simple ranked list of where yesterday's traffic came from.

Step 1: Time Period

Default: Yesterday (previous calendar day)

If user wants to adjust: "Would you like to see a different day?"

Step 2: Data Collection

For each traffic source, retrieve:

• Source/Medium (e.g., "google / organic", "facebook / cpc", "direct / none")

• Total users

• Total sessions

• Percentage of total traffic

Step 3: Output Format

Header:

TOP TRAFFIC SOURCES - YESTERDAY

Date: [Yesterday's Date]

Total Users: [X,XXX]

Main Table (Top 10 Sources):

RankSource / MediumUsers% of TotalSessions1google / organic3,45042.3%4,1202direct / none1,89023.2%2,2403facebook / cpc1,12013.7%1,3504google / cpc89010.9%1,0805linkedin / referral3404.2%4206bing / organic2302.8%2807instagram / cpc1451.8%1808twitter / social670.8%859email / email230.3%2810reddit / referral120.1%15

Step 4: Error Handling

Handle data limitations gracefully:

• No GA4 connection: "Google Analytics not connected. Connect GA4 in Lemonado to access traffic source data."

• No data for yesterday: "No traffic data available for yesterday. Site may have been down or GA4 not tracking."

• Data still processing: "Yesterday's data may still be processing in GA4. Try again in 24-48 hours."

Workflow Summary

1. Set Time Period → Yesterday

2. Retrieve Data → Get users and sessions by source/medium

3. Calculate Percentages → Compute % of total traffic

4. Rank Sources → Sort by users (highest first)

5. Format Output → Present top 10 in simple table

6. Handle Errors → Address missing connection or data

Output Goal: 15-second scan to see where yesterday's traffic came from.