YDA LabsData Engineer | BigQuery, dbt, n8n | Marketing & Sales Data Warehouses

Projects

Real client work. Client names are left out; every number comes from the project itself.

DTC e-commerce

Meta + TikTok ads kill list

A BigQuery + dbt pipeline that tells a media buying team every morning, in Slack, which Meta and TikTok ads to switch off, based on their own spend and ROAS rules.

  • ✔106 losing ads flagged in the first 13 days
  • ✔Spend on flagged ads dropped by about half (estimate)
  • ✔Stale data triggers an alert instead of a wrong list
Windsor.aiBigQuerydbtn8nSlackLooker Studio
Read the case study

Healthcare / aesthetic clinic

CRM sales warehouse: Pipedrive → BigQuery

An automated, incremental and deduplicated Pipedrive → BigQuery pipeline, modelled in dbt, with a Looker Studio sales report covering inquiries, quotations and conversion per treatment and customer type.

  • ✔6 years of sales history in one place (Oct 2020 → 2026)
  • ✔~4.8K inquiries and ~1.5K quotations, no more manual exports
  • ✔Existing patients convert at 54.0% vs 45.2% for new ones
Pipedrive APIn8nBigQuerydbtLooker Studio
Read the case study

Healthcare / aesthetic clinic

Revenue analytics from accounting data

The clinic's accounting data (bexio) automated into BigQuery and mapped from ledger accounts to business meaning, so revenue is split by business unit, treatment category and treatment in one report.

  • ✔Revenue 2019 → 2026 in one model
  • ✔Every booking classified by business unit, category and treatment
  • ✔Inquiry → quotation → revenue in one report with the CRM warehouse
bexio APIn8nBigQuerydbtLooker Studio
Read the case study

Healthcare / aesthetic clinic

Patient retention & cross-sell from a system with no API

A booking system with no API brought into BigQuery through a Drive → AppSheet/Apps Script pipeline, modelled in dbt, showing which treatments bring patients back and how fast.

  • ✔32% of patients return within 3 months, 55% within 12
  • ✔Time to return per treatment, so reminders go out at the right moment
  • ✔Surgery follow-up rate fell from ~42% to ~23%: a revenue opportunity
Google DriveAppSheetApps ScriptBigQuerydbtLooker Studio
Read the case study

Marketing agency (paid media, lead gen)

Agency ad data warehouse with alerts and a lead check

Scattered Google Ads, Meta and GA4 tables turned into a BigQuery star schema, with Looker Studio alerts on spend, CPA, CTR and ROAS per ad group and a check that catches lead-tracking gaps.

  • ✔One model for 1,000+ client accounts
  • ✔Daily to 30-day alerts per ad and ad group
  • ✔Lead check caught alignment dropping from 97% to ~57%
Windsor.aiBigQuerySQLGA4 exportLooker Studio
Read the case study

E-commerce, 13 country markets

Google Ads year-over-year dashboard, 13 markets

A Google Ads dashboard for ~80 campaigns across 13 countries: year-over-year KPI cards, spend vs revenue efficiency, and a like-for-like comparison that still works after every PMAX campaign was rebuilt.

  • ✔~80 campaigns, 13 country markets, one view
  • ✔Fair YoY comparison despite rebuilt PMAX campaigns
  • ✔First version 2 days after kickoff
Google AdsLooker Studio
Read the case study

Sports / youth training (local lead generation)

Meta lead-gen dashboard with recommended actions

A decision-focused Looker Studio dashboard for Meta lead campaigns: cost per lead, a lead score per ad set and city, creative lifecycle tracking, and recommended actions written into the report.

  • ✔Website and on-Facebook leads in one funnel
  • ✔Lead score per ad set and per city
  • ✔Recommended actions built into the report
Meta AdsLooker Studio
Read the case study

Engineering / surveying (HR & recruitment)

AppSheet recruitment app on a spreadsheet HR database

A spreadsheet HR database turned into an AppSheet recruitment app with campaigns, a candidate pipeline, interview questions per role and status emails, approved within 5 days.

  • ✔Prototype demoed 5 days after the offer, approved the same day
  • ✔Became the blueprint for the client's in-house HR platform
  • ✔Re-hired for a second job · 5.0 review
AppSheetGoogle SheetsApps ScriptAppSheet bots
Read the case study

Live demo · sample data

Google Ads performance dashboard

Account overview, cost vs conversions, campaign and ad group tables. Built on a demo account so you can click through it.

Open the demo in Looker Studio

Want something similar?

Send me what you're trying to decide. I'll tell you honestly whether a warehouse is worth it or a simpler setup will do.

Book a 30-min call Email me

yassin-abouzeid@ydalabs.com · or hire me on Upwork, Malt or Contra