To do that, click “Calculate model”:
Then select transactional window and click “Run calculation”:
Model will be preparing for calculation:
Usually calculation takes up to 30 minutes. It depends on analyzed data volume: number of sessions and selected time frames.
Scheduling automatic calculations for the model
To ensure that you always have relevant data in your reports, you can automate calculations of your model by setting up calculations schedule.
To set up the schedule, do the following:
- Click “Set up schedule” on the header of your model:
- Select your preferred settings and click “Save”:
This lets you set a really flexible schedule specifying a particular time of calculations. When changing the settings, consider when your data is updated and loaded into Google BigQuery. For example, time when you get tables with users behavior data influences calculation time, and time after which your transactions data is changed influences transactional window.