Looker Studio / Hubspot Connection

Greetings and Happy New Year!

I need help with connecting different data sources into a comprehensive C-Level dashboard in Looker Studio.
It aggregates data from Google Ads, Google Analytics, HubSpot, and Google Sheets. The goal is to create a dashboard that shows how our marketing expenses for Ads are comparing to the leads we get and the website traffic we generate.

The dashboard is partly up. What is missing:
* Help me make it visually compelling and easy to understand.
* Help me integrate the data from HubSpot.
* Help me double-check if the funnel is set up correctly: Does all the data flow correctly from Google Ads via Tag Manager in Analytics and HubSpot? Or is there something amiss?

Difficulty of this gig:

I have worked with 3 other data scientists/ agencies already. One was an expert in Tag Manager, one was a HubSpot expert, and another one was specialized in Data Visualization. But: The data flow is still buggy, and the dashboard is unusable.

If you can bring all the elements together, I am looking forward to your application. If you are lacking expertise in one of the above mentioned systems, and especially have never worked with HubSpot, please let me know - we have a bit of time pressure here. We can not loose any more time in trying out, but I would love to work with someone who can help me make a breakthrough in the next 10 days.

Thank you for your time,
Hellena