Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Description |
|---|---|---|---|
| TIME | Year | year | Year, e.g. 2017 |
| Year of week (Sun-Sat) | yearofweek | Year of week for US weeks, e.g. 2017 | |
| Year of week (Mon-Sun) | yearofweekiso | Year of week for ISO weeks, e.g. 2017 | |
| Year & month | yearmonth | Year and month, e.g. 2017|06 | |
| Quarter | quarter | Quarter, e.g. 1 | |
| Month | month | Month, e.g. 6 | |
| Year & week (Sun-Sat) | yearweek | Year and week for US weeks, e.g. 2017|08 | |
| Year & week (Mon-Sun) | yearweekiso | Year and week for ISO weeks, e.g. 2017|08 | |
| Week (Sun-Sat) | week | US week number, e.g. 51 | |
| Week (Mon-Sun) | weekiso | ISO week number, e.g. 51 | |
| Day of week (Sun-Sat) | dayOfWeekName | Day of week name for US weeks, e.g. 0 Sunday | |
| Day of week (Mon-Sun) | dayOfWeekNameIso | Day of week name for ISO weeks, e.g. 1 Monday | |
| Day of month | dayOfMonth | Day of month, e.g. 2 | |
| Date | date | Date, e.g. 2017-01-31 | |
| ACCOUNT | Account | account | The ad account name |
| Account ID | account_id | The unique ID for the ad account | |
| Account UI ID | account_ui_id | Converted account ID to base-10 to match the UI value | |
| CAMPAIGN | Campaign | campaign_name | |
| Campaign ID | campaign_id | The unique ID for each campaign | |
| Campaign UI ID | campaign_ui_id | Converted campaign ID to base-10 to match the UI value | |
| Campaign creation date | campaign_created_at | ||
| Campaign start date | campaign_start_time | The date your campaign is scheduled to launch. This field is deprecated by Twitter, please use Ad group start date instead | |
| Campaign end date | campaign_end_time | The date when the campaign ends. This field is deprecated by Twitter, please use Ad group end date instead | |
| Campaign servable | campaign_servable | ||
| Campaign status | campaign_status | The campaign status, with possible values ACTIVE, DRAFT, or PAUSED | |
| Campaign deleted | campaign_deleted | ||
| Campaign currency | campaign_currency | The currency used for all spend-related metrics and billing | |
| Campaign standard delivery | campaign_standard_delivery | ||
| Campaign total budget | campaign_total_budget_amount | The maximum amount you're willing to spend on each campaign for the duration of the campaign | |
| Campaign daily budget | campaign_daily_budget_amount | The maximum amount you're willing to spend on each campaign on average per day | |
| Campaign budget optimization | campaign_budget_optimization | Type of the campaign budget optimization. Possible values - CAMPAIGN and LINE_ITEM | |
| FUNDING INSTRUMENTS | Funding instrument ID | funding_instrument_id | A reference to the funding instrument |
| Funding instrument UI ID | funding_instrument_ui_id | Converted funding instrument ID to base-10 to match the UI value | |
| Funding instrument description | funding_instrument_description | Funding instrument description | |
| Funding instrument type | funding_instrument_type | Funding instrument type | |
| Funding instrument status | funding_instrument_status | Funding instrument status | |
| Funding instrument currency | funding_instrument_currency | Funding instrument currency | |
| Funding instrument start date | funding_instrument_start_date | The date for the funding instrument to become active and usable | |
| Funding instrument end date | funding_instrument_end_date | The date for the funding instrument to become inactive | |
| Funding instrument credit limit | funding_instrument_credit_limit | The total credit available against funding instrument | |
| Funding instrument funded amount | funding_instrument_funded_amount | The total budget amount allocated to funding instrument | |
| Funding instrument credit remaining | funding_instrument_credit_remaining | The total credit remaining to funding instrument | |
| Reasons funding instrument was not able to fund | funding_instrument_reasons_not_able_to_fund | Reasons funding instrument was not able to fund | |
| Insertion order header ID | funding_instrument_io_header | ID for the associated insertion order. Note that a single ID may be associated with multiple funding instruments | |
| AD GROUP | Ad group | line_item_name | Formerly called line item |
| Ad group ID | line_item_id | Formerly called line item id | |
| Ad group UI ID | ad_group_ui_id | Converted ad group ID to base-10 to match the UI value | |
| Objective | line_item_objective | ||
| Goal | line_item_goal | The optimization setting used for this ad group | |
| Product type | line_item_product_type | ||
| Placements | line_item_placements | ||
| Charge by | line_item_charge_by | ||
| Bid type | line_item_bid_type | ||
| Bid amount | line_item_bid_amount | ||
| Ad group total budget | line_item_total_budget_amount | The maximum amount you are willing to spend on the ad group, for the duration of the ad group flight length. Formerly called line item total budget | |
| Advertiser domain | line_item_advertiser_domain | ||
| Primary web event tag | line_item_primary_web_event_tag | ||
| Ad group creation date | line_item_created_at | Formerly called line item creation date | |
| Ad group start date | line_item_start_date | The date when the ad group began serving | |
| Ad group end date | line_item_end_date | The date when the ad group stopped serving | |
| Ad group status | line_item_status | The ad group status, with possible values ACTIVE, DRAFT, or PAUSED | |
| Ad group deleted | line_item_deleted | Formerly called line item deleted | |
| Categories | line_item_categories | ||
| Include sentiment | line_item_include_sentiment | ||
| PROMOTED TWEET | Tweet ID | promoted_tweet_id | Unique numeric ID of the original tweet being used in the promoted tweet ad |
| Tweet ad ID | promoted_tweet_ad_id | Unique alphanumeric ID for the promoted tweet ad | |
| Tweet creation date | promoted_tweet_created_at | ||
| Ad name | ad_name | Ad name as displayed in X user interface. Derived from promoted tweet name, or card name if tweet name is not set | |
| Tweet name | promoted_tweet_name | Name of the promoted tweet. Note that this can be empty for older Tweets or ones created without a name | |
| Tweet text | promoted_tweet_text | ||
| Tweet source | promoted_tweet_source | Source client of the tweet, e.g. twitter.com or Twitter for Android | |
| Tweet scheduled status | promoted_tweet_scheduled_status | Whether the tweet is scheduled for later or not | |
| Tweet scheduled at | promoted_tweet_scheduled_at | Tweet scheduled to publish at | |
| Tweet type | promoted_tweet_type | Tweet type, e.g. PUBLISHED | |
| Tweet language | promoted_tweet_language | Language of the tweet (automatically identified) | |
| Tweet hashtags | promoted_tweet_hashtags | Hashtags included in the tweet | |
| Tweet symbols | promoted_tweet_symbols | Symbols included in the tweet | |
| Tweet mentions | promoted_tweet_user_mentions | Users mentioned in the tweet | |
| Link to tweet | tweet_url | ||
| Tweet first URL | promoted_tweet_first_url | ||
| Tweet card title | promoted_tweet_card_title | ||
| Tweet card name | promoted_tweet_card_name | ||
| Tweet card type | promoted_tweet_card_type | ||
| Tweet card destination URL | promoted_tweet_card_destination_url | ||
| Tweet card image URL | promoted_tweet_card_image_url | ||
| Tweet card image | promoted_tweet_card_image | ||
| Tweet card URI | promoted_tweet_card_uri | The unique identifier of the card. Replaces Tweet card ID | |
| Tweet destination URL | promoted_tweet_destination_url | ||
| Tweet media type | promoted_tweet_media_type | Type of tweet media | |
| Source (utm) | utm_source | Value of the utm_source parameter extracted from the ad destination URL | |
| Medium (utm) | utm_medium | Value of the utm_medium parameter extracted from the ad destination URL | |
| Content (utm) | utm_content | Value of the utm_content parameter extracted from the ad destination URL | |
| Term (utm) | utm_term | Value of the utm_term parameter extracted from the ad destination URL | |
| Campaign (utm) | utm_campaign | Value of the utm_campaign parameter extracted from the ad destination URL | |
| MEDIA CREATIVE | Media creative ID | media_creative_id | ID of the media creative |
| Media creative creation date | media_creative_created_at | Creation date of the media creative | |
| Media creative type | media_creative_type | Type of the media creative | |
| Media name | media_name | Name of the media object | |
| Media url | media_url | URL to the media object | |
| SEGMENTATION | Age | AGE | |
| App store category | APP_STORE_CATEGORY | ||
| Conversion tag | CONVERSION_TAGS | ||
| Event | EVENTS | ||
| Gender | GENDER | ||
| Interest | INTERESTS | ||
| Keyword | KEYWORDS | ||
| Language | LANGUAGES | ||
| Country | LOCATIONS | ||
| Country code | countryCode | Two-letter county code | |
| Region | REGIONS | ||
| City | CITIES | ||
| Platform | PLATFORMS | ||
| Similar to follower | SIMILAR_TO_FOLLOWERS_OF_USER | ||
| TV show | TV_SHOWS | ||
| DEPRECATED | Tweet card display URL | promoted_tweet_card_display_url | Please note this field will be removed on 2021-08-24 |
| Audience category | audienceCategory | Name of audience category, e.g. White collar worker. Please note this field will be removed on 2020-01-30 | |
| Optimization | line_item_optimization | Please note this field will be removed on 2021-08-24 | |
| Audience name | audienceName | Name of audience, e.g. Occupation. Please note this field will be removed on 2020-01-30 | |
| Source of audience data | audienceSource | The providing party of audience data. Please note this field will be removed on 2020-01-30 | |
| Audience type | audienceType | Type of an audience, e.g. ALL_ON_TWITTER. Please note this field will be removed on 2020-01-30 | |
| Interaction type | interactionType | Type of interaction; applicable to some audience types. Please note this field will be removed on 2020-01-30 | |
| Tracking tags | line_item_tracking_tags | Please note that this field will be removed on 2022-02-15 | |
| Ad group paused | line_item_paused | Formerly called line item paused. Please note that this field will be removed on 2022-11-30 | |
| Automatically select bid | line_item_automatically_select_bid | Please note that this field will be removed on 2022-02-15 | |
| Campaign paused | campaign_paused | Please note that this field will be removed on 2022-11-30 | |
| Tweet card ID | promoted_tweet_card_id | Please note this field will be removed on 2021-08-24 | |
| Query | Start date | system_metadata.query_date_range_start | The start date of the requested query |
| End date | system_metadata.query_date_range_end | The end date of the requested query | |
| Timezone | system_metadata.query_timezone | The timezone that is supplied to the query | |
| Filters | system_metadata.query_filters | All filters used in the query | |
| Start | system_metadata.query_date_start | When the query was started | |
| End | system_metadata.query_date_end | When the query completed | |
| Duration | system_metadata.query_duration | The duration in seconds of the query | |
| Accounts | system_metadata.query_accounts | A list of accounts of which the data was pulled from | |
| Datasource | Data source logins | system_metadata.data_source_logins | The data source login accounts that were used to authenticate against the data source |
| Data source login owners | system_metadata.data_source_login_owners | The Supermetrics users that created the data source login connections |