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