Export data

The keyword monitor, the rankings view, the competitor list and the comparison matrix on the competitors page, the reviews list and the search results sheet each export a CSV file that follows the filters you have applied. <date> in a file name is the UTC day of the export. The app overview and the rankings view also print as a report, which is the quickest way to share a view with someone who has no account.

​

Export keywords to CSV

The export writes one row per tracked keyword, named keywords-<appId>-<date>.csv. added is the UTC day the app started tracking the keyword, and competitorsInTop10 is empty when the table shows a dash. The floor columns are explained in What is a floor answer?. The provenance columns travel with the scores on purpose. A spreadsheet that carries formulaVersion and confidence can still be audited months later, while one that carries only a number cannot. The file can be imported again: the keyword, country, tags and note columns are read and the rest are ignored. See Import keywords from a CSV file. The scoreComparability column repeats, on every row, that App Store and Google Play scores use different public signals and are not directly comparable. That caveat is easy to lose once data leaves the product, so it is written into the file. See App Store and Google Play. position is formatted the same way the table shows it, so an unranked keyword exports as >200 rather than as an empty cell or a zero. See Positions and rank depth.

​

Export rankings to CSV

The rankings view exports the charted window as one row per date and one column per keyword, named rankings-<appId>-<from>-<to>-<date>.csv, where <from> and <to> are the first and last day of the window.

​

Export competitors to CSV

The competitors page exports one row per tracked competitor from its latest snapshot, named competitors-<appId>-<date>.csv. Your own app is not in the file. A column the store does not publish stays empty: subtitle on Google Play, summary and installs on the App Store. See App Store and Google Play.

​

Export the keyword comparison to CSV

The comparison matrix exports the rows it shows, in the order shown, after the search, the market filter and the result filter. The file is named keyword-comparison-<appId>-<date>.csv, or keyword-gaps-<appId>-<date>.csv when only gaps is on, and then it holds the gap rows alone. The file always ends with country, like the keyword export, whether the matrix shows one market or several. Positions are written the way the matrix shows them: an app that does not rank exports as >200, and an app with no check yet exports an empty cell. Two competitors with the same name get (2), (3) after the name so every column header stays unique, and a competitor without a name is headed Competitor. What winning, losing, tied and a gap mean is explained in Read the comparison matrix.

​

Export reviews to CSV

The reviews list exports up to 200 reviews that match the star, version, period and reply state filters, in the order the page shows them, newest or lowest first, and keeps only the reviews the search matches, named reviews-<appId>-<date>.csv. The reviews endpoint returns at most 200 reviews in one request and does not page, so older reviews are not in the file. When more reviews match the filters than the file holds, a notice after the download says how many it holds. With a search, the file holds the reviews that match it among the ones loaded, up to 200, and the notice says how many it found, how many were searched and how many match the filters in all, because a search cannot reach reviews that did not load. Narrow the filters to reach a different set, for example one version at a time.

​

Export a SERP snapshot to CSV

The search results sheet on the keyword monitor exports the day it shows, one row per result, named serp-<appId>-<keywordId>-<captured>-<date>.csv, where <captured> is the day the snapshot was taken. ratings stays empty for Google Play keywords, whose search results carry no rating counts. See Search results for what the sheet shows. See App Store and Google Play.

​

Print a report or save it as PDF

The app overview and the rankings view print as a report. Select Print report, on the overview next to the snapshot facts and on the rankings view next to Export CSV, or use the browser’s print command. To get a file, choose Save as PDF as the destination. The printout leaves out the navigation, the header controls, banners and notifications, and every button. The keywords charted on the rankings view print as a row of labels with their colours. It opens with the app name, its store and home storefront, the page, each range the charts show, and the UTC date it was printed. Range pickers print as the range they are set to, so set them before you print. Charts keep the shape they had on screen and shrink to fit the paper, so a chart drawn across a wide window prints with smaller text. For larger chart text, print the overview in landscape or from a narrower window. Grade colours, badges and chart legends print even with background graphics turned off. Other pages print without the navigation and in the light theme, but without a report layout.

​

Save a chart as an image

The rankings chart and the position history of a keyword copy to the clipboard or download as a PNG. See Share a chart as an image.

​

Are the files safe to open?

Yes. Every field that begins with =, +, -, @, a tab or a carriage return is prefixed with an apostrophe before it is written, so a spreadsheet treats it as text rather than as a formula. Fields containing quotes, commas or newlines are quoted and escaped, and the file carries a byte order mark so spreadsheets read it as UTF-8.

​

Use the API instead

For anything scripted, read the API rather than parsing an export. It returns typed JSON and it does not depend on which filters happened to be applied in a browser. See asobeast API.

​

Related