SKU migration reports

Occasionally, we might shift how the SKUs related to your products are structured, or the product in Cloud Billing where they appear. When this happens, we create a file sku-migration-report.csv in the same location as your Customer Insights reports. Each SKU is located in a service, which has a 3-part hexadecimal ID of the form 0123-4567-89AB. In addition, each SKU has its own 3-part hexadecimal ID that is independent of the service ID, and unique across all services. You see the SKU ID in the sku_id column in the Customer insights report.

Report frequency

The SKU migration report is updated each day. If you have a retention policy on your Cloud Storage bucket, the update is delayed until the retention period has passed.

Report fields

The report contains the following information:

Field	Description
source_sku_id	The SKU ID of the original SKU.
target_sku_id	The SKU ID of the SKU that has replaced the original. If this is blank, then the original SKU has no replacement.
target_service_id	The service ID in which the replacement SKU is defined. If this is blank, then the original SKU has no replacement.
seller	Your company name.
product	The name of the product that the SKU relates to.
source_sku_name	A human-readable name of the source SKU (this is not how it appears on the customer invoice).
target_sku_name	A human-readable name of the SKU that has replaced the original. If this is blank, then the original SKU has no replacement.

Note: As we add features and make improvements to Cloud Marketplace, we add columns as needed to existing reports. If you set up any automated processing of your reports, you should configure it so that it operates based on the names of the columns, and doesn't depend on the total number of columns staying the same.