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
Transactions ID
Statement Id
Order Id
SKU Name
Seller SKU
Adjustment Id
Adjustment Order Id
Transaction Type
Currency
Order Create Time
Payment Id
Payment Status
Payment Time
Statement Time
Gross Sales Amount
Gross Sales Refund Amount
Net Sales Amount
Revenue Amount
After Seller Discounts Subtotal Amount
Customer Payment Amount
Customer Refund Amount
Customer Order Refund Amount
Settlement Amount
Seller Discount Amount
Seller Discount Refund Amount
Platform Discount Amount
Platform Discount Refund Amount
Platform Refund Subsidy Amount
Customer Shipping Fee Amount
Customer Shipping Fee Offset Amount
Customer Paid Shipping Fee Amount
Customer Paid Shipping Fee Refund Amount
Actual Shipping Fee Amount
Actual Return Shipping Fee Amount
Return Shipping Fee Amount
Shipping Fee Amount
Shipping Cost Amount
Shipping Cost Discount Amount
Shipping Fee Subsidy Amount
Shipping Insurance Fee Amount
Signature Confirmation Fee Amount
Platform Shipping Fee Discount Amount
Promo Shipping Incentive Amount
Refund Shipping Cost Discount Amount
Fbm Shipping Cost Amount
Fbt Shipping Cost Amount
Fbt Fulfillment Fee Amount
Fbt Fulfillment Fee Reimbursement Amount
Fee Amount
Referral Fee Amount
Transaction Fee Amount
Refund Administration Fee Amount
Platform Commission Amount
Sales Tax Amount
Sales Tax Payment Amount
Sales Tax Refund Amount
Isr Income Tax Amount
Iva Vat Amount
Retail Delivery Fee Amount
Retail Delivery Fee Payment Amount
Retail Delivery Fee Refund Amount
Affiliate Commission Amount
Affiliate Ads Commission Amount
Affiliate Partner Commission Amount
Affiliate Commission Before Pit
Pit Amount
Adjustment Amount
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:
Order ID (supports EQUALS or CONTAINS)
Seller SKU (supports EQUALS or CONTAINS)
Statement ID (supports EQUALS or CONTAINS)
Transactions ID (supports EQUALS or CONTAINS)
Transaction Type (All, Order, Reserve, Charge Back, Customer Service Compensation, Deductions Incurred by Seller, GMV Payment for Ads, Platform Commission Adjustment, Platform Commission Compensation, Platform Penalty, Promotion Adjustment, Rebate, Platform Compensation, Platform Reimbursement, Cofunded Creator Rewards, Stamp Duty, FBT Warehouse Service Fee, Logistics Reimbursement, Shipping Fee Adjustment, Shipping Fee Compensation, Shipping Fee Rebate, Sample Shipping Fee, Seller Mission Reward, Other Adjustment)
Payment Status (All, Paid, Failed, Processing)
Operator: Choose how the filter is applied:
EQUALS → Matches the exact value
CONTAINS → Matches partial values (useful for Order ID, Seller SKU, Statement ID, Transactions ID)
Value: Enter or select the value for the chosen field. This can be:
Manual input (e.g., Order ID, Seller SKU, Statement ID, Transactions ID)
Dropdown selection (e.g., Transaction Type, Payment 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
