使用gsutil下载Google Play报告后，如何定位Android应用年度订阅续费？

Hey there, let's tackle your questions about identifying annual subscription renewals in the reports you download via gsutil from Google Cloud, plus clarify how they differ from other charges and where they land in subscription reports.

1. Can we precisely locate annual subscription renewal transactions in Play Apps or Sales Reports? #

Absolutely, but the level of precision depends on which report you use:

• Sales Reports (the most granular option): These include line-item details for every transaction. To pinpoint annual renewals, filter for:
  • transaction_type = RENEWAL (marks this as an automatic renewal of an existing subscription)
  • Combine with either subscription_period = P1Y (the ISO 8601 code for a 1-year term) or your specific annual subscription product_id (assuming you created a unique SKU for annual plans, which is best practice)
• Play Apps Financial Reports: These are aggregated summaries per app, so they won't let you drill down to individual renewal transactions. If you need precise, transaction-level data, stick to the Sales Reports.

2. Are annual renewal transactions different from regular charges? #

Yes, they differ in several key ways, depending on what you mean by "regular charges":

• Vs. one-time purchases: One-time purchases have a transaction_type = PURCHASE and no associated subscription lifecycle. Annual renewals are tied to an ongoing subscription (marked by a unique subscription_id) and repeat at the 1-year interval until the user cancels.
• Vs. monthly subscription renewals: The core difference lies in the subscription_period (P1Y vs. P1M) and typically the product_id (if you use separate SKUs for monthly/annual plans). You'll also see distinct amounts corresponding to your annual subscription pricing.

3. Will annual renewals be listed as "New subscriptions" in the Subscription Report? #

No, they won't. The "New subscriptions" category in Google Play's Subscription Reports strictly refers to first-time purchases of a subscription SKU (when a user signs up for your annual plan for the very first time).

Annual renewals (auto-renewals of an existing annual subscription) fall under the "Renewals" or "Auto-renewals" category in the report. The only time an annual subscription would count as "New" is if a user cancels their existing annual plan and signs up again later—that's treated as a new subscription, not a renewal.

Pro tip: When working with the CSV reports downloaded via gsutil, you can use tools like Excel, Google Sheets, or even command-line utilities like awk or csvkit to quickly filter for the fields mentioned above and isolate the annual renewal transactions you need.

内容的提问来源于stack exchange，提问作者MikePFromE