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
OrderID
Purchase Date
Product ID
Variant ID
SKU
Order Status
Fulfillment Status
Order Name
Process Date
Closed
Close Date
Cancel Date
Update Date
Cancel Reason
Confirmed
Confirmation Number
Discount Code
Currency
Order SubTotal
Order Total
Total Discounts
Total Received
Total Refunded
Total Shipping Price
Total Tax
Net Payment
Item Quantity
Refundable Quantity
Non-Fulfillable Quantity
Current Quantity
Is Gift Card
Requires Shipping
Taxable
Original Unit Price
Original Unit Total Price
Line Item Discount
Discounted Unit Price
Discounted Unit Total Price
Group by
Not applicable for the Orders 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)
Product ID (supports EQUALS or CONTAINS)
Variant ID (supports EQUALS or CONTAINS)
Product Status (All, Active, Draft, Archived)
Order Status (All, Authorized, Expired, Paid, Partially Paid, Partially Refunded, Pending, Refunded, Voided)
Fulfillment Status (All, Fulfilled, In Progress, On Hold, Open, Partially Fulfilled, Pending Fulfillment, Request Declined, Restocked, Scheduled, Unfulfilled)
Order ID (supports EQUALS or CONTAINS)
Operator: Choose how the filter is applied:
EQUALS → Matches the exact value
CONTAINS → Matches partial values (useful for searching SKU, Product ID, Variant ID, or Order ID)
Value: Enter or select the value for the chosen field. This can be:
Manual input (e.g., SKU, Product ID, Variant ID, or Order ID)
Dropdown selection (e.g., Product Status, Order Status, or Fulfillment 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
