Task
It is necessary to build a unified interactive dashboard in Google Looker Studio that will consolidate data from several sources (Pipedrive, Dribbble, Behance, Clutch, Google Analytics, Paid Search, etc.), with the possibility of future expansion (LinkedIn Ads, Facebook Ads). The dashboard should help marketing and sales see the funnel, conversions at each stage, unit economics, and effectiveness by countries/accounts.
Data Sources
Pipedrive (CRM)
Dribbble, Behance, Clutch (marketing channels)
Google Analytics (GA4)
Paid Search (Google Ads)
In the future: LinkedIn Ads, Facebook Ads
Main Requirements
Integration of all sources into a single dashboard (via API/connectors or alternative methods).
Visualization of the sales and marketing funnel with details by stages.
Segmentation: countries, accounts, channels, funnel stages.
Unit economics:
Cost per Traffic (by campaign / case study / shot)
Cost per Lead (CPL)
Cost per MQL
Cost per SQL
CAC (Customer Acquisition Cost)
ROMI (Return on Marketing Investment)
LTV (Customer Lifetime Value)
Data update: once every half day (near real-time).
Ability to export data to Google Sheets.
Access rights segregation (Sales, Marketing, CEO).
Flexible structure: data for each channel separately + overall summary.
Technical Details
All accesses will be provided.
Tracking in GA4 is already set up.
Connection setup, data modeling, and visualization building are needed.
Timeline
1.5–2 months (ready to discuss phased delivery of work).
