Twitter Ads Data Dictionary

Metrics

Panoply creates a table for each valid combination of collection and metric. The table name is formatted as {__collection-table-name}_{metric}. For example, if you are interested in the mobile conversion add to wishlists metric for the campaigns collection, you would look at the twitter_ads_campaigns_mobile_conversion_add_to_wishlists table.

Panoply collects the full set of metric groups: engagement, billing, video, media, web_conversion, mobile_conversion, and life_time_value_mobile_conversion. For more information and a list of available metrics, see Metrics and Segmentation in the Twitter Ads API documentation.

Metadata

The following metadata columns are added to the destination tables:

• __updatetime - When the record was last updated. Formatted as a datetime, such as 2018-09-26T01:26:14.695Z.
• __senttime - When the record was sent from the data source. Formatted as a datetime, such as 2018-09-26T01:26:14.695Z.

The following metadata columns are added only to the entity tables for each collection, such as the twitter_ads_campaigns table, but are not added to tables created from nested data, such as the twitter_ads_campaigns_conversion_purchases table:

• __collection - The Twitter Ads collection. Possible values are: accounts, campaigns, funding_instruments, line_items, promoted_tweets, and user_timeline.
• __id - Varies for each collection.

Collections

Accounts

This collection is accounts, so the default destination table is twitter_ads_accounts. You can connect subtables to this table by joining the subtables' twitter_ads_accounts_id field on the twitter_ads_accounts table's id field.

Twitter Ads Accounts Data Dictionary

Campaigns

This collection is campaigns, so the default destination table is twitter_ads_campaigns. You can connect subtables to this table by joining the subtables' twitter_ads_campaigns_id field on the twitter_ads_campaigns table's id field.

Twitter Ads Campaigns Data Dictionary

Funding Instruments

This collection is funding_instruments, so the default destination table is twitter_ads_funding_instruments. You can connect subtables to this table by joining the subtables' twitter_ads_funding_instruments_id field on the twitter_ads_funding_instruments table's id field.

Twitter Ads Funding Instruments Data Dictionary

Line Items

This collection is line_items, so the default destination table is twitter_ads_line_items. You can connect subtables to this table by joining the subtables' twitter_ads_line_items_id field on the twitter_ads_line_items table's id field.

Twitter Ads Line Items Data Dictionary

Promoted Tweets

This collection is promoted_tweets, so the default destination table is twitter_ads_promoted_tweets. You can connect subtables to this table by joining the subtables' twitter_ads_promoted_tweets_id field on the twitter_ads_promoted_tweets table's id field.

Twitter Ads Promoted Tweets Data Dictionary

User Timeline

This collection is user_timeline, so the default destination table is twitter_ads_user_timeline. Contains a collection of the most recent Tweets posted by the user. The timeline returned is the equivalent of the one seen as a user's profile on Twitter. You can connect subtables to this table by joining the subtables' twitter_ads_user_timeline_id field on the twitter_ads_user_timeline table's id field.

Twitter Ads User Timeline Data Dictionary