Projects using Google BigQuery in Essen

Projects using Google BigQuery in EssenProjects using Google BigQuery 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

99

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

111

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

113

Cover image for Customer Analytics & Retention Dashboard

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