Advanced Action Listing with Category and SKUs Report

Published on: Fri, 26 Jan, 2024 at 4:09 AM | Updated on: Mon, 11 Mar, 2024 at 8:52 AM

The Advanced Action Listing Report with SKUs report gives you information about each action on a product and order level that has been credited to partners.

Manage the report

From the left navigation bar, select Reports → More Reports.
Select Performance from the Category filter.
Select Action Listing (Includes Category/SKUs).
Below Advanced Action Listing (Includes Category/SKUs), you can filter for the data you want to view. Select [Search] when you have the filters in place that you want.
- View the Filter reference below for more information.
View the table for your data.
- 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 [pin], [schedule], [save], or [retrieve via API].

Filter reference

Filter

Description

Date Range

Filter data by when it was created. You can also compare two periods of time against each other.

You can pull a maximum of 366 days of data. However, you can still perform Year-over-Year reporting by selecting [Unchecked box] compare to {Previous year}.

If you want to pull more than 366 days of data, you will need to create multiple reports.

Network

Filter by data source.

Action Type

Search for specific conversion types— like Sales, Downloads, etc.

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.

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

If you want to look up a specific action by its action ID, enter that here.

You can retrieve your action ID by looking at your pending payouts.

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.

OID

Search for a specific action by its order ID.

You can retrieve your OID for an action by looking at your pending payouts.

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

Filter for actions with a particular shared ID.

Learn more about shared IDs.

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 for which you want to view data.

Ad Type

Manage which kind of ads you want more information on.

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.

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 get added to the table after you select [Search].

Show Data Points

Data point	Description
Manufacturer	The group that makes the product.
Sku	The product's stock-keeping unit.
Category	Name of the category with which the product is associated.
Catalog Category	The group or kind of products with which the item 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 Brand	The brand associated with the item offering.
Catalog Subcategory	The second or third level of categorization for a catalog.
Goods Costs	The total cost of products in the basket captured at conversion.
Category List	Category exception lists associated with partners who get paid according to different rates based on a category. Learn more about exception lists.
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 product's/service's 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.
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-10	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	From which type of device 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.

Report data column reference

Action Date	Date (and time) when the action was recorded.
Action ID	Unique impact.com identifier for the action.
OID	Unique OID (Order ID) for the action.
Partner	Specifies the partner which drove the action: partner, source, or unidentified.
Partner ID	Unique identifier for the partner (partner, source, or unidentified)
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.

Manage the report

Related Articles