ImportantThe Report Runs consumption units apply exclusively to the OWOX: Reports, Charts & Pivots extension for Google Sheets.
OWOX Reports, Charts & Pivots (Google Sheets Extension): Terms of Usage
The "OWOX: Reports, Charts & Pivots" extension for Google Sheets allows users to create and manage Data Marts (Queries) within their OWOX BI project. A Data Mart includes the user's SQL statements and the active Google Cloud Platform (GCP) project name.
How Are Report Runs Counted?
- Running a Data Mart (Query) triggers the execution of SQL statements.
- Each successful execution of a Data Mart in the extension counts as 1 Report Run, regardless of the volume of processed data.
- The Data Mart (Query) is executed on behalf of the customer's GCP project within the dedicated OWOX BI Project, and processing costs are charged to the customer’s GCP billing account.
- Report Runs are counted equally, whether the Data Mart (Query) was executed manually or via automation.
- The type of SQL statement (e.g.,
SELECT,UPDATE,DELETE) does not affect the calculation of consumption units. - When calculating consumption units, all Google Sheets documents and their respective sheets where the Data Mart (Query) is executed are considered.
Examples of calculation consumption units
| Google Sheets Document | Sheet name | Data Mart (Query) name | Report Run |
|---|---|---|---|
| Document #1 | Sheet1 | Data Mart 1 |
1 (manual) 1 (scheduled) |
| Sheet2 | Data Mart 2 | 1 (scheduled) | |
| Document #2 | Sheet1 | Data Mart 3 | 3 (manual) |
| Document #3 | Sheet1 | Data Mart 2 | 24 (scheduled) |
| Document #4 | Sheet1 | Data Mart 1 | 1 (manual) |
| Sheet1 | Data Mart 2 | 1 (manual) | |
| Sheet1 | Data Mart 3 | 1 (manual) | |
| Sheet1 | Data Mart 4 | 1 (manual) | |
| Total: | 34 | ||
FAQ
Q: How can I monitor the number of Reports Runs per month?
A: On the OWOX BI app, go to the 'Credits consumption' page to see the number of Report Runs generated in the 'OWOX: Reports...' Extension. It shows the total for all your Google Sheets documents where reports have been launched.
Q: Will my reports be updated if I exceed the limit?
A: Absolutely! Your reports will keep updating on schedule, and manual runs will proceed as usual, even if you go beyond the limit. No interruptions here.
Q: How are the monthly limits calculated if I pay the tariff upfront for the year?
A: Let's break it down. If you need up to 2,000 data refreshes per month, select 2000 Report Runs monthly on the payment page. This totals to 1200 credits per year (i.e., 100 credits per month). Once your card is charged, you'll get 100 credits monthly to run 2000 Report Runs, ensuring regular updates to your reports within the OWOX BI project. Simple and seamless.
Q: What happens if I exceed the set limit?
A: If your Report Runs beyond the limit, you'll be billed on a Pay As You Go basis at the rates specified on our Pricing page. Let's break it down with an example: if you get 100 credits for 2000 Report Runs each month and end up using 3000 (equivalent to 150 credits) in the first month, the excess – 50 credits – will be charged to your card the following month. If this becomes a regular thing, you can adjust your plan; feel free to contact our Support Team for help.
0 Comments