ヘルプ&サポート
お困りのことはありませんか?
まずはこちらをご利用ください。
チケット発行
貴重なご意見をありがとうございました。
入力必須
できるだけ速やかに対応いたします。

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 タイプ Modifier
タイプ 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)  
製品 character varying(65535)  
campaign_eid character varying(65535)  
currency character varying(65535)  
言語 character varying(65535)  
domain character varying(65535)  
device_id_type character varying(65535)  
device_id character varying(65535)  
イベント 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 タイプ Modifiers
timestamp timestamp without time zone  
advertisable_eid テキスト  
segment_eid テキスト  
adgroup_eid テキスト  
ad_eid テキスト  
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 タイプ Modifiers
timestamp timestamp without time zone  
advertisable_eid テキスト  
segment_eid テキスト  
visitors integer  
収益 bigint  

Indexes:

   "segments_segment_index" btree (segment_eid)

   "segments_timestamp_index" btree ("timestamp")

 

UHURA DELIVERIES

Table "public.deliveries":

Column タイプ Modifiers
timestamp timestamp without time zone  
advertisable_eid テキスト  
adgroup_eid テキスト  
ad_eid テキスト  
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 タイプ Modifiers
Cookie テキスト  
advertisable_eid テキスト  
score double precision  
timestamp timestamp without time zone  

Indexes:

   "segmentation_intent_cookie_index" btree (cookie)

   "segmentation_intent_timestamp_index" btree ("timestamp")

 

この記事は役に立ちましたか?
0人中0人がこの記事が役に立ったと言っています