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 (link)
Connect your data warehouse here if you haven't already done so.
Navigate to the Data Warehouse Reports page in PRO and click "Create Report." This will open a separate tab in Google Data Studios.
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."
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.
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.
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 🤷♀️).
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)
Once you've entered your information, select "Authenticate > Reconnect"
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.
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!)
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)
If you run into any issues, check out our Knowledge Base articles for more information or reach out to our customer success team! (links)