How to create Transformation from a 'Merge Events into Sessions (App Data)' template

In this article, you will find step-by-step instructions about how to create a Transformation from the "Merge Events into Sessions (App Data)" template.

Important: Please make sure you meet the minimum requirements with OWOX BI Transformation functionality.

Step-by-step setup

Step 1. Go to the Workspace page and click the "New..." button in the top panel over the diagram. Choose the “Transformation” option in the popup menu.

Step 2. Now you will see the dialog with Templates gallery options. Choose the "Merge Events into Sessions (App Data)" template from the list in the sidebar:

Step 3. Click on the “Create & setup” button. And you will see your new Transformation:

How you can customize the template

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 before proceeding with the setup.

When you create a Transformation from a template, you can customize the list of Operations and their order, edit the SQL code, add or remove variables (list of variables for 'Merge Events into Sessions (App Data)' template), set up destinations, and add triggers for autoruns. Best of all, you can use these templates without any limits.

The Transformations created from templates will also be displayed on the Workspace diagram, giving you a clear overview of your data transformation process.


Run the Transformation and get analytics-ready data

Once you've finished debugging (all variables are set, list of Operations is actual), click on the “Run” button to start the sequential execution of the Operations. Check the status on the “Run history” tab.

After the successful run, go to your BigQuery account and check the table.


Automate your data transformation process

Once you've finished debugging and you are sure the Transformation works correctly, you can set up a time trigger. With autoruns, you will get up-to-date data for your reports without headaches. Read more about autorun triggers in this article.

ImportantPlease note: we recommend setting time triggers with a gap of five minutes or more for two different transformations, especially if they refer to the same table. This is because two simultaneous requests to the table can cause an error, resulting in the transformation not executing correctly.


Feedback and support

If you have any feedback or suggestions, please feel free to reach out to us via

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


Please sign in to leave a comment.