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, 3 months ago by  Nitish.
      • This discussion was modified 10 years, 2 months ago by  Forcetalks.
      • This discussion was modified 10 years, 2 months ago by  Forcetalks.
      Gourav replied 10 years, 3 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 HelpRange Integration

    Salesforce HelpRange Integration: A Detailed Overview

    Blog in Salesforce

    As we all know, security is the most important consideration in any organization. For example, if any person outside of the organization (Org) has access…

    API, API key, API Request, API Tool, CSV File
    SP Apr 28, 2022
    3,330  Views

    Benefits of Salesforce Custom Development in 2024| Greytrix

    Blog in Others

    Whether you agree with me or not, Salesforce is among the most potent CRM solutions on the market. With its many amazing features, functionalities, and…

    CRM Custom Development, CRM Development, Custom Business Solutions, Custom CRM, Custom CRM Development
    Greytrix May 21, 2024
    949  Views
    sales cloud vs service cloud

    Sales Cloud Vs Service Cloud: What are the Key Difference?

    Blog in Salesforce Cloud Platform

    No Salesforce Service Cloud Solution would be complete without its sales cloud counterpart. They are all part of the Salesforce platform and are essential modules…

    Best Experience, Client Records, Clients, Cloud Basic, Company
    Dave Mar 18, 2021
    3,031  Views

    Popular Salesforce Videos

    What is Dreamforce? | Salesforce Explained

    What is Dreamforce? | Salesforce Explained

    Video in Salesforce Stories

    Dreamforce has been coined “the world’s largest tech conference” and is a massive streaming moment on Salesforce+, but what actually takes place at this iconic…

    Salesforce Training, Salesforce Tutorial, dreamforce, salesforce, Salesforce Learning
    Nauman Aug 30, 2022
    1,944  Views
    How to Execute a SOQL Query in POSTMAN?

    How to Execute a SOQL Query in POSTMAN?

    Video in Salesforce Training

    Watch this video to learn how to execute a SOQL Query in POSTMAN. If you have any doubts or questions, let us know in the…

    Salesforce Training, Salesforce Tutorial, Salesforce Video, Salesforce Learning, Postman
    Rupal Kakkar Jun 28, 2021
    3,151  Views
    Streamline Sales Goals and Add Value to Your B2B Organization With Salesforce Marketing Automation

    Streamline Sales Goals and Add Value to Your B2B Organization With Salesforce Marketing Automation

    Video in Salesforce Products

    Salesforce Marketing Automation enables businesses to automate marketing processes, track customer engagement while delivering personalized experiences to each customer. With it, you can streamline and…

    Salesforce Training, Salesforce Developer, Customer Engagement, Salesforce Video, Salesforce Learning
    Kcloud Dec 16, 2020
    2,293  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.