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
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 |
Last updated