How to read your reports

Report types

We offer these reports for you to track your sales on Google News:

• Transaction reports.
  The transaction report tracks single issue sales, subscriptions, no-charge trials, and refunds on a transaction-level basis. This is the most granular report.

• Summary reports.
  The summary report tracks single issue sales, subscriptions, no-charge trials, and refunds on a transaction type basis. For example, this report counts the total number of annual subscriptions for a given month in one row.

• Tax summary reports.
  This report shows the taxable amounts and total amount of tax paid per transaction.

• Subscriber count reports.
  This report counts the total number of active subscribers on a given day.

How to read your reports

Transaction report

The detailed transaction report lists each transaction (sale or refund) that occurred within the report period. It details the sale type and date, revenue share, and publisher earnings for each. These reports don't include personally identifiable information (PII) of the customers.

The transaction report is considered final the day after the month ends. If there was a refund within the last few days before the end of the month, the transaction report may not match the amount paid out. If you have additional questions about payments received, please contact your account manager.

View an explanation of each column in the report

Date	The day on which the transaction occurred.
Time	The time (in Pacific Time) when the transaction occurred.
Order ID	A unique identification number for the customer's order. This is linked to the order, rather than the customer. So, the same customer may be reflected multiple times in a single report with different order IDs. For example, if a user subscribes to a magazine, and then cancels the subscription, this will generate 2 columns in the report to reflect the two transactions. When a no-charge trial converts to a paid subscription, the transaction will have an Order ID that ends with ..0. For example: 123456789234565678..0 is the Order ID for a monthly subscription to Google's Great Magazine purchased on July 12, 2012. If you search for that Order ID without the ..0 (123456789234565678), you'll find the initial transaction when the 14 day no-charge trial began on June 28, 2012. Subsequent transactions will be appended with ..1, ..2, and so on. See the Subscription payment number column for this information without the Order ID.
Publisher Name	The name listed on your publisher account.
Publisher ID	The unique ID associated with your publisher account.
Merchant of Record	The merchant of record on the transaction.
Magazine Title	Name of the magazine the user purchased or subscribed to.
ISSN	ISSN of the magazine in the transaction.
Issue Title	If a user purchases a current or back issue, the issue title (e.g., Aug. 2012) will appear in this column. If the transaction reflects a subscription or no-charge trial, the cell in this row will be blank.
Publication Date	The on-sale date for the magazine. This column only contains data if the transaction is for a single-issue purchase.
Type	The "Type" column shows the type of transaction. New No-Charge Trial. A user has subscribed to your magazine on a monthly or annual basis. If the user doesn't cancel the subscription within the no-charge trial period, our system will generate a new row with "New Paid Subscription" in the Type column. New Paid Subscription. A user's no-charge trial has expired, and they've converted to a paid subscription. Subscription Renewal. The user has renewed his subscription. This will appear every time a user renews a monthly or annual subscription. No-Charge Trial. This means the user has canceled or reactivated their subscription during the no-charge trial period. You can see which action was performed with the Purchase Type column, which will say “CANCEL” or “REACTIVATE.” Subscription. This means the user has canceled or reactivated the subscription. You can see which action was performed with the Purchase Type column, which will say “CANCEL” or “REACTIVATE.” Current Issue. The user had purchased a copy of the most current issue in the store. Back Issue. A user has purchased a copy of one of the back issues of the magazine. You can view which issue in the Issue Title column.
Qty	The number of units purchased. It will be "0" if there was no impact to earnings due to this transaction. If a user receives a refund, it will say "-1" in this column.
Purchase Type	SALE. The user purchased a subscription or single issue. CANCEL. The user cancelled a subscription. REFUND. The user received a refund of a subscription or single issue purchase. REACTIVATE. The user undid the cancellation of their subscription, and will continue to be billed at the next renewal period.
Subscription payment number	This column reflects the number of subscription payments a user has made. For example, a user who has paid for one annual subscription will have "1" in this column. If they renew their subscription for a second year, this column will say "2."
Subscription Period	This column shows the length of the subscription. This column will have values for both no-charge trials and users who convert to paid subscriptions after the no-charge trial ends. If a user purchases a single issue, this column will be blank. ONE MONTH. The user signed up for a no-charge trial on a monthly subscription, or has purchased a monthly subscription. ONE YEAR. The user signed up for a no-charge trial on an annual subscription, or has finished the no-charge trial and purchased an annual subscription.
No-Charge Trial Period	The length of the no-charge trial for the subscription. This column will have data for both no-charge trials and paid subscriptions. You can confirm the length of your no-charge trial period in Google Play Newsstand Producer: Go to Producer using the link provided by your account manager. Choose the Distribute tab on the left-hand navigation. Click the territory in question (for example, US). Click the Pricing link, and go down to the No-charge trial length area.
Sale Price	The list price for the magazine issue or subscription in Google Play Newsstand, tax-exclusive in the US. You can confirm the prices in your account using the following steps: Go to Producer using the link provided by your account manager. Choose the Distribute tab on the left-hand navigation. Click the territory in question (for example, US). Click the Pricing link. This will have your single issue and subscription prices.
Tax Amount	The amount of tax the user paid in the transaction.
Revenue Share %	Your publisher revenue share from the sale.
Publisher Earnings	The earnings from the transaction, calculated based on the Sale Price column and the Revenue Share % column. Note: While the sale price may be non-zero, some transactions, such as "No-Charge Trial," are $0. In this case, the earnings will be $0.00.
Total Amount Paid Publisher	The total amount paid to you as the publisher. This includes earnings in the Revenue Share % column, and, depending on your agreement with Google, may also include the tax in the Tax Amount column.
Total Paid Publisher Currency	The currency of the Total Amount Paid Publisher.
Exchange Rate	Foreign exchange rate used to convert from the buyer's currency (Total Amount Paid Publisher) to the currency of the publisher's bank account. Multiply the Exchange Rate times the Total Amount Paid Publisher.
Exchange Rate Type	The type of exchange rate, whether "spot" or "final." A spot rate is taken at the time the order is placed as an estimate of the "final" exchange rate to be applied later when currency is actually exchanged.
Exchange Amount	The amount paid to publisher in the currency of the publisher's bank account, after applying the foreign Exchange Rate.
Exchange Currency	The currency of the publisher's bank account, the result of the foreign exchange conversion.

Summary report

The summary report counts the total number of transactions by type, with one type per column per month. This includes subscriptions and single issues sold and refunded/canceled, as well as the total publisher earnings. Since the counts are grouped by month, if you download a report for July and August, transaction types such as "Current Issue" will be listed twice, the 2 rows showing the 2 months' sales for the most recent magazine issue.

View an explanation of each column in the report

Publisher Name	The name listed on your publisher account.
Magazine Title	Name of the magazine the user purchased or subscribed to.
ISSN	ISSN of the magazine in the transaction.
Type	The "Type" column shows the type of transaction. New No-Charge Trial. Users who have signed up for the no-charge trial period for a magazine. If users convert to a paid subscription, this conversion will be listed in another row with the entry "New Paid Subscription." No-Charge Trial. This type reflects actions taken while the user was within the no-charge trial portion of a subscription. New Paid Subscription. This type is for a user whose no-charge trials have expired, and who has converted to a paid subscription. Subscription Renewal. This type means a user has renewed a subscription. This will appear every time a user renews a monthly or annual subscription. Subscription. This type reflects actions taken while the user was within the paid portion of a subscription. Current Issue. The user had purchased a copy of the most current issue in the store. Back Issue. A user has purchased a copy of one of the back issues of the magazine. You can view which issue in the Issue Title column.
Subscription Period	This column shows the length of the subscription. This column will have values for both no-charge trials and users who convert to paid subscriptions after the no-charge trial ends. If a user purchases a single issue, this column will be blank. ONE MONTH. The user signed up for a no-charge trial on a monthly subscription, or has purchased a monthly subscription. ONE YEAR. The user signed up for a no-charge trial on an annual subscription, or has finished the no-charge trial and purchased an annual subscription.
Publication Date	The on-sale date for the magazine. This column only has data in it if the transaction is for a single issue purchase.
Issue title	If a user purchases a current of back issue, the issue title (for example, Aug. 2012) will appear in this column. If the transaction reflects a subscription or no-charge trial, the cell in this row will be blank.
Sale Price	The list price for the magazine issue or subscription in Google Play Newsstand, tax-exclusive in the US. You can confirm the prices in your account using the following steps: Open Google Play Newsstand Producer using the link provided by your account manager. Choose the Distribute tab on the left-hand navigation. Click the territory in question (for example, US). Click the Pricing link. This will have your single issue and subscription prices.
Units Purchased	The total number of units purchased of the transaction type listed in the Type column. If the type is "Subscription," there'll be a 0 in this column.
Units Refunded	The total number of units refunded of the transaction type listed in the Type column. This includes current issues, back issues, and subscriptions. You can see which magazine issue was refunded for single issue purchases by checking the Issue Title column.
Units Canceled	The total number of units canceled of the transaction type listed in the Type column. This is for non-money items, such as no-charge trials. Users who cancel their no-charge trial before converting to a paid subscription will be marked "No-Charge Trial" in the Type column.
Units Reactivated	The total number of units reactivated after being previously canceled. These users will continue to be billed at each renewal period. Users who reactivate before their no-charge trial has expired will be marked “No-Charge Trial” in the Type column.
Net Units Sold	The net number of units sold. This is the total number of units purchased, minus refunds.
Publisher Earnings	The total amount of publisher earnings from the transaction type in that month. This can be a negative number for transaction types such as "Subscription," which reflects subscriptions that have been canceled.
Tax Amount	The total amount of tax users paid on the transactions listed in the Type column for the month in the report.
Total Amount Paid Publisher	The total amount paid to the publisher for the transaction type in the row. This will be "0" for no-charge trials, and may be a negative number if the row reflects the number of subscriptions that have been canceled.

Tax summary report

The tax summary report shows the taxable amount for each transaction, as well as the total tax amount for that sale. There is a row for each transaction.

View an explanation of each column in the report

Publisher Name	The name listed on your publisher account.
Merchant of Record	The merchant of record on the transaction.
Type	Single issue. This is for sales of back issues and the most recent issue of the magazine. Subscription. This type is for monthly and annual subscriptions.
Taxable Amount	The taxable amount of money from the transaction. This will either be zero or the full sale amount.
Tax Amount	The amount of tax the user paid on the transaction. The amount will be based on the tax table for that country.