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 프로젝트 복제 프로젝트 에만 해당됩니다. 데이터 파이프라인 프로젝트는 지원되지 않습니다.대상 업데이트 방법
복제 작업:
데이터 레이크 작업에 데이터 랜딩:
메타데이터 관리
수동 메타데이터 생성이 필요하지 않습니다. 스키마 진화
열 데이터 유형 변경 작업만 지원됩니다. 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 시작 구독에서는 사용할 수 없습니다. 다른 구독 계층이 있고 데이터 이동 게이트웨이 를 사용하지 않으려면 없음 을 선택합니다.
데이터 이동 게이트웨이 의 이점과 이를 필요로 하는 사용 사례에 대한 자세한 내용은 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
