Use our Google Cloud ESR Query Generator to calculate your current Effective Savings Rate.
Effective Savings Rate (ESR) - Guided Steps
Follow the steps to generate a BigQuery SQL, run it, paste results, and calculate your ESR.
We use Google Cloud Detailed Usage Cost and Pricing exports to calculate ESR. If you haven't enabled them yet, see the instructions below or our help article.
- Open Google Cloud Console > Billing > Your billing account
- Select Billing Export
- Enable exports to BigQuery for Detailed Usage Cost and Pricing
Note: When enabling exports for the first time, data can take up to 5 days to fully populate.
Choose the time range and provide your BigQuery export table IDs. End Date is non-inclusive.
Where to find this
Format: project.dataset_name.table_id
Where to find this
Format: project.dataset_name.table_id
Copy the generated SQL into BigQuery and run it against your data. You can proceed when ready.
Paste the BigQuery results below. JSON and tab-delimited formats are supported. We'll compute your ESR and show a breakdown.
Detected format:
Compute Savings Breakdown
| Compute Usage | |
| Compute Spend | |
| Gross Savings | |
| Effective Savings Rate | % |