Pepperjam Predefined Reports
  • 2 Minutes to read
  • Dark
    Light
  • PDF

Pepperjam Predefined Reports

  • Dark
    Light
  • PDF

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 system schema 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 system schema String Dimension
transaction_id system schema String Dimension
publisher_id system schema String Dimension
order_id system schema 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 system schema String Dimension
transaction_id system schema String Dimension
item_id system schema String Dimension
publisher_id system schema 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 system schema String Dimension
publisher_id system schema 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 system schema String Dimension
publisher_id system schema 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 system schema 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 system schema String Dimension
publisher_id system schema String Dimension
transaction_id system schema String Dimension
item_id system schema 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 system schema String Dimension
id system schema String Dimension
amount String Dimension
description String Dimension
method String Dimension
type String Dimension

Was this article helpful?