Back to home

Help Center

ELT+ | Technical User Documentation

Integrations

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

API Endpoints
Entity Relationship Diagram
Pepperjam Schema
Related Resources

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
Transaction History
Creative Performance by Publisher
Creative Private Affiliates
Creative Promotion
Creative Type Advanced
Creative Type Banner
Creative Type Coupon
Creative Type Generic
Creative Type Promotion
Creative Type Text

Publisher Performance

Endpoint: Publisher Performance
Update Method: UPSERT
Table Name: pepperjam.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

Endpoint: Creative Performance by Publisher
Update Method: UPSERT
Table Name: pepperjam.creative_performance_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

Endpoint: Creative Advanced Links
Update Method: UPSERT
Table Name: pepperjam.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