About

Scope of Work: Marketing Performance Dashboard (Looker Studio) Objective To design and build a live top-of-funnel marketing performance dashboard in Looker Studio, aggregating data from Google Analytics, LinkedIn, and Google Search Console. The dashboard will provide visibility into key brand awareness and engagement metrics across website performance, search visibility, and social activity, enabling monthly trend analysis and insight into campaign effectiveness. Project Overview The dashboard will visualise key marketing performance indicators to track the impact of ongoing campaigns and identify opportunities to optimise. Data connections are already established from: Google Analytics LinkedIn Google Search Console This project focuses on designing visualisations, configuring filters, and ensuring data accuracy for the following defined metrics. Data Sources & Metrics 1. Google Analytics Metrics: Website Visits (6-Month Trend) Total sessions and users Visualised as a line or bar chart by month Website Conversions Total demo bookings via the website Conversion rate over time Meetings Booked This Month Number of meetings booked via the website in the current month Meetings Booked Over Time Monthly trend of meetings booked via the website Attribution Overview Channel contribution to website conversions (e.g. organic, paid, referral, social, direct) 2. LinkedIn Metrics: New Followers This Month Count of followers gained in the current month Trend view of growth compared to the previous month Engagement This Month Engagement rate and total interactions (likes, comments, shares, clicks) Top-performing posts by engagement Followers Over Time Line chart visualising follower growth month by month 3. Google Search Console Metrics: Top 5 Search Terms (by Impressions) Filterable by region: UK / US Top 5 Traffic Search Terms (by Clicks) Filterable by region: UK / US Filters & Functionality Date range filter: Default to “Last 6 Months,” with the ability to adjust Region filter: UK / US toggle Source filter: (Optional) To view data by individual channel Annotations: Optional notes to mark campaign launches or major events Visualisation Please see the suggested layout for the data here. Deliverables Fully built Looker dashboard with connected and validated data sources Dashboard user guide (brief walkthrough document)