Connecting Amazon to Google Data Studio: Setup Instructions

Google Data Studio is a good option for Amazon sellers and vendors to generate lightning-fast reports. However, first you must connect Google Data Studio with your Amazon Seller Central or Vendor Central account. This guide will show you a step-by-step process for doing so, including screenshots.

What Is Google Data Studio?

Google Data Studio is a popular tool for taking raw data and converting it into customizable reports and dashboards. It is part of the Google Analytics 360 suite, and was first unveiled in 2016. For Reason Automation clients, it is a great way to take the data we provide and create quick reports that contain actionable business insights.

How to Connect Google Data Studio to Amazon Data

Use the following steps to set up Google Data Studio and connect it to your Amazon Seller Central or Vendor Central account.

1. Create a new data source

From the Google Data Studio home page, click Create > Data Source.

google-create-data-source.png

2. Select the PostgreSQL connector published by Google

PostgreSQL is the database technology that we use to deliver your data. It is natively supported by Google Data Studio. Search for “PostgreSQL” to find the connector, then click the Select button.

 
 

3. Connect Google Data Studio to Reason Automation

In the next setup screen, fill out the following fields, then click Authenticate.

  Host Name:  [Your server]   Port:       [Your port - usually 5432 or 4527]   Database:   [Your database]   Username:   [Your database user name]   Password:   [Your database password]

Your database, database user name, and database password were emailed to you during account setup. If you have lost your database credentials and need them reset, please email technical support.

If you're receiving an error at this step, we may need to update your database configurations. Please email our technical support team for assistance.

 
 

4. Choose a table to work with

Select the table you want to import. Each table represents a Seller Central report that has been imported to your database, e.g. “inventory_all_listings”.

google-choose-table.png

5. Congratulations!

You now have direct access to all of your Seller Central reports from within Google Data Studio. Click Create Report to start working with your data right away. We recommend checking the data Type that Google assigned to each field, and updating if necessary.

Resources

The following external resources may help you get started with Google Data Studio.

  1. Welcome to Google Data Studio

  2. Introduction to Data Studio - free beginner courses from Google Analytics

Andrew Hamada

Chief Executive Officer, Reason Automation

Previous
Previous

Power BI Amazon Seller Central Setup Instructions

Next
Next

Tableau Amazon Seller Central Setup Instructions