report the number contacts uploaded and number of emails sent in a (standalone workflow) | XM Community
Skip to main content

HI All,

 

Following the migration from the old world of Directory > automations (where I used an SFTP process to import a file of contacts and distribute a survey).  The screens / reports I get / can see no longer provide the number of lines imported and the number of surveys sent.  Is this something I can get to using piped text or something in the flow?  I used to review the reports for both import and distribution pages and from that I could easily see if the values matches or (on some occasions) were massively different (we have had three occasions this year now where double the number of surveys have been sent due to issues with Qualtrics’ internal systems repeating the send process for some unknown reason!).

 

Any thoughts or suggestions (piped text / undisclosed embedded fields / API calls or a code task that could loop through and count even!) would be most helpful

 

Thanks

 

Rod Pestell

 

 

I think you can use an Email Task to retrieve the Run Summary Report by piping in the text from the previous task.

Migrating Automations to XM Directory Workflows


Thanks for the idea ​@PraDeepKotian_XM .  The piped text reported only gives you the number of contacts inported from say the csv file.  The distribution part only gives ids and no other info.  So I did a bit of investigation and found that I could get the list of contacts sent an email using the API call: https://fra1.qualtrics.com/API/v3/distributions/EMD_xxxxxxx/history in a webservice task.  This is paginated though and so although I’ve managed to create a custom path to get the revised URL to receive the next page of contacts, I am stuck on how I a) create a for each loop within the workflow and based on a webservice task as the starting point, b) concatenating each page’s results together and finally c) count all the elements in order to get a final count of emails sent.

 

Any ideas on this?

 

Thanks

 

Rod Pestell