Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Count the Number of Opens/Clicks per recipient

Avatar

Level 2

Hi, 

 

I've seen a few similar posts but none really get to what I need.

 

I'm hoping to segment customers based on their engagement i.e. Opened X times = High etc. For this I hoped to have each recipeint with the number of opens/clicks pull through for a particular time period.

 

Example query I'd like to use to split contacts: number of opens greater than X

 

When trying to get the count of opens/clicks by recipient I can't seem to find what i need.

 

I'm doing this in a workflow and have tried Count([url/@type]=1) for clicks and grouping by recipient PK. 

 

How would you achieve this?

 

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

Something like this??

 

David__Garcia_0-1638426319802.png

Query the Recipient tracking logs (nms) nms trackingLogRcp

 

David__Garcia_2-1638426557299.png

David__Garcia_3-1638426632053.png

 

Here is the XML configuration of the activity

 

 

    <query collision="0" distinct="true" img="nms:activities/query.png" keepAllExtraData="false"
           label="undefined" mask="0" name="queryCountURL" noAutoPk="true" noAutoPkFilter="0"
           onError="0" recipientLink="" runOnSimulation="true" schema="nms:trackingLogRcp"
           timezone="_inherit_" useSource="0" x="520" y="80">
      <transitions>
        <result enabled="true" label="Result" name="result" x="670" y="104"/>
      </transitions>
      <select>
        <node alias="@recipient" analyze="false" expr="[@recipient-id]" groupBy="1"
              label="recipient"/>
        <node alias="@count" analyze="false" expr="count([url/@type])" groupBy="0"
              label="Count"/>
        <node alias="@urlType" analyze="false" expr="[url/@type]" groupBy="1" label="Type (Url)"/>
      </select>
      <where displayFilter="undefined" filterName="backGroundFilterFrm" id="1663107605"/>
      <outputFilter displayFilter="count greater than 2 and type (Url) equal to Open">
        <condition boolOperator="AND" compositeKey="" dependkey="" enabledIf="" expr="@count &gt; 2"
                   internalId="1733493285"/>
        <condition compositeKey="" dependkey="" enabledIf="" expr="@urlType = 2"
                   internalId="1742864937"/>
      </outputFilter>
      <humanCond>Query: undefined</humanCond>
    </query>

 

 

 

View solution in original post

2 Replies

Avatar

Correct answer by
Employee Advisor

Something like this??

 

David__Garcia_0-1638426319802.png

Query the Recipient tracking logs (nms) nms trackingLogRcp

 

David__Garcia_2-1638426557299.png

David__Garcia_3-1638426632053.png

 

Here is the XML configuration of the activity

 

 

    <query collision="0" distinct="true" img="nms:activities/query.png" keepAllExtraData="false"
           label="undefined" mask="0" name="queryCountURL" noAutoPk="true" noAutoPkFilter="0"
           onError="0" recipientLink="" runOnSimulation="true" schema="nms:trackingLogRcp"
           timezone="_inherit_" useSource="0" x="520" y="80">
      <transitions>
        <result enabled="true" label="Result" name="result" x="670" y="104"/>
      </transitions>
      <select>
        <node alias="@recipient" analyze="false" expr="[@recipient-id]" groupBy="1"
              label="recipient"/>
        <node alias="@count" analyze="false" expr="count([url/@type])" groupBy="0"
              label="Count"/>
        <node alias="@urlType" analyze="false" expr="[url/@type]" groupBy="1" label="Type (Url)"/>
      </select>
      <where displayFilter="undefined" filterName="backGroundFilterFrm" id="1663107605"/>
      <outputFilter displayFilter="count greater than 2 and type (Url) equal to Open">
        <condition boolOperator="AND" compositeKey="" dependkey="" enabledIf="" expr="@count &gt; 2"
                   internalId="1733493285"/>
        <condition compositeKey="" dependkey="" enabledIf="" expr="@urlType = 2"
                   internalId="1742864937"/>
      </outputFilter>
      <humanCond>Query: undefined</humanCond>
    </query>