Send deliveries based on no.of clicks and opens using split

[ravitejagundu]

Hi All,

I want to send the deliveries to the customers based on previous emails tracking stats.

I have two scenarios here:

1) Send a mail to customers who opened the mail and clicked on the link

2) Send a mail to customers who opened the mail but not clicked on the link

And we need to filter the people who did not open the email.

I think, we can achieve this by using split activity and Query activity. But, which schema we need to use for Targeting and Filter dimension in Query and Split activity.

And my workflow is as follows. 

Please help me on this.

Thanks,

Raviteja Gundu.

[ravitejagundu]

Hi all,

Continuing the above post, i tried with Deliveries in both Targeting and Filtering dimension. And using attributes Total no. of opens and Total no. of clicks in the Indicators of Delivery.. I am not getting the expecting result. Every result is going to refused part only. The result is not coming in Opens part of split. Please look into below screenshot.

But i opened the email and clicked on the links for some deliveries. Those are not coming into second set. Please help me on this.

Thanks,

Raviteja.

[Amit_Kumar]

Hi Ravi,

please follow these steps.

1.

2.

3.

4.

5.

Hope this help!

order in the split is mandatory to have proper results.

Regards,

Amit

[ravitejagundu]

Hi Amit,

I tried your suggestions. But not getting the results in preview panel

Please find below screenshots

1)

2)

3)

In the second screenshot, the label of URL means what we need to give in the value place?

Please let me know, if i am doing any wrong here.

Thanks,

Raviteja.

[Amit_Kumar]

Hi Raviteja,

label value should be equal/contain to the label in your tracking url link, check if you are using the correct link label condition.

[ravitejagundu]

Hi Amit,

Thanks for your suggestions.

Please find the below screen shots and let me know, where am i doing mistakes.

1)

2)

3)

4)

5)

6)

I opened few emails and clicked on the link. I am not getting the population itself from query.

Thanks,

Raviteja

[Amit_Kumar · Accepted solution]

Hi Raviteja,

your query looks correct to me!

can you share the screenshot from logs?

it seems you do not have any tracking logs for delivery.

check if Tracking Technical workflow is running?

[ravitejagundu]

Hi Amit,

Thanks for your suggestion.

Yes, my tracking workflow in in pause mode. Just now i started. It displayed some logs in delivery logs. Before, it didn't shown these logs.

One more doubt, how much time it will take to update here? Because i just opened email and clicked on url which was sent 2 days back apart from the above the users.

And i sent this mail to 4 users, but query is resulting only one recipient. Is there any specific reason?

Thanks,

Raviteja.

[Amit_Kumar]

Hi Raviteja,

if you want to get all the users who opened or clicked than you need to remove the label condition and use only the delivery internal name criteria in your filter query and you will get all users. I can see in your logs you will get 2 users. usually, technical logs are updated every 1 hour if your workflow is up and running.

Regards,

Amit

[ravitejagundu]

Hi Amit,

Thanks, the suggestion is working.

For 2 recipients i opened and clicked on the link. For 1 recipient i opened the email but not clicked on link. These tracking details i am getting perfectly.

But i am missing the 4th recipient which I didn't open the mail till now. Please let me know, how to get that details also. And let me know how to get those 4th receipient details in split action also.

Thanks,

Raviteja.

[Amit_Kumar]

But that's not what you asked in the question. 4th will be available when he/she open/clicks the email.

To get all users you need to use the broadlog in the base query with a filter as delivery internal name and status equal to sent and use tracking logs in the split to check if they exist a record.