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
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Subscriptions in ACS

mmbb110
Level 8
Level 8

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
anasso83525035
Correct answer by
Level 3
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
anasso83525035
Level 3
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.

 

mmbb110
Level 8
Level 8

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

mmbb110
Level 8
Level 8

@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

 

 

anasso83525035
Correct answer by
Level 3
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