Read more from David, a Senior Product Strategist with 18+ years in digital product development and an atypical error detection knack.
Latest
30 posts · newest firstMake a BigQuery data agent accurate on GA4 data: precise instructions, a business glossary, and eight verified queries with parameters to start from.
by David PombarCreate and query BigQuery data agents from Python with the Conversational Analytics API, give an ADK agent BigQuery tools, and connect assistants over MCP.
by David PombarA step-by-step series on BigQuery data agents: from your first query to agents you can trust in production, on GA4 data, with Google’s docs and courses.
by David PombarRun BigQuery data agents in production: cap cost with quotas and byte limits, control access with IAM and row-level security, monitor usage, check inputs.
by David PombarUse the BigQuery Data Engineering Agent to turn your GA4 agent layer into a Dataform pipeline, set team rules in GEMINI.md, and fix failed runs.
by David PombarUse the Data Science Agent in BigQuery Studio notebooks to explore GA4 data, forecast revenue, and segment sessions, with a plan you approve step by step.
by David PombarHow to ask a BigQuery data agent better questions, read its answer critically, and spot the six errors agents make most often on GA4 data.
by David PombarSet up billing, APIs, and roles, create a data agent on your GA4 tables, cap what each answer can cost, test it in preview, and share it with your team.
by David PombarBuild a set of questions with known answers, rerun it after every change to your data agent, and use conversation logs to find the questions you missed.
by David PombarHow to turn on the GA4 BigQuery export, how its event tables are built, and the traps that make an agent’s answer differ from what GA4 reports.
by David PombarTurn the raw GA4 export into narrow tables a data agent can read: sessions, purchases, items, and pages, with descriptions written for the agent.
by David PombarThe SQL you need to read and audit what a BigQuery data agent writes: SELECT, WHERE, GROUP BY, JOIN, dates, and UNNEST, practiced on the GA4 sample.
by David PombarA BigQuery data agent answers business questions about the data that arrived. A tracking agent answers why it looks wrong. How to tell them apart.
by David PombarBigQuery from zero: projects, datasets, tables, what a query costs, the free sandbox, and the five kinds of agent Google ships in BigQuery today.
by David PombarFind the bots, ghost hits, and referral spam that GA4’s known-bot exclusion misses, and remove them in GA4, in BigQuery, or before they ever reach a tag.
by David PombarWhere the consent decision is enforced once tracking moves to server-side GTM and Meta CAPI, how gcs and gcd travel with the event, and how to check it.
by David PombarHow to debug dataLayer order and timing errors in GTM: late pushes, an overwritten dataLayer, single-page app routes, and consent-delayed tags.
by David PombarWhat to check in the dataLayer on every push, and how to catch renamed keys, type changes, and missing fields before they reach GA4, ads, or the warehouse.
by David PombarWhy GA4 and ad pixels record one action twice, from double tags to SPA history changes and pixel plus CAPI, and how to find and fix each one at the source.
by David PombarThe dataLayer push for each GA4 ecommerce event, from view_item_list to purchase: items, currency and value, the fields that go missing, and the tests.
by David PombarFind the emails, user IDs, and tokens hiding in your URLs and referrers, and strip them in GTM, GA4 data redaction, or the server before vendors get them.
by David PombarWhy GA4 transactions and revenue never equal your orders database, which gaps are expected, which are defects, and a step-by-step way to reconcile them.
by David PombarRun a quarterly audit of the vendors on your website: which scripts load, what each sends and to whom, and whether it is declared and waits for consent.
by David PombarDebug Google Consent Mode v2: the five usual failures, how to read gcs and gcd in Tag Assistant and the network tab, and how to monitor consent on real traffic.
by David PombarTrackingplan
Your implementations audited around the clock with real-time, real-user data. Real-time alerts about errors or changes in your data, campaigns, pixels, privacy and consent. Let AI flag issues before they cost you.