Select Account
Allows you to select the Seller Account and Marketplaces from where data will be retrieved.
Reload Accounts & Marketplaces:
Use this to refresh the connection and marketplace list if you have recently added or updated in the app.gorillaroi.com
Click here to connect additional accounts:
Click here to open the Gorilla ROI app, where you can add, update, or manage your account connections.
Period
Select the time range for your report using one of three options:
Predefined ranges (e.g., Last 7 Days, Last 30 Days, Last 90 Days etc) for quick selection.
Custom to choose a specific start and end date.
Last X Daily Values to get day-wise historical data for the selected number of past days (e.g., Number of days --> 22).
Metrics
Metrics
Date
SKU Market
GTIN
WPID
Item Name
Stock Status
WFS Publishing Status
WFS Item Lifecycle
Available Units
Reserved Units
Inbound Units
Inventory Review Units
Inventory Movement Units
On-Hand Units
Age 0-90 Days
Age 91-180 Days
Age 181-270 Days
Age 271-365 Days
Age 365+ Days
First In-Stock Date
Sales Forecast Wk 1-4
Sales Forecast Wk 5-8
Sales Forecast Wk 9-12
Sell Through Rate
Days of Supply
Out of Stock Date
Suggested Units
Surplus Units
Group by
Not applicable for the WFS Inventory History dataset.
Filter
Results per Query: Select the maximum number of records (rows) returned in the output (e.g., 5, 10, 50, 100, 500, 1000).
Field: Select the field to filter by, such as:
SKU (supports EQUALS or CONTAINS)
GTIN (supports EQUALS or CONTAINS)
WPID (supports EQUALS or CONTAINS)
Stock Status (All, In_Stock, Out_of_Stock, At Risk, Long Term Out of Stock)
WFS Publishing Status (All, Published, Unpublished, System Problem)
WFS Life Cycle (All, Active, Retired, Archived)
Operator: Choose how the filter is applied:
EQUALS → Matches the exact value
CONTAINS → Matches partial values (useful for SKU, GTIN, WPID)
Value: Enter or select the value for the chosen field. This can be:
Manual input (e.g., SKU, GTIN, WPID)
Dropdown selection (e.g., Stock Status, WFS Published Status, WFS Life Cycle)
Add Filter: Use Add filter to apply multiple conditions within the same group.
Add Filter Group: Use Add Filter Group to create separate groups for advanced filtering.
Options
Replace Blank Values with 0 or N/A: Replaces empty or missing values with 0 or N/A (where applicable).
No Header Row: Removes the header row from the output.
Products with Data Only: Displays only products that have data, hiding those with no data or activity.
Sample output (partial view) showing selected datapoints
