Adding profile count as additional data element. | Community
Skip to main content
bartt53947430
bartt53947430
Level 2
March 11, 2019
Solved

Adding profile count as additional data element.

  • March 11, 2019
  • 3 replies
  • 5009 views

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.
    Best answer by vraghav

    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

    3 replies

    vraghav
    Adobe Employee
    vraghavAdobe EmployeeAccepted solution
    Adobe Employee
    March 12, 2019

    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

      bartt53947430
      bartt53947430Author
      Level 2
      March 12, 2019

      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

      El_Loco
      El_Loco
      Level 5
      March 12, 2019

      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.

      Terms & ConditionsAccessibility statement

      Loading footer...