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.
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
Marketplace
Ads Type
Impressions
Clicks
Cpc
Ctr
Spend
Sales
Sales 14d
Acos
Roas
Acos Clicks
Roas Clicks
Purchases
Purchases 14d
Purchases Clicks
Orders
Sales Clicks
Units Sold 14d
Units Ordered New To Brand 14d
Units Ordered New To Brand % 14d
Conversion
Conversion Rate
Viewable Impressions
Vtr
Vctr
View Click Through Rate
Video First Quartile Views
Video Midpoint Views
Video Third Quartile Views
Video Complete Views
Video Unmutes
Video 5 Second Views
Video 5 Second View Rate
Branded Searches 14d
Dpv 14d
Orders New To Brand 14d
Orders New To Brand % 14d
Sales New To Brand 14d
Sales New To Brand % 14d
Order Rate New To Brand 14d
Group by
Period: Shows all datapoints grouped under one time range (e.g., Last 14 Days, Last 30 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 (Default: 50,000).
Field: Select the field to filter by, such as:
Campaign
Adgroup
Ads Type
Status
Has Sales Only
Operator: Choose how the filter is applied:
EQUALS → Matches the exact value
CONTAINS → Matches partial values (useful for Campaign or Adgroup search)
Value: Enter or select the value for the chosen field. This can be:
Manual input (e.g., Campaign or Adgroup name)
Dropdown selection (e.g., Ads Type, Status, or Has Sales Only)
Available values for Ads Type include:
All
SB
SD
SP
Available values for Status include:
All
Enabled
Paused
Archived
All But Archived
Available values for Has Sales Only include:
YES
NO
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.
Sample output (partial view) showing selected datapoints
