Skip to content
Campaign Audience BuilderCampaign Audience BuilderCAB Documentation

Diagnose an audience query

Investigate slow or risky audience definitions

Audience Query Diagnostics exposes the query CAB generates for an audience and points out filter patterns that may struggle with large data volumes. It is a diagnostic aid for administrators and Salesforce specialists; it does not change the audience.

Run diagnostics

Section titled “Run diagnostics”
  1. Go to CAB Settings → Audience Query Diagnostics.
  2. In Search Audiences, choose an audience.
  3. Review the summary: Initial Object, Risky Filters, Likely Indexed Initial Filter, and Likely Indexed Positive Filter.
  4. Read Recommendations and Query Plan before inspecting the query text.
  5. Use the copy button titled Copy SOQL when a Salesforce administrator needs to analyze the query elsewhere. Select Refresh Diagnostics after the audience definition or relevant schema changes.

Read the query sections

Section titled “Read the query sections”
  • Generated Initial SOQL is the initial query CAB plans to execute.
  • Simplified Fallback SOQL appears when CAB has a fallback representation.
  • Additional Generated SOQL lists numbered Relationship Query and Aggregate Query statements used by the audience graph.
  • Filter Diagnostics identifies each object, field, operator, whether it is on the initial object, whether it is likely indexed, whether it is risky for large data volumes, and an explanatory detail.