Dv 360

Setting up the Dv 360 connector

No	Item	Required	Example	Notes
1	credentials	Yes		Oauth2 credentials
2	partner_id	Yes		Partner ID
3	start_date	Yes		UTC date and time in the format 2017-01-25. Any data before this date will not be replicated
4	end_date	No		UTC date and time in the format 2017-01-25. Any data after this date will not be replicated.
5	filters	No		filters for the dimensions. each filter object had 2 keys: 'type' for the name of the dimension to be used as. and 'value' for the value of the filter

Tables in the Dv 360 connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	standard	500
2	audience_composition	15
3	unique_reach_audience	45
4	reach	36		Full Refresh, Incremental	date
5	floodlight	57

Table: standard

No	Column Name	Type	Notes
1	cpm_fee_2_advertiser_currency	VARCHAR
2	active_view_pct_full_screen	VARCHAR
3	client_cost_viewable_ecpm_advertiser_currency	VARCHAR
4	revenue_ecpc_advertiser_currency	VARCHAR
5	year	VARCHAR
6	profit_viewable_ecpm_usd	VARCHAR
7	zip_code	VARCHAR
8	media_fee_3_usd	VARCHAR
9	nielsen_digital_ad_ratings_fee_usd	VARCHAR
10	total_video_media_cost_ecpcv_usd	VARCHAR
11	refund_billable_cost_advertiser_currency	VARCHAR
12	active_view_pct_visible_at_third_quartile	VARCHAR
13	conversions_per_1000_impressions	VARCHAR
14	invalid_active_view_viewable_impressions	VARCHAR
15	audio_unmutes_audio	VARCHAR
16	active_view_not_measurable_impressions	VARCHAR
17	inventory_source_id_external	VARCHAR
18	counters	VARCHAR
19	floodlight_activity	VARCHAR
20	household_income	VARCHAR
21	media_fee_5_partner_currency	VARCHAR
22	client_cost_ecpa_pc_advertiser_currency	VARCHAR
23	active_view_viewable_impressions	VARCHAR
24	doubleverify_fee_usd	VARCHAR
25	gmail_gender	VARCHAR
26	line_item_lifetime_frequency	VARCHAR
27	cm_post_view_revenue	VARCHAR
28	dma_code	VARCHAR
29	active_view_pct_in_background	VARCHAR
30	audience_name	VARCHAR
31	creative_rendered_in_amp	VARCHAR
32	media_cost_ecpc_advertiser_currency	VARCHAR
33	media_cost_ecpc_pv_usd	VARCHAR
34	active_view_average_viewable_time_seconds	VARCHAR
35	total_media_cost_ecpc_usd	VARCHAR
36	total_media_cost_ecpm_advertiser_currency	VARCHAR
37	sensitive_category	VARCHAR
38	zip_code_id	VARCHAR
39	media_cost_usd	VARCHAR
40	total_media_cost_partner_currency	VARCHAR
41	revenue_advertiser_currency	VARCHAR
42	revenue_ecpa_pc_partner_currency	VARCHAR
43	attributed_userlist	VARCHAR
44	targeted_data_providers	VARCHAR
45	operating_system	VARCHAR
46	custom_fee_4_advertiser_currency	VARCHAR
47	revenue_usd	VARCHAR
48	cpm_fee_2_partner_currency	VARCHAR
49	total_media_cost_ecpa_pv_partner_currency	VARCHAR
50	adsafe_fee_usd	VARCHAR
51	max_video_duration	VARCHAR
52	partner	VARCHAR
53	cm_post_click_revenue	VARCHAR
54	adsafe_fee_advertiser_currency	VARCHAR
55	third_party_ad_server_fee_usd	VARCHAR
56	revenue_ecpe_usd	VARCHAR
57	extension_type	VARCHAR
58	algorithm_id	VARCHAR
59	cpm_fee_4_partner_currency	VARCHAR
60	extension_status	VARCHAR
61	client_cost_advertiser_currency	VARCHAR
62	media_cost_ecpm_usd	VARCHAR
63	cm_placement_id	VARCHAR
64	general_invalid_traffic_givt_active_view_viewable_impressions	VARCHAR
65	total_media_cost_usd	VARCHAR
66	ad_position	VARCHAR
67	invalid_tracked_ads	VARCHAR
68	creative_size	VARCHAR
69	youtube_views	VARCHAR
70	active_view_impressions_visible_10_seconds	VARCHAR
71	media_fee_4_usd	VARCHAR
72	data_management_platform_fee_advertiser_currency	VARCHAR
73	media_cost_viewable_ecpm_partner_currency	VARCHAR
74	line_item	VARCHAR
75	profit_ecpm_advertiser_currency	VARCHAR
76	line_item_integration_code	VARCHAR
77	general_invalid_traffic_givt_active_view_eligible_impressions	VARCHAR
78	creative_width	VARCHAR
79	video_player_size	VARCHAR
80	total_conversions	VARCHAR
81	total_media_cost_viewable_ecpm_partner_currency	VARCHAR
82	verifiable_impressions	VARCHAR
83	partner_currency	VARCHAR
84	custom_fee_3_advertiser_currency	VARCHAR
85	time_to_conversion	VARCHAR
86	trustmetrics_fee_advertiser_currency	VARCHAR
87	integral_ad_science_pre_bid_fee_partner_currency	VARCHAR
88	publisher_property_id	VARCHAR
89	comscore_vce_in_doubleclick_fee_usd	VARCHAR
90	adlingo_fee_advertiser_currency	VARCHAR
91	publisher_property_section_id	VARCHAR
92	month	VARCHAR
93	media_cost_ecpa_pc_advertiser_currency	VARCHAR
94	exchange	VARCHAR
95	video_skippable_support	VARCHAR
96	inventory_source_group_id	VARCHAR
97	evidon_fee_usd	VARCHAR
98	total_media_cost_ecpa_pc_advertiser_currency	VARCHAR
99	adloox_pre_bid_fee_usd	VARCHAR
100	device_model	VARCHAR
101	client_cost_ecpc_advertiser_currency	VARCHAR
102	third_quartile_audio	VARCHAR
103	active_view_pct_of_midpoint_impressions_audible_and_visible	VARCHAR
104	advertiser_id	VARCHAR
105	refund_media_cost_advertiser_currency	VARCHAR
106	attributed_userlist_id	VARCHAR
107	engagements	VARCHAR
108	exchange_code	VARCHAR
109	insertion_order_daily_frequency	VARCHAR
110	general_invalid_traffic_givt_begin_to_render_impressions	VARCHAR
111	gmail_conversions	VARCHAR
112	media_fee_2_partner_currency	VARCHAR
113	inventory_source	VARCHAR
114	media_fee_3_advertiser_currency	VARCHAR
115	teracent_fee_usd	VARCHAR
116	invalid_impressions	VARCHAR
117	revenue_viewable_ecpm_advertiser_currency	VARCHAR
118	creative_attributes	VARCHAR
119	adloox_pre_bid_fee_advertiser_currency	VARCHAR
120	total_media_cost_ecpc_partner_currency	VARCHAR
121	revenue_ecpa_pv_advertiser_currency	VARCHAR
122	revenue_ecpm_usd	VARCHAR
123	comscore_vce_in_doubleclick_fee_partner_currency	VARCHAR
124	line_item_daily_frequency	VARCHAR
125	dma	VARCHAR
126	clicks	VARCHAR
127	media_cost_ecpc_partner_currency	VARCHAR
128	media_fee_4_advertiser_currency	VARCHAR
129	revenue_ecpa_pv_usd	VARCHAR
130	total_media_cost_ecpa_pv_advertiser_currency	VARCHAR
131	channel	VARCHAR
132	gmail_post_click_conversions	VARCHAR
133	impressions_with_positive_custom_value	VARCHAR
134	begin_to_render_impressions	VARCHAR
135	teracent_fee_advertiser_currency	VARCHAR
136	aggregate_knowledge_fee_advertiser_currency	VARCHAR
137	creative_id	VARCHAR
138	pct_impressions_with_positive_custom_value	VARCHAR
139	media_fee_5_advertiser_currency	VARCHAR
140	third_party_ad_server_fee_partner_currency	VARCHAR
141	position_in_content	VARCHAR
142	estimated_cpm_for_impressions_with_custom_value_advertiser_currency	VARCHAR
143	active_view_impression_distribution_viewable	VARCHAR
144	algorithm	VARCHAR
145	impression_custom_value_cost	VARCHAR
146	active_view_pct_visible_at_completion	VARCHAR
147	invalid_active_view_eligible_impressions	VARCHAR
148	media_fee_1_usd	VARCHAR
149	profit_advertiser_currency	VARCHAR
150	gmail_age	VARCHAR
151	audio_client_cost_ecpcl_advertiser_currency	VARCHAR
152	evidon_fee_partner_currency	VARCHAR
153	detailed_demographics	VARCHAR
154	billable_cost_advertiser_currency	VARCHAR
155	total_media_cost_ecpa_advertiser_currency	VARCHAR
156	partner_status	VARCHAR
157	cpm_fee_1_partner_currency	VARCHAR
158	channel_id	VARCHAR
159	active_view_pct_measurable_impressions	VARCHAR
160	country_id	VARCHAR
161	fullscreens_video	VARCHAR
162	total_media_cost_ecpc_advertiser_currency	VARCHAR
163	city	VARCHAR
164	publisher_property	VARCHAR
165	total_interaction_time	VARCHAR
166	gmail_city	VARCHAR
167	media_cost_ecpc_pc_partner_currency	VARCHAR
168	total_media_cost_ecpa_usd	VARCHAR
169	revenue_ecpv_advertiser_currency	VARCHAR
170	total_video_media_cost_ecpcv_partner_currency	VARCHAR
171	general_invalid_traffic_givt_active_view_measurable_impressions	VARCHAR
172	integral_ad_science_pre_bid_fee_advertiser_currency	VARCHAR
173	media_cost_ecpa_pv_advertiser_currency	VARCHAR
174	active_view_pct_visible_10_seconds	VARCHAR
175	advertiser	VARCHAR
176	public_inventory	VARCHAR
177	profit_partner_currency	VARCHAR
178	video_media_cost_ecpcv_advertiser_currency	VARCHAR
179	adloox_fee_advertiser_currency	VARCHAR
180	invalid_clicks	VARCHAR
181	impressions	VARCHAR
182	vizu_fee_usd	VARCHAR
183	vizu_fee_partner_currency	VARCHAR
184	billable_impressions	VARCHAR
185	teracent_fee_partner_currency	VARCHAR
186	platform_fee_usd	VARCHAR
187	line_item_status	VARCHAR
188	adsafe_fee_partner_currency	VARCHAR
189	cpm_fee_5_partner_currency	VARCHAR
190	companion_creative	VARCHAR
191	audio_unmutes_video	VARCHAR
192	billable_cost_usd	VARCHAR
193	stops_audio	VARCHAR
194	completion_rate_audio	VARCHAR
195	line_item_id	VARCHAR
196	impressions_with_custom_value	VARCHAR
197	post_view_conversions__cross_environment	VARCHAR
198	scrolls	VARCHAR
199	life_events	VARCHAR
200	active_view_pct_play_time_visible	VARCHAR
201	advertiser_integration_code	VARCHAR
202	active_view_audible_and_fully_on_screen_for_half_of_duration_15_sec_cap_rate	VARCHAR
203	data_provider	VARCHAR
204	brand_lift_type	VARCHAR
205	revenue_ecpe_partner_currency	VARCHAR
206	media_cost_ecpa_partner_currency	VARCHAR
207	insertion_order_id	VARCHAR
208	inventory_source_id	VARCHAR
209	advertiser_status	VARCHAR
210	active_view_pct_visible_at_midpoint	VARCHAR
211	total_video_media_cost_ecpcv_advertiser_currency	VARCHAR
212	total_media_cost_viewable_ecpm_usd	VARCHAR
213	active_view_pct_audible_and_visible_at_midpoint	VARCHAR
214	general_invalid_traffic_givt_impressions	VARCHAR
215	starts_audio	VARCHAR
216	audience_list_cost	VARCHAR
217	rewarded	VARCHAR
218	time_of_day	VARCHAR
219	audio_mutes_audio	VARCHAR
220	media_fee_2_usd	VARCHAR
221	active_view_pct_of_third_quartile_impressions_audible_and_visible	VARCHAR
222	gmail_region	VARCHAR
223	cm_post_click_revenue__cross_environment	VARCHAR
224	active_view_pct_audible_impressions	VARCHAR
225	video_media_cost_ecpcv_usd	VARCHAR
226	active_view_audible_and_fully_on_screen_for_half_of_duration_15_sec_cap_impressions	VARCHAR
227	media_cost_ecpm_partner_currency	VARCHAR
228	pauses_audio	VARCHAR
229	partner_id	VARCHAR
230	playback_method	VARCHAR
231	platform_fee_rate	VARCHAR
232	refund_platform_fee_advertiser_currency	VARCHAR
233	aggregate_knowledge_fee_usd	VARCHAR
234	total_media_cost_viewable_ecpm_advertiser_currency	VARCHAR
235	creative_height	VARCHAR
236	doubleverify_pre_bid_fee_partner_currency	VARCHAR
237	moat_video_fee_partner_currency	VARCHAR
238	digital_content_label	VARCHAR
239	general_invalid_traffic_givt_tracked_ads	VARCHAR
240	impression_counting_method	VARCHAR
241	gmail_remarketing_list	VARCHAR
242	insertion_order_integration_code	VARCHAR
243	active_view_custom_metric_viewable_impressions	VARCHAR
244	trueview_invalid_views	VARCHAR
245	post_view_conversions	VARCHAR
246	profit_margin	VARCHAR
247	programmatic_guaranteed_savings_re_invested_due_to_frequency_advertiser_currency	VARCHAR
248	variant_version	VARCHAR
249	billable_cost_partner_currency	VARCHAR
250	video_client_cost_ecpcv_advertiser_currency	VARCHAR
251	active_view_impression_distribution_not_measurable	VARCHAR
252	average_display_time	VARCHAR
253	app_url_id	VARCHAR
254	active_view_pct_of_first_quartile_impressions_visible	VARCHAR
255	pct_impressions_leading_to_conversions	VARCHAR
256	cpm_fee_3_partner_currency	VARCHAR
257	media_cost_ecpa_advertiser_currency	VARCHAR
258	creative_asset	VARCHAR
259	timers	VARCHAR
260	audience_list	VARCHAR
261	creative_integration_code	VARCHAR
262	attributed_userlist_type	VARCHAR
263	active_view_audible_and_fully_on_screen_for_half_of_duration_trueview_impressions	VARCHAR
264	integral_ad_science_video_fee_advertiser_currency	VARCHAR
265	audience_list_type	VARCHAR
266	region_id	VARCHAR
267	data_provider_id	VARCHAR
268	premium_fee_advertiser_currency	VARCHAR
269	device_make	VARCHAR
270	floodlight_activity_id	VARCHAR
271	interactive_impressions	VARCHAR
272	revenue_ecpa_advertiser_currency	VARCHAR
273	cpm_fee_4_advertiser_currency	VARCHAR
274	profit_viewable_ecpm_partner_currency	VARCHAR
275	revenue_ecpa_usd	VARCHAR
276	companion_creative_id	VARCHAR
277	media_cost_ecpa_usd	VARCHAR
278	device	VARCHAR
279	revenue_viewable_ecpm_partner_currency	VARCHAR
280	pauses_video	VARCHAR
281	companion_clicks_audio	VARCHAR
282	media_cost_viewable_ecpm_advertiser_currency	VARCHAR
283	general_invalid_traffic_givt_clicks	VARCHAR
284	revenue_ecpe_advertiser_currency	VARCHAR
285	total_media_cost_ecpa_partner_currency	VARCHAR
286	inventory_source_type	VARCHAR
287	gmail_country	VARCHAR
288	revenue_ecpa_partner_currency	VARCHAR
289	adxpose_fee_advertiser_currency	VARCHAR
290	active_view_audible_and_fully_on_screen_for_half_of_duration_15_sec_cap_measurable_impressions	VARCHAR
291	integral_ad_science_pre_bid_fee_usd	VARCHAR
292	midpoint_audio	VARCHAR
293	amp_page_request	VARCHAR
294	active_view_pct_visible_at_first_quartile	VARCHAR
295	revenue_ecpa_pc_usd	VARCHAR
296	platform_fee_advertiser_currency	VARCHAR
297	video_continuous_play	VARCHAR
298	advertiser_currency	VARCHAR
299	active_view_impressions_audible_and_visible_at_completion	VARCHAR
300	companion_creative_size	VARCHAR
301	active_view_custom_metric_measurable_impressions	VARCHAR
302	comscore_vce_in_doubleclick_fee_advertiser_currency	VARCHAR
303	agency_trading_desk_fee_partner_currency	VARCHAR
304	media_fee_1_partner_currency	VARCHAR
305	active_view_audible_and_fully_on_screen_for_half_of_duration_trueview_rate	VARCHAR
306	first_quartile_views_video	VARCHAR
307	agency_trading_desk_fee_advertiser_currency	VARCHAR
308	media_fee_4_partner_currency	VARCHAR
309	country	VARCHAR
310	tracked_ads	VARCHAR
311	ad_type	VARCHAR
312	active_view_pct_of_completed_impressions_audible_and_visible	VARCHAR
313	client_cost_ecpa_advertiser_currency	VARCHAR
314	custom_fee_2_advertiser_currency	VARCHAR
315	total_media_cost_ecpa_pc_partner_currency	VARCHAR
316	cpm_fee_5_usd	VARCHAR
317	total_media_cost_advertiser_currency	VARCHAR
318	agency_trading_desk_fee_usd	VARCHAR
319	estimated_total_cost_for_impressions_with_custom_value_advertiser_currency	VARCHAR
320	integral_ad_science_video_fee_usd	VARCHAR
321	custom_fee_1_advertiser_currency	VARCHAR
322	doubleverify_pre_bid_fee_advertiser_currency	VARCHAR
323	verification_video_position	VARCHAR
324	attributed_userlist_cost	VARCHAR
325	publisher_property_section	VARCHAR
326	mediacost_data_fee_advertiser_currency	VARCHAR
327	keyword	VARCHAR
328	expansions	VARCHAR
329	campaign_id	VARCHAR
330	shoplocal_fee_partner_currency	VARCHAR
331	isp_or_carrier	VARCHAR
332	gmail_device_type	VARCHAR
333	audio_media_cost_ecpcl_advertiser_currency	VARCHAR
334	midpoint_views_video	VARCHAR
335	media_cost_ecpc_pc_usd	VARCHAR
336	media_fee_1_advertiser_currency	VARCHAR
337	served_pixel_density	VARCHAR
338	total_media_cost_ecpm_usd	VARCHAR
339	click_rate_ctr	VARCHAR
340	campaign	VARCHAR
341	region	VARCHAR
342	active_view_pct_audible_and_visible_at_start	VARCHAR
343	total_media_cost_ecpa_pc_usd	VARCHAR
344	data_management_platform_fee_usd	VARCHAR
345	rich_media_engagements	VARCHAR
346	city_id	VARCHAR
347	active_view_pct_play_time_audible	VARCHAR
348	doubleverify_pre_bid_fee_usd	VARCHAR
349	data_management_platform_fee_partner_currency	VARCHAR
350	adloox_fee_partner_currency	VARCHAR
351	active_view_pct_of_third_quartile_impressions_visible	VARCHAR
352	companion_clicks_video	VARCHAR
353	active_view_audible_and_fully_on_screen_for_half_of_duration_trueview_measurable_impressions	VARCHAR
354	engagement_rate	VARCHAR
355	third_party_ad_server_fee_advertiser_currency	VARCHAR
356	shoplocal_fee_usd	VARCHAR
357	cpm_fee_5_advertiser_currency	VARCHAR
358	active_view_pct_fully_on_screen_2_sec	VARCHAR
359	media_fee_2_advertiser_currency	VARCHAR
360	companion_impressions_audio	VARCHAR
361	exits	VARCHAR
362	begin_to_render_eligible_impressions	VARCHAR
363	billable_outcome	VARCHAR
364	insertion_order	VARCHAR
365	interest	VARCHAR
366	data_fees_partner_currency	VARCHAR
367	app_url_excluded	VARCHAR
368	revenue_ecpa_pc_advertiser_currency	VARCHAR
369	active_view_pct_audible_and_visible_at_completion	VARCHAR
370	day_of_week	VARCHAR
371	complete_listens_audio	VARCHAR
372	active_view_pct_of_completed_impressions_visible	VARCHAR
373	app_url	VARCHAR
374	verification_video_player_size	VARCHAR
375	life_event	VARCHAR
376	platform_fee_partner_currency	VARCHAR
377	active_view_pct_of_first_quartile_impressions_audible_and_visible	VARCHAR
378	media_fee_5_usd	VARCHAR
379	total_conversions__cross_environment	VARCHAR
380	aggregate_knowledge_fee_partner_currency	VARCHAR
381	complete_views_video	VARCHAR
382	insertion_order_status	VARCHAR
383	active_view_pct_of_ad_played	VARCHAR
384	companion_impressions_video	VARCHAR
385	active_view_custom_metric_viewable_rate	VARCHAR
386	integral_ad_science_video_fee_partner_currency	VARCHAR
387	doubleverify_fee_partner_currency	VARCHAR
388	revenue_ecpc_partner_currency	VARCHAR
389	revenue_ecpv_usd	VARCHAR
390	adloox_fee_usd	VARCHAR
391	inventory_source_group	VARCHAR
392	evidon_fee_advertiser_currency	VARCHAR
393	profit_ecpm_usd	VARCHAR
394	completion_rate_video	VARCHAR
395	active_view_impression_distribution_not_viewable	VARCHAR
396	cookie_unconsented_clicks	VARCHAR
397	revenue_ecpm_partner_currency	VARCHAR
398	budget_segment_description	VARCHAR
399	cpm_fee_1_advertiser_currency	VARCHAR
400	cm_post_view_revenue__cross_environment	VARCHAR
401	nielsen_digital_ad_ratings_fee_partner_currency	VARCHAR
402	cpm_fee_3_advertiser_currency	VARCHAR
403	media_cost_ecpc_usd	VARCHAR
404	revenue_ecpv_partner_currency	VARCHAR
405	client_cost_ecpa_pv_advertiser_currency	VARCHAR
406	programmatic_guaranteed_impressions_passed_due_to_frequency	VARCHAR
407	total_media_cost_ecpa_pv_usd	VARCHAR
408	average_interaction_time	VARCHAR
409	revenue_partner_currency	VARCHAR
410	data_fees_usd	VARCHAR
411	moat_video_fee_advertiser_currency	VARCHAR
412	creative	VARCHAR
413	total_display_time	VARCHAR
414	adloox_pre_bid_fee_partner_currency	VARCHAR
415	audience_list_id	VARCHAR
416	cpm_fee_4_usd	VARCHAR
417	gmail_post_view_conversions	VARCHAR
418	trueview_general_invalid_traffic_givt_views	VARCHAR
419	invalid_active_view_measurable_impressions	VARCHAR
420	extension	VARCHAR
421	active_view_custom_metric_id	VARCHAR
422	third_quartile_views_video	VARCHAR
423	media_cost_ecpc_pv_partner_currency	VARCHAR
424	inventory_rate_type	VARCHAR
425	attribution_model	VARCHAR
426	authorized_seller_state	VARCHAR
427	cpm_fee_1_usd	VARCHAR
428	revenue_ecpc_usd	VARCHAR
429	video_media_cost_ecpcv_partner_currency	VARCHAR
430	variant_id	VARCHAR
431	media_cost_ecpm_advertiser_currency	VARCHAR
432	total_impression_custom_value	VARCHAR
433	active_view_custom_metric_name	VARCHAR
434	first_quartile_audio	VARCHAR
435	detailed_demographics_id	VARCHAR
436	creative_source	VARCHAR
437	skips_video	VARCHAR
438	mediacost_data_fee_usd	VARCHAR
439	measurement_source	VARCHAR
440	advertiser_time_zone	VARCHAR
441	revenue_ecpa_pv_partner_currency	VARCHAR
442	audience_type	VARCHAR
443	trustmetrics_fee_usd	VARCHAR
444	custom_fee_5_advertiser_currency	VARCHAR
445	revenue_ecpm_advertiser_currency	VARCHAR
446	creative_status	VARCHAR
447	inventory_commitment_type	VARCHAR
448	moat_video_fee_usd	VARCHAR
449	date	VARCHAR
450	media_cost_partner_currency	VARCHAR
451	active_view_pct_audible_and_visible_at_first_quartile	VARCHAR
452	audio_revenue_ecpcl_advertiser_currency	VARCHAR
453	device_type	VARCHAR
454	active_view_pct_viewable_impressions	VARCHAR
455	active_view_pct_of_midpoint_impressions_visible	VARCHAR
456	adxpose_fee_usd	VARCHAR
457	format	VARCHAR
458	media_cost_advertiser_currency	VARCHAR
459	active_view_pct_play_time_audible_and_visible	VARCHAR
460	adxpose_fee_partner_currency	VARCHAR
461	doubleverify_fee_advertiser_currency	VARCHAR
462	cpm_fee_3_usd	VARCHAR
463	active_view_not_viewable_impressions	VARCHAR
464	profit_usd	VARCHAR
465	media_fee_3_partner_currency	VARCHAR
466	week	VARCHAR
467	active_view_pct_visible_at_start	VARCHAR
468	trustmetrics_fee_partner_currency	VARCHAR
469	shoplocal_fee_advertiser_currency	VARCHAR
470	platform	VARCHAR
471	invalid_begin_to_render_impressions	VARCHAR
472	browser_id	VARCHAR
473	exchange_id	VARCHAR
474	media_cost_viewable_ecpm_usd	VARCHAR
475	mediacost_data_fee_partner_currency	VARCHAR
476	client_cost_ecpm_advertiser_currency	VARCHAR
477	creative_type	VARCHAR
478	vizu_fee_advertiser_currency	VARCHAR
479	refund_reason	VARCHAR
480	pct_clicks_leading_to_conversions	VARCHAR
481	active_view_measurable_impressions	VARCHAR
482	line_item_type	VARCHAR
483	channel_type	VARCHAR
484	active_view_pct_audible_and_visible_at_third_quartile	VARCHAR
485	cpm_fee_2_usd	VARCHAR
486	profit_ecpm_partner_currency	VARCHAR
487	profit_viewable_ecpm_advertiser_currency	VARCHAR
488	nielsen_digital_ad_ratings_fee_advertiser_currency	VARCHAR
489	variant_name	VARCHAR
490	post_click_conversions	VARCHAR
491	data_fees_advertiser_currency	VARCHAR
492	inventory_delivery_method	VARCHAR
493	starts_video	VARCHAR
494	youtube_view_rate	VARCHAR
495	total_media_cost_ecpm_partner_currency	VARCHAR
496	category	VARCHAR
497	isp_or_carrier_id	VARCHAR
498	audio_mutes_video	VARCHAR
499	revenue_viewable_ecpm_usd	VARCHAR
500	active_view_eligible_impressions	VARCHAR

Table: audience_composition

No	Column Name	Type	Notes
1	date	VARCHAR
2	third_party_audience_list_type	VARCHAR
3	audience_list	VARCHAR
4	potential_impressions	VARCHAR
5	first_party_audience_list	VARCHAR
6	first_party_audience_list_id	VARCHAR
7	first_party_audience_list_type	VARCHAR
8	eligible_cookies_on_third_party_audience_list_and_interest	VARCHAR
9	third_party_audience_list_cost	VARCHAR
10	third_party_audience_list_id	VARCHAR
11	third_party_audience_list	VARCHAR
12	match_ratio	VARCHAR
13	unique_cookies_with_impressions	VARCHAR
14	eligible_cookies_on_first_party_audience_list	VARCHAR
15	first_party_audience_list_cost	VARCHAR

Table: unique_reach_audience

No	Column Name	Type	Notes
1	date	VARCHAR
2	country	VARCHAR
3	pct_viewable_population_reach	VARCHAR
4	line_item_id	VARCHAR
5	unique_reach_average_impression_frequency	VARCHAR
6	gender	VARCHAR
7	device_type	VARCHAR
8	creative_size	VARCHAR
9	creative_id	VARCHAR
10	advertiser_id	VARCHAR
11	line_item	VARCHAR
12	partner_id	VARCHAR
13	pct_viewable_composition_impressions	VARCHAR
14	pct_composition_impressions	VARCHAR
15	unique_reach_click_reach	VARCHAR
16	insertion_order	VARCHAR
17	line_item_integration_code	VARCHAR
18	creative_type	VARCHAR
19	pct_population_reach	VARCHAR
20	creative_width	VARCHAR
21	viewable_impressions	VARCHAR
22	line_item_type	VARCHAR
23	creative_height	VARCHAR
24	campaign_id	VARCHAR
25	unique_reach_impression_reach	VARCHAR
26	advertiser	VARCHAR
27	pct_composition_reach	VARCHAR
28	insertion_order_id	VARCHAR
29	unique_reach_viewable_impression_reach	VARCHAR
30	target_rating_points	VARCHAR
31	creative_source	VARCHAR
32	impressions	VARCHAR
33	creative	VARCHAR
34	population	VARCHAR
35	insertion_order_status	VARCHAR
36	insertion_order_integration_code	VARCHAR
37	partner	VARCHAR
38	month	VARCHAR
39	pct_viewable_composition_reach	VARCHAR
40	line_item_status	VARCHAR
41	campaign	VARCHAR
42	clicks	VARCHAR
43	creative_status	VARCHAR
44	age	VARCHAR
45	viewable_target_rating_points	VARCHAR

Table: reach

No	Column Name	Type	Notes
1	date	VARCHAR	Incremental sync key
2	country	VARCHAR
3	line_item_id	VARCHAR
4	unique_reach_average_impression_frequency	VARCHAR
5	cm_placement_id	VARCHAR
6	unique_reach_total_reach	VARCHAR
7	creative_id	VARCHAR
8	advertiser_id	VARCHAR
9	line_item	VARCHAR
10	partner_id	VARCHAR
11	unique_reach_click_reach	VARCHAR
12	insertion_order	VARCHAR
13	app_url_excluded	VARCHAR
14	line_item_integration_code	VARCHAR
15	targeted_data_providers	VARCHAR
16	advertiser_integration_code	VARCHAR
17	cookie_reach_average_impression_frequency	VARCHAR
18	campaign_id	VARCHAR
19	unique_reach_impression_reach	VARCHAR
20	advertiser	VARCHAR
21	inventory_source	VARCHAR
22	app_url	VARCHAR
23	cookie_reach_impression_reach	VARCHAR
24	insertion_order_id	VARCHAR
25	creative_integration_code	VARCHAR
26	advertiser_status	VARCHAR
27	creative_source	VARCHAR
28	creative	VARCHAR
29	insertion_order_status	VARCHAR
30	insertion_order_integration_code	VARCHAR
31	partner	VARCHAR
32	partner_status	VARCHAR
33	line_item_status	VARCHAR
34	campaign	VARCHAR
35	creative_status	VARCHAR
36	country_id	VARCHAR

Table: floodlight

No	Column Name	Type	Notes
1	date	VARCHAR
2	line_item_id	VARCHAR
3	year	VARCHAR
4	cm_placement_id	VARCHAR
5	cookie_unconsented_floodlight_impressions	VARCHAR
6	creative_size	VARCHAR
7	creative_id	VARCHAR
8	app_url_id	VARCHAR
9	line_item	VARCHAR
10	line_item_integration_code	VARCHAR
11	advertiser_integration_code	VARCHAR
12	creative_width	VARCHAR
13	creative_asset	VARCHAR
14	total_conversions	VARCHAR
15	campaign_id	VARCHAR
16	partner_currency	VARCHAR
17	floodlight_activity	VARCHAR
18	creative_integration_code	VARCHAR
19	advertiser_status	VARCHAR
20	creative	VARCHAR
21	cookie_consented_floodlight_impressions	VARCHAR
22	floodlight_activity_id	VARCHAR
23	month	VARCHAR
24	partner_status	VARCHAR
25	cm_post_view_revenue	VARCHAR
26	campaign	VARCHAR
27	exchange	VARCHAR
28	order_id	VARCHAR
29	creative_rendered_in_amp	VARCHAR
30	floodlight_impressions	VARCHAR
31	advertiser_id	VARCHAR
32	exchange_id	VARCHAR
33	partner_id	VARCHAR
34	insertion_order	VARCHAR
35	app_url_excluded	VARCHAR
36	creative_type	VARCHAR
37	targeted_data_providers	VARCHAR
38	exchange_code	VARCHAR
39	line_item_type	VARCHAR
40	creative_height	VARCHAR
41	day_of_week	VARCHAR
42	advertiser	VARCHAR
43	duplicate_floodlight_impressions	VARCHAR
44	app_url	VARCHAR
45	advertiser_currency	VARCHAR
46	creative_attributes	VARCHAR
47	creative_source	VARCHAR
48	post_click_conversions	VARCHAR
49	insertion_order_status	VARCHAR
50	advertiser_time_zone	VARCHAR
51	insertion_order_integration_code	VARCHAR
52	partner	VARCHAR
53	line_item_status	VARCHAR
54	cm_post_click_revenue	VARCHAR
55	post_view_conversions	VARCHAR
56	category	VARCHAR
57	creative_status	VARCHAR

External Resources

• Link
• Page
• Queries Documentation
• Setup Tool
• Getting Started Guide
• Using Oauth 2.0 To Access Google Apis
• Display & Video 360 Docs

Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.