Changes to iTunes Sales and Apple Music Reports

On May 13, 2019, customer identifiers included in Apple Music, iTunes Sales, iTunes Pre-order, and iTunes Match reports are being rotated on a regular basis.

We have also removed the UTC offset field and converted customer timestamps from UTC to local time in the Apple Music reports. This will help you analyze streaming activity by the time of day the activity occurred in the user’s local time.

For a full list of changes, see below:

Summary Streams - Event Report

• UTC offset column removed
• Datestamp adjusted to local time (previously in UTC)
• Version changed to V1_2
• New file name: AppleMusic_Event_[vendor number]_[date]_V1_2
• New Reporter command: java -jar Reporter.jar p=reporter.properties sales.getReport [vendor number], amstreams, Summary, daily, [date],1_2

Summary Streams (Content Report)

• No functional changes
• Version changed to V1_2
• New file name: AppleMusic_Content_[vendor number]_[date]_V1_2
• New Reporter command: java -jar Reporter.jar p=reporter.properties sales.getReport [vendor number], amstreams, Summary, daily, [date],1_2

Detailed Streams

• UTC offset column removed
• Anonymized Person ID converted to string (64 characters)
• Datestamp converted to local time (previously in UTC)
• Stream timestamp converted to local time (previously in UTC)
• Ingest timestamp truncated to seconds (previously in milliseconds)
• Version changed to V1_2
• New file name: AppleMusic_Streams_[vendor number]_[date]_V1_2
• New Reporter command: java -jar Reporter.jar p=reporter.properties sales.getReport [vendor number], amstreams, Detailed, daily, [date],1_2

Detailed Sales Report (Daily and Weekly)

• Customer Identifier converted to string (64 characters)
• Version changed to V1_2
• New file name (Daily): D_D_[vendor number]_[date]_V1_2
• New Reporter command (Daily): java -jar Reporter.jar p=reporter.properties sales.getReport [vendor number], sales, Detailed, Daily, [date],1_2
• New file name (Weekly): D_W_[vendor number]_[date]_V1_2
• New Reporter command (Weekly): java -jar Reporter.jar p=reporter.properties sales.getReport [vendor number], sales, Detailed, Weekly, [date],1_2

Detailed Pre-Order Report (Daily and Weekly)

• Customer Identifier converted to string (64 characters)
• Version changed to V1_2
• New file name (Daily): P_D_D_[vendor number]_[date]_V1_2
• New Reporter command (Daily): java -jar Reporter.jar p=reporter.properties sales.getReport [vendor number], pre-order, Detailed, Daily, [date],1_2
• New file name (Weekly): P_D_W_[vendor number]_[date]_V1_2
• New Reporter command (Weekly): java -jar Reporter.jar p=reporter.properties sales.getReport [vendor number], pre-order, Detailed, Weekly, [date],1_2

iTunes Match

• Customer Identifier converted to string (64 characters)
• Version changed to V1_1
• New file name: C_D_[vendor number]_[date]_V1_1
• New Reporter command: java -jar Reporter.jar p=reporter.properties sales.getReport [vendor number], cloud, Detailed, Daily, [date],1_1