If you are reconciling accounts for numerous customers, you can process data much more quickly by uploading a CSV to create multiple usage records at once.
Download your metering template
In Tackle, click Metering in the left menu.
Click Upload CSV.
On the new page that opens, click CSV Template to download the template.
Prepare your metering records CSV file
Open the CSV template on your computer using a tool like Excel, Google Sheets or Numbers and add a row for each metering record you want to create. Fill in all columns as indicated in the table below. All fields are required, except for end_time, which is only required if you are metering a contract through Google Cloud.
Column header | Notes |
| The ID of the product for which you are submitting usage. Product ids are visible as a column in the listing display when you click Metering > Create new record. |
| The reference ID for the buyer you are billing. You can also find this in the Tackle list of active contracts or in the corresponding marketplace portal. |
| The name of the metric you are reporting for, referred to in AWS and Microsoft as a dimension or Google Cloud as a metric. |
| The amount of the metric you are measuring (for example 3 clicks, 20 users etc.). Do not enter the price of the metric, this should be a count not a monetary amount. |
| The time usage occurred (AWS, Microsoft) or started (Google Cloud). All times should be in the format of an RFC3339 timestamp, for example: For AWS, the start time for usage can be up to six hours in the past - as long as the customer is still subscribed to your product. However, if the customer unsubscribes, you must send the metering records within one hour of their cancellation to avoid any issues. |
| The end of the time range for measured usage (Google Cloud). For AWS and Microsoft, leave this field blank. All times should be in the format of an RFC3339 timestamp, for example:
For Google Cloud, the |
Tip
If you are doing a monthly true-up, enter the current day/time in the start_time field for AWS or Microsoft record. For a Google Cloud record, enter the current day/time in the end_time field, and set the start_time an hour before the end_time.
When you're finished, save your file in the CSV format.
Upload your completed metering record CSV file
Return to the Tackle platform and navigate back to Metering > Upload CSV.
Drag and drop the CSV file of your metering records from your computer onto the same page in Tackle. You can also click Select metering CSV to navigate to the file on your computer.
Review the submissions, and if it looks correct, click Submit.