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.

Immagine di alto livello di questo connettore, inclusi collegamenti utili e funzionalità supportate.

Funzionalità/Capacità	Dettagli del supporto
Progetti Qlik Talend Data Integration supportati	Solo i progetti di replica. I progetti delle pipeline di dati non sono supportati.
Metodi di aggiornamento della destinazione	Attività di replica: Applica modifiche Archivia modifiche Trasferimento dei dati nelle attività di un data lake: Change Data Capture (CDC)
Gestione dei metadati	La generazione manuale dei metadati non è richiesta.
Evoluzione dello schema	È supportata solo l'operazione Cambia tipo di dati colonne.
Replica delle colonne LOB (NCLOB, CLOB e BLOB)	Operazione non supportata.
CDC pianificato	Operazione richiesta. In questo modo la destinazione viene aggiornata con le modifiche apportate alla sorgente. Per le attività di replica, vedere Attività di pianificazione Per le attività di trasferimento su data lake, vedere Pianificazione delle attività CDC per i processi di trasferimento su data lake
Notifiche	Operazione parzialmente supportata Impostare notifiche quando vengono apportate modifiche al funzionamento
Monitoraggio	Solo attività CDC, in quanto il caricamento completo non è rilevante per questo connettore. Monitoraggio di un'attività dati individuale
Annullamento automatico della nidificazione dei payload nelle colonne JSON	Operazione non supportata. La nidificazione per i payload della colonna JSON nei set di dati di origine non viene annullata automaticamente nella destinazione.

Preparing for authentication

To access your data, you need to authenticate the connection with your account credentials.

Assicurarsi che l'account utilizzata disponga di accesso di lettura per le tabelle che si desidera recuperare.

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 Connessione alle applicazioni 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.
Nota di suggerimentoYou 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	Selezionare un Gateway Data Movement se richiesto dal proprio caso di utilizzo. Nota informatica Questo campo non è disponibile con la sottoscrizione a Avvio Qlik Talend Cloud, poiché non supporta il Gateway Data Movement. Se si dispone di un altro livello di sottoscrizione e non si desidera utilizzare il Gateway Data Movement, selezionare Nessuno. Per informazioni sui vantaggi del Gateway Data Movement e quando è richiesto, vedere Qlik Data Gateway - Movimento dati.
Start Date	Inserire la data, nel formato `MM/DD/YYYY`, a partire dalla quale i dati devono essere replicati dalla sorgente alla destinazione.
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.

Replication Method

Full Table

Primary Key

eid

Useful links

AdRoll documentation

AdRoll API method

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:

id: STRING
status: STRING

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

Join ad_reports with

ad_groups

ad_reports.ad = ad_groups.ads.id

ads

ad_reports.ad = ads.eid

ad_reports.ad = ads.original_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

The ads table contains information about the ads and creatives associated with the advertisables in your AdRoll account.

Replication Method

Full Table

Primary Key

eid

Useful links

AdRoll documentation

AdRoll API method

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

Join ads with

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:

id: STRING
status: STRING

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.

Replication Method

Full Table

Primary Key

eid

Useful links

AdRoll documentation

AdRoll API method

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.

Replication Method

Full Table

Primary Key

eid

Useful links

AdRoll documentation

AdRoll API method

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.

Replication Method

Full Table

Primary Key

eid

Useful links

AdRoll documentation

AdRoll API method

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

Hai trovato utile questa pagina?

Se riscontri problemi con questa pagina o con il suo contenuto – un errore di battitura, un passaggio mancante o un errore tecnico – ti pregiamo di farcelo sapere!

Lascia qui il tuo feedback