Cutting BigQuery Costs by 12x for NewzDash
NewzDash is a SaaS platform that helps media companies and SEO teams stay ahead by delivering real-time SEO news, fast, summarized, and relevant.
Project Type: Audit & Analytics, Data Management, Query Optimization, Cost Optimization
Tools Used: Google Cloud (BigQuery), Looker Studio
12x
lower BigQuery costs, slashing monthly cloud spend.
50%
faster queries, saving ~$830 in two weeks.
100%
visibility with real-time cost tracking dashboard.
A 12x Cost Reduction in BigQueryy
NewzDash
Business Optimization
The Challenge
As NewzDash scaled and onboarded new enterprise clients, its Google Cloud costs skyrocketed.
Each new client meant almost equivalent costs in BigQuery usage, making onboarding financially unsustainable.
Despite having working analytics, the underlying codebase was messy and unoptimized, with inefficiencies hidden in the way data was queried and processed.
Previous vendor experiences had also left the founder hesitant about bringing in external help again.
The Core Problem
-
The objective was clear: identify and fix the cause of high BigQuery costs without affecting live production.
-
It wasn’t only a technical issue—it was a major obstacle to business growth.
-
Uncontrolled costs meant NewzDash couldn’t scale its client base in a profitable way.
The Solution
MarketLytics proposed a focused two-week engagement:
1 week of Discovery
-
Holistic audit of BigQuery infrastructure, identifying the top 10 most frequently use and top 10 most expensive queries.
1 week of Optimization
-
Fixing the “low-hanging fruit” that had the biggest cost and performance impact.
Our Approach Included:
-
A complete audit of infrastructure, partitions, and query performance.
-
Query-level optimization, rewriting the most resource-heavy queries for efficiency.
-
Dashboarding & Monitoring: Built a Looker Studio dashboard to monitor ongoing query cost, performance trends, and post-deployment improvements.
-
Post-Deployment Support: Deployed fixes and validated results over a two-week observation period.
-
Combine conversions across properties into one primary goal for clear, centralized reporting
The Result
-
BigQuery expenses shifted from unpredictable to measurable and manageable.
-
Query optimization now directly links performance to cost visibility.
-
The team can confidently onboard new clients without cost uncertainty.
-
Profitability scales with each new customer instead of shrinking.
-
Combine conversions across properties into one primary goal for clear, centralized reporting
Within just two weeks, NewzDash reshaped its cloud spending strategy, converting a major cost burden into a controlled and trackable process.
We’re big on SEO, paid search, and display video. So we need data from these channels and very clear insights to improve our decision-making. MarketLytics enabled us to be better at our internal decision-making on where to spend and when..
Martijn Scheijbeler
SVP Marketing
Master Attribution with Omair 📊
Ready to optimize your marketing spend?
We build custom solutions to uncover what drives results, ensuring every dollar delivers maximum impact.
Are you Ready to Fast Track your Marketing Attribution Decisions and Maximize your ROI?
Businesses that leverage automated marketing attribution see a 20-30% improvement in ad spend efficiency.