GA4 BigQuery and Looker Studio Interview Questions
GA4 BigQuery and Looker Studio questions: 30 questions with model answers on BigQuery, the APIs, Measurement Protocol and Looker Studio, from Basic to Advanced.
- Model answers
- Basic to Advanced
- Search and filter
BigQuery export, APIs, Measurement Protocol and Looker Studio reporting. Questions are grouped from Basic to Advanced, each with a model answer. Use the filters or search to find what you need, then take the free GA4 test to check your score. For official guidance, see the Google Analytics Help Center.
What these GA4 BigQuery and Looker Studio questions cover
These questions cover the GA4 BigQuery export and its event table, simple SQL on GA4 data, the Data and Admin APIs, the Measurement Protocol, and building Looker Studio dashboards that clients actually use.
Senior analytics roles nearly always test BigQuery or dashboards. Be ready to describe a dashboard you built and the decision it helped someone make.
All questions, from Basic to Advanced
Basic questions
Why link GA4 to BigQuery?
- Raw event-level data export (free for standard properties) for unsampled, custom analysis and data joins.
What is Looker Studio?
- Google's free dashboard tool (formerly Data Studio) connecting GA4, Ads, Sheets, BigQuery and more.
Intermediate questions
BigQuery export types?
- Daily export (events_YYYYMMDD), streaming/intraday (events_intraday_), and user data export tables.
Standard BigQuery export limit?
- Daily export limited to 1 million events per day for standard properties (otherwise paused); 360 has billions.
Expert insight: Standard properties' daily export is capped at 1 million events per day; streaming export is an alternative path. Reducing noisy events (e.g. scroll on every page) helps stay under the cap.
BigQuery export retroactive?
- No – exports begin after linking.
Event_params in BigQuery?
- Nested repeated field; use UNNEST(event_params) to get values (string_value, int_value, double_value).
Measurement Protocol?
- Send events server-to-server to GA4 using api_secret + measurement_id and client_id/user_id – e.g. offline sales, refunds.
Expert insight: Use it for events that happen off-site (offline sales, refunds, subscription renewals). Always send a real client_id/user_id from the original web session so the event joins the user's journey.
GA4 Data API vs Admin API?
- Data API: pull report data; Admin API: manage configuration (properties, key events, custom dimensions, access).
Looker Studio connectors for GA4?
- Native GA4 connector (quota limits), BigQuery connector for heavy dashboards, Sheets/extract options.
Data Manager API (2026)?
- Google's API that can send server-to-server events as an alternative to the Measurement Protocol.
Common data sources for a marketing dashboard?
- GA4, Google Ads, Search Console, Sheets (CRM/leads), BigQuery; partner connectors (Supermetrics, Windsor, Porter) for Meta/TikTok/Snap.
Blending data?
- Combine sources with a join key (e.g. date + campaign) – watch join type and aggregation.
Calculated fields examples?
- CPL = Cost / Leads; CASE statements to group campaigns into channels; ROAS = Revenue / Cost.
Filters and controls?
- Date range control, dropdown filters (channel, country), report-level vs page-level filters.
Owner's credentials vs viewer's credentials?
- Owner's: viewers see data without access; Viewer's: each viewer needs access to the source.
Advanced questions
Interview: "Looker Studio GA4 dashboard shows quota errors."
- Too many charts/queries on GA4 API: use extracts, BigQuery export, reduce charts per page, share with owner credentials thoughtfully.
Sample BigQuery question: sessions by source?
- Use collected_traffic_source / session_traffic_source_last_click fields or derive from event params; count distinct user_pseudo_id + ga_session_id.
Why BigQuery numbers differ from GA4 UI?
- UI applies modelling, thresholding, Google signals, attribution and HyperLogLog approximations; BigQuery is raw.
Measurement Protocol limitations?
- Should augment, not replace, client tagging; events need valid client_id/session for attribution; validation server for testing.
Joining GA4 with CRM data?
- Capture client_id/user_id into CRM via hidden form fields, then join in BigQuery for lead-to-sale analysis.
Cost control in BigQuery?
- Query only needed columns/date partitions, use _TABLE_SUFFIX, scheduled queries into summary tables.
Interview: "Design a monthly performance dashboard for a client."
- Page 1 summary KPIs vs target; page 2 channel performance; page 3 funnel & landing pages; page 4 campaigns/creatives; page 5 notes/actions.
GA4 API quota issues in Looker Studio – solutions?
- Fewer charts, data extracts, BigQuery, scheduled caching.
Making dashboards readable?
- Few KPIs, comparisons to previous period/target, consistent colours, plain-language titles, commentary.
Automating reporting?
- Scheduled email delivery from Looker Studio and GA4; connectors for ad platforms.
Single source of truth for revenue?
- Backend/CRM revenue in Sheets/BigQuery joined with spend for MER/CAC.
Reporting lead quality?
- Join CRM stages with campaigns via UTMs/gclid – show CPL, cost per qualified lead, cost per sale.
Common Looker Studio mistakes?
- Mixing ratio metrics incorrectly when blending, wrong date dimension, filters hiding data, no definitions.
GA4 Dashboards vs Looker Studio?
- GA4 dashboards (2026) give quick KPI views inside GA4; Looker Studio is better for multi-source, client-facing reports.
Alerts and anomaly detection?
- GA4 generated insights/custom insights; Looker Studio doesn't alert natively – use GA4 or BigQuery scheduled checks.
More GA4 question topics
Want an expert to run your GA4?
Book a free strategy call and get your tracking and reporting set up right.