Contents

Understanding Field Names

There are several ways to access the GA4 data:

  1. On BigQuery, where you are able to query the data directly
  2. Via the Pipeline GA4 Looker Studio Connector.

Field names are different depending on where you access the GA4 data.

In BigQuery the field names contain prefixes describing the type of underlying data they are.

In Looker Studio you get the more nicely formatter, less over-explained version.

They both have their pros and cons!

Explaining field names

BigQuery Field Names

When accessing the data via BigQuery directly the field names start with different characters depending on what they are:

  • dim__ - This field is a dimension (i.e dim__landing_page__full_domain)
  • met__ - This field is a metric (i.e met_sessions)
  • met_ce__ - This field as a conversion metric (i.e met_ce__visits_pricing_sum)
  • key__ - This field is a key (i.e key__session)
  • dim_sp__ - This field is a custom session dimension.
  • met_sp__ - This field is a custom session metric.
  • dim_up__ - This field is a custom user dimension.
  • met_up__ - This field is a custom user metric.

All of these last 4 are the session and user properties you’ve defined in the interface.

Looker Studio Field Names

In Looker Studio the fields are the exact same as in BigQuery, but with more user friendly names. For example, met__event_count is simply Event Count.

This is to save you having to rename all the fields.

Here's an example of the BigQuery Name and the Looker Studio Names side by side. You can see the full lists of the schema in each table in the Default Tables section.

6 columns selected