• Want to save time and streamline efforts of pulling hundreds of Seller Central reports?

  • Tired of sifting through outdated spreadsheets?

  • Need a better way to visualize your data to quickly identify areas of opportunity in your business?

📊 We've got you covered with dynamic reporting!

Our data scientists have created customizable dynamic reports using Google Data Studios that sync to your data warehouse. What data is included in the reports? Check out our knowledge article here for more info.

Get started with a few easy steps!

Check out our video of creating your dynamic report here

Step 1️⃣

Connect your data warehouse here if you haven't already done so.

Step 2️⃣

Navigate to the Data Warehouse Reports page in PRO and click "Create Report." This will open a separate tab in Google Data Studios.

Step 3️⃣

This link will send you to a dynamic report template that includes all of your Amazon order, inventory, business reports, advertising data, and so much more! You will need to make a "copy" of this report to start syncing to your data warehouse and pull your specific data.

Click the 3 dots at the top right side of the page and select "Make a Copy"

This will generate a new URL that is specifically yours!

A warning message will pop up. Do not change anything here. Click "Copy Report."

Step 4️⃣

From the copy report, Fell free to rename the report to your liking. Click Resource > Manage Added Data Sources" and you will see a list of data sources to connect to.

Step 5️⃣

You will need to start "connecting" your data warehouse to the data sources 1 by 1. This is a quick process (especially once you get the hang of it!).

Find the first available embedded data source

(Note: They can be in any order!) In the example above, Orders is the first data source.

Step 6️⃣

Select Edit under each data source and you will be directed to the connections page

(select "ok" if you receive an error message on this page. It's a Google Data Studios snag 🤷‍♀️).

Step 7️⃣

From the connections page, begin entering the 5 fields outlined below using your database information provided to you on the database page in PRO.

(screenshot in PRO of database info)

(note: you can copy and paste all info to speed up the process)

Step 8️⃣

Once you've entered your information, select "Authenticate > Reconnect"

Step 9️⃣

Click the data source back button at the top of the page (in this example the data source is Orders) and you will be directed to the data source connections page again.

Step 🔟

Repeat [STEPS 5 - 9] until all data sources have been connected with your database information. In this example, the next data source is purchased_product_by_keyword.
(Note: all data sources must be connected to your database in order for data to populate in your report!)

Step 1️⃣1️⃣

Once you have successfully connected all data sources, click the close button to exit and direct you back to your report!

From there, you should see your data populated in your report! Now you are on your way to better business insights!
(note: this may take up to 2 minutes for your data to sync)

__________________

Need help? Our support team is happy to assist you! 🙂

  • Connect via the in-app chat icon, located in the bottom-right of your screen while logged into any of our apps

  • Search the Knowledge Base to see if your question has already been answered

  • Make an appointment with us for more direct support

Did this answer your question?