Home / GA4 Interview Questions / BigQuery, APIs and Looker Studio
Interview questions

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

1BasicBigQuery, APIs, Measurement Protocol & Looker Studio

Why link GA4 to BigQuery?

  • Raw event-level data export (free for standard properties) for unsampled, custom analysis and data joins.
2BasicLooker Studio & Reporting

What is Looker Studio?

  • Google's free dashboard tool (formerly Data Studio) connecting GA4, Ads, Sheets, BigQuery and more.

Intermediate questions

3IntermediateBigQuery, APIs, Measurement Protocol & Looker Studio

BigQuery export types?

  • Daily export (events_YYYYMMDD), streaming/intraday (events_intraday_), and user data export tables.
4IntermediateBigQuery, APIs, Measurement Protocol & Looker Studio

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.

5IntermediateBigQuery, APIs, Measurement Protocol & Looker Studio

BigQuery export retroactive?

  • No – exports begin after linking.
6IntermediateBigQuery, APIs, Measurement Protocol & Looker Studio

Event_params in BigQuery?

  • Nested repeated field; use UNNEST(event_params) to get values (string_value, int_value, double_value).
7IntermediateBigQuery, APIs, Measurement Protocol & Looker Studio

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.

8IntermediateBigQuery, APIs, Measurement Protocol & Looker Studio

GA4 Data API vs Admin API?

  • Data API: pull report data; Admin API: manage configuration (properties, key events, custom dimensions, access).
9IntermediateBigQuery, APIs, Measurement Protocol & Looker Studio

Looker Studio connectors for GA4?

  • Native GA4 connector (quota limits), BigQuery connector for heavy dashboards, Sheets/extract options.
10IntermediateBigQuery, APIs, Measurement Protocol & Looker Studio

Data Manager API (2026)?

  • Google's API that can send server-to-server events as an alternative to the Measurement Protocol.
11IntermediateLooker Studio & Reporting

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.
12IntermediateLooker Studio & Reporting

Blending data?

  • Combine sources with a join key (e.g. date + campaign) – watch join type and aggregation.
13IntermediateLooker Studio & Reporting

Calculated fields examples?

  • CPL = Cost / Leads; CASE statements to group campaigns into channels; ROAS = Revenue / Cost.
14IntermediateLooker Studio & Reporting

Filters and controls?

  • Date range control, dropdown filters (channel, country), report-level vs page-level filters.
15IntermediateLooker Studio & Reporting

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

16AdvancedBigQuery, APIs, Measurement Protocol & Looker Studio

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.
17AdvancedBigQuery, APIs, Measurement Protocol & Looker Studio

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.
18AdvancedBigQuery, APIs, Measurement Protocol & Looker Studio

Why BigQuery numbers differ from GA4 UI?

  • UI applies modelling, thresholding, Google signals, attribution and HyperLogLog approximations; BigQuery is raw.
19AdvancedBigQuery, APIs, Measurement Protocol & Looker Studio

Measurement Protocol limitations?

  • Should augment, not replace, client tagging; events need valid client_id/session for attribution; validation server for testing.
20AdvancedBigQuery, APIs, Measurement Protocol & Looker Studio

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.
21AdvancedBigQuery, APIs, Measurement Protocol & Looker Studio

Cost control in BigQuery?

  • Query only needed columns/date partitions, use _TABLE_SUFFIX, scheduled queries into summary tables.
22AdvancedLooker Studio & Reporting

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.
23AdvancedLooker Studio & Reporting

GA4 API quota issues in Looker Studio – solutions?

  • Fewer charts, data extracts, BigQuery, scheduled caching.
24AdvancedLooker Studio & Reporting

Making dashboards readable?

  • Few KPIs, comparisons to previous period/target, consistent colours, plain-language titles, commentary.
25AdvancedLooker Studio & Reporting

Automating reporting?

  • Scheduled email delivery from Looker Studio and GA4; connectors for ad platforms.
26AdvancedLooker Studio & Reporting

Single source of truth for revenue?

  • Backend/CRM revenue in Sheets/BigQuery joined with spend for MER/CAC.
27AdvancedLooker Studio & Reporting

Reporting lead quality?

  • Join CRM stages with campaigns via UTMs/gclid – show CPL, cost per qualified lead, cost per sale.
28AdvancedLooker Studio & Reporting

Common Looker Studio mistakes?

  • Mixing ratio metrics incorrectly when blending, wrong date dimension, filters hiding data, no definitions.
29AdvancedLooker Studio & Reporting

GA4 Dashboards vs Looker Studio?

  • GA4 dashboards (2026) give quick KPI views inside GA4; Looker Studio is better for multi-source, client-facing reports.
30AdvancedLooker Studio & Reporting

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.

Book a free call