Freelance › Projects › Software development › Build a Google Looker Studio marketing dashboard with automated email delivery
Build a Google Looker Studio marketing dashboard with automated email delivery
Employer
Mykola
Project parameters
Type of cooperationOne-time project
SectionSoftware development
Prepaymentwithout prepayment
Payment methodsCash, Bank transfer
Acceptance of requestsfrom today, 03:54 until Aug 31, 2026
Project description
We run several marketing channels and currently pull numbers by hand from Google Analytics 4, Google Ads and a couple of Google Sheets every week. It eats hours and the figures never quite line up. I want a single, well-designed Looker Studio (formerly Data Studio) report that becomes our source of truth, so the team stops digging through raw exports and just opens one link. This is specifically a Looker Studio project, not Power BI or any desktop BI tool, because we live inside the Google ecosystem and need everything to stay native and shareable by URL.
The job is to connect the data sources correctly, model them into clean fields, and lay out a dashboard that a non-analyst can actually read. I expect a top summary page with the key KPIs (spend, clicks, conversions, cost per conversion, ROAS), then drill-down pages by channel and by campaign. Interactive controls are important: a date-range selector, plus filters by channel, campaign and device that update the whole page. Where GA4 and Ads figures overlap I need the blending done properly so we are not double counting, and calculated fields for the derived metrics. Please keep the design consistent and legible, with sensible colors, clear labels and no clutter.
Finally, set up scheduled delivery so a PDF snapshot lands in our inboxes automatically on a fixed schedule, and make sure sharing permissions are set so stakeholders can view without editing. At handover I would like a short walkthrough (a call or a recorded video) plus a one-page note on how the sources are connected and how to add a new campaign later, so we can maintain it ourselves.
— Connect and validate GA4, Google Ads and Google Sheets data sources
— Data blending and calculated fields, no double counting
— Summary KPI page plus channel and campaign drill-downs
— Interactive date range, channel, campaign and device filters
— Scheduled email/PDF delivery and correct view-only sharing
— Handover walkthrough and a short maintenance note
The job is to connect the data sources correctly, model them into clean fields, and lay out a dashboard that a non-analyst can actually read. I expect a top summary page with the key KPIs (spend, clicks, conversions, cost per conversion, ROAS), then drill-down pages by channel and by campaign. Interactive controls are important: a date-range selector, plus filters by channel, campaign and device that update the whole page. Where GA4 and Ads figures overlap I need the blending done properly so we are not double counting, and calculated fields for the derived metrics. Please keep the design consistent and legible, with sensible colors, clear labels and no clutter.
Finally, set up scheduled delivery so a PDF snapshot lands in our inboxes automatically on a fixed schedule, and make sure sharing permissions are set so stakeholders can view without editing. At handover I would like a short walkthrough (a call or a recorded video) plus a one-page note on how the sources are connected and how to add a new campaign later, so we can maintain it ourselves.
— Connect and validate GA4, Google Ads and Google Sheets data sources
— Data blending and calculated fields, no double counting
— Summary KPI page plus channel and campaign drill-downs
— Interactive date range, channel, campaign and device filters
— Scheduled email/PDF delivery and correct view-only sharing
— Handover walkthrough and a short maintenance note
