> For the complete documentation index, see [llms.txt](https://docs.zephyrintel.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.zephyrintel.com/analytics/export-analytics-to-csv.md).

# Export analytics to CSV

Every card in Analytics that has a table also has a **Download CSV** button. Each one saves a spreadsheet file named `{prefix}_{timestamp}.csv`, using the columns listed below for that card. Files use UTF-8 encoding, so accented characters and symbols open correctly in Excel and other spreadsheet software.

### Exports and columns

#### Model Performance

File name starts with `Aftermarket_Model_Performance`.

| Column       | Notes                                       |
| ------------ | ------------------------------------------- |
| Model Code   |                                             |
| Sales        | Number of sales in the current selection    |
| Revenue      | US dollars                                  |
| Growth Trend | Sales per quarter, from the last 8 quarters |
| Last Sale    | Date of the most recent sale                |

#### Unknown Model/Brand Sales

File name starts with `Aftermarket_Unknown_Model_Brand_Sales`.

| Column             | Notes                               |
| ------------------ | ----------------------------------- |
| Create Date        |                                     |
| Document Number    |                                     |
| Pump Serial Number | Blank when the sale record had none |
| Spare Part         |                                     |
| Customer           |                                     |
| Amount (USD)       |                                     |

#### Install Base by Brand / Model

File name starts with `Install_Base_By_Brand_Model`.

| Column       | Notes                            |
| ------------ | -------------------------------- |
| Brand        |                                  |
| Model Code   |                                  |
| Install Base | Units in the field               |
| Share        | Percentage of the filtered total |
| Customers    | Distinct customer count          |

#### Common Parts Across Models

File name starts with `Install_Base_Common_Parts_Across_Models`.

| Column      | Notes                            |
| ----------- | -------------------------------- |
| Part Number |                                  |
| Description |                                  |
| Models      | Number of models using this part |
| Assets      | Number of assets using this part |
| Total Qty   | Total quantity across assets     |

#### Cross-Brand Common Parts

File name starts with `Install_Base_Cross_Brand_Common_Parts`.

| Column      | Notes                              |
| ----------- | ---------------------------------- |
| Part Number |                                    |
| Description |                                    |
| Brands      | Number of brands sharing this part |
| Models      | Number of models using this part   |
| Qty         | Total quantity across assets       |

#### Recommended Spares Across Models / Brands

File name starts with `Install_Base_Recommended_Spares_Across_Models_Brands`.

| Column      | Notes                                   |
| ----------- | --------------------------------------- |
| Part Number |                                         |
| Description |                                         |
| Assets      | Number of assets recommending this part |
| Models      | Number of models recommending this part |
| Brands      | Number of brands recommending this part |

#### Customer Install Base Breakdown

File name starts with `Install_Base_Customer_Breakdown`.

| Column   | Notes                                                |
| -------- | ---------------------------------------------------- |
| Customer | "Unknown Customer" when Signal cannot resolve a name |
| Address  | "Address unavailable" when no address is on file     |
| Units    |                                                      |
| Models   | Distinct model count                                 |
| Brands   | Distinct brand count                                 |

### Notes

A **Download CSV** button is grayed out when its table has no rows. This feature may not be enabled for your organization. Ask your Zephyr Intel contact.
