March 17, 2023 — OWOX BI Transformation. Introducing Templates gallery for Transformations

Today, we’re excited to announce the Templates gallery for OWOX BI Transformations. Our colleagues from the OWOX Analysts team have created two initial templates: Blended AdSpend and Sessionization. And now, you can use these templates and streamline your data preparation process to save time and effort.

While browsing the Templates gallery, you can read the detailed template description and see a list of Operations.


As we wrote above, the first two templates are now available. And this is our smooth start for now. We are working on expanding the template gallery with new transformation templates.

About available templates

The Blended AdSpend template will help you to blend cost data across all channels, such as Facebook Ads, Twitter Ads, Bing Ads, LinkedIn Ads, and other advertising platforms, into one currency. You will get cost data in an automatically updated, unified, and user-friendly table without unnecessary fields.

The Sessionization template, on the other hand, allows you to automatically merge GA4 events into sessions without relying on the Google Analytics logic of session formation. This means that you can easily access ready-to-use, automatically updated session tables in a convenient structure.

How you can customize templates

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, 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.

At OWOX BI, we are dedicated to improving our products and are always looking for ways to better serve our customers. If you have any feedback or suggestions, please feel free to reach out to us via

Thank you for choosing OWOX BI.

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


Please sign in to leave a comment.