Telemetry Stream CSV Import

How to Create a Unit Cost or Allocation Telemetry Stream by Uploading a CSV

A telemetry stream provides CloudZero with cloud usage data so you can ensure your business is maximizing profit when delivering cloud-based services. CloudZero allows you to create and update a unit cost or allocation telemetry stream through the UI by uploading a CSV with telemetry data. This can be a convenient alternative to sending telemetry stream data to the CloudZero API.

Unit Cost vs. Allocation

Before you create a telemetry stream, it's important to understand the difference between a unit cost and an allocation, and when it's appropriate to use which.

Unit Cost Overview

A unit cost is a measurement of how efficiently your company is operating in the cloud, calculated as cloud cost divided by unit of demand. You can choose the unit of demand that is appropriate to track for your business. For example, if you are a food delivery platform, your unit of demand might be the number of orders processed. The unit cost, then, is your cost per order.

Tracking unit costs helps you gauge whether your business is operating efficiently. Even if your total cloud costs increase, a decreased unit cost indicates that your business is scaling efficiently, because you are spending less money to process each transaction.

You can associate a unit cost with the cost data for a particular dimension, such as products your company sells. This allows you to further refine your analysis by determining cost per order per product, for example.

Allocation Overview

In contrast, an allocation is a way to split cloud costs into new categories based on actual usage. For example, if you have an AWS RDS database that is shared across engineering teams, you can create an allocation that assigns the actual number of RDS writes to a given team name. You could then reference one or more allocation streams directly in your CostFormation definitions as a source of data when crafting custom dimensions. Each element name defined in your stream -- in this case, an engineering team's name -- corresponds to an element that exists within the dimension. In this example, Team Alpha is an element in the Engineering Team dimension.

You can associate an allocation with an additional dimension's cost data. For example, you might want to see each engineering team's RDS usage split across a Product dimension. This allows you to determine how much money each team is spending on RDS to develop each of your company's products, for example.

📘

Learn More about Cloud Unit Economics

To learn how unit costs and allocations can help you manage cloud costs more efficiently, see What Is Cloud Unit Economics (CUE)? A Comprehensive And, More Importantly, Fun Guide.

Create a Unit Cost Telemetry Stream in the CloudZero UI

A unit cost telemetry stream sends CloudZero the data required to calculate your unit cost. For example, you can use the CloudZero UI to upload a CSV that lists the number of orders per day or per month. After you create a unit cost stream, you can create Analytics dashboards to track your unit costs over time.

Upload the Unit Cost CSV File

Include the following data in each row of the CSV you intend to upload:

• Required: Timestamp in any format. For example, 2024-09-01 or 2024-09-01T12:00:00Z.
• Required: Unit value. Must be greater than 0. For example, 200 to represent the number of orders for that day or month.
• Optional: Up to 5 dimension elements (one per column). This allows you to associate additional cost data with the unit cost you create. For example, if you provide an Engineering Team column, you can associate each engineering team value in the column with the cost per order in order to calculate the cost per order per engineering team.

The first row of the CSV file should list the column names, and you can use any names you like.

To create a unit cost telemetry stream by uploading a CSV to the CloudZero UI:

1. Navigate to Settings > Telemetry Streams.

2. Select Create New Stream > New Unit Cost Stream.

   

3. Enter a stream Name, such as engineering-team-orders. You cannot change this value after you create the stream. The name can include up to 256 letters, digits, underscores, periods, or hyphens in any combination.

4. Optionally, enter a Description for the stream.

5. Set Granularity of data in the stream to Daily (default) or Monthly. You cannot change this setting after you create the stream.

   Granularity determines the time period used to track data changes:

   • Daily granularity lets you track how unit values change from day to day.
   • Monthly granularity lets you track how unit values change from month to month.

   Any data provided at a finer level of granularity will be aggregated. For example, if you provide hourly data but choose Daily, all of the hourly values for a given metric will be combined into a single value for the day.

6. In the Upload CSV File section, select your CSV file or drag and drop the file into the field. You can replace the CSV with a new one at any point before creating the stream. Maximum file size is 3MB.

   

7. Select the Timestamp drop-down menu to choose the timestamps column from your CSV.

8. Select the Unit value drop-down menu to choose the unit values column from your CSV.

9. Optionally, select a target dimension from the Target Dimension (Optional) drop-down menu. This menu displays all of your organization's dimensions, including CloudZero-defined and user-defined dimensions.

   Selecting a target dimension enables you to associate the metric with cost data from a specific dimension so you can determine the cost per unit per dimension element. For example, you can select an Engineering Team dimension to calculate cost per order per engineering team.

   1. If you selected a target dimension, you must select an elements column in your CSV from the Dimension Element drop-down menu. This column provides the values that correspond to the target dimension. For example, if your CSV has a Team column that includes a value such as Team Alpha or Team Beta for each row, you'd select the Team column from this drop-down.

   2. Optionally, select the + (plus sign) beneath the first target dimension to add more target dimensions and elements. Any CSV columns not mapped to a dimension will be ignored when the stream is created.

      Note that you cannot change the target dimensions after you create the stream.

      

10. Ensure the CSV Reference Table shows your data as you expect it and that there are no errors displayed.

    

    If there is an error message, such as a type mismatch, you can select an invalid value in the CSV Reference Table and type in a new value. You can also reassign columns or upload a new CSV file.

11. Optionally, select Export to CSV to download a copy of the data in the CSV Reference Table. This is useful if you have manually edited any cell values to resolve errors and want to download a CSV that includes the updated data.

12. Select Save.

After CloudZero creates your stream, you are redirected to the Telemetry Streams page, where you can see your new unit cost stream in the table. Its status will change from Pending to Available after CloudZero ingests the data.

Note that it can take up to 24 hours for CloudZero to ingest the data from a new stream.

View the Unit Cost Stream Details

From the Telemetry Streams page, you can select the name of a unit cost stream to view its details page, where you can take the following actions:

• Add and/or replace records by uploading another CSV file
• Update the stream description
• Delete the stream
• Download a CSV file of recent records (the last 7 days)
• View information about the stream, including:
  • Stream type (Metric)
  • Granularity of data (Daily or Monthly)
  • Status (Pending or Available)
  • Source (CSV and/or API)
  • Targeted dimensions
  • Activity of records ingestion

Update the Unit Cost Stream

You can update the unit cost stream by uploading a new CSV file. The CSV file adds new records or replaces existing ones based on the record date:

• If a record in the CSV file has the same data as an existing record except for the unit value, the CSV record will replace (overwrite) the existing record.
• If a record in the CSV file has data that does not match any existing records, the CSV record will be added as a new entry.

To add and/or replace records in a unit cost stream:

1. From the Telemetry Streams page, select the name of the unit cost stream you want to update.

2. In the Upload CSV section, select your CSV file or drag and drop the file into the field. You can replace the CSV with a new one at any point before you select Update.

   

3. Select the Timestamps drop-down menu to choose the timestamps column from your CSV.

4. Select the Unit value drop-down menu to choose the unit values column from your CSV.

5. If you selected a target dimension when you created the stream, select the corresponding elements column in your CSV from the Dimension Element drop-down menu.

   

6. Ensure the CSV Reference Table shows your data as you expect it and that there are no errors displayed.

   If there is an error message, such as a type mismatch, you can select an invalid value in the CSV Reference Table and type in a new value. You can also remap columns or upload a new CSV file.

7. Optionally, select Export to CSV to download a copy of the data in the CSV Reference Table. This is useful if you have manually edited any cell values to resolve errors and want to download a CSV that includes the updated data.

8. Select Update.

CloudZero displays a message stating how many records it successfully updated. The updated records appear in CloudZero after the next data ingest.

Create an Allocation Telemetry Stream in the CloudZero UI

An allocation telemetry stream sends CloudZero the data required to calculate an allocation. For example, you can use the CloudZero UI to upload a CSV that lists the number of RDS writes per day or per month for each engineering team. After you create an allocation stream, you can create a custom dimension from it using CostFormation.

Upload the Allocation CSV File

Include the following data in each row of the CSV you intend to upload:

• Required: Timestamp in any format. For example, 2024-09-01 or 2024-09-01T12:00:00Z.
• Required: Allocation value. Must be greater than 0. For example, 1000 to represent the number of RDS writes for that day or month.
• Required: Element name. For example, Team Alpha to associate the number of RDS writes per day with the Alpha engineering team.
• Optional: Up to 5 dimension elements (one per column). This allows you to associate additional data sources with the allocation. For example, if you provide a Product column, you can associate each product in the column with the number of RDS writes per team in order to calculate the number of RDS writes per team per product.

The first row of the CSV file should list the column names, and you can use any names you like.

To create an allocation telemetry stream by uploading a CSV to the CloudZero UI:

1. Navigate to Settings > Telemetry Streams.

2. Select Create New Stream > New Allocation Stream.

   

3. Enter a stream Name, such as rds-writes-by-team. You cannot change this value after you create the stream. The name can include up to 256 letters, digits, underscores, periods, or hyphens in any combination.

4. Optionally, enter a Description for the stream.

5. Set Granularity of data in the stream to Hourly, Daily (default), or Monthly. You cannot change this value after you create the stream.

   Granularity determines the time period used to track data changes:

   • Hourly granularity lets you track how allocation values change from hour to hour.
   • Daily granularity lets you track how allocation values change from day to day.
   • Monthly granularity lets you track how allocation values change from month to month.

   Any data provided at a finer level of granularity will be aggregated. For example, if you provide hourly data but choose Daily, all of the hourly values for a given element will be combined into a single value for the day.

6. In the Upload CSV File section, select your CSV file or drag and drop the file into the field. You can replace the CSV with a new one at any point before creating the stream. Maximum file size is 3MB.

   

7. Select the Timestamp drop-down menu to choose the timestamps column from your CSV.

8. Select the Allocation value drop-down menu to choose the allocation values column from your CSV.

9. Select the Element name drop-down menu to choose the element names column from your CSV. If you use the allocation stream to create a dimension later, these values become the element names in the dimension.

10. Optionally, select a target dimension from the Target Dimension (Optional) drop-down menu. This menu displays all of your organization's dimensions, including CloudZero-defined and user-defined dimensions.

    Selecting a target dimension enables you to associate the allocation with cost data from an existing dimension so you can group the allocated usage by each element in the selected dimension. For example, you can select the Product dimension to calculate number of RDS writes per engineering team per product.

    1. If you selected a target dimension, you must select an elements column in your CSV from the Dimension Element drop-down menu. This column provides the values that correspond to the target dimension. For example, if your CSV has a Product column that includes a value such as Analytics or AI Solutions for each row, you'd select the Product column from this drop-down.

    2. Optionally, select the + (plus sign) beneath the first target dimension to add more target dimensions and elements. Any CSV columns not mapped to a dimension will be ignored when the stream is created.

       Note that you cannot change the target dimensions after you create the stream.

       

11. Ensure the CSV Reference Table shows your data as you expect it and that there are no errors displayed.

    

    If there is an error message, such as a type mismatch, you can select an invalid value in the CSV Reference Table and type in a new value. You can also remap columns or upload a new CSV file.

12. Optionally, select Export to CSV to download a copy of the data in the CSV Reference Table. This is useful if you have manually edited any cell values to resolve errors and want to download a CSV that includes the updated data.

13. Select Save.

After CloudZero creates your stream, you are redirected to the Telemetry Streams page, where you can see your new allocation stream in the table.Its status will change from Pending to Available after CloudZero ingests the data.

Note that it can take up to 24 hours for CloudZero to ingest the data from a new stream.

View the Allocation Stream Details

From the Telemetry Streams page, you can select the name of an allocation stream to view its details page, where you can take the following actions:

• Add and/or replace records by uploading another CSV file
• Update the stream description
• Delete the stream
• Download a CSV file of recent records (the last 7 days)
• View information about the stream, including:
  • Stream type (Allocation)
  • Granularity of data (Daily, Hourly, or Monthly)
  • Status (Pending or Available)
  • Source (CSV and/or API)
  • Targeted dimensions
  • Activity of records ingestion

Update the Allocation Stream

You can update the allocation stream by uploading a new CSV file. The CSV file adds new records or replaces existing ones based on the record date:

• If a record in the CSV file has the same data as an existing record except for the allocation value, the CSV record will replace (overwrite) the existing record.
• If a record in the CSV file has data that does not match any existing records, the CSV record will be added as a new entry.

To add and/or replace records in an allocation stream:

1. From the Telemetry Streams page, select the name of the allocation stream you want to update.

2. In the Upload CSV file section, select your CSV file or drag and drop the file into the field. You can replace the CSV with a new one at any point before you select Update.

   

3. Select the Timestamp drop-down menu to choose the timestamps column from your CSV.

4. Select the Allocation Value drop-down menu to choose the allocation values column from your CSV.

5. Select the Element name drop-down to choose the element names column from your CSV.

6. If you selected a target dimension when you created the stream, select the corresponding elements column in your CSV from the drop-down menu.

   

7. Ensure the CSV Reference Table shows your data as you expect it and that there are no errors displayed.

   If there is an error message, such as a type mismatch, you can select an invalid value in the CSV Reference Table and type in a new value. You can also remap columns or upload a new CSV file.

8. Optionally, select Export to CSV to download a copy of the data in the CSV Reference Table. This is useful if you have manually edited any cell values to resolve errors and want to download a CSV that includes the updated data.

9. Select Update.

CloudZero displays a message stating how many records it successfully updated. The updated records appear in CloudZero after the next data ingest.

Delete a Telemetry Stream

To delete a unit cost or allocation telemetry stream through the Telemetry Streams page:

1. Select the three-dot icon in the Actions column for the stream you intend to delete.
2. Select the Delete Telemetry Stream button.
3. Type the name of the stream into the dialog box.
4. Select Delete.

To delete a telemetry stream through the stream's details page:

1. Select the Delete Stream button.
2. Type the name of the stream into the dialog box.
3. Select Delete.

CloudZero completes the stream deletion within 1 hour.