Generate TCO reports

This page describes how to generate total cost of ownership (TCO) reports for your infrastructure.

Understand your TCO report

The TCO report is the core of your infrastructure assessment. It describes the options you have for migrating your groups of assets to Google Cloud, and the associated costs, based on the migration preferences that you specify.

You choose groups of assets to include in the report, then you choose multiple sets of preferences to compare different migration scenarios. Your TCO report provides you with a high-level summary of the specifications of your assets across your groups, including information such as memory usage and storage usage. It also gives you a detailed comparison of the costs of migration for each individual group.

You can view your TCO report directly in Migration Center, or export it to Google Slides or Google Sheets, or download it as a CSV file or a Microsoft Excel spreadsheet.

  • The report in Google Slides format gives you a summary of your infrastructure and is useful for making executive-level decisions. It aggregates the cost items into a total cost, and gives a summary of the proposed configurations and target VM series for each asset group. It contains the information that you see in the Google Cloud console.
  • The report in Google Sheets format consists of two sheets, one for servers, and one for databases. It provides the details of the discovered assets, the recommended target VMs, and the associated costs for each individual asset in the group for which you generated the report.
  • The report in CSV format consists of two CSV files, one for servers, and one for databases. It provides the details of the discovered assets, the recommended target product for migration, and the associated costs for each individual asset in the groups for which you generated the report.
  • The report in Microsoft Excel format provides the same information as the report in CSV format, but contained in a single file for both servers and databases.

Out of scope assets are never included in a TCO report.

Limitations

  • If you generate a TCO report for a group that contains a database deployment and its underlying server, Migration Center generates separate cost estimates for the server and the database. For example, if server_1 is hosting database_1, and you group them together to generate the TCO report, you get cost estimates for running server_1 as a standalone VM in Compute Engine, and for running database_1 in Cloud SQL.
  • A report in Microsoft Excel format cannot contain more than 100k rows per sheet.
  • A report in Google Sheets format cannot contain more than 10 million cells.

Generate a report

To generate a TCO report, follow these steps:

  1. In the Google Cloud console, go to the Create reports page.

    Go to Create reports

  2. Click TCO and detailed pricing reports.

  3. On the Basic information page, enter a name and, optionally, a description for your report, then click Next.

  4. On the Select groups page, select up to five groups of assets that you want to include in the report, then click Next.

  5. On the Assign migration preferences page, expand each group to assign up to four preference sets that you want to compare. To use the same preference sets for all groups, select Apply to all groups.

  6. Click Generate report.

Your new report appears in the Reports page. For large groups of assets, it might take a few minutes for the report to be ready.

Export your TCO report

To export your report, follow these steps:

  1. In the Google Cloud console, go to the Reports page.

    Go to Reports

  2. From the list of reports, click the report that you want to export.

  3. Depending on the report that you want to generate, on the report details page do the following:

    • To export the TCO summary report in Google Slides format, click Export report > Export TCO report to Google Slides.
    • To export the detailed pricing report, click either Export report > Export detailed pricing report to CSV/Google Sheets or Export report > Export detailed pricing report to Microsoft Excel.

  4. The report generation starts. Don't navigate away from the window while the system generates the report. When the report generation finishes, do the following:

    • If you generated a TCO report in Google Slides format, to open your report, click Open report.
    • If you generated a detailed pricing report, do the following:
      • To download the files in Excel or CSV format, click Download.
      • To export your report to Google Sheets click Export to Google Sheets. Then, when the export finished, to view your report click Open in Google Sheets.

What's next