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:
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
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