Pepperjam predefined reports

The Pepperjam datasource in Data Integration includes predefined reports. Each report contains a short description of the data, a list of customizable fields (if any), and the schema mapping.

These reports follow a standardized format, so specific fields are locked, and you can only access them through the Custom reports feature.

Publisher performance by publisher

The Publisher performance report resource displays the publisher performance within a given time frame (year).

Field	Data Type	Dimension/Metric
publisher_id	String	Dimension
bonus_amount	String	Dimension
company	String	Dimension
earnings_per_click	String	Dimension
impressions	String	Dimension
leads	String	Dimension
publisher	String	Dimension
publisher_bonus	String	Dimension
publisher_commission	String	Dimension
clicks	String	Dimension
publisher_type	String	Dimension
sale_lead_amount	String	Dimension
sales	String	Dimension
site_bonus	String	Dimension
site_commission	String	Dimension
state	String	Dimension
total_commission	String	Dimension
website	String	Dimension

Transaction details

The Transaction details report resource displays all publisher transactions within a given time frame (year).

Field	Data Type	Dimension/Metric
creative_id	String	Dimension
transaction_id	String	Dimension
publisher_id	String	Dimension
order_id	String	Dimension
click_id	String	Dimension
coupons	String	Dimension
company	String	Dimension
device_type	String	Dimension
link_type	String	Dimension
new_to_file	String	Dimension
commission_site	String	Dimension
publisher	String	Dimension
commission_publisher	String	Dimension
publisher_type	String	Dimension
sale_amount	String	Dimension
sale_date	String	Dimension
status	String	Dimension
commission	String	Dimension
transaction_type	String	Dimension

Transaction history

The Transaction history report resource displays all publisher transaction history within a given time frame (year).

Field	Data Type	Dimension/Metric
order_id	String	Dimension
transaction_id	String	Dimension
item_id	String	Dimension
publisher_id	String	Dimension
commission	String	Dimension
process_date	String	Dimension
publisher	String	Dimension
link_type	String	Dimension
publisher_type	String	Dimension
revision	String	Dimension
sale_amount	String	Dimension
sale_date	String	Dimension
status	String	Dimension
company	String	Dimension
transaction_type	String	Dimension
website_url	String	Dimension

Creative performance

The Creative performance report resource displays the creative performance within a given year time frame.

Field	Data Type	Dimension/Metric
creative_id	String	Dimension
publisher_id	String	Dimension
affiliate_usage	String	Dimension
commission	String	Dimension
clicks	String	Dimension
creative_name	String	Dimension
creative_type	String	Dimension
earnings_per_click	String	Dimension
impressions	String	Dimension
publisher	String	Dimension
click_through_rate	String	Dimension
sales	String	Dimension
transactions	String	Dimension

Creative performance by publisher

The Creative performance by publisher report resource displays the creative performance per publisher over a given year.

Field	Data Type	Dimension/Metric
creative_id	String	Dimension
publisher_id	String	Dimension
click_through_rate	String	Dimension
clicks	String	Dimension
commission	String	Dimension
creative_name	String	Dimension
creative_type	String	Dimension
earnings_per_click	String	Dimension
impressions	String	Dimension
publisher	String	Dimension
sales	String	Dimension
transactions	String	Dimension

Itemized transaction summary

The Itemized transaction summary report resource displays a summary of the itemized product transactions within a given year.

Field	Data Type	Dimension/Metric
item_id	String	Dimension
commission	String	Dimension
item_category_name	String	Dimension
item_name	String	Dimension
quantity	String	Dimension
sale_amount	String	Dimension

Itemized transactions

The Itemized transactions report resource displays itemized product transactions within a given time frame (year).

note

This report is only available to advertisers who have itemized tracking enabled.

Field	Data Type	Dimension/Metric
order_id	String	Dimension
publisher_id	String	Dimension
transaction_id	String	Dimension
item_id	String	Dimension
publisher	String	Dimension
link_type	String	Dimension
item_name	String	Dimension
item_category_name	String	Dimension
company	String	Dimension
publisher_type	String	Dimension
quantity	String	Dimension
sale_amount	String	Dimension
sale_date	String	Dimension
status	String	Dimension
commission	String	Dimension

Payments and fees

The Payments and fees report shows all payments and fees within a given year.

Field	Data Type	Dimension/Metric
date	String	Dimension
id	String	Dimension
amount	String	Dimension
description	String	Dimension
method	String	Dimension
type	String	Dimension