# Twitter Ads (X) (v1)
Information note **Twitter Ads is in closed beta**
Twitter Ads is currently in closed beta. Contact support to inquire if testers for this integration are needed.
Information note **Twitter Ads extraction is supported by Stitch**
This integration is powered by [Singer's](https://www.singer.io/) twitter-ads tap and certified by Stitch. [Check out and contribute to the repo on GitHub](https://github.com/singer-io/tap-twitter-ads).
For support, contact [Support](https://community.qlik.com/t5/Support/ct-p/qlikSupport).
## Twitter Ads integration summary
Stitch’s Twitter Ads integration:
* Replicates core object data using the [Twitter Ads API v.10](https://developer.twitter.com/en/docs/ads/general/overview). Refer to the [Schema](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#schema) section for a list of objects available for replication.
* Supports configuring custom reports using Twitter’s [Analytics API](https://developer.twitter.com/en/docs/ads/analytics/overview)
## Twitter Ads feature snapshot
A high-level look at Stitch's Twitter Ads (v1) integration, including release status, useful links, and the features supported in Stitch.
| **STITCH** | | | |
| --- | --- | --- | --- |
| **[Release status](https://help.qlik.com/en-US/stitch/integrations/identify-an-integration-version)** | | **Supported by**
the Info icon
Indicates if the integration is supported by Stitch or the Singer community. | [Stitch](https://community.qlik.com/t5/Support/ct-p/qlikSupport) |
| **Stitch plan**
the Info icon
The type of Stitch plan required to use the integration. | Standard | **[API availability](https://help.qlik.com/en-US/stitch/developers/stitch-connect/guides/source-destination-reference)**
the Info icon
Indicates if the integration is available as a source in Stitch Connect. | the Success icon
This version of the integration is available via the API.
Indicates if Replication Methods can be defined by you for tables in the integration. | the Remove icon
Configurable Replication Methods are not supported for this integration. Stitch will use pre-defined replication methods for tables you set to replicate.
The ability to select individual tables for replication in the Stitch interface. If table selection is unavailable, all tables and all the columns they contain will be set to replicate by default. | the Success icon
This feature is supported for this version of the integration.
Supported | **Column selection**
the Info icon
The ability to select individual columns for replication in the Stitch interface. If column selection is unavailable, all columns will be set to replicate by default. | the Success icon
This feature is supported for this version of the integration.
Supported |
| **Select all**
the Info icon
Indicates if the integration supports selecting all available tables and columns. | the Success icon
Reports detailing the Loading phase of the replication process for a given integration. Includes the number of rows loaded for each table and error info, should an error occur. | the Success icon
This feature is supported for this version of the integration.
Supported |
## Connecting Twitter Ads
### Twitter Ads setup requirements
To set up Twitter Ads in Stitch, you need:
* **To have access to the Twitter Ads accounts you want to replicate data from.**
### Step 1: Retrieve account ID
1. Login to your Twitter Ads account.
2. Select the ads account that you’d like to use.
3. Click your account icon upper right corner of the screen.
4. Click **Settings** in the dropdown menu.
5. Copy your account ID and keep it readily available for the next step.
**Note**: If you would like to add multiple ads accounts for this integration, repeat the above steps for each account.
### Step 2: Add Twitter Ads as a Stitch data source
1. [Sign into your Stitch account](https://app.stitchdata.com/).
2. On the Stitch Dashboard page, click the **Add Integration** button.
3. Click the **Twitter Ads** icon.
4. Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.
For example, the name “Stitch Twitter Ads” would create a schema called `stitch_twitter_ads` in the destination. **Note**: Schema names cannot be changed after you save the integration.
5. In the **Account IDs** field, paste the account ID you copied from [Step 1](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#retrieve-account-id). If you’re adding multiple accounts IDs, format them as a comma-delimited list. For example: `accountId1, accountId2`
6. **Optional**: In the **Attribution Window** field, enter the number of days you want to use as a lookback period for [conversion reporting](https://business.twitter.com/en/help/campaign-measurement-and-analytics/conversion-tracking-for-websites.html) to stabilize. Custom report tables use this value during Extraction.
7. **Optional**: Check the **with deleted** box if you want to include deleted records in the extraction Stitch performs.
8. In the **Country Codes** field, enter a comma-separated list of the [ISO alpha-2 country codes](https://www.iban.com/country-codes) for each country you want to include in segmentation and targeting.
For example: A list of `US, DE, IE` corresponds to `United States, Germany, Ireland`.
**Note**: This field is required to use some [segment types in custom reports](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#custom-report-configuration-options--segments).
### Step 3: Configure reports
Information note **Note**: This step is optional. If you don’t want to configure any reports, click the **- Remove this report** link.
Stitch’s Twitter Ads integration supports the configuration of custom reports. For each report configured in the **Your Reports** section, a table will display in the **Tables to Replicate** tab as available for selection.
Refer to the [Table reference](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#example-custom-report) for an example of a custom report table.
* [Create a new report](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#configure-reports--new-report)
* [Remove a report](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#configure-reports--remove-report)
#### Create a new report
Information note **Important**: Twitter Ads enforces compatibility rules, which can affect the data available for extraction. When setting up custom reports, we recommend referring to the [Custom report options compatibility reference](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#custom-report-configuration-options) to ensure you get the data you want.
To add a report, click the **+ Configure new report** link. For each report you configure, you’ll define the following parameters:
* **Report Name**: A name for the report, which is used to create the name of its corresponding destination table
* **Entity**: The Twitter Ads entity (object) to report on. The entity you select determines the metrics (columns) available for selection and the segments you can apply to those metrics. Refer to the [Custom report options compatibility reference](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#custom-report-configuration-options) for more info.
* **Segment**: A segment to apply to the entity’s available metrics. **Note**: Some entity and segment combinations may be incompatible. Refer to the [Segment compatibility reference](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#custom-report-configuration-options--segments) for more info.
* **Granularity**: The granularity of the report data. Possible options are `DAY`, `HOUR`, and `TOTAL`.
#### Remove a report
To remove a report, click the **- Remove this report** link.
**Note**: Removing a report will not remove the corresponding table or its data from your destination.
### Step 4: Define the historical replication start date
The Sync Historical Data setting defines the starting date for your Twitter Ads integration. This means that data **equal to or newer than this date** will be replicated to your data warehouse.
Change this setting if you want to replicate data beyond Twitter Ads’s default setting of **1 year**. For a detailed look at historical replication jobs, check out the [Syncing Historical SaaS Data](https://help.qlik.com/en-US/stitch/replication/syncing-historical-saas-data-resetting-replication-keys) guide.
### Step 5: Create a replication schedule
Information note Replication schedules affect the time Extraction begins, not the time to data loaded. Refer to the [Replication Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling) documentation for more information.
In the **Replication Frequency** section, you’ll create the integration’s [replication schedule](https://help.qlik.com/en-US/stitch/replication/replication-scheduling). An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.
Twitter Ads integrations support the following replication scheduling methods:
* [Replication Frequency](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/replication-frequency)
* [Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/anchor-scheduling)
* [Advanced Scheduling using Cron](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/advanced-scheduling) (Advanced or Premium plans only)
To keep your row usage low, consider setting the integration to replicate less frequently. See the [Understanding and Reducing Your Row Usage guide](https://help.qlik.com/en-US/stitch/getting-started/understanding-stitch-usage) for tips on reducing your usage.
### Step 6: Set objects to replicate
Information note **Is an object missing or not replicating?** Verify that the object meets the requirements for [selection](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#selection-requirements) and [replication](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#replication-requirements).
The last step is to select the tables and columns you want to replicate. [Learn about the available tables for this integration.](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#schema)
**Note**: If a replication job is currently in progress, new selections won’t be used until the next job starts.
* Selection options
* Individual tables and columns
* All tables and columns
For Twitter Ads integrations, you can select:
1. **Individual tables and columns**
2. **All tables and columns**
Click the tabs to view instructions for each selection method.
1. In the integration’s **Tables to Replicate tab**, locate a table you want to replicate.
2. To track a table, click the **checkbox** next to the table’s name. A blue checkmark means the table is set to replicate.
3. To track a column, click the **checkbox** next to the column’s name. A blue checkmark means the column is set to replicate.
4. Repeat this process for all the tables and columns you want to replicate.
5. When finished, click the **Finalize Your Selections** button at the bottom of the screen to save your selections.
Information note **Important**: Using the **Select All** feature will overwrite any previous selections. However, selections aren’t final until **Finalize Your Selections** is clicked. Clicking **Cancel** will restore your previous selections. Refer to the [Select All guide](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#set-all-data-to-replicate) for more info about this feature.
1. Click into the integration from the Stitch Dashboard page.
2. Click the **Tables to Replicate** tab.
3. In the list of tables, click the box next to the **Table Names** column.
4. In the menu that displays, click **Track all Tables and Fields**:
The Track all Tables and Fields menu in the Tables to Replicate tabThe Track all Tables and Fields menu in the Tables to Replicate tab
5. Click the **Finalize Your Selections** button at the bottom of the page to save your data selections.
### Initial and historical replication jobs
After you finish setting up Twitter Ads, its **Sync Status** may show as **Pending** on either the Stitch Dashboard or in the Integration Details page.
For a new integration, a **Pending** status indicates that Stitch is in the process of scheduling the initial replication job for the integration. **This may take some time to complete.**
Information note
**Initial replication jobs with Anchor Scheduling**
If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the [Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling#job-scheduling-and-anchor-times) documentation for more information.
#### Free historical data loads
The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.
Information note **Replication will continue after the seven days are over**. If you’re no longer interested in this source, be sure to **pause** or **delete** the integration to prevent unwanted usage.
## Twitter Ads replication
In this section:
* [Extraction](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#extraction-details)
* [Loading](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#loading-details)
### Extraction
This section provides a high-level look at extraction, but you can check out the [sync review on Google Docs](https://docs.google.com/document/d/1MrXWHGyOsCv-xI7ecuUWG0VIAy8ko5fwKn-I91p-PSc/edit) for a more technical look at this process.
For every table set to replicate, Stitch will perform the following during Extraction:
* [Discover available tables and columns](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#extraction--discovery)
* [Extract records from selected tables and columns](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#extraction--data-replication)
#### Discovery
During Discovery, Stitch will:
* [Determine table availability](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#discovery--objects)
* [Determine column availability](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#discovery--columns)
##### Determining table availability
At the start of each replication job, Stitch performs a structure sync. During this phase, Stitch detects the objects available for replication.
There are two types of tables for Twitter Ads:
* **Core object tables**: These are tables that aren’t created using the **Custom reports** feature in the integration’s settings page. Table availability depends on the Twitter Ads Singer tap, which powers Stitch’s integration. The tap contains a [JSON schema](https://github.com/singer-io/tap-twitter-ads/tree/master/tap_twitter_ads/schemas) for each available table.
The [Table reference section](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#schema) of this guide lists the tables currently available for replication, as well as info about how they replicate.
* **Custom report tables**: These are tables that are created using the **Custom reports** feature in the integration’s settings page. Table availability depends on configuration of the report in the integration’s settings page. **Note**: Custom report tables must also be set to replicate in the **Tables to Replicate** tab - Stitch won’t automatically replicate them.
Refer to the [Table reference](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#example-custom-report) for an example of a custom report table.
##### Determining column availability
Column availability is dependent upon the type of table:
* **Core Object tables**: Column availability is determined by the [JSON schema](https://github.com/singer-io/tap-twitter-ads/tree/master/tap_twitter_ads/schemas) backing the table in the Singer tap.
* **Custom report tables**: Column availability is determined by the **Entity** selected during report configuration. Each entity in Twitter Ads is compatible with one or more metric groups. Each metric in a metric group corresponds to a column available for replication.
For example: If the entity is compatible with the [BILLING metric group](https://developer.twitter.com/en/docs/ads/analytics/overview/metrics-and-segmentation#BILLING), you’d see `billed_engagements` and `billed_charge_local_micro` columns available for replication.
Refer to the [Entity and metric group compatibility reference](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#custom-report-configuration-options--compatibility) for more info.
#### Data replication
After discovery is completed, Stitch will move onto extracting data for the tables and columns you set to replicate.
How Stitch extracts data depends on the type of table being replicated:
* **Core object tables**: For these tables, extraction depends on the type of Replication Method the table uses. Refer to the [Table reference](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#schema) for the Replication Method each table uses.
* **Custom report tables:** Custom report tables replicate using Key-based Incremental Replication and the [Attribution Window](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#add-stitch-data-source) you define during setup. Attribution Windows are used in conjunction with Replication Keys to determine where Stitch should begin extraction for a table during each extraction job.
### Loading
How data replicated from an Twitter Ads integration is loaded into your destination depends on two factors:
1. **The type of table being loaded**:
* **Core object tables** are loaded using [Upsert loading behavior](https://help.qlik.com/en-US/stitch/replication/loading/understanding-loading-behavior#loading-behavior-types--upsert).
* **Custom report tables** are loaded using [Append-Only loading behavior](https://help.qlik.com/en-US/stitch/replication/loading/understanding-loading-behavior#loading-behavior-types--append-only).
2. **If your destination supports upserts, or updating existing rows**. For destinations that support upserts, Stitch uses Primary Keys to de-dupe data during loading. Primary Keys are used to identify unique rows within a table and ensure that only the most recently updated version of that record appears in your destination.
**Note**: For Append-Only destinations, data will be loaded in an Append-Only manner, regardless of the table type.
## Twitter Ads table reference
Information note
**Schemas and versioning**
Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.
The schema and info displayed below is for **version 1** of this integration.
This is the latest version of the Twitter Ads integration.
Information note
**Table and column names in your destination**
Depending on your destination, table and column names may not appear as they are outlined below.
For example: Object names are lowercased in Redshift (`CusTomERs` > `customers`), while case is maintained in PostgreSQL destinations (`CusTomERs` > `CusTomERs`). Refer to the [Loading Guide](https://help.qlik.com/en-US/stitch/replication/loading/destination-guides) for your destination for more info.
### account\_media
The `account_media` table contains info about the account media associated with an account.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | updated\_at |
| **Useful links** | [account_media schema on GitHub](https://github.com/singer-io/tap-twitter-ads/blob/master/tap_twitter_ads/schemas/account_media.json "Opens in new tab: account_media schema on GitHub")
[Twitter Ads API method](https://developer.twitter.com/en/docs/ads/creatives/api-reference/account-media#account-media "Opens in new tab: Twitter Ads API method") |
account\_media table foreign keys
| Join account\_media with | on |
| --- | --- |
| [accounts](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#accounts) | ``` account_media.account_id = accounts.id ``` |
| [campaigns](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#campaigns) | ``` account_media.account_id = campaigns.account_id ```
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
| **servable**
DATE-TIME |
### accounts
The `accounts` table contains info about the advertising-enabled accounts the user authenticating the integration has access to.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | updated\_at |
| **Useful links** | [accounts schema on GitHub](https://github.com/singer-io/tap-twitter-ads/blob/master/tap_twitter_ads/schemas/accounts.json "Opens in new tab: accounts schema on GitHub")
DATE-TIME |
### advertiser\_business\_categories
The `advertiser_business_categories` table contains info about the advertiser business categories associated with an advertiser’s ad groups.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Key ** | id |
| **Useful links** | [advertiser_business_categories schema on GitHub](https://github.com/singer-io/tap-twitter-ads/blob/master/tap_twitter_ads/schemas/advertiser_business_categories.json "Opens in new tab: advertiser_business_categories schema on GitHub")
[Twitter Ads API method](https://developer.twitter.com/en/docs/ads/campaign-management/api-reference/advertiser-business-categories#advertiser-business-categories "Opens in new tab: Twitter Ads API method") |
advertiser\_business\_categories table foreign keys
| Join advertiser\_business\_categories with | on |
| --- | --- |
| [content_categories](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#content-categories) | ``` advertiser_business_categories.iab_categories = content_categories.iab_categories ``` |
| [iab_categories](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#iab-categories) | ``` advertiser_business_categories.iab_categories = iab_categories.id ``` |
advertiser\_business\_categories table schema
| **iab\_categories**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
| --- |
| **id**
STRING |
| **name**
STRING |
### campaigns
The `campaigns` table contains info about the campaigns associated with an account.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | updated\_at |
| **Useful links** | [campaigns schema on GitHub](https://github.com/singer-io/tap-twitter-ads/blob/master/tap_twitter_ads/schemas/campaigns.json "Opens in new tab: campaigns schema on GitHub")
[Twitter Ads API method](https://developer.twitter.com/en/docs/ads/campaign-management/api-reference/campaigns#campaigns "Opens in new tab: Twitter Ads API method") |
campaigns table foreign keys
| Join campaigns with | on |
| --- | --- |
| [account_media](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#account-media) | ``` campaigns.account_id = account_media.account_id ```
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
| **servable**
DATE-TIME |
### cards
The `cards` table contains info about cards associated with your account.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | updated\_at |
| **Useful links** | [cards schema on GitHub](https://github.com/singer-io/tap-twitter-ads/blob/master/tap_twitter_ads/schemas/cards.json "Opens in new tab: cards schema on GitHub")
[Twitter Ads documentation](https://developer.twitter.com/en/docs/twitter-ads-api/creatives/api-reference/cards "Opens in new tab: Twitter Ads documentation") |
cards table schema
| **card\_type**
STRING |
| --- |
| **card\_uri**
STRING |
| **components**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
| **created\_at**
DATE-TIME |
| **deleted**
BOOLEAN |
| **id**
STRING |
| **name**
STRING |
| **updated\_at**
DATE-TIME |
### cards\_image\_conversation
The `cards_image_conversation` table contains info about image conversation cards associated with an account.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | updated\_at |
| **Useful links** | [cards_image_conversation schema on GitHub](https://github.com/singer-io/tap-twitter-ads/blob/master/tap_twitter_ads/schemas/cards_image_conversation.json "Opens in new tab: cards_image_conversation schema on GitHub")
INTEGER |
### cards\_video\_conversation
The `cards_video_conversation` table contains info about the video conversation cards associated with an account.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | updated\_at |
| **Useful links** | [cards_video_conversation schema on GitHub](https://github.com/singer-io/tap-twitter-ads/blob/master/tap_twitter_ads/schemas/cards_video_conversation.json "Opens in new tab: cards_video_conversation schema on GitHub")
INTEGER |
### content\_categories
The `content_categories` table contains info about the content categories used as targeting criteria for ad groups.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Key ** | id |
| **Useful links** | [content_categories schema on GitHub](https://github.com/singer-io/tap-twitter-ads/blob/master/tap_twitter_ads/schemas/content_categories.json "Opens in new tab: content_categories schema on GitHub")
[Twitter Ads API method](https://developer.twitter.com/en/docs/ads/campaign-management/api-reference/content-categories#content-categories "Opens in new tab: Twitter Ads API method") |
content\_categories table foreign keys
| Join content\_categories with | on |
| --- | --- |
| [advertiser_business_categories](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#advertiser-business-categories) | ``` content_categories.iab_categories = advertiser_business_categories.iab_categories ``` |
| [iab_categories](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#iab-categories) | ``` content_categories.iab_categories = iab_categories.id ``` |
content\_categories table schema
| **iab\_categories**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
| --- |
| **id**
STRING |
| **name**
STRING |
### funding\_instruments
The `funding_instruments` table contains info about the funding instruments associated with an account.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | updated\_at |
| **Useful links** | [funding_instruments schema on GitHub](https://github.com/singer-io/tap-twitter-ads/blob/master/tap_twitter_ads/schemas/funding_instruments.json "Opens in new tab: funding_instruments schema on GitHub")
[Twitter Ads API method](https://developer.twitter.com/en/docs/ads/campaign-management/api-reference/funding-instruments#funding-instruments "Opens in new tab: Twitter Ads API method") |
funding\_instruments table foreign keys
| Join funding\_instruments with | on |
| --- | --- |
| [account_media](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#account-media) | ``` funding_instruments.account_id = account_media.account_id ```
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
| **start\_time**
DATE-TIME |
| **type**
STRING |
| **updated\_at**
DATE-TIME |
### iab\_categories
The `iab_categories` table contains info about the app categories associated with ad groups.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Key ** | id |
| **Useful links** | [iab_categories schema on GitHub](https://github.com/singer-io/tap-twitter-ads/blob/master/tap_twitter_ads/schemas/iab_categories.json "Opens in new tab: iab_categories schema on GitHub")
[Twitter Ads API method](https://developer.twitter.com/en/docs/ads/campaign-management/api-reference/iab-categories#iab-categories "Opens in new tab: Twitter Ads API method") |
iab\_categories table foreign keys
| Join iab\_categories with | on |
| --- | --- |
| [advertiser_business_categories](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#advertiser-business-categories) | ``` iab_categories.id = advertiser_business_categories.iab_categories ``` |
| [content_categories](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#content-categories) | ``` iab_categories.id = content_categories.iab_categories ``` |
iab\_categories table schema
| **id**
STRING |
| --- |
| **name**
STRING |
| **parent\_id**
STRING |
### line\_item\_apps
The `line_item_apps` table contains info about the apps associated with line items associated with an account.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | updated\_at |
| **Useful links** | [line_item_apps schema on GitHub](https://github.com/singer-io/tap-twitter-ads/blob/master/tap_twitter_ads/schemas/line_item_apps.json "Opens in new tab: line_item_apps schema on GitHub")
DATE-TIME |
### line\_items
The `line_items` table contains info about the line items (ad groups) associated with an account.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | updated\_at |
| **Useful links** | [line_items schema on GitHub](https://github.com/singer-io/tap-twitter-ads/blob/master/tap_twitter_ads/schemas/line_items.json "Opens in new tab: line_items schema on GitHub")
[Twitter Ads API method](https://developer.twitter.com/en/docs/ads/campaign-management/api-reference/line-items#line-items "Opens in new tab: Twitter Ads API method") |
line\_items table foreign keys
| Join line\_items with | on |
| --- | --- |
| [account_media](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#account-media) | ``` line_items.account_id = account_media.account_id ``` |
| [accounts](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#accounts) | ``` line_items.account_id = accounts.id ``` |
| [campaigns](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#campaigns) | ``` line_items.account_id = campaigns.account_id ```
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
| **charge\_by**
STRING |
| **created\_at**
DATE-TIME |
| **creative\_source**
STRING |
| **currency**
STRING |
| **deleted**
BOOLEAN |
| **end\_time**
DATE-TIME |
| **entity\_status**
STRING |
| **id**
STRING |
| **name**
STRING |
| **objective**
STRING |
| **optimization**
STRING |
| **placements**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
| **primary\_web\_event\_tag**
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
| **updated\_at**
DATE-TIME |
### media\_creatives
The `media_creatives` table contains info about the media creatives associated with an account.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | updated\_at |
| **Useful links** | [media_creatives schema on GitHub](https://github.com/singer-io/tap-twitter-ads/blob/master/tap_twitter_ads/schemas/media_creatives.json "Opens in new tab: media_creatives schema on GitHub")
[Twitter Ads API method](https://developer.twitter.com/en/docs/ads/campaign-management/api-reference/media-creatives#media-creatives "Opens in new tab: Twitter Ads API method") |
media\_creatives table foreign keys
| Join media\_creatives with | on |
| --- | --- |
| [account_media](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#account-media) | ``` media_creatives.account_id = account_media.account_id ```
DATE-TIME |
### preroll\_call\_to\_actions
The `preroll_call_to_actions` table contains info about the preroll call-to-actions associated with line items (ad groups) associated with an account.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | updated\_at |
| **Useful links** | [preroll_call_to_actions schema on GitHub](https://github.com/singer-io/tap-twitter-ads/blob/master/tap_twitter_ads/schemas/preroll_call_to_actions.json "Opens in new tab: preroll_call_to_actions schema on GitHub")
STRING |
### promoted\_accounts
The `promoted_accounts` table contains info about the promoted accounts associated with line items (ad groups) associated with an account.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | updated\_at |
| **Useful links** | [promoted_accounts schema on GitHub](https://github.com/singer-io/tap-twitter-ads/blob/master/tap_twitter_ads/schemas/promoted_accounts.json "Opens in new tab: promoted_accounts schema on GitHub")
STRING |
### promoted\_tweets
The `promoted_tweets` table contains info about references to Tweets associated with line items (ad groups) associated with an account.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | updated\_at |
| **Useful links** | [promoted_tweets schema on GitHub](https://github.com/singer-io/tap-twitter-ads/blob/master/tap_twitter_ads/schemas/promoted_tweets.json "Opens in new tab: promoted_tweets schema on GitHub")
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
| **targetable**
BOOLEAN |
| **targetable\_types**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
| **updated\_at**
DATE-TIME |
### targeting\_app\_store\_categories
The `targeting_app_store_categories` table contains info about the app store targeting categories associated with promoted products.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Key ** | targeting\_value |
| **Useful links** | [targeting_app_store_categories schema on GitHub](https://github.com/singer-io/tap-twitter-ads/blob/master/tap_twitter_ads/schemas/targeting_app_store_categories.json "Opens in new tab: targeting_app_store_categories schema on GitHub")
[Twitter Ads API method](https://developer.twitter.com/en/docs/ads/campaign-management/api-reference/targeting-options#get-targeting-criteria-conversations "Opens in new tab: Twitter Ads API method") |
targeting\_app\_store\_categories table schema
| **name**
STRING |
| --- |
| **os\_type**
STRING |
| **targeting\_type**
STRING |
| **targeting\_value**
STRING |
### targeting\_conversations
The `targeting_conversations` table contains info about the conversation-based targeting criteria for Promoted Products.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Key ** | targeting\_value |
| **Useful links** | [targeting_conversations schema on GitHub](https://github.com/singer-io/tap-twitter-ads/blob/master/tap_twitter_ads/schemas/targeting_conversations.json "Opens in new tab: targeting_conversations schema on GitHub")
[Twitter Ads API method](https://developer.twitter.com/en/docs/ads/campaign-management/api-reference/targeting-options#get-targeting-criteria-conversations "Opens in new tab: Twitter Ads API method") |
targeting\_conversations table schema
| **conversation\_type**
STRING |
| --- |
| **name**
STRING |
| **targeting\_type**
STRING |
| **targeting\_value**
STRING |
### targeting\_criteria
The `targeting_criteria` table contains info about the targeting criteria associated with an account.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Keys ** | id
line\_item\_id |
| **Useful links** | [targeting_criteria schema on GitHub](https://github.com/singer-io/tap-twitter-ads/blob/master/tap_twitter_ads/schemas/targeting_criteria.json "Opens in new tab: targeting_criteria schema on GitHub")
DATE-TIME |
### targeting\_devices
The `targeting_devices` table contains info about the device-based targeting criteria for Promoted Products.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Key ** | targeting\_value |
| **Useful links** | [targeting_devices schema on GitHub](https://github.com/singer-io/tap-twitter-ads/blob/master/tap_twitter_ads/schemas/targeting_devices.json "Opens in new tab: targeting_devices schema on GitHub")
[Twitter Ads API method](https://developer.twitter.com/en/docs/ads/campaign-management/api-reference/targeting-options#get-targeting-criteria-devices "Opens in new tab: Twitter Ads API method") |
targeting\_devices table schema
| **manufacturer**
STRING |
| --- |
| **name**
STRING |
| **os\_type**
STRING |
| **targeting\_type**
STRING |
| **targeting\_value**
STRING |
### targeting\_events
The `targeting_events` table contains info about event-based targeting criteria for Promoted Products.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Key ** | targeting\_value |
| **Useful links** | [targeting_events schema on GitHub](https://github.com/singer-io/tap-twitter-ads/blob/master/tap_twitter_ads/schemas/targeting_events.json "Opens in new tab: targeting_events schema on GitHub")
[Twitter Ads documentation](https://developer.twitter.com/en/docs/twitter-ads-api/campaign-management/api-reference/targeting-options#get-targeting-criteria-events "Opens in new tab: Twitter Ads documentation") |
targeting\_events table schema
| **country\_breakdown\_percentage**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
| --- |
| **country\_code**
STRING |
| **device\_breakdown\_percentage**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand device\_breakdown\_percentage
ANDROID
NUMBER
DESKTOP
NUMBER
IOS
NUMBER
OTHER_MOBILE
NUMBER
|
| **end\_time**
DATE-TIME |
| **event\_type**
STRING |
| **gender\_breakdown\_percentage**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand gender\_breakdown\_percentage
female
NUMBER
male
NUMBER
|
| **is\_global**
BOOLEAN |
| **name**
STRING |
| **reach**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand reach
total_impressions
INTEGER
total_number_of_tweets
INTEGER
total_reach
INTEGER
|
| **start\_time**
DATE-TIME |
| **targeting\_value**
STRING |
| **top\_hashtags**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
| **top\_tweets**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
| **top\_users**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
### targeting\_interests
The `targeting_interests` table contains info about the interest-based targeting criteria for Promoted Products.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Key ** | targeting\_value |
| **Useful links** | [targeting_interests schema on GitHub](https://github.com/singer-io/tap-twitter-ads/blob/master/tap_twitter_ads/schemas/targeting_interests.json "Opens in new tab: targeting_interests schema on GitHub")
[Twitter Ads API method](https://developer.twitter.com/en/docs/ads/campaign-management/api-reference/targeting-options#get-targeting-criteria-interests "Opens in new tab: Twitter Ads API method") |
targeting\_interests table schema
| **name**
STRING |
| --- |
| **targeting\_type**
STRING |
| **targeting\_value**
STRING |
### targeting\_languages
The `targeting_languages` table contains info about the language-based targeting criteria for Promoted Products.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Key ** | targeting\_value |
| **Useful links** | [targeting_languages schema on GitHub](https://github.com/singer-io/tap-twitter-ads/blob/master/tap_twitter_ads/schemas/targeting_languages.json "Opens in new tab: targeting_languages schema on GitHub")
[Twitter Ads API method](https://developer.twitter.com/en/docs/ads/campaign-management/api-reference/targeting-options#get-targeting-criteria-languages "Opens in new tab: Twitter Ads API method") |
targeting\_languages table schema
| **name**
STRING |
| --- |
| **targeting\_type**
STRING |
| **targeting\_value**
STRING |
### targeting\_locations
The `targeting_locations` table contains info about location-based targeting criteria for Promoted Products. According to Twitter Ads’s documentation, geo-targeting is available for Promoted Accounts and Tweets at the country, state/region, city, and postal code levels.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Key ** | targeting\_value |
| **Useful links** | [targeting_locations schema on GitHub](https://github.com/singer-io/tap-twitter-ads/blob/master/tap_twitter_ads/schemas/targeting_locations.json "Opens in new tab: targeting_locations schema on GitHub")
[Twitter Ads API method](https://developer.twitter.com/en/docs/ads/campaign-management/api-reference/targeting-options#get-targeting-criteria-locations "Opens in new tab: Twitter Ads API method") |
targeting\_locations table schema
| **country\_code**
STRING |
| --- |
| **location\_type**
STRING |
| **name**
STRING |
| **targeting\_type**
STRING |
| **targeting\_value**
STRING |
### targeting\_network\_operators
The `targeting_network_operators` table contains info about network operator-based targeting criteria for Promoted Products.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Key ** | targeting\_value |
| **Useful links** | [targeting_network_operators schema on GitHub](https://github.com/singer-io/tap-twitter-ads/blob/master/tap_twitter_ads/schemas/targeting_network_operators.json "Opens in new tab: targeting_network_operators schema on GitHub")
[Twitter Ads API method](https://developer.twitter.com/en/docs/ads/campaign-management/api-reference/targeting-options#get-targeting-criteria-network-operators "Opens in new tab: Twitter Ads API method") |
targeting\_network\_operators table schema
| **country\_code**
STRING |
| --- |
| **name**
STRING |
| **targeting\_type**
STRING |
| **targeting\_value**
STRING |
### targeting\_platform\_versions
The `targeting_platform_versions` table contains info about mobile OS-version based targeting criteria for Promoted Products.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Key ** | targeting\_value |
| **Useful links** | [targeting_platform_versions schema on GitHub](https://github.com/singer-io/tap-twitter-ads/blob/master/tap_twitter_ads/schemas/targeting_platform_versions.json "Opens in new tab: targeting_platform_versions schema on GitHub")
[Twitter Ads API method](https://developer.twitter.com/en/docs/ads/campaign-management/api-reference/targeting-options#get-targeting-criteria-platform-versions "Opens in new tab: Twitter Ads API method") |
targeting\_platform\_versions table schema
| **name**
STRING |
| --- |
| **number**
STRING |
| **os\_type**
STRING |
| **targeting\_type**
STRING |
| **targeting\_value**
STRING |
### targeting\_platforms
The `targeting_platforms` table contains info about platform-based targeting criteria for Promoted Products.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Key ** | targeting\_value |
| **Useful links** | [targeting_platforms schema on GitHub](https://github.com/singer-io/tap-twitter-ads/blob/master/tap_twitter_ads/schemas/targeting_platforms.json "Opens in new tab: targeting_platforms schema on GitHub")
[Twitter Ads API method](https://developer.twitter.com/en/docs/ads/campaign-management/api-reference/targeting-options#get-targeting-criteria-platforms "Opens in new tab: Twitter Ads API method") |
targeting\_platforms table schema
| **name**
STRING |
| --- |
| **targeting\_type**
STRING |
| **targeting\_value**
STRING |
### targeting\_tv\_markets
The `targeting_tv_markets` table contains info about TV markets where TV shows can be targeted. Use the [`targeting_tv_shows`](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#targeting_tv_shows) table for info about individual TV shows.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Key ** | locale |
| **Useful links** | [targeting_tv_markets schema on GitHub](https://github.com/singer-io/tap-twitter-ads/blob/master/tap_twitter_ads/schemas/targeting_tv_markets.json "Opens in new tab: targeting_tv_markets schema on GitHub")
[Twitter Ads API method](https://developer.twitter.com/en/docs/ads/campaign-management/api-reference/targeting-options#get-targeting-criteria-tv-markets "Opens in new tab: Twitter Ads API method") |
targeting\_tv\_markets table schema
| **country\_code**
STRING |
| --- |
| **locale**
STRING |
| **name**
STRING |
### targeting\_tv\_shows
The `targeting_tv_shows` table contains info about TV-show based targeting criteria for Promoted Products.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Key ** | targeting\_value |
| **Useful links** | [targeting_tv_shows schema on GitHub](https://github.com/singer-io/tap-twitter-ads/blob/master/tap_twitter_ads/schemas/targeting_tv_shows.json "Opens in new tab: targeting_tv_shows schema on GitHub")
[Twitter Ads API method](https://developer.twitter.com/en/docs/ads/campaign-management/api-reference/targeting-options#get-targeting-criteria-tv-shows "Opens in new tab: Twitter Ads API method") |
targeting\_tv\_shows table schema
| **genre**
STRING |
| --- |
| **locales**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand locales
country
STRING
language
STRING
|
| **name**
STRING |
| **targeting\_value**
STRING |
### tracking\_tags
The `tracking_tags` table contains info about tracking tags associated with your account.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | updated\_at |
| **Useful links** | [tracking_tags schema on GitHub](https://github.com/singer-io/tap-twitter-ads/blob/master/tap_twitter_ads/schemas/tracking_tags.json "Opens in new tab: tracking_tags schema on GitHub")
[Twitter Ads documentation](https://developer.twitter.com/en/docs/twitter-ads-api/campaign-management/api-reference/tracking-tags "Opens in new tab: Twitter Ads documentation") |
tracking\_tags table schema
| **created\_at**
DATE-TIME |
| --- |
| **deleted**
BOOLEAN |
| **id**
STRING |
| **line\_item\_id**
STRING |
| **tracking\_tag\_type**
STRING |
| **tracking\_tag\_url**
STRING |
| **updated\_at**
DATE-TIME |
### tweets
The `tweets` table contains info about the scheduled and published Tweets associated with an account’s full promotable user. **Note**: This table doesn’t include draft Tweets.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | id |
| **Replication Key ** | created\_at |
| **Useful links** | [tweets schema on GitHub](https://github.com/singer-io/tap-twitter-ads/blob/master/tap_twitter_ads/schemas/tweets.json "Opens in new tab: tweets schema on GitHub")
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand coordinates
coordinates
ARRAY
type
STRING
|
| **created\_at**
DATE-TIME |
| **entities**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand entities
hashtags
ARRAY
indices
ARRAY
text
STRING
media
ARRAY
display_url
STRING
expanded_url
STRING
id
INTEGER
id_str
STRING
indices
ARRAY
media_url
STRING
media_url_https
STRING
sizes
OBJECT
large
OBJECT
h
INTEGER
resize
STRING
w
INTEGER
medium
OBJECT
h
INTEGER
resize
STRING
w
INTEGER
small
OBJECT
h
INTEGER
resize
STRING
w
INTEGER
thumb
OBJECT
h
INTEGER
resize
STRING
w
INTEGER
polls
ARRAY
duration_minutes
INTEGER
end_datetime
DATE-TIME
options
ARRAY
position
INTEGER
text
STRING
symbols
ARRAY
indices
ARRAY
text
STRING
urls
ARRAY
display_url
STRING
expanded_url
STRING
indices
ARRAY
url
STRING
user_mentions
ARRAY
id
INTEGER
id_str
STRING
indices
ARRAY
name
STRING
screen_name
STRING
|
| **extended\_entities**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand extended\_entities
media
ARRAY
additional_media_info
OBJECT
description
STRING
embeddable
BOOLEAN
monetizable
BOOLEAN
title
STRING
display_url
STRING
expanded_url
STRING
id
INTEGER
id_str
STRING
indices
ARRAY
media_url
STRING
media_url_https
STRING
sizes
OBJECT
large
OBJECT
h
INTEGER
resize
STRING
w
INTEGER
medium
OBJECT
h
INTEGER
resize
STRING
w
INTEGER
small
OBJECT
h
INTEGER
resize
STRING
w
INTEGER
thumb
OBJECT
h
INTEGER
resize
STRING
w
INTEGER
video_info
OBJECT
aspect_ratio
ARRAY
duration_millis
INTEGER
variants
ARRAY
bitrate
INTEGER
content_type
STRING
url
STRING
|
| **favorite\_count**
INTEGER |
| **favorited**
BOOLEAN |
| **filter\_level**
STRING |
| **id**
INTEGER |
| **id\_str**
STRING |
| **in\_reply\_to\_screen\_name**
STRING |
| **in\_reply\_to\_status\_id**
INTEGER |
| **in\_reply\_to\_status\_id\_str**
STRING |
| **in\_reply\_to\_user\_id**
INTEGER |
| **in\_reply\_to\_user\_id\_str**
STRING |
| **is\_quote\_status**
BOOLEAN |
| **lang**
STRING |
| **matching\_rules**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand matching\_rules
id
INTEGER
id_str
STRING
tag
STRING
|
| **place**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand place
attributes
OBJECT
bounding_box
OBJECT
coordinates
ARRAY
type
STRING
country
STRING
country_code
STRING
full_name
STRING
id
STRING
name
STRING
place_type
STRING
url
STRING
|
| **possibly\_sensitive**
BOOLEAN |
| **quote\_count**
INTEGER |
| **quote\_status\_id**
INTEGER |
| **quote\_status\_id\_str**
STRING |
| **quoted\_status**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
| **reply\_count**
INTEGER |
| **retweet\_count**
INTEGER |
| **retweeted**
BOOLEAN |
| **retweeted\_status**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
| **source**
STRING |
| **text**
STRING |
| **truncated**
BOOLEAN |
| **tweet\_type**
STRING |
| **user**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand user
created_at
DATE-TIME
default_profile
BOOLEAN
default_profile_image
BOOLEAN
derived
OBJECT
locations
ARRAY
country
STRING
country_code
STRING
full_name
STRING
geo
OBJECT
coordinates
ARRAY
type
STRING
locality
STRING
region
STRING
sub_region
STRING
description
STRING
entities
OBJECT
description
OBJECT
urls
ARRAY
url
OBJECT
urls
ARRAY
display_url
STRING
expanded_url
STRING
indices
ARRAY
url
STRING
favourites_count
INTEGER
followers_count
INTEGER
friends_count
INTEGER
id
INTEGER
id_str
STRING
listed_count
INTEGER
location
STRING
name
STRING
profile_banner_url
STRING
profile_image_url_https
STRING
protected
BOOLEAN
screen_name
STRING
statuses_count
INTEGER
url
STRING
verified
BOOLEAN
withheld_in_countries
ARRAY
withheld_scope
STRING
|
## Reference
In this section:
* [Entity and metric group compatibility reference](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#custom-report-configuration-options--compatibility)
* [Segment compatibility reference](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#custom-report-configuration-options--segments)
* [Additional resources](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#custom-report-configuration-options--resources)
### Entity and metric group compatibility reference
In the following table, you’ll find info about the custom report options Stitch’s Twitter Ads currently supports.
The columns are as follows:
* **Entity**: The name of the entity
* **Metric group availability**: The metric groups Twitter Ads supports for the entity, which determines the columns that will be available for selection in Stitch.
For example: If an entity supports the [BILLING metric group](https://developer.twitter.com/en/docs/ads/analytics/overview/metrics-and-segmentation#BILLING), you’ll see the `billed_engagements` and `billed_charge_local_micro` metrics as available columns in the report in Stitch.
Click the links in this column for more info about the data points (columns) the metric group contains.
* **Segmentation compatibility**: Indicates the level of segment compatibility for the entity:
* the Success icon
Full compatibility
indicates the entity is compatible with all segments
* the Warning 2 icon
Some compatibility
indicates the entity is compatible with some segments
* the Remove icon
Segmentation not supported
indicates Twitter Ads doesn’t support segmentation for the entity
Refer to the [Segment compatibility reference](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#custom-report-configuration-options--segments) for more info.
| **Entity** | **Metric group availability** | **Segmentation compatibility** |
| --- | --- | --- |
| ACCOUNT |
Some compatibility |
### Segment compatibility reference
In the following table, you’ll find info about the segment options Stitch’s Twitter Ads integration currently supports.
The columns are as follows:
* **Segment**: The name of the segment
* **Entity compatibility**: The entities Twitter Ads deems compatible with the segment. **Note**: Stitch’s integration accounts for some undocumented incompatibilities. They’re documented here, but you can view them in the [Singer tap’s code](https://github.com/singer-io/tap-twitter-ads/blob/master/tap_twitter_ads/schema.py#L119).
* **Notes**: Additional notes about the segment. For example: Some segments may require that specific fields be defined in Stitch.
| **Segment** | **Entity compatibility** | **Notes** |
| --- | --- | --- |
| NO\_SEGMENT | Compatible with all entities | |
| AGE | Compatible with all entities **except**:
MEDIA_CREATIVE
ORGANIC_TWEET
| |
| AMPLIFY\_MARKETPLACE\_PREROLL\_VIDEOS | Compatible with all entities **except**:
MEDIA_CREATIVE
ORGANIC_TWEET
| |
| AMPLIFY\_PUBLISHER\_TWEETS | Compatible with all entities **except**:
MEDIA_CREATIVE
ORGANIC_TWEET
| |
| APP\_STORE\_CATEGORY | Compatible with all entities **except**:
MEDIA_CREATIVE
ORGANIC_TWEET
| |
| AUDIENCES | Compatible with all entities **except**:
MEDIA_CREATIVE
ORGANIC_TWEET
| |
| CONVERSIONS | Compatible with all entities **except**:
MEDIA_CREATIVE
ORGANIC_TWEET
| |
| CONVERSION\_TAGS | Compatible with the following entities:
ACCOUNT
CAMPAIGN
LINE_ITEM
ORGANIC_TWEET
| Only compatible with the following metric groups: WEB\_CONVERSION |
| DEVICES | Compatible with all entities **except**:
MEDIA_CREATIVE
ORGANIC_TWEET
| |
| EVENTS | Compatible with all entities **except**:
MEDIA_CREATIVE
ORGANIC_TWEET
| |
| GENDER | Compatible with all entities **except**:
MEDIA_CREATIVE
ORGANIC_TWEET
| |
| INTERESTS | Compatible with all entities **except**:
MEDIA_CREATIVE
ORGANIC_TWEET
| |
| KEYWORDS | Compatible with all entities **except**:
MEDIA_CREATIVE
ORGANIC_TWEET
| |
| LANGUAGES | Compatible with the following entities:
CAMPAIGN
LINE_ITEM
PROMOTED_TWEET
ORGANIC_TWEET
| |
| LOCATION | Compatible with all entities **except**:
MEDIA_CREATIVE
ORGANIC_TWEET
| The [Country codes](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#add-stitch-data-source) field must be defined to use this segment |
| METROS | Compatible with all entities **except**:
MEDIA_CREATIVE
ORGANIC_TWEET
| The [Country codes](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#add-stitch-data-source) field must be defined to use this segment |
| PLATFORM\_VERSIONS | Compatible with all entities **except**:
MEDIA_CREATIVE
ORGANIC_TWEET
| |
| PLATFORMS | Compatible with all entities **except**:
MEDIA_CREATIVE
ORGANIC_TWEET
| |
| POSTAL\_CODES | Compatible with all entities **except**:
MEDIA_CREATIVE
ORGANIC_TWEET
| The [Country codes](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#add-stitch-data-source) field must be defined to use this segment |
| REGIONS | Compatible with all entities **except**:
MEDIA_CREATIVE
ORGANIC_TWEET
| The [Country codes](https://help.qlik.com/en-US/stitch/integrations/saas/twitter-ads#add-stitch-data-source) field must be defined to use this segment |
| SIMILAR\_TO\_FOLLOWERS\_OF\_USER | Compatible with all entities **except**:
MEDIA_CREATIVE
ORGANIC_TWEET
| |
| SWIPEABLE\_MEDIA | Compatible with all entities **except**:
MEDIA_CREATIVE
ORGANIC_TWEET
| |
| TV\_ADS | Compatible with all entities **except**:
MEDIA_CREATIVE
ORGANIC_TWEET
| |
| TV\_SHOWS | Compatible with all entities **except**:
MEDIA_CREATIVE
ORGANIC_TWEET
| |
### Additional resources
* [Twitter Ads API Hierarchy and Terminology](https://developer.twitter.com/en/docs/tutorials/ads-api-hierarchy-terminology)
* [Twitter Ads Metrics and Segmentation Rules](https://developer.twitter.com/en/docs/ads/analytics/overview/metrics-and-segmentation)