Connect 3 Data Sources into One Dashboard (MongoDB + Google Sheet + Google Ads)

We're a smallAustralian business. We need a full-stack developer to connect three existing data sources into one dashboard so we can finally see which ad campaigns produce real sales not just leads. The task: We have three data sources that have never been joined: • MongoDB Atlas — our leads (website form submissions) • A Google Sheet (populated by Zapier) — our sales/connections • Google Ads — our ad spend by campaign All three contain the customer email address. Your job is to match them on email so that, for each ad campaign, we can see: leads, sales, conversion rate, revenue, and true cost per sale. Output a single clean, refreshable dashboard. Definition of done: We can open one view and see, per campaign — leads, connections, conversion %, revenue, and cost per connection. Important: Sales data has duplicates (one customer can generate multiple confirmation emails) — these must be de-duplicated on email. A detailed brief with all logic and access will be provided on hire. Out of scope: No changes to our live website or backend, no version control work — this is purely the data connection. Skills: MongoDB, Google Sheets/Zapier data, Google Ads data, and dashboard building (Looker Studio or similar). To apply, please answer briefly: 1. Have you joined data from separate sources (a database + a spreadsheet) on a shared field like email before? Give one example. 2. What tool would you use for the dashboard, and why? 3. Your availability to start if selected? Please answer the 3 questions in one sentence each