---
schema_version: "1"
id: 346c3f9732449b7d63cdf6ab0d5bd0d3244685fd354fa7347847d70f0f20a09b
title: Reports & Dashboards CSV File Reference
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/cc/264-0-0/b2c_report_download_reference.md
canonical_url: https://help.salesforce.com/s/articleView?id=cc.b2c_report_download_reference.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 59ec8c45057783dcf1104fac5c35779bcf092a23f9eb892664617a16007b544f
description: This topic applies to B2C Commerce Reports & Dashboards. Download many of the Analytics reports as csv files. The csv files show the report data in a different format. This reference describes each csv file.
products:
  - Commerce
  - B2C Commerce
release: "264"
---
# Reports & Dashboards CSV File Reference

This topic applies to B2C Commerce Reports & Dashboards. Download many of the Analytics reports as csv files. The csv files show the report data in a different format. This reference describes each csv file.

revenue\_impact\_by\_discount

 
| Column Heading | Description |
| --- | --- |
| promotionid | The promotion id established in Business Manager. |
| npromotionid | The id associated with the promotion and assigned by B2C Commerce. |
| PromotionName | The promotion name. |
| Promotion Class | The promotion class–shipping, product, or order. |
| usd\_totalDiscount | Total discount in US dollars. |
| std\_totalDiscount | Total discount in realm currency. |
| ste\_totalDiscount | Total discount in site currency. |
| usd\_revenue | Promotion revenue in US dollars. |
| std\_revenue | Promotion revenue in realm currency |
| ste\_revenue | Promotion revenue in site currency |
| Uses | The number of times shoppers used the promotion during the report period. |

sales\_overview

 
| Column Heading | Description |
| --- | --- |
| Date | The date for which the report date is calculated. |
| usd\_revenue | Sales revenue in US dollars. |
| std\_revenue | Sales revenue in realm currency. |
| ste\_revenue | Sales revenue in site currency. |
| orders | Number of orders for the report period. |
| units | Number of units sold for the report period. |
| usd\_aov | The average order value in US dollars |
| std\_aov | Average order value in realm currency. |
| ste\_aov | Average order value in site currency. |
| upt | Units per transaction. |
| usd\_tax | Tax on revenue in US dollars. |
| ste\_tax | Tax on revenue in realm currency. |
| ste\_tax | Tax on revenue in site currency. |
| usd\_shipping | Shipping costs in US dollars. |
| std\_shipping | Shipping costs in realm currency. |
| ste\_shipping | Shipping costs in site currency. |

orders\_by\_promotion\_class

 
| Column Heading | Description |
| --- | --- |
| promotionClass | The promotion class–shipping, product, or order. |
| ordersPlaced | Total number of promotion class order placed. |
| orderPlacedRatio | Ratio of orders placed to the promotion class. |

avg\_selling\_price

 
| Column Heading | Description |
| --- | --- |
| usd\_asp | Average selling price in US dollars. |
| std\_asp | Average selling price in realm currency. |
| ste\_asp | Average selling price in site currency. |

first\_time\_buyer\_overview

 
| Column Heading | Description |
| --- | --- |
| firstTimeBuyer | A customer for whom it’s the first purchase under their account registration. For anonymous customers, if it’s their first purchase using the provided email address. |
| usd\_revenue | Revenue in US dollars. |
| std\_revenue | Revenue in realm currency. |
| ste\_revenue | Revenue in site currency. |
| orders | Total number of first-time buyer orders. |
| units | Total number of units purchased. |
| use\_aov | Average order value in Us dollars. |
| ste\_aov | Average order value in realm currency. |
| ste\_aov | Average order value in site currency. |
| upt | Units per transaction. |
| ust\_tax | Tax on revenue in US dollars |
| std\_tax | Tax on revenue in realm currency. |
| ste\_tax | Tax on revenue in site currency. |
| usd\_shipping | Shipping costs in US dollars. |
| std\_shipping | Shipping costs in realm currency. |
| ste\_shipping | Shipping costs in site currency. |

registration\_status\_overview

 
| Column Heading | Description |
| --- | --- |
| registered | Is the customer registered? |
| revenue | Total customer revenue. |
| orders | Total customer orders. |
| units | Total number of units purchased. |
| aov | Average order value for the customer. |
| upt | Units per transaction. |
| tax | Total tax on revenue. |
| shipping | Total shipping costs. |

total\_promotion\_discount

 
| Column Heading | Description |
| --- | --- |
| date | The transaction date. |
| promotionClass | The promotion class–shipping, product, or order. |
| usd\_totalDiscount | Total discount in US dollars. |
| std\_totalDiscount | Total discount in realm currency. |
| ste\_totalDiscount | Total discount in site currency. |
| totalOrders | Total promotion orders. |
| usd\_averageOrderDiscount | Average order discount in US dollars |
| ste\_averageOrderDiscount | Average discount in realm currency. |
| ste\_averageOrderDiscount | Average discount in site currency. |

total\_promotion\_discount

 
| Row | Description |
| --- | --- |
| ORDER | Order promotion type. |
| PRODUCT | Product promotion type. |
| SHIPPING | Shipping promotion type. |
| TOTAL | Total promotion type. |
| UNKNOWN | Unknown promotion type. |

## Technical Reports

main\_pipeline\_kpi

 
| Row | Description |
| --- | --- |
| date | The call date. |
| total\_call\_count | The total number of calls. |
| total\_response\_time | Total response time in milliseconds. |
| total\_missandstore\_count | The number of responses retrieved from the web adapter page. |
| total\_miss\_count | The number of responses not retrieved from the web adapter page cache. |
| total\_error\_count | Total number of calls that returned error codes. |

main\_pipeline\_non200\_status\_code

 
| Row | Description |
| --- | --- |
| date | The call date. |
| status\_code | The returned status code. |
| call\_count | The number of calls that returned the status code. |
| total\_count | total number of calls. |
| percent | The percent of calls that returned the status code. |

main\_pipeline\_callbuckets

 
| Row | Description |
| --- | --- |
| total\_call\_count | The number of calls. |
| total\_call\_count bucket1 | The total number of call responses that fall in the 0-499 ms range. |
| total\_call\_count bucket2 | The total number of call responses that fall in the 500-999 ms range. |
| total\_call\_count bucket3 | The total number of call responses that fall in the 1000-1499 ms range. |
| total\_call\_count bucket4 | The total number of call responses that fall in the 1500-1999 ms range. |
| total\_call\_count bucket5 | The total number of call responses that fall in the 2000-2499 ms range. |
| total\_call\_count bucket6 | The total number of call responses that fall in the 2500-2999 ms range. |
| total\_call\_count bucket7 | The total number of call responses that fall in the 3000-3499 ms range. |
| total\_call\_count bucket8 | The total number of call responses that fall in the 3500-3999 ms range. |
| total\_call\_count bucket9 | The total number of call responses that fall in the 4000-4499 ms range. |
| total\_call\_count bucket10 | The total number of call responses that fall in the 4500-4999 ms range. |
| total\_call\_count bucket11 | The total number of call responses that fall in the 5000+ ms range. |

main\_pipelines\_table

 
| Row | Description |
| --- | --- |
| pipeline\_name | The name of the pipeline call. |
| call\_count | The number of calls for the pipeline. |
| total\_call\_count | The number of all pipeline calls. |
| share\_of\_total | The pipeline call as a percentage of all pipeline calls. |
| response\_time | The aggregate response time for the pipeline. |
| avg\_response\_time | The average response time for the pipeline. |
| hit\_count | The number of responses retrieved form the web adapter page cache. |
| cache\_hit\_percentage | The percentage of responses retrieved from the web adapter page cache. |
| missandstore\_count | The number of responses created by an appserver, marked as cacheable, and stored in web adapter page cache. |
| cache\_missandstore\_percentage | The percentage of responses created by an appserver, marked as cacheable, and stored in web adapter page cache. |
| miss\_count | The number of responses not retrieved from the web adapter page cache. |
| cache\_miss\_percentage | The percentage of responses not retrieved from the web adapter page cache. |
| non200\_count | The number of calls that return a non-200 code response. |
| non200\_percentage | The percentage of call that return a non-200 code response. |

gift-certificates\_activations

 
| Column | Description |
| --- | --- |
| date | The transaction date. |
| site | The transaction site. |
| activation\_count | The number of gift certificates activated. |
| usd\_activation\_revenue | The revenue from gift certificate activation in US dollars. |
| std\_activation\_revenue | The revenue from gift certificate activation in realm currency. |
| ste\_activation\_revenue | The revenue from gift certificate activation in site currency. |

gift-certificates\_redemptions

 
| Column | Description |
| --- | --- |
| date | The transaction date. |
| site | The redemption site. |
| redemption\_count | The number of gift certificate redemptions. |
| usd\_redemption\_value | The redemption value in US dollars. |
| std\_redemption\_value | The redemption value in realm currency. |
| ste\_redemption\_value | The redemption value in site currency. |

gift-certificates\_distribution

 
| Column | Description |
| --- | --- |
| std\_lower\_inclusive | The lowest value including the listed value for the stated currency range. |
| std\_upper\_exclusive | The highest value excluding the listed value for the stated currency range. |
| std\_activation\_count | The number of gift certificate activations. |
| std\_activation\_value | The value of the gift certificate activations. |
| std\_activation\_avg\_value | The average value of an individual gift certificate activation. |