In this article, you will find step-by-step instructions about how to create a Transformation from the 'Blended AdSpend + GA4 Cost Import (With Currency Convert)' 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 'Blended AdSpend + GA4 Cost Import (With Currency Convert)' 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 bi@owox.com 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, 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 with the following data schema.
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 bi@owox.com.
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.
0 Comments