How to count a shared audience population in a workflow?

Avatar

Avatar
Validate 1
Level 1
vitor_d
Level 1

Likes

0 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
vitor_d
Level 1

Likes

0 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
vitor_d
Level 1

20-04-2021

When I open a Shared Audience, I usually go to Content > Data and click the counter button to get a preview of the population size. Unfortunately, I noticed that the population size there is not correct, since a few old audiences show more than 17 million recipients, but when I query them I get around 200k recipients.

 

I am looking forward to automate the count of all my audiences to generate a report, but I honestly don't want to load each of them to generate a count. I was looking forward to build a query in a workflow capable of counting all of these audiences without having to load them. I also noticed that these audiences are stored in tables such as grp3495361793.

 

Could somebody point me towards a direction on how I should do this? Where do I find this table name? How do I query it? Or maybe if there is a better alternative I am missing?

 

Thanks in advance.

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar
Boost 5
Employee
denisb91363072
Employee

Likes

8 likes

Total Posts

33 posts

Correct reply

6 solutions
Top badges earned
Boost 5
Affirm 5
Boost 3
Boost 1
Affirm 3
View profile

Avatar
Boost 5
Employee
denisb91363072
Employee

Likes

8 likes

Total Posts

33 posts

Correct reply

6 solutions
Top badges earned
Boost 5
Affirm 5
Boost 3
Boost 1
Affirm 3
View profile
denisb91363072
Employee

22-04-2021

Hi,

Try to query the Audience entity, it also contains a count, however depending how your audience is updated, we might have a cumulated count. It worth a try

Thanks

Denis

denisb91363072_0-1619094848435.png