Weekly Growth Report
Run this every week (Monday morning recommended) to collect the prior week's data from all three tools, spot what moved, and produce the weekly growth report in Google Sheets with an executive summary for leadership.
- Open the reporting period: define "last week" as Monday 00:00 through Sunday 23:59 in the team's local time zone.
- Pull from Google Analytics: total sessions, new users, channel breakdown (organic, paid, direct, referral, social, email), top 10 pages by sessions, bounce rate, and goal completions (form fills, demo requests, or whatever the team's primary goal is).
- Pull from HubSpot: new contacts created, new MQLs, new SQLs, and for any active campaigns, impressions, clicks, click-through rate, and conversions.