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
GTIN
WPID
Return Order ID
Return Order Line Number
Sales Order Line Number
Return Reason
Purchase Order ID
Seller Order ID
Purchase Order Line Number
Is Return For Exception
Exception Item Type
Recharge Reason
Return Cancellation Reason
Product Name
Item Weight Value
Item Weight Unit
Charge Category
Charge Name
Charge Per Unit Amount
Charge Per Unit Currency
Is Discount
Is Billable
Tax Name
Excess Tax Amount
Excess Tax Currency
Tax Per Unit Amount
Tax Per Unit Currency
Excess Charge Amount
Excess Charge Currency
References Name
References Value
Unit Price Amount
Unit Price Currency
Current Delivery Status
Current Refund Status
Cancellable Quantity
Quantity Value
Quantity Unit
Return Expected Flag
Is Fast Replacement
Is Keep It
Last Item Refunded Quantity
Rechargeable Quantity
Refund Channel
Group by
Period: Shows all datapoints grouped under one time range (e.g., Last 30 Days, Last 60 Days, Last 90 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:
SKU (supports EQUALS or CONTAINS)
GTIN (supports EQUALS or CONTAINS)
WPID (supports EQUALS or CONTAINS)
Availability (All, In_Stock, Out_of_Stock)
Published Status (All, Published, Unpublished, System Problem)
Life Cycle Status (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., Availability, Published Status, Life Cycle 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
