Pepperjam ON THIS PAGE
Pepperjam is an affiliate marketing solutions provider that powers growth for marketers seeking a scaled alternative to their primary sales and marketing channels.
Pepperjam integration replicates data using the Pepperjam Advertiser API v20120402 .
See the
Schema section for a list of objects available for replication.
Feature snapshot
A high-level look at this connector, including useful links, and supported features.
Preparing for authentication To access your data, you need to authenticate the connection with your account credentials.
Information note Make sure that the account you use has read access to the tables you want to fetch.
Creating the connection For more information, see Connecting to SaaS applications
Fill in the required connection properties. Provide a name for the connection in Connection name .
Select Open connection metadata to define metadata for the connection when it has been created.
Click Create .
Connection settings Setting Description Data gateway
Select a Data Movement gateway if required by your use case.
Information note This field is not available with the Qlik Talend Cloud Starter subscription, as it does not support Data Movement gateway . If you have another subscription tier and do not want to use Data Movement gateway , select None .
For information on the benefits of Data Movement gateway and use cases that require it, see Qlik Data Gateway - Data Movement
Start Date Enter the date, in the format MM/DD/YYYY, from which the data must be replicated from your source to your target.
API Key API key.
Information note Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.
The schema and info displayed below is for version 1.
Depending on your destination, table and column names may not appear as they are outlined below.
creative_advanced
The creative_advanced table contains information about advanced link creatives in your Pepperjam account.
creative_advanced table foreign keys Join creative_advanced with on creative_banner creative_advanced.private_affiliates.affiliate_id = creative_banner.private_affiliates.affiliate_id creative_advanced.promotions.id = creative_banner.promotions.id creative_coupon creative_advanced.private_affiliates.affiliate_id = creative_coupon.private_affiliates.affiliate_id creative_advanced.promotions.id = creative_coupon.promotions.id creative_text creative_advanced.private_affiliates.affiliate_id = creative_text.private_affiliates.affiliate_id creative_advanced.promotions.id = creative_text.promotions.id creative_promotion creative_advanced.promotions.id = creative_promotion.id
creative_advanced table schema
code
STRING
created
DATE-TIME
description
STRING
end_date
DATE-TIME
flash_url
STRING
id
INTEGER
modified
DATE-TIME
name
STRING
personalized
INTEGER
private
INTEGER
private_affiliates
ARRAY
This is a nested data structure:
affiliate_id: INTEGER first_name: STRING last_name: STRING
promotions
ARRAY
This is a nested data structure:
start_date
DATE-TIME
status
STRING
sub_type
STRING
supression_url
STRING
type
STRING
verified
STRING
view_date
DATE-TIME
creative_banner
The creative_banner table contains information about banner creatives in your Pepperjam account.
creative_banner table foreign keys Join creative_banner with on creative_advanced creative_banner.private_affiliates.affiliate_id = creative_advanced.private_affiliates.affiliate_id creative_banner.promotions.id = creative_advanced.promotions.id creative_coupon creative_banner.private_affiliates.affiliate_id = creative_coupon.private_affiliates.affiliate_id creative_banner.promotions.id = creative_coupon.promotions.id creative_text creative_banner.private_affiliates.affiliate_id = creative_text.private_affiliates.affiliate_id creative_banner.promotions.id = creative_text.promotions.id creative_promotion creative_banner.promotions.id = creative_promotion.id
creative_banner table schema
allow_deep_link
INTEGER
alt_text
STRING
banner_url
STRING
created
DATE-TIME
description
STRING
destination_url
STRING
end_date
DATE-TIME
height
INTEGER
id
INTEGER
modified
DATE-TIME
name
STRING
private
INTEGER
private_affiliates
ARRAY
This is a nested data structure:
affiliate_id: INTEGER first_name: STRING last_name: STRING
promotions
ARRAY
This is a nested data structure:
start_date
DATE-TIME
status
STRING
type
STRING
view_date
DATE-TIME
width
INTEGER
creative_coupon
The creative_coupon table contains information about coupon creatives in your Pepperjam account.
creative_coupon table foreign keys Join creative_coupon with on creative_advanced creative_coupon.private_affiliates.affiliate_id = creative_advanced.private_affiliates.affiliate_id creative_coupon.promotions.id = creative_advanced.promotions.id creative_banner creative_coupon.private_affiliates.affiliate_id = creative_banner.private_affiliates.affiliate_id creative_coupon.promotions.id = creative_banner.promotions.id creative_text creative_coupon.private_affiliates.affiliate_id = creative_text.private_affiliates.affiliate_id creative_coupon.promotions.id = creative_text.promotions.id creative_promotion creative_coupon.promotions.id = creative_promotion.id
creative_coupon table schema
coupon_code
STRING
created
DATE-TIME
description
STRING
end_date
DATE-TIME
id
INTEGER
modified
DATE-TIME
name
STRING
personalized
INTEGER
private
INTEGER
private_affiliates
ARRAY
This is a nested data structure:
affiliate_id: INTEGER first_name: STRING last_name: STRING
promotions
ARRAY
This is a nested data structure:
start_date
DATE-TIME
status
STRING
type
STRING
url
STRING
view_date
DATE-TIME
creative_generic
The creative_generic table contains information about generic link creatives in your Pepperjam account.
creative_generic table foreign keys creative_generic table schema
allow_deep_link
INTEGER
modified
DATE-TIME
type
STRING
url
STRING
The creative_performance table contains information about your Pepperjam creatives’ performance within a -day time frame from the date of the last table replication.
Note : During every replication job, Stitch will replicate the last days’ worth of data for this table. Refer to the Attribution windows and data extraction section for more info.
Replication Method
CDC
Primary Keys
creative_id
creative_type
date
Replication Key
datetime
Useful links
Pepperjam API method
The creative_performance_by_publisher table contains information about your Pepperjam creatives’ performance, per publisher, within a -day time frame from the date of the last table replication.
Note : During every replication job, Stitch will replicate the last days’ worth of data for this table. Refer to the Attribution windows and data extraction section for more info.
Replication Method
CDC
Primary Keys
creative_id
creative_type
date
publisher_id
Replication Key
datetime
Useful links
Pepperjam API method
creative_product
The creative_product table contains information about product creatives in your Pepperjam account.
creative_product table schema
age_range
STRING
artist
STRING
aspect_ratio
STRING
author
STRING
battery_life
STRING
binding
STRING
buy_url
STRING
category_network
STRING
category_program
STRING
color
STRING
color_output
STRING
condition
STRING
description_long
STRING
description_short
STRING
director
STRING
discontinued
STRING
display_type
STRING
edition
STRING
expiration_date
STRING
features
STRING
focus_type
STRING
functions
STRING
genre
STRING
heel_height
STRING
height
STRING
id
INTEGER
image_thumb_url
STRING
image_url
STRING
in_stock
STRING
installation
STRING
isbn
STRING
keywords
STRING
length
STRING
load_type
STRING
location
STRING
made_in
STRING
manufacturer
STRING
material
STRING
megapixels
STRING
memory_capacity
STRING
memory_card_slot
STRING
memory_type
STRING
model_number
STRING
mpn
STRING
name
STRING
occasion
STRING
operating_system
STRING
optical_drive
STRING
pages
INTEGER
payment_accepted
STRING
payment_notes
STRING
platform
STRING
price
NUMBER
price_retail
NUMBER
price_sale
NUMBER
price_shipping
NUMBER
processor
STRING
product_format
STRING
publisher
STRING
quantity_in_stock
INTEGER
rating
STRING
recommended_usage
STRING
resolution
STRING
screen_size
STRING
shipping_method
STRING
shoe_size
STRING
shoe_width
STRING
size
STRING
sku
STRING
staring
STRING
style
STRING
tech_spec_url
STRING
tracks
INTEGER
upc
STRING
weight
STRING
width
STRING
wireless_interface
STRING
year
STRING
zoom
STRING
The creative_promotion table contains information about promotion creatives in your Pepperjam name account.
creative_text
The creative_text table contains information about text creatives in your Pepperjam account.
creative_text table foreign keys Join creative_text with on creative_advanced creative_text.private_affiliates.affiliate_id = creative_advanced.private_affiliates.affiliate_id creative_text.promotions.id = creative_advanced.promotions.id creative_banner creative_text.private_affiliates.affiliate_id = creative_banner.private_affiliates.affiliate_id creative_text.promotions.id = creative_banner.promotions.id creative_coupon creative_text.private_affiliates.affiliate_id = creative_coupon.private_affiliates.affiliate_id creative_text.promotions.id = creative_coupon.promotions.id creative_promotion creative_text.promotions.id = creative_promotion.id
creative_text table schema
allow_deep_link
INTEGER
created
DATE-TIME
description
STRING
end_date
DATE-TIME
id
INTEGER
link_anchor_text
STRING
modified
DATE-TIME
private
INTEGER
private_affiliates
ARRAY
This is a nested data structure:
affiliate_id: INTEGER first_name: STRING last_name: STRING
promotions
ARRAY
This is a nested data structure:
start_date
DATE-TIME
status
STRING
type
STRING
url
STRING
view_date
DATE-TIME
group
The group table contains information about groups in your Pepperjam account.
group table schema
assigned_publishers
INTEGER
id
INTEGER
name
STRING
group_member
The group_member table contains information about members within groups in your Pepperjam account.
group_member table foreign keys group_member table schema
default
STRING
group_id
INTEGER
id
INTEGER
name
STRING
product_count
INTEGER
itemized_list
The itemized_list table contains information about your itemized lists in your Pepperjam account.
itemized_list table foreign keys itemized_list table schema
default
STRING
id
INTEGER
name
STRING
product_count
INTEGER
itemized_list_product
The itemized_list_product table contains information about products within your itemized lists in your Pepperjam account.
itemized_list_product table foreign keys Join itemized_list_product with on itemized_list itemized_list_product.list_id = itemized_list.id
itemized_list_product table schema
id
STRING
list_id
INTEGER
name
STRING
publisher
The publisher table contains information about the publishers, the publishers’ status, and the publishers’ term in your Pepperjam account.
publisher table foreign keys Join publisher with on creative_performance publisher.group.id = creative_performance.group_id creative_performance_by_publisher publisher.group.id = creative_performance_by_publisher.group_id publisher.id = creative_performance_by_publisher.publisher_id group publisher.group.id = group.id group_member publisher.group.id = group_member.group_id publisher_performance publisher.group.id = publisher_performance.group_id publisher.id = publisher_performance.publisher_id transaction_details publisher.group.id = transaction_details.group_id publisher.id = transaction_details.publisher_id transaction_history publisher.group.id = transaction_history.group_id publisher.id = transaction_history.publisher_id term publisher.term.id = term.id
publisher table schema
category
ARRAY
This is a nested data structure:
company
STRING
country
STRING
first_name
STRING
group
ARRAY
This is a nested data structure:
id
INTEGER
join_date
DATE-TIME
last_name
STRING
primary_promo_method
STRING
promotional_method
ARRAY
This is a nested data structure:
request_date
DATE-TIME
state
STRING
status
STRING
term
ARRAY
This is a nested data structure:
transparency
INTEGER
website
STRING
The publisher_performance table contains information about publishers’ performance within a -day time frame from the date of the last table replication.
Note : During every replication job, Stitch will replicate the last days’ worth of data for this table. Refer to the Attribution windows and data extraction section for more info.
Replication Method
CDC
Primary Keys
date
publisher_id
Replication Key
datetime
Useful links
Pepperjam API method
term
The term table contains information about the terms for your program in your Pepperjam account.
term table foreign keys Join term with on publisher term.id = publisher.term.id
term table schema
cookie_duration
STRING
created
DATE
default
STRING
id
INTEGER
name
STRING
transaction_details
The transaction_details table contains all publisher transaction details, within a -day time frame from the date of the last table replication.
Note : During every replication job, Stitch will replicate the last days’ worth of data for this table. Refer to the Attribution windows and data extraction section for more info.
Replication Method
CDC
Primary Key
transaction_id
Replication Key
sale_date
Useful links
Pepperjam API method
transaction_details table foreign keys Join transaction_details with on creative_performance transaction_details.creative_id = creative_performance.creative_id transaction_details.group_id = creative_performance.group_id creative_performance_by_publisher transaction_details.creative_id = creative_performance_by_publisher.creative_id transaction_details.group_id = creative_performance_by_publisher.group_id transaction_details.publisher_id = creative_performance_by_publisher.publisher_id group transaction_details.group_id = group.id group_member transaction_details.group_id = group_member.group_id publisher transaction_details.group_id = publisher.group.id transaction_details.publisher_id = publisher.id publisher_performance transaction_details.group_id = publisher_performance.group_id transaction_details.publisher_id = publisher_performance.publisher_id transaction_history transaction_details.group_id = transaction_history.group_id transaction_details.order_id = transaction_history.order_id transaction_details.publisher_id = transaction_history.publisher_id transaction_details.transaction_id = transaction_history.transaction_id
transaction_details table schema
click_id
STRING
commission
NUMBER
commission_publisher
NUMBER
commission_site
NUMBER
company
STRING
coupons
STRING
creative_id
STRING
device_type
STRING
group_id
INTEGER
link_type
STRING
new_to_file
STRING
order_id
STRING
publisher
STRING
publisher_id
INTEGER
publisher_type
STRING
sale_amount
NUMBER
sale_date
DATE-TIME
status
STRING
transaction_id
INTEGER
transaction_type
STRING
transaction_history
The transaction_history table contains all historical publisher transactions, within a -day time frame from the date of the last table replication.
Note : During every replication job, Stitch will replicate the last days’ worth of data for this table.
Replication Method
CDC
Primary Keys
transaction_id
process_date
sale_date
Replication Key
sale_date
Useful links
Pepperjam API method
transaction_history table foreign keys Join transaction_history with on creative_performance transaction_history.group_id = creative_performance.group_id creative_performance_by_publisher transaction_history.group_id = creative_performance_by_publisher.group_id transaction_history.publisher_id = creative_performance_by_publisher.publisher_id group transaction_history.group_id = group.id group_member transaction_history.group_id = group_member.group_id publisher transaction_history.group_id = publisher.group.id transaction_history.publisher_id = publisher.id publisher_performance transaction_history.group_id = publisher_performance.group_id transaction_history.publisher_id = publisher_performance.publisher_id transaction_details transaction_history.group_id = transaction_details.group_id transaction_history.order_id = transaction_details.order_id transaction_history.publisher_id = transaction_details.publisher_id transaction_history.transaction_id = transaction_details.transaction_id
transaction_history table schema
commission
NUMBER
company
STRING
group_id
INTEGER
item_id
STRING
link_type
STRING
order_id
STRING
process_date
DATE-TIME
publisher
STRING
publisher_commission
NUMBER
publisher_id
INTEGER
publisher_type
STRING
revision
STRING
sale_amount
NUMBER
sale_date
DATE-TIME
site_commission
NUMBER
status
STRING
transaction_id
INTEGER
transaction_type
STRING
website_url
STRING
