Advertising Beast Knowledge Base
  • Advertising Beast knowledge base
  • Getting started
    • Understanding the essentials
      • Data considerations
      • Data processing queue
    • Onboarding
      • Connecting accounts
        • Connecting amazon advertising accounts
        • Connecting selling partner accounts
          • Granting account access
            • Seller central service provider permissions
            • Seller central user permissions
          • Granting 'inventory' access
            • Seller central service provider admin 'inventory' access
            • Seller central user admin 'inventory' access
          • Granting 'ad management' access
            • Seller central service provider admin 'ad management' access
            • Seller central user admin 'ad management' access
          • Granting 'reports' access
            • Seller central service provider 'business reports' access
            • Seller central user 'business reports' access
            • Seller central service provider admin 'reports' access
            • Seller central user admin 'reports' access
          • Granting account 'performance' dashboard access
            • Seller central service provider admin account 'performance ' dashboard access
            • Seller central user admin account 'performance ' dashboard access
            • Seller central service provider 'app authorization'
            • Seller central user 'app authorization'
          • Manage permissions
            • Vendor central 'manage integrations (EDI/API)'
      • Granting access to users
      • Enabling accounts for advertising
    • Navigating the app
      • Logging in
      • Selecting accounts
      • Configuring basic interface settings
  • Managing advertising accounts
    • Modules
      • Cross-module components
        • Navigation pills
        • Date range selector
        • Data tables
          • Actions bar
            • Fast mode
            • Filters
              • Conditions
              • Operators
            • Columns
            • Actions (edit)
              • Update
              • Lock/unlock records
              • Update custom fields
                • Bulk upload custom fields
              • Move to portfolio
              • Create targeting
              • Create access link
              • Open profiles in new tab
              • Log processor
              • Revert
              • Retry
            • Export
          • Checkboxes
          • Controllers bar
            • Comparison controller
            • Percentage controller
            • Filtering controller
            • Sorting controller
          • Data
            • Available dimensions
            • Available metrics
          • Pagination
        • Building blocks
          • Controllers bar
        • Preview mode
      • Bulk manager
        • Accounts
        • Portfolios
        • ASINs
        • Campaigns
        • Ad groups
          • Update ad groups
            • Update ad group default bid
              • Ad group bidding parameters
            • Update ad group state
          • Create targeting from ad groups
        • Ads
        • Targeting
          • Update targeting
            • Update targeting bid
              • Targeting bidding parameters
            • Update targeting state
        • Negative targeting
        • Search terms
          • Create targeting from search terms
            • Match types and negative match types
            • Ad group methods
            • Output
      • Ads launcher
        • Spreadsheet bulk uploads
        • Campaign templates
          • Sponsored products & display
          • Sponsored brands
      • Automated rules
        • Before setting up rules
        • Creating rules
        • Available models
          • Overview
          • ASINs
          • Campaigns
          • Ad groups
          • Ads
          • Targeting
          • Negative Targeting
          • Search terms
      • Reports
        • Advertising reports
          • Standard reports
          • Custom reports
          • Guest reports
        • Attribution reports
      • Actions log
        • Operation batches
        • Operation reports
          • Error messages
        • Actions log actions
          • Revert
          • Retry
  • Troubleshooting the app
    • Failing to load in-app data
    • Failing to accurately compare in-app data to console
    • Finding missing accounts
    • Troubleshooting 'actions log' errors
  • Cancelling services
    • Disabling accounts from advertising
    • Disconnecting accounts
      • Disconnecting amazon advertising accounts
      • Disconnecting selling partner accounts
    • Terminating app subscription
Powered by GitBook
On this page
  • Nested operators
  • Operators and negative filtering conditions
  1. Managing advertising accounts
  2. Modules
  3. Cross-module components
  4. Data tables
  5. Actions bar
  6. Filters

Operators

PreviousConditionsNextColumns

Last updated 1 year ago

In the context of filtering, "operators" are crucial parameters that help define how different conditions relate to each other. Understanding these operators, especially 'AND' and 'OR', is key to creating effective filters.

The filter operators are:

  • And: This operator is used when you want to apply multiple conditions simultaneously. A filter with the 'AND' operator will only include results that meet all the specified conditions.

  • Or: The 'OR' operator is used when you want to include results that meet any one of multiple conditions. A filter with the 'OR' operator shows results that meet any one of the criteria. For example, filtering for campaigns that are either "active" OR have a budget of "$100" will show campaigns that meet either one of these conditions.

Nested operators

  • Single: The filter meets a "single" specific condition. It's like applying a straightforward, one-condition filter.

  • Any: This operator is equivalent to the 'OR' operator at a nested level. It meets any one of the listed conditions (each condition specified on a separate line). For example, using "any" to filter for budgets of "$20" or "$50" will show campaigns with either of these budgets.

  • All: Similar to the 'AND' operator, 'All' meets all of the listed conditions (each condition specified on a separate line). This is used for more stringent filtering. For instance, using "all" to filter for campaigns that do not have budgets of "$20" and "$50" will exclude campaigns with these specific budgets.

Applications

Nested filters can be overlapped or combined to create even more specific and complex filtering parameters. For example:

  • To exclusively analyze campaigns with a $100 budget, use "single" equals 100.

  • To analyze campaigns with either $20 or $50 budgets, use "any" equals 20 OR 50.

  • To exclude campaigns with budgets of $20 and $50, select "all" does not equal 20 AND 50.

The ability to overlap nested filters allows you to refine conditions, enabling you to drill down into very specific data sets based on your unique requirements.

Operators and negative filtering conditions

The use of AND/ALL operators in creating negative conditions, such as 'does not include' or 'does not equal', is a critical aspect of filtering data. These operators play a pivotal role in refining search results and ensuring accuracy, especially when dealing with exclusions or specific omissions in data sets.

When setting up negative conditions, the AND/ALL operators are essential for ensuring that all specified criteria are met simultaneously. For instance, using 'does not equal' in conjunction with the AND/ALL operators allows you to effectively exclude multiple specific values or conditions at once. This is particularly important in scenarios where precision is key. For example, if you want to filter out campaigns that do not belong to certain categories or have budgets outside a specific range, using 'does not equal' with the AND/ALL operators ensures that all specified exclusions are applied together. This results in a more targeted and relevant dataset.

Without the AND/ALL operators, negative conditions might not be as comprehensive or effective, potentially leading to incomplete or misleading results. By ensuring that multiple exclusion criteria are satisfied concurrently, these operators provide a more robust and reliable filtering mechanism. This is crucial in data analysis and decision-making processes where overlooking certain elements due to inadequate filtering can lead to incorrect conclusions or strategies. Thus, the correct application of AND/ALL operators in negative conditions is fundamental in achieving precise and actionable insights from your data.

Operators can be further narrowed with the use of .

Nested operators function within a lower hierarchy level than the and allow for more complex filtering scenarios.

Filtered results are listed in the background.
Filtered results are listed in the background.
Filtered results are listed in the background.
Filtered results are listed in the background.
nested operators
primary operators