**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:

   ```json
   {
     "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](/hc/papo/articles/how-to-use-papo-api-list-conversations-send-messages-programmatically)
- [How to export the funnel summary report for external analysis](/hc/papo/articles/how-to-export-funnel-summary-report-for-external-analysis)

---

**[Start for free →](https://chat.papo.global/app/auth/signup?papo_lp=home&utm_source=lp&utm_medium=landing&utm_campaign=home&utm_content=start-free&papo_lp_v=start-free)**

Centralize WhatsApp, Instagram, email, and SMS in a single inbox and automate your customer service with AI.