AdRoll
AdRoll is an ecommerce marketing platform that gives growing D2C brands the power to connect with customers wherever they are.
AdRoll integration replicates data using the NextRoll API.
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.
정보 메모사용하는 계정에 가져오려는 테이블에 대한 읽기 액세스 권한이 있는지 확인합니다.
To generate your client ID and secret:
- Log into your AdRoll account.
- Click your user email in the upper-right corner, then click Apps.
- Select New Apps to start registration.
- Enter a meaningful App name.
- Enable Starter API Access; it is recommended to select Basic API Key Access due to NextRoll's API rate limits.
- Set Callback URL to https://connector.qlik.com/auth/oauth/v3.htm.
- Click Save.
- Copy and paste your client ID and secret into a secured file.
Creating the connection
For more information, see SaaS 응용 프로그램에 연결.
Click Authenticate when you have filled in the required connection settings.
You may be asked to log in to the source application.
A window is displayed with an authentication code.
Copy the code to the clipboard and return to the connection dialog.
Paste the code in Complete authentication with the code provided by the source and click Verify.
팁 메모You may need to scroll down to see this field.
When status is Verified, the authentication is verified.
Provide a name for the connection in Connection name.
Select Open connection metadata to define metadata for the connection when it has been created.
Connection settings| Setting | Description |
|---|
| Data gateway | 사용 사례에 필요한 경우 데이터 이동 게이트웨이를 선택합니다. 정보 메모이 필드는 데이터 이동 게이트웨이를 지원하지 않으므로 Qlik Talend Cloud 시작 구독에서는 사용할 수 없습니다. 다른 구독 계층이 있고 데이터 이동 게이트웨이를 사용하지 않으려면 없음을 선택합니다. 데이터 이동 게이트웨이의 이점과 이를 필요로 하는 사용 사례에 대한 자세한 내용은 Qlik 데이터 게이트웨이 - 데이터 이동를 참조하십시오. |
| Start Date | 데이터를 소스에서 대상으로 복제해야 하는 날짜를 MM/DD/YYYY 형식으로 입력합니다. |
| Lookback Window | Lookback window is the period during which recent data changes are checked and captured at each sync. Default is 7 days. |
| Client ID | Client ID. |
| Client Secret | Client secret. |
| End Date | The end date defines the last day included in data extraction in yyyy-mm-dd format. Default is the current day. |
Schema
정보 메모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.
ad_groups
The ad_groups table contains info about the adgroups contained within the campaigns of your AdRoll account.
| Join ad_groups with | on |
|---|
| ads | ad_groups.eid = ads.adgroups.id ad_groups.ads.id = ads.eid ad_groups.ads.id = ads.original_ad |
| campaigns | ad_groups.eid = campaigns.adgroups.items |
| ad_reports | ad_groups.ads.id = ad_reports.ad |
| segments | ad_groups.segments.id = segments.eid |
ad_optimization
STRING
|
ads
ARRAY
This is a nested data structure: |
campaign
STRING
|
coops
ARRAY
This is a nested data structure. |
created_date
DATE-TIME
|
demographic_targets
ARRAY
This is a nested data structure. |
eid
STRING
|
flight_timezone
STRING
|
geo_targets
ARRAY
This is a nested data structure. |
is_cats4gold
BOOLEAN
|
name
STRING
|
placement_targets
ARRAY
This is a nested data structure. |
platform_targets
ARRAY
This is a nested data structure. |
segments
ARRAY
This is a nested data structure: - id: STRING
- is_negative: BOOLEAN
|
site_exclusions
ARRAY
This is a nested data structure. |
space_optimization
STRING
|
status
STRING
|
type
STRING
|
updated_date
DATE-TIME
|
ad_reports
The ad_reports table contains ad-level reporting data from your AdRoll account.
Replication Method | CDC |
Primary Keys | eid date |
Replication Key | date |
| Useful links |
AdRoll API method
|
| Join ad_reports with | on |
|---|
| ad_groups | ad_reports.ad = ad_groups.ads.id |
| ads | ad_reports.ad = ads.eid ad_reports.ad = ads.original_ad |
ad
STRING
|
ad_size
STRING
|
adjusted_click_through_ratio
NUMBER
|
adjusted_cpa
NUMBER
|
adjusted_ctc
INTEGER
|
adjusted_total_conversion_rate
NUMBER
|
adjusted_total_conversions
INTEGER
|
adjusted_view_through_ratio
NUMBER
|
adjusted_vtc
INTEGER
|
advertiser
STRING
|
attributed_click_through_rev
NUMBER
|
attributed_rev
NUMBER
|
attributed_view_through_rev
NUMBER
|
billing_cost
NUMBER
|
click_cpa
NUMBER
|
click_through_conversions
INTEGER
|
click_through_ratio
NUMBER
|
clicks
INTEGER
|
cost
NUMBER
|
cpa
NUMBER
|
cpc
NUMBER
|
cpm
NUMBER
|
created_date
STRING
|
ctr
NUMBER
|
date
DATE-TIME
|
eid
STRING
|
height
INTEGER
|
impressions
INTEGER
|
paid_impressions
INTEGER
|
prospects
INTEGER
|
roi
NUMBER
|
status
STRING
|
total_conversion_rate
NUMBER
|
total_conversions
INTEGER
|
type
STRING
|
view_through_conversions
INTEGER
|
view_through_ratio
NUMBER
|
width
INTEGER
|
ads
The ads table contains information about the ads and creatives associated with the advertisables in your AdRoll account.
| Join ads with | on |
|---|
| ad_groups | ads.adgroups.id = ad_groups.eid ads.eid = ad_groups.ads.id ads.original_ad = ad_groups.ads.id |
| campaigns | ads.adgroups.id = campaigns.adgroups.items |
| ad_reports | ads.eid = ad_reports.ad ads.original_ad = ad_reports.ad |
ad_format
STRING
|
ad_format_id
INTEGER
|
ad_format_name
STRING
|
ad_parameters
ARRAY
This is a nested data structure. |
adgroups
ARRAY
This is a nested data structure: |
advertisable
STRING
|
app_id
STRING
|
body
STRING
|
body_dynamic
STRING
|
brand_name
STRING
|
call_to_action
STRING
|
created_date
DATE-TIME
|
destination_url
STRING
|
display_url_override
STRING
|
eid
STRING
|
has_edits
BOOLEAN
|
has_future_campaigns
BOOLEAN
|
has_pending_edits
BOOLEAN
|
headline
STRING
|
headline_dynamic
STRING
|
height
INTEGER
|
inventory_type
STRING
|
is_active
BOOLEAN
|
is_fb_dynamic
BOOLEAN
|
is_liquid
STRING
|
is_outlined
BOOLEAN
|
lead_gen_form_id
STRING
|
message
STRING
|
message_dynamic
STRING
|
multi_share_optimized
STRING
|
multiple_products
STRING
|
name
STRING
|
original_ad
STRING
|
outline_color
STRING
|
replacement_ad
STRING
|
src
STRING
|
status
STRING
|
type
STRING
|
updated_date
DATE-TIME
|
valid_clicktag
BOOLEAN
|
width
INTEGER
|
advertisables
The advertisables table contains information about the advertisables in your AdRoll account.
| Join advertisables with | on |
|---|
| campaigns | advertisables.eid = campaigns.advertisable |
| segments | advertisables.eid = segments.advertisable_eid |
abm_onboarding_status
STRING
|
account
STRING
|
account_country_code
STRING
|
account_is_autobilled
BOOLEAN
|
account_is_prepaid
BOOLEAN
|
account_is_suspended
BOOLEAN
|
account_suspension_reason
STRING
|
admin_page_permission
BOOLEAN
|
am_email
STRING
|
approval_state
STRING
|
attached_users
ARRAY
This is a nested data structure. |
blacklisted_sites
ARRAY
This is a nested data structure. |
business_unit
STRING
|
campaign_monitor_client_api_key
STRING
|
campaign_monitor_client_id
STRING
|
click_through_conversion_window
INTEGER
|
cm_networks
STRING
|
company_phone
STRING
|
constant_contact_code
STRING
|
constant_contact_oauth_url
STRING
|
country_code
STRING
|
created_date
DATE-TIME
|
csm_admin
STRING
|
currency
STRING
|
default_homepage
STRING
|
default_utm
STRING
|
eid
STRING
|
enable_customer_multi_dur_segs
BOOLEAN
|
fb_offsite_pixels_tos_accepted
BOOLEAN
|
fbx_account_id
INTEGER
|
fbx_page_id
STRING
|
fbx_page_url
STRING
|
has_approved_consent_solution
BOOLEAN
|
has_approved_safari_add_on
BOOLEAN
|
has_created_campaign
BOOLEAN
|
has_offsite_pixels
BOOLEAN
|
has_privacy_policy
BOOLEAN
|
has_sales_and_leads_automation
BOOLEAN
|
hide_optins_page
BOOLEAN
|
homepage_enabled
BOOLEAN
|
iab1_category_id
INTEGER
|
iab1_category_name
STRING
|
iab2_category_id
INTEGER
|
iab2_category_name
STRING
|
iab_content_id
INTEGER
|
instagram_actor_id
STRING
|
ip_address_exclusions
ARRAY
This is a nested data structure. |
is_abm_customer
BOOLEAN
|
is_active
BOOLEAN
|
is_b2b
BOOLEAN
|
is_campaign_monitor_syncing
BOOLEAN
|
is_constant_contact_syncing
BOOLEAN
|
is_coop_approved
STRING
|
is_kpi_eligible
BOOLEAN
|
is_managed
BOOLEAN
|
is_marketo_syncing
BOOLEAN
|
is_salesforce_system_owned
BOOLEAN
|
is_suspended
BOOLEAN
|
is_trusted
BOOLEAN
|
is_twitter_syncing
BOOLEAN
|
liquidads
STRING
|
logo_url
STRING
|
magellan_legacy
BOOLEAN
|
magellan_query
BOOLEAN
|
marketo_api_endpoint
STRING
|
marketo_client_id
STRING
|
marketo_secret_key
STRING
|
name
STRING
|
nbam_admin
STRING
|
ops
STRING
|
optimizer
STRING
|
optimizer_email
STRING
|
organization
STRING
|
page_access_request_status
STRING
|
path_name
STRING
|
product_name
STRING
|
recent_theme_color
STRING
|
reskin_enabled
BOOLEAN
|
revshare_click_percent
NUMBER
|
revshare_view_percent
NUMBER
|
rollcrawl_enabled
BOOLEAN
|
rollworks_self_serve_ads
BOOLEAN
|
safari_add_on_theme
STRING
|
saleser
STRING
|
self_serve_prospecting_enabled
BOOLEAN
|
show_dpa
BOOLEAN
|
show_web_dynamic_ads
BOOLEAN
|
source
STRING
|
status
STRING
|
twitter_handle
STRING
|
uhura_enabled
BOOLEAN
|
updated_date
STRING
|
url
STRING
|
use_universal_campaigns
BOOLEAN
|
view_through_conversion_window
INTEGER
|
zvelo_category_id
INTEGER
|
zvelo_category_name
STRING
|
campaigns
The campaigns table contains information about the advertising campaigns in your AdRoll account.
| Join campaigns with | on |
|---|
| ad_groups | campaigns.adgroups.items = ad_groups.eid |
| ads | campaigns.adgroups.items = ads.adgroups.id |
| advertisables | campaigns.advertisable = advertisables.eid |
| segments | campaigns.advertisable = segments.advertisable_eid |
abm_type
STRING
|
adgroups
ARRAY
This is a nested data structure. |
advertisable
STRING
|
bid_strategy
STRING
|
bid_strategy_target
STRING
|
bid_type
STRING
|
budget
NUMBER
|
campaign_type
STRING
|
cpc
NUMBER
|
cpm
NUMBER
|
created_date
DATE-TIME
|
eid
STRING
|
end_date
DATE-TIME
|
facebook_campaign_objective
STRING
|
frequency_cap
STRING
|
is_active
BOOLEAN
|
is_apple
BOOLEAN
|
is_cats4gold
BOOLEAN
|
is_coop
BOOLEAN
|
is_facebook
BOOLEAN
|
is_fb_lookalike
BOOLEAN
|
is_fb_wca
BOOLEAN
|
is_fbx_newsfeed
BOOLEAN
|
is_pubgraph
BOOLEAN
|
is_retargeting
BOOLEAN
|
is_rtb
BOOLEAN
|
max_cpm
NUMBER
|
name
STRING
|
pa_sales_stage_eid
STRING
|
pricing_strategies
ARRAY
This is a nested data structure. |
source
STRING
|
spend_limit_until
STRING
|
start_date
DATE-TIME
|
status
STRING
|
ui_budget_daily
BOOLEAN
|
updated_date
DATE-TIME
|
use_case
STRING
|
segments
The segments table contains information about segments, or the lists of users that visit your AdRoll site.
| Join segments with | on |
|---|
| advertisables | segments.advertisable_eid = advertisables.eid |
| campaigns | segments.advertisable_eid = campaigns.advertisable |
| ad_groups | segments.eid = ad_groups.segments.id |
advertisable_eid
STRING
|
conversion_value
STRING
|
created_date
DATE-TIME
|
display_name
STRING
|
duration
INTEGER
|
duration_sec
INTEGER
|
eid
STRING
|
group
INTEGER
|
has_default_rule
BOOLEAN
|
is_active
BOOLEAN
|
match_method
STRING
|
name
STRING
|
parent_id
STRING
|
pattern
STRING
|
product
STRING
|
recent_first_match
BOOLEAN
|
rule
STRING
|
rule_id
INTEGER
|
source
STRING
|
threshold
INTEGER
|
type
STRING
|
