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 项目 | 仅 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.
信息注释请确保您使用的帐户对要获取的表具有读取权限。
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 Starter 订阅，因为它不支持 数据移动网关。如果您有另一个订阅层并且不想使用 数据移动网关，请选择无。 有关 数据移动网关 的优势和需要它的用例的信息，请参阅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
|
