Custom Google Analytics 4 (GA4) & BigQuery Dashboard for E-commerce

Category: Data Science

Budget: 1850–1850 USDC

We are seeking an experienced Data Analyst to architect a comprehensive performance dashboard for our multi-channel e-commerce platform. The project involves three primary phases: first, auditing our current GA4 implementation to ensure event tracking (purchase, add_to_cart, and user_journey) is firing correctly across web and mobile. Second, you will configure a daily automated export of raw GA4 data into BigQuery to circumvent API quota limits and data sampling issues. Finally, you will build a dynamic, multi-page Looker Studio dashboard that visualizes customer acquisition costs (CAC), lifetime value (LTV), and funnel conversion rates. The ideal candidate will provide clean SQL scripts for data transformation and a final documentation report. We expect this project to be completed within a 3-week timeline, including one week of post-launch monitoring and bug fixing.

Skills required

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

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