Introduction
Monthly reports are essential for client retention — they show the value you’re delivering. But creating them manually takes 1-2 hours per client per month. With 10 clients, that’s 10-20 hours of report writing.
Automated monthly reports generate and send themselves: pull data from your tools, format it into a professional report, and email it to the client. Zero manual work.
What to include in a monthly report
For marketing clients
- Traffic (sessions, users, page views)
- Leads generated
- Conversion rate
- Top-performing content
- Social media metrics (followers, engagement)
- Ad performance (spend, clicks, conversions)
- Recommendations for next month
For web development clients
- Uptime (99.9%)
- Page speed (Core Web Vitals)
- Traffic and engagement
- Security updates applied
- Bug fixes and improvements
- Recommendations
For SEO clients
- Keyword rankings (movement)
- Organic traffic
- Backlinks gained
- Technical SEO issues fixed
- Content published
- Next month’s plan
Step 1: Data collection (automated)
import requests, os
from datetime import datetime, timedelta
# Google Analytics 4
def get_ga4_data(property_id, start_date, end_date):
from google.analytics.data_v1beta import BetaAnalyticsDataClient
from google.analytics.data_v1beta.types import RunReportRequest, DateRange, Metric, Dimension
client = BetaAnalyticsDataClient()
request = RunReportRequest(
property=f"properties/{property_id}",
dimensions=[Dimension(name="pagePath")],
metrics=[Metric(name="sessions"), Metric(name="totalUsers"), Metric(name="screenPageViews")],
date_ranges=[DateRange(start_date=start_date, end_date=end_date)],
)
response = client.run_report(request)
return response
# Google Search Console
def get_gsc_data(site_url, start_date, end_date):
from googleapiclient.discovery import build
service = build("searchconsole", "v1", credentials=creds)
request = {
"startDate": start_date,
"endDate": end_date,
"dimensions": ["query"],
"rowLimit": 25,
}
response = service.searchanalytics().query(siteUrl=site_url, body=request).execute()
return response.get("rows", [])
# Social media (example: Twitter API)
def get_twitter_metrics(handle):
# Use Twitter API v2
pass
Step 2: Generate report (PDF)
from fpdf import FPDF
from datetime import datetime
def generate_monthly_report(client_name, data, month, year):
pdf = FPDF()
pdf.add_page()
# Header
pdf.set_font("Arial", "B", 18)
pdf.cell(0, 12, f"Monthly Report — {client_name}", ln=True, align="C")
pdf.set_font("Arial", "", 12)
pdf.cell(0, 8, f"{month} {year}", ln=True, align="C")
pdf.ln(5)
# Traffic section
pdf.set_font("Arial", "B", 14)
pdf.cell(0, 10, "Website Traffic", ln=True)
pdf.set_font("Arial", "", 11)
pdf.cell(0, 7, f"Sessions: {data['sessions']:,}", ln=True)
pdf.cell(0, 7, f"Users: {data['users']:,}", ln=True)
pdf.cell(0, 7, f"Page Views: {data['page_views']:,}", ln=True)
pdf.cell(0, 7, f"Change from last month: {data['sessions_change']:+.1f}%", ln=True)
pdf.ln(5)
# SEO section
pdf.set_font("Arial", "B", 14)
pdf.cell(0, 10, "SEO Performance", ln=True)
pdf.set_font("Arial", "", 11)
pdf.cell(0, 7, f"Organic Traffic: {data['organic_traffic']:,}", ln=True)
pdf.cell(0, 7, f"Top Keyword: {data['top_keyword']} (Position {data['top_keyword_pos']})", ln=True)
pdf.cell(0, 7, f"New Backlinks: {data['new_backlinks']}", ln=True)
pdf.ln(5)
# Social media section
pdf.set_font("Arial", "B", 14)
pdf.cell(0, 10, "Social Media", ln=True)
pdf.set_font("Arial", "", 11)
pdf.cell(0, 7, f"Followers: {data['followers']:,} (+{data['follower_growth']})", ln=True)
pdf.cell(0, 7, f"Engagement Rate: {data['engagement_rate']:.1f}%", ln=True)
pdf.cell(0, 7, f"Posts Published: {data['posts_published']}", ln=True)
pdf.ln(5)
# Recommendations
pdf.set_font("Arial", "B", 14)
pdf.cell(0, 10, "Recommendations for Next Month", ln=True)
pdf.set_font("Arial", "", 11)
for rec in data["recommendations"]:
pdf.cell(0, 7, f"• {rec}", ln=True)
pdf.ln(5)
pdf.set_font("Arial", "I", 9)
pdf.cell(0, 6, "Generated automatically. Questions? Reply to this email.", ln=True)
filename = f"report_{client_name.replace(' ', '_')}_{month}_{year}.pdf"
pdf.output(filename)
return filename
Step 3: Send via email
import resend, os, base64
resend.api_key = os.environ["RESEND_API_KEY"]
def send_report(client_name, client_email, filename):
with open(filename, "rb") as f:
pdf_data = base64.b64encode(f.read()).decode()
month = datetime.now().strftime("%B %Y")
resend.Emails.send({
"from": "Reports <[email protected]>",
"to": [client_email],
"subject": f"Monthly Report — {client_name} — {month}",
"html": f"""
<p>Hi {client_name},</p>
<p>Please find attached your monthly report for {month}.</p>
<p>Key highlights:</p>
<ul>
<li>Traffic: [X] sessions (+Y%)</li>
<li>Leads: [X] new leads</li>
<li>Top keyword: [keyword] (position [X])</li>
</ul>
<p>Let me know if you have any questions!</p>
<p>Best,<br>Your Name</p>
""",
"attachments": [{"filename": filename, "content": pdf_data}],
})
print(f"Report sent to {client_name}")
Step 4: Automate with cron
# Run on the 1st of every month at 9 AM
0 9 1 * * cd /path/to/project && python generate_reports.py
Or GitHub Actions:
name: Monthly Reports
on:
schedule:
- cron: '0 9 1 * *'
jobs:
reports:
runs-on: ubuntu-latest
steps:
- uses: actions/checkout@v4
- run: pip install fpdf google-analytics-data google-api-python-client
- run: python generate_reports.py
Step 5: Google Sheets data source (no-code alternative)
For non-developers, use Google Sheets + Apps Script:
function generateMonthlyReport() {
const sheet = SpreadsheetApp.getActiveSpreadsheet();
const data = sheet.getSheetByName("Metrics").getDataRange().getValues();
// Calculate metrics
const sessions = data[data.length - 1][1];
const prevSessions = data[data.length - 2][1];
const change = ((sessions - prevSessions) / prevSessions * 100).toFixed(1);
// Create report doc
const doc = DocumentApp.create("Monthly Report - " + new Date().toLocaleString("default", {month: "long", year: "numeric"}));
const body = doc.getBody();
body.appendParagraph("Monthly Report").setHeading(DocumentApp.ParagraphHeading.HEADING1);
body.appendParagraph(`Sessions: ${sessions} (${change}% vs last month)`);
body.appendParagraph(`Users: ${data[data.length - 1][2]}`);
// ... add more metrics
// Email the doc
const pdf = doc.getAs(MimeType.PDF);
GmailApp.sendEmail("[email protected]", "Monthly Report", "Please find attached.", {attachments: [pdf]});
}
What to include in reports (by client type)
Marketing clients
- Traffic (sessions, users, page views)
- Leads generated
- Conversion rate
- Top-performing content
- Social media metrics
- Ad performance (spend, clicks, conversions)
- Recommendations for next month
Web development clients
- Uptime (99.9%)
- Page speed (Core Web Vitals)
- Traffic and engagement
- Security updates applied
- Bug fixes and improvements
- Recommendations
SEO clients
- Keyword rankings (movement)
- Organic traffic
- Backlinks gained
- Technical SEO issues fixed
- Content published
- Next month’s plan
Social media clients
- Follower growth
- Engagement rate
- Top-performing posts
- Content published
- Audience demographics
- Recommendations
Common mistakes
- Too long — 2-3 pages max. Clients skim.
- No context — “Sessions: 5,000” means nothing. Add “vs last month: +12%”.
- No recommendations — data without insights is useless. Always include 2-3 actionable recommendations.
- Late delivery — send on the 1st or 2nd of the month. Late reports look unprofessional.
- Generic template — customize for each client’s KPIs. Don’t send the same report to everyone.
- No visual — include at least one chart. Visuals are easier to digest than numbers.
Key Concepts
- Monthly report = summary of performance metrics for a client
- KPI = Key Performance Indicator (the metrics that matter)
- Automated report = generated and sent without manual intervention
- Cron job = scheduled task that runs automatically
- GA4 = Google Analytics 4 (website analytics)
What to Try Next
- Automate invoices for payment tracking
- Track freelance income and expenses for finances
- Build a report dashboard in Streamlit
- Organise client projects with a system
FAQ
How long should a monthly report be?
1-2 pages. Include: key metrics (3-5 numbers), one chart, 2-3 recommendations, and next steps. Clients don’t read 10-page reports.
Should I send reports even if the month was bad?
Yes — especially then. Clients appreciate transparency. Frame it positively: “Traffic was down 10% due to [reason]. Here’s our plan to recover.” Hiding bad news destroys trust.
What if I don’t have access to the client’s analytics?
Ask for access during onboarding. If they won’t share, use the data you have (your own tracking, social media metrics, etc.). A partial report is better than no report. See Client Onboarding Questionnaire.