Select Account
Allows you to select the Vendor 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
This dataset only supports Weekly, Monthly, and Quarterly periods (no daily custom range or Last X Daily Values).
Supported date range options:
Supported date range options:
Custom Week
Custom Month
This Week
This Month
This Quarter
This Year
This Year to Last Month
Last Week
Last Month
Last 3 Months
Last 12 Months
Last Quarter
Last Year
Last 7 Days Week Ago
Last 7 Days Year Ago
Last 30 Days Month Ago
Last 30 Days Year Ago
Last Week Year Ago
Last Month Year Ago
Metrics
Metrics
ASIN
Marketplace
Department Name
Search Term
Clicked Item Name
Search Freq Rank
Click Share Rank
Click Share %
Conversion Share %
Group by
Period: Shows all datapoints grouped under one time range (e.g. Last 3 Months, Last 12 Months, 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:
Department Name (supports EQUALS or CONTAINS)
Search Term (supports EQUALS or CONTAINS)
ASIN (supports EQUALS or CONTAINS)
Clicked Item Name (supports EQUALS or CONTAINS)
Operator: Choose how the filter is applied:
EQUALS → Matches the exact value
CONTAINS → Matches partial values
Value: Enter or select the value for the chosen field. This can be:
Manual input (e.g., ASIN, Search Term, ASIN, Clicked Item Name)
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
