Expand my Community achievements bar.

SOLVED

Subscriptions in ACS

Avatar

Level 9

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? 

 

 

 

 

1 Accepted Solution

Avatar

Correct answer by
Level 3

@mmbb110 You need to base your query on the subscription history ressource not Profile :

 

anasso83525035_0-1602159673303.png

Conditions are : 

anasso83525035_1-1602159808545.png

 

Then dedup on the temporary ressource :

 

anasso83525035_3-1602159912513.png

 

This should work.

 

 

 

View solution in original post

5 Replies

Avatar

Level 3

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.

 

Avatar

Level 9

That sounds great, I will check and let you know the results.

Avatar

Level 9

@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.

 

servicedashboard.JPG

 

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.

 

workflow.JPGworkflow2.JPG

 

 

Avatar

Correct answer by
Level 3

@mmbb110 You need to base your query on the subscription history ressource not Profile :

 

anasso83525035_0-1602159673303.png

Conditions are : 

anasso83525035_1-1602159808545.png

 

Then dedup on the temporary ressource :

 

anasso83525035_3-1602159912513.png

 

This should work.