Custom KPI Dashboard Integration

I need a single, easy-to-read KPI dashboard that pulls live data from Google Analytics, Google Ads, and Microsoft Clarity so I can compare organic versus paid performance in one place. The core of the work is connecting the three platforms, shaping the data properly, and visualising the metrics that matter to me.

Google Ads metrics to surface:
• Click-Through Rate (CTR)
• Cost Per Click (CPC)
• Conversion Rate
• Bounce Rate

Google Analytics metrics to surface:
• User Sessions
• Bounce Rate
• Goal Completions

From Microsoft Clarity I want the standard behavioural insights—heat-maps, session recordings, and any additional engagement indicators you can expose—to sit alongside the numbers above.

The finished dashboard should:
• Refresh automatically (no manual CSV uploads).
• Offer quick filters for date range, traffic source, campaign, and landing page.
• Present a clear split between paid and organic traffic with trend lines and headline figures.
• Be shareable with my wider team without extra licence costs.

Please build in the BI tool you are most comfortable with—Looker Studio, Power BI, or Tableau are all acceptable—as long as it stays free for viewing and gives me edit access. Include a short hand-over video or document so I know how to maintain and extend the report later.

I’m ready to start immediately and will provide account access as soon as we agree on the approach and staging milestones.