Skip to main content

Product

Provides product-level advertising performance insights, including sales, conversions, engagement, and ad efficiency across campaigns, SKUs, and ASINs.

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

  • Marketplace

  • Ads Type

  • SKU

  • ASIN

  • Campaign

  • Purchases

  • Purchases Clicks

  • Purchases Promoted Clicks

  • Purchases 1d

  • Purchases 7d

  • Purchases 14d

  • Purchases 30d

  • Purchases Same Sku 1d

  • Purchases Same Sku 7d

  • Purchases Same Sku 14d

  • Purchases Same Sku 30d

  • Sales Clicks

  • Sales Promoted Clicks

  • Sales

  • Sales 1d

  • Sales 7d

  • Sales 14d

  • Sales 30d

  • Sales Same Sku 1d

  • Sales Same Sku 7d

  • Sales Same Sku 14d

  • Sales Same Sku 30d

  • Spend

  • Units Sold

  • Units Sold Clicks

  • New To Brand Units Sold

  • New To Brand Units Sold Clicks

  • Units Sold Clicks 1d

  • Units Sold Clicks 7d

  • Units Sold Clicks 14d

  • Units Sold Clicks 30d

  • Units Sold Same Sku 1d

  • Units Sold Same Sku 7d

  • Units Sold Same Sku 14d

  • Units Sold Same Sku 30d

  • Impressions

  • Cpc

  • Ctr

  • Acos Clicks

  • Roas Clicks

  • Clicks

  • Conversion

  • View Click Through Rate

  • Detail Page Views

  • Detail Page Views Clicks

  • Conversion 1d

  • Conversion 7d

  • Conversion 14d

  • Conversion 30d

  • Acos Clicks 7d

  • Acos Clicks 14d

  • Roas Clicks 7d

  • Roas Clicks 14d

  • Acos

  • Roas

  • Units Sold 14d

  • Orders

Group by

  • Period: Shows all datapoints grouped under one time range (e.g. Last 14 Days, 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:

  • SKU

  • ASIN

  • Campaign

  • Ads Type

  • Status

  • Has Sales Only

Operator: Choose how the filter is applied:

  • EQUALS → Matches the exact value

  • CONTAINS → Matches partial values (useful for SKU, ASIN or Campaign search)

Value: Enter or select the value for the chosen field. This can be:

  • Manual input (e.g., SKU, ASIN or Campaign name)

  • Dropdown selection (e.g., Ads Type, Status, or Has Sales Only)

Available values for Ads Type include:

  • All

  • 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

Related Articles
Amazon Ads Data Supported
Ads Overview
Campaign
Group
Keyword
Did this answer your question?