{"id":362,"date":"2026-01-26T17:46:47","date_gmt":"2026-01-26T16:46:47","guid":{"rendered":"https:\/\/ga4-auditor.dev\/2026\/01\/26\/e-commerce-source-attribution-differences-between-live-api-and-bigquery-export-in-ga4-auditor\/"},"modified":"2026-01-26T17:51:50","modified_gmt":"2026-01-26T16:51:50","slug":"e-commerce-source-attribution-differences-between-live-api-and-bigquery-export-in-ga4-auditor","status":"publish","type":"post","link":"https:\/\/ga4-auditor.dev\/en\/2026\/01\/26\/e-commerce-source-attribution-differences-between-live-api-and-bigquery-export-in-ga4-auditor\/","title":{"rendered":"E-Commerce Source Attribution: Differences Between Live API and BigQuery Export in GA4 Auditor"},"content":{"rendered":"\n
The GA4 Auditor offers two reports for e-commerce source attribution:<\/p>\n\n
\n
Live API Report<\/strong> (under “Live API Checks > E-Commerce > Source Attribution”)<\/li>\n\n\n\n
Both reports analyze the same question: Which marketing channels can be attributed to e-commerce transactions? Nevertheless, they show different values in practice. This article explains why these differences arise and how to interpret them correctly. <\/p>\n\n
The Live API Report in GA4 Auditor retrieves data via the official GA4 Data API. This API: <\/p>\n\n
\n
Provides pre-aggregated report data, as it also appears in the GA4 interface<\/li>\n\n\n\n
Uses the dimension sessionDefaultChannelGroup<\/code> for channel assignment<\/li>\n\n\n\n
Automatically applies Google’s standard channel grouping rules<\/li>\n\n\n\n
Takes into account subsequent attribution corrections by Google (e.g., conversion modeling)<\/li>\n<\/ul>\n\n
The report shows the proportion of transactions that could be assigned to a source (“Assigned”) versus the proportion without a clear assignment (“Direct \/ Unassigned”).<\/p>\n\n
BigQuery Export Report: Raw Data Analysis<\/h3>\n\n
The BigQuery Export Report analyzes the event-level raw data directly in BigQuery. The GA4 Auditor uses: <\/p>\n\n
\n
The field session_traffic_source_last_click.cross_channel_campaign.default_channel_group<\/code> for the channel<\/li>\n\n\n\n
Additional fields such as source<\/code>, medium<\/code>, campaign<\/code> for deeper analyses<\/li>\n\n\n\n
A combination of Daily Export (events_*<\/code>) and Intraday Export (events_intraday_*<\/code>)<\/li>\n<\/ul>\n\n
The report differentiates between different problem categories, enabling targeted error analyses.<\/p>\n\n
\n\n
Why the values differ: Technical reasons<\/h2>\n\n
1. Different Attribution Fields<\/h3>\n\n
The most fundamental difference lies in the data fields used:<\/p>\n\n
Live API Report:<\/strong><\/p>\n\n
sessionDefaultChannelGroup (Dimension of the Data API)\n<\/pre>\n\n
Although both fields should provide the same information, they differ in processing:<\/p>\n\n
\n
The Data API uses Google’s internally processed and enriched data<\/li>\n\n\n\n
The BigQuery Export contains the values “frozen” at the time of export<\/li>\n\n\n\n
The Data API may contain subsequent corrections through Google Ads conversion modeling<\/li>\n<\/ul>\n\n
2. The 72-Hour Attribution Delay<\/h3>\n\n
Attribution in GA4 is not static. It can change up to 72 hours after the event: <\/p>\n\n
Reasons for subsequent attribution changes:<\/strong><\/p>\n\n\n
Google Ads Conversion Modeling<\/strong>: Google uses machine learning to attribute conversions even with cookie blocking or cross-device journeys<\/li>\n\n\n\n
Data Processing Pipeline<\/strong>: Google’s backend processes data in batches, with attribution calculations occurring with a time delay<\/li>\n\n\n\n
Consent Mode Modeling<\/strong>: For users without tracking consent, GA4 models the likely source<\/li>\n<\/ol>\n\n
Practical impact in the GA4 Auditor:<\/strong><\/p>\n\n
\n
The Live API Report<\/strong> shows the current attribution, which may still change<\/li>\n\n\n\n
The BigQuery Export Report<\/strong> shows the attribution finalized at the time of export<\/li>\n<\/ul>\n\n
For data from the last 24-72 hours, the Live API Report may therefore show more “Direct”, while the BigQuery Report (after finalization) shows a better assignment.<\/p>\n\n
3. Classification of “Direct” and “Unassigned”<\/h3>\n\n
The reports classify problematic attribution differently:<\/p>\n\n
Live API Report \u2013 Broad Definition:<\/strong><\/p>\n\n
The report summarizes the following under “Direct \/ Unassigned”:<\/p>\n\n
\n
Direct<\/code><\/li>\n\n\n\n
(direct)<\/code><\/li>\n\n\n\n
(not set)<\/code><\/li>\n\n\n\n
Unassigned<\/code><\/li>\n\n\n\n
(other)<\/code><\/li>\n<\/ul>\n\n
This summary provides a quick overview of the proportion of unassigned transactions.<\/p>\n\n
Tables are deleted after completion of the Daily Export<\/li>\n<\/ul>\n\n
Deduplication logic in the GA4 Auditor:<\/strong><\/p>\n\n
-- Simplified representation\nWITH combined AS (\n SELECT *, 'daily' as source FROM events_*\n UNION ALL\n SELECT *, 'intraday' as source FROM events_intraday_*\n)\nSELECT * FROM combined\nQUALIFY ROW_NUMBER() OVER (\n PARTITION BY event_name, event_timestamp, user_pseudo_id\n ORDER BY CASE source WHEN 'daily' THEN 1 ELSE 2 END\n) = 1\n<\/pre>\n\n
Daily data is preferred. Intraday data is only used for time periods that have not yet been finalized. <\/p>\n\n
\n\n
Typical discrepancies and their interpretation<\/h2>\n\n
Observation<\/th>
Likely cause<\/th>
Recommendation<\/th><\/tr><\/thead>
Live API shows more Direct than BigQuery<\/td>
Attribution not yet finalized (72h delay)<\/td>
Analyze period without last 72h<\/td><\/tr>
BigQuery shows a lot of “Direct without session_start”<\/td>
session_start event is not triggered<\/td>
Check tracking implementation<\/td><\/tr>
BigQuery shows “Direct with Referrer”<\/td>
Referrer exclusion list incomplete<\/td>
Check GA4 property settings<\/td><\/tr>
BigQuery shows “Direct with GCLID”<\/td>
Cross-domain tracking problem<\/td>
Check linker configuration<\/td><\/tr>
Large differences in Google Ads Attribution<\/td>
Conversion modeling only in Data API<\/td>
Prefer Data API for Ads analysis<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
Recommendations for using both reports<\/h2>\n\n
When to use the Live API Report?<\/h3>\n\n
\n
Quick overview<\/strong>: Current status of attribution at a glance<\/li>\n\n\n\n
Daily monitoring<\/strong>: Recognize trends (with awareness of 72h delay)<\/li>\n\n\n\n
Google Ads Analysis<\/strong>: Contains the modeled conversions<\/li>\n<\/ul>\n\n
When to use the BigQuery Export Report?<\/h3>\n\n
\n
Detailed error analysis<\/strong>: What kind of problems exist?<\/li>\n\n\n\n
Tracking debugging<\/strong>: Why are transactions not assigned?<\/li>\n\n\n\n
Historical analyses<\/strong>: Finalized data for consistent time series<\/li>\n<\/ul>\n\n
Best Practices<\/h3>\n\n\n
Keep time periods comparable<\/strong>: Compare both reports only for time periods that are at least 72 hours in the past<\/li>\n\n\n\n
Use both reports in a complementary manner<\/strong>:\n
\n
Live API for a quick overview<\/li>\n\n\n\n
BigQuery for deep debugging<\/li>\n<\/ul>\n<\/li>\n\n\n\n
Use debug queries<\/strong>: The BigQuery Report offers copy-&-paste queries for detailed analyses in the BigQuery console<\/li>\n\n\n\n
Note the information boxes<\/strong>: Both reports show information about the data source and its limitations<\/li>\n<\/ol>\n\n\n\n
Conclusion<\/h2>\n\n
The differences between the Live API Report and the BigQuery Export Report in the GA4 Auditor are not a mistake, but the result of different data sources and processing times. Both reports have their justification: <\/p>\n\n
\n
The Live API Report<\/strong> shows the current Google attribution and is ideal for quick overviews<\/li>\n\n\n\n
The BigQuery Export Report<\/strong> enables granular error analyses and shows where tracking problems specifically lie<\/li>\n<\/ul>\n\n
For a complete attribution analysis, it is recommended to combine both reports: The Live API Report identifies whether a problem exists. The BigQuery Export Report shows what kind of problem it is and how it can be resolved. <\/p>\n","protected":false},"excerpt":{"rendered":"
The GA4 Auditor offers two reports for e-commerce source attribution: Both reports analyze the same question: Which marketing channels can be…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kadence_starter_templates_imported_post":false,"_swpsp_post_exclude":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","slim_seo":{"description":"Why do Live API and BigQuery Export show different attribution values in GA4 Auditor? This article explains the technical reasons.","title":"E-Commerce Source Attribution: Differences Between Live API and BigQuery Export in GA4 Auditor - GA4 Auditor"},"footnotes":""},"categories":[1],"tags":[],"class_list":["post-362","post","type-post","status-publish","format-standard","hentry","category-nicht-kategorisiert"],"taxonomy_info":{"category":[{"value":1,"label":"Nicht kategorisiert"}]},"featured_image_src_large":false,"author_info":{"display_name":"Bernhard Prange","author_link":"https:\/\/ga4-auditor.dev\/en\/author\/masterben\/"},"comment_info":0,"category_info":[{"term_id":1,"name":"Nicht kategorisiert","slug":"nicht-kategorisiert","term_group":0,"term_taxonomy_id":1,"taxonomy":"category","description":"","parent":0,"count":8,"filter":"raw","cat_ID":1,"category_count":8,"category_description":"","cat_name":"Nicht kategorisiert","category_nicename":"nicht-kategorisiert","category_parent":0}],"tag_info":false,"_links":{"self":[{"href":"https:\/\/ga4-auditor.dev\/en\/wp-json\/wp\/v2\/posts\/362","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ga4-auditor.dev\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ga4-auditor.dev\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ga4-auditor.dev\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ga4-auditor.dev\/en\/wp-json\/wp\/v2\/comments?post=362"}],"version-history":[{"count":1,"href":"https:\/\/ga4-auditor.dev\/en\/wp-json\/wp\/v2\/posts\/362\/revisions"}],"predecessor-version":[{"id":363,"href":"https:\/\/ga4-auditor.dev\/en\/wp-json\/wp\/v2\/posts\/362\/revisions\/363"}],"wp:attachment":[{"href":"https:\/\/ga4-auditor.dev\/en\/wp-json\/wp\/v2\/media?parent=362"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ga4-auditor.dev\/en\/wp-json\/wp\/v2\/categories?post=362"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ga4-auditor.dev\/en\/wp-json\/wp\/v2\/tags?post=362"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}