Toggle Side Panel

  • Blogs
  • Consultants
    • Salesforce Product Expertise
      • Top Salesforce ConsultantsTop Salesforce Consultants
      • Marketing Cloud ConsultantsMarketing Cloud Consultants
      • Service Cloud ConsultantsService Cloud Consultants
      • Experience Cloud ConsultantsExperience Cloud Consultants
      • Analytics Cloud ConsultantsAnalytics Cloud Consultants
    • Salesforce Industry Expertise
      • Non-Profit Cloud ConsultantsNon-Profit Cloud Consultants
      • Financial Service Cloud ConsultantsFinancial Service Cloud Consultants
      • Health Cloud ConsultantsHealth Cloud Consultants
      • Commerce Cloud ConsultantsCommerce Cloud Consultants
      • Manufacturing Cloud ConsultantsManufacturing Cloud Consultants
    • Salesforce Experts by Location
      • USATop Salesforce Consultants in USA
      • IndiaTop Salesforce Consultants in India
      • AustraliaTop Salesforce Consultants in Australia
      • United KingdomTop Salesforce Consultants in UK
      • CanadaTop Salesforce Consultants in Canada
  • Webinars
  • Contact Us
  • Discussions
More options
    Sign in Sign up
    • Blogs
    • Consultants
      • Salesforce Product Expertise
        • Top Salesforce ConsultantsTop Salesforce Consultants
        • Marketing Cloud ConsultantsMarketing Cloud Consultants
        • Service Cloud ConsultantsService Cloud Consultants
        • Experience Cloud ConsultantsExperience Cloud Consultants
        • Analytics Cloud ConsultantsAnalytics Cloud Consultants
      • Salesforce Industry Expertise
        • Non-Profit Cloud ConsultantsNon-Profit Cloud Consultants
        • Financial Service Cloud ConsultantsFinancial Service Cloud Consultants
        • Health Cloud ConsultantsHealth Cloud Consultants
        • Commerce Cloud ConsultantsCommerce Cloud Consultants
        • Manufacturing Cloud ConsultantsManufacturing Cloud Consultants
      • Salesforce Experts by Location
        • USATop Salesforce Consultants in USA
        • IndiaTop Salesforce Consultants in India
        • AustraliaTop Salesforce Consultants in Australia
        • United KingdomTop Salesforce Consultants in UK
        • CanadaTop Salesforce Consultants in Canada
    • Webinars
    • Contact Us
    • Discussions
    Close search

    Activity › Forums › Salesforce® Discussions › How to count unique accounts from the campaign member related list?

    Tagged: Account, Related List, Salesforce Apex, Salesforce SOQL, Salesforce Trigger

    • Salesforce® Discussions

      How to count unique accounts from the campaign member related list?

      Posted by Nitish on April 30, 2016 at 5:23 PM

      How to count unique accounts from the campaign member related list on the campaign detail page?

      • This discussion was modified 10 years, 5 months ago by  Nitish.
      • This discussion was modified 10 years, 4 months ago by  Forcetalks.
      • This discussion was modified 10 years, 4 months ago by  Forcetalks.
      Gourav replied 10 years, 5 months ago 2 Members · 1 Reply
      • Account
      • Related List
      • Salesforce Apex
      • Salesforce SOQL
      • Salesforce Trigger
    • 1 Reply
    • Gourav

      Member
      June 2, 2016 at 1:57 PM

      There is no configuration through which this can be achieved easily. This can be done via a trigger.

      Create a trigger on CampaignMember for after insert, after update, after delete and after undelete.
      Get the unique campaign Ids from Campaign Members
      Create a aggregate query and group by Campaign Id and Account Id.
      The aggregate query should be able to give you the unique count which you can update on Account. You might also require triggers on Contact and Account for handling situations such as Account update on Contact, Contact deletion, Account deletion.

    Log In to reply.

    • Public
    • All Members
    • My Connections
    • Only Me
    • Public
    • All Members
    • My Connections
    • Only Me
    • Public
    • All Members
    • My Connections
    • Only Me

    Popular Salesforce Blogs

    Salesforce Summer '23 Release Highlights

    Blog in Salesforce Releases

    Salesforce is heating up with new features in the Summer '23 update! Sit back and enjoy the sunshine and the bright innovations that will increase…

    B2B Stores, Case Management, Commerce, Customization, Dashboard Filters
    DB May 22, 2023
    1,448  Views

    Salesforce FreePBX Integration | All You Need to Know

    Blog in Salesforce

    In the fast-paced realm of customer relationship management (CRM), staying ahead requires leveraging the latest technologies. One such powerful tool that transforms the way businesses…

    Automatic Call Logging, Better Customer Insights, Business Efficiency, Call Logging Experience, Click-to-Call Experience
    Variance InfoTech Dec 21, 2023
    1,796  Views
    Salesforce Inventory Management System

    Salesforce Inventory Management System : AI + Data-Driven Solutions

    Blog in Salesforce Products

    In the dynamic world of supply chain management, staying ahead means leveraging the latest technology to enhance efficiency, reduce costs, and improve customer satisfaction. The…

    Automated Replenishment, CRM+AI+Data, Data-driven Insights, E-Commerce Inventory, ERP Integration
    Kizzy Consulting Jul 2, 2024
    1,394  Views

    Popular Salesforce Videos

    Customize Salesforce in a Flash with Lightning

    Customize Salesforce in a Flash with Lightning

    Video in Salesforce customization

    This video shows you how to use Lightning App Builder to make page customizations without any code. This enables admins to tailor Lightning Experience for…

    Salesforce Online Training, Salesforce Lightning, Salesforce Lightning Experience, Salesforce Lightning Components, Salesforce Visualforce Page
    Pooja Jan 30, 2018
    2,243  Views
    4 Benefits of Salesforce Vlocity Communications Clouds

    4 Benefits of Salesforce Vlocity Communications Clouds

    Video in Salesforce Cloud Platform, Salesforce Training

    Vlocity Communications effortlessly collaborate with Salesforce Service Cloud to design a solution to garner personalized and uninterrupted experience for customers throughout their channels. This not…

    Salesforce Training, Salesforce Service Cloud, salesforce, Salesforce Video, Customers
    Cyntexa May 9, 2022
    2,806  Views
    How to Create Bulk Custom Fields in Salesforce using BOFC App | Salesforce | BOFC | AppExchange

    How to Create Bulk Custom Fields in Salesforce using BOFC App | Salesforce | BOFC | AppExchange

    Video in Salesforce Development

    Want to perform multiple operations? This quick video walks you through how to create mass custom fields of any type (Master Detail, Lookup, Formula, Primitive…

    Salesforce Field Objects, Salesforce Objects, Salesforce Fields, Salesforce Custom Objects, Salesforce BOFC
    Jogender Jan 12, 2020
    4,552  Views
    Footer Forcetalks logo

    support@forcetalks.com

    • twitterx

    Quick Links

    Advertise with Us

    Salesforce® Articles

    Dreamforce 2023

    Top Salesforce® Bloggers 2023

    Top Salesforce Consultants

    Get Listed

    Company

    Contact Us

    About Us

    Privacy Policy

    Terms & Conditions

    InsightHub

    Salesforce Blogs

    Salesforce Videos

    Salesforce Groups

    Salesforce Jobs

    © 2026 - Forcetalks ● All Rights Reserved

    Salesforce® is a trademark of Salesforce® Inc. No claim is made to the exclusive right to use “Salesforce”. Any services offered within the Forcetalks website/app are not sponsored or endorsed by Salesforce®.

    We use cookies to enhance your browsing experience. Please see our privacy policy if you'd like more information on our use of cookies.