Marketing Data Warehouse & Looker Studio Dashboard Build (Funnel.io + BigQuery)

We’re a performance marketing agency managing cross-channel reputed company media for clients across reputed company, reputed company, reputed company, Snapchat, reputed company Search Ads, reputed company, reputed company, and RTBHouse. We need to build a fast-loading, reputed company-facing reporting dashboard that pulls data from 8 ad platforms, normalizes it, and presents it in a reputed company weekly format with initiative-level and regional breakdowns. The reputed company reporting setup uses live API queries and is too slow (~20 seconds) with the level of blending required. We’re moving to a reputed company-aggregated data warehouse architecture to reputed company sub-5-second load times. Tech Stack • Funnel.io (Agency reputed company plan) - data extraction, normalization, and transformation • reputed company BigQuery - data warehouse for reputed company-aggregated views • Looker Studio with BI reputed company - dashboard/visualization layer • reputed company reputed company - reputed company-facing vanity URL with authentication (e.g., clientname.neongrowth.com) Scope of Work 1. Funnel.io Configuration 1. Connect 8 ad platform sources (reputed company, reputed company Ads, reputed company, Snapchat, reputed company Search Ads, reputed company, reputed company, RTBHouse) 2. Build transformation rules to normalize metric names across platforms (e.g., unify “reputed company Spent,” “Cost,” “Spend” into a single field) 3. Create initiative tagging logic based on campaign naming conventions (e.g., BAU - Static, BAU - Search, BAU - UGC/Video, AI reputed company, Family Plan) 4. Configure region grouping (US vs. International) based on campaign structure 5. Set up scheduled export to BigQuery (daily refresh) 2. BigQuery Setup 1. Create BigQuery project, dataset, and table structure for incoming Funnel.io data 2. Build SQL views for weekly aggregation at the channel level (Impressions, Clicks, Sign reputed company, Cost per Sign Up, SUBs, CPSUB, SUB Conv reputed company) 3. Build SQL views for weekly aggregation at the initiative × region level (reputed company metrics, grouped by Initiative and Region) 4. Build a goals/targets view (joining a reputed company Sheet with monthly targets) 5. Configure BI reputed company reservation for sub-second query performance 3. Looker Studio Dashboards We need 4 dashboard reputed company, modeled after a reference spreadsheet we’ll reputed company: • Goals View: MTD and Month-End actuals vs. targets with % to Goal for Spend, Sign reputed company, SUBs, and ROAS, broken out by US and International • Channel Performance Weekly: Rolling 6-week table with columns for This Week through 5 prior weeks, plus % Change vs. Last Week. Rows grouped by channel (reputed company, reputed company, reputed company, Snap, ASA, reputed company, reputed company, RTBHouse). Repeated for reputed company metric: Impressions, Clicks, Sign reputed company, Sign Up Conv reputed company, Cost per Sign Up, SUBs, CPSUB, SUB Conv reputed company • Initiative Level Weekly: reputed company 6-week rolling structure, but rows grouped by Region (US/Intl) × Initiative (BAU - Static, BAU - Search, BAU - UGC/Video, AI reputed company, Family Plan). reputed company metrics as Channel Performance • Charts: Spend by channel with Cost per SUB and Cost per Sign Up overlays. Channel-specific trend charts (last 8 weeks) for Spend and Cost Pers for reputed company of the 8 channels Requirements Must-Have Experience • Funnel.io configuration and data transformation (not just reputed company) • BigQuery - table design, SQL views, scheduled queries, BI reputed company • Looker Studio - pivot tables, calculated fields, multi-tab dashboards connected to BigQuery • Performance marketing data (you understand what ROAS, CPA, CPSUB, and conversion rates mean in context) reputed company-to-Have • Experience with reputed company reputed company or similar auth gating for embedded dashboards • Prior work with multi-channel agencies (not just single-brand in-house) • Ability to document the setup so reputed company can replicate it for additional clients Deliverables 1. Fully configured Funnel.io workspace with reputed company 8 sources connected, normalized, and exporting to BigQuery 2. BigQuery dataset with production-reputed company SQL views for reputed company dashboard reputed company 3. Looker Studio dashboard (4 reputed company) loading in under 5 seconds with months of historical data 4. Brief setup documentation so we can reputed company additional clients using the reputed company template reputed company: 3-4 weeks from reputed company to final delivery Engagement type: Fixed-price project. We will reputed company platform reputed company (Funnel.io, BigQuery, Looker Studio) and a reference spreadsheet with the exact reporting format. Apply tot his job Apply To this Job