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.
Metrics
Metrics
SKU
WPID
GTIN
Inbound Order ID
Shipment ID
Ship To FC Name
Ship To City
Ship To State
Ship To Country
Ship To Postal Code
Return City
Return State
Return Country
Return Postal Code
Shipment Status
Created Date
Shipment Units
Received Units
Expected Delivery Date
Updated Expected Delivery Date
Actual Delivery Date
Tracking Number
Carrier Name
Group by
Period: Shows all datapoints grouped under one time range (e.g., This Month, Last Month, 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:
Inbound Order ID (supports EQUALS or CONTAINS)
Shipment ID (supports EQUALS or CONTAINS)
Shipment Status (All, Draft, Created, Receiving, Delivered, Closed, Cancelled)
Ship To FC Name (supports EQUALS or CONTAINS)
Carrier Name (supports EQUALS or CONTAINS)
Tracking Number (supports EQUALS or CONTAINS)
Operator: Choose how the filter is applied:
EQUALS → Matches the exact value
CONTAINS → Matches partial values (useful for Inbound Order ID, Shipment ID, Ship To FC Name, Carrier Name, Tracking Number)
Value: Enter or select the value for the chosen field. This can be:
Manual input (e.g., Inbound Order ID, Shipment ID, Ship To FC Name, Carrier Name, Tracking Number)
Dropdown selection (e.g., Shipment 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
