Introduction

Datasources and destinations

Fields listing for Google Play Store

Package Name
Developer-specified name of the product. Displayed in the buyer's locale.
Field IDpackageTitle
TypeTEXT
Data Typedimension
Package Id
The Package Name of the application
Field IDpackageId
TypeTEXT
Data Typedimension
Tax Type
Blank for non-tax lines.
Field IDtaxType
TypeTEXT
Data Typedimension
Transaction Type
Charge, Google fee, Tax, Charge refund, Google fee refund, Charge rebill, Tax rebill, Google fee rebill, Adjustment.
Field IDtransactionType
TypeTEXT
Data Typedimension
Refund Type
Full, Partial. Refunds where the buyer was reimbursed their full spend will be marked as 'Full'. Refunds for part of a user’s payment amount will be marked as 'Partial'.
Field IDrefundType
TypeTEXT
Data Typedimension
SKU Id
Developer-specified unique ID of the product.
Field IDskuId
TypeTEXT
Data Typedimension
Currency
USD, EUR, THB, and so on.
Field IDcurrency
TypeTEXT
Data Typedimension
Hardware
Android device model used to make the purchase. For subscription orders, this refers to the model used for the original purchase.
Field IDhardware
TypeTEXT
Data Typedimension
Item Price
Shown in the buyer's local currency. With “,” as a thousands separator.
Field IDitemPrice
TypeNUMBER
Data Typemetric
Tax
In the buyer's local currency. With “,” as a thousands separator.
Field IDtaxCollected
TypeNUMBER
Data Typemetric
Amount
In the buyer's local currency. This is the sum of the item price and taxes collected. With “,” as a thousands separator.
Field IDamount
TypeNUMBER
Data Typemetric
City
City of the auction
Field IDcity
TypeTEXT
Data Typedimension
State
State of the auction
Field IDstate
TypeTEXT
Data Typedimension
Post Code
Post Code of the auction
Field IDpostCode
TypeTEXT
Data Typedimension
Country
Country of the auction
Field IDcountry
TypeTEXT
Data Typedimension
Group Id
GroupId of the auction
Field IDgroupId
TypeTEXT
Data Typedimension
Promotion Id
Only populated for sales related to Play Points. Prefixes “PP.C” and “PP.P” define orders involving coupons and in-app product promotions respectively. Orders where play points are spent directly are also shown.
Field IDpromotionId
TypeTEXT
Data Typedimension
Coupon Value
Shown in the buyer’s local currency. With “,” as a thousands separator. Only populated for sales related to Play Points coupons.
Field IDcouponValue
TypeNUMBER
Data Typedimension
Current Device Installs
Current Device Installs
Field IDcurrentDeviceInstalls
TypeNUMBER
Data Typemetric
Installs on active devices
Installs on active devices
Field IDinstallOnActiveDevices
TypeNUMBER
Data Typemetric
Install Events
Install Events
Field IDinstallEvents
TypeNUMBER
Data Typemetric
Update Events
Update Events
Field IDupdateEvents
TypeNUMBER
Data Typemetric
Uninstall Events
Uninstall Events
Field IDuninstallEvents
TypeNUMBER
Data Typemetric
Daily Device Installs
Daily Device Installs
Field IDdailyDeviceInstalls
TypeNUMBER
Data Typemetric
Daily Device Uninstalls
Daily Device Uninstalls
Field IDdailyDeviceUninstalls
TypeNUMBER
Data Typemetric
Daily Device Upgrades
Daily Device Upgrades
Field IDdailyDeviceUpgrades
TypeNUMBER
Data Typemetric
Current User Installs
Current User Installs
Field IDcurrentUserInstalls
TypeNUMBER
Data Typemetric
Total User Installs
Total User Installs
Field IDtotalUserInstalls
TypeNUMBER
Data Typemetric
Daily User Installs
Daily User Installs
Field IDdailyUserInstalls
TypeNUMBER
Data Typemetric
Daily User Uninstalls
Daily User Uninstalls
Field IDdailyUserUninstalls
TypeNUMBER
Data Typemetric
Daily Crashes
Daily Crashes
Field IDdailyCrashes
TypeNUMBER
Data Typemetric
Daily ANRs
Daily ANRs
Field IDdailyANRs
TypeNUMBER
Data Typemetric
Daily Average Rating
Daily Average Rating
Field IDdailyAverageRating
TypeNUMBER
Data Typemetric
Total Average Rating
Total Average Rating
Field IDtotalAverageRating
TypeNUMBER
Data Typemetric
New Subscriptions
New Subscriptions
Field IDnewSubscriptions
TypeNUMBER
Data Typemetric
Canceled Subscriptions
Canceled Subscriptions
Field IDcanceledSubscriptions
TypeNUMBER
Data Typemetric
Active Subscriptions
Active Subscriptions
Field IDactiveSubscriptions
TypeNUMBER
Data Typemetric
Discount Rate
% discount rate used to specify the saving made by the user by spending Play Points compared to spending money. Only populated for sales related to Play Points.
Field IDdiscountRate
TypePERCENT
Data Typemetric
Order Number
Subscription order IDs include the renewal cycle number at the end (for example, the first renewal is GPA.1234-1234-1234-12345..0, second renewal is GPA.1234-1234-1234-12345..1, and so on).
Field IDorderNumber
TypeTEXT
Data Typedimension
Earning ID
Subscription order IDs include the renewal cycle number at the end (for example, the first renewal is GPA.1234-1234-1234-12345..0, second renewal is GPA.1234-1234-1234-12345..1, and so on).
Field IDearningId
TypeTEXT
Data Typedimension
Traffic Source
How the user got to your store listing:Google Play searchThird-party referralsGoogle Play exploreNote: Can be Other if this value does not reach certain minimum thresholds
Field IDtrafficSource
TypeTEXT
Data Typedimension
Search Term
The term the user searched for before navigating to your store listing. Only available for Google Play search. Note: Can be Other if this value does not reach certain minimum thresholds. Must be used with Traffic Source to work.
Field IDsearchTerm
TypeTEXT
Data Typedimension
UTM Source
The value of the utm_source URL parameter in deep links to your store listing. Only available for third-party referralsNote: Can be Other if this value does not reach certain minimum thresholds
Field IDutmSource
TypeTEXT
Data Typedimension
UTM campaign
The value of the utm_campaign URL parameter in deep links to your store listing. Only available for third-party referrals.Note: Can be Other if this value does not reach certain minimum thresholds
Field IDutmCampaign
TypeTEXT
Data Typedimension
Store listing acquisitions
The number of users who visited your store listing and installed your app, who didn’t have it installed on any other devices at the time
Field IDstoreListingAcquisition
TypeNUMBER
Data Typemetric
Store listing visitors
The number of users who visited your store listing who didn’t already have your app installed on any of their devices
Field IDstoreListingVisitors
TypeNUMBER
Data Typemetric
Store listing conversion rate
The percentage of store listing visitors who installed your app Note: Does not include visits or installs from users who already have your app installed on another device
Field IDstoreListingConversionRate
TypePERCENT
Data Typemetric
Financial Status
charged, refund, partial refund, and so on.If you fully refund an order after issuing a partial refund: The partial refund appears on a separate line. The full refund line shows the remaining balance
Field IDfinancialStatus
TypeTEXT
Data Typedimension
Device
Android device model used.
Field IDdeviceModel
TypeTEXT
Data Typedimension
App Version Code
App Version Code used
Field IDappVersionCode
TypeTEXT
Data Typedimension
Carrier
Carrier
Field IDcarrier
TypeTEXT
Data Typedimension
Language
Language
Field IDlanguage
TypeTEXT
Data Typedimension
Android OS Version
Android OS Version
Field IDosVersion
TypeTEXT
Data Typedimension
Offer ID
The offer ID of the subscription. Only populated for subscriptions.
Field IDofferId
TypeTEXT
Data Typedimension
Base Plan ID
The base plan ID of the subscription. Only populated for subscriptions.
Field IDbasePlanId
TypeTEXT
Data Typedimension
Reviewer Language
The reviewer's language.
Field IDreviewerLanguage
TypeTEXT
Data Typedimension
Review Last Update
The date and time of the last update to the review.
Field IDreviewLastUpdate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Review Star Rating
Star Rating
Field IDstarRating
TypeNUMBER
Data Typemetric
Review Title
Review Title
Field IDreviewTitle
TypeTEXT
Data Typedimension
Review Text
Review Text
Field IDreviewText
TypeTEXT
Data Typedimension
Developer Reply Date
Developer Reply Date
Field IDdeveloperReplyDate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Developer Reply Text
Developer Reply Text
Field IDdeveloperReplyText
TypeTEXT
Data Typedimension
Review Link
Review Link
Field IDreviewLink
TypeTEXT
Data Typedimension
Review Submit Date and Time
Review Submit Date and Time
Field IDreviewSubmitDate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
TypeYEAR
Data Typedimension
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
TypeYEAR_QUARTER
Data Typedimension
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
TypeYEAR_MONTH
Data Typedimension
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
TypeYEAR_WEEK
Data Typedimension
Date
Year, month, and day.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
TypeYEAR_MONTH_DAY
Data Typedimension
Year month day hour
Year, month, day, and hour.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
TypeQUARTER
Data Typedimension
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
TypeMONTH
Data Typedimension
Week of the year
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK
TypeWEEK
Data Typedimension
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
TypeMONTH_DAY
Data Typedimension
Day of the week
Week of the year
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
TypeDAY_OF_WEEK
Data Typedimension
Day of the month
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
TypeDAY
Data Typedimension
Extracted Date
The date where the extraction take times.
Field ID_catchr_date_extract
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Platform Name
Return the platform name
Field ID_catchr_platform_name
TypeTEXT
Data Typedimension