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
Period is not required for the Promotion Activities dataset.
Metrics
Metrics
Activity ID
Product ID
SKU ID
Title
Activity Type
Status
Product Level
Duration Type
Begin Time
End Time
Create Time
Update Time
Product Name
Seller SKU
Discount Percentage
Activity Price Amount
Activity Price Currency
Quantity Limit
Quantity Per User
Note: Activity ID, Product ID and SKU ID are mandatory and always included in the output. The output returns one row per product (or SKU) in each activity, so an activity that covers several products appears on several rows.
Group by
Not applicable for the Promotion Activities dataset.
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:
Activity ID (supports EQUALS or CONTAINS)
Activity Type (All, Fixed Price, Direct Discount, Flash Sale, Shipping Discount, Buy More Save More)
Status (All, Draft, Not Start, Ongoing, Expired, Deactivated, Not Effective)
Product ID (supports EQUALS or CONTAINS)
Product Name (supports EQUALS or CONTAINS)
Seller SKU (supports EQUALS or CONTAINS)
SKU ID (supports EQUALS or CONTAINS)
Note: By default, the query includes a Status EQUALS All filter so activities in every status are returned.
Operator: Choose how the filter is applied:
EQUALS → Matches the exact value
CONTAINS → Matches partial values (useful for Activity ID, Product ID, Product Name, Seller SKU, SKU ID)
Value: Enter or select the value for the chosen field. This can be:
Manual input (e.g., Activity ID, Product ID, Product Name, Seller SKU, SKU ID)
Dropdown selection (e.g., Activity Type, 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
