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

Pepperjam Predefined Reports

  • Dark
    Light
  • PDF

Article summary

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.

FieldData TypeDimension/Metric
publisher_id system schemaStringDimension
bonus_amountStringDimension
companyStringDimension
earnings_per_clickStringDimension
impressionsStringDimension
leadsStringDimension
publisherStringDimension
publisher_bonusStringDimension
publisher_commissionStringDimension
clicksStringDimension
publisher_typeStringDimension
sale_lead_amountStringDimension
salesStringDimension
site_bonusStringDimension
site_commissionStringDimension
stateStringDimension
total_commissionStringDimension
websiteStringDimension

Transaction Details

The transaction details report resource displays all publisher transactions within a given year time frame.

FieldData TypeDimension/Metric
creative_id system schemaStringDimension
transaction_id system schemaStringDimension
publisher_id system schemaStringDimension
order_id system schemaStringDimension
click_idStringDimension
couponsStringDimension
companyStringDimension
device_typeStringDimension
link_typeStringDimension
new_to_fileStringDimension
commission_siteStringDimension
publisherStringDimension
commission_publisherStringDimension
publisher_typeStringDimension
sale_amountStringDimension
sale_dateStringDimension
statusStringDimension
commissionStringDimension
transaction_typeStringDimension

Transaction History

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

FieldData TypeDimension/Metric
order_id system schemaStringDimension
transaction_id system schemaStringDimension
item_id system schemaStringDimension
publisher_id system schemaStringDimension
commissionStringDimension
process_dateStringDimension
publisherStringDimension
link_typeStringDimension
publisher_typeStringDimension
revisionStringDimension
sale_amountStringDimension
sale_dateStringDimension
statusStringDimension
companyStringDimension
transaction_typeStringDimension
website_urlStringDimension

Creative Performance

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

FieldData TypeDimension/Metric
creative_id system schemaStringDimension
publisher_id system schemaStringDimension
affiliate_usageStringDimension
commissionStringDimension
clicksStringDimension
creative_nameStringDimension
creative_typeStringDimension
earnings_per_clickStringDimension
impressionsStringDimension
publisherStringDimension
click_through_rateStringDimension
salesStringDimension
transactionsStringDimension

Creative Performance By Publisher

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

FieldData TypeDimension/Metric
creative_id system schemaStringDimension
publisher_id system schemaStringDimension
click_through_rateStringDimension
clicksStringDimension
commissionStringDimension
creative_nameStringDimension
creative_typeStringDimension
earnings_per_clickStringDimension
impressionsStringDimension
publisherStringDimension
salesStringDimension
transactionsStringDimension

Itemized Transaction Summary

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

FieldData TypeDimension/Metric
item_id system schemaStringDimension
commissionStringDimension
item_category_nameStringDimension
item_nameStringDimension
quantityStringDimension
sale_amountStringDimension

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.

FieldData TypeDimension/Metric
order_id system schemaStringDimension
publisher_id system schemaStringDimension
transaction_id system schemaStringDimension
item_id system schemaStringDimension
publisherStringDimension
link_typeStringDimension
item_nameStringDimension
item_category_nameStringDimension
companyStringDimension
publisher_typeStringDimension
quantityStringDimension
sale_amountStringDimension
sale_dateStringDimension
statusStringDimension
commissionStringDimension

Payments And Fees

The payments and fees report resource displays all the payments and fees within a given year time frame.

FieldData TypeDimension/Metric
date system schemaStringDimension
id system schemaStringDimension
amountStringDimension
descriptionStringDimension
methodStringDimension
typeStringDimension

Was this article helpful?