# Available Columns

Violet allows you to export commission rate change logs to track historical changes to commission rates between channels and merchants. This page provides details on the columns you are able to export from your commission rate change log.

The **Commission Rate Change Log** tracks all modifications to commission rates, including who made the change, when it occurred, and what the previous and new rates were. This provides full audit trail visibility for commission rate management across your partnerships.

{% hint style="info" %}
The available columns vary depending on whether a channel or a merchant user is requesting the report. Channels can see merchant-specific data such as the merchant ID and the merchant name responsible for the change, while merchants can see app-specific data for their commission rate changes.
{% endhint %}

## Common Columns (Available to Both Channels and Merchants)

### Date Information

| Field Name                  | Export Name    | Definition                                                 |
| --------------------------- | -------------- | ---------------------------------------------------------- |
| Commission Rate Change Date | `date_created` | The date and time when the commission rate change was made |

### Commission Rate Information

| Field Name    | Export Name                | Definition                                                       |
| ------------- | -------------------------- | ---------------------------------------------------------------- |
| Previous Rate | `previous_commission_rate` | The commission rate before the change was made (as a percentage) |
| New Rate      | `commission_rate`          | The commission rate after the change was made (as a percentage)  |

### User Information

| Field Name         | Export Name       | Definition                                                              |
| ------------------ | ----------------- | ----------------------------------------------------------------------- |
| User Type          | `user_type`       | The type of user who made the change (e.g., `DEVELOPER` or `MERCHANT` ) |
| User First Name    | `user_first_name` | The first name of the user who made the commission rate change          |
| User Last Name     | `user_last_name`  | The last name of the user who made the commission rate change           |
| User Email Address | `user_email`      | The email address of the user who made the commission rate change       |

## Merchant-Specific Columns

{% hint style="info" %}
These columns are only available when exporting as a **Merchant** user, providing context about which apps the commission rate changes apply to.
{% endhint %}

### App Information

| Field Name | Export Name | Definition                                                                 |
| ---------- | ----------- | -------------------------------------------------------------------------- |
| App ID     | `app_id`    | The unique identifier of the app for which the commission rate was changed |
| App Name   | `app_name`  | The name of the app for which the commission rate was changed              |

## Channel-Specific Columns

{% hint style="info" %}
These columns are only available when exporting from the channel dashboard, providing context about which merchants the commission rate changes apply to.
{% endhint %}

### Merchant Information

| Field Name    | Export Name     | Definition                                                                      |
| ------------- | --------------- | ------------------------------------------------------------------------------- |
| Merchant ID   | `merchant_id`   | The unique identifier of the merchant for which the commission rate was changed |
| Merchant Name | `merchant_name` | The name of the merchant for which the commission rate was changed              |

{% hint style="info" %}
When exporting from the channel dashboard, you'll see commission rate changes across all your merchant connections.

When exporting from the merchant dashboard, you'll see commission rate changes across the apps you are connected to as a merchant.
{% endhint %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.violet.io/prism/reporting/commission-rate-change-log/columns.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.