Period
Specify the period for which you want to perform the transformation.
| Variable name | Type | Description | Example of value |
|---|---|---|---|
{{start_suffix}} |
STRING |
The start variable is responsible for the period's start date for which transformation should be performed. Example value is an SQL code that takes one day less than the current date and turns it into a string that is understandable for Google BigQuery. In other words, this is the beginning of the period during which the transformation needs to be performed. We recommend using a data refresh interval of 1 day to save resources, but you can use any interval you prefer. Additionally, instead of SQL code, you can specify a specific date in the date format here, for example, |
FORMAT_DATE('%Y%m%d',DATE_SUB(CURRENT_DATE(), INTERVAL 3 DAY)) |
{{end_suffix}} |
STRING |
The end variable is responsible for the period's end date for which transformation should be performed. Example value is an SQL code that takes one day less than the current date and turns it into a string that is understandable for Google BigQuery. Thus, this transformation would take dates between start_suffix and end_suffix. This is the end of the period during which the transformation needs to be performed. We recommend using a data refresh interval of 1 day to save resources, but you can use any interval you prefer. Additionally, instead of SQL code, you can specify an end date in the date format, for example, |
FORMAT_DATE('%Y%m%d',DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY)) |
GA4 BigQuery Export table
Specify the parameters of the GA4 events export table. In the Table ID, specify the name before the underscore at the end, and without a suffix — calculated suffixes will be attached to this name in the future.
Important: Using this template assumes that all your data is located within one GCP (Google Cloud Platform) project.
If you store data in more than one project, please contact us via email at bi@owox.com before proceeding with the setup.
| Variable name | Type | Description | Example of value |
|---|---|---|---|
{{gcp_project_id}} |
STRING |
The project ID where the events table is located for which the current transformation is configured. |
cute-gbq-project |
{{ga4e_dataset_id}} |
STRING |
The dataset ID where the events table is located for which the current transformation is configured. |
OWOXBI_GA4_Streaming |
{{ga4e_table_id}} |
STRING |
ID of your table with events. Has a standard value: events_ |
events_ |
Additional parameters
Specify additional parameters used for merging events into sessions.
| Variable name | Type | Description | Example of value |
|---|---|---|---|
{{s_timeout}} |
STRING |
Session timeout is the duration after which one session is interrupted and the next begins. Specified in minutes. The default session expiration time in Google Analytics is 30 minutes. However, you can specify any time depending on your website settings. |
30 |
{{c_timeout}} |
STRING |
The waiting time for the campaign in days. When preparing the LNDC model, the specified number of days ago will be checked to determine the user's last indirect source. |
90 |
{{timezone}} |
STRING |
Timezone in which sessions will be collected. Specified for:
|
Europe/Kiev |
{{r_exclusion_list}} |
STRING |
Referral exclusion list.A list of domains that, when transitioned from, will not start a new session and users will not be counted as referral traffic. |
yourwebsite.com| onemoreyourwebsite.com| anothersite.com|verygoodsite.com |
Intermediate tables
Specify the names of the intermediate tables used for merging.
| Variable name | Type | Description | Example of value |
|---|---|---|---|
t1_table_id |
STRING |
Intermediate temporary table with sessions data. This table will be created automatically, choose a descriptive name to make sure the purpose of this table is clear in the future. |
temp_ga4_sessions |
t2_table_id |
STRING |
Intermediate temporary table with aggregated data. This table will be created automatically, choose a descriptive name to make sure the purpose of this table is clear in the future. |
temp_agg_sessions |
Merging results
Specify where to save merged sessions.
| Variable name | Type | Description | Example of value |
|---|---|---|---|
{{s_dataset_id}} |
STRING |
The dataset ID where the session table is located for which the current transformation is configured. Place, in which results of merging events would be saved. |
OWOXBI_GA4_Streaming |
{{s_table_id}} |
STRING |
The ID of the table with sessions. Place in which results of merging events would be saved. We recommend a standard value: export_ga4_sessions |
export_ga4_sessions |
0 Comments