Variables list for the 'CMO Dashboard' template

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, CAST ('20230101' AS STRING).

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, CAST ('20230101' AS STRING).

FORMAT_DATE('%Y%m%d',DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY))

 

 

Path to merging events results

Specify the path to the table with sessions. 

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

ID of your project in Google Big Query, where the session table is located for which the 'CMO Dashboard' transformation is configured.

 

cute-gbq-project
{{s_dataset_id}} STRING

The dataset ID where the session table is located for which the 'CMO Dashboard' transformation is configured.

OWOXBI_GA4_Streaming
{{s_table_id}} STRING

The ID of the table with sessions. 

owoxbi_ga4_sessions

 

Additional parameters

Variable name Type Description Example of value
{{c_event}} STRING

Conversion event. 
For transactions, you must use the standard name purchase, for page views - name of event, like registration_complete.

purchase OR registration_complete
{{c_url}} STRING

Conversion URL - allows you to set the URL where the conversion event occurs (by default it is set as the entire site).

%% - this value stands for the whole site.
%/conversion% - for the specified conversion page
{{step_1}} STRING

Parameter, responsible for the add_to_cart event. 

add_to_cart
{{step_2}} STRING

Parameter, responsible for the begin_checkout event. 

begin_checkout

 

Results

Specify the data, where the result of this transformation would be saved. This table would be used as a source for the dashboard template. 

Variable name Type Description Example of value
{{r_dataset_id}} STRING

The ID of your dataset in Google Big Query, where the result of the 'CMO Dashboard' transformation would be saved.

OWOXBI_Reports
{{r_table_id}} STRING

ID of the CMO_dashboard_table. Has a standard value: CMO_dashboard_table

CMO_dashboard_table
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.