Integration: Pepperjam

This article will help you learn about how Daasity replicates data from Pepperjam, limitations to the data we can extract and where the data is stored in the Pepperjam schema.

Key Topics

Click on the links below to take you to the section where you can learn more about this Integration

Integration Availability

This integration is available for:

  • Growth
  • Pro (V1 and V2)

Integration Overview

Pepperjam is an affiliate marketing platform used by merchants to manage their web-based affiliate advertising campaigns. Pepperjam collects data from publishers (affiliates) and reports metrics such as clicks, impressions, revenue, spend, etc.

The Daasity Pepperjam integration extracts data from the most important endpoints needed to populate the UMS tables: Transaction History, Creative Performance by Publisher, and Publisher Performance.

API Endpoints

The Daasity Pepperjam extractor is built based on this Pepperjam API documentation.  The following endpoints are used by Daasity to replicate data from Pepperjam:

Entity Relationship Diagram (ERD)

The embedded diagram houses the ERD for the Daasity Pepperjam integration illustrating the different tables and keys to join across tables. Hover over the embedded diagram to reveal controls to zoom and scroll.

Pepperjam Schema

The Daasity Pepperjam extractor creates these tables using the endpoints and replication methods listed. The data is mapped from source API endpoint to the table based on the mapping logic outlined in each table.

Publisher Performance

JSON Element Database Column
publisher_id publisher_id
date transaction_date
impressions impressions
clicks clicks
sales sales
leads leads
sale_lead_amount sales_lead_amount
earnings_per_click earnings_per_click
bonus_amount bonus_amount
total_commission total_commission
site_bonus site_bonus
site_commission site_commission
publisher_bonus publisher_bonus
publisher_commission publisher_commission
publisher publisher
company company
state state
website website
publisher_type publisher_type
Daasity: {unique_id} _account_id
Daasity: {merchant_name} __source_id
MD5(publisher_id + date + __source_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Transaction History

  • Endpoint: Transaction History
  • Update Method: UPSERT
  • Table Name: pepperjam.transaction_history
JSON Element Database Column
publisher_id publisher_id
transaction_id transaction_id
sale_date sale_date
order_id order_id
status status
link_type link_type
transaction_type transaction_type
publisher_commission publisher_commission
site_commission site_commission
sale_amount sale_amount
process_date process_date
revision revision
item_id item_id
publisher publisher
company company
website_url website_url
publisher_type publisher_type
Daasity: {unique_id} _account_id
Daasity: {merchant_name} __source_id
MD5(transaction_id + item_id + revision + sales_date + __source_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Creative Performance by Publisher

JSON Element Database Column
creative_id creative_id
creative_type creative_type
creative_name creative_name
publisher_id publisher_id
publisher publisher
date date
impressions impressions
transactions transactions
clicks clicks
click_through_rate click_through_rate
sales sales
earnings_per_click earnings_per_click
commission commission
Daasity: {unique_id} _account_id
Daasity: {merchant_name} __source_id
MD5(publisher_id + creative_id + date + __source_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Creative Private Affiliates

  • Endpoint: Creative Banner
  • Update Method: UPSERT
  • Table Name: pepperjam.creative_private_affiliates
JSON Element Database Column
id creative_id
type creative_type
private_affiliates::affiliate_id private_affiliate_id
private_affiliates::first_name private_affiliate_firstname
private::affiliates::last_name private_affiliates_lastname
Daasity: {unique_id} _account_id
Daasity: {merchant_name} __source_id
MD5(id + type + private_affiliates::affiliate_id + __source_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Creative Promotion Table

  • Endpoint: Creative Banner
  • Update Method: UPSERT
  • Table Name: pepperjam.creative_promotion
JSON Element Database Column
id creative_id
type creative_type
promotions::id promotion_id
promotions::name promotion_name
Daasity: {unique_id} _account_id
Daasity: {merchant_name} __source_id
MD5(id + type + private_affiliates::affiliate_id + __source_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Creative Type Advanced

JSON Element Database Column
id id
type type
name name
sub_type sub_type
code code
description description
verified verified
start_date start_date
end_date end_date
view_date view_date
created created_at
modified updated_at
status status
Daasity: {unique_id} _account_id
Daasity: {merchant_name} __source_id
MD5(id + type + __source_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Creative Type Banner

  • Endpoint: Creative Banner
  • Update Method: UPSERT
  • Table Name: pepperjam.creative_type_banner
JSON Element Database Column
id id
type type
name name
destination_url destination_url
banner_url banner_url
width width
height height
description description
allow_deep_link allow_deep_link
start_date start_date
end_date end_date
view_date view_date
created created_at
modified updated_at
status status
Daasity: {unique_id} _account_id
Daasity: {merchant_name} __source_id
MD5(id + type + __source_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Creative Type Coupon

  • Endpoint: Creative Coupon
  • Update Method: UPSERT
  • Table Name: pepperjam.creative_type_coupon
JSON Element Database Column
id id
type type
name name
description description
url url
coupon_code coupon_code
personalized personalized
start_date start_date
end_date end_date
created created_at
modified updated_at
status status
Daasity: {unique_id} _account_id
Daasity: {merchant_name} __source_id
MD5(id + type + __source_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Creative Type Generic

  • Endpoint: Creative Generic
  • Update Method: UPSERT
  • Table Name: pepperjam.creative_type_generic
JSON Element Database Column
type type
allow_deep_link allow_deep_link
url url
modified modified
Daasity: {unique_id} _account_id
Daasity: {merchant_name} __source_id
MD5(type + url + __source_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Creative Type Promotion

  • Endpoint: Creative Promotion
  • Update Method: UPSERT
  • Table Name: pepperjam.creative_type_promotion
JSON Element Database Column
id id
name name
Daasity: {unique_id} _account_id
Daasity: {merchant_name} __source_id
MD5(id + name + __source_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Creative Type Text

  • Endpoint: Creative Text
  • Update Method: UPSERT
  • Table Name: pepperjam.creative_type_text
JSON Element Database Column
id id
type type
url url
description description
allow_deep_link allow_deep_link
start_date start_date
end_date end_date
view_date view_date
created created_at
modified updated_at
status status
Daasity: {unique_id} _account_id
Daasity: {merchant_name} __source_id
MD5(id + type + __source_id) __sync_key
Daasity: timestamp when loaded into DB __synced_at

Related Resources