Can you be more specific about how this data is provided to you? Is there an API? A direct database connect? Do you have to download CSV or Excel Files?
Back on this ---- sorry, it's been a very long time since this issue has had my attention but it's made it's way back to my list.
Tom, that's the issue at hand. I am not sure how to get the data from Amazon. I do know Excel/CSV is an option but we are looking for something more automated.
I thought there was a chance that there are more Tableau customers out there that need to tap into Amazon besides my organization. If there are, I was wondering how you tap into the data.
I am in the same situation. We sell on Amazon. I have been pulling the business reports as a .csv and merging them in MS-dos before bringing the data into Tableau. I generally spend about an hour after month-end pulling data, adding dates to it cleaning it up etc.
I can't find a way to automate the .csv to anywhere. Amazon does have an API but I am no developer, and our developer is deep into other non-data projects right now and won't free back up for a long time.
The Data I use is under business reports and includes PageViews, Sessions and Buy Box %.
Seems like there would be enough demand for this that a 3rd party would build out solution and sell it... maybe on Amazon.
Great news, Tableau users! If anyone is interested, I'm looking for hand raisers to beta test our integration with Amazon MWS. It will allow you to pull sales performance data from Amazon.com for analysis in Tableau. This post explains a bit more: https://blog.openbridge.com/secrets-of-cutting-edge-amazon-sellers-keep-your-eye-on-the-prize-by-harnessing-amazon-data-for-6a6269a63e39.
For anyone interested in the Amazon MWS data we are asking they complete a short survey.
If you have any questions, please do not hesitate to reach out. Appreciate your interest!