MS Teams - UC Analytics Copilot on the GPT Store

Introduction to MS Teams - UC Analytics Copilot

GPT Description

GPT Prompt Starters

• /optimize PSTN Logs
• /impress me with your skills; You are the visualization expert; I love beautiful visuals for trend analysis and insights into performance optimization. Refer to the {Microsoft Teams dataset data dictionary} for guidance. Microsoft Teams dataset data dictionary: ``` ### 1. **Auto Attendant Table** | Field Name | Data Type | Description | Example Value | |-----------------------------------|-------------|--------------------------------------------------------------|---------------------------------------------| | `DocumentId` | String | Unique identifier for the document | `ca783718-03ec-4d3c-8b9e-0c54989eafd7` | | `ConferenceId` | String | Conference identifier associated with the call | `1f23e484-5fb6-4fe3-bc15-cbe35944eb29` | | `DialogId` | String | Dialog identifier for the session | `040bf508-7a14-4f46-b654-d86326f5459a` | | `UserStartTimeUTC` | DateTime | Start time of the user's interaction with Auto Attendant | `07/25/2023 08:51:40 PM` | | `EndTime` | DateTime | End time of the call | `07/25/2023 10:03:40 PM` | | `Duration` | Integer | Duration of the call in seconds | `2545` | | `AutoAttendantChainStartTime` | DateTime | Start time of the call chain in Auto Attendant | `07/25/2023 09:10:40 PM` | | `AutoAttendantIdentity` | String | Identity of the Auto Attendant | `AA42_Tokyo_Japan_AA@abc.com` | | `AutoAttendantDirectorySearchMethod` | String | Method used for directory search (if applicable) | `Voice` or `DTMF` | | `AutoAttendantTransferAction` | String | Action taken to transfer the call | `unknown` | | `AutoAttendantCallResult` | String | Final result of the call in Auto Attendant | `external_pstn` | | `AutoAttendantChainDuration` | Integer | Total duration in the Auto Attendant | `120` | | `AACallerActionCount` | Integer | Number of actions taken by the caller | `2` | ### 2. **Call Queue Final State Action Table** | Field Name | Data Type | Description | Example Value | |-----------------------------------|-------------|--------------------------------------------------------------|---------------------------------------------| | `DocumentId` | String | Unique identifier for the document | `ca783718-03ec-4d3-8b9e-0c54989eafd7` | | `ConferenceId` | String | Conference identifier associated with the call | `1f23e484-5fb6-4fe3-bc15-cbe35944eb29` | | `DialogId` | String | Dialog identifier for the session | `040bf508-7a14-4f46-b654-d86326f5459a` | | `UserStartTimeUTC` | DateTime | Start time of the user's interaction with Call Queue | `07/25/2023 08:51:40 PM` | | `EndTime` | DateTime | End time of the call | `07/25/2023 10:03:40 PM` | | `Duration` | Integer | Duration of the call in seconds | `2545` | | `Call Queue Identity` | String | Identity of the Call Queue | `SupportQueue` | | `Call Queue Final State Action` | String | Final state action taken in the Call Queue | `transferred_to_user` | | `IsAbandoned` | Boolean | Indicates if the call was abandoned | `True` or `False` | ### 3. **Graph Users Table** | Field Name | Data Type | Description | Example Value | |-----------------------------------|-------------|--------------------------------------------------------------|---------------------------------------------| | `AADObjectId` | String | Azure Active Directory Object ID | `c8e63510-867c-402a-8f12-fa4d7de57dab` | | `UPN` | String | User Principal Name (email format) | `clayton.adams@abc.com` | | `UserDisplayName` | String | Display name of the user | `Clayton Adams` | | `CallType` | String | Type of call (e.g., unassigned_in, user_out) | `unassigned_in` | | `NumberType` | String | Type of phone number (e.g., Subscriber, Service) | `Subscriber` | | `DestinationDialed` | String | Country or region dialed | `BR` | | `DestinationNumber` | String | Destination phone number in E.164 format | `+553473085954` | | `Currency` | String | Currency used for calculating the cost of the call | `USD` | | `Charge` | Double | Cost of the call charged to the account | `0.0` | | `Operator` | String | Operator providing the PSTN services | `Microsoft` | | `SourceCallDuration` | Float | Duration of the call as recorded by the source | `1277.0` | | `CallerID` | String | Caller ID in E.164 format | `+984564285885` | | `DomesticInternational` | String | Whether the call was Domestic or International | `International` | ### 4. **Graph Direct Routing Calls Table** | Field Name | Data Type | Description | Example Value | |-----------------------------------|-------------|--------------------------------------------------------------|---------------------------------------------| | `startDateTime` | DateTime | Start date and time of the call | `07/25/2023 08:51:40 PM` | | `successfulCall` | Boolean | Indicates whether the call was successful | `True` | | `duration` | Integer | Duration of the call in seconds | `2545` | | `callerNumber` | String | Caller phone number in E.164 format | `+984564285885` | | `calleeNumber` | String | Callee phone number in E.164 format | `+553473085954` | | `finalSipCode` | Integer | Final SIP code for the call | `200` | | `userId` | String | Unique identifier for the user involved in the call | `c8e63510-867c-402a-8f12-fa4d7de57dab` | | `callType` | String | Type of the call (e.g., user_out, conf_in) | `user_out` | | `mediaPathLocation` | String | Location of the media path | `Central Europe` | | `signalingLocation` | String | Location of the signaling path | `Central Europe` | | `finalSipCodePhrase` | String | Phrase associated with the final SIP code | `OK` | | `trunkFullyQualifiedDomainName` | String | Fully qualified domain name of the trunk used | `trunk01.company.com` | | `mediaBypassEnabled` | Boolean | Indicates whether media bypass was enabled | `True` | ### 5. **Call Queue Analytics Table** | Field Name | Data Type | Description | Example Value | |-----------------------------------|-------------|--------------------------------------------------------------|---------------------------------------------| | `Duration` | Integer | The total duration of the call in seconds | `600` | | `CQ Name` | String | Name of the Call Queue | `SalesQueue` | | `Call Count` | Integer | Total number of calls in the queue | `100` | | `Call Start Time UTC` | DateTime | UTC start time of the call | `2024-09-01T12:00:00` | | `Call End Time UTC` | DateTime | UTC end time of the call | `2024-09-01T12:10:00` | | `Call Queue Agent Count` | Integer | Number of agents available in the call queue | `5` | | `Call Queue Call Result` | String | Final result of the call (e.g., completed, missed) | `completed` | | `PSTN Total Minutes` | Integer | Total minutes of PSTN usage | `10` | | `Call Queue Target Type` | String | Target type within the call queue | `Agent` | ### 6. **Graph User Activity Detail Table** | Field Name | Data Type | Description | Example Value | |-----------------------------------|-------------|--------------------------------------------------------------|---------------------------------------------| | `UserId` | String | Unique identifier of the user | `c8e63510-867c-402a-8f12-fa4d7de57dab` | | `UserStartTimeUTC` | DateTime | Start time of the user's activity in UTC | `2023-07-25 08:51:40 PM` | | `UserEndTimeUTC` | DateTime | End time of the user's activity in UTC | `2023-07-25 10:03:40 PM` | | `ActivityType` | String | Type of activity performed by the user | `Call` | | `DurationSeconds` | Integer | Duration of the activity in seconds | `2545` | | `DeviceType` | String | Type of device used for the activity (e.g., Desktop, Mobile) | `Desktop` | | `NetworkType` | String | Network type used during the activity (e.g., Wi-Fi, Wired) | `Wi-Fi` | | `Location` | String | Physical or logical location of the user during activity | `Office` | | `CallResult` | String | Result of the call activity | `Completed` | | `MediaBypassEnabled` | Boolean | Indicates if media bypass was enabled during the activity | `True` | ### 7. **Agent Timeline Analytics Table** | Field Name | Data Type | Description | Example Value | |-----------------------------------|-------------|--------------------------------------------------------------|---------------------------------------------| | `UserStartTimeUTC` | DateTime | The UTC start time of the agent's activity | `07/25/2023 21:49:32 PM` | | `Hour` | Integer | The hour of the day when the interaction started | `21` | | `ConferenceId` | String | Unique identifier for the conference call | `e9104742-d473-4ed4-b1df-2c5ed6eab138` | | `FirstUPN` | String | User Principal Name of the first agent in the interaction | `paul.butler@abc.com` | | `FirstIsCaller` | Boolean | Indicates if the first agent is the caller | `True` | | `SecondUPN` | String | User Principal Name of the second agent (if applicable) | `heather.miller@abc.com` | | `TransferredFromCallQueueIdentity`| String | Identity of the call queue the call was transferred from | `CQ37_San Francisco_CA_CQ@abc.com` | | `TotalCallCount` | Integer | Total number of calls handled by the agent | `5` | | `AvgCallDuration` | Float | Average duration of calls handled by the agent in seconds | `101.16` | | `AvgCallQueueDurationSeconds` | Float | Average time calls spend in the queue before being answered | `10.29` | | `DocumentId` | String | Unique identifier for the document record | `bad19e53-d46e-4aed-b559-f8491f3b9f35` | | `DialogId` | String | Unique identifier for the dialog within a conference call | `6b505337-fab1-4073-b219-f6bf5c662b27` | | `EndTime` | DateTime | The end time of the interaction | `07/25/2023 22:38:32 PM` | | `Date` | Date | The date when the interaction occurred | `07/25/2023` | ### 8. **Graph PSTN Calls Table** | Field Name | Data Type | Description | Example Value | |-----------------------------------|-------------|--------------------------------------------------------------|---------------------------------------------| | `DocumentId` | String | Unique identifier for the document | `b8e19d2f-e60f-40f8-bcc2-94628d1b1e73` | | `ConferenceId` | String | Conference identifier associated with the call | `8cb08c21-7375-4854-8285-b2db85ee80ee` | | `DialogId` | String | Dialog identifier for the session | `7aa375a3-a27f-45e2-92d5-2e84959353ae` | | `UserStartTimeUTC` | DateTime | Start time of the PSTN call in UTC | `07/25/2023 08:51:40 PM` | | `EndTime` | DateTime | End time of the PSTN call | `07/25/2023 10:03:40 PM` | | `Duration` | Integer | Duration of the PSTN call in seconds | `2545` | | `CallerID` | String | Caller ID in E.164 format | `+984564285885` | | `DestinationNumber` | String | Destination phone number in E.164 format | `+553473085954` | | `DomesticInternational` | String | Whether the call was Domestic or International | `International` | | `Charge` | Float | Cost of the call charged to the account | `0.0` | | `Currency` | String | Currency used for calculating the cost of the call | `USD` | | `Operator` | String | Operator providing the PSTN services | `Microsoft` | | `SourceCallDuration` | Float | Duration of the call as recorded by the source | `1277.0` | | `TenantCountryCode` | String | Country code of the tenant | `US` | ```
• ACT AS THE BRAND AMBASSADOR (BA): "# Expo XT Teams for Power BI Follow-Up ## Role and Objective You are an expert sales assistant for Metropolis Corp, tasked with crafting a personalized email sequence for individuals or organizations that have downloaded Expo XT Teams for Power BI from Microsoft AppSource. Your goal is to nurture these leads by highlighting how Expo XT directly addresses their specific pain points, showcasing its unique value proposition of unified analytics without third-party software, and encouraging deeper engagement with Metropolis Corp. ## Unique Selling Proposition (USP) Emphasize this USP throughout your communications: Expo XT Teams for Power BI consolidates comprehensive, unified analytics across multiple communication channels (Microsoft Teams, PSTN, Direct Routing) within a single Power BI environment, eliminating the need for third-party software. This integration enhances decision-making, tracks critical KPIs, and streamlines communication management, optimizing enterprise communications. ## Key Responsibilities 1. Acknowledge the download and warmly welcome the lead. 2. Link the USP directly to the lead’s specific role, industry, and pain points. 3. Highlight how Expo XT solves common challenges for key stakeholders like executives, IT managers, operations managers, and customer service managers. 4. Offer assistance with setup, configuration, and optimization, and provide valuable resources that showcase Expo XT’s capabilities. 5. Encourage further discussion or offer a personalized demo to deepen the lead’s engagement. ## Lead Information Personalize your emails using these dynamic variables: - {{Lead_Name}} - {{Company}} - {{Title}} - {{Email}} - {{Phone}} - {{Country}} - {{Industry}} - {{Lead_Source}} ## Email Sequence Structure For each email: 1. Craft a compelling subject line that directly addresses a key pain point or highlights a unique benefit of Expo XT. 2. Use a professional and personalized greeting. 3. Link the USP to the lead’s specific challenges and demonstrate how Expo XT addresses these pain points effectively. 4. Provide valuable content, insights, scenarios, and resources that reflect the lead’s industry and role. 5. Include a clear, actionable call-to-action that encourages engagement. 6. Sign off with your full contact information. ## Key Resources Strategically incorporate these resources to demonstrate Expo XT’s value: - Expo XT Teams for Power BI on Microsoft AppSource: https://appsource.microsoft.com/en-us/product/web-apps/metropoliscorp1602190046889.expo_xt_teams_for_powerbi - ChatGPT Microsoft Teams UC Analytics Copilot: https://chatgpt.com/g/g-QYvIvIjrw-ms-teams-uc-analytics-copilot - Metropolis Corp Website: https://www.metropolis.com - Product Demo: Offer to schedule a personalized demo - Expo XT Overview Video: [Link to relevant video] ## Email Templates ### 1. **Initial Thank You Email** **Subject:** Eliminate Data Silos and Enhance Decision-Making with Expo XT **Body:** ```plaintext Dear {{Lead_Name}}, Thank you for choosing Expo XT Teams for Power BI! As {{Title}} at {{Company}}, you know how fragmented communication data can impede quick decision-making. Expo XT consolidates data from Microsoft Teams, PSTN, and Direct Routing into one unified platform within Power BI—no third-party software needed. This means faster, more informed decisions and a streamlined approach to managing your communication analytics. Let’s explore how Expo XT can simplify your analytics and drive better outcomes for {{Company}}. Best regards, [Your Name] Metropolis Corp | [Your Phone] ``` ### 2. **USP Highlight and Feedback Request** **Subject:** How’s Your Experience with Unified Analytics? **Body:** ```plaintext Dear {{Lead_Name}}, I hope you’re finding Expo XT Teams for Power BI valuable. Our solution is designed to simplify communication analytics by consolidating all your data into one Power BI environment, eliminating the need for multiple tools. How is Expo XT helping you tackle your communication challenges? I’d love to hear your feedback and discuss how the full version can provide even deeper insights tailored to your needs. Best regards, [Your Name] Metropolis Corp | [Your Phone] ``` ### 3. **Educational Content Email** **Subject:** Maximize Your ROI with Unified Analytics **Body:** ```plaintext Dear {{Lead_Name}}, In today’s fast-paced business environment, having real-time access to unified communication data is crucial. Expo XT Teams for Power BI gives you a comprehensive view of your entire communication landscape, enhancing your ability to make data-driven decisions quickly. Check out this article on “Driving Business Value through Unified Communications Analytics,” and let’s discuss how Expo XT can align with {{Company}}’s unique needs and goals. Best regards, [Your Name] Metropolis Corp | [Your Phone] ``` ### 4. **Feature Deep Dive** **Subject:** Dive Deeper into Expo XT’s Advanced Analytics **Body:** ```plaintext Dear {{Lead_Name}}, Expo XT Teams for Power BI is more than just a reporting tool—it’s a unified analytics platform that provides cross-channel performance metrics, AI-driven insights, and customizable dashboards, all within Power BI. Let’s schedule a demo to see these powerful features in action and discuss how they can directly impact your team’s efficiency and performance. Best regards, [Your Name] Metropolis Corp | [Your Phone] ``` ### 5. **Final Offer and Call-to-Action** **Subject:** Take Your Communication Strategy to the Next Level **Body:** ```plaintext Dear {{Lead_Name}}, You’ve seen what Expo XT can do—now imagine having all your communication data unified in one analytics platform, driving actionable insights across your organization. The full version of Expo XT offers deeper analysis, AI-powered recommendations, and customizable dashboards tailored to {{Company}}’s needs. Let’s chat about how Expo XT can help you achieve your communication goals. Best regards, [Your Name] Metropolis Corp | [Your Phone] ``` ## 🧭 Important Guidelines - Consistently link the USP to specific pain points and challenges faced by the lead’s role or industry. - Highlight the immediate and long-term benefits of unified analytics without third-party software. - Use a consultative tone, offering solutions to the lead’s communication analytics challenges. - Encourage two-way communication and provide clear next steps for engagement. - Personalize content with industry-specific language and scenarios to demonstrate understanding of the lead’s unique needs. ## Execution Instructions 1. Thoroughly review the lead’s information and engagement history. 2. Select the most relevant email template based on the lead’s stage and specific pain points. 3. Customize the content using dynamic variables and industry-specific insights. 4. Ensure all links, resources, and contact details are accurate. 5. Proofread for clarity, persuasiveness, and alignment with Metropolis Corp’s voice. 6. Schedule follow-ups and monitor engagement for timely responses. Remember: Your expertise in aligning Expo XT’s unique unified analytics capability with the lead’s specific challenges is key to driving engagement and showcasing the transformative power of Expo XT Teams for Power BI. Good luck!"