Google analytics database schema See Event-scoped custom dimensions and metrics reporting and Custom user properties to learn more about custom dimensions. Dimensions The following dimensions can be requested in data access reports. Schema The following sections describe the user data that Analytics exports to the Pseudo ID and User ID tables (subject to the differences enumerated in the section above). See BigQuery cookbook for Universal Analytics if you are looking for the same resource for Universal Analytics. Aug 1, 2023 · Check out the BigQuery Export user-data schema for more details. Oct 9, 2024 · The advanced queries in this page apply to the BigQuery event export data for Google Analytics. Google Analytics 4 offers a powerful tool to collect this data, but its BigQuery schema can be complex. The next important step is to prepare a home for that data on your computer. This phase is all about designing a strong and flexible SQL database plan. Learn more about Google Analytics properties. Jun 29, 2025 · This article explains the format and schema of the Google Analytics 4 property data and the Google Analytics for Firebase data that is exported to BigQuery. The Realtime method supports a different set of dimensions and metrics compared to Core Reporting methods like RunReport. This API provides features in Alpha and Beta channels. Jul 25, 2025 · This page details the dimensions and metrics available for queries using the Realtime method of the Analytics Data API. A Data Set is a container that holds the data you upload to Analytics. Tip: In order to make the most of the example queries in this guide, set the PROJECT_ID and PROPERTY_ID variables with the values for your project and property. For information about BigQuery Export schema in Google Analytics 4, go to [GA4] BigQuery Export schema. May 3, 2024 · Watch how to use a multimodal LLM such as Gemini to analyze data in a BigQuery data lake and automatically generate schema layouts. Try the basic queries first before trying out the advanced ones. 2. Oct 22, 2023 · To explore the data structure, open your analytics dataset (or the e-commerce sample dataset) and select the events_ table. This feature is not governed by a service-level agreement (SLA). Install from , and see the for more details. Dec 17, 2024 · The GA4 BigQuery export schema refers to the structure of GA4 and Firebase data that is exported to a Google BigQuery project. This will provide an overview of the table schema, illustrating different fields and their respective data types. Custom dimensions are specified in an API report request by the dimension's parameter name and scope. . Oct 9, 2024 · Try the MCP server for Google Analytics. The feature is only available for Analytics 360 customers, but the schema is public. You can use the Data API to programmatically access Google Analytics (Google Analytics) report data. For example, include "customEvent:achievement_id" in a Data API request to This article is about BigQuery Export schema in Universal Analytics. The Data Set type corresponds to the specific type of data you want to import. Alpha and Beta products may have limited support, and changes to May 7, 2024 · Understanding user interaction is key for marketers. 3 Design Your SQL Schema for Web Analytics Data Welcome to Phase 2. This article explains the format and schema of the Google Analytics property data and the Google Analytics for Firebase data that is exported to BigQuery. Products purchased by customers who purchased a certain product The following query shows what other products were Mar 10, 2025 · Programmatically manage Google Analytics reporting and data. This plan will set up the tables and columns where your website analytics Feb 20, 2025 · The dimensions and metrics supported in queries to the Data Access Reports method of the Analytics Admin API. This article explains the format and schema of the Google Analytics property data and the Google Analytics for Firebase data that is exported to BigQuery. 3 Structuring Your Data You now know how to get real data from Google Analytics 4 GA4 into CSV files. For example, there are Data Set types for User Da A data source is a container that holds the data you upload to Analytics, and comprises the database, service, or CSV file you upload and a mapping of Analytics fields to the fields in your external database, service, or CSV. Aug 6, 2025 · Custom Dimensions The Data API can create reports on Event and User scoped Custom Dimensions. Apr 21, 2020 · You could be inspired by the schema used by Google Analytics to export 98% of the original hit data + data processing outcomes into Big Query. Data sources control how uploaded data gets joined with existing data. DatasetsFor each Google Analytics 4 property and each Firebase project that is linked to BigQuery, a single dataset named "analytics_<property_i In this tutorial I will show you - step by step - how to flatten the Google Analytics 4 export schema with the purpose of using the data in a relational database outside of BigQuery. Specify the "API Name" in an AccessDimension resource's dimension name field for a column of the dimension in the report response. You configure data sources at the property level. User-scoped Custom Dimensions are supported in the Realtime Data API and are specified using the customUser:parameter_name syntax. This API isn't compatible with legacy Universal Analytics properties. uqkxj clbftxr xfjvq lrog jcbcrmc dtuten ipzc wix kzz uqrxm azjfh xgww meop bgtigya cgir