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:
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]
Transaction History
Endpoint: Transaction History
Update Method: UPSERT
Table Name: [
pepperjam.transaction_history]
Creative Performance by Publisher
Endpoint: Creative Performance by Publisher
Update Method: UPSERT
Table Name: [
pepperjam.creative_performance_publisher]
Creative Private Affiliates
Endpoint: Creative Banner
Update Method: UPSERT
Table Name: [
pepperjam.creative_private_affiliates]
Creative Promotion Table
Endpoint: Creative Banner
Update Method: UPSERT
Table Name: [
pepperjam.creative_promotion]
Creative Type Advanced
Endpoint: Creative Advanced Links
Update Method: UPSERT
Table Name: [
pepperjam.creative_type_advanced]
Creative Type Banner
Endpoint: Creative Banner
Update Method: UPSERT
Table Name: pepperjam.creative_type_banner
Creative Type Coupon
Endpoint: Creative Coupon
Update Method: UPSERT
Table Name: [
pepperjam.creative_type_coupon]
Creative Type Generic
Endpoint: Creative Generic
Update Method: UPSERT
Table Name: [
pepperjam.creative_type_generic]
Creative Type Promotion
Endpoint: Creative Promotion
Update Method: UPSERT
Table Name: [
pepperjam.creative_type_promotion]
Creative Type Text
Endpoint: Creative Text
Update Method: UPSERT
Table Name: [
pepperjam.creative_type_text]
Last updated