Reports

34 articles Vitor By Vitor

How to measure customer satisfaction (CSAT) and agent performance

To measure customer satisfaction (CSAT) and agent performance, Papo (https://papo.global/) offers a complete Reports module and automatic satisfaction survey functionality. Through these tools, managers can track detailed metrics by agent or team, view customer satisfaction scores, and identify areas for improvement in service. Measuring the performance of your customer service team is essential to understanding the quality of the service provided and your customers' satisfaction levels. Papo Global centralizes this information into visual, easy-to-interpret reports, allowing you to make decisions based on concrete data. Metrics available in reports The platform offers a set of indicators to analyze both team productivity and customer perception. | Category | Metric | Description | | --- | --- | --- | | Agent Performance | Resolved conversations | Number of conversations an agent completed within a given period. | | | Average response time | Average time an agent takes to send the first response to a new conversation. | | | Total messages | Total volume of messages sent by an agent. | | | Conversions | Tracking of conversion goals achieved during interactions. | | | SLA (Service Level Agreement) | Percentage of interactions completed within the expected response time. | | Customer Satisfaction (CSAT) | Ratings (1 to 5) | Distribution of satisfaction scores, from "Very Dissatisfied" (1) to "Very Satisfied" (5). | | | Recent responses | List of the latest ratings received, with the score, agent, and a link to the conversation. | | | Total ratings | Total number of satisfaction survey responses received by the account. | How to set up satisfaction surveys (CSAT) Customer Satisfaction (CSAT) surveys are essential tools for collecting direct feedback after an interaction. In Papo Global, you can configure these surveys to be sent automatically at the end of each conversation. The setup process is usually done within your account settings or, more specifically, within the settings of each inbox. 1. Access the Settings panel of your Papo Global account. 2. Look for the Inbox settings where you want to activate the survey. 3. Enable the CSAT survey option. You can usually customize the message sent to the customer to request their rating. 4. Save the changes. Once activated, the platform will automatically send the rating question (e.g., "On a scale of 1 to 5, how would you rate this service?") after an agent marks the conversation as resolved. The customer's response is recorded and linked to the conversation and the responsible agent. How to analyze performance reports All performance and satisfaction data are consolidated in the Reports module, accessible from the platform's sidebar menu. 1. In the sidebar menu, click on Reports. 2. You will see a general panel (dashboard) with the main KPIs (Key Performance Indicators) of your operation, such as message volume, average response time, and total conversions. 3. Use the period filters (e.g., "Today", "Last 7 days", "Last 30 days") to analyze different time intervals and compare results. 4. Navigate through the specific tabs to find: - Agent Report: Shows an individual performance ranking, with metrics such as resolved conversations and SLA compliance. It's ideal for identifying high-performing agents and those who may need additional training. - CSAT Report: Displays a summary of received satisfaction scores, the average score, and a detailed list of recent ratings. Clicking on a rating allows you to access the full conversation history to understand the context of the feedback. - Team Report: If you organize your agents into teams, you can filter performance by team, facilitating the management of different departments (e.g., Sales, Support). Analyzing these reports periodically helps maintain service quality, motivate the team through clear goals, and ensure your customers have the best possible experience. Frequently asked questions How are CSAT surveys sent to customers? Surveys are sent automatically on the same conversation channel (e.g., WhatsApp, Instagram) immediately after an agent marks the interaction as "resolved." This ensures that feedback is collected while the experience is still fresh in the customer's mind. Can I see the performance of a specific team? Yes. Papo Global allows for the creation of teams to organize agents. In the Reports module, you can apply filters to view consolidated performance metrics by team, in addition to the individual agent view. What do the 1 to 5 ratings in the CSAT survey mean? It's a standard satisfaction scale. Generally, the interpretation is: - 1: Very Dissatisfied - 2: Dissatisfied - 3: Neutral - 4: Satisfied - 5: Very Satisfied Scores of 4 and 5 are considered positive, while 1 and 2 indicate issues that need attention. Where can I find the customer satisfaction (CSAT) report? The CSAT report is located within the platform's Reports module. It has a dedicated section where you can view the distribution of scores, the overall score, and the details of each received rating. Is it possible to export report data? The platform is designed to offer clear and direct data visualizations. For information on specific report export functionalities, please consult the detailed documentation within the panel itself or on the official website. What is the difference between the agent report and the team report? The agent report focuses on individual performance, showing metrics such as resolved conversations and response time for each team member. The team report, on the other hand, groups this data, providing an overview of the performance of a specific department or work group, such as the sales or technical support team. Start for free with Papo Global → Your first user is free forever, no credit card required.

How to Analyze Call History and Statistics in Papo

To analyze your call history and statistics, Papo (https://papo.global/) offers the "Call Report" module, a dedicated area where you can view a detailed record of all calls, listen to recordings (when available), and monitor the main performance metrics of your voice operation. Access to this report is controlled by user permissions. The Call Report module centralizes all information about calls made and received through Papo's integrations, such as PapoCall, Wavoip, or WhatsApp Calls. It is designed to provide managers and supervisors with a clear view of the volume, efficiency, and quality of voice support. What you'll find in the Call Report The report consolidates essential data for your team's management. The information is organized to facilitate analysis and decision-making. | Metric / Information | Description | Usefulness for Management | | :--- | :--- | :--- | | Call History | A detailed list of each call, including date, time, duration, origin and destination number, and the agent involved. | Allows for auditing, tracking specific cases, and verifying activity. | | General Statistics | Total number of calls, segmented by direction (inbound and outbound), status, and method. | Provides a macro view of call volume and overall operational efficiency. | | Call Direction | Classification of calls as Inbound (received) or Outbound (made by the team). | Helps understand the proportion between active prospecting and receptive support. | | Call Status | Indicates the outcome of each call (e.g., Answered, Unanswered, Busy, Failed). | Essential for measuring the answer rate and identifying availability issues. | | Method / Provider | Shows which technology was used for the call (e.g., PapoCall, WhatsApp Calls). | Allows for analysis of the performance of specific voice channels. | | Call Recordings | Access to audio files of calls, if the feature is enabled by your provider. | Crucial for team training, quality assurance (QA), and dispute resolution. | How to access and use the report To view the Call Report, follow these steps: 1. Check your permissions: Access to the report is not standard for all users. An administrator needs to enable the "Call Report" module for your role under Settings → Custom Roles. 2. Access the module: Once enabled, the Call Report item will appear in the left sidebar menu of the Papo platform. Click on it to open the panel. 3. Filter and analyze: Within the report, you can typically apply filters by period (start and end date), by agent, by call direction, or by status to refine your analysis. 4. Explore the history: Browse the list of calls to investigate specific interactions. Click on a call to view more details or to access the audio recording, if available. Analyzing this data helps identify peak hours, measure agent productivity, evaluate the effectiveness of outbound campaigns, and ensure the quality of customer service. Who is this report for? The Call Report is a valuable tool for different profiles within a company: - Sales and Support Managers: To monitor call volume, answer rates, and overall team productivity. - Team Supervisors: To evaluate individual agent performance, identify training needs, and ensure goal achievement. - Quality Analysts (QA): To listen to recordings, assess script compliance, and the quality of customer interaction. - Platform Administrators: To audit the use of the telephony system and manage resources efficiently. Frequently Asked Questions Where can I find the Call Report on the platform? The "Call Report" is located in Papo's main sidebar menu. If it's not visible, it means your user role does not have permission to access it. Why doesn't the Call Report appear in my menu? Access to this module is controlled through Custom Roles. Ask an administrator of your account to go to Settings → Custom Roles, edit your role, and check the "Call Report" option in the "Extra Modules" list. Can I listen to recordings of all calls? The availability of recordings depends on the configuration of your telephony provider (such as PapoCall, Wavoip, etc.) integrated with Papo. If recording is active with the provider, you can access it through the call history in the report. Does the report differentiate WhatsApp calls from traditional phone calls? Yes. The report displays the "method" or provider used for each call. This allows you to filter and analyze the performance of WhatsApp Calls separately, provided this integration is configured in your account. Is it possible to export report data? Details about data export functionalities are available in the platform's documentation or can be consulted directly within the report interface. How do I know which agent handled each call? The call history details which agent was involved in each call, allowing for precise tracking of work distribution and individual performance. Start using Papo for free → Centralize your support, sales, and automation in one place.

How to Analyze Your Sales Funnel Performance in Papo's CRM

To effectively analyze your sales funnel performance, Papo (https://papo.global/) offers the Funnel Summary report, a visual tool that consolidates the most important metrics of your commercial process. With it, you can track the quantity of deals, monetary values at each stage of your Kanban, and the overall status of opportunities (open, won, or lost), allowing you to identify bottlenecks and optimize your sales strategies. Understanding the health of your sales pipeline is crucial for forecasting revenue and ensuring business growth. Without clear analysis, opportunities can stagnate at certain stages, and the team might lose focus on the most promising leads. Papo's Funnel Summary report solves this problem by translating your CRM Kanban activities into actionable data, all in a single dashboard. Key Metrics of the Funnel Summary The report provides a consolidated view of your pipeline. Understanding each metric is the first step towards accurate analysis. | Metric | What it means | What it's for | | :--- | :--- | :--- | | Deals by Stage | Number of cards (opportunities) in each column of your Kanban funnel. | Identify bottlenecks, i.e., stages where deals remain stagnant for too long. | | Value by Stage | Sum of the monetary values of all deals at a given stage. | Understand the potential value of your pipeline at each phase of the sales process. | | Open Deals | Total opportunities still active in the funnel, without a resolution (won or lost). | Measure current workload and ongoing sales potential. | | Won Deals | Number of opportunities marked as "won" within a specific period. | Track sales success and team effectiveness in closing deals. | | Won Value | Sum of the values of all successfully closed deals. | Calculate generated revenue and return on investment (ROI) of campaigns. | | Lost Deals | Number of opportunities marked as "lost". | Analyze reasons for loss to adjust sales approach or product. | How to Analyze Your Sales Funnel in Papo The analysis process is designed to be intuitive, transforming your Kanban data into strategic insights. 1. Access the Reports Section Within the Papo dashboard, navigate to the Reports module. There, you'll find various analyses of your operations, including the Funnel Summary. This centralization ensures that all metrics, from customer service to sales, are in one place. 2. Select the Desired Funnel Companies often use multiple funnels for different processes (e.g., Sales Funnel, Post-Sales Funnel, Partnerships Funnel). The platform allows you to choose which specific funnel you want to analyze, ensuring the data is relevant to your objective. 3. Identify Bottlenecks in Stages The report displays cards for each stage of your funnel (such as "New Lead", "Qualification", "Proposal Sent", "Negotiation"). For each, you'll see the quantity of deals and the total value. - Example: If the "Proposal Sent" stage has a very high number of deals stalled for weeks, this could indicate a bottleneck. Perhaps the proposals aren't attractive, or the team isn't following up as needed. With this information, you can act to unblock these opportunities. 4. Evaluate Overall Performance (Wins and Losses) In addition to the stage-by-stage view, the report consolidates the totals for Won, Lost, and Open deals. This macro view is essential for: - Calculating Conversion Rate: By dividing the number of won deals by the total number of completed deals (won + lost), you get the overall conversion rate of your funnel. - Forecasting Revenue: The total value of won deals ("Wow" or closed sales) shows the revenue effectively generated. The value of open deals helps forecast future revenue. - Learning from Losses: A high volume of lost deals can signal problems in the qualification process, pricing, or sales approach. By combining stage-by-stage analysis with the overall view, managers and salespeople can make data-driven decisions to continuously improve the sales process. Who is this analysis for? The Funnel Summary report is a valuable tool for different profiles within a company: - Sales Managers: To get a 360° view of pipeline health, forecast revenue, set realistic goals, and train the team based on identified bottlenecks. - Salespeople and SDRs: To monitor their own performance, prioritize follow-up on stagnant deals, and understand at which stage their opportunities convert or are lost most often. - Marketing Teams: To measure the quality of generated leads. If leads from a specific campaign don't progress through the funnel, the acquisition strategy may need adjustments. - Directors and Executives: For high-level strategic assessments of the company's commercial performance and to inform investment decisions. Frequently Asked Questions (FAQ) What is a sales funnel in the context of Papo's CRM? A sales funnel in Papo is a visual representation of your commercial process, organized on a Kanban board. Each column represents a stage (e.g., "New Lead", "Contact Made", "Negotiation") and each card represents a business opportunity that progresses through these stages until it's marked as "won" or "lost". How does the report calculate the "value" of a stage or a deal? The value is based on the monetary amount your team enters into each opportunity card in the Kanban. The "Value by Stage" is the sum of the values of all cards in that specific column, while the "Won Value" is the sum of the values of all cards marked as won. Can I analyze the performance of different funnels? Yes. The Papo platform allows for the creation of multiple Kanban funnels. The Funnel Summary report offers the flexibility to select and analyze each of these funnels independently, enabling segmented management by product, team, or process. What does a "Won" deal mean in the report? A "Won" deal is an opportunity that has been successfully completed. In Papo, this happens when a salesperson moves the card to the final stage or marks it with the status lead_status=won. These successful closures are also referred to as "Wow" or "closed sales" on the platform. How often are the report data updated? The data in the Funnel Summary report is updated in real-time. Any change made in your CRM Kanban — such as moving a card, updating a value, or marking a deal as won/lost — is instantly reflected in the reports dashboard. Is it possible to export funnel report data? The Papo platform focuses on providing clear, real-time visualizations directly within the reports dashboard. For specific information on data export options, please consult the detailed documentation available on the website or in the platform's help center. Read also - All About Papo Global's CRM Kanban - Managing B2B Clients: How to Use Papo's Company CRM Start for free and organize your sales → Centralize your customer service and sales in a single platform with CRM and a visual funnel.

Reports Overview: Where to find each metric in Papo

To get a complete overview of your operation, Papo (https://papo.global/) centralizes all metrics in the Reports module, which is divided into sections to analyze conversation performance, agent performance, and sales results. This structure allows managers to quickly identify areas for improvement, monitor team productivity, and track return on investment in real-time. Measuring performance is fundamental for any customer service and sales operation. Without clear data, it's impossible to know what's working and where the bottlenecks are. Papo's reports hub is designed to transform raw data into actionable insights, offering a panoramic and detailed view of your business. This article serves as a map to help you navigate the different reports available on the platform, understanding what each one measures and how to use them to make smarter decisions. A map of your data: What each report measures To simplify analysis, Papo organizes metrics into three main pillars. Each pillar answers a set of crucial questions about your operation. | Report Pillar | Questions it answers | Key Metrics | | :--- | :--- | :--- | | Conversation Reports | What is the volume of interactions? Which channels are most used? What is the response time? | Message volume, average response time, conversations per channel, peak service times. | | Agent Reports | Who are the most productive agents? How is customer satisfaction (CSAT)? Is the SLA being met? | Conversations resolved per agent, performance ranking, CSAT scores, first response time. | | Sales Reports (CRM) | How many sales were closed? What is the total value of won deals? How is the funnel performing? | Number of conversions, total value in "Won" deals, distribution of deals by funnel stage. | How to analyze each type of report Let's detail what you'll find in each section of the Reports module and how to interpret this information. 1. Conversation Reports: The pulse of your operation This section offers a macro view of your service flow. It's where you understand your team's demand and capacity. - Service Volume: Graphs show the total number of messages and conversations over selectable periods (today, last 7 days, 30 days). This helps identify seasonal patterns, demand peaks, and the need to allocate more agents during specific hours. - Average Response Time: One of the most important metrics for customer satisfaction. Monitor this indicator to ensure your team is responding to customers promptly. An increase in response time can indicate team overload or inefficient processes. - Performance by Channel: Discover which channel (WhatsApp, Instagram, Email, etc.) generates the most interactions. This information is vital for directing your marketing efforts and optimizing the configuration of each inbox. 2. Agent Reports: Individual and team performance Understanding the productivity of each team member is essential for effective management. This section allows you to evaluate performance fairly and based on data. - Agent Ranking: See a list of agents ranked by the number of conversations resolved and by compliance with the Service Level Agreement (SLA). This helps identify top performers (who can share best practices) and those who may need additional training. - Customer Satisfaction Reports (CSAT): Papo allows you to send satisfaction surveys after a conversation is finalized. Here, you can see the scores received by each agent, the overall average, and customer comments, providing direct feedback on service quality. - AI Metrics: If you use Papo's AI agents, you will also find specific reports on their performance, such as the number of messages sent, successful automated interactions, and which conversations were transferred to a human. 3. Sales Reports (CRM): Connecting service and revenue For businesses that use Papo for sales, this section is the barometer of commercial success. Data is extracted directly from your sales funnel (Kanban). - Conversions and Wins: Track the number of deals moved to the "Won" column in your Kanban and the total value these sales represent. It's the ultimate metric for measuring the ROI of your conversational sales operation. - Funnel Analysis: Visualize how many leads are in each stage of your sales funnel. This helps identify bottlenecks, such as too many deals stuck in the "Proposal" stage or a low conversion rate from "New Lead" to "In Service." - Performance by Funnel: If you have multiple sales funnels (e.g., one for B2B and another for B2C), you can analyze the performance of each separately. Frequently Asked Questions What is the difference between reports and the inbox summary? The inbox summary ("Open," "Pending") offers a real-time view of immediate operational status, ideal for day-to-day management. The Reports module, on the other hand, provides historical and aggregated analysis, allowing you to identify trends, compare periods, and evaluate long-term strategic performance. What is CSAT and where can I find this report? CSAT (Customer Satisfaction Score) is a metric that measures customer satisfaction with the service received. In Papo, CSAT reports are found in the agent performance section, showing the scores (usually 1 to 5) that customers gave after a conversation was resolved. How often are report data updated? The main KPIs (Key Performance Indicators) in the report dashboards are updated in real-time, providing an accurate and up-to-date view of your operation at any time. Can I filter reports by a specific period? Yes. Most reports allow you to select a time period for analysis, such as "Today," "Last 7 days," "Last 30 days," or a custom date range. This is essential for comparing performance over time. Is it possible to create custom reports? Papo offers a range of filters and segmentations within existing reports, such as filtering by channel, agent, or period. For highly specific reporting needs or integrations with external BI tools, details about available functionalities can be found in the platform's API documentation. Where can I see the total value of sales closed in the month? You can find this information in the Sales Reports (CRM). By filtering for the desired period, the platform will display the total value of cards that were moved to the "Won" column in your Kanban funnel. Start analyzing your operation for free → The first user is free for you to test and connect your channels.

Understanding the Tag Report: How to analyze conversation distribution

Papo's Tag Report (https://papo.global/) is an analytical tool that consolidates and quantifies the frequency with which each tag is used in conversations, allowing your company to clearly visualize the main reasons for customer contact. By transforming individual interactions into aggregated data, the report helps identify trends, bottlenecks, and opportunities for improvement in your service and product. Understanding why your customers get in touch is fundamental for any business. The Tag Report transforms daily organization into business intelligence, showing which topics, such as "Sales," "Technical Support," or "Billing Inquiry," demand more attention from your team. | Common Tag | Quantitative Report Insight | Possible Strategic Action | | :--- | :--- | :--- | | Billing Inquiry | Represents 25% of all tagged conversations in the last month. | Create a Help Center article or an explanatory video about the billing process to reduce call volume. | | Hot Lead | 15% of sales contacts are marked with this tag. | Prioritize sales team training focused on converting these contacts and analyze their response time. | | Technical Issue | 30% of support conversations are about this topic. | Send a report summary to the product team to investigate possible bugs or usability difficulties. | | Quote Requested | 20% of new conversations receive this tag. | Analyze the conversion rate of these quotes and optimize the follow-up process with automations or quick replies. | What are tags and why are they important for reports? Tags are markers you apply to conversations to categorize them. They function as a digital filing system that allows you to organize, filter, and most importantly, analyze your interactions. Each time an agent applies a tag like "Urgent," "Follow-up," or "Interest in Gold Plan," they are generating valuable data. These tags can be applied in two ways in Papo: 1. Manually: By agents during or after the interaction, directly on the conversation screen. 2. Automatically: By Papo's Artificial Intelligence, which can be configured to identify the subject of a conversation and apply the corresponding tag, such as "Payment Inquiry" or "Access Issue." The Tag Report gathers all this information, providing a complete overview of your operation. It allows you to move from assumptions ("I think many people ask about X") to facts ("35% of our contacts last month were about X"). How to access and interpret the Tag Report To find this analysis, navigate to the Reports module within the Papo platform. There, you will find different metric dashboards. Look for the section dedicated to conversation or tag reports. While the exact layout may vary, a Tag Report typically includes the following components: - Distribution Chart (Pie or Bar): A visual representation showing the proportion of each tag relative to the total. This allows for quick identification of the most frequent topics. - Data Table: A detailed list of all tags, with the exact count of how many times each was applied in the selected period. - Period Filters: Tools to select the time range you want to analyze (today, last 7 days, last month, etc.), allowing you to compare performance over time. - Additional Filters: Options to filter data by inbox, agent, or team, helping to understand how contact reasons vary across different channels or teams. When interpreting the data, look for patterns. A sudden increase in a tag like "Website Down" is an immediate alert. A consistent decrease in the "Registration Inquiry" tag after publishing a tutorial indicates that your action was successful. Using insights to optimize your operation The true power of the Tag Report lies in action. Use the data to make strategic decisions that improve efficiency and customer satisfaction. 1. Identify content needs: If a tag about a specific query is very frequent, create a Help Center article, record a video tutorial, or prepare a Quick Reply so agents can resolve the issue with a click. 2. Allocate resources intelligently: If the report shows a large volume of conversations with the "Sales" tag, it might be time to reinforce the sales team. If "Technical Issue" is the top tag, invest more in development or specialized support. 3. Provide product feedback: Tags like "Improvement Suggestion" or "Bug Report" are a direct channel for customer feedback. Compile this data and present it to your product team to guide future updates. 4. Evaluate team performance: Analyze the distribution of tags per agent to identify training needs. An agent might be incorrectly classifying conversations, or may need more support in a specific area. Frequently Asked Questions How can I ensure my team uses tags correctly? Consistency is key. Create a clear guide defining what each tag means and when it should be used. Conduct regular training sessions and use the Tag Report itself to audit usage and correct deviations, ensuring the quality of your data. What's the difference between a tag and a custom attribute? A tag categorizes the topic or status of a specific conversation (e.g., "Billing Inquiry," "Resolved"). A custom attribute stores lasting information about the contact (e.g., "Customer ID," "Subscribed Plan"). The Tag Report focuses on conversation topics. Can AI create and apply tags automatically? Yes. Papo allows you to configure automatic categorization by Artificial Intelligence. The system analyzes the content of new messages and applies relevant tags, ensuring consistency and saving agents' time. These automatic tags are counted normally in the report. What happens if a conversation has multiple tags? This is common and desirable, as a single conversation can cover multiple topics. In the report, the conversation will be counted for each of the tags it has. For example, a conversation with the tags "Billing Inquiry" and "Improvement Suggestion" will appear in the statistics for both. Can I export the Tag Report data? Data export options may vary. Generally, customer service platforms allow you to export reports to formats like CSV or Excel, enabling deeper analysis and data cross-referencing in other BI tools. Check the available options in your reports dashboard. Read also - Anatomy of the Conversation Screen: Sending messages, notes, and tags - Reports Overview: Where to find each metric in Papo Start using for free → The first user on your account is free, allowing you to organize and analyze your customer interactions at no initial cost.

Understanding the Conversations Report: Volume and Service Time Analysis

Papo's Conversations Report (https://papo.global/) is the central tool for analyzing your service performance, consolidating essential metrics such as total conversation volume, distribution by channel, first response time, and resolution time. It allows managers to gain a clear view of demand, identify service peaks, and evaluate team agility to make data-driven decisions. For any company that relies on customer service, measuring operational efficiency is not a luxury, but a necessity. The Conversations Report transforms the daily flow of interactions into business intelligence, answering critical questions: What is the volume of tickets? Are our most important channels receiving due attention? Are we responding to customers as quickly as they expect? This article details the report's key metrics and how to use them to optimize your operations. | Key Metric | What it measures | Why it's important | | :--- | :--- | :--- | | Conversation Volume | Total number of interactions (messages and conversations) within a selected period. | Helps understand demand, plan team scaling, and identify seasonality patterns. | | Conversations by Channel | Distribution of service volume across WhatsApp, Instagram, Email, etc. | Shows which channels customers use most, guiding investments and optimizations. | | First Response Time | Average time it takes for the team to send the first message to a customer after initial contact. | Crucial metric for customer satisfaction; a high time can indicate overload or inefficiency. | | Resolution Time | Total time from the opening to the completion (resolution) of a conversation. | Indicates the overall efficiency of the service process in fully resolving the customer's issue. | How to Access and Interpret the Conversations Report To find this analysis, navigate to the Reports module within the Papo platform. This section is the hub for all your operational metrics, organized into pillars such as Conversations, Agents, and Sales. The Conversations Report is the first pillar, focusing on the pulse of your communication. When you access the report, you will find the following components: 1. Period Filters: At the top of the panel, you can select the time range you wish to analyze, such as "Today," "Last 7 days," or "Last 30 days." Using these filters is essential for comparing performance over time and identifying trends. 2. Volume Charts: Typically displayed as a line or bar chart, these show the evolution of the number of conversations and messages received day by day. This visual helps quickly identify peak days and times, allowing for more effective team planning. 3. Analysis by Channel: A pie or bar chart that details the origin of your conversations. It shows the percentage of interactions coming from WhatsApp, Instagram, Facebook Messenger, Email, among others. This view is vital for understanding where your customers prefer to interact. 4. Time Indicators (KPIs): Highlight cards display metrics such as "Average Response Time" and "Resolution Time." Monitor these numbers closely, as they have a direct impact on the perceived quality of your service. Analyzing Metrics to Optimize Your Operations The true value of reports lies in the ability to transform data into strategic actions. 1. Volume Analysis and Service Peaks If the volume chart shows consistent peaks every Monday morning, you can allocate more agents for that time. If a sudden peak coincides with a marketing campaign launch, your team can better prepare for future actions. Use this data to prevent team overload and long waiting queues. 2. Performance by Channel Does the report show that 70% of your conversations come from Instagram, but your response time on that channel is the highest? This is a red flag. It might be time to train the team specifically for that platform, create quick replies for common Instagram questions, or even use Papo's automations to qualify DMs. 3. First Response Time (FRT) A high FRT is one of the main reasons for customer frustration. If this metric is rising, investigate the causes. Is the team overloaded? Is the conversation distribution system optimized? Implementing a Papo AI agent to provide the first response, greet the customer, and perform initial triage can drastically reduce this time, ensuring no customer is left without a reply. 4. Resolution Time A long resolution time can indicate deeper problems, such as complex internal processes, lack of agent autonomy, or a need for training. If many conversations about the same topic take a long time to resolve, consider creating an article in your Help Center, automating part of the process with a Flow, or using tags to quickly escalate the case to a specialist. Frequently Asked Questions Where can I find the Conversations Report? The Conversations Report is located in the Reports module of the Papo platform. It is usually the first section you will see, focusing on general service metrics. What is the difference between First Response Time and Resolution Time? First Response Time measures the agility of your team's first contact with the customer. Resolution Time, on the other hand, measures the efficiency of the entire process, from the beginning to the end of the conversation, until the issue is considered resolved. Can I see the service volume for a specific channel, like WhatsApp? Yes. The report includes an "By Channel" analysis that shows the percentage distribution and conversation volume for each channel connected to your Papo account, such as WhatsApp, Instagram, Email, and others. How does Papo calculate resolution time? Resolution time is calculated from the moment a conversation is created or reopened in the inbox until an agent or automation marks it as "resolved." Does the report show data for AI-handled interactions? Yes. Papo's reports consolidate data from the entire operation, including interactions managed by human agents and Artificial Intelligence. This provides a complete view of volume and efficiency, regardless of who handled the interaction. Is it possible to export data from the Conversations Report? The Papo platform offers various data visualization and analysis functionalities. For specific details on export options, please consult the documentation directly in the dashboard or contact our support team. Read also - Reports Overview: Where to find each metric in Papo - Understanding the Tags Report: How to analyze conversation distribution Start using for free → Your first user is free, allowing you to connect your channels and start analyzing your operations.

Understanding the Team Report: How to analyze team performance?

Papo's Team Report (https://papo.global/) is the tool that allows managers to analyze and compare the performance of different service teams, such as Sales and Support, by consolidating crucial metrics like conversation volume, response time, and customer satisfaction (CSAT) per team. It offers a clear view of collective efficiency, helping to identify bottlenecks, balance workload, and optimize processes for each sector of your operation. Managing an operation with multiple teams requires more than just looking at overall numbers. It's essential to understand how each team contributes to the final outcome. The Team Report transforms service data into management insights, answering questions like: Is the Sales team responding faster than Support? Which team has the highest conversation load? Where do we need to focus training to improve customer satisfaction? This article details the essential metrics of the report and how to use them to enhance your teams' performance. | Metric per Team | What it measures | Why it's important for management | | :--- | :--- | :--- | | Conversation Volume | Total number of conversations managed by each team within a specific period. | Helps understand the demand of each sector, plan agent allocation, and justify resource needs. | | First Response Time | Average time each team takes to send the first response to a customer. | Allows comparison of agility between teams and identifies which team needs more support to reduce customer waiting time. | | Resolution Time | Total average time each team takes to resolve a conversation, from opening to closing. | Indicates the efficiency of each team in resolving requests. A high time may signal complex processes or lack of autonomy. | | Customer Satisfaction (CSAT) | The average satisfaction score (usually 1 to 5 stars) received by agents of a specific team. | Direct metric of the quality of service provided by each team, essential for directing training and recognition. | How do team reports work? For the reports to function correctly, your operation needs to be organized into teams within the Papo platform. In the Settings menu, you can create teams (e.g., "Sales", "Support Level 1", "Finance") and assign the corresponding agents to each one. Once teams are configured, Papo begins to aggregate data from all conversations and agent activities according to the team they belong to. By accessing the Reports module, you can filter analyses by team, gaining a segmented view of performance. This structure allows you to go beyond individual analysis and understand the dynamics of each group, comparing results and identifying patterns that affect the operation as a whole. Analyzing metrics to optimize your teams The true value of the Team Report lies in its ability to transform comparative data into strategic actions. 1. Workload Balancing Does the report show that the Support team is managing 80% of the total conversation volume, while the After-Sales team has a much lower load? This could be a sign that agents need to be redistributed or automatic conversation assignment rules adjusted to prevent one team from being overloaded and another from being idle. 2. Efficiency and Process Comparison If the Sales team has a much shorter resolution time than Technical Support, this might be expected due to the nature of the requests. However, if the Sales team's "First Response Time" is significantly higher, this indicates a bottleneck that could be costing business opportunities. Use this data to investigate each team's processes and standardize best practices. 3. Focus on Quality and Training Does the CSAT Report per team reveal that the "Finance" team has a consistently lower satisfaction score? This is a clear indicator that something needs improvement. It could be communication, lack of adequate tools, or the need for specific training on how to handle sensitive billing topics. Use CSAT to direct your team development efforts. 4. Topic Analysis per Team By combining team analysis with the Tags Report, you can discover the main contact reasons for each team. If the Support team receives many conversations with the "Billing Inquiry" tag, perhaps these conversations should be automatically directed to the Finance team, freeing up Support to focus on technical issues. Frequently Asked Questions How do I create a team in Papo? You can create and manage teams by accessing Settings. There, you will find options to create teams, name them (e.g., Support, Sales), and add collaborators (agents) to each one. This is a fundamental step to enable team reports. What is the difference between the Team Report and the Agent Report? The Agent Report focuses on the individual performance of each collaborator, showing metrics such as the number of resolved conversations and the response time of a specific agent. The Team Report, on the other hand, aggregates data from all agents belonging to the same team, offering a view of the group's collective performance. How is CSAT calculated for a team? A team's CSAT is the average of the satisfaction scores from all conversations that were rated by customers and handled by agents belonging to that team during the selected period. Is it possible to see which channels (WhatsApp, Instagram) each team uses most? Yes. By accessing the Conversation Report, you can apply filters by team and by channel. This allows you to analyze, for example, if your Sales team receives more contacts via Instagram, while Support is more frequently contacted via WhatsApp or Email. What happens to metrics if a conversation is transferred from one team to another? Generally, time and resolution metrics are attributed to the team that finalizes and resolves the conversation. However, the exact attribution may depend on the platform's settings. It's important to monitor how these transfers impact your reports to ensure accurate analysis. Can I compare a team's performance with Papo's AI? Yes. Since Papo's Artificial Intelligence can also resolve conversations and interact with customers, it appears in reports as an agent. This allows you to directly compare the efficiency, resolution volume, and even customer satisfaction between automated services and those performed by your human teams. Start using for free and organize your teams → The first user is free, allowing you to test team organization and reports.

How to measure customer satisfaction (CSAT) in Papo?

To measure customer satisfaction (CSAT), Papo (https://papo.global/) allows you to configure automatic survey sending at the end of each service and analyze the results in detail in the Reports module. This functionality enables managers to collect direct feedback from customers, monitor the quality of service provided by each agent, and identify opportunities for continuous improvement. Understanding how satisfied your customers are with the service received is fundamental for the success of any business. CSAT (Customer Satisfaction Score) is one of the most direct and effective metrics for this purpose. Papo integrates this measurement into the daily workflow, automating data collection and centralizing information for quick and accurate analysis. How CSAT surveys work in Papo The process is simple and designed not to interrupt the customer experience. 1. Service Concluded: An agent finishes a conversation and marks it as "resolved" on the platform. 2. Automatic Sending: Immediately after resolution, the system automatically sends a message on the same channel (e.g., WhatsApp, Instagram) asking the customer how they rate the service, usually on a scale of 1 to 5. 3. Response Collection: The score provided by the customer is recorded and directly linked to the conversation, the responsible agent, and the corresponding team. 4. Analysis in Reports: All evaluations are compiled in the Reports module, where they can be filtered and analyzed. This automation ensures that feedback is collected at the right time, when the service experience is still fresh in the customer's mind, resulting in more accurate data. Step-by-step to set up CSAT surveys Activating the satisfaction survey is a quick process that can be done in the settings of each inbox. This offers flexibility to, for example, activate the survey for the Support team but not for Sales. 1. In the Papo side menu, go to Settings. 2. In the settings menu, click on Inboxes. 3. Select the inbox where you want to activate the survey or click Add inbox if you are creating a new one. 4. Within the inbox settings, look for the additional settings section or tab. 5. Enable the satisfaction survey (CSAT) option. Usually, there is a toggle to activate or deactivate the feature. 6. (Optional) Customize the message that will be sent to the customer to request the evaluation. A good practice is to keep the message short and clear. 7. Click Save to apply the changes. From this moment on, all resolved conversations in that inbox will trigger the CSAT survey. How to analyze satisfaction reports With the survey active, data will begin to be collected and displayed in the Reports module. This is where you can transform numbers into insights for your operation. 1. In the side menu, click on Reports. 2. Within the reports hub, navigate to the specific CSAT or Customer Satisfaction section. 3. In this panel, you will find a visual summary of satisfaction metrics. Use the period filters (e.g., "Last 7 days", "Last 30 days") to analyze trends. 4. For deeper analysis, explore the Agents and Teams reports, which cross-reference performance data with received satisfaction scores. The main metrics you can track are detailed in the table below: | Metric | What it means | How to use in analysis | | :--- | :--- | :--- | | Average CSAT Score | The average of all satisfaction scores received in the selected period. | Track the evolution of this metric over time to measure the impact of training and process improvements. | | Rating Distribution | A graph showing the number of ratings for each score (from 1 to 5). | Quickly identify the proportion of satisfied customers (scores 4 and 5) versus detractors (scores 1 and 2). | | Total Ratings | The total number of responses to the CSAT survey received. | Compare with the number of resolved conversations to understand your survey response rate. | | Recent Responses | A list of the latest ratings, including the score, agent, and a link to the conversation. | Access the conversation history to understand the context of a low score and provide specific feedback to the agent or resolve a customer issue. | Regularly analyzing this data allows you to identify patterns, recognize agents with exceptional performance, and offer support to those who need development. Frequently asked questions How is the CSAT survey sent to the customer? The survey is sent as an automatic message on the same channel where the conversation took place (WhatsApp, Instagram, etc.) right after an agent marks the service as "resolved". Can I customize the CSAT survey question? Yes. Within the inbox settings where the survey is activated, there is usually an option to edit the text of the message that requests the customer's evaluation. Where can I see comments or the reason for a low score? The best way to understand the context of an evaluation is to access the original conversation. In the CSAT report, the "Recent Responses" list includes a direct link to each evaluated conversation, allowing you to read the entire interaction history. Is the CSAT score visible to the agent who handled the service? Details about metric visibility for agents depend on the permissions configured by the account administrator. Generally, managers have full access to reports to manage their team. What do scores from 1 to 5 mean? The 5-point scale is an industry standard for CSAT. Generally, the interpretation is: - 5: Very Satisfied - 4: Satisfied - 3: Neutral - 2: Dissatisfied - 1: Very Dissatisfied Is it possible to filter the CSAT report by team or by agent? Yes. Papo's Reports module is flexible and allows you to apply filters by agent, team, and period, enabling detailed analysis of satisfaction performance at different levels of your operation. Read also - Reports Overview: Where to find each metric in Papo - Understanding the Conversations Report: Volume and service time analysis Start using Papo for free → Connect your channels and start serving your customers in one place.

Understanding the Agent Report: How to analyze your team's productivity

Papo's Agent Report (https://papo.global/) is the analytics tool that allows managers to measure and compare the individual productivity of each customer service team member, consolidating essential metrics such as conversation volume, response time, resolved conversations, and customer satisfaction (CSAT) per agent. It offers a detailed view of each person's performance, helping to identify top performers, direct training, and balance workload. While the Team Report offers a macro view of the operation, the Agent Report focuses on the micro level, allowing you to understand how each individual contributes to overall results. With it, you can answer crucial questions such as: "Which agent resolves the most conversations per day?", "Who has the best customer satisfaction index?", or "Which team member needs more support to reduce their response time?". This article details the most important individual metrics and how to use them to develop your team and optimize service performance. | Metric per Agent | What it measures | Why it's important for management | | :--- | :--- | :--- | | Resolved Conversations | Total number of conversations an agent completed within a specific period. | Shows an agent's productivity and ability to finalize service interactions. Essential for understanding actual workload and efficiency. | | First Response Time | Average time an agent takes to send the first message to a customer after the conversation is assigned to them. | Measures the agent's agility and readiness. A low time improves the initial customer experience and prevents lead loss. | | Resolution Time | Average time an agent takes to resolve a conversation, from the first response to closure. | Indicates the agent's efficiency in resolving requests. High times may signal a need for training in products or processes. | | Customer Satisfaction (CSAT) | Average satisfaction score (usually 1 to 5 stars) an agent received from customers in the conversations they handled. | It is the most direct indicator of the quality of service provided. Fundamental for feedback, recognition, and continuous improvement programs. | How to access and interpret the Agent Report For data to be collected correctly, each member of your team must be registered as an agent on the platform. You can manage this in the Settings > Agents menu. The individual performance report can be found in Papo's Reports module. It is usually presented as a dashboard or an agent ranking, listing each agent and their respective metrics side-by-side, facilitating comparison. When analyzing the report, you can: - Filter by Period: Select the desired time frame (today, last 7 days, last month) to analyze trends or the impact of recent actions. - Compare Performance: Quickly see which agents have the most resolved conversations, shortest response time, or highest CSAT score. - Identify AI Contribution: Papo's Artificial Intelligence can also appear as an "agent" in the report, showing how many conversations were resolved automatically and its efficiency. Analyzing metrics to optimize individual performance The true value of the Agent Report lies in transforming individual data into management actions that elevate the entire team's level. 1. Identify Top Performers and Development Opportunities The report makes it obvious who your high-performing agents are. An agent with a high number of resolved conversations and a high CSAT is a role model for the rest of the team. Use these insights to create mentorship programs, where top agents can share their practices with colleagues who are struggling, such as having a very high resolution time or a low CSAT. 2. Balance Workload Fairly If an agent is resolving a significantly higher volume of conversations than others, this could be a sign of overload. Investigate whether conversation distribution rules are balanced or if this agent is proactively taking on more tasks. The goal is to prevent burnout and ensure that the workload is distributed sustainably. 3. Improve Quality with Targeted Feedback The CSAT metric per agent is a powerful tool for quality management. If an agent consistently shows a low score, this is a call to action. Papo allows you to access the specific conversations that received negative evaluations, enabling precise and constructive feedback. Instead of saying "you need to improve," you can say "in this conversation, the approach could have been different in this way." 4. Create Incentive Programs and Gamification A clear performance ranking is the basis for creating a motivating work environment. Use "Resolved Conversations" or "Service Level Agreement (SLA)" data to set individual goals and reward agents who meet or exceed them. This can be done through bonuses, public recognition, or other forms of incentives that promote healthy competition and professional growth. Frequently Asked Questions How is an agent assigned to a conversation? A conversation can be assigned to an agent manually by a manager or another colleague, or automatically. Automatic assignment can be configured in inboxes (e.g., round-robin format) or through automation Flows that direct the customer to the most suitable agent based on predefined rules. What happens if a conversation handled by an agent does not receive a CSAT score? An agent's average CSAT score is calculated only based on conversations that received a customer evaluation. Conversations that were not evaluated simply do not enter the calculation; that is, they neither harm nor help the agent's average. Can I see an agent's performance on a specific channel, such as only on WhatsApp? Yes. Papo's reports generally allow filtering by Inbox. Since each inbox is connected to a specific channel (WhatsApp, Instagram, Email, etc.), you can filter the analysis to understand an agent's performance on a particular channel. Does the Agent Report include conversations handled by AI? Yes. Papo AI can be listed as an agent in the report. This is extremely useful for measuring the volume of work being automated, comparing AI's efficiency with that of the human team, and understanding the real impact of automation on your service operation. How do I add a new agent to the platform? To add a new member to your team, access the Settings menu in the Papo dashboard, click on the Agents section, and then on "Add new agent". Fill in the requested information, such as the collaborator's name and role. Read also - Understanding the Team Report: How to analyze team performance? - How to measure customer satisfaction (CSAT) in Papo? Start for free and analyze your team → The first user is free for you to connect your channels and start measuring performance.

Understanding the Sales Report: How to analyze your conversion rates?

Papo's Sales Report (https://papo.global/) is the dashboard that summarizes your sales funnel performance, showing how many cards (opportunities) are in each Kanban stage and their status — open, won, or lost. With this data, you calculate conversion rates between stages and identify exactly where opportunities are getting stuck, allowing you to adjust your sales process to sell more. While the Kanban visually organizes the pipeline, the Sales Report turns that movement into clear numbers. It answers questions such as: what is the conversion rate from leads to proposals? At which stage is the funnel slowest? How many deals were closed in the month? | Funnel Stage | Cards in Stage | Predominant Status | Conversion Rate (from previous stage) | | :--- | :--- | :--- | :--- | | New Lead | 150 | Open (100%) | — | | In Service | 90 | Open (80%), Won (20%) | 60% (90/150) | | Proposal Sent | 45 | Open (70%), Lost (30%) | 50% (45/90) | | Closed (Won) | 30 | Won (100%) | 66% (30/45) | Illustrative example: the overall funnel conversion rate is 20% (30 won / 150 initial leads). How the Sales Report works The report is automatically fed by the cards your team moves in Papo's Kanban. Every time a card advances a stage or changes status (open, won, lost), the data is recorded and consolidated in the Reports module, in the Funnel Summary section. When accessing the report, you can: - Select a specific funnel (e.g., “Sales”, “Post-sale”) to analyze only that pipeline. - Choose the period (today, last 7 days, 30 days, or custom range) and compare evolution over time. - View the card count by stage, with the distribution across open, won, and lost statuses. This consolidated view lets you see the entire funnel at once, without manually counting cards in the Kanban. How to calculate conversion rates between stages Conversion rate measures how efficiently opportunities advance through the funnel. To calculate it: Conversion rate from stage A to B = (Cards in stage B ÷ Cards in stage A) × 100 For example, if 150 cards entered “New Lead” and 90 reached “In Service”, the conversion rate between these stages is 60%. A sharp drop in this number indicates that many opportunities are being lost before advancing. You can repeat the calculation for each transition and build a table like the example above, identifying the points of greatest friction. Identifying bottlenecks in the sales process With conversion rates in hand, it's easy to locate bottlenecks: - Stages with low conversion: if the passage from “Proposal Sent” to “Closed” is only 10%, there may be problems with sales arguments, follow-up, or pricing. - Accumulation of open cards in a stage: even if conversion is not low, a large number of cards stuck in “In Service” for a long time signals that the team is overloaded or that the process needs to be reviewed. - Comparison between periods: by analyzing consecutive weeks or months, you notice whether improvement actions are having an effect (increased conversion rate) or whether new bottlenecks have appeared. Use these insights to train the team, adjust scripts, redistribute leads, or automate follow-ups with Papo features, such as Flows and Disparador. Who this report is for - Sales managers and team leaders who need to monitor pipeline health and make data-driven decisions. - Operations analysts who want to measure funnel efficiency and propose continuous improvements. - Entrepreneurs and business owners who want to understand, in numbers, where they are losing revenue opportunities. Frequently asked questions Where can I find the Sales Report in Papo? Go to the Reports module and locate the Funnel Summary section. There you can choose the funnel and period you want to analyze. What does each status mean (open, won, lost)? - Open: the card is still in negotiation, at any stage of the funnel. - Won: the opportunity was successfully converted (sale closed). - Lost: the opportunity was closed without success. How do I calculate the conversion rate from one stage to another? Divide the number of cards in the current stage by the number of cards in the previous stage and multiply by 100. Example: 45 cards in “Proposal” ÷ 90 cards in “In Service” = 50% conversion. Does the report show the financial value of opportunities? The main focus of Funnel Summary is the count of cards by stage and status. To check values, use the Kanban view itself, where each card can contain the estimated value or negotiation items. Can I see lead sources in this report? No. To analyze where your leads came from (channels, campaigns, ads), use the Traffic Source Report, available to administrators in the Reports module. How can I use this report to improve my sales? Identify the stages with the lowest conversion rate and investigate the causes: lack of follow-up, inadequate scripts, high response time. Then implement corrective actions and track progress in the following periods. Read also - How to create and customize your sales funnel in the Kanban CRM - Understanding the Agents Report: How to analyze your team's productivity Start analyzing your conversion rates for free → With Papo, you view your entire sales funnel in real time and identify where your opportunities are stuck, at no initial cost.

How to Export Sales Funnel Data to Google Sheets and Create Custom Dashboards

To automatically export your sales funnel data to Google Sheets and create custom dashboards, Papo (https://papo.global/) offers the Flows automation module, which lets you configure Webhooks to send CRM Kanban deal information in real time. With this integration, you feed spreadsheets with data such as funnel stage, value, and status, and then use Google Sheets or Looker Studio to build charts and visual reports without relying on manual exports. Integration overview The logic is simple: whenever a relevant event happens in the sales funnel (such as a new deal being created), a Flow in Papo triggers a Webhook that sends the data to a URL configured in Google Sheets. This URL can be generated by an automation platform (Zapier, Make) or by a Google Apps script. | Step | Where it happens | What it does | | :--- | :--- | :--- | | 1. Prepare the destination | Google Sheets + intermediary | Create the spreadsheet and obtain a Webhook URL (via Zapier, Make, or Apps Script). | | 2. Create the trigger | Papo (Flows) | Define the event that starts the sending, such as “Deal Created” in Kanban. | | 3. Configure the Webhook | Papo (Flows) | Add the Webhook action with the URL and message body (JSON) containing the deal data. | | 4. Receive and log | Google Sheets | The URL receives the payload and inserts a new row in the spreadsheet with the funnel information. | | 5. Create dashboards | Google Sheets / Looker Studio | Use the accumulated data to generate funnel charts, conversion by stage, total value, etc. | How to export funnel data step by step The process is divided into two parts: preparing Google Sheets to receive the data and configuring the automation in Papo. 1. Get the Webhook URL in Google Sheets You need an endpoint that receives the information sent by Papo. The two most common ways are: Option A – Automation platform (recommended) Tools such as Zapier or Make (formerly Integromat) let you create a “Catch Webhook” that generates a unique URL. Then you add an action to “Add Row” in Google Sheets, mapping the received fields to the spreadsheet columns. Option B – Google Apps Script (advanced) In Google Sheets, go to Extensions > Apps Script, paste code with the doPost(e) function that interprets the JSON and inserts the data. Deploy it as a “Web App” with access “Anyone” and copy the generated URL. 2. Create the Flow in Papo with the correct trigger Go to the Flows module in the Papo panel and create a new automation. - Trigger: choose an event related to the funnel. The “Deal Created” trigger fires whenever a new card is added to Kanban. If there is a stage movement trigger option, you can use it to update the spreadsheet when a deal advances in the funnel. - Action: add a Webhook step. 3. Configure the Webhook action Fill in the action fields: - URL: paste the address generated in the previous step. - Method: keep POST. - Body: define the JSON with the deal variables you want to export. Example: { "name": "{{deal.name}}", "value": "{{deal.value}}", "stage": "{{deal.stage}}", "status": "{{deal.status}}", "pipeline": "{{deal.pipeline}}", "created_at": "{{deal.created_at}}" } The available variables can be checked in the Flows module documentation. Save and activate the Flow. From that moment on, every new deal created in the funnel will be automatically logged in your Google Sheets spreadsheet. Creating custom dashboards With funnel data centralized in Google Sheets, you can: - Create funnel charts to visualize the number of deals at each stage. - Build pivot tables with sums of values by stage, by salesperson, or by period. - Connect the spreadsheet to Looker Studio (formerly Google Data Studio) and build interactive dashboards that update automatically. This approach gives you total freedom to cross-reference CRM information with other sources and create views that native reports do not yet cover. Who this integration is useful for - Sales managers who need to track the pipeline in real time and share dashboards with leadership. - Operations analysts who want to combine funnel data with marketing or financial metrics. - Sales teams that already use Google Sheets as an information hub and want to eliminate manual report exports. Frequently asked questions Do I need to know how to code to configure the Webhook? Not necessarily. Using platforms such as Zapier or Make, the integration is no-code. Only the Google Apps Script option requires basic JavaScript knowledge. Is the data sent in real time? Yes. As soon as the trigger configured in the Flow is fired (e.g., new deal created), the Webhook sends the data immediately to the spreadsheet. Can I export data from more than one funnel? Yes. You can create separate Flows for each funnel or use a single Flow that captures deals from all pipelines, then filter in the spreadsheet by the “pipeline” column. Is it possible to send data when a deal changes stage? It depends on the triggers available in the Flows module. If there is a card movement trigger (e.g., “Deal Updated”), you can configure a Flow to update the corresponding row in the spreadsheet. Check the options inside the Flows editor. How do I create funnel charts in Google Sheets? Once the data is in the spreadsheet, use the “Funnel chart” feature (available in the Insert > Chart menu) or build a table with counts by stage and generate a stacked bar chart. What should I do if the Webhook fails? Check that the URL is active and that the intermediary service (Zapier, Make, or Apps Script) has not reached usage limits. In the Flow history inside Papo, you can see execution statuses and identify any errors. Read also - How to create and customize your sales funnel in the Kanban CRM - How to Save Papo Leads to Google Sheets with Webhooks Start for free and automate your funnel export → With the first user free, you can already configure Webhooks and start building custom dashboards with your CRM data.

How to analyze Live Coach performance with suggestion reports

To analyze the performance of Papo's Live Coach (https://papo.global/) and measure how many suggestions were accepted and the impact on sales, you should combine data from the Agent Report with conversion indicators from the sales funnel. Although the platform does not display an explicit suggestion acceptance counter, the AI copilot's performance is directly reflected in sales reps' productivity: an increase in conversion rate, a reduction in first response time, and an improvement in CSAT, as shown in the account reports. This integrated view allows managers to optimize training and adjust the playbook to get the most out of every interaction. Papo offers reports that show individual agent performance and the health of the sales funnel. When you activate Live Coach, you gain contextual suggestions generated by AI in real time, based on your sales playbook. To assess whether this tool is truly driving results, it is essential to look at the right numbers. | Key metric | What it measures in the context of Live Coach | Why it matters for optimizing training | | :--- | :--- | :--- | | Conversion Rate | Percentage of conversations that turn into closed deals ("won" cards in Kanban). | The most direct metric to quantify Live Coach's impact on sales. Compare the rate before and after activation. | | Time to First Response | Average time an agent takes to start handling after the customer's first message. | Ready-made Live Coach suggestions enable faster responses, reducing this time and improving the lead's experience. | | Sales Volume (R$) | Sum of the values of closed deals in the period. | Indicates whether increased efficiency translated into higher revenue. Track month-over-month evolution. | | CSAT (Satisfaction) | Average customer satisfaction score attributed to the agent. | Suggestions aligned with the brand's tone of voice tend to raise service quality, which is reflected in CSAT. | | Conversation Volume | Total number of conversations handled by the agent in the period. | An increase in this volume without a drop in quality suggests that Live Coach is helping the salesperson be more productive. | How to evaluate Live Coach performance in practice There is no single "accepted suggestions" report, but structured analysis of three Papo data sources reveals Live Coach's impact in a practical way. 1. Establish a baseline (before Live Coach) Before activating the assistant for a team or inbox, access the Agent Report and Sales Report. Record the baseline values for conversion rate, response time, and CSAT for the next 7 to 30 days. This is your baseline. 2. Track progress after activation With Live Coach in operation, return to the same reports after at least one or two weeks. The Agent Report quickly shows whether efficiency indicators improved. In parallel, the Sales Report confirms whether improvements translate into more closed deals and higher total revenue. 3. Relate the data to team actions If conversion rate did not improve, for example, review the sales playbook — perhaps the mapped objections need adjustment or new arguments have emerged. Use the metrics to guide targeted training. The report information indicates which agents are performing best and can serve as a model for the others. 4. Compare longer periods and different team compositions Perform a comparative analysis over 30, 60, and 90 days. This helps distinguish a one-off improvement from a consistent trend attributable to Live Coach use. Who this analysis is for - Sales managers and sales leaders who want to measure the return on investment in AI training. - Customer service supervisors who need to identify operational bottlenecks and guide their analysts with real data. - Those responsible for sales strategy who want to validate whether the current playbook fits the profile of the customers served. Frequently Asked Questions How can I measure acceptance of Live Coach suggestions? Directly, the Papo platform does not display a counter for "suggestion accepted" vs. "suggestion ignored." However, you can infer acceptance by monitoring the evolution of performance indicators (conversion rate, response time, CSAT) after Live Coach is introduced. Consistent improvements indicate that sales reps are using the AI guidance effectively. Does Live Coach improve sales in a measurable way? Yes, and the way to measure it is through an increase in conversion rate and closed revenue volume in the sales reports. Papo provides the Agent Report and the Sales Report, which let you compare results before and after using the copilot. Which reports should I consult to evaluate Live Coach? The two main ones are the Agent Report (for individual efficiency metrics) and the Sales Report (for conversions and revenue). Occasionally, the Team Report helps if you have teams that use Live Coach and teams that do not, enabling a comparison between groups. Do I need to configure anything to see suggestion metrics? There is no extra configuration. The performance and sales reports are already active by default in your Papo account. Just make sure Live Coach is correctly configured (playbook filled in and inbox_ids associated) so that its suggestions influence agents' work. What should I do if the conversion rate does not improve after activating Live Coach? Review the following points: does the playbook contain real objections and up-to-date arguments? Does the chosen tone of voice (consultative, direct, friendly, formal) match the customer profile? Are the correct inboxes associated? Also compare in the Agent Report whether response time worsened for any operational reason. The report data itself points to where to focus the adjustment. Does Live Coach data appear in the Agent Report? The suggestions themselves are not listed, but their effect appears in the metrics the Agent Report displays: response time, conversation volume, and CSAT. Therefore, by analyzing these numbers, you are indirectly measuring Live Coach's impact. Read also - Understanding the Agent Report: How to analyze your team's productivity - Understanding the Sales Report: How to analyze your conversion rates? - How to structure an effective sales Playbook to train Live Coach Start for free now → With Papo, you evaluate the real impact of AI on your sales through integrated reports, with no initial cost.

How to interpret the Agents Report to measure response time

To interpret Papo's Agents Report (https://papo.global/) and measure response time, go to the Reports module and open the Agents section. There you'll find metrics such as average response time, first response time, resolved conversations, and SLA, allowing you to identify bottlenecks, compare agents, and improve service agility. Measuring the performance of your customer service team requires looking beyond conversation volume. The time each agent takes to respond has a direct impact on customer satisfaction and sales conversion. Papo's Agents Report consolidates these indicators in one place, with period filters and rankings that make it easier to read and make decisions. Summary of Agents Report metrics | Metric | What it measures | How to use it to improve performance | | :--- | :--- | :--- | | Average response time | Average time an agent takes to send the first response to a new conversation | Compare agents with each other, identify overload, and redistribute demands | | First response time | Time until first contact with the customer after the conversation is opened | Ensure no customer is left waiting without a reply; reduce it with automations or AI | | Resolved conversations | Number of conversations an agent completed in the period | Measure individual and team productivity; recognize good performance | | SLA (Service Level Agreement) | Percentage of interactions handled within the expected response time | Monitor goal compliance by agent or team; trigger training when below expectations | How to access and read the Agents Report The Agents Report is part of Papo's Reports module, the central hub for operation metrics. To interpret response time data, follow this path: 1. In the side menu, click Reports. 2. Apply the desired period filter — typical options include Today, Last 7 days, and Last 30 days. 3. Open the Agents Report, which shows the individual performance ranking. 4. Look at the Resolved conversations and SLA columns to see who is meeting goals. 5. Analyze the time metrics per agent: average response time indicates each attendant's initial agility. 6. Compare numbers across different periods to detect trends or sudden declines. Period filters are essential. An average time that seems acceptable over the last 30 days can hide slowdown peaks on specific days. Adjust the analysis window to investigate higher-volume days, such as Mondays or after marketing campaigns. What time metrics reveal about the team High or rising average response time An increase in average response time generally indicates team overload, failures in conversation distribution, or inefficient processes. If an agent's average is much higher than their colleagues', they may have more conversations assigned or need training. Using Papo's AI to provide the first response, greet the customer, and perform initial triage can drastically reduce this time, ensuring no contact is left without a reply. First response time and SLA SLA shows the percentage of interactions answered within the agreed deadline. If an agent's or team's SLA is below expectations, first response time is probably high. Compare SLA with average response time to confirm whether the slowdown is concentrated at the beginning of the conversation or spread throughout the service. Differences between agents The Agents Report ranking makes it easy to quickly identify top performers and those who may need support. Agents with many resolved conversations and good response time can share best practices with the rest of the team. Those with high average time and low SLA deserve individual attention. Who this report is most useful for The Agents Report makes the most sense for: - Supervisors and customer service managers who need to track SLA goals. - Operations with a high volume of messages on WhatsApp, Instagram, or other connected channels. - Teams that want to reduce response time without increasing the number of agents. - Leaders who evaluate individual productivity fairly and based on data. If your operation doesn't use automations yet, the report also helps justify implementing quick replies, chatbots, or AI agents to absorb the first interactions and free up the human team for complex cases. Frequently asked questions What does average response time mean in the Agents Report? It is the average time an agent takes to send the first response to a new conversation. It measures the initial agility of service and is one of the main indicators of customer satisfaction. What is the difference between average response time and first response time? In practice, average response time in the Agents Report refers to the time until the agent's first message in a conversation. First response time, when displayed in conversation reports, follows the same principle of first contact after the conversation is opened. Both indicators point to initial agility, but they may be in different sections of the Reports module. How does SLA appear in the Agents Report? SLA appears as a percentage of interactions handled within the expected response time. Each agent has their own percentage displayed in the ranking, allowing you to compare goal compliance individually. Can I filter the report by team? Yes. Papo lets you organize agents into teams. In the Reports module, you can apply filters to view performance metrics consolidated by team, in addition to the individual view by agent. How often should I analyze these times? A weekly analysis is recommended, or at least every 7 days, using the corresponding period filter. For very dynamic operations, daily analysis may be necessary to act quickly during demand peaks. Does the Agents Report also show customer satisfaction? Yes. In addition to time metrics, Papo's Reports module displays CSAT results, with scores from 1 to 5 and a list of recent responses linked to the agent and the conversation. This allows you to cross-reference agility with perceived quality. Read also - How to create an automation to send a CSAT survey at the end of each service - How to add and manage your team members in Papo? Start for free and monitor your response times → Centralize WhatsApp, Instagram, and other channels in a single inbox with Papo and have AI respond in 2 seconds so your team can focus on what matters.

How to generate a monthly productivity report by agent

To generate a monthly productivity report by agent in Papo (https://papo.global/), go to the Reports module, open the Agent Report, and set the period filter to the desired month. This way you can view resolved conversations, average response time, and satisfaction score (CSAT) for each team member side by side. With this monthly view, managers can assess team progress, compare workload, and quickly identify who needs support or recognition. Papo's Agent Report organizes the main service metrics in a clear ranking, eliminating spreadsheets and making data-driven decisions easier. Summary of monthly report metrics | Metric | What it shows in the report | Importance for monthly management | | :--- | :--- | :--- | | Resolved conversations | Total conversations completed by the agent in the selected period. | Measures individual productivity and helps balance workload among agents. | | Average response time | Average time the agent takes to send the first message to the customer. | Indicates agility; high values may signal overload or the need for automation at the start of the conversation. | | Individual CSAT | Average score (1 to 5 stars) customers gave to that agent's conversations. | Reflects service quality. Essential for feedback, recognition, and targeted training programs. | | SLA (Service Level Agreement) | Percentage of conversations answered within the internal deadline the company defined. | Tracks compliance with response time goals and reveals operational bottlenecks. | How to access the monthly report by agent Before generating the report, every professional who serves customers must be registered as an agent on the platform, in Settings > Agents. Only then will their conversations be counted in the metrics. With agents registered, follow these steps: 1. In Papo's side menu, click Reports. 2. In the metrics module, find and open the Agent Report — it shows the individual performance ranking. 3. Use the period filter to select the month you want to analyze. Typical options include Today, Last 7 days, and Last 30 days, but you can also choose custom dates to cover exactly the month of interest, for example, from day 1 to day 31. 4. The report will display a list of all agents on the account and their respective columns for Resolved conversations, Average response time, CSAT, and SLA. 5. To compare monthly evolution, switch the filter between different periods and observe each agent's trends. How to interpret productivity data The monthly report works as a snapshot of team performance. When analyzing it, focus on three aspects: - Comparison between agents: an agent with many resolved conversations and high CSAT is a model to replicate. Those with high response time or SLA below expectations may be overloaded or need training. - Evolution over the months: compare the January report with the February report to see whether operational changes (such as new automation flows or team reinforcement) had an effect. - AI contribution: Papo's Artificial Intelligence also appears as an "agent" in the report, showing how many conversations were resolved automatically. This helps quantify how much automation relieves the human queue. Who this report is most useful for The monthly report by agent is recommended for: - Service supervisors who hold one-on-one meetings and performance reviews. - Companies seeking SLA goals and wanting to distribute workload in a balanced way. - Teams using WhatsApp, Instagram, Telegram, or other channels integrated into the same Papo inbox. - Managers who need to justify investments in AI or new hires based on data. Frequently asked questions Can I generate the report for a period other than 30 days? Yes. Papo's period filter allows you to select custom dates, so you can analyze any interval — a week, two weeks, or a quarter, for example. Does the report show each agent's satisfaction score (CSAT)? Yes. The CSAT column displays the average rating customers gave to that agent's conversations in the selected period, usually on a scale of 1 to 5. Does Papo's AI appear in the Agent Report? Yes. The platform includes Artificial Intelligence as an "agent" in the list, informing the number of conversations resolved automatically and the corresponding SLA percentage. This allows you to measure the impact of automation on the operation. Are all agents on the account displayed at once? The report presents the complete ranking of all registered agents, making side-by-side comparison easy. There is no internal filter to show only one agent, but the columns allow individual focus. How does the report help justify training? Agents with low CSAT or high response time appear highlighted. With this data, you can open the specific conversations that received negative ratings and prepare precise feedback or focused retraining. Do I need to export data to build the monthly report? No. Papo's Agent Report already organizes the metrics for the chosen period directly in the dashboard. You check the numbers and make decisions without external spreadsheets. Read also: - How to interpret the Agent Report to measure response time Start for free and monitor your team's productivity with real-time reports → Papo brings service channels, CRM, and AI together in the same panel, at no cost for the first user.

How to schedule automatic email report delivery to managers

Yes, you can schedule automatic email report delivery in Papo (https://papo.global/) using the Flows module. The platform combines the artificial intelligence that already analyzes conversations, deals, and productivity metrics with a scheduled sending action, delivering daily, weekly, or monthly summaries straight to the manager's inbox with no manual work. With this automation, anyone responsible for the operation receives exactly the slice they need: volume and sentiment of conversations, closed sales pipeline, or individual agent performance. Papo's AI extracts and summarizes the data automatically, and the email arrives at the interval you define. | Report type | Data source in Papo | Example of information the AI can summarize | | :--- | :--- | :--- | | Conversations | Conversations module (last period) | Total tickets, pending, leads with the highest score, frequent tags, sentiment analysis | | Sales (Kanban) | Kanban module (won deals) | Closed deals (Won) with value, date, funnel, and owner | | Agent productivity | Reports module (per-agent metrics) | Conversations handled, average response time, resolutions within SLA | | Custom | Combination of modules via AI prompt | Any summary the manager needs — just describe what the AI should fetch and group | How automatic report delivery works The core of the automation is in the Flows module. You create a flow that starts with a scheduled trigger (daily, weekly, or monthly), runs an AI action to generate the desired report, and ends with an email sending action. 1. Scheduled trigger: The Flow starts automatically at the defined interval — every day at 8 p.m., every Monday morning, or once a month. 2. AI summarization action: An AI node receives a custom prompt. The artificial intelligence queries the relevant information (conversations, Kanban, agent reports) and returns structured text. 3. Email delivery: The generated summary is inserted into the body of an email and sent to the manager (or list of recipients) using an SMTP credential already configured in the account. The result is a report that arrives without anyone having to open the dashboard, export spreadsheets, or compile data manually. Step by step to create an automatic report flow Prerequisite: email sending credential Before building any report flow, you must have an email inbox configured for sending. In Settings → Inboxes, add an inbox of type Email and fill in the SMTP server details (server, port, user, and password). We recommend services such as Amazon SES or SendGrid to ensure high deliverability. 1. Create a new Flow Go to the Flows module in the side menu and click to create a new flow. Give it a name that identifies the report, for example "Daily sales summary" or "Weekly agent report". 2. Configure the scheduled trigger Add a Trigger node and choose the scheduling option. Set the frequency (daily, weekly, monthly) and the exact time when the summary should be generated and sent. For after-hours reports, a time such as 7 p.m. or 8 p.m. works well. 3. Add the AI action with the report prompt Insert an Action node that uses Papo's artificial intelligence. The secret lies in the prompt: describe exactly which data the AI should fetch and how it should organize it. Practical examples: - Conversations report: "Consider the conversations from the last 24 hours. Bring the total number of tickets, how many are pending, the 5 contacts with the highest lead score, the 3 most applied tags, and a brief sentiment analysis." - Sales report (Kanban): "List the deals marked as Won in the Kanban, grouped by funnel. For each deal, provide the value, closing date, and responsible agent." - Agent productivity report: "Based on data from the Reports module, summarize for each agent: number of conversations handled, average response time, and percentage of conversations resolved within SLA." The AI will return text ready to be inserted into the email. 4. Add the email sending action After the AI node, include an Action node of type Send email. Select the credential configured in the prerequisite, enter the recipient (or multiple recipients), and use the variable with the summary generated in the previous step as the message body. The subject can be fixed, such as "Sales report – {{date}}". 5. Activate and test Save and activate the flow. To validate it, you can force a manual run (if available) or wait for the next scheduled time. Check that the email arrives and that the content matches expectations; adjust the AI prompt as needed to refine the information. Who this automation is useful for - Support managers who need a daily X-ray of the operation without having to access the dashboard. - Sales supervisors who want to know daily which deals were closed, by whom, and for what value. - Team coordinators who track each agent's productivity weekly or monthly. - Business owners who outsource part of their support and want a regular summary of quality and volume. - Multichannel operations that need to consolidate information from WhatsApp, Instagram, email, and other channels into a single report. Frequently asked questions Can I create one flow to send a sales report and another for a conversations report? Yes. You can create as many flows as needed, each with its own trigger, AI prompt, and recipients. Just clone an existing flow and adjust the prompt for the new report type. Can the AI access data from Kanban and the Reports module? Yes. The platform is built so that the artificial intelligence interacts with the main modules, including Kanban and Reports. Just instruct it in the prompt what to fetch — for example, won deals or agent metrics — and the AI will bring the information available for the period. What sending frequency can I schedule? The Flows scheduled trigger allows daily, weekly, or monthly intervals, with an exact time defined. So you can have daily reports, every Monday, or on the first day of every month. Do I need a specific SMTP credential to send the emails? Yes. You need to have an email inbox configured as type Email in Papo, with valid SMTP server details. Without it, the flow cannot send the message. Is it possible to include more than one recipient in the same report? Yes. In the email sending action you can enter a list of recipients, separating the addresses with commas, or use a group of managers. Can I customize the email subject with the report date? Yes. In the email action configuration, the subject field accepts fixed text and variables, such as "Daily summary – {{date}}". The platform replaces the variable with the flow's execution date. Read also - How to create a flow that sends a daily summary of conversations by email - How to generate a monthly productivity report per agent Start for free and automate your reports now → With Papo, you centralize support, CRM, and reports in a single platform, and the free plan already lets you get started at no cost.

How to export report metrics to external spreadsheets

To export metrics from Papo reports (https://papo.global/) to spreadsheets such as Excel or Google Sheets, you can use the platform's public API or configure webhooks that send data in real time to automation tools. This integration lets you create custom dashboards and analyses beyond the native panels, combining conversation information, agent performance, and sales funnel results. Papo already offers a complete reports hub with views on service volume, SLA, conversions, and agent ranking. However, there are scenarios where you need to cross-reference this data with internal spreadsheets, calculate proprietary metrics, or consolidate information from multiple sources. Instead of exporting manually, the API and webhooks automate this flow. Summary of export methods | Method | Best for | How it works in Papo | | :--- | :--- | :--- | | Reports API | Scheduled queries and custom dashboards | REST endpoints that return agent and CSAT metrics in JSON format; can be consumed by scripts or ETL tools. | | Webhooks | Receiving real-time events (e.g., new closed deal) | Papo sends HTTP notifications to a configured URL whenever a certain event occurs, such as a sale moved to "Won" in Kanban. | | Manual export (via interface) | One-off, quick analyses | Inside the Reports module, you can view and copy data, but there is no direct download button for CSV. The API is the recommended route for exporting larger volumes. | How to export metrics with the Papo API The Papo API allows you to programmatically access the same data you see in reports. Currently, endpoints are available to query performance summary by agent and satisfaction metrics (CSAT). To consume this data in spreadsheets: 1. Generate your API credentials Go to the API settings in your Papo account and create a public/private key pair. This process is detailed in the article How to generate a public key and a secret key for the Papo API. 2. Choose the consumption tool You can use Google Sheets with Apps Script, an automation platform such as N8N or Zapier, or even an Excel spreadsheet with Power Query queries. The important thing is that the tool can make authenticated HTTP requests. 3. Build the request Conceptual example: to get performance by agent, make a GET call to the corresponding endpoint (the exact documentation is available in the Papo API portal). Pass the authentication keys and, if desired, period parameters (since and until in Unix timestamp). 4. Turn the data into a table The response will come in JSON with fields such as resolved_count, sla_percentage, and avg_first_response_time. In your spreadsheet, structure this data into columns and, if necessary, automate updates with time-based triggers. Complete instructions with endpoints, parameters, and sample code are in the official Papo API documentation, accessible after login. How to use webhooks to feed spreadsheets in real time If your need is to capture sales events or conversation updates immediately, webhooks are the best option. In Papo, you can configure destination URLs where the platform will send notifications when a relevant action occurs, such as a deal moved to the "Won" column in Kanban. To integrate this with spreadsheets: 1. Use an automation tool as an intermediary Because the webhook sends data to a URL, you need a receiver that interprets it and inserts it into the spreadsheet. The guide to sending new contact data to Google Sheets via webhook explains the basic principle, which can be adapted for sales events. 2. Configure the webhook in Papo In your account settings, enter the URL generated by the intermediary tool (N8N, Zapier, etc.). There you can map which event should trigger the send (for example, "deal closed"). 3. Structure the spreadsheet automatically Each new event will add a row to your spreadsheet with data such as deal value, contact, responsible agent, and date. With this, you build an incremental history for funnel and commission analyses. Who this export is useful for - Data and BI analysts: who need to cross-reference service metrics with data from other sources (ERP, external CRM) using tools such as Power BI or Google Data Studio. - Financial managers: who want to calculate commissions based on Kanban winnings in an automated way. - Operations teams that already have external dashboards: and want to feed those panels with conversation data without leaving their current flow. - Teams that need custom reports: that go beyond the standard templates in Papo's Reports module. Does Papo offer a download button for reports in CSV or Excel format? Currently, Papo's Reports module does not have a native feature for direct export to CSV or Excel. The recommended way to bring data into external spreadsheets is through the API, which provides the same data in a structured and updatable way. What metrics are available in the API? Papo's public API provides endpoints to query performance summary by agent (resolved conversations, SLA, etc.) and CSAT survey responses (ratings from 1 to 5). The official documentation lists all available fields. Can I export sales funnel data (Kanban)? Yes. Although the specific Kanban endpoint is not detailed in the reference material provided, you can use webhooks to capture events when a deal is moved to "Won" and thus feed spreadsheets with values and contacts. Consult the API documentation for additional endpoints. Do I need to know how to code to use the API? It depends on the level of automation desired. Tools such as Zapier and N8N allow you to create integrations with little or no coding. For more complex scripts, basic knowledge of HTTP requests and JSON handling is enough. Where can I find the complete API documentation? The complete documentation, with endpoints, parameters, and examples, is accessible in the Papo API portal (https://papo.global/docs) right after you log in to the platform. Can I use webhooks to feed Google Sheets? Yes. Configure a webhook in Papo pointing to an intermediary URL (via N8N, Zapier, or Apps Script), which in turn inserts the data into Google Sheets. See the basic guide in How to send new contact data to Google Sheets via webhook. Read also - How to generate a public key and a secret key for the Papo API - How to send new contact data to Google Sheets via webhook - How to generate a monthly productivity report by agent - Reports overview: where to find each metric in Papo Start free → Centralize your metrics in spreadsheets for advanced analyses and make data-driven decisions without relying on manual exports.

How to generate a conversation report by channel and export data to CSV

To generate a conversation report by channel in Papo (https://papo.global/), access the Reports module and open the conversation report. With it, you filter the desired period, select the channels you want to compare, and view volume, average response time, conversions, and SLA by source. The displayed table can be exported to CSV and opened in external spreadsheets. Process summary | Step | What to do | Result | | :--- | :--- | :--- | | Access Reports | Enter the Reports module in Papo. | See the available metrics dashboards. | | Filter period | Choose Today, Last 7 days, Last 30 days, or custom dates. | Limit the analysis to the desired interval. | | View by channel | View the report broken down by source channel (WhatsApp, Instagram, Facebook, email, etc.). | Compare volume and performance across channels. | | Export CSV | Use the export available in the report. | Download the table and open it in Excel, Google Sheets, or another editor. | What the conversation report by channel shows Papo brings connected channels together in a single inbox, and the same data appears in the Reports module. The conversation report by channel helps answer questions such as: - Which channel generates the most conversations? - Where is the average response time highest? - Which source converted the most in the period? - Which channel is furthest from the SLA target? Each row in the report represents a channel or a comparison metric across channels. Data is updated from real conversations in the operation, so manual spreadsheets and screenshots are not needed. How to filter and export the data The flow is simple. The important thing is to apply filters before exporting, because the CSV reflects the view visible in the report. 1. Access the Reports module in Papo. 2. Open the conversation report. 3. Set the analysis period: Today, Last 7 days, Last 30 days, or a custom range. 4. Apply the channel filter to compare the desired sources. 5. Check the volume, average response time, conversions, and SLA columns. 6. Export the table to CSV. The file can be opened in any spreadsheet editor to create charts, cross-reference with other data, or share with the team. If your account has specific retention rules or export limits, check the help center or the Papo website for updated details. Metrics for comparing channels | Metric | What it indicates | Practical use | | :--- | :--- | :--- | | Conversation volume | Total conversations for each channel in the period. | Identify channels with the highest demand. | | Average response time | Time until the first reply to the customer. | Find channels with slow service. | | Conversions | Conversations that became an opportunity or deal. | Focus sales efforts on the channels that convert the most. | | SLA | Percentage of replies within the defined deadline. | Track targets by channel. | | Percentage distribution | Share of each channel in the total. | Assess operational concentration. | These metrics are the same ones used in other Papo reports, such as the Agent Report and the Tag Report, but organized by source channel. Who this report is useful for The conversation report by channel is recommended for: - Coordinators who need to distribute agents across WhatsApp, Instagram, and email. - Analysts who track the performance of each source over time. - Companies that use multiple channels in the same operation and want to identify where it is worth investing. - Managers who need to justify hires or workflow changes with data by channel. The CSV export is especially useful for those who need to consolidate information with other areas, such as finance, marketing, or planning. Frequently asked questions Can I export only one channel to CSV? Yes. By applying the channel filter before exporting, the generated file follows the view visible in the report. Does the report show WhatsApp and Instagram in the same chart? Yes. Papo centralizes connected channels, so the report lets you compare sources side by side, including percentage distribution. Does the CSV include agent data and tags? The conversation report by channel focuses on performance by source. Individual agent data appears in the Agent Report, and tag distribution appears in the Tag Report. Do I need to configure anything before generating the report? The channels must already be connected and receiving conversations. The Reports module automatically consolidates operation data. Is there a row limit for CSV export? Limits may vary depending on the period and plan. For updated information, check the help center or the Papo website. Read also - How to export report metrics to external spreadsheets - How to generate a monthly productivity report by agent Start for free and see your conversations by channel in a single report → The first user is free so you can validate the flow.

How to schedule automatic weekly sales report sending

Yes, you can schedule automatic sending of a weekly sales report in Papo (https://papo.global/) using the Flows module. The platform combines the artificial intelligence that already analyzes the Kanban pipeline with a scheduled sending action, delivering a weekly sales funnel summary to the manager's email, with no manual work. With this automation, the person responsible for sales operations receives exactly the breakdown they need: closed deals, total value, breakdown by funnel, and responsible agent. Papo's AI extracts and summarizes the data automatically, and the email arrives on the day and time you set. | Step | Action | Where to configure | | :--- | :--- | :--- | | 1 | Configure an SMTP email credential | Settings → Inboxes | | 2 | Create a Flow with a weekly trigger | Flows module | | 3 | Add an AI action to generate the Kanban summary | Action node in the Flow (AI) | | 4 | Include an email sending action with the summary | Email action node | | 5 | Activate and test the flow | Flows module | How the automatic weekly report works Papo already uses artificial intelligence to monitor the CRM in real time — card movement, values, and owners. The weekly flow simply schedules the collection of this information and sends it by email. 1. Scheduled trigger: The Flow starts automatically once a week, on the day and time you set (e.g., every Monday at 8 AM). 2. Collection and summarization: An AI action queries the Kanban data for the period (last week) and generates a summary with won deals (Won), total value, breakdown by funnel, and owner. 3. Email sending: The generated text is inserted into the body of an email and sent to the manager (or distribution list) using the SMTP credential configured in the platform. The result is a report that arrives every week without anyone needing to open the dashboard, export spreadsheets, or compile data manually. Step-by-step to create the weekly sales report flow Prerequisite: email sending credential Before building the flow, you need to have an email inbox configured in Papo for sending. Go to Settings → Inboxes, add an inbox of type Email, and provide your SMTP server details (server, port, user, and password). It is recommended to use services like Amazon SES or SendGrid to ensure deliverability. 1. Create a new Flow In the side menu, go to the Flows module and click to create a new flow. Give it a descriptive name, such as “Weekly sales report”. 2. Configure the weekly trigger Add a Trigger node and choose the weekly scheduling option. Set the day of the week and time when the summary should be generated and sent — for example, every Monday at 8 AM, so the manager starts the week with updated numbers. 3. Add the AI action for summarization Insert an Action node that uses Papo's artificial intelligence. Configure the prompt so that the AI: - Queries the Kanban deals from the last week. - Lists cards marked as Won, grouped by funnel. - For each deal, reports value, closing date, and responsible agent. - Optionally, includes a summary of open or lost deals, if the manager needs a complete view of the funnel. The AI will return a structured text that will serve as the email body. 4. Add the email sending action After the AI node, include another Action node of type Send email. Select the credential configured in the prerequisite, enter the recipient's address (manager), and use the variable with the summary generated in the previous step as the message content. You can also set a fixed subject, such as “Sales report – Week {{date}}”. 5. Activate and test Save the flow and activate it. To test, you can force a manual execution (if available) or wait for the next scheduled time. Check that the email arrives correctly and that the content reflects the Kanban data. Adjust the AI prompt as needed to include exactly the information the manager needs. Who this automation is useful for - Sales managers who need to track the sales team's performance weekly. - Operations directors who want a consolidated view of closed deals without entering the CRM. - B2B companies with long sales cycles, where the weekly summary helps maintain focus on results. - Operations with multiple funnels that want to consolidate wins from different pipelines into a single report. Frequently asked questions Do I need to have an email credential configured before creating the flow? Yes. Sending the report depends on an email inbox with SMTP configured in Papo. Without it, the flow will not be able to send the message. Can the AI pull data from all Kanban funnels? Yes. In the prompt, you can specify which funnels should be considered. If none are mentioned, the AI can bring data from all active pipelines in the account. Can I send the report to more than one manager? Yes. In the email sending action, you can enter multiple recipients separated by commas, or set up a distribution list. Does the report include only won deals or the entire funnel? The content depends on the prompt you configure. You can request only Won deals, or a complete summary with cards at each stage (open, won, lost). Is it possible to customize the prompt to include other metrics? Yes. Papo's AI is flexible: you can request, for example, the sum of values by agent, the funnel conversion rate, or a comparison with the previous week. What to do if the email does not arrive? Check that the SMTP credential is active and that the flow has the status “active”. Also check that the recipient is not blocking the sender. If the problem persists, contact Papo support. Read also - How to schedule automatic email report sending to managers - How to use Kanban to track the financial value of each funnel stage Start for free → The first user on the platform is R$ 0, allowing you to validate automatic sales report sending at no cost.

How to Interpret the Email Marketing Campaign Report

Papo's Email Marketing Campaign Report (https://papo.global/) brings together metrics such as emails sent, open rate, clicks, replies, bounces, unsubscribes, and CTOR, and also shows the best time to send based on open data. With this information, you identify which one-shot campaigns or sequence steps are generating engagement and where to adjust content, audience, or scheduling to improve results. Summary of metrics and how to interpret each one In the Email Marketing module, the overview screen presents the main indicators. Reading each metric correctly prevents hasty conclusions and guides campaign optimization. | Metric | What it shows | Practical reading | | :--- | :--- | :--- | | Emails sent | Total sends made | Base volume for calculating the other rates and comparing campaigns. | | Average open rate | Opens in relation to sends | Indicates whether the sender, subject, and time sparked interest. | | Average click rate | Clicks on links in the email | Shows whether the offer, copy, and call led to action. | | Reply rate | Replies received | Signals qualified engagement and potential for conversation with the lead. | | CTOR (Click to Open Rate) | Clicks over opens | Evaluates content quality after the email was opened. | | Unsub rate | Unsubscribe rate | Indicates whether frequency, relevance, or segmentation are bothering the audience. | | Bounce rate | Rate of rejected emails | Reveals deliverability problems or contact list quality issues. | | Best Time to Send | Visual grid with the times of highest opens | Helps schedule sends for moments of highest engagement. | How to analyze one-shot campaigns and sequences Below the daily activity chart, the report splits results into two sections: - One-Shot Campaigns: shows single-send campaigns, with total sent and average open rate. - Sequences: lists the best-performing email sequences, showing the number of emails sent and the average open rate for each one. This split lets you quickly compare what works in isolated sends and what works in an automated email series. Detailed report by sequence When you click a specific sequence, Papo opens a report with two main parts: - Daily Activity Chart: shows the evolution of emails sent, opened, clicks, replies, and bounces over the last few days. - Step-by-Step Stats (Stats by Step): details the performance of each email in the sequence, including subject, delay, delayed emails, sent, opens, clicks, CTOR, unsubscribe rate, and bounce rate. With this step-by-step view, you identify exactly which email in the sequence has low open or low click conversion and can adjust just that point, without redoing the entire campaign. How to use interaction-based segmentation The Audience Segmentation feature lets you generate segmented lists based on specific interactions with the campaign. For example, you can create an audience of people who opened an email but did not click; people who replied; contacts that failed; or emails that bounced. This lets you create highly targeted follow-ups: re-engage those who showed initial interest, fix delivery issues, or send a new message only to those who did not interact, without bothering those who have already moved forward. Who this report is for - Marketing and growth teams who want to improve the performance of one-shot campaigns and sequences. - Pre-sales and SDRs who do email nurturing and need to prioritize engaged leads. - Customer service and sales managers who want to track email channel performance in the same dashboard as the CRM and WhatsApp. Frequently asked questions What does CTOR mean? CTOR stands for Click to Open Rate, that is, the click rate over opens. It measures the effectiveness of the email content for those who already opened the message. If the open rate is high but CTOR is low, the problem is usually in the offer, the copy, or the call to action inside the email. What is a one-shot campaign? It is a single email send to a selected audience, with no subsequent automated steps. In the report, one-shot campaigns appear with total sent and average open rate for direct comparison. What is a sequence? It is a series of emails sent automatically, with delays between each step. The detailed report by sequence shows the individual performance of each email, allowing you to identify specific bottlenecks in the journey. Does the report show unsubscribes and bounces? Yes. In the step-by-step breakdown of a sequence, Papo presents the unsubscribe rate (unsub rate) and bounce rate of each email, in addition to open, click, and reply metrics. How do I know the best time to send? The Best Time to Send feature shows a visual grid in which darker cells indicate the times and days with the highest open rate. When you click a cell, the system displays the open rate for that period. This way, you schedule campaigns for the moments of highest engagement. Read also - How to list all Sequences and track contact progress - What is the difference between Flow and Sequence in Papo? Start for free → Create your free Papo account and track email marketing metrics in the same dashboard as your CRM.

How to export detailed PDF reports with period filters

In Papo (https://papo.global/), you view detailed reports with conversation, agent, and channel metrics, apply period filters, and save the page as PDF using your browser's print function. This lets you share the data in management meetings without relying on external spreadsheets. Process summary | Step | What to do | Result | | :--- | :--- | :--- | | 1. Access Reports | Go to Papo's Reports module. | See the available metric dashboards. | | 2. Filter period | Select Today, Last 7 days, Last 30 days, or a custom range. | Restrict the analysis to the desired period. | | 3. Choose the metrics | View conversation, agent, or channel reports, depending on the meeting focus. | Display volume, average response time, conversions, and SLA. | | 4. Export as PDF | Use the browser print option (Ctrl+P / Cmd+P) and select "Save as PDF". | Get a PDF file with the filtered data ready to present. | How PDF export works in Papo Papo's Reports module brings together customer service and sales indicators in real time, without your needing to open separate spreadsheets. With period filters, you can focus the analysis on the days that matter for the management meeting: yesterday, last week, current month, or a custom range. The platform does not provide an "Export PDF" button, but it lets you turn the view into a PDF file in a practical way: - After applying the filters and reviewing the desired metrics, trigger your browser's print function. - In the destination, choose "Save as PDF" and adjust the layout settings (orientation, margins, and scale) so the report is readable. This way, any reports dashboard — conversations by channel, agent performance, or consolidated view — can be saved and shared without relying on CSVs or screenshots. Step by step: from date selection to PDF file 1. Access the Reports module In Papo's main dashboard, open the Reports section. The platform displays the most recent KPIs for your operation. 2. Apply the period filter At the top of the report, choose from the quick options (Today, Last 7 days, Last 30 days) or set a custom range with start and end dates. The selection automatically changes all displayed numbers. 3. Select the report that best fits the meeting - Conversations by channel report — ideal for comparing volume and SLA across WhatsApp, Instagram, Facebook, and email. - Agent report — shows individual productivity, average response time, resolutions, and SLA compliance. - Consolidated report — overview of messages, conversions, and active agents. 4. Review the metrics and make any adjustments Check that the data matches what will be presented. Charts and tables update automatically according to the filter. 5. Save as PDF Press Ctrl+P (Windows) or Cmd+P (Mac). In the browser print window, select “Save as PDF” as the destination. Adjust the layout if needed and click “Save”. The generated file shows exactly what was visible in the dashboard, preserving charts and tables. Which metrics to bring to the management meeting Depending on the focus of the meeting, you can choose from different Papo reports. The table below summarizes the most common metrics and how to use them. | Report type | Main metrics | Use in management | | :--- | :--- | :--- | | Conversations by channel | Volume, average response time, conversions, SLA | Decide agent distribution and investment in channels. | | Agent performance | Conversations handled, resolutions, individual SLA | Evaluate team productivity and identify training needs. | | Consolidated view | Total messages, conversions, active agents | Present the executive summary of the operation. | You can switch between views and generate a PDF for each one, depending on the meeting agenda. Who this method is useful for - Customer service coordinators who need to bring daily or weekly data to the team. - Sales managers who track conversions by channel and want to present results without spreadsheets. - Performance analysts who want to document how metrics evolve over time. - Companies that use multiple channels and need a consolidated view for planning meetings. PDF export via browser allows any Papo user, even without technical knowledge, to generate a formal document from reports in seconds. Frequently asked questions Does Papo have an “Export PDF” button? No, reports inside the platform do not have a dedicated PDF button. However, you can use your browser's print function to save the page as PDF, keeping the entire filtered view. Does the PDF preserve charts and tables? Yes. The generated file shows exactly what was visible in the dashboard at the time of printing, including bar charts, numbers, and percentage distributions. Can I filter by agent before generating the PDF? Yes. In the agent performance report, the period filter is applied and you can view individual metrics before saving. The PDF will reflect the agent or list of agents displayed. Does export work in any browser? The “Save as PDF” feature is available in major browsers (Chrome, Edge, Firefox, Safari). Layout options may vary, but the final result is the same: a PDF file with the report. Can the PDF be scheduled for automatic sending? Currently, Papo does not include scheduling for sending PDF reports. For this functionality, check the help center or Papo's website to see the available options. Do I need special configuration to export? No. Just apply the desired filters and use the browser print option. No extra permission is required. Read also - How to generate a conversations by channel report and export data to CSV - How to generate a monthly agent productivity report Start free → With Papo, you centralize all reports in real time and bring structured data to any management meeting.

How to customize a productivity report with CSAT and response time metrics

To customize a productivity report with CSAT and response time metrics in Papo (https://papo.global/), go to the Reports module, open the Agent Report, and use the period filters to isolate the desired interval. Then export the data as PDF or CSV, gaining a management view that combines customer satisfaction with team agility. Combining the satisfaction score (CSAT) with average response time lets you evaluate service quality and speed in a single report. Papo organizes these metrics in the Agent Report, and period filters help create precise slices for team meetings, performance reviews, and monthly comparisons. Summary of steps to create the customized report | Step | Action | Result | | :--- | :--- | :--- | | 1. Access Reports | In the sidebar, click Reports and open the Agent Report. | View the agent ranking with the main service metrics. | | 2. Define the period | Use the period filter (Today, Last 7 days, Last 30 days, or custom dates). | Isolate the exact interval you want to analyze, such as a campaign week or a closed month. | | 3. Analyze CSAT and response time | Look at the CSAT (score from 1 to 5) and Average response time columns. | Identify agents with high satisfaction and speed, as well as possible bottlenecks. | | 4. Export the report | Click the export option for PDF or CSV. | Generate a file ready to share with leadership or integrate into management spreadsheets. | How it works: step by step The Agent Report is the starting point for any individual productivity analysis. It already displays, side by side, resolved conversations, average response time, CSAT, and SLA for each agent. To turn this data into a management report focused on CSAT and speed, follow this flow: 1. Access the Reports module – In the Papo sidebar, click Reports. This is the hub that brings together all operation metrics, from conversation volume to sales performance. 2. Open the Agent Report – Within the reports hub, find the Agents section. It shows the full team ranking, with each agent listed and their respective metrics. 3. Apply the desired period filter – The filter lets you select predefined intervals (Today, Last 7 days, Last 30 days) or define a custom period. For a monthly productivity report, for example, choose the dates from the first to the last day of the month. This time slice is what customizes the management view: you can compare performance during high-demand weeks, evaluate the impact of a training, or isolate the period of a specific campaign. 4. Focus on the CSAT and Average response time columns – CSAT shows the average score (from 1 to 5) that customers gave to that agent's conversations in the period. Average response time indicates how many minutes, on average, the agent took to send the first message to the customer. Cross-referencing these two metrics reveals, for example, whether a very fast agent maintains quality or whether slowness is hurting satisfaction. 5. Export the data – In the report itself, there is an option to export the content as PDF (ideal for presentations and documentation) or CSV (for more detailed analysis in spreadsheets). The generated file respects the applied period filter, delivering exactly the slice you defined. For more details on the export process, see the article on how to export detailed reports as PDF with period filters. Who this report is most useful for - Service managers and supervisors who need to present team productivity in results meetings. - Leaders who hold one-on-ones and want to base feedback on objective CSAT and response time data. - Operations with multiple channels (WhatsApp, Instagram, Telegram, etc.) seeking a unified view of individual performance. - Companies that want to justify investments in automation – by comparing periods before and after AI activation, the report shows the evolution of speed and satisfaction. Frequently asked questions Can I export the report with a custom period, such as the last 15 days? Yes. Papo's period filter accepts custom dates. Just define the desired interval and then export the report as PDF or CSV — the file will reflect exactly the chosen slice. Does the Agent Report show each agent's individual CSAT score? Yes. The CSAT column displays the average rating (from 1 to 5) that customers gave to that agent's conversations in the selected period. This lets you compare service quality among team members. How can I compare productivity between two different months? Apply the period filter for the first month, analyze the metrics, and, if desired, export the report. Then change the filter to the second month and repeat the process. Placing the two files side by side (or the data in a spreadsheet) makes it easier to compare the evolution of CSAT and response time. Is it possible to schedule automatic email delivery of this report? Yes, Papo allows you to schedule report delivery by email to managers. This setup is done in a specific automations area, and you can define the frequency and recipients. This way, the productivity report with CSAT and response time arrives automatically in your inbox. What should I do if the average response time is too high? A high response time generally indicates team overload or manual processes that could be automated. Papo offers features such as quick replies, chatbots, and Super Chat (conversational AI) to absorb the first interactions and reduce this indicator. The report itself helps identify which agents or periods concentrate the slowness. Does Papo's AI appear in this productivity report? Yes. Papo's Artificial Intelligence is listed as an “agent” in the Agent Report, showing how many conversations were resolved automatically, the response time, and CSAT (when applicable). This lets you measure the impact of automation on the team's overall productivity. Read also - How to export detailed reports as PDF with period filters - Key indicators to evaluate customer service team efficiency in Papo Start for free → Create your free Papo account and start monitoring your team's productivity with CSAT and response time reports in minutes.

How to export a conversation report filtered by tag to analyze specific requests

To export a conversation report filtered by tag in Papo (https://papo.global/), go to the Reports module, open the conversation report, apply the desired tag filter, and export the table to CSV. This way, you isolate the metrics for a specific topic — such as “Billing Question,” “Hot Lead,” or “Technical Issue” — and bring objective data for analysis in spreadsheets, presentations, or management meetings. Process summary | Step | What to do | Result | | :--- | :--- | :--- | | Access Reports | Go to Papo's Reports module. | View the available metrics dashboards. | | Filter by tag | In the conversation report, select the tag that represents the request you want to analyze. | Isolate only the conversations marked with that tag. | | View metrics | Observe volume, average response time, SLA, and other metrics applied to the tag segment. | Get a quantitative view of the chosen topic. | | Export CSV | Use the export option available in the report. | Download the table and open it in Excel, Google Sheets, or another spreadsheet editor. | Why filter conversations by tag to export Tags are markers applied to conversations to categorize the reason for contact. Each time an agent — or Papo's AI — applies a tag such as “Urgent,” “Follow-up,” or “Interest in the Gold Plan,” valuable data is generated. When you filter the conversation report by one of these tags, you turn individual interactions into a set of metrics that answers questions such as: - How many conversations about “Complaint” did we have this month? - What is the average response time for conversations marked as “Hot Lead”? - Is SLA being met in “Technical Support” conversations? - Which tags consume the most team time? Without this filter, you only see the total volume of the operation. With it, you can isolate a specific request and bring precise numbers to management, the product team, or content planning. How the tag filter works in the conversation report Papo's Reports module automatically consolidates data from all conversations that pass through the platform. The conversation report already presents general metrics, but you can apply a tag filter to restrict the analysis to a single topic. Tags can be created manually by the team or configured to be applied automatically by Papo's AI, which identifies the conversation subject and assigns the corresponding tag. Once tags are in use, the report can separate conversations that received each one. When you select a tag in the filter, the displayed metrics — volume, response time, conversions, and SLA — reflect only conversations with that marking. It is like opening a magnifying glass on one type of request, without other subjects interfering with the numbers. Step by step to export the filtered report 1. Access the Reports module In Papo's main dashboard, open the Reports section. The platform displays the most recent KPIs for your operation. 2. Open the conversation report Within the module, find the report that shows metrics per conversation. It is the same report used to compare channels, agents, or periods. 3. Apply the tag filter In the report, use the tag filter to choose the topic you want to analyze — for example, “Billing Question,” “Access Issue,” or “Requested Quote.” The segment automatically changes all displayed numbers. 4. Review the metrics for the selected topic Observe conversation volume, average response time, SLA percentage, and other available metrics. This data is already isolated for the chosen tag. 5. Export to CSV Use the export option available in the report. The generated CSV file reflects exactly the visible segment — that is, only conversations with the filtered tag. 6. Open in your preferred spreadsheet The CSV can be opened in Excel, Google Sheets, or any other editor. From there, you can create charts, cross-reference with data from other sources, or include the information in presentations. Which metrics you can analyze by tag | Metric | What it indicates | Practical use with tag filter | | :--- | :--- | :--- | | Conversation volume | Total conversations with the tag in the period. | Measure the frequency of a specific request and justify actions. | | Average response time | Time until the first response to the customer in those conversations. | Identify whether urgent topics are being handled quickly. | | SLA | Percentage of responses within the deadline defined for the tag. | Enforce targets by type of request. | | Conversions | Interactions that became an opportunity or deal. | Evaluate the commercial performance of tags such as “Hot Lead.” | | Percentage distribution | Share of the tag in total conversations. | Compare the weight of each request in the operation. | These metrics are the same ones used in other Papo reports, such as the Agent Report and the Channel Report, but now organized around a specific tag. Who this export is useful for - Support coordinators who need to show management the volume of complaints or questions about a product. - Quality analysts who want to monitor response time on sensitive topics, such as “Cancellation.” - Sales leaders who want to isolate conversations marked as “Hot Lead” and track the conversion rate. - Companies with multiple products or services that use tags to separate requests by business line. - Managers preparing planning meetings who need objective data on the main reasons for contact. CSV export allows these professionals to take the numbers outside the platform, combine them with other sources, and build presentations without relying on screenshots. Frequently asked questions Can I export the report with more than one tag at the same time? The tag filter in the conversation report allows you to select one tag at a time. For a combined view of distribution across multiple tags, use the Tag Report, which already consolidates all tags in a single dashboard. Does the exported CSV include the name of the agent who handled each conversation? The conversation report filtered by tag focuses on aggregated metrics for the topic. Individual agent data appears in the Agent Report, which can also be exported. Do I need to create tags before I can filter? Yes. Tags must exist in the account and have been applied to conversations for the filter to return results. You can create tags manually or configure Papo's AI to apply them automatically. Does the filter work with tags applied by AI? Yes. Tags applied automatically by Papo's AI are treated the same way as manual ones and appear in the report filter. Is there a row limit for CSV export? Limits may vary according to the selected period and the plan contracted. For up-to-date information, check the help center or Papo's website. Can I schedule automatic sending of this filtered report? Manual CSV export is the direct way to obtain the file. For sending automations, check the possibilities for integration with webhooks or automation rules in the platform. Read also - How to generate a conversation report by channel and export data to CSV - How to export report metrics to external spreadsheets - How to export detailed reports in PDF with period filters Start for free → Try tag-based report export and present real data to your management at no initial cost.

How to generate a monthly WhatsApp credit usage report

To generate a monthly WhatsApp credit usage report in Papo (https://papo.global/), go to the Reports module, select the WhatsApp channel, set the desired monthly interval, and analyze the volume of conversations and template sends. With CSV or PDF export, you can track API credit usage and plan your costs accurately. Process summary | Step | What to do | Result | | :--- | :--- | :--- | | Access Reports | Go to Papo's Reports module. | View the available metric dashboards. | | Filter period | Choose the desired month (last 30 days or custom range). | Restrict the analysis to the billing period. | | Select WhatsApp channel | Apply the channel filter to show only WhatsApp. | Isolate the conversations and sends that consume credits. | | Analyze volume and templates | Observe the total started conversations and template messages sent. | Estimate credit usage based on Meta's pricing. | | Export data | Use CSV export or save as PDF. | Share the report with finance or use it in cost spreadsheets. | How credit usage works on WhatsApp WhatsApp Cloud API consumes credits according to started conversations and message templates sent. Each customer service conversation or marketing template has a credit cost, defined by Meta. In Papo, you connect your WhatsApp inbox and all interactions go through the platform, generating metrics that help estimate this usage. Papo's Reports module centralizes customer service and sales indicators. Although there is no specific report named “credit usage,” you can use the conversations by channel report to get the volume of WhatsApp interactions and, from there, calculate monthly spend. Step by step to generate the report 1. Access the Reports module In Papo's main dashboard, open the Reports section. You will see the most recent KPIs for your operation. 2. Set the monthly period In the date filter, select “Last 30 days” for the current month or enter a custom range (e.g., 06/01/2026 to 06/30/2026). The selection automatically changes all numbers. 3. Filter by WhatsApp channel Apply the channel filter and check only WhatsApp. This way, the report will show exclusively the conversations and sends made through this channel. 4. Analyze the metrics relevant to credits - Started conversations: each new conversation started by the company (proactive) or by the customer (reactive) may consume credits, depending on the category. - Templates sent: template messages (HSM) approved by Meta consume credits per send. Check the total sends in the period. - Total message volume: useful for an overview, but credit usage is more closely tied to conversations and templates. Papo displays this data in tables and charts, allowing you to quickly identify usage spikes. 5. Export the data - CSV: use the export option available in the report to download a spreadsheet with detailed numbers. You can open it in Excel or Google Sheets and cross-reference it with Meta's price list. - PDF: if you prefer a presentation-ready document, use the browser's print function (Ctrl+P / Cmd+P) and save as PDF. The file preserves the charts and tables for the filtered period. With this data in hand, multiply the number of conversations and templates by their respective credit costs (provided by Meta) to get the estimated usage for the month. Who this report is useful for - Companies that use WhatsApp API at scale and need to control their monthly credit budget. - Agencies and B2B operations that send many marketing or re-engagement templates. - Financial analysts who consolidate customer service channel costs. - Support managers who want to understand whether WhatsApp conversation volume is aligned with credit investment. Frequently asked questions Does Papo have a report dedicated to credit usage? Currently, the Reports module does not have a dashboard named “credit usage.” However, the conversations by channel report, filtered by WhatsApp, provides the volume of interactions that allows you to calculate credit spend. How do I know how many credits each conversation consumes? The credit cost is defined by Meta and varies according to the conversation type (customer service, marketing, utility) and country. Papo displays the volume of conversations and templates; to know the exact value, consult the official WhatsApp Business API price list. Can I export the report with only WhatsApp data? Yes. By applying the channel filter before export, the generated CSV or PDF file will contain only WhatsApp information, making cost analysis easier. Does the report show sent templates separately? The conversations by channel report presents the total interactions. To detail the number of templates sent, you can check the Disparador module or the conversation history, but the overall message volume already serves as a basis for estimating credits. Is there an export or period limit? Limits may vary according to your plan and account data retention. For up-to-date information, consult the help center or Papo's website. Is it possible to schedule automatic sending of this report? Papo does not currently have a native report scheduling feature, but you can manually export the data whenever needed or use webhooks to integrate with BI systems, as described in other help center articles. Read also - How to generate a conversations by channel report and export data to CSV - How to export detailed reports to PDF with period filters Start for free → Monitor WhatsApp credit usage and optimize your costs with the first user free.

How to Generate a Sentiment Analysis Report from Conversations

To generate a sentiment analysis report from conversations in Papo (https://papo.global/), go to the Reports module, apply the sentiment filter (positive, negative, or neutral), and export the data as CSV. This way you can identify customer satisfaction trends and make data-driven decisions. Process summary | Step | What to do | Result | | :--- | :--- | :--- | | Access Reports | Go to Papo's Reports module. | View the available metrics dashboards. | | Filter by sentiment | Select the desired sentiment (positive, negative, neutral). | Isolate only the conversations with that classification. | | View metrics | Observe volume, distribution, and sentiment trends over the period. | Understand the overall mood of customers. | | Export CSV | Use the export option available in the report. | Download the table for analysis in external spreadsheets. | How sentiment analysis works in Papo Papo's artificial intelligence automatically evaluates the tone of every conversation that passes through the platform. As customers interact via WhatsApp, Instagram, Facebook, and other channels, the AI classifies the predominant sentiment as positive, negative, or neutral. This classification is available in the Reports module, allowing you to filter conversations by sentiment and spot satisfaction patterns without having to read every message. With the sentiment filter, you can answer questions such as: - Did the volume of negative conversations increase after a policy change? - Are positive interactions concentrated in a specific channel or agent? - What percentage of neutral conversations could become upsell opportunities? Step-by-step guide to generate the report 1. Access the Reports module In Papo's main dashboard, open the Reports section. The platform displays the most recent KPIs for your operation. 2. Open the conversations report Within the module, find the report that shows metrics per conversation. It's the same report used to compare channels, agents, or tags. 3. Apply the sentiment filter In the report, use the sentiment filter to choose between positive, negative, or neutral. You can select more than one sentiment to compare the distribution. The selection automatically updates all displayed numbers. 4. Set the analysis period Choose from the quick options (Today, Last 7 days, Last 30 days) or set a custom range. The report will show the evolution of sentiment over the selected period. 5. Review the metrics Look at the volume of conversations by sentiment, the percentage distribution, and daily trends. This data helps identify spikes in dissatisfaction or moments of high satisfaction. 6. Export to CSV Use the export option available in the report. The generated CSV file reflects exactly the visible selection — that is, only the conversations with the filtered sentiment(s). 7. Open in your preferred spreadsheet The CSV can be opened in Excel, Google Sheets, or any other editor. From there, you can create charts, cross-reference with data from other sources, or include the information in presentations. Metrics you can analyze by sentiment | Metric | What it indicates | Practical use with sentiment filter | | :--- | :--- | :--- | | Conversation volume | Total conversations with the selected sentiment in the period. | Measure the frequency of complaints or praise and act quickly. | | Percentage distribution | Proportion of each sentiment relative to the total. | Track the overall health of the customer relationship. | | Daily trend | Day-by-day evolution of the volume of positive, negative, and neutral conversations. | Detect sudden changes after launches or announcements. | | Comparison between channels | Predominant sentiment in each channel (WhatsApp, Instagram, etc.). | Adjust the service strategy by origin. | Who this report is useful for - Customer success managers who need to monitor customer satisfaction in real time. - Support coordinators who want to identify agents or channels with a high concentration of negative conversations. - Quality analysts who track the evolution of sentiment after training or process changes. - Companies using multiple channels that want to understand where the customer experience is most positive or negative. The CSV export allows you to share the data with other areas, such as marketing or product, without depending on platform access. Frequently asked questions How does Papo classify the sentiment of conversations? Papo's artificial intelligence automatically analyzes the content of messages and assigns a sentiment classification (positive, negative, or neutral). No manual configuration is required. Can I filter by more than one sentiment at the same time? Yes. You can select multiple sentiments in the filter to compare the distribution between them, such as positive versus negative, and view the metrics side by side. Does the report show the evolution of sentiment over time? Yes. When you set a period, the report displays the daily trend of each sentiment, allowing you to identify spikes or drops in satisfaction. Can I export the report as PDF? Yes. Although the native export is in CSV, you can use your browser's print function (Ctrl+P / Cmd+P) and select "Save as PDF" to generate a document with the filtered data. Do I need to configure anything for sentiment analysis to work? No. Sentiment analysis is automatically applied to all conversations that pass through the Papo platform. Simply access the Reports module and apply the filter. Does the CSV include the text of the conversations? The CSV file exports aggregated metrics (volume, percentages, trends). To access the full content of conversations, you can check the individual history of each customer directly in Papo. Read also - How to use AI sentiment analysis to generate proactive alerts in Papo Start using Papo for free and see sentiment analysis in action → With the first user free, you connect your WhatsApp and start monitoring customer satisfaction right away.

How to export the funnel summary report for external analysis

To export Papo's (https://papo.global/) funnel summary report for external analysis, you can set up webhooks that send Kanban data in real time to Google Sheets, or use the platform's API to extract conversion and value metrics. With this data, you can create custom dashboards in tools such as Excel or Looker Studio. Summary of export methods | Method | Best for | How it works in Papo | | :--- | :--- | :--- | | Webhooks via Flows | Sending funnel events in real time (e.g., new deal created, stage movement) | A Flow with a Kanban trigger fires a Webhook action that sends the data to a configured URL. | | Papo API | Scheduled queries and integration with BI tools | REST endpoints that return agent and CSAT metrics; for funnel data, the webhook approach is the most direct. | | Visualization in the Reports module | Quick analysis and manual copy | The funnel summary report displays cards by stage, status (open/won/lost), and values, but it does not have a direct CSV download button. | What the funnel summary report shows Inside Papo's Reports module, the funnel summary presents a consolidated view of the sales pipeline. You will find: - Number of cards in each Kanban stage. - Distribution by status: open, won, and lost. - Total estimated or actual value of deals at each stage. - Conversion rates between stages, when available. This view is updated automatically based on CRM movements and helps answer questions such as "how many deals are in proposal?" or "what is the total value of won deals this month?". To bring these numbers into a spreadsheet or presentation, automated export is the recommended path. How to export funnel data with webhooks The most practical way to feed an external spreadsheet with the funnel summary is to use Flows and Webhooks. This way, whenever a relevant event happens in the Kanban, Papo sends the data to a destination you configure. 1. Prepare the destination (Google Sheets) You need a URL that receives the information. The most common options: - Automation platform (Zapier, Make): create a "Catch Webhook" that generates a unique URL and then add an action to insert a row in Google Sheets. - Google Apps Script: in Google Sheets, go to Extensions > Apps Script, write a doPost(e) function that parses the JSON and adds the data. Deploy it as a web app and copy the generated URL. 2. Create the Flow in Papo Go to the Flows module and create a new automation. - Trigger: choose a Kanban event, such as "Deal Created" or moving a card to a specific stage. - Action: add a Webhook step. 3. Configure the Webhook Fill in the fields: - URL: paste the address obtained in the previous step. - Method: POST. - Body: define a JSON with the deal variables. Example: { "name": "{{deal.name}}", "value": "{{deal.value}}", "stage": "{{deal.stage}}", "status": "{{deal.status}}", "pipeline": "{{deal.pipeline}}", "created_at": "{{deal.created_at}}" } Save and activate the Flow. From that moment on, each new deal or movement will trigger the sending of data to your spreadsheet. 4. Build the funnel summary in the spreadsheet With raw data arriving row by row, you can use formulas or pivot tables to recreate the summary: - Count cards by stage and status. - Sum values by stage. - Calculate conversion rates between columns. If you prefer, connect the spreadsheet to Looker Studio and create funnel charts that update automatically. What if I need a one-time export? If the need is occasional, you can access the Reports module, view the funnel summary, and manually copy the data to a spreadsheet. For larger volumes or frequent updates, automation via webhooks is more efficient. Who this export is useful for - Sales managers who need to track the pipeline in real time and share dashboards with leadership. - Operations analysts who want to cross-reference funnel data with marketing or financial metrics. - Teams that already use Google Sheets or Excel as an information hub and want to eliminate manual export. - White label resellers who want to provide customized reports to their clients. Frequently asked questions Does the funnel summary report have direct CSV export? Currently, the Reports module displays the funnel summary, but it does not offer a direct download button. Automated export via webhooks or API is the recommended alternative. Can I export only a specific funnel? Yes. In the Flow, you can add conditions to filter by funnel (pipeline) before sending the webhook, ensuring that only the desired funnel data is exported. Does the data include values in reais? Yes. Kanban variables carry the deal value (estimated_value or value of items) in reais, which can be sent in the webhook JSON. Do I need to know how to code to configure the webhook? Not necessarily. Using platforms such as Zapier or Make, the integration is done without code. Only the Google Apps Script option requires basic JavaScript knowledge. Does the Papo API have endpoints for the funnel summary? Currently, the API offers endpoints for agent and CSAT metrics. For funnel data, the webhook approach is the most direct. Check the official documentation for updates. Can I export historical funnel data? The webhook sends events from the moment it is activated. To retrieve past data, you can combine manual report export with the new automated records. Read also - Automations in Papo: Rules, Macros, Flows, and Webhooks – which one to use? - How to use the Papo API to manage automation Flows Start free → Create your free account and start exporting funnel data to spreadsheets in minutes.

How to export total CRM deal value by period

To export the total value of CRM deals by period in Papo (https://papo.global/), use the Reports module to view the funnel summary with values by stage and status and, to take data outside the platform, set up an automation with webhooks or use the API. Automated export sends Kanban values to an external spreadsheet whenever a deal is created or moved. Summary of export methods | Method | What it does | Best for | | :--- | :--- | :--- | | Reports | Shows the funnel summary with cards by stage and status (open, won, lost) and values. | Quick analysis in the dashboard. | | Webhooks via Flows | Sends Kanban events to an external URL in real time. | Feeding spreadsheets and dashboards automatically. | | API | Allows scheduled queries and integration with BI tools. | Technical teams that need recurring extraction. | | Super Chat | Lists all Kanban wins with total in R$ and breakdown by funnel. | One-off check of the total value. | How to view the total value in the Reports module Papo's Reports module brings together the funnel summary and CRM values. In it, you see the number of cards in each Kanban stage, the distribution by status (open, won, and lost), and the total value of deals in each phase. Apply the period filter to restrict the analysis to the desired interval. This view is updated automatically based on CRM movements and helps answer questions such as “what is the total value of won deals in the month?” or “how much is stuck in proposal?”. To take these numbers to a spreadsheet or presentation, automated export is the recommended path. How to export the total value with webhooks The most practical way to feed an external spreadsheet with the total CRM value is to use Flows and webhooks. Thus, whenever a relevant event happens in the Kanban, Papo sends the data to a destination configured by you. 1. Prepare the destination: create a webhook URL in an automation tool or script that writes the data to a spreadsheet. 2. Create the flow in Papo: go to the Flows module and create a new automation with a Kanban trigger, such as “deal created” or stage movement. 3. Add the webhook action: enter the destination URL and define the sending method. 4. Send the deal data: in the webhook body, include name, value, stage, status, funnel, and creation date. 5. Activate the flow: from that moment on, each new deal or movement triggers sending the data to your spreadsheet. With raw data arriving row by row, you can use formulas or pivot tables to sum values by period, stage, and status. If you prefer, connect the spreadsheet to a BI tool to create dashboards that update automatically. What if I need a one-time export? If the need is one-off, go to the Reports module, view the funnel summary, and copy the data manually to a spreadsheet. For larger volumes or frequent updates, webhook automation is more efficient. Papo's API also allows scheduled queries, but for funnel data the webhook approach is the most direct. Another quick option is to ask Super Chat: “list all Kanban wins”. The response brings the number of won cards, the total in R$ (sum of card items; if there are no items, it uses the estimated value) and the breakdown by funnel. Who this export is useful for - Sales managers who need to track the total pipeline value by period and share it with leadership. - Operations analysts who want to cross-reference funnel data with marketing or financial metrics. - Teams that already use spreadsheets as an information hub and want to eliminate manual export. - White label resellers who want to provide customized reports for their clients. Frequently asked questions Does the funnel report have direct CSV export? No. The funnel summary is displayed in the Reports module, but it does not offer a direct download button. Automated export via webhooks or API is the recommended alternative. Can I export the total value for a specific period? Yes. Apply the period filter in the report before viewing. For automated export, configure the flow to send only events from the desired interval or filter the data in the spreadsheet. How do I get the total won deals in the period? In the funnel report, see the cards with “won” status and sum the values. You can also ask Super Chat “list all Kanban wins” to get the total in R$ and the breakdown by funnel. Do I need technical knowledge to export? Viewing in the dashboard does not require it. For webhooks and API, you need to configure a destination URL, but the flow can be set up without heavy coding. Do exported values include card items? Yes. The total considers the sum of card items; if there are no items, it uses the estimated value. Can I filter by owner? For a breakdown by owner, combine with the agents report, which shows individual performance. Available filters may vary by account; check the help center for updated details. Read also - How to export the funnel summary report for external analysis - Automations in Papo: Rules, Macros, Flows, and Webhooks – which one to use? Start free → Create your free Papo account and track the total value of CRM deals without paying for the first user.

How to create a sales funnel report by salesperson in Papo

To create a sales funnel report by salesperson in Papo (https://papo.global/), use the native filters in the CRM Kanban Deals list to select an owner, the desired period, and the pipeline stages. Then export the filtered view as CSV or XLS to an external spreadsheet and, if needed, feed dashboards in Google Sheets or Looker Studio. With your data already organized in the CRM, in just a few minutes you get an individual snapshot of each salesperson's performance: how many deals are in each stage, what the total value under management is, and which opportunities are active at the time of analysis. Summary of what you'll do | Step | What to do | Result | |:---|:---|:---| | 1. Filter by owner | In the Deals list, select the salesperson (owner) you want to analyze. | Shows only that professional's deals. | | 2. Refine by period and stage | Adjust the filters for creation date, value, or funnel phase. | Narrows the scope to a specific month, week, or stage. | | 3. Export the list | Use the export function to download the data. | Generates a CSV/XLS file with the deal fields. | | 4. (Optional) Feed dashboards | Load into Google Sheets and connect to Looker Studio, or set up an automation with Flows and Webhooks. | Creates recurring visual reports that are independent of manual exports. | How to build the report step by step The process does not require any new module — you use the information already in the CRM. 1. Go to the Deals list In the Papo panel, go to the Kanban module or the Deals list view. Both views show the same cards in your pipeline. 2. Apply the owner filter Find the Owner (or salesperson) filter and choose the name of the professional to be analyzed. From that point on, the screen shows only the deals assigned to them. 3. Refine the period and stages (optional) For a more targeted report, combine the available filters: - Creation date: isolate deals opened in the last 7, 15, or 30 days. - Funnel stage: focus on specific phases, such as "Proposal Sent" or "Negotiation". - Value: filter by ticket range if the focus is high-value deals. These combinations let you generate anything from a weekly follow-up to a monthly analysis of the individual pipeline. 4. Export the data With the filters applied, use the export option in the Deals list. Usually the platform offers an "Export" button in the upper corner of the grid. Select the desired format (CSV or XLS) and download it. The generated file will include columns such as deal title, value, stage, creation date, associated contact, and owner — everything you need to build a pivot table or a funnel chart by salesperson. 5. Turn the file into a dashboard (if you want) After exporting, you can: - Open the spreadsheet in Excel or Google Sheets and sum the values by stage. - Create funnel charts with the number of deals in each column. - Connect to Looker Studio to have a dashboard that updates whenever a new file is uploaded. If you need automatic updates without manual exports, the Flows module with Webhooks sends the data from each new deal (or change) directly to a Google spreadsheet. The articles listed in "Read also" show how to set up that integration. Who this report is useful for - Sales managers who need to evaluate the team's individual productivity and prepare follow-up meetings. - Commercial coordinators who want to compare different salespeople's pipelines without relying on manual spreadsheets. - White Label Resellers who want to generate performance reports for each client in their reseller business, clearly demonstrating the value of the CRM. - Operations analysts who cross-reference funnel data with targets and commissions. Frequently asked questions Does the report show the total value of deals by salesperson? Yes. By filtering by owner and exporting, you get a column with the value of each card. By summing these values in a spreadsheet, you arrive at the total managed by the salesperson. In addition, the Kanban view itself can display the sum of values on screen. Can I save the filter to reuse it next week? Deals list filters do not remain saved between sessions, but you can reapply the same combination of criteria in a few seconds. For automated reports, the recommendation is to use Flows with Webhooks or schedule automatic report sending by email. Is it possible to include data from associated contacts? The export includes the primary contact of each deal. If you need more fields from the record, you can cross-reference the exported list with data from the Contacts module, also exporting the contacts database filtered by the same owner criterion (when available) or by tags. Can I generate a salesperson's report for all pipelines at the same time? Yes. Just select the owner and leave the pipeline filter unrestricted — the view and export will bring all deals for that salesperson, regardless of the pipeline they are in. Is there a row limit on export? The export loads all records that match the applied filters. There is no practical limit for report generation, but download time may vary depending on volume. The exact features of each plan can be found on Papo's plans page. Can I schedule this report to be sent by email? Yes. Papo lets you schedule reports to be sent automatically to the manager's inbox. This way, the funnel summary by salesperson arrives before the meeting, without relying on manual exports. Configuration details are in the article about scheduling reports. Read also - How to export the funnel summary report for external analysis - How to export the total value of CRM deals by period Start for free and generate your team's reports now → Filter Papo CRM Deals by salesperson, export to spreadsheets, and turn your pipeline into decisions — without relying on external BI.

How to export voice call statistics for external analysis

To export Papo (https://papo.global/) voice call statistics for external analysis — whether to spreadsheets like Excel or Google Sheets, or to BI dashboards — you must use the platform's public API. The “Call Report” module provides detailed visualization and filters, but automated and programmatic export depends on API integration, which returns call data in JSON format. Papo centralizes all voice metrics in a native dashboard, with information such as total calls, direction (inbound or outbound), status (answered, missed, busy), method (PapoCall, WhatsApp Calls, etc.), and recordings (when available). To combine this data with other sources, calculate proprietary KPIs, or feed external tools, the API is the recommended path. Summary of ways to obtain voice data | Method | Ideal for | How it works in Papo | | :--- | :--- | :--- | | Papo API | Scheduled queries, custom dashboards, and integration with spreadsheets/BI | REST endpoints that deliver call metrics in JSON. You consume the data with scripts, ETL tools, or connectors. | | Viewing in Call Report | One-off analysis, manual filters, and auditing specific interactions | Native module displays history, totals by direction/status/method, and lets you listen to recordings, but it does not have a direct CSV download button. | How to export call statistics via API The platform provides a documented API that exposes, among other resources, voice data. To bring these metrics into a spreadsheet or dashboard: 1. Generate your API credentials In the Papo dashboard, go to the API settings and create a key pair (public and secret). Store these credentials in a secure location. 2. Check the API documentation After logging in, the official documentation lists the available endpoints, including the one that returns call statistics. There you will find the exact URL format, accepted parameters (such as since and until in Unix timestamp), and response examples. 3. Build the request Conceptual example: a GET call to the voice statistics endpoint, authenticated with your keys, may return content similar to: { "total_calls": 1250, "inbound": 800, "outbound": 450, "answered": 1100, "missed": 120, "busy": 30, "avg_duration_s": 145, "calls_by_method": { "papocall": 900, "wavoip": 300, "whatsapp": 50 } } The exact fields and structure depend on the documented API version. 4. Import the data into your tool With the JSON in hand, you can: - In Google Sheets, use an Apps Script script that makes the request and fills the cells automatically. - In Excel, use Power Query to import the JSON and build refreshable tables. - In BI tools (Looker Studio, Power BI, Tableau), connect directly to the endpoint via API/Web connectors. 5. Automate the refresh To keep data always fresh, schedule the script execution (e.g., time-driven triggers in Apps Script) or configure a refresh routine in your BI tool. Who this export is useful for - Data and BI analysts who need to cross-reference voice metrics with CRM, sales, or marketing data. - Operations supervisors who want to monitor call efficiency in external dashboards, comparing teams and channels. - Finance managers who use call data to calculate costs, commissions, or campaign ROI. - White label resellers who want to offer their clients custom voice reports outside the native dashboard. Frequently Asked Questions Does the Call Report module have direct CSV export? No. The native report offers complete visualization of history and statistics, but it does not include a direct download button. To bring the data into a spreadsheet or dashboard, the API is the recommended path. What voice metrics can I extract via the API? The API returns the same indicators displayed in the Call Report module, such as total calls, distribution by direction (inbound/outbound), status (answered, missed, busy), method/provider used, and average duration. The exact fields are in the official documentation. Do I need to know how to program to use the API? Basic knowledge of HTTP requests (GET, authentication, JSON handling) is required. However, many tools such as Google Sheets (via Apps Script) or automation platforms (Zapier, Make) simplify the process for non-technical users. Can I schedule the export automatically? Yes. After building the integration, you can use time-driven triggers (such as time-based triggers in Apps Script) or your ETL tool's scheduler to refresh the data daily, weekly, or at custom intervals. Do the extracted data include call recordings? The API provides call metadata (date, duration, status, agent, etc.) and, if recording is active with your telephony provider, the endpoint may include the audio URL. The availability of the recording itself depends on the voice channel configuration. Is there a way to receive data in real time? API queries are made on demand (pull). For scenarios that require real-time notifications (such as new call events), webhooks would be needed; however, the availability of specific triggers for voice events should be checked in the platform's updated documentation. Read also - How to use the Papo API to list conversations and send programmatic messages - How to export the funnel summary report for external analysis Start for free → Centralize WhatsApp, Instagram, email, and SMS in a single inbox and automate your customer service with AI.

How to create a report of WhatsApp campaigns sent in the Disparador

To create a report of WhatsApp campaigns sent in the Disparador, access the Disparador module in Papo (https://papo.global/), where each campaign displays sending, delivery, read, and failure metrics. The platform allows you to export this data in CSV so you can cross-reference information and evaluate the real effectiveness of your mass campaigns. Analyzing results is what transforms a WhatsApp send into a communication strategy that generates sales. Papo centralizes metrics in the Disparador itself, eliminating the need for manual spreadsheets. In this article, you will see how to access these numbers, interpret each indicator, and export the data to create complete reports. How to access the campaign report in the Disparador Every campaign sent through Papo's Disparador automatically generates a set of metrics. To view them: 1. Access the Disparador module in the Papo panel. 2. In the campaign list, locate the send you want to analyze. 3. Click on the campaign to view detailed metrics, such as total messages sent, delivered, read, and failures. The campaign list already works as a control panel, allowing you to quickly compare the performance of different sends. Metrics available in the Disparador report Each campaign in the Disparador presents the following metrics, essential for measuring the effectiveness of the send: | Metric | What it means | How to use it in the report | | :--- | :--- | :--- | | Sent | Total messages the platform attempted to send. | Basis for calculating delivery and read rates. | | Delivered | Messages that reached the recipient's device. | A delivery rate below 95% indicates problems in the contact list (invalid numbers or blocks). | | Read | Messages opened by the recipient (two blue checkmarks). | Measures the interest generated by the content. Low rates suggest a need to adjust the text or sending time. | | Failures | Messages not delivered due to permanent error (number without WhatsApp, invalid format). | Use this list to clean your contact base and improve future campaigns. | | Responses/Conversions | Interactions generated from the message. | Cross-reference with Kanban reports to measure how many leads advanced in the sales funnel. | How to export data to CSV For deeper analysis or to share results with your team, you can export campaign data: 1. In the Disparador module, locate the campaign list. 2. Use the export option available in the interface to download a CSV file with metrics for all campaigns or a specific selection. 3. Open the file in a spreadsheet (Excel, Google Sheets) to create charts, calculate rates, and cross-reference information with other sources. CSV export offers total flexibility to build custom reports, without depending on fixed formats. Cross-referencing Disparador data with response metrics Disparador metrics show the reach of your message, but the real business impact appears when you combine these numbers with CRM conversion data. - Disparador + Kanban: Export the Disparador report and compare it with the Kanban sales funnel. This way you can answer questions like: "Of the 500 contacts who received the campaign, how many became opportunities?" or "Which campaign generated the most closed deals?". - Disparador + Inbox: Monitor direct responses in the WhatsApp inbox used for the send. This helps identify which messages generated the most engagement and calibrate the call-to-action for future campaigns. This cross-referencing transforms the Disparador report into a sales intelligence tool, not just a technical delivery one. Frequently asked questions Can I export the report as PDF? Direct PDF export is not available in the Disparador. You can export the data to CSV and generate your own PDF with any spreadsheet editor. Does the report show who responded to the message? The Disparador displays aggregated metrics. To see individual responses, access the WhatsApp inbox linked to the campaign. How do I cross-reference Disparador data with Kanban conversions? Export the Disparador CSV and compare the contacts who received the campaign with the cards that advanced in the Kanban funnel. This way you measure the real conversion rate of the action. Is it possible to schedule automatic report sending by email? Currently, the Disparador does not have automatic report scheduling. You can access and export the data manually whenever needed. Can I filter the report by period? Yes, the campaign list allows you to view sends by date. After exporting the CSV, you can also apply period filters in the spreadsheet. Are the "Read" metrics reliable? Yes, the read metric is based on the confirmation of two blue checkmarks from WhatsApp, indicating that the recipient opened the conversation. Read also - How to test message variations in the Disparador without affecting the entire base - How to export your CRM contacts to a CSV file Start for free → Create your free Papo account and get access to the Disparador with complete metrics to optimize your WhatsApp campaigns.

How to create a reseller revenue dashboard in Power BI with webhook integration

To create a revenue dashboard for your white-label reseller in Power BI, use Papo webhooks (https://papo.global/) to capture new subscription and payment events in real time. This data feeds a dataset in Power BI that displays MRR, growth, and the financial health of your customer base, without manual exports. Combining Papo's automatic notifications with Power BI transforms how you track your business. You stop relying on static reports and start seeing revenue evolve minute by minute, enabling faster decisions about pricing, customer base expansion, and customer retention. Configuration overview |Step|Description|Main tool| |:---|:---|:---| |Prepare the data environment|Create a streaming dataset in Power BI with columns for subscription and payment|Power BI Service| |Configure the integration intermediary|Create an inbound webhook in Zapier/Make and connect it to Power BI to insert rows|Zapier, Make, or Power Automate| |Create the webhook in Papo|Configure a Flow or native webhook that triggers payment/subscription data to the intermediary URL|Papo Global| |Build the dashboard|Create reports in Power BI with real-time data to visualize MRR, growth, and financial metrics|Power BI Desktop/Service| How the integration works Papo can notify external systems whenever a relevant event for your business occurs. For the revenue dashboard, the focus is on billing and subscription events available in your account. When a customer takes out a new subscription or a payment is confirmed, Papo sends a POST with the data (amount, plan, customer, date) to a URL you configure. To reach Power BI, an intermediary service — such as Zapier, Make, or Power Automate — receives that POST, converts the payload, and adds a row to a streaming dataset. Power BI then automatically updates the dashboard visuals, reflecting revenue in real time. Step-by-step 1. Create the streaming dataset in Power BI In the Power BI service, go to the Streaming datasets area. Create a new dataset and define the columns that will feed the dashboard. Example structure: - datetime (date and time of the event) - subscription_id (unique identifier) - customer (customer name or ID) - plan (name of the subscribed plan) - amount (amount in R$) - event_type (new subscription, renewal, etc.) Note the dataset name — it will be used in the next step. 2. Configure the intermediary automation (example with Zapier) 1. In Zapier, create a Zap. 2. Choose the Webhook by Zapier trigger with the Catch Hook event. Copy the generated URL. 3. Add a Power BI - Add rows to a dataset (API) action. 4. Connect your Power BI account (OAuth login) and select the workspace and the dataset you created. 5. Map the fields from the received JSON to the dataset columns (customer name, amount, etc.). Zapier automatically interprets the test payload. After saving and turning on the Zap, the Catch Hook URL will be ready to receive Papo notifications. 3. Configure the webhook in Papo Papo offers two ways to send the data: - Native webhooks: in the account's Webhooks section, create a new subscription. Select the available events, such as “New subscription” or “Payment confirmed” (the exact list depends on the enabled modules). Paste the Zapier Catch Hook URL and keep the POST method. The standard payload will be sent; you can keep it if the fields already fit. - Webhooks via Flows: in the Flows module, create an automation with the desired event trigger. Add the Webhook action, paste the Zapier URL, and, in the message body, build a JSON with the available variables (e.g., {{subscription.value}}, {{customer.name}}). This lets you select exactly the data you need. In both cases, save and activate. From that moment on, every new subscription or payment will be sent instantly to Power BI. 4. Build and publish the dashboard With data flowing, open Power BI Desktop, connect to the streaming dataset, and create the visuals: - Current MRR card (sum of active subscription amounts) - Monthly growth bar chart (MRR per month) - Latest subscriptions table (latest customers who joined) - Revenue daily evolution line chart Publish the report to the Power BI service and pin the cards to a dashboard. The dashboard will update automatically as webhooks arrive. Who this solution is for - Papo white-label resellers who need to monitor the evolution of their customer base and recurring revenue in real time. - Sales managers who offer modular plans and want to track which plans are selling best. - Finance teams who need alerts about delinquency or renewal, triggered directly in the dashboard. - Data professionals who already use Power BI and want to eliminate manual report exports. Frequently asked questions Do I need to know how to code to implement this integration? No. With platforms like Zapier and Make, configuration is entirely visual, with no code. Only creating the dashboard in Power BI requires some familiarity with the tool, but it does not require programming. Does the data arrive in real time? Yes. As soon as the payment or subscription event occurs in Papo, the webhook is triggered immediately. Zapier processes the send in seconds, and Power BI reflects the new data in the dashboard almost instantly. Which payment events are available in Papo? The list of available events depends on the modules you have contracted and your reseller plan. Check the webhook creation interface to see which billing and subscription triggers appear for your account. Can I use Power Automate instead of Zapier? Yes. Power Automate also has connectors for “When an HTTP request is received” (trigger) and “Add rows to a Power BI dataset” (action). The logical flow is the same. Is there an additional cost for data streaming in Power BI? The streaming datasets feature requires a Power BI Pro license (or higher). The row limit per hour is generous for reseller scenarios; check Microsoft's official documentation for current limits. How can I test the integration before activating it? Create a test subscription or a manual payment in your Papo account. After sending, check whether Zapier received the webhook and whether the row appears in the Power BI dataset. You can also use Zapier's “Test” feature to send a sample payload. Read also - How to view the monthly recurring revenue of your white-label reseller - How to generate usage reports for white-label reseller customers Start for free → Create your free Papo account and start automating event capture to build your real-time dashboards today.

How to generate a comparative performance report between teams

To generate a comparative performance report between teams in Papo (https://papo.global/), use the Agents Report with the team filter enabled. This feature places metrics such as resolved conversations, average response time, and customer satisfaction score (CSAT) side by side for each team, allowing managers to compare the efficiency of Sales, Support, Finance, or any other team created on the platform. With this grouped view, you stop looking only at the operation's overall numbers and start understanding how each team contributes to the final result — whether in service volume, first-response speed, or the quality perceived by the customer. Papo consolidates this data automatically, eliminating the need for manual spreadsheets and screenshots. Process summary | Step | What to do | Result | | :--- | :--- | :--- | | Organize the teams | Register the teams in Settings and assign the corresponding agents. | Papo automatically starts grouping metrics by team. | | Access the Agents Report | In the Reports module, open the Agents Report. | View the individual performance ranking of all agents. | | Apply the team filter | Select the team you want to analyze, or compare several by selecting one at a time. | The table metrics are restricted to the agents on that team, showing collective performance. | | Compare between teams | Switch the filter between different teams or export the data to CSV and cross-reference the information. | Identify bottlenecks, balance workload, and direct training based on real data. | How the comparative report works in practice For team comparison to be possible, your operation must be organized into teams within Papo. In the Settings menu, you can create teams such as "Sales", "Tier 1 Support", or "After-Sales" and add the corresponding agents. From that point on, every conversation handled by an agent will be automatically associated with their team in the reports. The Agents Report is the most direct starting point for comparison. It originally displays the individual ranking of all agents, but when you apply the team filter, you isolate the metrics of a specific team. By noting one team's numbers and then switching the filter to another, you quickly build the comparison. The main metrics available in this report are: | Metric | What it measures | Why compare between teams | | :--- | :--- | :--- | | Resolved conversations | Total number of conversations completed by team members in the period. | Reveals each team's real demand and helps justify agent reallocations. | | Average response time | Time until the first message sent to the customer. | Shows agility; teams with high times may be overloaded or have inefficient processes. | | CSAT (Customer Satisfaction) | Average score (1 to 5 stars) received by the team's agents. | Indicates service quality. Comparing CSAT between teams guides investments in training and recognition. | | SLA | Percentage of conversations answered within the deadline defined by the company. | Allows targets to be enforced in a segmented way and identifies teams that need adjustments in their workflows. | You can also enrich the analysis by combining the Agents Report with the Tags Report. This way, you find out which topics each team handles most — for example, whether the Support team is receiving many "Billing Question" conversations that should go to Finance. Step-by-step to generate the comparison 1. Make sure the teams are configured: in Settings, create the teams and assign the agents. Without this step, the team filter will not return segmented results. 2. In Papo's side menu, go to Reports and open the Agents Report. 3. Set the period you want to analyze: Today, Last 7 days, Last 30 days, or a custom range. 4. Apply the team filter by choosing the first team you want to evaluate. Note the metrics or export the table to CSV. 5. Switch the filter to another team and repeat collecting the numbers. 6. Compare the results — you can do this visually in the dashboard itself or by opening the CSVs in a spreadsheet to create comparative charts and tables. Who this report is most useful for Comparing performance between teams is especially relevant for: - Supervisors and coordinators who manage multiple teams (Sales, Support, Retention, etc.) and need a consolidated view. - Companies with omnichannel operations that want to understand whether performance varies by channel or responsible team. - Operations seeking to balance workload by identifying overloaded or idle teams. - Managers who need to justify hires, reallocations, or automation investments with data segmented by team. Frequently asked questions Do I need to create the teams before generating the report? Yes. The team filter only works if the teams are already registered in Settings and agents are assigned to them. Does the Agents Report show the average CSAT for each team? It shows the individual CSAT of each agent. When you apply the team filter, you view the values of all members of that team, allowing you to calculate the average or identify top performers. Can I compare more than two teams at the same time in the dashboard? The Agents Report filter allows you to select one team at a time. To compare multiple teams, the most practical way is to export each team's data to CSV and consolidate it externally. Is there a specific teams report in Papo? Yes. Papo also offers the Teams Report, which already consolidates metrics such as conversation volume, first response time, and CSAT by team without needing to switch filters manually. Does the report include Papo's AI as a "team"? Papo's AI appears as an "agent" in the Agents Report, showing how many conversations were resolved automatically. It is not part of a specific team, but its metrics can be compared with those of human teams to measure the impact of automation. Can I schedule automatic sending of this comparison? Papo reports are generated on demand. For scheduled sending features, check the updated information on the website or in the help center. Read also - How to create and manage agent teams in Papo - Understanding the Teams Report: How to analyze team performance? Start for free and compare your teams' performance right now → Try Papo with no commitment and see in minutes how your teams compare in productivity and customer satisfaction.

How to export conversation data to Google Sheets via webhook

To automatically export conversation data — such as the contact's name, channel, message text and assigned agent — to Google Sheets, use the Papo (https://papo.global/) Flows module to create an automation with a new conversation trigger and a webhook action. The webhook sends the data to a URL prepared in Google Sheets through an automation platform (Zapier, Make) or a Google Apps Script. This integration eliminates manual collection of support metrics and keeps a spreadsheet always up to date with every interaction that comes into your inboxes. With the data centralized, you can build dashboards in Google Sheets or Looker Studio to track volume per channel, peak hours, agent workload and much more. Integration overview | Step | Where it happens | What it does | | :--- | :--- | :--- | | 1. Prepare the destination | Google Sheets + intermediary | Create the spreadsheet and generate a webhook URL with Zapier, Make or Google Apps Script. | | 2. Create the trigger | Papo (Flows) | Define the "New conversation" event (or "Message received") to start the automation. | | 3. Configure the webhook | Papo (Flows) | Add the webhook action with the destination URL and the JSON body containing the conversation data. | | 4. Receive and log | Google Sheets | The URL receives the payload and inserts a new row into the spreadsheet with the conversation information. | | 5. Build dashboards | Google Sheets / Looker Studio | Use the accumulated data to generate charts for volume, conversion per channel, agent performance and more. | How it works – step by step 1. Prepare Google Sheets to receive the data Papo does not generate the Google Sheets URL. You need to create an endpoint that receives the JSON sent by the webhook and writes the data to the spreadsheet. The two most common ways are: Option A – No-code automation platform (recommended) Tools such as Zapier or Make let you create a "Catch Webhook", which generates a unique URL. Then you add an action to "Add Row" in Google Sheets, mapping the received fields to the spreadsheet columns. This option requires no programming and handles authentication with Google. Option B – Google Apps Script In Google Sheets, go to Extensions > Apps Script, paste code with a doPost(e) function that parses the JSON and inserts the data. Deploy it as a "Web app" with access set to "Anyone" and copy the generated URL. This alternative gives you more control, but requires basic knowledge of JavaScript. 2. Create the Flow in Papo with the right trigger Go to the Flows module in the Papo dashboard and create a new automation. - Trigger: choose the "New conversation" event so the webhook fires whenever a contact starts a conversation in an inbox. If you prefer to capture each message individually, use the "Message received" trigger and, if needed, apply filters (by channel, keyword, etc.). - Inbox: select the desired inbox (WhatsApp, Instagram, email, etc.) to limit sending to conversations from that channel only. 3. Configure the webhook action Add a Webhook step and fill in: - URL: paste the address generated in Zapier, Make or Apps Script. - Method: keep it as POST. - Body: define the JSON with the conversation variables you want to export. Example: { "contact_name": "{{contact.name}}", "channel": "{{inbox.name}}", "message_text": "{{message.text}}", "agent": "{{agent.name}}", "event_date": "{{timestamp}}" } The available variables can be found in the Flows module documentation. If the destination system requires specific headers (such as Content-Type: application/json or authentication tokens), add them in the headers field. 4. Test and activate the Flow Before going live, run a test: 1. Temporarily replace the destination URL with a test URL (e.g.: Webhook.site). 2. Start a conversation in the configured inbox. 3. Check that the payload arrives correctly, with all the expected fields and values. 4. Replace it with the final URL and activate the Flow. From that moment on, every new conversation (or message, depending on the trigger) will be automatically logged in your Google Sheets spreadsheet. Who this integration is useful for - Data and BI analysts who need to consolidate support metrics without manual exports. - Operations managers who want dashboards showing conversation volume per channel, peak hours and agent workload. - Marketing and sales teams who want to cross-reference conversation data with campaigns and funnels in the CRM. - Companies that already use Google Sheets as an information hub and want to feed it automatically with support data. Frequently asked questions Do I need to know how to code to set up the webhook? Not necessarily. With Zapier or Make, the integration is built without code. Only the Google Apps Script option requires basic knowledge of JavaScript. Is the data sent in real time? Yes. As soon as the trigger configured in the Flow fires (e.g.: new conversation), the webhook sends the data immediately to the configured URL. What information can I send to Google Sheets? You can send the contact's name, source channel, message text, assigned agent, date/time and other variables available in the Flow. Check the Flows module documentation to see all the options. Can I test before activating the Flow? Yes. We recommend using a test URL (such as Webhook.site) to validate the sending before pointing it to the final Google Sheets. Does Papo provide the webhook URL? No. The URL must be created in Zapier, Make or Google Apps Script. Papo only sends the data to the configured address. Can I export conversation data from specific channels? Yes. When configuring the trigger in the Flow, you can select the desired inbox (WhatsApp, Instagram, email, etc.) so that only conversations from that channel fire the webhook. Read also - How to export sales funnel data to Google Sheets and create custom dashboards - How to create a reseller revenue dashboard in Power BI with webhook integration Start for free and export conversation data to Google Sheets → With Papo, you automate the collection of conversation data and build dashboards at no initial cost.

How to export support reports by inbox and agent to CSV

To export support reports by inbox and agent to CSV, go to Papo's Reports module (https://papo.global/), open the Agent Report, apply the desired inbox filter, and use the available export option. The CSV file will bring individual metrics — such as conversation volume, average response time, and CSAT — ready for analysis in Excel, Google Sheets, or any BI tool. Process summary | Step | What to do | Result | | :--- | :--- | :--- | | Access Reports | Enter Papo's Reports module. | See available metric dashboards. | | Filter by inbox | Select the inbox (WhatsApp, Instagram, email, etc.) you want to analyze. | Restrict analysis to a specific channel or group of channels. | | View data by agent | Observe individual metrics for each agent who worked in that inbox. | Compare performance among agents in a segmented way. | | Export CSV | Use the export option available in the report. | Download a table with all filtered data and open it in any spreadsheet. | How the inbox and agent filter works Papo's platform brings multiple channels together in a single operation, but when evaluating team performance, it often makes sense to separate each source — for example, to understand whether agents working on WhatsApp are faster than those on Instagram. The Agent Report, available in the Reports module, already shows metrics for all agents. When you apply an inbox filter, the dashboard narrows the data and displays only the performance related to conversations that went through that inbox. This way, you can compare agents within the same channel or check how the same agent performs across different channels. In addition to productivity metrics — such as number of conversations handled and average first response time — the report can also include the CSAT (Customer Satisfaction) score given by the customer after the interaction, allowing a complete analysis of service quality. Step by step to export the report 1. Go to the Reports module On Papo's main dashboard, click Reports. The initial screen already shows the most recent KPIs for your operation. 2. Open the Agent Report Within the module, find the report focused on individual team performance. That is where you find columns such as conversations handled, average response time, and CSAT scores. 3. Apply the inbox filter At the top of the report, choose the inbox you want to isolate — for example, "WhatsApp Sales" or "Instagram Support". The filter is immediate and all numbers adjust automatically. 4. Review the metrics Check conversation volume, average response time, SLA, and CSAT ratings for each agent in that filter. These indicators are already segmented by inbox. 5. Export the data to CSV Use the export option available in the report. The downloaded file reflects exactly the current view — that is, only the data for the inbox and agents visible at that moment. 6. Open it in your preferred spreadsheet The CSV can be imported into Excel, Google Sheets, Power BI, or any other tool. From there, you can create charts, cross-reference with historical data, or share it with leadership. Metrics you find in the CSV | Metric | What it indicates | Practical use | | :--- | :--- | :--- | | Conversations handled | Total interactions handled by the agent in that inbox during the period. | Compare workload among team members. | | Average response time | Time until the first response to the customer within the inbox. | Identify agents who are taking longer to start the interaction. | | SLA | Percentage of responses within the deadline defined per inbox. | Evaluate adherence to service level targets. | | CSAT | Average satisfaction score (1 to 5) given to the agent by customers. | Measure the quality of service provided. | | Conversions (if applicable) | Interactions that generated an opportunity or sale. | Link agent performance to commercial results. | These fields may vary according to your account configuration and the plan you purchased. For full details, check the help center or Papo's website. Who this type of export is useful for - Support coordinators who need to evaluate team performance by channel, identifying who stands out on WhatsApp, Instagram, or other sources. - Quality analysts who want to cross-reference CSAT with response time in external spreadsheets. - Operations managers who build dashboards in Power BI or Google Data Studio from real support data. - Companies that use multiple inboxes and want a granular view of agents' work in each one. Frequently asked questions Can I export the report for a single agent? Yes. Just apply the agent filter — or keep only the desired agent's row visible — before exporting. The generated CSV follows the view on screen. Does the CSV include the CSAT for each conversation? The report consolidates data by agent and inbox. If your satisfaction survey is active and there are responses in the period, the CSAT score will appear in the exported table as an aggregated metric by agent. Do I need to filter by period before choosing the inbox? Yes. Always set the interval first (Today, Last 7 days, Last 30 days, or custom dates). Then apply the inbox filter so the data reflects the correct period. Can I export multiple inboxes at the same time? The platform's default behavior allows selecting one inbox at a time. To consolidate data from multiple inboxes, simply repeat the export for each one and merge the spreadsheets externally. Does the CSV show Agent Report data even without CSAT? Yes. Productivity metrics (volume, response time, SLA) are always available, regardless of CSAT collection. Is the exported data in real time? Papo's reports are updated with conversations that have already passed through the platform, so the CSV reflects the operation's reality up to the moment of export. See also - How to generate a comparative performance report between teams - How to export conversation data to Google Sheets via webhook Start free on Papo and generate your first reports in minutes → Papo offers all support reports ready to export to CSV — just connect your channels and start serving.

How to Schedule Automatic Email Reports of Conversations

Yes, you can schedule automatic email delivery of conversation reports in Papo (https://papo.global/) using the Flows module. The platform combines the artificial intelligence that already analyzes conversations, deals, and productivity metrics with a scheduled sending action, delivering daily, weekly, or monthly summaries to the manager's inbox with no manual work. With this automation, the person responsible for the operation receives exactly the slice they need: conversation volume, pending items, frequent tags, leads with the highest score, conversation sentiment, and individual agent performance. Papo's AI extracts and organizes the data automatically, and the email arrives at the interval you define. | Type of conversation report | Data source in Papo | Examples of information the AI can summarize | | :--- | :--- | :--- | | General support | Conversations module in the last period | Total conversations, pending conversations, leads with the highest score, most applied tags, and sentiment analysis | | Agent productivity | Reports module | Conversations handled per agent, average response time, and resolutions within SLA | | Custom | AI prompt combining modules | Any summary the manager needs — just describe what the AI should fetch and group | How automatic conversation report delivery works The core of the automation is in the Flows module. You create a flow that starts with a scheduled trigger, generates the report with an AI action, and ends with an email send. 1. Scheduled trigger: the Flow starts automatically at the defined interval — daily, weekly, or monthly, at the chosen time. 2. AI action for summarization: an AI node receives a custom prompt, queries the relevant conversation information, and returns structured text. 3. Email send: the generated summary is inserted into the message body and sent to the manager using an SMTP credential already configured in the account. The result is a report that arrives without anyone needing to open the dashboard, export spreadsheets, or manually compile data. Step by step to create an automatic report flow Prerequisite: email sending credential Before building the flow, you must have an email inbox configured for sending. In Settings → Inboxes, add an Email type inbox and fill in the SMTP server details: server, port, username, and password. Services such as Amazon SES or SendGrid help ensure high deliverability. 1. Create a new Flow Go to the Flows module and create a new flow with a descriptive name, such as “Daily conversation summary” or “Weekly support report.” 2. Configure the scheduled trigger Add a Trigger node and choose the scheduling option. Set the frequency and exact time when the summary should be generated and sent. For after-hours reports, times such as 7 p.m. or 8 p.m. work well. 3. Add the AI action with the report prompt Insert an Action node that uses Papo's artificial intelligence. In the prompt, describe exactly which data the AI should fetch and how to organize it. Practical examples: - Conversation report: “Consider conversations from the last 24 hours. Bring the total number of conversations, how many are pending, the 5 contacts with the highest lead score, the 3 most applied tags, and a brief sentiment analysis.” - Productivity report: “Based on data from the Reports module, summarize for each agent: number of conversations handled, average response time, and percentage of conversations resolved within SLA.” The AI returns text ready to be inserted into the email. 4. Add the email sending action After the AI node, include an Action node of type Send email. Select the credential configured in the prerequisite, enter the recipient or list of recipients, and use the variable with the summary generated in the previous step as the message body. The subject can be fixed, such as “Conversation report – {{data}}”. 5. Activate and test Save and activate the flow. To validate, force a manual run if the option is available or wait for the next scheduled time. Check that the email arrives correctly and adjust the AI prompt as needed to refine the information. Who this automation is useful for - Support managers who need a daily summary of the operation without opening Papo. - Team supervisors who track productivity and SLA per agent. - Lean operations where the manager wears multiple hats and has no time to compile reports. - White label resellers who want to deliver ready periodic reports to clients, replicating the same flow for each operation. - B2B teams or teams with high conversation volume that need continuous monitoring without relying on exports. Frequently asked questions Do I need an email credential configured before creating the flow? Yes. Sending depends on an email inbox with SMTP configured in Papo. Without this credential, the flow cannot send the message. Can the AI generate reports for different periods? Yes. You define the desired period in the prompt, such as the last 24 hours, last week, or month. The trigger frequency controls how often it is sent. Can I send the same report to more than one recipient? Yes. In the sending node, you can enter the recipient or a list of recipients, according to the operation's needs. Does automatic sending replace the Reports module? No. The Reports module remains the real-time dashboard for interactive queries. The email flow delivers a ready slice to the inbox without replacing analysis in the dashboard. Does this same logic work for sales reports? Yes. Just change the AI prompt to query the Kanban and list won deals, values, and owners. The flow remains the same. Do I need to know how to code to configure this? No. Flow is visual, and the AI generates structured text from the prompt. No code is required. Read also - How to export support reports by inbox and agent to CSV - What is Papo's artificial intelligence and how does it work? Start for free and set up your automatic reports → Papo's starter account is free and does not require a credit card for you to test the automation.