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
- 3
- Followers
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