Please let me know how i can get the contacts whose not submitted subscription form.

Answered

Comments

5 comments

  • Avatar
    Rhys Saraceni

    Hello Mohammad

    Unfortunately, CRM does not really support looking for records that do NOT exist, so the process for generating this list will be a bit roundabout. Instead of looking for people who did not submit the form, it will be easier to start with a list of everybody that received the email and remove the people that did submit the form. I would recommend creating a static copy of the marketing list you sent to, then use Manage Members > Remove Members using an Advanced Find to remove any members who have an associated open email event for your email and who also have an associated posted form record for your form. This will leave a list of recipients who did not open the email or submit the form.

    I have attached a screenshot of an example advanced find.

    example_advanced_find.png

  • Avatar
    Mohammad Sharique

    Hi Rhys Saraceni,

    Thanks for your help, but i want to show this data in a view in CRM so please let me know how can.

  • Avatar
    Rhys Saraceni

    Hello Mohammad

    Unfortunately, my point about CRM's difficulty with querying things that do not exist applies to both marketing lists and views. As such, you could make a view of these contacts who received your email but didn't open it or submit your form by setting the view to only show members of the marketing list created in my previous response.

     

  • Avatar
    Mohammad Sharique

    Hi Rhys Saraceni,

    I didn't understand completely, can you please explain more me that can we show the records those are opened the link but not submitted the form.

    If yes so please let me know how?

     

  • Avatar
    Matt Privateer

    Hi Mohammad,

    Using Rhys' Advanced Find above, you will remove any members returned through the advanced find.  The remaining members of the marketing list will be who you create the view off of.  These will be people who did not open your email or have a posted form record for the specified form.

    Kind Regards,

    Matt

Please sign in to leave a comment.