Marketing Analytics Dashboard for Ads & RevenueYassin Abouzeid
Marketing data often lives in multiple tools — Meta Ads, Google Ads, Shopify, CRM systems, and spreadsheets. This makes it difficult to understand what is actually driving growth.
I build automated marketing analytics dashboards that centralize your data and give your team clear, decision-ready insights.
Using Looker Studio connected to BigQuery, I create dashboards that help marketing teams monitor performance, identify opportunities, and optimize campaigns faster.
What you will get
• Unified marketing performance dashboard
• Real-time visibility into campaigns and revenue
• Clear KPIs like ROAS, CPA, CAC, and conversion rates
• Campaign and channel comparison
• Funnel performance insights
• Clean and structured data models
Typical data sources
• Meta Ads
• Google Ads
• Shopify / Ecommerce platforms
• CRM systems (Pipedrive, HubSpot, etc.)
• Google Analytics
Deliverables
• Fully built Looker Studio dashboard
• Data source connections configured
• KPI definitions and business logic implemented
• Documentation for your team
Tools used
• Looker Studio
• Google BigQuery
• dbt
• SQL
FAQs
Example work
Contact for pricing
Duration1 week
Tags
dbt
Google BigQuery
Looker Studio
SQL
Data Analyst
Marketing Analytics Specialist
Analytics
Service provided by
Yassin Abouzeid Essen, Germany
Marketing Analytics Dashboard for Ads & RevenueYassin Abouzeid
Contact for pricing
Duration1 week
Tags
dbt
Google BigQuery
Looker Studio
SQL
Data Analyst
Marketing Analytics Specialist
Analytics
Marketing data often lives in multiple tools — Meta Ads, Google Ads, Shopify, CRM systems, and spreadsheets. This makes it difficult to understand what is actually driving growth.
I build automated marketing analytics dashboards that centralize your data and give your team clear, decision-ready insights.
Using Looker Studio connected to BigQuery, I create dashboards that help marketing teams monitor performance, identify opportunities, and optimize campaigns faster.
What you will get
• Unified marketing performance dashboard
• Real-time visibility into campaigns and revenue
• Clear KPIs like ROAS, CPA, CAC, and conversion rates
• Campaign and channel comparison
• Funnel performance insights
• Clean and structured data models
Typical data sources
• Meta Ads
• Google Ads
• Shopify / Ecommerce platforms
• CRM systems (Pipedrive, HubSpot, etc.)
• Google Analytics
Deliverables
• Fully built Looker Studio dashboard
• Data source connections configured
• KPI definitions and business logic implemented
• Documentation for your team
Tools used
• Looker Studio
• Google BigQuery
• dbt
• SQL
FAQs
Example work
Contact for pricing