Projects using dbt in Essen
Projects using dbt in Essen
Sign Up
Post a job
Sign Up
Log In
Filters
2
Projects
People
1
Yassin Abouzeid
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
1
Yassin Abouzeid
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
3
Yassin Abouzeid
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
Explore projects