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 | |
CAMPAIGN | Campaign | campaign_name | |
Campaign ID | campaign_id | The unique ID for each campaign | |
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 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 | |
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 |