Custom Google Looker Studio Dashboard for E-commerce Marketing Attribution

Category: Data Science

Budget: 1525–1525 USDC

We are seeking an experienced data analyst to build a comprehensive marketing attribution dashboard for our Shopify store. The goal is to consolidate data from Google Ads, Meta Ads, and GA4 to visualize the customer journey and ROAS across multiple channels. You will be responsible for creating a unified data schema using BigQuery, setting up automated data pipelines, and designing an interactive Looker Studio report. Deliverables include a live dashboard with drill-down capabilities for campaign-level performance, a documented data dictionary, and a brief video walkthrough of the setup. We require this project to be completed within three weeks, including a round of revisions based on initial stakeholder feedback. The ideal candidate has deep expertise in SQL and proven experience with multi-channel attribution modeling.

Skills required

• Google Looker Studio
• BigQuery
• SQL
• Google Analytics 4
• Data Visualization

Milestones are funded into USDC escrow on Polygon before work begins.