Data Studio (Looker Studio) Report

DATA STUDIO (LOOKER STUDIO) REPORT: a live, editable dashboard in the user's own Google account. Other report requests are answered with marketing_report_pdf, which returns the finished report as a direct download link. This tool creates a professional, chart-based Data Studio report on the user's OWN Google account, fed live by Opus Growth: Google Ads, Meta Ads, TikTok Ads, LinkedIn Ads, Microsoft Advertising and ChatGPT Ads in one data source (daily campaign rows; spend, impressions, clicks, conversions, conversion value, CTR, CPC, CPM, CPA, ROAS). Returns a one-click Data Studio link; opening it copies Opus Growth's designed ten-page template and connects every page to the user's own data. page = the page it opens on: cover (default; title page with the client's name, the period, an executive summary in plain sentences and the report contents) | summary (KPI cards vs the previous period with sparklines, daily spend and conversions, channel mix, platform table, top campaigns) | website (GA4: sessions, users, key events by channel and day, top landing pages) | organic (Search Console: organic clicks, impressions, CTR, average position, top queries and pages) | business_profile (Business Profile: Search and Maps views, calls, direction requests, website clicks per day) | campaigns (budget, budget pacing, projected month spend, impression share and impression share lost to budget and rank, full campaign table, daily spend by platform, spend by campaign type) | audience (device, gender, age, country map, audience table) | ads (ad-level table, spend vs conversions, CTR and cost per conversion over time) | search (top search terms, Quality Score with expected CTR, ad relevance and landing page experience, search terms that spent without converting = negative keyword candidates) | findings (prioritised findings and recommended next steps from Opus Growth's own analysis: wasted search term spend, conversion tracking health, impression share loss, budget pacing, low Quality Score, Google's own recommendations with projected impact, campaigns without conversions or with outlier cost per conversion). The report stays live and editable and can be shared, scheduled by email and downloaded as PDF in Data Studio. platforms = comma-separated subset (google_ads, meta, tiktok, linkedin, microsoft, chatgpt_ads); empty = every connected platform. accounts = comma-separated account ids (or platform:id); empty = every connected account. currency = report currency (ISO code: TRY, USD, EUR…); other currencies are converted with the daily ECB rate; empty = the currency with the highest spend. Agencies add their own name and logo with looker_studio_settings and they appear on every report. Beyond ads the report also covers the website and local presence: GA4 (sessions, users and key events by channel over time, landing pages), Search Console (organic clicks, impressions, CTR, average position over time, top queries and pages) and Business Profile (search and Maps views, calls, direction requests, website clicks over time). ga4_property / gsc_site / gbp_location pick which GA4 property, Search Console site and Business Profile location the report reads (values from ga4_list_properties, gsc_list_sites, gbp_list_locations; a name or domain also works). Leave them empty and the only connected one is used, or the one whose name matches the client's ad account; when an agency has several clients and none matches, pass them explicitly. The first call also returns the user's Data Studio key, which is pasted into Data Studio once.