# 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>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/advertising/stackadapt/schema-information.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.