Marketing Analytics
How to Calculate Meta Ads ROAS in BigQuery
Calculate Meta Ads ROAS in BigQuery with SQL you can reuse — the core query, ROAS by campaign and over time, and the gotchas that make BigQuery and Ads Manager disagree.
· 9 min read
Blog
Notes on data, analytics, and the tools I use — written as I learn.
Marketing Analytics
Skyvia Facebook Ads Replication Completed but the BigQuery Table Is Empty
A Skyvia Facebook Ads replication can finish successfully yet leave the BigQuery table empty or stale. Diagnose the cause with a clear checklist and non-destructive BigQuery SQL.
· 12 min read
Power BI & Dashboards
Building My First Power BI Dashboard: A Step-by-Step Walkthrough
How I turned a raw sales CSV into a clean Power BI dashboard — importing data, shaping it in Power Query, modelling it, writing DAX measures, and designing the report.
· 4 min read
CRM & Salesforce
What a CRM Actually Does (and Why Clean Data Matters)
A plain-English look at what a CRM like Salesforce is really for, why CRM data quality matters, and how messy data quietly breaks the reports and dashboards built on top of it.
· 4 min read
SQL & Data Wrangling
The 8 SQL Queries I Use in Almost Every Analysis
The core SQL queries for data analysis — filtering, grouping, joins, window functions, and CTEs — explained with beginner-friendly examples you can reuse.
· 4 min read
Career & Learning Notes
Why I Started Writing About Data
An introduction to this blog — why I'm learning in public and what I'll be writing about.
· 2 min read