Integration Specifications

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.

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.

This document provides context on what kind of data is being gathered through this extractor, which endpoints that data is coming from, and how the extracted tables relate to each other.

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.

Integration Availability

This integration is available for:

• Enterprise

• Growth

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:

• Creative Advanced Links

• Creative Banner

• Creative Coupon

• Creative Generic

• Creative Performance by Publisher

• Creative Promotion

• Creative Text

• Publisher Performance

• Transaction History

Entity Relationship Diagram (ERD)

Click here to view the ERD for the Daasity Pepperjam integration illustrating the different tables and keys to join across tables.

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