Genesys Cloud - Main

 View Only

Sign Up

  • 1.  Practical Utility: Export Participant Data from Genesys Cloud Queue to Excel (Interactive Python Tool)

    Posted 21 days ago

    Hi everyone,

    I wanted to share a utility I recently built while working on contact center analytics and Architect-driven workflows, specifically around extracting participant data set within flows.

    The Problem:

    In many real-world implementations, we rely heavily on Set Participant Data in Architect to store:

    - CRM context (e.g., Salesforce URL pop / IDs)

    - Routing decisions and metadata

    - Authentication context

    - Bot / IVR interaction signals

    However, analyzing this data for a specific queue over time is not straightforward:

    - Standard reports don't expose participant attributes cleanly

    - Conversation structure (participants → sessions → segments) makes extraction tricky

    - Transfers and multiple queue segments create duplication challenges

    - Async analytics APIs require orchestration

    Solution:

    I created an interactive Python tool that leverages the Analytics Conversation Detail Jobs API to extract participant data in a structured and usable way.

    What the Tool Does:

    - Filters conversations by Queue ID

    - Extracts a specific Participant Data attribute

    - Supports auto-discovery of attribute names

    - Handles async job creation and polling

    - Flattens complex conversation structures

    - Exports results into an Excel workbook

    Key Features:

    - Interactive CLI

    - Queue validation (displays queue name)

    - Attribute discovery

    - Handles multi-segment conversations

    - Deduplicated and detailed outputs

    - Region-aware

    Output:

    The Excel file contains:

    - Results_Unique: One row per conversation ID + attribute value

    - Results_Detailed: Full breakdown (participants, sessions, segments)

    - Metadata: Query and job details

    Permissions Required:

    - Analytics > Conversation Detail > View

    - Analytics > Data Export > All

    - Reporting > CustomParticipantAttributes > View

    GitHub:

    Repository Link

    Use Cases:

    - Debugging Architect flows

    - Extracting CRM context

    - Auditing routing decisions

    - IVR/Bot analytics

    - Building analytics datasets

    Would love feedback:

    - Any improvements?

    - Other approaches?

    - Interest in UI version?

    Thanks!


    #Reporting/Analytics

    ------------------------------
    Vipin Kalra
    Lead Engineer
    ------------------------------


  • 2.  RE: Practical Utility: Export Participant Data from Genesys Cloud Queue to Excel (Interactive Python Tool)

    Posted 21 days ago

    Hello Vipin, 

    This is awesome and I know for a fact valuable. Set participant in architect can give even the most seasoned Genesys users a hard time. Thank you!

    Cheers,  



    ------------------------------
    Cameron
    Online Community Manager/Moderator
    ------------------------------



  • 3.  RE: Practical Utility: Export Participant Data from Genesys Cloud Queue to Excel (Interactive Python Tool)
    Best Answer

    Posted 21 days ago
    Edited by Jason Kleitz 3 days ago

    Really useful utility and a great example of how to export participant data from Genesys Cloud queues into Excel.

    It also looks like a helpful way to troubleshoot participant data in bulk without having to open individual interactions one by one and inspect them manually.

    You can also achieve some of this visibility using workflow notifications when working with triggers, but this approach makes it much easier to review and analyse the data in one place.

    Thank you for sharing@Vipin Kalra



    ------------------------------
    Phaneendra
    Technical Solutions Consultant
    ------------------------------



  • 4.  RE: Practical Utility: Export Participant Data from Genesys Cloud Queue to Excel (Interactive Python Tool)

    Posted 21 days ago

    Hi Vipin

    Interesting... I'll definitely run some tests. Thanks for sharing.



    ------------------------------
    Kaio Oliveira
    GCP - GCQM - GCS - GCA - GCD - GCO - GPE & GPR - GCWM

    PS.: I apologize if there are any mistakes in my English; my primary language is Portuguese-Br.
    ------------------------------



  • 5.  RE: Practical Utility: Export Participant Data from Genesys Cloud Queue to Excel (Interactive Python Tool)

    Posted 20 days ago

    hi Vipin, Thanks for sharing



    ------------------------------
    Cesar Padilla
    INDRA COLOMBIA
    ------------------------------



  • 6.  RE: Practical Utility: Export Participant Data from Genesys Cloud Queue to Excel (Interactive Python Tool)

    Posted 19 days ago

    Hi Vipin,

    Very useful. Thanks for sharing.



    ------------------------------
    Jyoti Sharma
    Senior Design Consultant
    ------------------------------