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

    Overcoming 5 Biggest Salesforce Integration Challenges

    Blog in Salesforce integration

    Salesforce is a powerful tool that lets companies create a 360-degree view of their customers and business. Integration with other databases can further enhance the…

    AppExchange, Applications, Apps, Apps on AppExchange, Business Needs
    Carol Jan 19, 2022
    6,540  Views

    Guided Selling in Salesforce for Sales Reps in 2024

    Blog in Salesforce Cloud Platform

    Guided selling is a game-changing approach that streamlines the sales process by swiftly identifying customer needs and aligning them with company objectives. Data backs the…

    Automated Quotes, Business Processes, Buying Experience, Configure Price Quote, CPQ
    Sculptor CPQ May 2, 2024
    843  Views

    How Salesforce Einstein Works for FinTech: Features & Benefits Overview

    Blog in Salesforce Einstein

    67% of respondents consider artificial intelligence to be a top technology that will influence fintech over the decade. At the forefront of fintech's dynamic progress, Salesforce…

    Behavioral Analysis, Churn Prediction, Common Practices, Compliance Gaps, Customer Profiling
    Sparkybit Mar 27, 2024
    1,436  Views

    Popular Salesforce Videos

    Can I Get a Job by Just Learning Salesforce Admin?

    Can I Get a Job by Just Learning Salesforce Admin?

    Video in Salesforce Training, Salesforce Admin

    In this Video Shrey covered the following questions: 1. Can I get a job by just learning Salesforce Admin? 2. Can you start a career…

    Salesforce Training, Salesforce Tutorial, salesforce, Salesforce Admin, Salesforce Video
    Abhishek Oct 18, 2021
    2,662  Views
    5 Steps to Faster Case Resolution | Salesforce Support

    5 Steps to Faster Case Resolution | Salesforce Support

    Video in Salesforce Stories

    When it comes to filling out a Salesforce case from, the description field and attached files are key to fast routing and resolution. Here are…

    Salesforce Training, Salesforce Tutorial, salesforce, Salesforce Video, Salesforce Learning
    Abhishek Feb 11, 2022
    2,064  Views
    What is Audit Trail in Salesforce?

    What is Audit Trail in Salesforce?

    Video in Others

    The Setup Audit Trail feature in Salesforce enables you to closely track changes made to your organization. It records all modifications concerning the administration, customization, security,…

    Salesforce Video, Salesforce Organization, Salesforce Learning, Data Management, Development
    CRS Dec 21, 2021
    1,443  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.