Schema Information for GA4
Schema Information for GA4
In this article, we will look at the schema information of the supported APIs and tables for GA4 connector.
Find the links to other articles related to GA4 Below:
The schema for the GA4 integration in Daton contains the following fields:
- Daton fields (i.e.,
_daton_user_id
,_daton_batch_runtime
,_daton_batch_id
) - Selected dimensions
- Selected metrics
- Start date
- End date
For instance,
If a table is defined as per the following metrics and dimensions:
The data will be stored incrementally based on the Date in the warehouse as a table with the
following fields:
Field Name |
Data Type |
---|---|
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
_daton_batch_id |
NUMERIC |
source |
STRING |
sourceMedium |
STRING |
activeUsers |
INTEGER |
sessions |
INTEGER |
start_date |
DATE |
end_date |
DATE |
Where, the fields- source
, sourceMedium
, activeUsers
, and sessions
were defined in the custom table through metrics and dimensions, during the Daton integration.