Adding profile count as additional data element. | Community
Skip to main content
bartt53947430
bartt53947430
Level 2
Mar 11, 2019 3:24 PM UTC
Solved

Adding profile count as additional data element.

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

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    vraghav
    vraghavAccepted solution
    Employee
    Mar 12, 2019 12:18 AM UTC

    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 reply

    3 replies

    El_Loco
    El_Loco
    Level 5
    Mar 12, 2019 3:25 PM UTC

    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.

    Translate
    bartt53947430
    bartt53947430Author
    Level 2
    Mar 12, 2019 7:41 AM UTC

    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

    Translate
    vraghav
    vraghavAccepted solution
    Employee
    Mar 12, 2019 12:18 AM UTC

    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

    Translate
      Terms & ConditionsAccessibility statement

      Loading footer...