ga_session_start

INTEGER

NULLABLE

the first event_timestamp of the session

int timpestamp

session_id

INTEGER

NULLABLE

the google analytics session id

unique int

session_number

INTEGER

NULLABLE

the number of the session compared to prior visits made by the same visitor

number from 1 to n

source_medium_session

STRING

NULLABLE

the session attribution (complex logic) of the source_medium

concat(source,' / ', medium)

campaign_session

STRING

NULLABLE

the session attribution (complex logic) of the source_medium

the name of a campaign

full_referrer

STRING

NULLABLE

retrieval of the referrer of the first sesion event

a URL

default_channel_grouping_session

STRING

NULLABLE

the session attribution (complex logic) of the categorization of the traffic source (complex rules to map the possible values)

Organic Search, Paid Search, Email, Direct, Affiliates, Display, Referral, …

source_medium_user

STRING

NULLABLE

the user attribution (simple logic as provided by GA4 in the traffic_source) of the source_medium

concat(source,' / ', medium)

campaign_user

STRING

NULLABLE

the user attribution (simple logic as provided by GA4 in the traffic_source) of the source_medium

the name of a campaign

default_channel_grouping_user

STRING

NULLABLE

the user attribution (simple logic as provided by GA4 in the traffic_source) of the categorization of the traffic source (complex rules to map the possible values)

Organic Search, Paid Search, Email, Direct, Affiliates, Display, Referral, …

gclid

STRING

NULLABLE

search for the gclid in the session event parameters with proper attribution of all following session events since the gclid is detected (switch from one gclid at the beginning of the session to another one later on is managed)

a gclid string

date

DATE

NULLABLE

the date field used for the partitioning of the table (use it to avoid querying and be charged for all the data)

the day date of the ga_session_start

name

STRING

NULLABLE

the name of the attribution model

a string with a name for the attribution model user can select in a drop down (Traffic Source - Session (GA), Google Ads - Last Click, …)

channel

STRING

REPEATED

the name of the attributed channel

Paid Search, Direct, … or Untracked

order_sys_cd

STRING

REPEATED

opitional parameter to set a different sys code for the order

source

STRING

REPEATED

optional parameter to set a specific different source

sourcePlatform

STRING

REPEATED

optional parameter to set a specific different source platform

medium

STRING

REPEATED

optional parameter to set a specific different medium

sourceMedium

STRING

REPEATED

optional parameter to set a specific different source medium

AccountName

STRING

REPEATED

optional parameter to set a specific account name

CustomerId

STRING

REPEATED

optional parameter to set a specific customer id

CampaignName

STRING

REPEATED

the name of the campaign as per the attribution model

CampaignId

STRING

REPEATED

the name of the campaign id as per the attribution model

AdGroupName

STRING

REPEATED

optional parameter to set a specific google ad group name

AdGroupId

STRING

REPEATED

optional parameter to set a specific google ad group identifier

AdName

STRING

REPEATED

optional parameter to set a specific google ad name

AdId

STRING

REPEATED

optional parameter to set a specific google ad identifier

AdNetworkType

STRING

REPEATED

optional parameter to set a specific network type

keywordText

STRING

REPEATED

optional parameter to set a specific referral keyword

query

STRING

REPEATED

optional parameter to set a specific referral query

OfferId

STRING

REPEATED

the offer id in systems like google shopping

item

RECORD

REPEATED

the details of the item id like for google analytics view_item

repeated record matching GA4 format

parameters

RECORD

REPEATED

speicifc parameters and values often set with available attribution values

date

DATE

NULLABLE

date - PK

Device

STRING

NULLABLE

device - PK

Campaignid

INTEGER

NULLABLE

campaign id - PK

CampaignName

STRING

NULLABLE

campaign name - PK

cost

FLOAT

NULLABLE

total costs

clicks

INTEGER

NULLABLE

total clicks

conversions

FLOAT

NULLABLE

total conversions

conversionvalue

FLOAT

NULLABLE

total conversion value

impressions

INTEGER

NULLABLE

total impression

interactions

INTEGER

NULLABLE

total interactions

attributions

RECORD

REPEATED

same structure as for prior tables

…

all the fields of gads_campaign_analytics

products_group_id

STRING

NULLABLE

the identifier of the products group as per your doc_product data

title_en

STRING

NULLABLE

title of the product group in English

title_de

STRING

NULLABLE

... German

title_fr

STRING

NULLABLE

… French

title_it

STRING

NULLABLE

… Italian

exact_margin

FLOAT

NULLABLE

the exact margin made based on your doc_order margin data

rounded_margin

FLOAT

NULLABLE

same but rounded

exact_price

FLOAT

NULLABLE

the exact sales price based on your doc_order data

rounded_price

FLOAT

NULLABLE

same but rounded

product_owners

STRING

REPEATED

configured product owners

sku

STRING

NULLABLE

product sku

ean

STRING

NULLABLE

product ean

gtin

STRING

NULLABLE

product gtin

article_id

STRING

NULLABLE

product article id

product_properties

RECORD

REPEATED

additional generic properties

product_id_properties

RECORD

NULLABLE

additional named properties (brand, category, …)