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 7 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)) |
BlendedAdSpend Data
Specify the parameters of the OWOX Blended AdSpend table.
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 ID of your project in Google Big Query, where the BlendedAdSpend table is stored. |
cute-gbq-project |
{{ba_dataset_id}} |
STRING |
The ID of your dataset in Google Big Query, where the BlendedAdSpend table is stored. |
OWOXBI_BlendedAdSpend |
{{ba_table_id}} |
STRING |
ID of the BlendedAdSpend table. Has a standard value: BlendedAdSpend |
BlendedAdSpend |
Path to the merging events results
Specify the path to the table with 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 cost, clicks and impressions attribution would be saved. |
OWOXBI_GA4_Streaming |
{{s_table_id}} |
STRING |
The ID of the table with sessions. Place in which results of cost, clicks and impressions attribution would be saved. |
owoxbi_ga4_sessions |
CRM Data settings
Specify the CRM Data settings.
| Variable name | Type | Description | Example of value |
|---|---|---|---|
{{crm_table_id}} |
STRING |
The id of a table, where the CRM data is located for which the current transformation is configured. |
crmStandart |
{{completed_status}} |
STRING |
The default value for fully completed transactions. |
Completed |
{{update_online_identifiers}} |
STRING |
Updating of online identifiers (clientId, userId etc.) |
0 - do not update 1 - update all |
{{data_priority}} |
STRING |
What type of transactions should be considered as the main source? |
0 - CRM transactions over Streaming transactions 1 - CRM transactions equally with Streaming transactions 2 - Streaming transactions over CRM transactions |
Project name
Please, specify the name of your OWOX BI project.
| Variable name | Type | Description | Example of value |
|---|---|---|---|
{{project_name}} |
STRING |
The indicative variable, adds the name of the project in every operation. More technical: code is added to every operation and it's easy to define transformation / project for CSM. |
OWOX or OnlineShop |
Transformation settings
Please, add the needed settings to your transformation.
| Variable name | Type | Description | Example of value |
|---|---|---|---|
{{conversion_window}} |
STRING |
Conversion window in days, in which the transaction would be attributed to previous session. |
30 |
{{attribution_exclusions}} |
STRING |
Exclusion list for attribution, that gives the opportunity to ignore some values in the attribution model. Excludes sources from value attribution for standard attribution models. It works for both direct matches and inclusions. |
google / cpc - excludes all sessions with source/medium 'google / cpc'. / .*organic.* - excludes all sessions with medium including 'organic'. facebook / / .*brand.* - excludes all sessions with source 'facebook', and 'campaign', containing 'brand'. |
{{move_value}} |
STRING |
A variable that takes a value of 1 or 0. If set to 1, it transfers the value from the transaction to the previous non-excluded session, if such a session exists, and if the source/medium/campaign where the transaction occurred is in the exclusion list. If set to 0, even if the source/medium/campaign where the transaction occurred is in the exclusion list, the session will receive part of the value. 1 - default value. |
1 or 0 |
{{ir}} |
STRING |
IR - initial run. |
# - if first run. - for all subsequent runs. |
Path to the Transformations result
Specify the path to the place, where results of transformations would be saved.
| Variable name | Type | Description | Example of value |
|---|---|---|---|
{{m_dataset_id}} |
STRING |
The dataset ID where the model's data would be located, and for which the current transformation is configured. |
OWOXBI_DataModel |
{{transactions_table_id}} |
STRING |
The table, where the transactions would be located. |
streamingTransactions - for just WEB transactions crmTransactions - for WEB+CRM transactions |
0 Comments