3 Replies Latest reply on Aug 19, 2016 11:35 AM by Andrew Watson

    How to subset contacts based on their inclusion in a campaign

    Nikita Goldovsky
      Contact IDCampaignIsInCampaignA?
      123ATRUE
      123BTRUE
      456BFALSE

       

       

      My data set is composed of contacts who interact with various campaign. Each contact can be part of multiple campaigns.

       

      How do I flag all contacts who are part of a specific campaign (campaign A in my example) as TRUE in a third column across all the instances of the contact ID (including the rows where the contact is interacting with other campaigns (campaign B in my example)? 

       

      Thank you for your help.