Lucen

Google Analytics 4 data reference

Analytics
56 tables
936 columns

Lucen syncs your Google Analytics 4 data (Analytics) to your warehouse and models it into the tables below. You connect Google Analytics 4 with one OAuth sign-in. By default your data refreshes every day at 07:00 Buenos Aires time (UTC-3). Your plan sets how many times a day it can sync, and you can choose the times, see pricing.

Your plan sets how much history the first sync loads, see pricing.

Send Google Analytics 4 data to

Tables

gold_google_analytics_event_catalog_current

Grain
Current event catalog

gold_google_analytics_first_user_channel_daily

Grain
First-user channel

gold_google_analytics_first_user_channel_events_daily

One row per property_id, date, first_user_default_channel_group, event_name, is_key_event. Use for original user acquisition by GA4's default channel classification. Independent event-count query, with historical is_key_event in the grain. Sum all status rows for all occurrences of a name; filter true for historically key occurrences. Use the matching performance model for users and sessions; aggregate event rows to its full key before joining.

gold_google_analytics_first_user_channel_key_event_pivot_daily

One row per property_id, date, first_user_default_channel_group. Use for original user acquisition by GA4's default channel classification. Pilot view combining independent performance with occurrence columns for currently configured key-event names across properties; columns change on rebuild. Counts include both historical key statuses; zero means complete coverage with no matching occurrences, NULL means missing coverage or an event not currently key for that property. Event-only keys retain NULL performance. Use the property report for totals and never sum distinct-user metrics.

gold_google_analytics_first_user_manual_source_daily

Grain
Manual first-user source

gold_google_analytics_first_user_manual_source_events_daily

One row per property_id, date, first_user_manual_source, event_name, is_key_event. Use for original user acquisition by manual UTM attribution. Independent event-count query, with historical is_key_event in the grain. Sum all status rows for all occurrences of a name; filter true for historically key occurrences. Use the matching performance model for users and sessions; aggregate event rows to its full key before joining.

gold_google_analytics_first_user_manual_source_key_event_pivot_daily

One row per property_id, date, first_user_manual_source. Use for original user acquisition by manual UTM attribution. Pilot view combining independent performance with occurrence columns for currently configured key-event names across properties; columns change on rebuild. Counts include both historical key statuses; zero means complete coverage with no matching occurrences, NULL means missing coverage or an event not currently key for that property. Event-only keys retain NULL performance. Use the property report for totals and never sum distinct-user metrics.

gold_google_analytics_first_user_manual_source_medium_content_daily

Grain
Manual first-user source / medium / content

gold_google_analytics_first_user_manual_source_medium_content_events_daily

One row per property_id, date, first_user_manual_source, first_user_manual_medium, first_user_manual_ad_content, event_name, is_key_event. Use for original user acquisition by manual UTM attribution. Content is the manual utm_content dimension. Independent event-count query, with historical is_key_event in the grain. Sum all status rows for all occurrences of a name; filter true for historically key occurrences. Use the matching performance model for users and sessions; aggregate event rows to its full key before joining.

gold_google_analytics_first_user_manual_source_medium_content_key_event_pivot_daily

One row per property_id, date, first_user_manual_source, first_user_manual_medium, first_user_manual_ad_content. Use for original user acquisition by manual UTM attribution. Content is the manual utm_content dimension. Pilot view combining independent performance with occurrence columns for currently configured key-event names across properties; columns change on rebuild. Counts include both historical key statuses; zero means complete coverage with no matching occurrences, NULL means missing coverage or an event not currently key for that property. Event-only keys retain NULL performance. Use the property report for totals and never sum distinct-user metrics.

gold_google_analytics_first_user_manual_source_medium_daily

Grain
Manual first-user source / medium

gold_google_analytics_first_user_manual_source_medium_events_daily

One row per property_id, date, first_user_manual_source, first_user_manual_medium, event_name, is_key_event. Use for original user acquisition by manual UTM attribution. Independent event-count query, with historical is_key_event in the grain. Sum all status rows for all occurrences of a name; filter true for historically key occurrences. Use the matching performance model for users and sessions; aggregate event rows to its full key before joining.

gold_google_analytics_first_user_manual_source_medium_key_event_pivot_daily

One row per property_id, date, first_user_manual_source, first_user_manual_medium. Use for original user acquisition by manual UTM attribution. Pilot view combining independent performance with occurrence columns for currently configured key-event names across properties; columns change on rebuild. Counts include both historical key statuses; zero means complete coverage with no matching occurrences, NULL means missing coverage or an event not currently key for that property. Event-only keys retain NULL performance. Use the property report for totals and never sum distinct-user metrics.

gold_google_analytics_first_user_source_daily

Grain
First-user source

gold_google_analytics_first_user_source_events_daily

One row per property_id, date, first_user_source, event_name, is_key_event. Use for original user acquisition by GA4-resolved attribution. Resolved includes eligible auto-tagged traffic; it is not auto-tag-only. Independent event-count query, with historical is_key_event in the grain. Sum both status rows for all occurrences of a name; filter true for historically key occurrences. Use the matching performance model for users and sessions; aggregate event rows to its full key before joining.

gold_google_analytics_first_user_source_key_event_pivot_daily

One row per property_id, date, first_user_source. Use for original user acquisition by GA4-resolved attribution. Resolved includes eligible auto-tagged traffic; it is not auto-tag-only. Pilot view combining independent performance with occurrence columns for currently configured key-event names across properties; columns change on rebuild. Counts include both historical key statuses; zero means complete coverage with no matching occurrences, NULL means missing coverage or an event not currently key for that property. Event-only keys retain NULL performance. Use the property report for totals and never sum distinct-user metrics.

gold_google_analytics_first_user_source_medium_content_daily

Grain
First-user source / medium / content

gold_google_analytics_first_user_source_medium_content_events_daily

One row per property_id, date, first_user_source, first_user_medium, first_user_manual_ad_content, event_name, is_key_event. Use for original user acquisition by GA4-resolved attribution. Resolved includes eligible auto-tagged traffic; it is not auto-tag-only. Content is the manual utm_content dimension. Independent event-count query, with historical is_key_event in the grain. Sum all status rows for all occurrences of a name; filter true for historically key occurrences. Use the matching performance model for users and sessions; aggregate event rows to its full key before joining.

gold_google_analytics_first_user_source_medium_content_key_event_pivot_daily

One row per property_id, date, first_user_source, first_user_medium, first_user_manual_ad_content. Use for original user acquisition by GA4-resolved attribution. Resolved includes eligible auto-tagged traffic; it is not auto-tag-only. Content is the manual utm_content dimension. Pilot view combining independent performance with occurrence columns for currently configured key-event names across properties; columns change on rebuild. Counts include both historical key statuses; zero means complete coverage with no matching occurrences, NULL means missing coverage or an event not currently key for that property. Event-only keys retain NULL performance. Use the property report for totals and never sum distinct-user metrics.

gold_google_analytics_first_user_source_medium_daily

Grain
First-user source / medium

gold_google_analytics_first_user_source_medium_events_daily

One row per property_id, date, first_user_source, first_user_medium, event_name, is_key_event. Use for original user acquisition by GA4-resolved attribution. Resolved includes eligible auto-tagged traffic; it is not auto-tag-only. Independent event-count query, with historical is_key_event in the grain. Sum all status rows for all occurrences of a name; filter true for historically key occurrences. Use the matching performance model for users and sessions; aggregate event rows to its full key before joining.

gold_google_analytics_first_user_source_medium_key_event_pivot_daily

One row per property_id, date, first_user_source, first_user_medium. Use for original user acquisition by GA4-resolved attribution. Resolved includes eligible auto-tagged traffic; it is not auto-tag-only. Pilot view combining independent performance with occurrence columns for currently configured key-event names across properties; columns change on rebuild. Counts include both historical key statuses; zero means complete coverage with no matching occurrences, NULL means missing coverage or an event not currently key for that property. Event-only keys retain NULL performance. Use the property report for totals and never sum distinct-user metrics.

gold_google_analytics_geography_daily

Grain
Country / region / city

gold_google_analytics_geography_events_daily

One row per property_id, date, country, region, city, event_name, is_key_event. Use for GA4-attributed geography at the complete country/region/city grain. Independent event-count query, with historical is_key_event in the grain. Sum all status rows for all occurrences of a name; filter true for historically key occurrences. Use the matching performance model for users and sessions; aggregate event rows to its full key before joining.

gold_google_analytics_geography_key_event_pivot_daily

One row per property_id, date, country, region, city. Use for GA4-attributed geography at the complete country/region/city grain. Pilot view combining independent performance with occurrence columns for currently configured key-event names across properties; columns change on rebuild. Counts include both historical key statuses; zero means complete coverage with no matching occurrences, NULL means missing coverage or an event not currently key for that property. Event-only keys retain NULL performance. Use the property report for totals and never sum distinct-user metrics.

gold_google_analytics_landing_page_daily

Grain
Session entry page

gold_google_analytics_landing_page_events_daily

One row per property_id, date, landing_page, event_name, is_key_event. Use for session entry-page reporting. Independent event-count query, with historical is_key_event in the grain. Sum both status rows for all occurrences of a name; filter true for historically key occurrences. Use the matching performance model for users and sessions; aggregate event rows to its full key before joining.

gold_google_analytics_landing_page_key_event_pivot_daily

One row per property_id, date, landing_page. Use for session entry-page reporting. Pilot view combining independent performance with occurrence columns for currently configured key-event names across properties; columns change on rebuild. Counts include both historical key statuses; zero means complete coverage with no matching occurrences, NULL means missing coverage or an event not currently key for that property. Event-only keys retain NULL performance. Use the property report for totals and never sum distinct-user metrics.

gold_google_analytics_page_daily

Grain
Page path

gold_google_analytics_page_events_daily

One row per property_id, date, page_path, event_name, is_key_event. Use for activity by visited page, not session entry-page reporting. Independent event-count query, with historical is_key_event in the grain. Sum all status rows for all occurrences of a name; filter true for historically key occurrences. Use the matching performance model for users and sessions; aggregate event rows to its full key before joining.

gold_google_analytics_page_key_event_pivot_daily

One row per property_id, date, page_path. Use for activity by visited page, not session entry-page reporting. Pilot view combining independent performance with occurrence columns for currently configured key-event names across properties; columns change on rebuild. Counts include both historical key statuses; zero means complete coverage with no matching occurrences, NULL means missing coverage or an event not currently key for that property. Event-only keys retain NULL performance. Use the property report for totals and never sum distinct-user metrics.

gold_google_analytics_property_current

Grain
Current property metadata

gold_google_analytics_property_daily

Grain
Property totals (use this for headlines)

gold_google_analytics_property_events_daily

One row per property_id, date, event_name, is_key_event. Use for property-day totals; do not reconstruct them by summing breakdown reports. Independent event-count query, with historical is_key_event in the grain. Sum all status rows for all occurrences of a name; filter true for historically key occurrences. Use the matching performance model for users and sessions; aggregate event rows to its full key before joining.

gold_google_analytics_property_key_event_pivot_daily

One row per property_id, date. Use for property-day totals; do not reconstruct them by summing breakdown reports. Pilot view combining independent performance with occurrence columns for currently configured key-event names across properties; columns change on rebuild. Counts include both historical key statuses; zero means complete coverage with no matching occurrences, NULL means missing coverage or an event not currently key for that property. Event-only keys retain NULL performance. Use the property report for totals and never sum distinct-user metrics.

gold_google_analytics_session_channel_daily

Grain
Session default channel

gold_google_analytics_session_channel_events_daily

One row per property_id, date, session_default_channel_group, event_name, is_key_event. Use for session acquisition by GA4's default channel classification. Independent event-count query, with historical is_key_event in the grain. Sum all status rows for all occurrences of a name; filter true for historically key occurrences. Use the matching performance model for users and sessions; aggregate event rows to its full key before joining.

gold_google_analytics_session_channel_key_event_pivot_daily

One row per property_id, date, session_default_channel_group. Use for session acquisition by GA4's default channel classification. Pilot view combining independent performance with occurrence columns for currently configured key-event names across properties; columns change on rebuild. Counts include both historical key statuses; zero means complete coverage with no matching occurrences, NULL means missing coverage or an event not currently key for that property. Event-only keys retain NULL performance. Use the property report for totals and never sum distinct-user metrics.

gold_google_analytics_session_manual_source_daily

Grain
Manual session source

gold_google_analytics_session_manual_source_events_daily

One row per property_id, date, session_manual_source, event_name, is_key_event. Use for session acquisition by manual UTM attribution. Independent event-count query, with historical is_key_event in the grain. Sum all status rows for all occurrences of a name; filter true for historically key occurrences. Use the matching performance model for users and sessions; aggregate event rows to its full key before joining.

gold_google_analytics_session_manual_source_key_event_pivot_daily

One row per property_id, date, session_manual_source. Use for session acquisition by manual UTM attribution. Pilot view combining independent performance with occurrence columns for currently configured key-event names across properties; columns change on rebuild. Counts include both historical key statuses; zero means complete coverage with no matching occurrences, NULL means missing coverage or an event not currently key for that property. Event-only keys retain NULL performance. Use the property report for totals and never sum distinct-user metrics.

gold_google_analytics_session_manual_source_medium_content_daily

Grain
Manual session source / medium / content

gold_google_analytics_session_manual_source_medium_content_events_daily

One row per property_id, date, session_manual_source, session_manual_medium, session_manual_ad_content, event_name, is_key_event. Use for session acquisition by manual UTM attribution. Content is the manual utm_content dimension. Independent event-count query, with historical is_key_event in the grain. Sum both status rows for all occurrences of a name; filter true for historically key occurrences. Use the matching performance model for users and sessions; aggregate event rows to its full key before joining.

gold_google_analytics_session_manual_source_medium_content_key_event_pivot_daily

One row per property_id, date, session_manual_source, session_manual_medium, session_manual_ad_content. Use for session acquisition by manual UTM attribution. Content is the manual utm_content dimension. Pilot view combining independent performance with occurrence columns for currently configured key-event names across properties; columns change on rebuild. Counts include both historical key statuses; zero means complete coverage with no matching occurrences, NULL means missing coverage or an event not currently key for that property. Event-only keys retain NULL performance. Use the property report for totals and never sum distinct-user metrics.

gold_google_analytics_session_manual_source_medium_daily

Grain
Manual session source / medium

gold_google_analytics_session_manual_source_medium_events_daily

One row per property_id, date, session_manual_source, session_manual_medium, event_name, is_key_event. Use for session acquisition by manual UTM attribution. Independent event-count query, with historical is_key_event in the grain. Sum all status rows for all occurrences of a name; filter true for historically key occurrences. Use the matching performance model for users and sessions; aggregate event rows to its full key before joining.

gold_google_analytics_session_manual_source_medium_key_event_pivot_daily

One row per property_id, date, session_manual_source, session_manual_medium. Use for session acquisition by manual UTM attribution. Pilot view combining independent performance with occurrence columns for currently configured key-event names across properties; columns change on rebuild. Counts include both historical key statuses; zero means complete coverage with no matching occurrences, NULL means missing coverage or an event not currently key for that property. Event-only keys retain NULL performance. Use the property report for totals and never sum distinct-user metrics.

gold_google_analytics_session_source_daily

Grain
Session source

gold_google_analytics_session_source_events_daily

One row per property_id, date, session_source, event_name, is_key_event. Use for session acquisition by GA4-resolved attribution. Resolved includes eligible auto-tagged traffic; it is not auto-tag-only. Independent event-count query, with historical is_key_event in the grain. Sum both status rows for all occurrences of a name; filter true for historically key occurrences. Use the matching performance model for users and sessions; aggregate event rows to its full key before joining.

gold_google_analytics_session_source_key_event_pivot_daily

One row per property_id, date, session_source. Use for session acquisition by GA4-resolved attribution. Resolved includes eligible auto-tagged traffic; it is not auto-tag-only. Pilot view combining independent performance with occurrence columns for currently configured key-event names across properties; columns change on rebuild. Counts include both historical key statuses; zero means complete coverage with no matching occurrences, NULL means missing coverage or an event not currently key for that property. Event-only keys retain NULL performance. Use the property report for totals and never sum distinct-user metrics.

gold_google_analytics_session_source_medium_content_daily

Grain
Session source / medium / content

gold_google_analytics_session_source_medium_content_events_daily

One row per property_id, date, session_source, session_medium, session_manual_ad_content, event_name, is_key_event. Use for session acquisition by GA4-resolved attribution. Resolved includes eligible auto-tagged traffic; it is not auto-tag-only. Content is the manual utm_content dimension. Independent event-count query, with historical is_key_event in the grain. Sum all status rows for all occurrences of a name; filter true for historically key occurrences. Use the matching performance model for users and sessions; aggregate event rows to its full key before joining.

gold_google_analytics_session_source_medium_content_key_event_pivot_daily

One row per property_id, date, session_source, session_medium, session_manual_ad_content. Use for session acquisition by GA4-resolved attribution. Resolved includes eligible auto-tagged traffic; it is not auto-tag-only. Content is the manual utm_content dimension. Pilot view combining independent performance with occurrence columns for currently configured key-event names across properties; columns change on rebuild. Counts include both historical key statuses; zero means complete coverage with no matching occurrences, NULL means missing coverage or an event not currently key for that property. Event-only keys retain NULL performance. Use the property report for totals and never sum distinct-user metrics.

gold_google_analytics_session_source_medium_daily

Grain
Session source / medium

gold_google_analytics_session_source_medium_events_daily

One row per property_id, date, session_source, session_medium, event_name, is_key_event. Use for session acquisition by GA4-resolved attribution. Resolved includes eligible auto-tagged traffic; it is not auto-tag-only. Independent event-count query, with historical is_key_event in the grain. Sum all status rows for all occurrences of a name; filter true for historically key occurrences. Use the matching performance model for users and sessions; aggregate event rows to its full key before joining.

gold_google_analytics_session_source_medium_key_event_pivot_daily

One row per property_id, date, session_source, session_medium. Use for session acquisition by GA4-resolved attribution. Resolved includes eligible auto-tagged traffic; it is not auto-tag-only. Pilot view combining independent performance with occurrence columns for currently configured key-event names across properties; columns change on rebuild. Counts include both historical key statuses; zero means complete coverage with no matching occurrences, NULL means missing coverage or an event not currently key for that property. Event-only keys retain NULL performance. Use the property report for totals and never sum distinct-user metrics.

Columns

Column names match your warehouse exactly. Descriptions come from dbt.

gold_google_analytics_event_catalog_current columns

IDNameTypeDescription
property_idProperty idSTRINGGA4 property ID. Include it in joins; event names and dimension values are not unique across properties.
event_nameEvent nameSTRINGExact, case-sensitive GA4 event name. Join event metadata using both property_id and event_name.
is_key_event_currentIs key event currentBOOLLatest loaded Admin key-event membership: true if configured, false if absent from a completed catalog, NULL if no completed catalog is available.
counting_methodCounting methodSTRINGCurrent Admin key-event counting rule, such as ONCE_PER_EVENT or ONCE_PER_SESSION; NULL for names absent from current configuration.
key_event_created_atKey event created atTIMESTAMPAdmin API creation timestamp for the current key-event configuration, not the event's first occurrence; NULL if not currently configured.
pivot_column_namePivot column nameSTRINGStable safe column alias for this configured event in pilot views. Use this mapping to recover the exact event name; NULL for unconfigured names.
first_seen_dateFirst seen dateDATEEarliest occurrence date in retained property-level event reports; NULL for configured events never observed there. Not necessarily lifetime first occurrence.
last_seen_dateLast seen dateDATELatest occurrence date in retained property-level event reports; NULL for configured events never observed there.
catalog_observed_atCatalog observed atTIMESTAMPUTC extraction timestamp of the latest completed Admin key-event catalog, including a successful empty catalog; NULL if unavailable.

gold_google_analytics_first_user_channel_daily columns

19

gold_google_analytics_first_user_channel_events_daily columns

IDNameTypeDescription
property_idProperty idSTRINGGA4 property ID. Include it in joins; event names and dimension values are not unique across properties.
dateDateDATEActivity date in the GA4 property's reporting timezone; the row is daily, not a period total.
first_user_default_channel_groupFirst user default channel groupSTRINGGA4 firstUserDefaultChannelGroup: default channel classification of the user's original acquisition, not the current session.
event_nameEvent nameSTRINGExact, case-sensitive GA4 event name. Join event metadata using both property_id and event_name.
is_key_eventIs key eventBOOLHistorical isKeyEvent status reported for these occurrences. Both true and false can exist for one event/date; this is part of the row key, not current configuration. Exact true maps to true; false, (not set), empty string and NULL map to false. (other) and other aggregation buckets map to NULL because their status is unknown. Unexpected representations also remain NULL and are detected by the raw supported-values check.
event_countEvent countINT64Number of event occurrences reported for this row (eventCount), not distinct users or sessions.
year_monthYear monthSTRINGYYYY-MM derived from date for filtering or grouping. It does not make the row a monthly total or make user metrics additive.
property_name_currentProperty name currentSTRINGLatest loaded property display name. It may change on refresh and is not the historical name on the activity date.
property_metadata_observed_atProperty metadata observed atTIMESTAMPUTC extraction timestamp of the current property metadata joined to this row; NULL when metadata is unavailable.
property_timezoneProperty timezoneSTRINGProperty reporting timezone captured during extraction; date is interpreted in this timezone.
client_idClient idSTRINGLucen organization identifier supplied to the pipeline; not a GA4 user or browser client ID.
data_updated_atData updated atTIMESTAMPUTC extraction timestamp of the source report row; not the event time or the table build time.

gold_google_analytics_first_user_channel_key_event_pivot_daily columns

18

gold_google_analytics_first_user_manual_source_daily columns

19

gold_google_analytics_first_user_manual_source_events_daily columns

IDNameTypeDescription
property_idProperty idSTRINGGA4 property ID. Include it in joins; event names and dimension values are not unique across properties.
dateDateDATEActivity date in the GA4 property's reporting timezone; the row is daily, not a period total.
first_user_manual_sourceFirst user manual sourceSTRINGManual utm_source attribution for the user's original acquisition; separate from GA4-resolved source. Unavailable values are preserved as returned by GA4.
event_nameEvent nameSTRINGExact, case-sensitive GA4 event name. Join event metadata using both property_id and event_name.
is_key_eventIs key eventBOOLHistorical isKeyEvent status reported for these occurrences. Both true and false can exist for one event/date; this is part of the row key, not current configuration. Exact true maps to true; false, (not set), empty string and NULL map to false. (other) and other aggregation buckets map to NULL because their status is unknown. Unexpected representations also remain NULL and are detected by the raw supported-values check.
event_countEvent countINT64Number of event occurrences reported for this row (eventCount), not distinct users or sessions.
year_monthYear monthSTRINGYYYY-MM derived from date for filtering or grouping. It does not make the row a monthly total or make user metrics additive.
property_name_currentProperty name currentSTRINGLatest loaded property display name. It may change on refresh and is not the historical name on the activity date.
property_metadata_observed_atProperty metadata observed atTIMESTAMPUTC extraction timestamp of the current property metadata joined to this row; NULL when metadata is unavailable.
property_timezoneProperty timezoneSTRINGProperty reporting timezone captured during extraction; date is interpreted in this timezone.
client_idClient idSTRINGLucen organization identifier supplied to the pipeline; not a GA4 user or browser client ID.
data_updated_atData updated atTIMESTAMPUTC extraction timestamp of the source report row; not the event time or the table build time.

gold_google_analytics_first_user_manual_source_key_event_pivot_daily columns

18

gold_google_analytics_first_user_manual_source_medium_content_daily columns

21

gold_google_analytics_first_user_manual_source_medium_content_events_daily columns

IDNameTypeDescription
property_idProperty idSTRINGGA4 property ID. Include it in joins; event names and dimension values are not unique across properties.
dateDateDATEActivity date in the GA4 property's reporting timezone; the row is daily, not a period total.
first_user_manual_sourceFirst user manual sourceSTRINGManual utm_source attribution for the user's original acquisition; separate from GA4-resolved source. Unavailable values are preserved as returned by GA4.
first_user_manual_mediumFirst user manual mediumSTRINGManual utm_medium attribution for the user's original acquisition; separate from GA4-resolved medium. Unavailable values are preserved as returned by GA4.
first_user_manual_ad_contentFirst user manual ad contentSTRINGManual utm_content attribution for the user's original acquisition. Also used in resolved source/medium/content reports because content remains the manual dimension.
event_nameEvent nameSTRINGExact, case-sensitive GA4 event name. Join event metadata using both property_id and event_name.
is_key_eventIs key eventBOOLHistorical isKeyEvent status reported for these occurrences. Both true and false can exist for one event/date; this is part of the row key, not current configuration. Exact true maps to true; false, (not set), empty string and NULL map to false. (other) and other aggregation buckets map to NULL because their status is unknown. Unexpected representations also remain NULL and are detected by the raw supported-values check.
event_countEvent countINT64Number of event occurrences reported for this row (eventCount), not distinct users or sessions.
year_monthYear monthSTRINGYYYY-MM derived from date for filtering or grouping. It does not make the row a monthly total or make user metrics additive.
property_name_currentProperty name currentSTRINGLatest loaded property display name. It may change on refresh and is not the historical name on the activity date.
property_metadata_observed_atProperty metadata observed atTIMESTAMPUTC extraction timestamp of the current property metadata joined to this row; NULL when metadata is unavailable.
property_timezoneProperty timezoneSTRINGProperty reporting timezone captured during extraction; date is interpreted in this timezone.
client_idClient idSTRINGLucen organization identifier supplied to the pipeline; not a GA4 user or browser client ID.
data_updated_atData updated atTIMESTAMPUTC extraction timestamp of the source report row; not the event time or the table build time.

gold_google_analytics_first_user_manual_source_medium_content_key_event_pivot_daily columns

20

gold_google_analytics_first_user_manual_source_medium_daily columns

20

gold_google_analytics_first_user_manual_source_medium_events_daily columns

IDNameTypeDescription
property_idProperty idSTRINGGA4 property ID. Include it in joins; event names and dimension values are not unique across properties.
dateDateDATEActivity date in the GA4 property's reporting timezone; the row is daily, not a period total.
first_user_manual_sourceFirst user manual sourceSTRINGManual utm_source attribution for the user's original acquisition; separate from GA4-resolved source. Unavailable values are preserved as returned by GA4.
first_user_manual_mediumFirst user manual mediumSTRINGManual utm_medium attribution for the user's original acquisition; separate from GA4-resolved medium. Unavailable values are preserved as returned by GA4.
event_nameEvent nameSTRINGExact, case-sensitive GA4 event name. Join event metadata using both property_id and event_name.
is_key_eventIs key eventBOOLHistorical isKeyEvent status reported for these occurrences. Both true and false can exist for one event/date; this is part of the row key, not current configuration. Exact true maps to true; false, (not set), empty string and NULL map to false. (other) and other aggregation buckets map to NULL because their status is unknown. Unexpected representations also remain NULL and are detected by the raw supported-values check.
event_countEvent countINT64Number of event occurrences reported for this row (eventCount), not distinct users or sessions.
year_monthYear monthSTRINGYYYY-MM derived from date for filtering or grouping. It does not make the row a monthly total or make user metrics additive.
property_name_currentProperty name currentSTRINGLatest loaded property display name. It may change on refresh and is not the historical name on the activity date.
property_metadata_observed_atProperty metadata observed atTIMESTAMPUTC extraction timestamp of the current property metadata joined to this row; NULL when metadata is unavailable.
property_timezoneProperty timezoneSTRINGProperty reporting timezone captured during extraction; date is interpreted in this timezone.
client_idClient idSTRINGLucen organization identifier supplied to the pipeline; not a GA4 user or browser client ID.
data_updated_atData updated atTIMESTAMPUTC extraction timestamp of the source report row; not the event time or the table build time.

gold_google_analytics_first_user_manual_source_medium_key_event_pivot_daily columns

19

gold_google_analytics_first_user_source_daily columns

19

gold_google_analytics_first_user_source_events_daily columns

IDNameTypeDescription
property_idProperty idSTRINGGA4 property ID. Include it in joins; event names and dimension values are not unique across properties.
dateDateDATEActivity date in the GA4 property's reporting timezone; the row is daily, not a period total.
first_user_sourceFirst user sourceSTRINGGA4-resolved source for the user's original acquisition, including eligible UTM, auto-tagged, organic and referral attribution. Not restricted to auto-tagged traffic.
event_nameEvent nameSTRINGExact, case-sensitive GA4 event name. Join event metadata using both property_id and event_name.
is_key_eventIs key eventBOOLHistorical isKeyEvent status reported for these occurrences. Both true and false can exist for one event/date; this is part of the row key, not current configuration. Exact true maps to true; false, (not set), empty string and NULL map to false. (other) and other aggregation buckets map to NULL because their status is unknown. Unexpected representations also remain NULL and are detected by the raw supported-values check.
event_countEvent countINT64Number of event occurrences reported for this row (eventCount), not distinct users or sessions.
year_monthYear monthSTRINGYYYY-MM derived from date for filtering or grouping. It does not make the row a monthly total or make user metrics additive.
property_name_currentProperty name currentSTRINGLatest loaded property display name. It may change on refresh and is not the historical name on the activity date.
property_metadata_observed_atProperty metadata observed atTIMESTAMPUTC extraction timestamp of the current property metadata joined to this row; NULL when metadata is unavailable.
property_timezoneProperty timezoneSTRINGProperty reporting timezone captured during extraction; date is interpreted in this timezone.
client_idClient idSTRINGLucen organization identifier supplied to the pipeline; not a GA4 user or browser client ID.
data_updated_atData updated atTIMESTAMPUTC extraction timestamp of the source report row; not the event time or the table build time.

gold_google_analytics_first_user_source_key_event_pivot_daily columns

18

gold_google_analytics_first_user_source_medium_content_daily columns

21

gold_google_analytics_first_user_source_medium_content_events_daily columns

IDNameTypeDescription
property_idProperty idSTRINGGA4 property ID. Include it in joins; event names and dimension values are not unique across properties.
dateDateDATEActivity date in the GA4 property's reporting timezone; the row is daily, not a period total.
first_user_sourceFirst user sourceSTRINGGA4-resolved source for the user's original acquisition, including eligible UTM, auto-tagged, organic and referral attribution. Not restricted to auto-tagged traffic.
first_user_mediumFirst user mediumSTRINGGA4-resolved medium for the user's original acquisition, including eligible UTM, auto-tagged, organic and referral attribution. Not restricted to auto-tagged traffic.
first_user_manual_ad_contentFirst user manual ad contentSTRINGManual utm_content attribution for the user's original acquisition. Also used in resolved source/medium/content reports because content remains the manual dimension.
event_nameEvent nameSTRINGExact, case-sensitive GA4 event name. Join event metadata using both property_id and event_name.
is_key_eventIs key eventBOOLHistorical isKeyEvent status reported for these occurrences. Both true and false can exist for one event/date; this is part of the row key, not current configuration. Exact true maps to true; false, (not set), empty string and NULL map to false. (other) and other aggregation buckets map to NULL because their status is unknown. Unexpected representations also remain NULL and are detected by the raw supported-values check.
event_countEvent countINT64Number of event occurrences reported for this row (eventCount), not distinct users or sessions.
year_monthYear monthSTRINGYYYY-MM derived from date for filtering or grouping. It does not make the row a monthly total or make user metrics additive.
property_name_currentProperty name currentSTRINGLatest loaded property display name. It may change on refresh and is not the historical name on the activity date.
property_metadata_observed_atProperty metadata observed atTIMESTAMPUTC extraction timestamp of the current property metadata joined to this row; NULL when metadata is unavailable.
property_timezoneProperty timezoneSTRINGProperty reporting timezone captured during extraction; date is interpreted in this timezone.
client_idClient idSTRINGLucen organization identifier supplied to the pipeline; not a GA4 user or browser client ID.
data_updated_atData updated atTIMESTAMPUTC extraction timestamp of the source report row; not the event time or the table build time.

gold_google_analytics_first_user_source_medium_content_key_event_pivot_daily columns

20

gold_google_analytics_first_user_source_medium_daily columns

20

gold_google_analytics_first_user_source_medium_events_daily columns

IDNameTypeDescription
property_idProperty idSTRINGGA4 property ID. Include it in joins; event names and dimension values are not unique across properties.
dateDateDATEActivity date in the GA4 property's reporting timezone; the row is daily, not a period total.
first_user_sourceFirst user sourceSTRINGGA4-resolved source for the user's original acquisition, including eligible UTM, auto-tagged, organic and referral attribution. Not restricted to auto-tagged traffic.
first_user_mediumFirst user mediumSTRINGGA4-resolved medium for the user's original acquisition, including eligible UTM, auto-tagged, organic and referral attribution. Not restricted to auto-tagged traffic.
event_nameEvent nameSTRINGExact, case-sensitive GA4 event name. Join event metadata using both property_id and event_name.
is_key_eventIs key eventBOOLHistorical isKeyEvent status reported for these occurrences. Both true and false can exist for one event/date; this is part of the row key, not current configuration. Exact true maps to true; false, (not set), empty string and NULL map to false. (other) and other aggregation buckets map to NULL because their status is unknown. Unexpected representations also remain NULL and are detected by the raw supported-values check.
event_countEvent countINT64Number of event occurrences reported for this row (eventCount), not distinct users or sessions.
year_monthYear monthSTRINGYYYY-MM derived from date for filtering or grouping. It does not make the row a monthly total or make user metrics additive.
property_name_currentProperty name currentSTRINGLatest loaded property display name. It may change on refresh and is not the historical name on the activity date.
property_metadata_observed_atProperty metadata observed atTIMESTAMPUTC extraction timestamp of the current property metadata joined to this row; NULL when metadata is unavailable.
property_timezoneProperty timezoneSTRINGProperty reporting timezone captured during extraction; date is interpreted in this timezone.
client_idClient idSTRINGLucen organization identifier supplied to the pipeline; not a GA4 user or browser client ID.
data_updated_atData updated atTIMESTAMPUTC extraction timestamp of the source report row; not the event time or the table build time.

gold_google_analytics_first_user_source_medium_key_event_pivot_daily columns

19

gold_google_analytics_geography_daily columns

21

gold_google_analytics_geography_events_daily columns

IDNameTypeDescription
property_idProperty idSTRINGGA4 property ID. Include it in joins; event names and dimension values are not unique across properties.
dateDateDATEActivity date in the GA4 property's reporting timezone; the row is daily, not a period total.
countryCountrySTRINGCountry attributed to the activity by GA4's geographic lookup; not necessarily the user's residence.
regionRegionSTRINGGeographic region attributed by GA4. Use with country and city to identify this report's full location grain.
cityCitySTRINGCity attributed by GA4. Use with country and region; city names are not globally unique.
event_nameEvent nameSTRINGExact, case-sensitive GA4 event name. Join event metadata using both property_id and event_name.
is_key_eventIs key eventBOOLHistorical isKeyEvent status reported for these occurrences. Both true and false can exist for one event/date; this is part of the row key, not current configuration. Exact true maps to true; false, (not set), empty string and NULL map to false. (other) and other aggregation buckets map to NULL because their status is unknown. Unexpected representations also remain NULL and are detected by the raw supported-values check.
event_countEvent countINT64Number of event occurrences reported for this row (eventCount), not distinct users or sessions.
year_monthYear monthSTRINGYYYY-MM derived from date for filtering or grouping. It does not make the row a monthly total or make user metrics additive.
property_name_currentProperty name currentSTRINGLatest loaded property display name. It may change on refresh and is not the historical name on the activity date.
property_metadata_observed_atProperty metadata observed atTIMESTAMPUTC extraction timestamp of the current property metadata joined to this row; NULL when metadata is unavailable.
property_timezoneProperty timezoneSTRINGProperty reporting timezone captured during extraction; date is interpreted in this timezone.
client_idClient idSTRINGLucen organization identifier supplied to the pipeline; not a GA4 user or browser client ID.
data_updated_atData updated atTIMESTAMPUTC extraction timestamp of the source report row; not the event time or the table build time.

gold_google_analytics_geography_key_event_pivot_daily columns

20

gold_google_analytics_landing_page_daily columns

19

gold_google_analytics_landing_page_events_daily columns

IDNameTypeDescription
property_idProperty idSTRINGGA4 property ID. Include it in joins; event names and dimension values are not unique across properties.
dateDateDATEActivity date in the GA4 property's reporting timezone; the row is daily, not a period total.
landing_pageLanding pageSTRINGSession entry page path without query string (landingPage): the page associated with the session's first pageview.
event_nameEvent nameSTRINGExact, case-sensitive GA4 event name. Join event metadata using both property_id and event_name.
is_key_eventIs key eventBOOLHistorical isKeyEvent status reported for these occurrences. Both true and false can exist for one event/date; this is part of the row key, not current configuration. Exact true maps to true; false, (not set), empty string and NULL map to false. (other) and other aggregation buckets map to NULL because their status is unknown. Unexpected representations also remain NULL and are detected by the raw supported-values check.
event_countEvent countINT64Number of event occurrences reported for this row (eventCount), not distinct users or sessions.
year_monthYear monthSTRINGYYYY-MM derived from date for filtering or grouping. It does not make the row a monthly total or make user metrics additive.
property_name_currentProperty name currentSTRINGLatest loaded property display name. It may change on refresh and is not the historical name on the activity date.
property_metadata_observed_atProperty metadata observed atTIMESTAMPUTC extraction timestamp of the current property metadata joined to this row; NULL when metadata is unavailable.
property_timezoneProperty timezoneSTRINGProperty reporting timezone captured during extraction; date is interpreted in this timezone.
client_idClient idSTRINGLucen organization identifier supplied to the pipeline; not a GA4 user or browser client ID.
data_updated_atData updated atTIMESTAMPUTC extraction timestamp of the source report row; not the event time or the table build time.

gold_google_analytics_landing_page_key_event_pivot_daily columns

18

gold_google_analytics_page_daily columns

19

gold_google_analytics_page_events_daily columns

IDNameTypeDescription
property_idProperty idSTRINGGA4 property ID. Include it in joins; event names and dimension values are not unique across properties.
dateDateDATEActivity date in the GA4 property's reporting timezone; the row is daily, not a period total.
page_pathPage pathSTRINGVisited page path without query string (pagePath). Describes the page associated with activity, not necessarily the session entry page.
event_nameEvent nameSTRINGExact, case-sensitive GA4 event name. Join event metadata using both property_id and event_name.
is_key_eventIs key eventBOOLHistorical isKeyEvent status reported for these occurrences. Both true and false can exist for one event/date; this is part of the row key, not current configuration. Exact true maps to true; false, (not set), empty string and NULL map to false. (other) and other aggregation buckets map to NULL because their status is unknown. Unexpected representations also remain NULL and are detected by the raw supported-values check.
event_countEvent countINT64Number of event occurrences reported for this row (eventCount), not distinct users or sessions.
year_monthYear monthSTRINGYYYY-MM derived from date for filtering or grouping. It does not make the row a monthly total or make user metrics additive.
property_name_currentProperty name currentSTRINGLatest loaded property display name. It may change on refresh and is not the historical name on the activity date.
property_metadata_observed_atProperty metadata observed atTIMESTAMPUTC extraction timestamp of the current property metadata joined to this row; NULL when metadata is unavailable.
property_timezoneProperty timezoneSTRINGProperty reporting timezone captured during extraction; date is interpreted in this timezone.
client_idClient idSTRINGLucen organization identifier supplied to the pipeline; not a GA4 user or browser client ID.
data_updated_atData updated atTIMESTAMPUTC extraction timestamp of the source report row; not the event time or the table build time.

gold_google_analytics_page_key_event_pivot_daily columns

18

gold_google_analytics_property_current columns

IDNameTypeDescription
property_idProperty idSTRINGGA4 property ID. Include it in joins; event names and dimension values are not unique across properties.
property_name_currentProperty name currentSTRINGLatest loaded property display name. It may change on refresh and is not the historical name on the activity date.
property_timezoneProperty timezoneSTRINGProperty reporting timezone captured during extraction; date is interpreted in this timezone.
currency_codeCurrency codeSTRINGProperty's configured reporting currency code from current metadata; not a metric or a currency conversion instruction.
client_idClient idSTRINGLucen organization identifier supplied to the pipeline; not a GA4 user or browser client ID.
metadata_observed_atMetadata observed atTIMESTAMPUTC extraction timestamp of the latest completed property metadata snapshot.

gold_google_analytics_property_daily columns

18

gold_google_analytics_property_events_daily columns

IDNameTypeDescription
property_idProperty idSTRINGGA4 property ID. Include it in joins; event names and dimension values are not unique across properties.
dateDateDATEActivity date in the GA4 property's reporting timezone; the row is daily, not a period total.
event_nameEvent nameSTRINGExact, case-sensitive GA4 event name. Join event metadata using both property_id and event_name.
is_key_eventIs key eventBOOLHistorical isKeyEvent status reported for these occurrences. Both true and false can exist for one event/date; this is part of the row key, not current configuration. Exact true maps to true; false, (not set), empty string and NULL map to false. (other) and other aggregation buckets map to NULL because their status is unknown. Unexpected representations also remain NULL and are detected by the raw supported-values check.
event_countEvent countINT64Number of event occurrences reported for this row (eventCount), not distinct users or sessions.
year_monthYear monthSTRINGYYYY-MM derived from date for filtering or grouping. It does not make the row a monthly total or make user metrics additive.
property_name_currentProperty name currentSTRINGLatest loaded property display name. It may change on refresh and is not the historical name on the activity date.
property_metadata_observed_atProperty metadata observed atTIMESTAMPUTC extraction timestamp of the current property metadata joined to this row; NULL when metadata is unavailable.
property_timezoneProperty timezoneSTRINGProperty reporting timezone captured during extraction; date is interpreted in this timezone.
client_idClient idSTRINGLucen organization identifier supplied to the pipeline; not a GA4 user or browser client ID.
data_updated_atData updated atTIMESTAMPUTC extraction timestamp of the source report row; not the event time or the table build time.

gold_google_analytics_property_key_event_pivot_daily columns

17

gold_google_analytics_session_channel_daily columns

19

gold_google_analytics_session_channel_events_daily columns

IDNameTypeDescription
property_idProperty idSTRINGGA4 property ID. Include it in joins; event names and dimension values are not unique across properties.
dateDateDATEActivity date in the GA4 property's reporting timezone; the row is daily, not a period total.
session_default_channel_groupSession default channel groupSTRINGGA4 sessionDefaultChannelGroup: GA4's default channel classification for the session, not a literal UTM value.
event_nameEvent nameSTRINGExact, case-sensitive GA4 event name. Join event metadata using both property_id and event_name.
is_key_eventIs key eventBOOLHistorical isKeyEvent status reported for these occurrences. Both true and false can exist for one event/date; this is part of the row key, not current configuration. Exact true maps to true; false, (not set), empty string and NULL map to false. (other) and other aggregation buckets map to NULL because their status is unknown. Unexpected representations also remain NULL and are detected by the raw supported-values check.
event_countEvent countINT64Number of event occurrences reported for this row (eventCount), not distinct users or sessions.
year_monthYear monthSTRINGYYYY-MM derived from date for filtering or grouping. It does not make the row a monthly total or make user metrics additive.
property_name_currentProperty name currentSTRINGLatest loaded property display name. It may change on refresh and is not the historical name on the activity date.
property_metadata_observed_atProperty metadata observed atTIMESTAMPUTC extraction timestamp of the current property metadata joined to this row; NULL when metadata is unavailable.
property_timezoneProperty timezoneSTRINGProperty reporting timezone captured during extraction; date is interpreted in this timezone.
client_idClient idSTRINGLucen organization identifier supplied to the pipeline; not a GA4 user or browser client ID.
data_updated_atData updated atTIMESTAMPUTC extraction timestamp of the source report row; not the event time or the table build time.

gold_google_analytics_session_channel_key_event_pivot_daily columns

18

gold_google_analytics_session_manual_source_daily columns

19

gold_google_analytics_session_manual_source_events_daily columns

IDNameTypeDescription
property_idProperty idSTRINGGA4 property ID. Include it in joins; event names and dimension values are not unique across properties.
dateDateDATEActivity date in the GA4 property's reporting timezone; the row is daily, not a period total.
session_manual_sourceSession manual sourceSTRINGManual utm_source attribution for the session; separate from GA4-resolved source. Unavailable values are preserved as returned by GA4.
event_nameEvent nameSTRINGExact, case-sensitive GA4 event name. Join event metadata using both property_id and event_name.
is_key_eventIs key eventBOOLHistorical isKeyEvent status reported for these occurrences. Both true and false can exist for one event/date; this is part of the row key, not current configuration. Exact true maps to true; false, (not set), empty string and NULL map to false. (other) and other aggregation buckets map to NULL because their status is unknown. Unexpected representations also remain NULL and are detected by the raw supported-values check.
event_countEvent countINT64Number of event occurrences reported for this row (eventCount), not distinct users or sessions.
year_monthYear monthSTRINGYYYY-MM derived from date for filtering or grouping. It does not make the row a monthly total or make user metrics additive.
property_name_currentProperty name currentSTRINGLatest loaded property display name. It may change on refresh and is not the historical name on the activity date.
property_metadata_observed_atProperty metadata observed atTIMESTAMPUTC extraction timestamp of the current property metadata joined to this row; NULL when metadata is unavailable.
property_timezoneProperty timezoneSTRINGProperty reporting timezone captured during extraction; date is interpreted in this timezone.
client_idClient idSTRINGLucen organization identifier supplied to the pipeline; not a GA4 user or browser client ID.
data_updated_atData updated atTIMESTAMPUTC extraction timestamp of the source report row; not the event time or the table build time.

gold_google_analytics_session_manual_source_key_event_pivot_daily columns

18

gold_google_analytics_session_manual_source_medium_content_daily columns

21

gold_google_analytics_session_manual_source_medium_content_events_daily columns

IDNameTypeDescription
property_idProperty idSTRINGGA4 property ID. Include it in joins; event names and dimension values are not unique across properties.
dateDateDATEActivity date in the GA4 property's reporting timezone; the row is daily, not a period total.
session_manual_sourceSession manual sourceSTRINGManual utm_source attribution for the session; separate from GA4-resolved source. Unavailable values are preserved as returned by GA4.
session_manual_mediumSession manual mediumSTRINGManual utm_medium attribution for the session; separate from GA4-resolved medium. Unavailable values are preserved as returned by GA4.
session_manual_ad_contentSession manual ad contentSTRINGManual utm_content attribution for the session. Also used in resolved source/medium/content reports because content remains the manual dimension.
event_nameEvent nameSTRINGExact, case-sensitive GA4 event name. Join event metadata using both property_id and event_name.
is_key_eventIs key eventBOOLHistorical isKeyEvent status reported for these occurrences. Both true and false can exist for one event/date; this is part of the row key, not current configuration. Exact true maps to true; false, (not set), empty string and NULL map to false. (other) and other aggregation buckets map to NULL because their status is unknown. Unexpected representations also remain NULL and are detected by the raw supported-values check.
event_countEvent countINT64Number of event occurrences reported for this row (eventCount), not distinct users or sessions.
year_monthYear monthSTRINGYYYY-MM derived from date for filtering or grouping. It does not make the row a monthly total or make user metrics additive.
property_name_currentProperty name currentSTRINGLatest loaded property display name. It may change on refresh and is not the historical name on the activity date.
property_metadata_observed_atProperty metadata observed atTIMESTAMPUTC extraction timestamp of the current property metadata joined to this row; NULL when metadata is unavailable.
property_timezoneProperty timezoneSTRINGProperty reporting timezone captured during extraction; date is interpreted in this timezone.
client_idClient idSTRINGLucen organization identifier supplied to the pipeline; not a GA4 user or browser client ID.
data_updated_atData updated atTIMESTAMPUTC extraction timestamp of the source report row; not the event time or the table build time.

gold_google_analytics_session_manual_source_medium_content_key_event_pivot_daily columns

20

gold_google_analytics_session_manual_source_medium_daily columns

20

gold_google_analytics_session_manual_source_medium_events_daily columns

IDNameTypeDescription
property_idProperty idSTRINGGA4 property ID. Include it in joins; event names and dimension values are not unique across properties.
dateDateDATEActivity date in the GA4 property's reporting timezone; the row is daily, not a period total.
session_manual_sourceSession manual sourceSTRINGManual utm_source attribution for the session; separate from GA4-resolved source. Unavailable values are preserved as returned by GA4.
session_manual_mediumSession manual mediumSTRINGManual utm_medium attribution for the session; separate from GA4-resolved medium. Unavailable values are preserved as returned by GA4.
event_nameEvent nameSTRINGExact, case-sensitive GA4 event name. Join event metadata using both property_id and event_name.
is_key_eventIs key eventBOOLHistorical isKeyEvent status reported for these occurrences. Both true and false can exist for one event/date; this is part of the row key, not current configuration. Exact true maps to true; false, (not set), empty string and NULL map to false. (other) and other aggregation buckets map to NULL because their status is unknown. Unexpected representations also remain NULL and are detected by the raw supported-values check.
event_countEvent countINT64Number of event occurrences reported for this row (eventCount), not distinct users or sessions.
year_monthYear monthSTRINGYYYY-MM derived from date for filtering or grouping. It does not make the row a monthly total or make user metrics additive.
property_name_currentProperty name currentSTRINGLatest loaded property display name. It may change on refresh and is not the historical name on the activity date.
property_metadata_observed_atProperty metadata observed atTIMESTAMPUTC extraction timestamp of the current property metadata joined to this row; NULL when metadata is unavailable.
property_timezoneProperty timezoneSTRINGProperty reporting timezone captured during extraction; date is interpreted in this timezone.
client_idClient idSTRINGLucen organization identifier supplied to the pipeline; not a GA4 user or browser client ID.
data_updated_atData updated atTIMESTAMPUTC extraction timestamp of the source report row; not the event time or the table build time.

gold_google_analytics_session_manual_source_medium_key_event_pivot_daily columns

19

gold_google_analytics_session_source_daily columns

19

gold_google_analytics_session_source_events_daily columns

IDNameTypeDescription
property_idProperty idSTRINGGA4 property ID. Include it in joins; event names and dimension values are not unique across properties.
dateDateDATEActivity date in the GA4 property's reporting timezone; the row is daily, not a period total.
session_sourceSession sourceSTRINGGA4-resolved source for the session, including eligible UTM, auto-tagged, organic and referral attribution. Not restricted to auto-tagged traffic.
event_nameEvent nameSTRINGExact, case-sensitive GA4 event name. Join event metadata using both property_id and event_name.
is_key_eventIs key eventBOOLHistorical isKeyEvent status reported for these occurrences. Both true and false can exist for one event/date; this is part of the row key, not current configuration. Exact true maps to true; false, (not set), empty string and NULL map to false. (other) and other aggregation buckets map to NULL because their status is unknown. Unexpected representations also remain NULL and are detected by the raw supported-values check.
event_countEvent countINT64Number of event occurrences reported for this row (eventCount), not distinct users or sessions.
year_monthYear monthSTRINGYYYY-MM derived from date for filtering or grouping. It does not make the row a monthly total or make user metrics additive.
property_name_currentProperty name currentSTRINGLatest loaded property display name. It may change on refresh and is not the historical name on the activity date.
property_metadata_observed_atProperty metadata observed atTIMESTAMPUTC extraction timestamp of the current property metadata joined to this row; NULL when metadata is unavailable.
property_timezoneProperty timezoneSTRINGProperty reporting timezone captured during extraction; date is interpreted in this timezone.
client_idClient idSTRINGLucen organization identifier supplied to the pipeline; not a GA4 user or browser client ID.
data_updated_atData updated atTIMESTAMPUTC extraction timestamp of the source report row; not the event time or the table build time.

gold_google_analytics_session_source_key_event_pivot_daily columns

18

gold_google_analytics_session_source_medium_content_daily columns

21

gold_google_analytics_session_source_medium_content_events_daily columns

IDNameTypeDescription
property_idProperty idSTRINGGA4 property ID. Include it in joins; event names and dimension values are not unique across properties.
dateDateDATEActivity date in the GA4 property's reporting timezone; the row is daily, not a period total.
session_sourceSession sourceSTRINGGA4-resolved source for the session, including eligible UTM, auto-tagged, organic and referral attribution. Not restricted to auto-tagged traffic.
session_mediumSession mediumSTRINGGA4-resolved medium for the session, including eligible UTM, auto-tagged, organic and referral attribution. Not restricted to auto-tagged traffic.
session_manual_ad_contentSession manual ad contentSTRINGManual utm_content attribution for the session. Also used in resolved source/medium/content reports because content remains the manual dimension.
event_nameEvent nameSTRINGExact, case-sensitive GA4 event name. Join event metadata using both property_id and event_name.
is_key_eventIs key eventBOOLHistorical isKeyEvent status reported for these occurrences. Both true and false can exist for one event/date; this is part of the row key, not current configuration. Exact true maps to true; false, (not set), empty string and NULL map to false. (other) and other aggregation buckets map to NULL because their status is unknown. Unexpected representations also remain NULL and are detected by the raw supported-values check.
event_countEvent countINT64Number of event occurrences reported for this row (eventCount), not distinct users or sessions.
year_monthYear monthSTRINGYYYY-MM derived from date for filtering or grouping. It does not make the row a monthly total or make user metrics additive.
property_name_currentProperty name currentSTRINGLatest loaded property display name. It may change on refresh and is not the historical name on the activity date.
property_metadata_observed_atProperty metadata observed atTIMESTAMPUTC extraction timestamp of the current property metadata joined to this row; NULL when metadata is unavailable.
property_timezoneProperty timezoneSTRINGProperty reporting timezone captured during extraction; date is interpreted in this timezone.
client_idClient idSTRINGLucen organization identifier supplied to the pipeline; not a GA4 user or browser client ID.
data_updated_atData updated atTIMESTAMPUTC extraction timestamp of the source report row; not the event time or the table build time.

gold_google_analytics_session_source_medium_content_key_event_pivot_daily columns

20

gold_google_analytics_session_source_medium_daily columns

20

gold_google_analytics_session_source_medium_events_daily columns

IDNameTypeDescription
property_idProperty idSTRINGGA4 property ID. Include it in joins; event names and dimension values are not unique across properties.
dateDateDATEActivity date in the GA4 property's reporting timezone; the row is daily, not a period total.
session_sourceSession sourceSTRINGGA4-resolved source for the session, including eligible UTM, auto-tagged, organic and referral attribution. Not restricted to auto-tagged traffic.
session_mediumSession mediumSTRINGGA4-resolved medium for the session, including eligible UTM, auto-tagged, organic and referral attribution. Not restricted to auto-tagged traffic.
event_nameEvent nameSTRINGExact, case-sensitive GA4 event name. Join event metadata using both property_id and event_name.
is_key_eventIs key eventBOOLHistorical isKeyEvent status reported for these occurrences. Both true and false can exist for one event/date; this is part of the row key, not current configuration. Exact true maps to true; false, (not set), empty string and NULL map to false. (other) and other aggregation buckets map to NULL because their status is unknown. Unexpected representations also remain NULL and are detected by the raw supported-values check.
event_countEvent countINT64Number of event occurrences reported for this row (eventCount), not distinct users or sessions.
year_monthYear monthSTRINGYYYY-MM derived from date for filtering or grouping. It does not make the row a monthly total or make user metrics additive.
property_name_currentProperty name currentSTRINGLatest loaded property display name. It may change on refresh and is not the historical name on the activity date.
property_metadata_observed_atProperty metadata observed atTIMESTAMPUTC extraction timestamp of the current property metadata joined to this row; NULL when metadata is unavailable.
property_timezoneProperty timezoneSTRINGProperty reporting timezone captured during extraction; date is interpreted in this timezone.
client_idClient idSTRINGLucen organization identifier supplied to the pipeline; not a GA4 user or browser client ID.
data_updated_atData updated atTIMESTAMPUTC extraction timestamp of the source report row; not the event time or the table build time.

gold_google_analytics_session_source_medium_key_event_pivot_daily columns

19

Typical questions

Prompt to try
Users / sessions this month

gold_google_analytics_property_dailydo not SUM users across days as unique

Prompt to try
Landing pages

gold_google_analytics_landing_page_daily

Prompt to try
Channel mix

gold_google_analytics_session_channel_daily

Starter queries

sql
SELECT date, property_id, total_users, active_users, new_users
FROM `your-project.your_org_gold.gold_google_analytics_property_daily`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY date DESC
LIMIT 100;
sql
SELECT date, property_id, landing_page, total_users, active_users
FROM `your-project.your_org_gold.gold_google_analytics_landing_page_daily`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY date DESC
LIMIT 100;
sql
SELECT date, property_id, page_path, total_users, active_users
FROM `your-project.your_org_gold.gold_google_analytics_page_daily`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY date DESC
LIMIT 100;
sql
SELECT date, property_id, country, region, city
FROM `your-project.your_org_gold.gold_google_analytics_geography_daily`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY date DESC
LIMIT 100;

Integration page