If you run sales or marketing in Salesforce, you already know reports are the heartbeat of your pipeline reviews. But the most valuable reports are rarely the obvious ones; they are *exception* reports – Accounts without Contacts, Opportunities without Activities, customers with no expansion pipeline. That is where Salesforce cross filters shine.Below, we will walk through three layers of doing this work: manual setup, no-code automation, and then scaling it with an AI agent that works in Salesforce the way a power user would.### 1. Manual ways to use Salesforce cross filtersLet us start with the basics your team can do today inside Salesforce.#### 1.1 Find Accounts without Opportunities1. In Salesforce, go to the Reports tab.2. Click New Report.3. Choose the report type Accounts and hit Continue.4. In the Filters panel, set Show Me to All accounts and set a broad Date range, such as All Time.5. Click the down arrow next to Filters and choose Add Cross Filter.6. Configure: - Parent: Accounts - With or Without: Without - Child: Opportunities7. Click Apply, then Run.You now have a live list of every account that has never had an opportunity. Sales leaders can assign outreach, BDRs can prospect, and marketing can plan nurture campaigns.For Salesforce’s official help on cross filters, see the article "Filter Reports Using Cross Filters" in the Salesforce Help Center: https://help.salesforce.com (search that title).#### 1.2 Find Opportunities without Activities (classic exception report)1. New Report → choose Opportunities.2. In Filters, set Close Date range and Stage filters to match your active pipeline.3. Add Cross Filter: - Opportunities Without Activities.4. Optionally click Add Activities Filter to narrow to a specific Activity Date, such as THIS WEEK.5. Run the report.This shows deals at risk because nobody has called, emailed, or met with the customer recently.#### 1.3 Find Accounts without Contacts or without a Primary Contact1. Create a report with the Accounts report type.2. Add a cross filter: Accounts Without Contacts.3. Duplicate the report and, in the second version, change the filter to Accounts With Contacts and then add a sub-filter on Contacts where Primary equals False or is blank.Now you have:- One report for orphaned accounts.- One report for accounts with contacts but no clear owner.These three patterns, combined with variations (Opportunities without Products, Cases without Activities, etc.), cover most manual use cases.### 2. No-code automation with Salesforce and popular toolsManual reports are powerful, but they still rely on someone remembering to open them. No-code automation lets you turn cross filters into a recurring signal.#### 2.1 Use report subscriptions in Salesforce1. Open any cross-filtered report you created.2. Click Subscribe (top right in Lightning Experience).3. Choose: - Frequency: Daily, Weekly, or Monthly. - Conditions: e.g., Row Count is greater than 0, so emails only send when there is something to fix. - Recipients: individual owners, managers, or a distribution list.4. Save.Now Salesforce automatically emails the exception list to the right people. See "Subscribe to Reports and Dashboards" in Salesforce Help for configuration details at https://help.salesforce.com.#### 2.2 Use dashboard components plus subscriptions1. Create a dashboard and add your cross-filter reports as components (tables or charts).2. Group by Owner, Stage, or Segment to make issues visible at a glance.3. Subscribe managers to the dashboard so they receive a snapshot before pipeline reviews.This makes cross filters central to your weekly rhythm, not a one-off discovery.#### 2.3 Connect no-code automation platformsYou can also let tools like Zapier or Make use Salesforce reports:1. Expose the relevant reports or build list views that mimic your cross filter logic.2. In your automation tool, use the Salesforce connector to query records matching those conditions.3. Push them into spreadsheets, Slack notifications, or task systems like Asana.While this is still rule-based, it offloads the repetitive fetching and routing of exception data.### 3. Scaling cross filters with an AI agent (Simular-powered workflows)At some point, the problem is not just “how do I build one good cross filter?” It becomes “how do I maintain dozens of smart exception views, update them as the business changes, and keep everyone informed – without babysitting Salesforce?”This is where an AI computer agent running on Simular Pro becomes your virtual Salesforce analyst.#### 3.1 AI agent that builds and updates cross-filter reportsWhat it does:- Logs into Salesforce like a human.- Navigates to Reports and Dashboards.- Creates or edits reports with cross filters (e.g., Accounts without Opportunities this quarter, Opportunities without Activities last 14 days).- Saves them into shared folders by team or region.**Pros:**- No admin bottleneck; business teams describe what they need in natural language.- Agent executes multi-step UI workflows reliably across the Salesforce interface.- Transparent execution: every click is recorded and reviewable in Simular Pro.**Cons:**- Requires clear access policies and a monitored sandbox to start.- Needs initial setup time to encode naming conventions and folder structures.Learn more about how Simular agents operate across desktop and browser apps at https://www.simular.ai/simular-pro.#### 3.2 AI agent that schedules, exports, and distributes insightsBeyond building the reports, the agent can:- Open each cross-filter report on a schedule.- Export results to CSV or Excel.- Upload results into Google Sheets or your data warehouse.- Post a summary in Slack or email with highlights, such as "12 Opportunities without Activity; 3 over 30 days stale".**Pros:**- Turns static exception lists into an ongoing workflow.- Bridges Salesforce with other tools without custom integration.- Ideal for agencies managing many client orgs or business units.**Cons:**- You still define the business rules; the agent handles execution.- Governance is important when data leaves Salesforce.#### 3.3 AI agent orchestrating multi-step remediationA more advanced pattern:- The agent pulls the cross-filtered list.- For each record, it opens the detail page.- It creates follow-up tasks, updates fields, or sends templated emails (according to your playbook).Example: For every Opportunity without Activity over 14 days, the agent can:- Create a “Re-engage this week” task for the owner.- Tag the deal with a Risk flag.- Add it to a “Stale Pipeline” campaign.Over time, this becomes a living governance layer around your Salesforce data, handled by an AI assistant that never gets tired or distracted.

Heading 1

Heading 2

Heading 3

Heading 4

Heading 5

Heading 6

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.

Block quote

Ordered list

1. Item 1
2. Item 2
3. Item 3

Unordered list

• Item A
• Item B
• Item C

Text link

Bold text

Emphasis

^Superscript

_Subscript