Expand my Community achievements bar.

Exporting multiple query counts into one CSV file

Avatar

Level 1

I have a workflow with multiple queries for counts and I would like to export all of these to one CSV.
All I need to have is the name of each query and it's associated count.

Step by step guide please as still fairly new to this.

Thank you.

 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Community Advisor

@CliveFo 

  • In the additional data section of each query activity, utilize the count function to retrieve the number of records, assigning a label that matches the query criteria.
  • Connect the outbound transition of all the query activities to AND-join
  • Connect the outbound transition of AND-join with the extract file activity.
  • Set up the Extract file activity using the count expressions you've included in the additional data section of each query activity.

Have a look at this documentation,

How to additional data on query activity - https://experienceleague.adobe.com/en/docs/campaign-standard/using/managing-processes-and-data/targe...

How to use the AND-join,

https://experienceleague.adobe.com/en/docs/campaign-standard/using/managing-processes-and-data/execu...

How to use the extract file activity,

https://experienceleague.adobe.com/en/docs/campaign-standard/using/managing-processes-and-data/data-...

List of functions,

https://experienceleague.adobe.com/en/docs/campaign-standard/using/managing-processes-and-data/filte...

Thanks, Sathees