Ayuda y asistencia técnica
¿Cómo podemos ayudarle?
Esto podría serle de ayuda
ABRIR INCIDENCIA
Gracias por sus comentarios.
Espacio para rellenar
Le contestaremos con la mayor brevedad posible.

AdRoll SQL

AdRollSQL sends your AdRoll performance (impressions, clicks, conversions) data to a Redshift, MySql, Postgres, or S3 database that you host. It’s an easy way to extract, transform and load your AdRoll data into other data sets. 

Setup your AdRoll SQL here

4 steps to setting up your warehouse

1. Choose your warehouse : Redshift or Postgres.

2. Enter the credentials for access, the host and the port. Please note that the port needs to be added separately from the host.

3. You can test your connection by clicking on "Connect". If you see an error like this, it means AdRoll cannot access your database. Please check the permissions on the host.

4. If we are able to successfully connect, we will sync the data at the end of the day UTC. 

 

FAQ 

How do I set up Amazon Redshift?

http://docs.aws.amazon.com/redshift/latest/gsg/getting-started.html

Note: Your redshift warehouse cannot have special characters. More info here.

 

How do I set up Amazon RDS Postgres?

http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_GettingStarted.CreatingConnecting.PostgreSQL.html

 

How do I give permission AdRoll to write to RDS or Redshift?

You can do this by allowing the IP address `52.38.114.50`to write to your instance.

 

How do I give permission AdRoll to write to S3?

Setup a policy similar to:


How often is the data refreshed? 

The data is refreshed every night.

 

Do you do a backfill?

We backfill every 30 days.

 

Does AdRoll host a SQL solution?

Not yet, please send us a feedback if you are interested.

 

What data is included?

Pixel, Impression, Click, View-Through-Conversion and Click-Through-Conversion.

 

What characters can my warehouse password contain?

All characters besides:

+, @, !, {, }, (, ), ;, %

 

What does the schema look like?

AdRoll SQL schema:

Column Tipo Modifier
Tipo character varying(65535)  
adgroup_eid character varying(65535)  
ad_eid character varying(65535)  
width character varying(65535)  
height character varying(65535)  
site_url character varying(65535)  
timestamp timestamp without time zone  
referrer character varying(65535)  
user_agent character varying(65535)  
Cookie character varying(65535)  
ip character varying(65535)  
segment_eid character varying(65535)  
conversion_value character varying(65535)  
external_data character varying(65535)  
producto character varying(65535)  
campaign_eid character varying(65535)  
currency character varying(65535)  
Idioma character varying(65535)  
domain character varying(65535)  
device_id_type character varying(65535)  
device_id character varying(65535)  
Evento character varying(65535)  
event_source    
event_source_version character varying(65535)  
stable_user_identifier character varying(65535)  
product_group character varying(65535)  
product_action character varying(65535)  
domain_normalized character varying(65535)  
geo2_continent_code character varying(65535)  
geo2_country_code character varying(65535)  
geo2_country_code3 character varying(65535)  
geo2_country_name character varying(65535)  
geo2_country_eid character varying(65535)  
geo2_region_name character varying(65535)  
geo2_region_eid character varying(65535)  
geo2_metro_regions character varying(65535)  
geo2_metro_name character varying(65535)  
geo2_metro_eid character varying(65535)  
geo2_city_name character varying(65535)  
geo2_city_eid character varying(65535)  
geo2_latitude character varying(65535)  
geo2_longitude character varying(65535)  
geo2_company character varying(65535)  
geo2_demographics character varying(65535)  
geo2_postal_code_name character varying(65535)  
geo2_postal_code_eid character varying(65535)  
email_id character varying(65535)  

Indexes:

   "timestamp_index" btree ("timestamp")

   "type_index" btree (type)  

 

UHURA ATTRIBUTIONS

 Table "public.attributions":

Column Tipo Modifiers
timestamp timestamp without time zone  
advertisable_eid Texto  
segment_eid Texto  
adgroup_eid Texto  
ad_eid Texto  
vt2 integer  
ct2 integer  
vt2_revenue bigint  
ct2_revenue bigint  

Indexes:

   "attributions_ad_index" btree (ad_eid)

   "attributions_adgroup_index" btree (adgroup_eid)

   "attributions_segment_index" btree (segment_eid)

   "attributions_timestamp_index" btree ("timestamp")

 

UHURA SEGMENTS

Table "public.segments":

Column Tipo Modifiers
timestamp timestamp without time zone  
advertisable_eid Texto  
segment_eid Texto  
visitors integer  
ingresos bigint  

Indexes:

   "segments_segment_index" btree (segment_eid)

   "segments_timestamp_index" btree ("timestamp")

 

UHURA DELIVERIES

Table "public.deliveries":

Column Tipo Modifiers
timestamp timestamp without time zone  
advertisable_eid Texto  
adgroup_eid Texto  
ad_eid Texto  
imp integer  
cli integer  
cost bigint  

Indexes:

   "deliveries_ad_index" btree (ad_eid)

   "deliveries_adgroup_index" btree (adgroup_eid)

   "deliveries_timestamp_index" btree ("timestamp")

 

SEGMENTATION INTENT

 Table "public.segmentation_intent":

Column Tipo Modifiers
Cookie Texto  
advertisable_eid Texto  
score double precision  
timestamp timestamp without time zone  

Indexes:

   "segmentation_intent_cookie_index" btree (cookie)

   "segmentation_intent_timestamp_index" btree ("timestamp")

 

¿Fue útil este artículo?
Usuarios a los que les pareció útil: 0 de 0