Data Warehouse & Pipeline Cost Audit
Review of what you export, what you actually query, and what it costs. Covers BigQuery, Snowflake, and PostHog with specific changes that cut the monthly bill.
What's included
What's flowing in
- Inventory of every pipeline writing into the warehouse, including GA4 exports, ad platform connectors, CDP syncs, and custom jobs
- Streaming and batch decisions with what each one costs you
- Event volume by source, with the share that has never appeared in a query
- Schema review covering nested fields, unused columns, and tables written but never read
- Duplicate ingestion, which happens more often than anyone expects once two tools sync the same source
Query and storage cost
- Cost breakdown by user, job, and scheduled query
- Partitioning and clustering on your largest tables
- Full table scans running hourly for dashboards nobody opens
- Materialized views and aggregate tables that would replace repeated scans
- Storage class and retention policy per dataset
- Slot or warehouse sizing if you're on a capacity model
PostHog and product data
- Event volume against what you query, since most PostHog bills are made of events nobody looks at
- Session replay sampling, retention, and masking settings
- Warehouse source joins and whether they behave the way you think
- Batch exports and destinations, plus filtering in the pipeline so you stop paying twice for the same rows
Governance
- Access control and who can run expensive queries
- Cost attribution by team or client if you run multi-tenant
- Alerting on cost anomalies
- Documentation of the pipeline end to end
Deliverable
- Cost breakdown showing where the money goes
- Ranked list of changes with estimated monthly savings
- Critical changes implemented
Why it matters
Warehouse bills grow quietly because nothing breaks when they do. A connector stays on for a project that ended, a scheduled query scans a full table every hour for a dashboard nobody opens, and the invoice creeps up until someone in finance asks about it.
Most of the savings are unglamorous. Partition the big tables, kill the exports nobody queries, sample replay properly, and replace the hourly full scans with an aggregate. The work takes a few days and the result lands on a line item your client already sees every month, which makes it one of the easier things to get signed off.
What clients say
“Thomas is a certified expert. Not only did he help set up all the Google and Facebook analytic tags/pixels, he was also very helpful in walking us through how to use them. He is very knowledgeable and friendly. Would 100% recommend him. Thanks for the great job Thomas!”
Bryce Alsten
“Working with SmartMetrics has made a huge difference in my business. I now know what is working on an hour by hour basis, and where to invest additional resources. I can’t recommend it highly enough.”
Brian Elliott
“Thomas has been very good to work with. Thank you, Thomas!”
Social Jobs
What clients say
“Tomas at SmartMetrics has been fantastic to work with. He consistently delivers high-quality work quickly, communicates clearly and proactively, and makes even complex implementations feel straightforward.”
Gray Digital Group
5.0 on Google · All reviews“A huge difference to the business, and we know where the next dollar goes.”
Blitzy“We can scale spend now without guessing what is actually working.”
PermitFlow“Extremely knowledgable & capable!”
Dj Haer Jr
Work with Tomas
Founder, San Diego, CA
20 years in marketing, CRO, CRM, and analytics. Now building the systems AI runs on.
You work with me directly, from scope to delivery. No account managers.