Pepperjam 在该页面上
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.
特性快照 对这个连接器进行高级查看，包括有用的链接和支持的特性。
特性/功能 支持详情 支持的 Qlik Talend Data Integration 项目 仅 Replication 项目 。不支持数据管道项目。 目标更新方法
复制任务：
在数据湖任务中登陆数据：
管理元数据
无需手动生成元数据。 模式演变
只支持更改列数据类型 操作。 复制 LOB 列（NCLOB、CLOB 和 BLOB） 不支持 已计划 CDC 必填字段。这就是目标与源的更改保持同步的方式。
有关复制任务，请参阅计划任务
有关湖登陆任务，请参阅为湖登陆任务调度 CDC
通知 部分支持
设置操作更改通知
监视 仅 CDC，因为满负载与此连接器无关。
监视单个数据任务
JSON 列有效载荷的自动解密 不支持不会自动在目标上删除源数据集中的 JSON 列有效负载。
Preparing for authentication To access your data, you need to authenticate the connection with your account credentials.
信息注释 请确保您使用的帐户对要获取的表具有读取权限。
Creating the connection 有关更多信息，请参阅连接到 SaaS 应用程序
填写所需的连接属性。 在连接名称 中提供连接的名称。
选择打开连接元数据 以定义创建连接时的元数据。
单击创建 。
Connection settings Setting Description Data gateway
如果您的用例需要，请选择一个 数据移动网关 。
信息注释 此字段不适用于 Qlik Talend Cloud Starter 订阅，因为它不支持 数据移动网关 。如果您有另一个订阅层并且不想使用 数据移动网关 ，请选择无 。
有关 数据移动网关 的优势和需要它的用例的信息，请参阅Qlik 数据网关 - 数据移动
Start Date 按格式 MM/DD/YYYY 输入必须将数据从源复制到目标的日期。
API Key API key.
信息注释 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
