Pepperjam Predefined Reports

Overview

The Pepperjam datasource in Rivery comes with the below predefined reports. Each report will have a short description of the data, a list of customizable fields (if any), and the schema mapping. Due to the standardized nature of these reports, there are a number of locked fields that will only be accessible through the custom reporting functionality.

Publisher Performance By Publisher

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

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 year time frame.

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 year time frame.

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 within a given year time frame.

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 the summary of the itemized product transactions within a given year time frame.

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 year time frame.

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 resource displays all the payments and fees within a given year time frame.

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