Schema Information

This subtopic provides a structured reference to assist you in working with Daton's StackAdapt connector and the associated fields and tables.

Tables/APIs

The following is the list of tables or APIs associated with the StackAdapt connector:

• Campaigns

• Campaign Stats

• Conversion Tracker

Campaigns

Get the list of all campaigns and campaign groups that you have access to, as well as specific campaigns or campaign groups with the corresponding ID from the system that you can access. For more information, see Campaigns.

Fields whose data type is RECORD cannot be set as the primary key.

Fields

Field Name	Data Type
id	NUMERIC
line_item_id	NUMERIC
name	STRING
bid_type	STRING
bid_amount_total	NUMERIC
pace_evenly	BOOLEAN
state	STRING
created_at	TIMESTAMP
updated_at	TIMESTAMP
category_options	STRING
device_type_options	STRING
supply_type_options	STRING
supply_source_options	STRING
freq_cap_time	NUMERIC
language_options	STRING
weekday_enabled	BOOLEAN
use_dma	BOOLEAN
engagement_tracking_type	NUMERIC
city_options	STRING
timezone	STRING
is_deal_id_strict	BOOLEAN
advertiser_id	NUMERIC
start_date	DATE
status	RECORD
end_date	DATE
channel	STRING
campaign_type	STRING
budget	NUMERIC
day_part	RECORD
domain_action	STRING
domain_options	STRING
custom_segments_list	STRING
custom_segments_ids	STRING
demo_and_interests_ids	STRING
demo_and_interests_list	STRING
negative_rt_audiences	STRING
deal_group_ids	STRING
all_native_ads	RECORD
conversion_trackers	RECORD
optimize_type	STRING
optimize_value	NUMERIC
us_state_options	STRING
positive_rt_audiences	STRING
ip_options	STRING

Campaign Stats

Used to query for insight, delivery, and buyer account status. For more information, see Stats.

Fields whose data type is RECORD cannot be set as the primary key.

Fields

Field Name	Data Type
total_stats	RECORD
daily_stats	RECORD

Conversion Tracker

Get the list of all conversion trackers and a specific conversion tracker that the user can access. For more information, see Conversion Trackers.

Fields whose data type is RECORD cannot be set as the primary key.

Fields

Field Name	Data Type
total_stats	RECORD
daily_stats	RECORD