Projects using dbt in Essen

Projects using dbt in EssenProjects using dbt in Essen

Cover image for I built an automated CRM

I built an automated CRM data pipeline that syncs Pipedrive data into Google BigQuery, cleans it, prevents duplicates, and prepares it for advanced reporting in Looker Studio. The goal was to eliminate: Manual exports Inconsistent deal data Duplicate records Broken reporting logic ⚙️ Tech Stack Pipedrive API n8n (API orchestration & pagination) Google BigQuery (Data Warehouse) dbt (Data modeling) Looker Studio (Reporting layer)

1

67

Cover image for This project focuses on turning

This project focuses on turning raw Meta Ads data into clear, decision-ready insights for performance optimization and budget allocation. Instead of reporting isolated metrics like CPC or CTR, the goal was to understand where spend actually converts into quality leads — and where performance silently breaks down across the funnel. The dashboard was built to support daily and weekly decision-making for marketing and growth teams.

1

74

Cover image for I built a marketing performance

I built a marketing performance analytics dashboard that helps marketing teams quickly identify which campaigns, audiences, and ad groups are actually driving conversions — and which ones are wasting budget. The goal of this dashboard is simple: “Inside a campaign, what is actually working?” Instead of only tracking high-level metrics, the dashboard breaks performance down into campaign and ad group level insights, enabling faster optimization decision The dashboard tracks the full marketing funnel: Impressions Clicks Conversions Spend CTR (Click Through Rate) CVR (Conversion Rate)

3

83