Reports and Data Exports

OnSpend provides a number of visualizations and ways to access and monitor your Google Cloud usage and costs. However, you may need to extract this data and use in your own applications or visualization tools for further analysis of your billing data. OnSpend allows you to export data directly to a data source of your choice. If you require this data on a regular interval, you can also setup automated billing reports that will generate a data export file for you automatically on a time interval of your choice.

Custom Data Exports

Data exports provide an on-demand report of your billing data. If you need your billing data to do further analysis or you need to import it into your own applications or visualization tools, you can create a report with the desired data attributes for a specified time period.

To export billing data from OnSpend, complete the following steps.

1. From the Dashboard view, click the icon in the top-right corner of the screen.

OR

1. From the Groups view, search or navigate to the desired resource. Click the icon and select Export.
2. The Export dialog will prompt you for a start and end date, a date type (invoice vs. usage), an export file type, and by which attributes to group the results. You can also optionally apply cost filters.

3. Select a start and end date.
4. Select how you wish to have the data grouped. Select all boxes of the data attributes that you would like in the resulting export file.
5. Select the data file type the data will be exported to. Available options are CSV, Google Spreadsheet, Cloud Storage or BigQuery. Note: Exporting data to Google Spreadsheets, Cloud Storage or BigQuery requires additional authorization.
6. Select a date type that will determine whether usage date or invoiced date should be used for reporting.
7. You can optionally apply cost filters. See cost filtering for more information about applying cost filters.
8. Click OK.
9. A message will be displayed when the export is available. To access the file, click Open.

Note: If grouping by date is selected, the resulting export contains spend by date cost incurred. If grouping by month or if date type is Invoice Date, the resulting export contains spend by invoiced month.

Note: If exporting data to Cloud Storage, the resulting file will be created in the specified Cloud Storage bucket with the name: YYYYMMdd-YYYYMMdd-export-[CURRENT_TIME_MS].csv where YYYYMMdd represents the start and end date of the data export. The current time in milliseconds will be appended to the name of the file to prevent unintentional overwriting of previous reports.

Warning: If exporting data to an existing BigQuery table, data will be appended to the table if the report data types and the table schema data types are equivalent. If the data types between the table schema and reported data are different, the table will be overwritten.

Automated Billing Reports

Billing reports provide an automated report of your billing data on a specific schedule. This allows you to setup a report once and have that report delivered to your inbox every week, month, quarter, or year automatically. In addition to a data export file, the billing reports also include a summary of costs and a series of charts similar to what is available in the OnSpend dashboard. The charts available in automated billing reports are based on your dashboard preferences. To change the visualizations returned in a automated billing report, simply navigate to the Dashboard and update your selections.

Note: Automated reports configured with a daily intervals do not deliver messages to your inbox. You will be required to view the report results in the export type application (e.g Google Drive, Cloud Storage, BigQuery).

Creating Reports

To setup an automated billing report, complete the following steps.

1. From the Reports view click Create Report.

OR

1. From the Groups view search or navigate to the desired resource. Click the icon and select Report.
2. The Report dialog will prompt you for a name, an interval, an optional expiration date, a grouping and an export file type.

3. Provide a name for your report. Give it a name that will help you identify it in your list of reports.
4. Search and select a resource. If launching from the Groups view, this will automatically be pre-populated.
5. Select an interval at which the report will be delivered to your inbox. By default, reports will be delivered monthly. You can change this selection to either daily, weekly, quarterly, or annually. Reports will automatically be generated and delivered at the end of the time period you selected when all data has been collected and finalized which may take up to a few days at the end of each time period.
6. You can optionally set an expiration date on the report. By setting an expiration date, the report will automatically be disabled and cease to be generated and delivered once the expiration date is met.
7. Select how you wish to have the data grouped. Select all boxes of the data attributes that you would like in the resulting export file.
8. Select the data file type the data will be exported to. Available options are CSV, Google Spreadsheet, Cloud Storage, or BigQuery. Note: Exporting data to Google Spreadsheets, Cloud Storage, or BigQuery requires additional authorization.
9. Select a date type that will determine whether usage date or invoiced date should be used for reporting.
10. You can optionally apply cost filters. See cost filtering for more information about applying cost filters.
11. Click Save.

Note: If grouping by date is selected, the resulting export contains spend by date usage incurred. If grouping by month or if date type is Invoice Date, the resulting export contains spend by invoiced month.

Note: If exporting data to Cloud Storage, the resulting file will be created in the specified Cloud Storage bucket with the name: YYYYMMdd-YYYYMMdd-export-[REPORT_ID].csv where YYYYMMdd represents the start and end date of the report. A unique ID will be appended to the name of the file to prevent unintentional overwriting of report data.

Warning: If exporting data to an existing BigQuery table, data will be appended to the table if the report data types and the table schema data types are equivalent. If the data types between the table schema and reported data are different, the table will be overwritten.

Editing Reports

To edit a report, or change the time period or attributes included in the report, complete the following steps.

1. Navigate to the Reports view.
2. Click the icon of the report you wish to edit, and click Edit.
3. The Report dialog will prompt you to edit a name, an interval, an optional expiration date, a grouping or an export file type.

4. Edit the name for your report. Give it a name that will help you identify it in your list of reports.
5. If you wish to change the resource for this report remove the current resource, then search and select a resource.
6. To change the interval, select an interval at which the report will be delivered to your inbox. You can change this selection to either daily, weekly, monthly, quarterly, or annually.
7. You can optionally set an expiration date on the report. By setting an expiration date, the report will automatically be disabled and cease to be generated and delivered once the expiration date is met.
8. Select how you wish to have the data grouped. Select all boxes of the data attributes that you would like in the resulting export file.
9. Select the data file type the data will be exported to. Available options are CSV, Google Spreadsheet, Cloud Storage, or BigQuery. Note: Exporting data to Google Spreadsheets, Cloud Storage, or BigQuery requires additional authorization.
10. Select a date type that will determine whether usage date or invoiced date should be used for reporting.
11. You can optionally apply cost filters. See cost filtering for more information about applying cost filters.
12. Click Save.

Enabling or Disabling Reports

You can start or stop receiving reports by enabling or disabling reports respectively. When you disable a report, you and any other additional recipients will no longer be emailed a billing report.

To enable or disable a report, complete the following steps.

1. Navigate to the Reports view.
2. Select the status toggle of the report you wish to enable or disable.

OR

2. Click the icon of the report you wish to enable or disable.
3. Click Enable or Disable.

Deleting Reports

To permanently delete a billing report, complete the following steps.

1. Navigate to the Reports view.
2. Click the icon of the report you wish to delete.
3. Click Delete.