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

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

5 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

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

query

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar
Boost 5
Employee
denisb91363072
Employee

Likes

6 likes

Total Posts

28 posts

Correct Reply

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

Avatar
Boost 5
Employee
denisb91363072
Employee

Likes

6 likes

Total Posts

28 posts

Correct Reply

5 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