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

Adding profile count as additional data element.

bartt53947430
Level 2
Level 2

Hi Everybody,

I want to send an email that includes a count of profiles that satisfy specific criteria. 

Is it possible to create an additional data element, that counts the number of profiles in a query and include this in an email to a specific address?

For example run a query that selects all profiles which have been modified in the last 30 days.  Count the number of profiles and include this number in a scheduled email?

Kind regards,

Bart

1 Accepted Solution
Vapsy
Correct answer by
Employee
Employee

Hi bartt53947430,

Please confirm if this query is for ACC or ACS. This is doable on ACC.

Right after the query activity you can make use of a JS code activity where you define an intance variable and populate it with record count

instance.vars.profileCount = vars.recCount

Then use this instance variable to pass it over to a delivery variable and use in personalisation.

Regards,
vipul

View solution in original post

3 Replies
Vapsy
Correct answer by
Employee
Employee

Hi bartt53947430,

Please confirm if this query is for ACC or ACS. This is doable on ACC.

Right after the query activity you can make use of a JS code activity where you define an intance variable and populate it with record count

instance.vars.profileCount = vars.recCount

Then use this instance variable to pass it over to a delivery variable and use in personalisation.

Regards,
vipul

View solution in original post

bartt53947430
Level 2
Level 2

Hi Vipul,

The solution needs to be created for ACS.

I thought it might be possible, as the "count" function seems to be supported.  Am I right?

Many thanks,

Bart

bobbyjss
Community Advisor
Community Advisor

I've noticed the count function is available if you add Additional data to a query from an alternative data schema, but I'm not sure how to make this work for the native(profile) schema.

We'd find this functionality useful too so I'm keen to find out if it's possible too.