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, anduser_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.