Not specified
23 proposals
Create a single universal marketing report template in Looker Studio. The main requirement is scalability. The structure and data sources must be set up so that agency employees can copy the report, change the data sources to the accounts of a new client, and all charts and tables will recalculate automatically without additional editing of elements.2. Data Sources (Connectors) The report should only use standard (free from Google) connectors or clearly defined third-party solutions: Google Analytics 4 (GA4): with mandatory pulling of e-commerce events (revenue, transactions, conversion rate, purchased products). Google Search Console (GSC): site data (Impressions, Clicks, CTR, Average Position) at the domain and URL level. Google Business Profile (formerly GMB): integration via free connector or export to Google Sheets (if local metrics are needed: calls, directions, views). Clarify with the executor the optimal option.3. Report Structure (Estimated Pages/Blocks) Page 1: Executive Dashboard (KPI Executive Summary) Total traffic, total e-commerce revenue, number of transactions, comparison with the previous period (YoY / MoM). Page 2: SEO Performance (Search Console + GA4) Dynamics of clicks and impressions. Table of TOP queries and TOP landing pages with average position, CTR. Sessions and conversions strictly from the Organic Search channel. Page 3: E-commerce Analytics (GA4) (manually because most projects are service businesses) Purchase funnel (product views -> add to cart -> purchase). Table of category and individual product performance (revenue, quantity). Analysis of traffic sources (Source / Medium) that generate revenue. Page 4: Local SEO (Google Business Profile) Dynamics of interactions (clicks to the site, calls, directions).4. Technical Requirements for Template Creation All data sources must be Embedded or clearly structured as Reusable, so that when copying, Looker Studio suggests replacing them with new ones. Single corporate style of the agency (colors, fonts, logo are set through the report theme, so they can be changed with one click for the entire document). Availability of filters on each page: date selection (Date Range Selector), filter by categories/devices.
If something similar has already been done - please indicate in the bid,