Yassin Abouzeid
Data Analyst / Engineer
New to Contra
Yassin is ready for their next project!
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
11
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
14
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)
1
16
Customer Analytics & Retention Dashboard | BigQuery + Looker Studio Marketing Intelligence
For this project, I built a complete customer analytics and retention intelligence dashboard for an aesthetic clinic to help them understand who their clients are, how they grow, and how well they retain them over time.
The goal was to transform raw operational data into clear strategic insights that support marketing decisions, acquisition strategies, and customer retention optimization.
Business Impact
This dashboard allows the clinic to:
✔ Identify the most valuable customer segments
✔ Understand client retention patterns
✔ Optimize marketing acquisition strategies
✔ Focus on high-retention treatments
✔ Track business growth year over year
1
26