Query tracking and delivery logs | Community
Skip to main content
S
Sebastiancm1
Level 2
August 28, 2019
Solved

Query tracking and delivery logs

  • August 28, 2019
  • 2 replies
  • 4061 views

Hi all,

I have a question regarding query of logs. Is it possible to query profiles who have received for example 10 emails (have 10 delivery log ID's on the sending/delivery log)  or clicked in 5 emails (have 5 tracking logs) etc in ACS? I can't find any way to do it without having to extract the data into excel and then do some work in there. But it would be much easier if there happened to be a way in the system, maybe with advanced expression were it could be done.

Thank you in advance!

All the best,

Sebastian

    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 kpottsadb

    Hi Sebastian,

    A few options exist in ACS that will allow us to 'aggregate' records on a table, specifically the delivery and tracking log tables.

    - The first method is to Enrich your query using Additional Data.  Here you will query the profile table to return the target profiles you would like to review and configure 'Additional Data'.  Under additional data, create an element and select the log table (delivery or tracking).  After this selection you will land on a screen that allows you to select aggregate or collection - in this case you want to choose aggregate.  Configure the aggregate as a distinct count and choose an attribute on the log table, such as event date.  Once you have your aggregate values you will then need to filter/segment for profiles that have 10 or greater.

    - The second method is to write a query on the profile resource.  The condition should select the log table and the filter should be changed from Exists to Count.  Then you can add the logical operator to get the 'count' that you need.

    -KP

    2 replies

    K
    Adobe Employee
    kpottsadbAdobe EmployeeAccepted solution
    Adobe Employee
    September 6, 2019

    Hi Sebastian,

    A few options exist in ACS that will allow us to 'aggregate' records on a table, specifically the delivery and tracking log tables.

    - The first method is to Enrich your query using Additional Data.  Here you will query the profile table to return the target profiles you would like to review and configure 'Additional Data'.  Under additional data, create an element and select the log table (delivery or tracking).  After this selection you will land on a screen that allows you to select aggregate or collection - in this case you want to choose aggregate.  Configure the aggregate as a distinct count and choose an attribute on the log table, such as event date.  Once you have your aggregate values you will then need to filter/segment for profiles that have 10 or greater.

    - The second method is to write a query on the profile resource.  The condition should select the log table and the filter should be changed from Exists to Count.  Then you can add the logical operator to get the 'count' that you need.

    -KP

      S
      Sebastiancm1Author
      Level 2
      September 10, 2019

      Hi,

      Thank you very much. Super helpfull!

      /Sebastian

      Terms & ConditionsAccessibility statement

      Loading footer...