Lemlist Campaign Performance Tracker

Task

Use @Lemlist/Get Many CampaignsName it "Lemlist/Get Many Campaigns" and call it with @Lemlist/Get Many Campaigns to pull all active and completed campaigns, then use @Lemlist/Get StatsName it "Lemlist/Get Stats" and call it with @Lemlist/Get Stats for each campaign to get open rates, click rates, reply rates, and bounce rates. Use @Lemlist/Get Many ActivitiesName it "Lemlist/Get Many Activities" and call it with @Lemlist/Get Many Activities to find which specific leads are engaging. Finally, use @Google Sheets/Append RowsName it "Google Sheets/Append Rows" and call it with @Google Sheets/Append Rows to export a performance report to a spreadsheet.

Example: Pull last month's campaign stats, rank them by reply rate, and export the report to my "Outbound Metrics" Google Sheet.

Input

The user will provide:

1. Time period to analyze (last week, last month, Q1, etc.)
2. (Optional) Specific campaign names to focus on
3. (Optional) Google Sheet URL or name for export
4. (Optional) Specific metrics they care about most

Example: "How did my cold outreach campaigns perform last month? Export to my tracking sheet."

Context

Metrics to Track

Campaign-level metrics:

• Open rate (benchmark: 40-60% for cold email)
• Click rate (benchmark: 3-7%)
• Reply rate (benchmark: 5-15% for cold outreach)
• Bounce rate (should be under 3%)
• Unsubscribe rate (should be under 1%)

Engagement analysis:

• Which campaigns have the highest reply rates
• Which subject lines drive the most opens
• What time/day do leads engage most
• Which leads opened but did not reply (warm leads to follow up on)

Analysis Strategy

1. Pull all campaigns and their configurations
2. Get stats for each campaign in the specified time period
3. Rank campaigns by the metric that matters most (usually reply rate)
4. Pull activities to identify hot leads (multiple opens, clicks, replies)
5. Export the compiled data to Google Sheets

What Makes a Good Report

• Compare campaigns against each other, not just benchmarks
• Highlight statistical outliers (both good and bad)
• Identify leads who engaged but have not replied yet
• Note campaigns with high bounces that need list cleaning
• Track trends over time if historical data is available

Output

Campaign Performance Overview:

| Campaign | Sent | Opens | Open Rate | Clicks | Click Rate | Replies | Reply Rate | Bounces | |----------|------|-------|-----------|--------|------------|---------|------------|---------| | [Campaign 1] | [X] | [X] | [X%] | [X] | [X%] | [X] | [X%] | [X] | | [Campaign 2] | [X] | [X] | [X%] | [X] | [X%] | [X] | [X%] | [X] |

Top Performing Campaign: [Name] with [X%] reply rate

Needs Attention: [Name] has [X%] bounce rate (above 3% threshold)

Hot Leads (Engaged But No Reply):

• [Name] at [Company] - Opened [X] times, clicked [X] links
• [Name] at [Company] - Opened [X] times

Key Insights:

• [Observation about what is working]
• [Observation about what needs improvement]
• [Recommendation for next campaign]

Exported to: [Google Sheet name/URL]