Where did my traffic come from yesterday?

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

  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.

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

  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.

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.