All data in Merchant Assistant can be pushed into a database and staged to be queried directly and quickly. Database tables are automatically updated with the latest data from Amazon and any dashboards connected through a direct query or import pipeline results in improved performance over a traditional OData query. Merchant Assistant can push data into any relational database or columnar database.

Once the reports have been pushed into your database of choice, tables can be massaged and customized so that the tables are clean and ready to be imported into any live dashboards. Through database scripts, you can pivot, refine, partition, and remove any rows needed.

By storing all the data on a database or in a data lake, you will have access to all the data from the beginning of data collection to reference. Even when the data is no longer relevant and has rolled off the reporting calendar, all the downloaded reports will be available to ad-hoc analytics.