Hi Community,
For one of my client I am trying to check the total count of unsubscribed for a particular service. I am seeing some discrepancies in the count received and would like to know why?
Via audience using type as query , I created an audience and used the below elements,
subscription = exists and service =xyz and action unsubscribe.
I get a count of 100 (example)
Now, when I check for this same division in the service dashboard and select action as unsubscribe the count is higher.
This higher count is seen for the other services as well.
Is there any reason why the service dashboard shows a higher count? Or is my query incorrect?
Solved! Go to Solution.
Views
Replies
Total Likes
@mmbb110 You need to base your query on the subscription history ressource not Profile :
Conditions are :
Then dedup on the temporary ressource :
This should work.
Hello @mmbb110,
The explanation is simple :
In your Audience Query, you have the number of profiles who unsubscribed from the service.
In the Subscription history tab of your service, you can have multiple unsubscription records for the same profile, thus the higher count. A deduplication based on the email address will give you the same count as your Audience query.
Views
Replies
Total Likes
That sounds great, I will check and let you know the results.
Views
Replies
Total Likes
@anasso83525035I get the logic that you stated where I can have multiple unsub records for the same profile, I am trying to validate this for my case, In the service dashboard I don't have an option to dedupe based on email address, so I think I need to use a workflow instead? may be I am doing it wrong.
I have attached the workflow example. I created a query and deduped on email, the count is much lower than I received earlier. In the service dashboard count = 786, query count = 735. I think I am missing something but can't figure this out.
Views
Replies
Total Likes
@mmbb110 You need to base your query on the subscription history ressource not Profile :
Conditions are :
Then dedup on the temporary ressource :
This should work.
Views
Replies
Total Likes