Note:The DataMarket Service Explorer supports listing values for query parameters. The Excel Add in DOES NOT (still in beta).
DataMarket Service Explorer providing parameter values
Excel Add In requiring manual entry of parameter values
The API UPC field is a string to accommodate leading zeros and comma separated lists of multiple UPCs. There is a bug in the beta Excel Add-in that erroneously converts the string to numeric. If this field is important to you, we advise that you use: a. the Service Explorer and export and save your queries by choosing CSV and then import into Excel identifying this field as a 'string' or, b. export to PowerPivot which handles this field correctly.
Remember: set ISMarketplace to "False" to filter out a Retailer's 3rd-party merchants if you only want to see data related to SKUs sold direct from a Retailer.
You can convert the API’s Date/Time text to an Excel DateType utilizing the following:
For API Summary Records:
For API Event History Records:
Use a Retailer–SKU combination to obtain cross-retailer data for individual products. The API will automatically return matching SKUs for other Retailers.
The parameter ReturnedDataScope defaults to a value of AllRetailers unless explicitly set to InputedRetailerOnly in which case only data for the retailer set in the Retailer parameter is returned.
Excel PowerPivot and Excel 2013 along with PowerView provide powerful, self-serve analytical capabilities out-of-the-box. The Images below are from the "Retail Intelligence Excel Workbook and Data Set Sample".
PowerView (Excel 2013)