Sales, trends, and reports
Sales and Trends on iTunes Connect provides next-day data, customizable graphs, and downloadable reports so you can track the performance of your books. You must have the Admin, Finance, or Sales role in iTunes Connect to access Sales and Trends.
- The Sales pages display graphs of high-level data. Filter data by territory, content, transaction type, and other dimensions, and modify your time period to see performance over a specific date range.
- The Reports page provides compressed ZIP files which contain more detailed data in spreadsheet format. Reports are available for specific days, weeks, months, or years.
If you have recently completed a legal entity name change, the new legal entity name has been set up as a new vendor with a new vendor ID. Sales are reported separately, and information from multiple vendor IDs cannot be consolidated. However, previous reports are still available in Sales and Trends on iTunes Connect.
Note: If you see a message that your account is pending when you go to Sales and Trends, your updated user role is likely still being processed. If you’re still seeing this message after 24 hours, let us know.
For more information, see the iTunes Connect Sales and Trends Guide.
About sales reports
On the Sales and Trends Reports page in iTunes Connect, the following reports are available:
- Summary Sales Reports show aggregated sales, minus refunds, for the chosen reporting period, such as daily or weekly. The report contains products, customer price, royalty price, and sales territory.
- Detailed Sales Reports are available to publishers that have had at least one Volume Content Service (VCS) transaction.
Users with the Admin, Finance, or Sales role can access Sales Reports on iTunes Connect. If you are an Admin, you can create a new user in Users and Roles on iTunes Connect.
Report date ranges
Daily, weekly, and monthly reports are saved for one year after they become available. Yearly reports are saved indefinitely. We don’t store or regenerate reports for download after these time periods expire.
Reports become available for download at the following times:
- Daily reports are available the following day.
- Weekly reports are available on Mondays.
- Monthly reports are available five days after the end of the month.
- Yearly reports are available six days after the end of the year.
Summary Sales reports are available by 6 a.m. in the time zone of the agreement and territories covered by that report. If a report covers multiple time zones, availability will be based on the latest time zone covered by that report.
Report time zones
Report time zones are based on the territories covered by each agreement:
- United States, Canada, Latin America: Pacific Standard Time (PST)/Pacific Daylight Time (PDT)
- Europe, Middle East, Africa: Central Europe Time (CET)
- Japan, Asia Pacific: Japan Standard Time (JST)
- Australia, New Zealand, Papua New Guinea, Solomon Islands: Australian Western Standard Time (AWST)
Reports for worldwide agreements use PST/PDT.
All reports contain a header row with the field names for each column. The reports include transactions that can be tracked by ISBN, vendor ID, or Apple ID.
Sales and Trends Reports for Books use PST/PDT and the following definitions for periods of time:
- A day starts at 12:00:00 a.m. and ends at 11:59:59 p.m. in the time zone for a territory.
- A week starts on Monday at 12:00:00 a.m. and ends on Sunday at 11:59:59 p.m. in the time zone for a territory.
- A month starts on the first day of the month at 12:00:00 a.m. and ends on the last day of the same month at 11:59:59 p.m. in the time zone for a territory.
- A year starts on January 1 at 12:00:00 a.m. and ends on December 31 at 11:59:59 p.m. in the time zone for a territory.
Sales and Trends reports vs. financial reports
There are several differences between the reports in Sales and Trends and those in Payments and Financial Reports on iTunes Connect.
- Timeframe: Weekly Sales and Trends reports end on Sunday and start on Monday, while reports from Payment and Financial Reports are based on Apple fiscal months that always end on a Saturday.
Transaction types: Sales and Trends reports include all account transactions of the day, while reports from Payment and Financial Reports only include processed transactions. Several factors impact the financial processing status, such as amount due, country of purchase, number of hours since purchase, content type, credit checks, and fraud rules.
Downloading sales reports
Reports are downloadable as tab-delimited text (.txt) files compressed in gzip (.gz) format. To view a downloaded report:
- Unzip the compressed gzip (.gz) file by opening it or using a utility.
- Open the extracted tab-delimited text (.txt) file in a spreadsheet application.
Opt-In reports are password-protected ZIP files, with a new password generated for each download. You can view this unique password on the Reports page. To open these files, use a decompression tool that supports password-protected ZIP files.
We also have a command-line tool, Reporter, which you can use to automate downloads of your Sales and Trends reports or Payments and Financial reports.
Sales report troubleshooting
How can I download my sales reports if I have multiple providers linked to my Apple ID on iTunes Connect?
You can still download all sales reports for these providers if you have the right user role: Admin, Finance, or Sales. Simply choose a different provider from the menu in Payments and Financial Reports and on the other pages on iTunes Connect.
Why can’t I see sales for a particular item?
That item may not be available on the store. Make sure you’ve accepted the latest agreements in Agreements, Tax, and Banking. If you’ve accepted the latest agreement, check the store status for your item on iTunes Connect.
Why do I see higher or lower sales for certain periods of time?
It’s very common for sales to rise and fall over time, which will show up as periods of high or low volumes in your downloads. We can’t comment on specific reasons why your download volumes might change over time or on other changes in customer behavior, including redownloads, purchases, or refunds.
Why do my reports show some transactions with a negative amount?
We provide refunds if the customer experience was unsatisfactory due to content or quality.
Why don’t my Sales and Trends reports match up with my Financial Reports?
There are significant differences in the reporting timeframes and transaction types across these two types of reports. Additionally, proceeds in the Sales and Trends report are only estimates based on daily downloads. Your final proceeds can be found in Payments and Financial Reports. Due to these differences, you should not reconcile these reports. For additional information, see the Sales and Trends Guide or the Payments and Financial Reports Guide.
Why don’t I see any data on the Trends graph of the Summary Page?
If you have not accumulated any sales since your contract started, you won’t see any data presented on the Trends graph. If you just started selling, you won’t see any sales or payment data presented until you have financial reports and payments, communicated and presented on the Earnings and Payments pages. Payments made to you for earnings prior to July 2010 are not presented on the graph.