Freelancers using Google BigQuery in Essen
Freelancers using Google BigQuery in Essen
Sign Up
Post a job
Sign Up
Log In
Filters
2
Projects
People
Yassin Abouzeid
Essen, Germany
Analytics Engineer | BigQuery, dbt, Looker Studio
New to Contra
Follow
Message
Analytics Engineer | BigQuery, dbt, Looker Studio
1
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
99
1
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
111
3
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
113
1
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
96
Google BigQuery
(4)
Follow
Message
Explore people
