# Advanced Action Listing with Category & SKUs - Custom Permissions

This report displays data columns that your partners have permitted you to view. To enable this functionality, [contact support](https://app.impact.com/support/portal.ihtml?createTicket=true) and include which column to show, along with the partner’s Id. Also attach proof (e.g., a screenshot of an email from the partner) to the ticket that the partner has given consent.

{% hint style="info" %}
For example, you could add the following to the support ticket:

*"Please show the `SubId1` column, shared by partner 10011, to my Brand report 16771 (Advanced Action Listing with Category & SKUs - Custom Permissions). I've attached a screenshot of the partner's consent."*
{% endhint %}

#### Manage the report

1. From the left navigation bar, select ![](https://4048883401-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FwMLlMoFBtKJa8ptd3zaw%2Fuploads%2Fgit-blob-230534471fef5f40808e921e41ee44e4a06ded03%2Fe6cb9548999afdc1ed3ce4942e4cb5b45b5cecbd323267aac2a7cd1915fccc09.svg?alt=media) **\[Engage]** → **Reports** → **More Reports**.
2. Under *More Reports*, select **Performance** as the filter next to the search bar.
3. Select [**Advanced Action Listing (Includes Category/SKUs) - Custom Permissions**](https://app.impact.com/secure/advertiser/report/viewReport.report?handle=adv_action_listing_w_sku_and_permissions).
4. Filter for the data you want to view. Select **Apply** when you have the filters in place that you want.

   * View the *Filter reference* below for more information.

   <div data-gb-custom-block data-tag="hint" data-style="info" class="hint hint-info"><p><strong>Note:</strong> This report loads in <em>order level</em> view by default. However, if any <em>item level</em> field, like <em>Category</em>, <em>Product Category</em> or <em>SKU</em> is selected in the filters, then item level columns will also be displayed. In this case, the <em>SKU</em> column will automatically be added to the report.</p></div>
5. Add or remove columns from the report table using the ![](https://4048883401-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FwMLlMoFBtKJa8ptd3zaw%2Fuploads%2Fgit-blob-55f9a4ba17f1edde22510bc766728b311864c461%2Feaf620c7b74ff071d06c5e1b12bb1bd184361280cdc0ea896c3f8058c11b8532.svg?alt=media) **\[Columns]** icon at the top-right of the report.
   * See the *Report data column reference* below for more information on the report's table columns.
   * You can use the icons at the top-right of the page to <img src="https://4048883401-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FwMLlMoFBtKJa8ptd3zaw%2Fuploads%2FAAbcO4tyS4wdfpLAb6ag%2Fpin.png?alt=media&#x26;token=b56da71c-d91b-4654-b93b-7ac9bbb3ece6" alt="pin_vnext.png" data-size="original"> **\[**[**pin**](https://help.impact.com/brand/what-would-you-like-to-learn-about/platform-features/multi-program-reports/report-management/pin-a-report)**]**, ![\[Email\]](https://paligoapp-cdn-eu1.s3.eu-west-1.amazonaws.com/impact/attachments/f01cdffa431a4d75ff09c130b66974d4-cca31a241674dbbd001d8c49733cc0d9.svg) **\[**[**schedule**](https://help.impact.com/brand/what-would-you-like-to-learn-about/platform-features/multi-program-reports/data-lab-custom-reports/schedule-a-custom-report)**]**,![\[Download report\] vNext](https://paligoapp-cdn-eu1.s3.eu-west-1.amazonaws.com/impact/attachments/f01cdffa431a4d75ff09c130b66974d4-d86efd15651b5054fddb008ce5d1a1d6.svg)**\[**[**download**](https://help.impact.com/brand/what-would-you-like-to-learn-about/platform-features/multi-program-reports/report-management/download-a-report)**]** (in PDF, Excel, or CSV format), or![\[Export report\] vNext](https://paligoapp-cdn-eu1.s3.eu-west-1.amazonaws.com/impact/attachments/f01cdffa431a4d75ff09c130b66974d4-fd77f03a4c5618018e59013607ed56bc.svg)**\[**[**export the report**](https://integrations.impact.com/impact-brand/reference/export-reports)**]** (via API).

<div data-with-frame="true"><figure><img src="https://4048883401-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FwMLlMoFBtKJa8ptd3zaw%2Fuploads%2FbHv0GJbp0bLDtpfrXMwy%2Faal_cust_perms.png?alt=media&#x26;token=10c8975d-8ba7-4945-83f9-7bff6b5c9499" alt="" width="563"><figcaption></figcaption></figure></div>

<details>

<summary>Filter reference</summary>

| Filter                 | Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
| ---------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Date Range             | <p>Filter data by when it was created. You can also compare two periods of time against each other.</p><p>You can pull a maximum of <strong>366 days</strong> of data. However, you can still perform Year-over-Year reporting by selecting <img src="https://paligoapp-cdn-eu1.s3.eu-west-1.amazonaws.com/impact/attachments/f01cdffa431a4d75ff09c130b66974d4-396370c2cdec89ba7d714c4c58e6845b.svg" alt="[Unchecked box]"> <strong>\[Unchecked box] compare to {Previous year}</strong>.</p><p>If you want to pull more than 366 days of data, you will need to create multiple reports.</p> |
| Network                | Filter by data source.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| Action Type            | Search for specific conversion types like Sales, Downloads, etc.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| Category List          | The associated list of product categories.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| Partner                | Select the partners for which you want to see data.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| Deal                   | Input the deal for which you want to see data.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |
| Action Status          | Filter for actions at a specific stage in the approval process.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| Campaign Id            | The unique identification number for the overall marketing campaign.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
| Campaign Status        | The current status of the campaign.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| Internal ID            | The unique Id assigned to the action by the impact.com system.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |
| Item Campaign Id       | The unique ID for the specific campaign tied to an individual item within an order.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| Performance Campaign   | A campaign focused on driving specific performance-based marketing goals.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| Product Boost Campaign | Indicates if the action was part of a campaign designed to promote a product.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| SKU                    | Input the product's stock-keeping unit for which you want to see data.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| Product Category       | Input the product category name for which you want to see data.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| Product                | Input the product name for which you want to see data.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| Catalog Category       | Input the name of the group of products in the catalog for which you want to see data.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| Action Id              | <p>If you want to look up a specific action by its action ID, enter that here.</p><p>You can retrieve your action ID by looking at your <a href="../../actions-and-payouts/payouts/filter-and-download-pending-payouts-list">pending payouts</a>.</p>                                                                                                                                                                                                                                                                                                                                         |
| Subcategory            | The subcategory for the product referenced at the item level.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| Business               | Input the business name associated with the item.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| Manufacturer           | Input the name of the group that makes the product.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| Event Type             | Select the specific action by which your partners' audience was tracked. E.g., Online Sale/CPA, App Install, etc.                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| Group                  | Select the partner group for which you want to see data.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| Relationship Type      | Manage what kind of partners you want to view, such as direct partners.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| Shared Id              | <p>Filter for actions with a particular shared ID.</p><p>Learn more about <a href="https://help.impact.com/en/support/solutions/articles/155000000003-dynamically-pay-partners-with-the-shared-id">shared IDs</a>.</p>                                                                                                                                                                                                                                                                                                                                                                        |
| Contract               | View actions that are the result of a particular template term.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| Referral Type          | Select the conversion type that you want to view.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| Customer Id            | Enter specific customer IDs of the customers for which you want to view purchasing trends.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| Promo Code             | Select the [promo codes](https://help.impact.com/brand/what-would-you-like-to-learn-about/platform-features/promo-codes/promo-codes-overview) for which you want to view data.                                                                                                                                                                                                                                                                                                                                                                                                                |
| Ad Type                | Manage which kind of ads you want more information on.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| Ad                     | Select the specific ad you want data on. The ads are displayed as ad type-ad name-ad id.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| Text 1-5               | Input a separate text/string value associated with an action.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| Property Id            | Enter the unique ID of the media property associated with the action. You can retrieve the property ID from the partner.                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| OID                    | <p>Search for a specific action by its order ID.</p><p>You can retrieve your OID for an action by looking at your <a href="https://help.impact.com/en/support/solutions/articles/48001232530-pending-payouts-actions">pending payouts</a>.</p>                                                                                                                                                                                                                                                                                                                                                |
| Currency               | Set the currency in which you want to view report data. impact.com will convert the amounts to your selected currency.                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| Show                   | Add data from a large selection of metrics. These data points will be added to the table after you select **Apply**.                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |

**Show Data Points**

| Data point                   | Description                                                                                                                                                                                                                                                                            |
| ---------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Payout Rank                  | A rank indicating the payout tier, helping you identify top-performing actions.                                                                                                                                                                                                        |
| Campaign Id                  | The unique identification number for the overall marketing campaign.                                                                                                                                                                                                                   |
| Invoice Date                 | The date that the transaction was officially invoiced.                                                                                                                                                                                                                                 |
| Item Campaign Id             | The unique ID for the specific campaign tied to an individual item within an order.                                                                                                                                                                                                    |
| Creator Campaign             | The campaign associated with a specific creator or influencer, if applicable.                                                                                                                                                                                                          |
| Performance Campaign         | A campaign focused on driving specific performance-based marketing goals.                                                                                                                                                                                                              |
| Campaign Status              | The current status of the campaign.                                                                                                                                                                                                                                                    |
| Product Boost Campaign       | Indicates if the action was part of a campaign designed to promote a product.                                                                                                                                                                                                          |
| Internal Id                  | The unique Id assigned to the action by the impact.com system.                                                                                                                                                                                                                         |
| Manufacturer                 | The group that makes the product.                                                                                                                                                                                                                                                      |
| Sku                          | The product's stock-keeping unit. This column will display automatically if you filter on an item level field like *Product Category*.                                                                                                                                                 |
| Catalog Category             | The group or kind of products with which the item is associated.                                                                                                                                                                                                                       |
| Category                     | Name of the category with which the product is associated.                                                                                                                                                                                                                             |
| Business                     | The name of the business associated with the item.                                                                                                                                                                                                                                     |
| Date                         | The date on which the action was tracked. This filter shows the same date as the entry in the Action Date column.                                                                                                                                                                      |
| Margin                       | This number represents Revenue minus Goods Cost.                                                                                                                                                                                                                                       |
| Total Business Cost          | The total Cost of Goods plus Total Cost.                                                                                                                                                                                                                                               |
| Partner Group                | The partner group to which the partner is joined.                                                                                                                                                                                                                                      |
| Product                      | The name of the product associated with the action.                                                                                                                                                                                                                                    |
| Item Count                   | The total number of individual items included in the transaction.                                                                                                                                                                                                                      |
| Item Brand                   | The brand associated with the item offering.                                                                                                                                                                                                                                           |
| Goods Costs                  | The total cost of products in the basket captured at conversion.                                                                                                                                                                                                                       |
| Catalog Subcategory          | The second or third level of categorization for a catalog.                                                                                                                                                                                                                             |
| Category List                | <p>Category exception lists associated with partners who get paid according to different rates based on a category.</p><p>Learn more about <a href="../../../account-administration/program-settings/exception-lists/create-category-and-sku-exception-lists">exception lists</a>.</p> |
| Product Category             | Name of the category with which the product is associated.                                                                                                                                                                                                                             |
| Action Batch Date            | If the action was entered into impact.com via a batch file, the date on which that batch file was provided to impact.com.                                                                                                                                                              |
| Batch ID                     | If the action was entered into impact.com via a batch file, the identifier of that batch event.                                                                                                                                                                                        |
| Ad                           | Which ad drove the action.                                                                                                                                                                                                                                                             |
| Ad Placement                 | Where your ad was hosted when it referred a customer. E.g., "home", and "forum".                                                                                                                                                                                                       |
| Ad Position                  | On which kind of screen the ad that referred the customer was placed. E.g., "Top", "Bottom", or "Side".                                                                                                                                                                                |
| Ad Rank                      | Where the ad that referred the customer ranks on search engine results pages.                                                                                                                                                                                                          |
| Bonus Cost                   | If there is any performance bonus cost associated with the action, this filter will list that cost.                                                                                                                                                                                    |
| Business Region              | In which geographical region your business operates.                                                                                                                                                                                                                                   |
| Referral Business Region     | In which geographical region the business that referred the customer operates.                                                                                                                                                                                                         |
| Subcategory                  | The products or services listed subcategory.                                                                                                                                                                                                                                           |
| Channel                      | Which marketing channel drove the action.                                                                                                                                                                                                                                              |
| Client Cost                  | If you are an agency, the amount charged to the client brand for an action.                                                                                                                                                                                                            |
| Contract                     | Which contract is associated with an action.                                                                                                                                                                                                                                           |
| Currency Exchange            | Adding this filter will add the Original Currency, Original Currency Revenue, and Currency Exchange Rate columns to the report, showing you in what currency the action was driven.                                                                                                    |
| Custom Total                 | If a different revenue number was reported to impact.com, this new number will be listed as the Custom Total for an action.                                                                                                                                                            |
| Customer Region              | The region (or state) in which the customer resides.                                                                                                                                                                                                                                   |
| Customer Country             | The country in which the customer resides.                                                                                                                                                                                                                                             |
| Customer City                | The city in which the customer resides.                                                                                                                                                                                                                                                |
| Customer Email               | The customer's email address.                                                                                                                                                                                                                                                          |
| Customer Id                  | A unique identifier for the customer.                                                                                                                                                                                                                                                  |
| Customer Status              | The customer's Customer Status Mapping code for the action.                                                                                                                                                                                                                            |
| Date 1-10                    | If you passed a separate datetime along with an action, that will appear here.                                                                                                                                                                                                         |
| Discount                     | The total discount applied to the action.                                                                                                                                                                                                                                              |
| Disposition Status           | If you have custom disposition codes set up and passed them alongside an action, the code will appear if you enable this filter.                                                                                                                                                       |
| Hear About Us                | If the customer was asked how they learned about your brand and that data was passed to impact.com, the result of that question will appear.                                                                                                                                           |
| Landing Page URL             | To which URL the customer was referred when they clicked through the ad.                                                                                                                                                                                                               |
| Line of Business             | If you have multiple kinds of product groupings (e.g., experiences and dining) and that information is passed to impact.com during a conversion, that data will appear.                                                                                                                |
| Referral Line of Business    | A type of Line of Business indicating the action was a customer lead or referral, not a direct sale.                                                                                                                                                                                   |
| Locking Date                 | The action's locking date. After this date, the action can no longer be modified or reversed.                                                                                                                                                                                          |
| Modification Date            | If the action was modified (but not reversed), the date on which this modification happened will appear.                                                                                                                                                                               |
| Modification Reason          | If the action was modified (but not reversed), the reason for the modification will appear.                                                                                                                                                                                            |
| Money 1-3                    | If you passed a separate money value along with an action, that will appear here. The value of this money will be converted to whatever Currency you select in the filters at the top of the report.                                                                                   |
| Numeric 1-10                 | If you passed a separate numeric value along with an action, that will appear here.                                                                                                                                                                                                    |
| Notes                        | If you added any notes to an action, they will appear here.                                                                                                                                                                                                                            |
| Order Promo Code Description | If the action includes a promo code used by the customer, the promo code's description will appear.                                                                                                                                                                                    |
| Original Payout              | If the current payout for the action differs from the original payout (e.g., due to a payout adjustment outlined in your contract with the winning partner), that original payout will appear here.                                                                                    |
| Original Revenue             | If the current revenue for the action differs from the original payout (e.g., due to a promotion you are currently running), that original revenue will appear here.                                                                                                                   |
| Payment Type                 | How the customer paid for their order.                                                                                                                                                                                                                                                 |
| Postcode                     | The postcode in which the customer generated the action.                                                                                                                                                                                                                               |
| Property                     | Which partner media property referred the customer to generate the action.                                                                                                                                                                                                             |
| Rebate                       | If a rebate is available for the customer to use, that rebate amount will appear.                                                                                                                                                                                                      |
| Redirect Rule ID             | If a blocking or redirect rule affected the customer's referral journey, the ID rule responsible will appear.                                                                                                                                                                          |
| Redirect Rule                | If a blocking or redirect rule affected the customer's referral journey, the rule responsible will appear.                                                                                                                                                                             |
| Referral Date                | The date on which the partner drove a customer referral.                                                                                                                                                                                                                               |
| Referral Param 1-3           | If the partner added a Param parameter (similar to a Shared ID), that parameter value will appear.                                                                                                                                                                                     |
| Referral Partner Property    | Which partner media property referred the customer to generate the action.                                                                                                                                                                                                             |
| Referral Traffic Source      | The referring ad that generated the click action.                                                                                                                                                                                                                                      |
| Referral Traffic Type        | The kind of traffic that generated the click action.                                                                                                                                                                                                                                   |
| Referral Type                | The kind of referral that generated the action.                                                                                                                                                                                                                                        |
| Relationship Type            | Your current relationship status with the partner that drove the action.                                                                                                                                                                                                               |
| Scheduled Clearing date      | The scheduled payout date for the action. This is the date on which the partner will be paid for driving the action.                                                                                                                                                                   |
| Shipping                     | The shipping cost associated with the order.                                                                                                                                                                                                                                           |
| Site Category                | What type of site referred the customer.                                                                                                                                                                                                                                               |
| Site Version                 | The edition of the site that referred the customer.                                                                                                                                                                                                                                    |
| Status Detail                | If the action was reversed, the reason you provided for the reversal.                                                                                                                                                                                                                  |
| Text 1-25                    | If you passed a separate text/string value along with this action, that will appear here.                                                                                                                                                                                              |
| Property Type                | What kind of media property is associated with the action.                                                                                                                                                                                                                             |
| Property Id                  | The ID of the media property associated with the action.                                                                                                                                                                                                                               |
| Property Name                | The name of the media property associated with the action.                                                                                                                                                                                                                             |
| Device                       | The type of device from which the customer generated the action.                                                                                                                                                                                                                       |
| Action Clearing date         | If the payout scheduling date for the action was changed, the new clearing date will appear.                                                                                                                                                                                           |
| Location                     | From where the customer generated the action.                                                                                                                                                                                                                                          |
| Click to Action Time         | The time a customer took from initially clicking through the ad to when they generated the action.                                                                                                                                                                                     |
| Location Name                | The name of the location from where the customer generated the action.                                                                                                                                                                                                                 |
| Location Id                  | The ID of the location from where the customer generated the action.                                                                                                                                                                                                                   |
| Location Type                | The kind of location from where the customer generated the action.                                                                                                                                                                                                                     |
| MP Value 1-3                 | If you assigned a separate ID to the partner that drove the action, that ID will appear.                                                                                                                                                                                               |
| Media Property Id            | The ID of the media property associated with the action.                                                                                                                                                                                                                               |
| Delivery Type                | Type of delivery method specified for an item (e.g. in store).                                                                                                                                                                                                                         |
| Media Property Name Historic | View the historic name (i.e., the old name) of the platform on which content was used to drive the action.                                                                                                                                                                             |
| Media Property Name Current  | View the current name of the platform on which content was used to drive the action.                                                                                                                                                                                                   |
| Media Property Type Historic | View the historic type (i.e., the old type) of media platform on which content was used to drive the action.                                                                                                                                                                           |
| Media Property Type Current  | View the type of media platform on which content was used to drive the action.                                                                                                                                                                                                         |

</details>

<details>

<summary>Report data column reference</summary>

| Data point    | Description                                                                                               |
| ------------- | --------------------------------------------------------------------------------------------------------- |
| Action Date   | Date and time when the action was recorded.                                                               |
| Action ID     | Unique impact.com identifier for the action.                                                              |
| OID           | Unique Order ID for the action.                                                                           |
| Partner       | Specifies the partner that drove the action.                                                              |
| Partner ID    | Unique identifier for the partner.                                                                        |
| Status        | Status of the action: Approved, Pending, N/A, or Reversed.                                                |
| Revenue       | Amount of revenue generated by this action.                                                               |
| Action Cost   | The amount of compensation paid to partners for driving the traffic that resulted in conversions.         |
| Rate          | Percentage rate determined by revenue total and action costs.                                             |
| Promo Code    | If a promo code is used, it's listed here.                                                                |
| Event Type    | The specific action by your partners' audience that was tracked. E.g., Online Sale/CPA, App Install, etc. |
| Event Type ID | Unique identifier for the event type that tracked this conversion.                                        |
| Referring URL | The URL a consumer came from.                                                                             |
| Sub ID 1-3    | Shows the SubID, if used for an action.                                                                   |
| Shared ID     | Shows the Shared ID, if used for this action.                                                             |
| Referral ID   | The ID used to tie the referral back to the partner.                                                      |
| Indirect Tax  | Tax incurred indirectly on goods and services.                                                            |

</details>
