Automated Daily Performance Reporting with BigQuery and Apps ScriptAutomated Daily Performance Reporting with BigQuery and Apps Script
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
A project I enjoyed building: an automated daily performance report.
Before: someone copy-pasted numbers every morning. After: BigQuery SQL pulls the data, Apps Script processes it, and a 7 AM trigger refreshes one shared Google Sheet. It shows Day, WTD and LWTD comparisons with colour-coded changes.
Less manual work, and the same metric definitions every day.
(Sample data. Full project is in my Work tab.)
What's one report you still build by hand every week?
Post image
Back to feed
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started