Endash: Data Templates
  • Data model templates
    • Ad Reporting: Ad Group Report
    • Ad Reporting: Account Report
    • Ad Reporting: Ad Report
    • Ad Reporting: Campaign Report
    • Ad Reporting: Keyword Report
    • Ad Reporting: Search Report
    • Ad Reporting: Url Report
    • Amazon Ads: Account Report
    • Amazon Ads: Ad Group Report
    • Amazon Ads: Ad Report
    • Amazon Ads: Campaign Report
    • Amazon Ads: Keyword Report
    • Amazon Ads: Portfolio Report
    • Amazon Ads: Search Report
    • Amplitude: Daily Performance
    • Amplitude: Event Enhanced
    • Amplitude: Sessions
    • Amplitude: User Enhanced
    • Apple Search Ads: Ad Group Report
    • Apple Search Ads: Ad Report
    • Apple Search Ads: Campaign Report
    • Apple Search Ads: Keyword Report
    • Apple Search Ads: Organization Report
    • Apple Search Ads: Search Term Report
    • Apple Store: App Version Report
    • Apple Store: Device Report
    • Apple Store: Overview Report
    • Apple Store: Platform Version Report
    • Apple Store: Source Type Report
    • Apple Store: Territory Report
    • Asana: Daily Metrics
    • Asana: Project
    • Asana: Tag
    • Asana: Task
    • Asana: Team
    • Asana: User
    • Facebook Ads: Account Report
    • Facebook Ads: Ad Report
    • Facebook Ads: Campaign Report
    • Facebook Ads: Ad Set Report
    • Facebook Ads: Url Report
    • Facebook Ads: Url Tags
    • Facebook Pages: Pages Report
    • Facebook Pages: Posts Report
    • Github: Daily Metrics
    • Github: Issues
    • Github: Monthly Metrics
    • Github: Pull Requests
    • Github: Quarterly Metrics
    • Github: Weekly Metrics
    • Google Ads: Account Report
    • Google Ads: Ad Group Report
    • Google Ads: Ad Report
    • Google Ads: Campaign Report
    • Google Ads: Keyword Report
    • Google Ads: Url Report
    • Google Play: App Version Report
    • Google Play: Country Report
    • Google Play: Device Report
    • Google Play: Os Version Report
    • Google Play: Overview Report
    • Greenhouse: Application Enhanced
    • Greenhouse: Application History
    • Greenhouse: Interview Enhanced
    • Greenhouse: Interview Scorecard Detail
    • Greenhouse: Job Enhanced
    • Hubspot: Companies
    • Hubspot: Company History
    • Hubspot: Contact History
    • Hubspot: Contact Lists
    • Hubspot: Contacts
    • Hubspot: Deal History
    • Hubspot: Deal Stages
    • Hubspot: Deals
    • Hubspot: Email Campaigns
    • Hubspot: Email Event Bounce
    • Hubspot: Email Event Clicks
    • Hubspot: Email Event Deferred
    • Hubspot: Email Event Delivered
    • Hubspot: Email Event Forward
    • Hubspot: Email Event Dropped
    • Hubspot: Email Event Opens
    • Hubspot: Email Event Print
    • Hubspot: Email Event Sent
    • Hubspot: Email Event Spam Report
    • Hubspot: Email Event Status Change
    • Hubspot: Email Sends
    • Hubspot: Engagement Calls
    • Hubspot: Engagement Emails
    • Hubspot: Engagement Meetings
    • Hubspot: Engagement Tasks
    • Hubspot: Engagement Notes
    • Hubspot: Engagements
    • Instagram Business: Posts
    • Intercom: Admin Metrics
    • Intercom: Company Enhanced
    • Intercom: Company Metrics
    • Intercom: Contact Enhanced
    • Intercom: Conversation Enhanced
    • Intercom: Conversation Metrics
    • Iterable: Campaigns
    • Iterable: List User History
    • Iterable: Events
    • Iterable: User Campaign
    • Iterable: User Unsubscriptions
    • Iterable: Users
    • Jira: Daily Issue Field History
    • Jira: Issue Enhanced
    • Jira: Project Enhanced
    • Jira: User Enhanced
    • Klaviyo: Campaigns
    • Klaviyo: Events
    • Klaviyo: Flows
    • Klaviyo: Person Campaign Flow
    • Klaviyo: Persons
    • Lever: Interview Enhanced
    • Lever: Opportunity Enhanced
    • Lever: Opportunity Stage History
    • Lever: Posting Enhanced
    • Lever: Requisition Enhanced
    • Linkedin Ads: Account Report
    • Linkedin Ads: Campaign Group Report
    • Linkedin Ads: Campaign Report
    • Linkedin Ads: Creative Report
    • Linkedin Ads: Url Report
    • Linkedin Pages: Posts
    • Mailchimp: Automation Activities
    • Mailchimp: Automation Emails
    • Mailchimp: Automations
    • Mailchimp: Campaign Activities
    • Mailchimp: Campaign Recipients
    • Mailchimp: Campaigns
    • Mailchimp: Lists
    • Mailchimp: Members
    • Mailchimp: Segments
    • Marketo: Calendar Spine
    • Marketo: Campaigns
    • Marketo: Change Data Details
    • Marketo: Change Data Pivot
    • Marketo: Email Sends
    • Marketo: Change Data Scd
    • Marketo: Email Templates
    • Marketo: Lead Calendar Spine
    • Marketo: Lead History
    • Marketo: Leads
    • Marketo: Programs
    • Microsoft Ads: Account Report
    • Microsoft Ads: Ad Group Report
    • Microsoft Ads: Ad Report
    • Microsoft Ads: Campaign Report
    • Microsoft Ads: Keyword Report
    • Microsoft Ads: Search Report
    • Microsoft Ads: Url Report
    • Pardot: Campaigns
    • Pardot: Lists
    • Pardot: Opportunities
    • Pardot: Prospects
    • Pendo: Account Daily Metrics
    • Pendo: Account
    • Pendo: Feature Daily Metrics
    • Pendo: Feature Event
    • Pendo: Feature
    • Pendo: Guide Daily Metrics
    • Pendo: Guide Event
    • Pendo: Guide
    • Pendo: Page Daily Metrics
    • Pendo: Page Event
    • Pendo: Page
    • Pendo: Visitor Daily Metrics
    • Pendo: Visitor Feature
    • Pendo: Visitor
    • Pinterest Ads: Ad Group Report
    • Pinterest Ads: Advertiser Report
    • Pinterest Ads: Campaign Report
    • Pinterest Ads: Keyword Report
    • Pinterest Ads: Pin Promotion Report
    • Pinterest Ads: Url Report
    • Qualtrics: Contact
    • Qualtrics: Daily Breakdown
    • Qualtrics: Directory
    • Qualtrics: Distribution
    • Qualtrics: Response
    • Qualtrics: Survey
    • Quickbooks: Ap Ar Enhanced
    • Quickbooks: Cash Flow Statement
    • Quickbooks: Expenses Sales Enhanced
    • Quickbooks: General Ledger By Period
    • Quickbooks: General Ledger
    • Quickbooks: Profit And Loss
    • Recharge: Billing History
    • Recharge: Charge Line Item History
    • Recharge: Customer Daily Rollup
    • Recharge: Customer Details
    • Recharge: Monthly Recurring Revenue
    • Recharge: Subscription Overview
    • Recurly: Account Daily Overview
    • Recurly: Account Overview
    • Recurly: Balance Transactions
    • Recurly: Churn Analysis
    • Recurly: Monthly Recurring Revenue
    • Recurly: Subscription Overview
    • Reddit Ads: Account Report
    • Reddit Ads: Ad Group Report
    • Reddit Ads: Ad Report
    • Reddit Ads: Campaign Report
    • Reddit Ads: Url Report
    • Sage Intacct: Ap Ar Enhanced
    • Sage Intacct: Balance Sheet
    • Sage Intacct: General Ledger
    • Sage Intacct: General Ledger By Period
    • Sage Intacct: Profit And Loss
    • Salesforce: Account Daily History
    • Salesforce: Contact Daily History
    • Salesforce: Contact Enhanced
    • Salesforce: Daily Activity
    • Salesforce: Manager Performance
    • Salesforce: Opportunity Daily History
    • Salesforce: Opportunity Enhanced
    • Salesforce: Opportunity Line Item Enhanced
    • Salesforce: Owner Performance
    • Salesforce: Sales Snapshot
    • Shopify: Customer Cohorts
    • Shopify: Customer Email Cohorts
    • Shopify: Customer Emails
    • Shopify: Customers
    • Shopify: Daily Shop
    • Shopify: Discounts
    • Shopify: Inventory Levels
    • Shopify: Order Lines
    • Shopify: Orders
    • Shopify: Products
    • Shopify: Transactions
    • Snapchat Ads: Account Report
    • Snapchat Ads: Ad Report
    • Snapchat Ads: Ad Squad Report
    • Snapchat Ads: Campaign Report
    • Snapchat Ads: Url Report
    • Social Media Reporting: Rollup Report
    • Stripe: Activity Itemized 2
    • Stripe: Balance Change From Activity Itemized 3
    • Stripe: Balance Transactions
    • Stripe: Customer Overview
    • Stripe: Daily Overview
    • Stripe: Ending Balance Reconciliation Itemized 4
    • Stripe: Invoice Details
    • Stripe: Invoice Line Item Details
    • Stripe: Payout Itemized 3
    • Stripe: Subscription Details
    • Tiktok Ads: Ad Group Report
    • Tiktok Ads: Ad Report
    • Tiktok Ads: Advertiser Report
    • Tiktok Ads: Campaign Report
    • Tiktok Ads: Url Report
    • Twilio: Account Overview
    • Twilio: Message Enhanced
    • Twilio: Number Overview
    • Twitter Ads: Account Report
    • Twitter Ads: Campaign Report
    • Twitter Ads: Keyword Report
    • Twitter Ads: Line Item Report
    • Twitter Ads: Promoted Tweet Report
    • Twitter Ads: Url Report
    • Twitter Organic: Tweets
    • Xero: Balance Sheet Report
    • Xero: General Ledger
    • Xero: Invoice Line Items
    • Xero: Profit And Loss Report
    • Youtube: Age Demographics Pivot
    • Youtube: Demographics Report
    • Youtube: Gender Demographics Pivot
    • Youtube: Video Metadata
    • Youtube: Video Report
    • Zendesk: Sla Policies
    • Zendesk: Ticket Backlog
    • Zendesk: Ticket Enriched
    • Zendesk: Ticket Field History
    • Zendesk: Ticket Metrics
    • Zendesk: Ticket Summary
    • Zuora: Account Daily Overview
    • Zuora: Account Overview
    • Zuora: Billing History
    • Zuora: Line Item History
    • Zuora: Monthly Recurring Revenue
    • Zuora: Subscription Overview
  • 🏡Other guides
    • Endash: Main guide
    • Endash: Export to Google Sheets
    • Endash: Connectors guide
Powered by GitBook
On this page
  • Description
  • Supported Data Sources
  • Columns

Was this helpful?

  1. Data model templates

Google Play: Country Report

Last updated 1 year ago

Was this helpful?

Description

  • Daily report on installs, ratings, and store performance by app and user country. Records with NULL countries (ie did not consent to being tracked) are aggregated together into daily batches.

Supported Data Sources

  • Google Play

Columns

Type
Name
Description

DATE

date_day

The date on which the data is reported.

STRING

country_short

Two-letter abbreviation of the country where the user’s Google account is registered.

STRING

country_long

Full name of the country.

STRING

region

Geographical region of the country.

STRING

sub_region

Geographical subregion of the country.

STRING

package_name

The package name of the app owning the report data.

INTEGER

device_installs

Devices on which users installed your app on this day. An individual user can have multiple device installs.

INTEGER

device_uninstalls

The number of devices from which users uninstalled your app on a given day.

INTEGER

device_upgrades

The number of devices from which users upgraded your app on a given day.

INTEGER

user_installs

The number of users who installed your app and did not have it installed on any other devices at the time on a given day.

INTEGER

user_uninstalls

The number of users who uninstalled your app from all of their devices on this day.

INTEGER

install_events

The number of times your app was installed, including devices on which the app had been installed previously. This does not include pre-installs or device reactivations.

INTEGER

uninstall_events

The number of times your app was uninstalled. This does not include inactive devices.

INTEGER

update_events

The number of times your app was updated.

INTEGER

store_listing_acquisitions

The number of users that visited your store listing and installed your app, who did not have your app installed on any device.

INTEGER

store_listing_visitors

The number of users that visited your store listing who did not have your app installed on any device.

DECIMAL

store_listing_conversion_rate

The percentage of store listing visitors who installed your app on a given day.Note: Does not include visits or installs from users who already have your app installed on another device

INTEGER

active_devices_last_30_days

The number of active devices on which your app is installed. An active device is one that has been turned on at least once in the past 30 days.

DECIMAL

average_rating

Average star rating this app has received across all ratings submitted on a given day.

DECIMAL

rolling_total_average_rating

Average star rating this app received across all ratings submitted up to and including the past day. For each user submitting a rating, only their most recent rating of the app is counted.

INTEGER

total_device_installs

Cumulative number of device installs up to and including this day (aggregated on the dimension of this table). This does not take uninstalls into account and may contain duplicate devices.

INTEGER

total_device_uninstalls

Cumulative number of device uninstalls up to and including this day (aggregated on the dimension of this table). This does not take re-installs into account and may contain duplicate devices.

INTEGER

total_store_acquisitions

Cumulative number of users that visited your store listing and installed your app, who did not have your app installed on any device prior to this.

INTEGER

total_store_visitors

Cumulative number of users that visited your store listing who did not have your app installed on any device at the time.

INTEGER

rolling_store_conversion_rate

Rolling percentage of store listing visitors who installed your app within a given country. The ratio of total_store_acquisitions to total_store_visitors.

INTEGER

net_device_installs

Cumulative net number of device installs up to and including this day (aggregated on the dimension of this table). This is the difference of total_device_installs and total_device_uninstalls.