Count the Total of specific values in {{webResponse}}

Matthew Challenger

Looking for a bit of assistance here. I can't seem to get this working.

My use-case is click data from marketing emails. I'm trying to update a field with the # of unique (distinct) link clicks of a particular link.

I'm using an API call to return all click data in a {{webResponse}} object.

 

The response data looks something like this: 

 

"ClickData": [
    
    {
      "UserEmail": "test1@gmail.com",

      "LinkUrl": "https://www.google.com/",
      
      "Click Date": "2024-01-01"

    },

    {

      "UserEmail": "test1@gmail.com",

      "LinkUrl": "https://www.google.com/",

      "Click Date": "2024-01-01"

    },

    {

      "UserEmail": "test2@gmail.com",

      "LinkUrl": "https://www.google.com/",

      "Click Date": "2024-01-01"

    },

    {

      "UserEmail": "test2@gmail.com",

      "LinkUrl": "https://www.adobe.com/",

      "Click Date": "2024-01-01"
    },

    {

      "UserEmail": "test3@gmail.com",

      "LinkUrl": "https://www.apple.com/",

      "Click Date": "2024-01-01"
    }

]

Now imagine I want to count all unique clicks on "www.google.com" from users. My expected value would be 2, since test1@gmail.com (clicked twice, but should count only once) and test2@gmail.com were the distinct contacts that clicked on the link.

Any thoughts on how to accomplish this?

I've tried different approaches of variables, functions and advanced branching but nothing seems to work.

Vikrant Yadav

Hi @Matthew Challenger  For getting the count of an email address from a JSON response, you can use this smartvalue : 

{{webhookData.ClickData.UserEmail.match(".*(test1@gmail.com).*").size}}

 

It gives count result : 2. Count number of times test1@gmail.com comes in a JSON body.