Select Account
Allows you to select the Vendor 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
Marketplace
Purchase Order Number
Item Sequence Number
ASIN
Vendor Sku
Purchase Order State
Purchase Order Type
Purchase Order Date
PO State Changed Date
PO Changed Date
Payment Method
Ship Window
Buying Party Id
Selling Party Id
Ship To Party Id
Bill To Party Id
Purchase Order Status
Order Status Updated Date
Updated At
Ordered Qty UOM
Is Back Order Allowed
Net Cost Currency
List Price Currency
Confirmation Status
Accepted Qty UOM
Rejected Qty UOM
Receive Status
Received Qty UOM
Last Receive Date
Ordered Qty
Ordered Qty Unit Size
Net Cost Amount
List Price Amount
Accepted Qty
Rejected Qty
Received Qty
Group by
Period: Shows all datapoints grouped under one time range (e.g. Last 7 Days, Last 14 Days, Last 30 Days, etc.).
Datapoint: Shows each metric separately, with the time range shown for each.
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:
ASIN (supports EQUALS or CONTAINS)
Vendor Sku (supports EQUALS or CONTAINS)
Purchase Order Status (All, Open, Closed)
Purchase Order Type (All, Regular Order, Consigned Order, New Product Introduction, Rush Order)
Confirmation Status (All, Accepted, Partially Accepted, Rejected, Unconfirmed)
Receive Status (All, Not Received, Partially Received, Received)
Operator: Choose how the filter is applied:
EQUALS → Matches the exact value
CONTAINS → Matches partial values
Value: Enter or select the value for the chosen field. This can be:
Manual input (e.g., ASIN, Vendor Sku)
Dropdown selection (e.g., Purchase Order Status, Purchase Order Type, Confirmation Status, Receive Status)
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
