Select Account
Allows you to select the TikTok Shop account from where data will be retrieved.
Reload Accounts & Marketplaces:
Use this to refresh the connection 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 these options:
Predefined ranges (e.g., Today, Yesterday, Last 7 Days, Last 30 Days, This Year, Last Month, Last 12 Months, 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
Order Id
Line Item Id
User Id
Status
Create Time
Update Time
Paid Time
Cancel Time
Cancellation Initiator
Cancel Reason
Cancel Order Sla Time
Delivery Sla Time
Shipping Due Time
Tts Sla Time
Payment Currency
Payment Method
Payment Total Amount
Payment Sub Total
Payment Original Total Product Price
Payment Seller Discount
Payment Platform Discount
Payment Shipping Fee
Payment Original Shipping Fee
Payment Shipping Fee Seller Discount
Payment Shipping Fee Cofunded Discount
Payment Shipping Fee Platform Discount
Payment Shipping Fee Tax
Payment Product Tax
Payment Tax
Payment Retail Delivery Fee
Payment Item Insurance Tax
Warehouse Id
Fulfillment Type
Shipping Type
Delivery Type
Delivery Option Id
Delivery Option Name
Tracking Number
Recipient Region Code
Is Cod
Is Exchange Order
Is On Hold Order
Is Replacement Order
Is Sample Order
Is Subscription Order
Has Updated Recipient Address
Package Id
Package Status
Sku Id
Product Id
Sku Name
Product Name
Seller Sku
Sku Type
Sku Image
Currency
Original Price
Sale Price
Seller Discount
Platform Discount
Display Status
Cancel User
Tax Type
Tax Amount
Tax Rate
Is Gift
Is Dangerous Good
Note: Order Id and Line Item Id are mandatory and always included in the output.
Group by
Period: Shows all datapoints grouped under one time range (e.g., Last 30 Days, Last 60 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, 50,000).
Field: Select the field to filter by, such as:
Seller SKU (supports EQUALS or CONTAINS)
SKU Name (supports EQUALS or CONTAINS)
Product Name (supports EQUALS or CONTAINS)
Order ID (supports EQUALS or CONTAINS)
Status (All, Unpaid, On Hold, Awaiting Shipment, Awaiting Collection, Partially Shipping, In Transit, Shipped, Delivered, Completed, Cancelled)
Operator: Choose how the filter is applied:
EQUALS → Matches the exact value
CONTAINS → Matches partial values (useful for Seller SKU, SKU Name, Product Name, Order ID)
Value: Enter or select the value for the chosen field. This can be:
Manual input (e.g., Seller SKU, SKU Name, Product Name, Order ID)
Dropdown selection (e.g., 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
