Exporting customers and metrics to Google Sheets

This article explains how to export your ChartMogul customers and metrics to a Google sheet using the ChartMogul Google Sheets app.

export_googlesheet.png

Contents

  1. Installing the Google Sheets app
  2. Exporting customers
  3. Exporting metrics 

Installing the Google Sheets app

Open a Google Sheet and select Add-ons from the menu. Select Get Add-ons... and search for ChartMogul in the Google Sheets Add-ons store.

Alternatively, go directly to the ChartMogul Google Sheets app, and click Install.

mceclip0.png

 

Input your ChartMogul API Keys

Once you have installed the ChartMogul Google Sheets app, navigate to a Google Sheet, select ChartMogul > Open app, and add your ChartMogul API Keys.

Navigate to https://app.chartmogul.com/#admin/api. Copy and paste both your ChartMogul API Token and Secret Key into the app's input fields. Finally, click Save keys. You will now be able to export your ChartMogul data to a Google Sheet.

Exporting customers

Once you have installed the ChartMogul Google Sheets app, you can export your customers to a Google Sheet by clicking Metrics > Import ChartMogul customers.

 

The export will contain data and metrics for all of your customers, including customer attributes and tags. 

Once your export completes, you will be notified in the Google Sheets app.

Note: a customer's export can take some time. Please leave the Google Sheet open while your customers are being exported.

Export metrics

Once you have installed the ChartMogul Google Sheets app, you can export your ChartMogul metrics to a Google Sheet by following these steps:

  1. Click Metrics.
  2. In the input fields below Import metrics, enter the period start and end dates you would like the metrics to cover. Dates must be in this format: YYYY-MM-DD. E.g., 2015-02-28 and 2016-02-28.
  3. Next, select the metric you would like to export and the time interval.
  4. Finally, click Import metrics.

The data export can take some time. Closing the app or the Google Sheet will cancel the export.

If you have data in your sheet that you've already sent to ChartMogul, clicking Send to ChartMogul with these data still in the sheet will create duplicates in ChartMogul. We highly recommend using a new tab in Google Sheets to import new data. 

Was this article helpful?