Configuring Google Cloud Storage as a destination

You’ll need to be a Staff or Admin in ChartMogul and an Admin in Google Cloud Platform to complete the steps outlined in this article. Read more about user roles and permissions.

ChartMogul allows you to export MRR movements, customers, custom attributes, and tags to Google Cloud Storage. From there, you can send your data to a data warehouse and combine it with other datasets for further analysis.

Here’s what we cover in this article:

Resources and further reading:

Before you begin

Please review the following details before completing the steps we outline in this article.

Step 1 — Create a Cloud Storage service account

First, create a service account that will have permission to access the bucket. After creating the service account, you’ll download the account’s private key as a JSON file, which you’ll need as part of creating the destination in ChartMogul.

  1. Within Google Cloud Platform, navigate to IAM and Admin > Service Accounts.
  2. Click + Create Service Account.
  3. Enter a name for the service account, e.g., ChartMogul, in the Service account name field, then click Done .
  4. Once Google has created the account, find it in the Service accounts table, click the vertical ellipse Actions icon, and select Manage keys. Next, click Add Key > Create a new key.
  5. With JSON selected as the Key type, click Create. Your browser should then download the private key as a JSON file.

Step 2 — Create a Cloud Storage bucket for ChartMogul

Next, create a new Cloud Storage bucket:

  1. Within Google Cloud Platform, navigate to Cloud Storage and click + CREATE BUCKET.
  2. Name your bucket and click Continue.
  3. Choose where you’d like to store your data by selecting Region as the Location Type and a region from the Location drop-down, then click Continue.
  4. Complete any additional setup options you may need, then click Create.

Step 3 — Assign permissions to the bucket

  1. Click Choose how to protect object data.
  2. Click the Permissions tab.
  3. Click + Add.
  4. In the New principals field, enter the email address associated with the Service Account you created in the previous step.
  5. Select Storage Object Admin from the Role drop-down.
  6. Click Save.

Step 4 — Add Google Cloud Storage as a destination

Finally, add your Google Cloud Storage as a destination in ChartMogul.

  1. Within ChartMogul, navigate to Data & Config > Destinations.
  2. Click Add Destination and select Google Cloud Storage.
  3. Enter a unique name for your destination in the Name field.
  4. Choose how often you’d like ChartMogul to export data to your bucket, either:
    • Daily (9:00 UTC each day)
    • Weekly (9:00 UTC each Sunday), or
    • Monthly (9:00 UTC on the first day of each month)
  5. Choose the datasets you'd like to export: Screenshot of the Add a Destination dialog with some of Datasets selected.
  6. Choose the file type you'd like to export, either:
    • Parquet or
    • CSV
  7. Enter the name of your bucket as it appears on your Google Cloud Storage account in the Bucket Name field.
  8. Upload the service account’s private key JSON file your browser downloaded in Step 1.
  9. Click Save and Test Connection.

ChartMogul will perform a test connection and, if successful, add your Cloud Storage bucket as a new destination.

Was this article helpful?

We’re sorry to hear that. Would you like to share more feedback?

Thanks for your feedback!