> For the complete documentation index, see [llms.txt](https://daton-sarasanalytics.gitbook.io/daton/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/advertising/stackadapt/schema-information.md).

# Schema Information

## Tables/APIs 

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

* [Campaigns](#campaigns)
* [Campaign Stats](#campaign-stats)
* [Conversion Tracker](#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](https://docs.stackadapt.com/v2#!/Campaign/findCampaigns).

{% hint style="info" %}
Fields whose data type is RECORD cannot be set as the primary key. 
{% endhint %}

**Fields**

<table><thead><tr><th width="286">Field Name</th><th width="255">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>line_item_id</td><td>NUMERIC</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>bid_type</td><td>STRING</td></tr><tr><td>bid_amount_total</td><td>NUMERIC</td></tr><tr><td>pace_evenly</td><td>BOOLEAN</td></tr><tr><td>state</td><td>STRING</td></tr><tr><td>created_at</td><td>TIMESTAMP</td></tr><tr><td>updated_at</td><td>TIMESTAMP</td></tr><tr><td>category_options</td><td>STRING</td></tr><tr><td>device_type_options</td><td>STRING</td></tr><tr><td>supply_type_options</td><td>STRING</td></tr><tr><td>supply_source_options</td><td>STRING</td></tr><tr><td>freq_cap_time</td><td>NUMERIC</td></tr><tr><td>language_options</td><td>STRING</td></tr><tr><td>weekday_enabled</td><td>BOOLEAN</td></tr><tr><td>use_dma</td><td>BOOLEAN</td></tr><tr><td>engagement_tracking_type</td><td>NUMERIC</td></tr><tr><td>city_options</td><td>STRING</td></tr><tr><td>timezone</td><td>STRING</td></tr><tr><td>is_deal_id_strict</td><td>BOOLEAN</td></tr><tr><td>advertiser_id</td><td>NUMERIC</td></tr><tr><td>start_date</td><td>DATE</td></tr><tr><td>status</td><td>RECORD</td></tr><tr><td>end_date</td><td>DATE</td></tr><tr><td>channel</td><td>STRING</td></tr><tr><td>campaign_type</td><td>STRING</td></tr><tr><td>budget</td><td>NUMERIC</td></tr><tr><td>day_part</td><td>RECORD</td></tr><tr><td>domain_action</td><td>STRING</td></tr><tr><td>domain_options</td><td>STRING</td></tr><tr><td>custom_segments_list</td><td>STRING</td></tr><tr><td>custom_segments_ids</td><td>STRING</td></tr><tr><td>demo_and_interests_ids</td><td>STRING</td></tr><tr><td>demo_and_interests_list</td><td>STRING</td></tr><tr><td>negative_rt_audiences</td><td>STRING</td></tr><tr><td>deal_group_ids</td><td>STRING</td></tr><tr><td>all_native_ads</td><td>RECORD</td></tr><tr><td>conversion_trackers</td><td>RECORD</td></tr><tr><td>optimize_type</td><td>STRING</td></tr><tr><td>optimize_value</td><td>NUMERIC</td></tr><tr><td>us_state_options</td><td>STRING</td></tr><tr><td>positive_rt_audiences</td><td>STRING</td></tr><tr><td>ip_options</td><td>STRING</td></tr></tbody></table>

#### Campaign Stats&#x20;

Used to query for insight, delivery, and buyer account status. For more information, see [Stats](https://docs.stackadapt.com/v2#!/Stats/getInsightStats).

{% hint style="info" %}
Fields whose data type is RECORD cannot be set as the primary key.&#x20;
{% endhint %}

**Fields**

<table><thead><tr><th width="286">Field Name</th><th width="255">Data Type</th></tr></thead><tbody><tr><td>total_stats</td><td>RECORD</td></tr><tr><td>daily_stats</td><td>RECORD</td></tr></tbody></table>

#### Conversion Tracker&#x20;

Get the list of all conversion trackers and a specific conversion tracker that the user can access. For more information, see [Conversion Trackers](https://docs.stackadapt.com/v2#!/Conversion_Tracker/findConversionTrackers).

{% hint style="info" %}
Fields whose data type is RECORD cannot be set as the primary key.&#x20;
{% endhint %}

**Fields**

<table><thead><tr><th width="286">Field Name</th><th width="255">Data Type</th></tr></thead><tbody><tr><td>total_stats</td><td>RECORD</td></tr><tr><td>daily_stats</td><td>RECORD</td></tr></tbody></table>