Atlassian Marketplace Connector for Google Data Studio

⚠️ DEPRECATED Fetching export data directly from the Atlassian Marketplace API is generally quite slow. As a result Data Studio reports that fetch data using this connector load fairly slow. In an effort to try to fix this we are deprecating this connector in favor of a new Google Sheets connector: https://github.com/toolsplus/atlassian-marketplace-sheets-connector. The Google Sheets connector allows you to load Marketplace data into a Google Sheet which can then be imported into Data Studio using the Data Studio native Google Sheet connector.

Bring your Atlassian Marketplace data to Google Data Studio and create reports and charts to visualize your sales performance, licensing data or, conversion events.

🗄️️ Available datasets:

Get started

Build and deploy the connector to App Script

Clone the repository and install dependencies.

 git clone https://github.com/toolsplus/atlassian-marketplace-data-studio-connector
 cd atlassian-marketplace-data-studio-connector
 npm install

Enable the Google Apps Script API: https://script.google.com/home/usersettings
Log in to Google clasp and authorize using your Google account.
```
 npx clasp login
```

Create a new Google Script in your Google Drive.

 npx clasp create --type standalone --title "Atlassian Marketplace Data Studio Connector" --rootDir ./dist

Deploy the project (production or development build).

 // Production build
 npm run deploy:prod
 
 // Development build
 npm run deploy

Deploy the Atlassian Marketplace connector to Data Studio

Go to scripts.google.com and open the Atlassian Marketplace Data Studio Connector project.
In the App Script editor click Publish > Deploy from manifest...
Click on the Head version, and you will see a URL showing up. Click on the URL which will bring you directly to Data Studio.

You can also find instructions for these steps in the Data Studio documentation.

Setting up the connector

Follow the instructions in Data Studio to set up the Atlassian Marketplace connector. When you are asked for credentials enter the following:

Username is the email address that you are using with your Atlassian account.

Password is an API token which you can generate at https://id.atlassian.com/manage/api-tokens. Refer to the Atlassian documentation for further details on how to generate API tokens.

When you are asked for your Vendor ID go to https://marketplace.atlassian.com/manage/apps which will redirect you to an URL of the following format:

https://marketplace.atlassian.com/manage/vendors/<Vendor ID>/addons

Simply copy-paste your vendor id from the URL into the Data Studio connector configuration.

Once you entered all the details click Connect in the top right corner.

🎉 That's it, you are now ready to chart your Atlassian Marketplace data in Data Studio.