Oops! Something went wrong while submitting the form.
Get a Demo
See your data in HubiFi < 2 days
Get step-by-step instructions for exporting reports App Store Connect, plus tips to analyze your app’s data and keep your financial reports organized.
Does your monthly routine involve manually logging into App Store Connect, downloading a handful of files, and then spending hours trying to piece them together in a spreadsheet? This process is not only time-consuming but also leaves plenty of room for human error. There is a much more efficient way to manage your app's financial data. It all starts with mastering the basics of exporting reports app store connect offers, which then opens the door to powerful automation. This guide will first walk you through the essential manual steps, then show you how to build a system that saves you time, improves accuracy, and gives you a consistent, up-to-date view of your business performance.
If you have an app on the Apple App Store, you’ll be spending a lot of time in App Store Connect. Think of it as your mission control center for everything related to your app's presence and performance. It’s a suite of web-based tools from Apple that lets you manage your app from submission to sale. This is where you’ll upload new app versions for review, update your product page with fresh screenshots and descriptions, and respond to customer reviews.
Beyond app management, App Store Connect is a goldmine of data. It’s the single source of truth for how your app is performing financially and how users are interacting with it. For finance teams and business owners, this is where you’ll find all the essential sales, subscription, and payment information you need to understand your revenue. The platform provides detailed reports that are critical for everything from daily performance tracking to complex financial reconciliation and compliance. Understanding how to access and use this data is the first step toward making smarter, data-driven decisions for your business. This guide will walk you through exactly how to pull those valuable reports so you can put them to work.
App Store Connect is packed with features, but a few stand out as essential for monitoring your app's health. The App Analytics section gives you a clear view of user engagement, showing you everything from how many people visit your App Store page to how many of them actually download and use your app. You can track session numbers, active devices, and crash rates to get a pulse on the user experience.
Next is Sales and Trends, which is where you’ll find the core data on your app’s commercial performance. This feature tracks your downloads, in-app purchases, and subscription revenue over time. Finally, the Payments and Financial Reports section provides the detailed monthly invoices and payment information you need for your accounting. It breaks down your earnings, taxes, and what you can expect to see in your bank account.
Before you can analyze your data, you need to know where to find it. The reporting interface in App Store Connect is straightforward once you know your way around. Most of the reports you'll need for performance analysis are located within the Sales and Trends section. Here, you can download App Store Sales and Trends reports directly.
You’ll find several report types available for download, including Summary Sales Reports, Subscription Reports, and Subscription Event Reports. These can typically be downloaded as compressed GZIP (.gz) files containing tab-separated values (.tsv), which you can easily open in any spreadsheet software. For those who need more frequent or automated data pulls, Apple also offers an App Store Connect API, which allows you to programmatically fetch reports without logging into the web interface every time.
App Store Connect offers a variety of reports, and knowing which one to pull can save you a ton of time. Each report type is designed to answer different questions about your app's performance, from daily sales snapshots to detailed financial statements. Think of it like this: you wouldn't use a balance sheet to check daily traffic, right? The same logic applies here. Choosing the right report ensures you get the exact data you need for financial planning, marketing strategy, or app development. Let's walk through the main report types so you can confidently find the information you’re looking for.
When you need a quick, daily pulse check on your app's performance, Sales and Trends reports are your best friend. These reports give you a near-real-time look at how your apps and in-app purchases are doing, with data available for the previous day. They are perfect for spotting immediate trends, assessing the impact of a recent marketing push, or just keeping a close eye on your progress. While this data is preliminary, it’s incredibly useful for making agile decisions. You can view Sales and Trends to get a clear picture of your daily unit sales and proceeds without waiting for the month-end financial close.
For the official numbers you’ll use for accounting and revenue recognition, turn to Financial Reports. Unlike the daily estimates in Sales and Trends, these reports show your final, processed earnings after all calculations and adjustments are complete. This is the data that reflects the actual revenue hitting your bank account, making it essential for accurate bookkeeping, financial planning, and meeting compliance standards like ASC 606. Think of these as your official monthly statements from Apple. They provide a comprehensive overview of your earnings, taxes, and net proceeds, giving you the concrete data needed for serious financial analysis.
If you want to understand how people are using your app, Analytics Reports are where you'll find the answers. These reports go beyond sales figures to give you detailed data on user engagement, usage patterns, and other key performance metrics. You can see everything from session numbers and crash rates to which screens users visit most. This information is vital for making informed decisions about future updates, feature improvements, and marketing strategies. By downloading analytics reports, you can gather the evidence you need to build a better app and create a more engaging user experience.
For any business with a recurring revenue model, Subscription Reports are indispensable. These reports provide a clear view of your subscription health, showing you the total number of active subscriptions at any given time. You can also see how many subscribers are on introductory offers and track retention over time. A particularly useful feature is the ability to see how many users have opted in to receive marketing communications, which can help you build a direct line to your most loyal customers. This data is key to understanding the effectiveness of your subscription model and identifying opportunities for growth.
Thinking of launching a new app? Pre-Order Reports can give you a valuable sneak peek into its potential success. These reports track the performance of apps you’ve made available for pre-order on the App Store. You can see exactly how many customers have placed and canceled pre-orders, giving you a solid indicator of market interest before your official launch day. This data is incredibly helpful for gauging demand, refining your launch strategy, and tailoring your marketing efforts to build momentum. It’s a great way to test the waters and make sure you’re set up for a strong start.
Getting your data out of App Store Connect is the first step toward deeper analysis and accurate financial reporting. The process is straightforward once you know where to look. Whether you need a quick sales snapshot or detailed financial data for your accounting records, Apple provides the tools to download what you need. This process is key to getting the raw data required for accurate revenue recognition and strategic planning. Let's walk through the exact steps to pull your reports, from navigating the interface to choosing the right format for your needs.
Start by logging into App Store Connect. All of your app's performance data lives here, ready for you to access. Once you're in, find and click on "Sales and Trends" from the main dashboard. This section is your hub for all sales-related reporting. From there, you'll see an option for "Sales and Trends Reports" in the left-hand menu. This is where you can download and view reports directly from Apple. Think of this as your command center for pulling the raw numbers that tell the story of your app's performance.
After you select "Sales and Trends Reports," you'll see a list of available report types. Scroll down to find the specific one you need, like the "Summary Sales Report." Next, you’ll need to set a few parameters to get the right data. If you manage multiple apps or company names, select the correct vendor number. Then, choose the reporting period. You can select a specific day, week, month, or year. This step is crucial for ensuring the data you export matches the period you need for your financial statements or performance analysis. Double-check your selections before moving on to the download.
Once you click download, App Store Connect will provide a compressed GZIP file, which has a .gz extension. Don't let the file type intimidate you. If you're on a Mac, you can simply double-click it to unzip it. On Windows, you might need a program like 7-Zip. Inside, you'll find a tab-delimited text file (.txt). This file is designed to be opened with any spreadsheet software, like Microsoft Excel or Google Sheets. From there, you can view your data in a familiar row-and-column format, making it much easier to read and begin your analysis.
If you find yourself manually downloading reports often, you might want to consider a more automated approach. The App Store Connect API is a powerful tool that lets you pull data programmatically without ever logging into the interface. This is perfect for businesses that need to feed app data directly into their own analytics dashboards or accounting software. Using the API requires some technical know-how, but it can save you a ton of time and reduce manual errors. You can learn more about downloading analytics reports via the API in Apple's official documentation.
It’s important to know what you’re looking at once you have the file. Sales and Trends reports are great for getting quick, next-day insights into your app's performance. They help you spot recent changes and make timely decisions. On the other hand, Payments and Financial Reports are the official record of your earnings after Apple has processed all transactions and fees. These are the reports you’ll use for accounting, revenue recognition, and tax purposes. Understanding the distinction helps you use the right data for the right task, ensuring your financial records are accurate and your strategic decisions are based on solid information.
Once you've exported your reports, the real work begins: turning all that raw data into actionable insights. It can feel like a lot to sort through, but this is where you find the stories your app is telling you about its performance, your users, and your revenue. Analyzing this data is the key to making smarter, data-driven decisions that guide your app's growth. Instead of guessing what users want or which marketing efforts are paying off, you can look directly at the numbers.
Think of your reports as a roadmap. They show you where you’ve been and give you clues about the best path forward. Are users in a specific country converting at a higher rate? Is a new feature getting the engagement you hoped for? Are your subscription numbers trending up or down? Answering these questions helps you refine your strategy, allocate your budget effectively, and ultimately build a better, more profitable app. We’ll walk through the key areas to focus on so you can start making sense of your data right away.
Before you get lost in the numbers, it’s helpful to know what you’re looking for. Start by tracking a few essential performance metrics to get a high-level view of your app's health. These are the vital signs that tell you how users are interacting with your app. Key metrics include daily and monthly active users (DAU/MAU), user retention rates, and session duration. By monitoring these figures, you can quickly spot trends and understand if your engagement strategies are working. Consistent tracking helps you set benchmarks and measure the impact of any changes you make, from new features to marketing campaigns.
Your financial reports are the clearest indicator of your app's commercial success. Dive into your sales and trends data to see how your app and its in-app purchases are performing. Look at total revenue, average revenue per user (ARPU), and customer lifetime value (CLV). It's also important to track sales by region and device. This analysis helps you understand your primary revenue drivers and identify opportunities for growth. For businesses with complex revenue streams, especially subscriptions, ensuring this data aligns with accounting standards like ASC 606 is crucial for accurate financial reporting.
Beyond the big-picture metrics, you need to understand how people actually use your app. User engagement data shows you which features are popular and where users might be getting stuck. Look at screen flow reports to see the paths users take through your app and identify any drop-off points. Metrics like feature adoption rates and conversion rates for specific actions (like signing up for a newsletter or making a purchase) provide deep insights into user behavior. This information is invaluable for improving the user experience and guiding your product development roadmap.
Understanding where your users are coming from can unlock new growth opportunities. Your Sales and Trends reports break down performance by territory, allowing you to see which markets are driving the most downloads and revenue. This geographic data is essential for tailoring your marketing efforts, localizing your app content, and identifying underserved regions. For example, if you notice a surge of users in a new country, you might consider translating your app store listing or running targeted ad campaigns to build on that momentum.
If your app uses a subscription model, the Subscription Report is your best friend. This report details your active subscriptions, new sign-ups, and churn rate (the percentage of subscribers who cancel). Analyzing this data helps you understand the health of your subscription business and the effectiveness of your pricing strategies, including any introductory offers. A rising number of active subscriptions is great, but a high churn rate could signal issues with value or user satisfaction. Keeping a close eye on these trends is key to building a sustainable revenue stream.
Once you’ve exported your App Store Connect reports, the real work begins: turning all that raw data into something you can actually use to make decisions. The right tool for this job really depends on your business's scale and complexity. A small startup might be perfectly happy with a simple spreadsheet, while a high-volume business will need something more powerful to handle the load and automate the process.
Choosing the right software is about more than just creating pretty charts. It’s about building a system that can grow with you, ensuring your financial data is accurate, compliant, and easy to access. A great setup will connect all your data sources, giving you a clear view of your business performance without hours of manual work. As you explore your options, think about which tools offer the best integrations with the systems you already use, like your accounting software or CRM. This will save you a ton of headaches down the road.
For many, the first stop for data analysis is a trusty spreadsheet. Tools like Microsoft Excel or Google Sheets are familiar, accessible, and surprisingly powerful for getting a handle on your exported data. You can easily sort, filter, and create basic charts to visualize sales trends or track key metrics. They’re a great starting point because they don’t require a huge investment in time or money to get going.
However, as your app grows and your data volume increases, you’ll likely start to feel the limitations of spreadsheets. Manually importing new reports each week or month is time-consuming and opens the door to human error. For businesses that need to maintain strict financial compliance, a simple copy-paste mistake can become a major problem.
When spreadsheets start holding you back, Business Intelligence (BI) platforms are the logical next step. Think of tools like Tableau or Power BI. These platforms are designed to connect directly to multiple data sources, pull information automatically, and create interactive dashboards. To get your App Store Connect data into a BI tool, you’ll typically need a "data pipeline" to automate the transfer, which can be set up using third-party services.
The main advantage here is automation and depth. Instead of manually updating your numbers, your dashboards refresh on their own, giving you a real-time look at your business performance. This allows you to spend less time wrangling data and more time analyzing it to make strategic decisions about your app’s future.
If your primary goal is to communicate data clearly, then a dedicated data visualization tool is your best friend. While many BI platforms have great visualization features, tools like Google Data Studio are specifically built to turn complex datasets into easy-to-understand reports and dashboards. Since it has a free version and is simple to set up, it’s a popular choice for visualizing exported data without a steep learning curve.
These tools are fantastic for sharing insights with your team, investors, or other stakeholders. A well-designed chart can tell a story much more effectively than a table of numbers, helping everyone quickly grasp performance trends, identify regional opportunities, or see the impact of a recent marketing campaign.
For high-volume businesses with complex revenue models or strict compliance needs, off-the-shelf tools sometimes don't cut it. This is where custom analytics solutions come in. A custom solution is built specifically for your business, integrating directly with your financial systems to provide actionable insights tailored to your unique operations. This approach is ideal for automating complex processes like revenue recognition under ASC 606.
Instead of trying to piece together multiple tools, you can work with a partner to build a system that handles everything from data integration to financial reporting. If you’re spending more time managing data than using it, it might be time to schedule a demo to see how a tailored solution can help you close your books faster and make more confident decisions.
Exporting reports from App Store Connect is a critical step for understanding your app's performance, but it’s not always a straight path. You might find yourself staring at a permission-denied error, a file format you don’t recognize, or numbers that just don’t seem to add up. These little roadblocks can be frustrating, especially when you’re on a deadline or trying to close out your monthly financials. The good news is that you’re not alone—these are common challenges that many developers and finance teams encounter.
Fortunately, each of these problems has a straightforward solution. It usually comes down to knowing where to look and what to adjust, whether it’s a setting in your account, a free piece of software for your computer, or just a simple shift in perspective (like accounting for time zones). In this section, we’ll break down the most frequent export issues one by one. We’ll give you clear, actionable steps to resolve them quickly so you can get back to what really matters: analyzing your data and growing your business.
If you’re blocked from exporting reports, the issue often comes down to permissions. First and foremost, you must be an active member of the Apple Developer Program to access any sales or analytics data. It’s the basic entry ticket. Beyond that, your specific role within your App Store Connect team determines what you can see and do. If you can’t access a report, check with your team’s Account Holder or Admin to ensure your user role has the necessary permissions for sales, finance, or analytics. Also, make sure your app is in good standing and complies with all of Apple’s guidelines, as this can sometimes affect data access. Getting these permissions sorted out is the essential first step.
So you’ve downloaded your report, but it’s a .gz file. What now? This is just a compressed file format, similar to a ZIP file. On a Mac, a simple double-click is all it takes to decompress it. If you’re on a Windows machine, you’ll need a free tool like 7-Zip or WinRAR to extract the contents. Inside, you’ll find a tab-delimited text file (.txt). While you can open it in a basic text editor, it will look much better in a spreadsheet application. Just open Excel or Google Sheets and import the .txt file. The program will automatically organize the data into clean rows and columns, making it easy to read and analyze.
This is a small detail that can cause big headaches if you’re not aware of it. All reports generated by App Store Connect operate on Pacific Time (PT), regardless of where you or your customers are located. Each daily report covers the 24-hour period from 12:00 a.m. to 11:59 p.m. PT. If your accounting team works in New York or London, you’ll need to adjust for this difference when reconciling your financials or analyzing daily trends. Forgetting this can lead to data that seems mismatched or inaccurate. Always keep the PT standard in mind to ensure your analysis is spot-on and aligns with Apple’s reporting cycle.
As you get into the rhythm of exporting reports, you’ll quickly build up a large collection of files. To avoid a chaotic downloads folder, it’s a great idea to establish an organization system from day one. Create a main folder for all your App Store Connect exports, then use subfolders for different report types (e.g., Sales, Subscriptions). I recommend using a consistent naming convention for your files, such as "SalesReport_YYYY-MM-DD.txt." This simple habit makes it incredibly easy to find specific reports later, whether you’re doing a quarterly review or tracking performance over several years. A little organization now saves a ton of time later.
Manually downloading, decompressing, and organizing reports every week is time-consuming and leaves room for error. Why not let technology handle the repetitive work? Automation is your best friend here. By setting up an automated workflow, you can have your reports exported, formatted, and delivered exactly where you need them without lifting a finger. This is especially powerful when you’re pulling data from multiple sources, like the App Store and Google Play. Using a platform that offers seamless integrations with your existing tools can centralize all your app data, ensuring it’s always consistent, accurate, and ready for analysis. This frees you up to focus on strategy instead of data entry.
Exporting your App Store Connect data is the first step toward deeper analysis, but it also means you’re taking on the responsibility of protecting that information. Once a report leaves Apple’s secure environment and lands on your computer, its safety is in your hands. Mishandling this data can lead to inaccurate financial reporting, compliance violations, and a loss of customer trust that’s hard to win back.
Building a secure data handling process isn’t just about checking a box for compliance; it’s about creating a reliable foundation for your entire analytics strategy. When you know your data is secure and handled correctly from the moment of export, you can be more confident in the insights you draw from it. Think of these best practices as the framework that supports smarter, safer business decisions. A little planning here goes a long way in protecting your company and your users.
Not everyone on your team needs access to every piece of data. App Store Connect allows you to assign specific roles to each user, and it’s wise to use this feature to control who can export sensitive reports. The principle of least privilege is your best friend here: grant team members access only to the information they absolutely need to do their jobs. For instance, your marketing team might need Sales and Trends data, but they probably don’t need to see detailed financial payment reports.
Take a moment to review the user permissions in your App Store Connect account. Limit the Admin and Finance roles—the ones with the power to export financial data—to a small, trusted group. This simple step significantly reduces the risk of accidental data leaks or misuse and ensures your most sensitive information stays that way.
Your responsibility to protect user privacy doesn't end within your app. The data you export is subject to the same privacy laws and policies, like GDPR and CCPA. Before you even download a report, make sure you have a clear understanding of what user data it might contain and how you’re permitted to use it. Your app’s privacy policy is a promise to your users, and that promise extends to how you handle their information offline.
Always be mindful of personally identifiable information (PII) that might appear in your reports. If possible, anonymize data before sharing it for broader analysis. Consistently following privacy guidelines not only keeps you compliant but also reinforces the trust your users have placed in you. That trust is one of your most valuable assets.
Not all data in App Store Connect is created equal. It’s crucial to understand the timing and finality of different reports to avoid making decisions based on incomplete information. For example, the Sales and Trends reports provide valuable next-day estimates, but they aren’t final. The official, finalized revenue figures are found in the monthly Payments and Financial Reports.
Confusing preliminary data with final numbers can lead to major discrepancies in your accounting and forecasting. Before you build a dashboard or present to stakeholders, double-check the source of your data. Apple’s documentation clearly explains what each report contains and when the data is considered final. You can view reports directly in the developer portal to familiarize yourself with the differences.
Once you’ve downloaded a report, where does it live? Leaving sensitive financial data in a downloads folder on a shared computer is a security risk waiting to happen. You need a clear plan for storing your exported files securely. This could be an encrypted folder on a secure company server or a trusted, password-protected cloud storage service. The key is to restrict access to only authorized personnel.
Consider how you’ll use the data long-term. If you’re manually downloading reports each month, you’re also creating more files to track and secure. This is where automated solutions can help. Using a platform that offers secure data integrations can pull information directly via API, bypassing the need for manual downloads and ensuring your data is stored and processed in a controlled, secure environment from the start.
Exporting your App Store Connect reports is the first step. The real magic happens when you start analyzing that data to make smarter decisions for your business. Going beyond a surface-level glance at your numbers can help you spot growth opportunities, catch potential issues before they become major problems, and understand what truly drives your app’s success. These strategies are all about turning raw data into a clear roadmap for your business, helping you move from reacting to the market to proactively shaping your own success.
A single data point doesn't tell you much. The key to meaningful analysis is tracking your performance over time to identify patterns, seasonality, and the long-term impact of your efforts. You can view the performance of your app with next-day data from Sales and Trends reports for a quick pulse check, while Payments and Financial Reports provide the final, confirmed proceeds. Using both gives you a complete picture of your app's financial health and helps you understand if your growth is consistent or tied to specific events.
You can’t track everything, so focus on the metrics that are directly tied to your business goals. These Key Performance Indicators (KPIs) are the specific, measurable numbers that tell you if you’re on the right track. For example, if your goal is to improve user retention, your KPIs might be churn rate and daily active users. By closely monitoring your chosen key performance metrics, you can gain clear insights into how people interact with your app and make data-driven decisions that actually move the needle.
The standard reports in App Store Connect are a great starting point, but your business has unique questions that require a more tailored view. Instead of manually filtering a massive spreadsheet, you can configure your exports to focus only on the data that matters most. You can download App Store Sales and Trends reports like the Summary Sales Report or Subscription Event Report. By combining or filtering these, you can answer specific questions, making your analysis more efficient and your insights more actionable.
Manually downloading and compiling reports is time-consuming and leaves room for error. An automated reporting system solves this by pulling the data you need on a set schedule and delivering it in a consistent format. This frees you up to spend less time on data collection and more time on analysis. Automation ensures your data is always up-to-date and ready for review. You can achieve this using the App Store Connect API or by setting up integrations with your existing tools to create a single source of truth for your financial and performance data.
What’s the main difference between a Sales and Trends report and a Financial Report? Think of Sales and Trends reports as your daily check-in. They give you a quick, preliminary look at your sales from the previous day, which is great for spotting immediate trends or seeing the impact of a marketing push. Financial Reports, on the other hand, are your official, finalized monthly statements. They show the actual money you've earned after Apple has processed all transactions, taxes, and fees. For your official accounting and revenue recognition, you should always use the
I'm on the finance team, not a developer. How can I get access to these reports? You don't need to be a developer to access App Store Connect data, but you do need the right permissions. The Account Holder or an Admin on your company's Apple Developer account can grant you access. They can assign you a specific role, like "Finance," which gives you permission to view and download the financial reports you need without giving you access to the technical side of app management.
Why don't the sales numbers I see in my reports match the exact amount deposited in my bank? This is a common point of confusion, and there are a few reasons for the difference. The sales figures in your reports represent the total amount customers paid, but the final deposit you receive is the net amount after Apple deducts its commission, taxes, and any applicable fees. Your monthly Financial Report provides a detailed breakdown of these deductions, so you can see exactly how your gross sales translate into the final payment that hits your bank account.
Is it better to download reports manually or use the API for automation? This really depends on the size and needs of your business. If you only need to check your numbers once a month for bookkeeping, manual downloads are perfectly fine and straightforward. However, if you're a high-volume business that needs to integrate app data into other systems for daily analysis or complex revenue recognition, automating with the API is a much better approach. It saves a significant amount of time and reduces the risk of manual errors.
My downloaded report is a compressed file with a .gz extension. How do I open it? Don't worry, this is an easy one to solve. A .gz file is simply a compressed file, much like a ZIP file. If you're using a Mac, you can just double-click it to open it. On a Windows computer, you may need a free program like 7-Zip to extract the file inside. Once you do, you'll have a text file that you can open directly in any spreadsheet software like Excel or Google Sheets, which will organize the data into neat columns for you.
Former Root, EVP of Finance/Data at multiple FinTech startups
Jason Kyle Berwanger: An accomplished two-time entrepreneur, polyglot in finance, data & tech with 15 years of expertise. Builder, practitioner, leader—pioneering multiple ERP implementations and data solutions. Catalyst behind a 6% gross margin improvement with a sub-90-day IPO at Root insurance, powered by his vision & platform. Having held virtually every role from accountant to finance systems to finance exec, he brings a rare and noteworthy perspective in rethinking the finance tooling landscape.
Copyright © 2025 HubiFi | All rights reserved.
