Data Sources
Department
See your top traffic sources from yesterday in Google Analytics with a simple ranked list. Quickly identify which channels are driving the most visitors to your site.
Prompt
Copy Prompt
Copied!
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
Set Time Period → Yesterday
Retrieve Data → Get users and sessions by source/medium
Calculate Percentages → Compute % of total traffic
Rank Sources → Sort by users (highest first)
Format Output → Present top 10 in simple table
Handle Errors → Address missing connection or data
Output Goal: 15-second scan to see where yesterday's traffic came from.
Prompt
Copy Prompt
Copied!
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
Set Time Period → Yesterday
Retrieve Data → Get users and sessions by source/medium
Calculate Percentages → Compute % of total traffic
Rank Sources → Sort by users (highest first)
Format Output → Present top 10 in simple table
Handle Errors → Address missing connection or data
Output Goal: 15-second scan to see where yesterday's traffic came from.
You might also like
Tutorials using same data sources
Stop fighting with data. Start feeding your AI.
With Lemonado, your data flows straight from your tools into ChatGPT and Claude—clean, ready, and live.


















