Connecting Google Play to ChartMogul

You’ll need to be an Admin in ChartMogul and the Account Owner in Google Play Developer Console to complete the following steps.

Before you begin

There are four steps you’ll need to complete before connecting Google Play to ChartMogul.

1. Select an integration type

ChartMogul offers two ways to import your Google Play data: either using Google Play’s daily Sales report (no development required) or by sending your data via the payloads URL (development required in sending payloads).

Each integration type has its own advantages. Please make sure you understand how each integration type works and select the one best suited to your needs before continuing. 

Screenshot of Integration Type radio button with two choice: 1) Import my data using the daily Sales report (no development required), 2) I'll send the payloads via the payloads URL.

2. Retrieve your app’s package name

Get your Google Play app’s package name by opening your Google Play console and looking at your list of published apps. You’ll find the package name directly below the name of the app you’d like to import into ChartMogul (e.g., com.pecode.purchaseappdemo). 

Screenshot showing an example package in Google Play console

3. Set up API Access Client using a service account and download JSON Key

Next, carefully follow the steps to set up an API access client using a service account, setting the Role to Owner.

After creating the service account, click the Actions icon and click Create key. Select JSON as the Key type and click Create.

Screenshot showing selection of Key Type

After clicking Create, Google generates a JSON file that your browser should automatically download. You’ll upload this file as the Service Account JSON Key as part of connecting your Google Play account to ChartMogul below.

Finally, go back to your Google Play console’s API Access page, find the new service account you just created in the list, and click Grant Access. Then edit the Role to add the Manage orders permission.

Screenshot showing the Manage orders checkbox

4. Retrieve your Google Play Storage Bucket ID

You’ll only need to complete this step if you’ve decided to import your Google Play data using the daily Sales reports (and not by sending the payloads manually).

Here’s how to retrieve your Google Storage Bucket ID: 

  1. Go to your Google Play console and select Download Reports in the left navigation bar
  2. Find and click on your app 
  3. At the bottom of the page, find the Direct reports URI. It’ll look something like: gs://pubsite_prod_rev_01234501234567890123/reviews 
  4. Extract your Google Play Bucket ID from the Direct reports URI by removing both gs:// (from the beginning) and /reviews (from the end), e.g., pubsite_prod_rev_01234501234567890123

Connecting your Google Play account

  1. Go to the Data Platform section of ChartMogul.
  2. Under Data Sources, click on Add a Data Source.
    Add_Data_Source.png
  3. In the popup, click Google Play from the list.
  4. Enter a name and click Next

  5. Complete the Google Play data source form using the Package Name, Service Account JSON Key file, and Google Storage Bucket ID you retrieved in the Before you begin section above. Once you’ve filled out all the fields, click Connect.
  6. If you selected Import my data using the daily Sales report as the Integration Type, ChartMogul starts the import automatically.
  7. If you selected I’ll send the payloads via the payloads URL as the Integration Type, ChartMogul displays the Payloads URL between the UUID and the Connect / Re-sync Data button (see screenshot below).

    Use the Payloads URL to import new and historical Google Play purchases into ChartMogul. Read our developer tutorial on importing purchase payloads.
Was this article helpful?