> For the complete documentation index, see [llms.txt](https://docs.roivenue.com/roivenue-resources/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.roivenue.com/roivenue-resources/roivenue-training/roivenue-app/data/connectors-overview/list-of-connectors/x-twitter/x-twitter-supported-columns.md). # X (Twitter) - Supported Columns Every column the X (Twitter) connector can download. These are the columns available to a X (Twitter) connector. The recommended template uses a small subset of them, listed on the [X (Twitter)](/roivenue-resources/roivenue-training/roivenue-app/data/connectors-overview/list-of-connectors/x-twitter.md) page. The rest can be added to a connector through the Advanced Editor, which stops that connector receiving template updates. ## Dimensions | Column | Type | Metric group | Description | | ------------------------------------- | -------- | ------------ | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | `Entity.name` | String | | The name for the entity. | | `Entity.start_time` | DateTime | | The time, expressed in ISO 8601, that the entity will begin serving. | | `Entity.end_time` | DateTime | | The time, expressed in ISO 8601, that the entity will stop serving. | | `Entity.created_at` | DateTime | | The time, expressed in ISO 8601, when the entity was created. | | `Entity.updated_at` | DateTime | | The time, expressed in ISO 8601, when the entity was for the last time updated. | | `Entity.entity_status` | String | | The campaign status. Possible values: ACTIVE, DRAFT, PAUSED. | | `Entity.deleted` | Boolean | | Indicates if the campaign is deleted. | | `Entity.purchase_order_number` | String | | The booking reference number. Use this field to help with invoice reconciliation. Maximum length: 50 characters. | | `Entity.servable` | Boolean | | Indicates if campaign is servable. | | `Entity.effective_status` | String | | The campaign's effective status. Possible values: RUNNING. | | `Entity.standard_delivery` | Boolean | | Indicates if standard or accelerated delivery should be enabled. | | `Entity.reasons_not_servable` | String | | Reasons why this campaign is not servable. Possible values are: PAUSED\_BY\_ADVERTISER, INCOMPLETE, DELETED. | | `Entity.bid_strategy` | String | | The bidding mechanism. AUTO automatically optimizes bidding based on daily budget and campaign flight dates. MAX sets the maximum allowable bid and is not available when the objective is set to REACH or FOLLOWERS. TARGET attempts to make daily bid averages within 20% of the specified bid\_amount\_local\_micro and is available when the objective is set to REACH, FOLLOWERS, OR WEBSITE\_CLICKS. If set to AUTO, bid\_amount\_local\_micro will be ignored. Cannot be set in the same request as automatically\_set\_bid. Default based on objective. | | `Entity.pay_by` | String | | The unit to charge this line item by. This setting can only be modified for line items using the APP\_INSTALLS objective. The default pay\_by is automatically set based upon the campaign objective and line item's bid unit. Possible values: APP\_CLICK. | | `Entity.product_type` | String | | The type of promoted product that this line item will contain. Possible values: MEDIA, PROMOTED\_ACCOUNT, PROMOTED\_TWEETS. | | `Entity.objective` | String | | The campaign objective for this line item. Possible values: APP\_ENGAGEMENTS, APP\_INSTALLS, REACH, FOLLOWERS, ENGAGEMENTS, VIDEO\_VIEWS, PREROLL\_VIEWS, WEBSITE\_CLICKS. | | `Entity.creative_source` | String | | The source of creative for this line item. Possible values: MANAUL. | | `Entity.advertiser_domain` | String | | TThe website domain for this advertiser, without the protocol specification. | | `Entity.primary_web_event_tag` | String | | The identifier of the primary web event tag. Allows more accurate tracking of engagements for the campaign pertaining to this line item. | | `Entity.automatically_select_bid` | Boolean | | Indicates if automatically optimize bidding based on daily budget and campaign flight dates is set. | | `Entity.placements` | String | | Lists the places where Twitter ads will be displayed. The possible values are: ALL\_ON\_TWITTER, PUBLISHER\_NETWORK, TWITTER\_PROFILE, TWITTER\_SEARCH, TWITTER\_TIMELINE, TAP\_BANNER, TAP\_FULL, TAP\_FULL\_LANDSCAPE, TAP\_NATIVE, TAP\_MRECT. | | `Entity.tracking_tags` | String | | The tracking partner enum and the tracking tag url provided by the tracking partner, separated by a dash. The only currently accepted partner enum is: DOUBLE\_CLICK. Example: DOUBLE\_CLICK-. | | `Entity.categories` | String | | The relevant IAB categories for this advertiser. | | `Entity.automatic_tweet_promotion` | String | | Not documented. | | `Entity.android_app_store_identifier` | String | | The Google App Store identifier for promoted applications. | | `Entity.ios_app_store_identifier` | String | | The numeric portion of the Apple App Store identifier for promoted applications. | | `Entity.goal` | String | | The optimization setting to use with this line item. The APP\_CLICKS and APP\_INSTALLS options are available for APP\_INSTALL and APP\_ENGAGEMENTS and may require using a supported MACT partner. Default based on objective. Possible values: APP\_CLICKS, APP\_INSTALLS, ENGAGEMENT, FOLLOWERS, LINK\_CLICKS, MAX\_REACH, PREROLL, PREROLL\_STARTS, REACH\_WITH\_ENGAGEMENT, VIDEO\_VIEW, VIEW\_3S\_100PCT, VIEW\_6S, VIEW\_15S, WEBSITE\_CONVERSIONS. | | `Entity.description` | String | | Description of funding instrument. | | `Entity.type` | String | | The type of funding instrument. Possible values: AGENCY\_CREDIT\_LINE, CREDIT\_CARD, CREDIT\_LINE, INSERTION\_ORDER, PARTNER\_MANAGED. | | `Entity.able_to_fund` | Boolean | | Indicates if this funding instrument is able to be used for funding. | | `Entity.reasons_not_able_to_fund` | String | | Reasons why this funding instrument cannot be used for funding. Possible values are: DELETED, PAUSED or CANCELLED. | | `Entity.approval_status` | String | | Status of approval. Possible values include: ACCEPTED, REJECTED, and UNDER\_REVIEW. | | `Entity.card_uri` | String | | Gets the card URI of the Tweet connected to the promoted tweet. | | `Entity.card_name` | String | | Gets the card name of the Tweet connected to the promoted tweet. | | `Entity.landing_url` | String | | The URL of the website to direct a user to. This should only be used with TAP images (or 'display creatives'). This value will be ignored if used with preroll assets. | | `Entity.coordinates` | String | | | | `Entity.retweeted` | Boolean | | | | `display_text_range` | String | | | | `Entity.geo` | String | | | | `Entity.id_str` | String | | | | `Entity.in_reply_to_user_id` | String | | | | `Entity.truncated` | Boolean | | | | `Entity.in_reply_to_status_id` | String | | | | `Entity.conversation_settings` | String | | | | `Entity.nullcast` | Boolean | | | | `Entity.place` | String | | | | `Entity.scheduled_at` | DateTime | | | | `Entity.tweet_type` | String | | The type of the Tweet connected to the promoted tweet. Possible values: DRAFT, PUBLISHED, SCHEDULED. | | `Entity.favorited` | Boolean | | | | `Entity.full_text` | String | | Gets the full text of the Tweet connected to the promoted tweet. | | `Entity.lang` | String | | | | `contributors` | String | | | | `Entity.in_reply_to_screen_name` | String | | | | `Entity.card_type` | String | | | ## Metrics | Column | Type | Metric group | Description | | ------------------------------------------------------------------------ | ------- | ------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | `engagements` | Long | ENGAGEMENT | Total number of engagements | | `impressions` | Long | ENGAGEMENT | Total number of impressions | | `retweets` | Long | ENGAGEMENT | Total number of retweets | | `replies` | Long | ENGAGEMENT | Total number of replies | | `likes` | Long | ENGAGEMENT | Total number of likes | | `follows` | Long | ENGAGEMENT | Total number of follows | | `card_engagements` | Long | ENGAGEMENT | Total number of card engagements | | `clicks` | Long | ENGAGEMENT | Total number of clicks, including favorites and other engagements | | `app_clicks` | Long | ENGAGEMENT | Number of app install or app open attempts | | `qualified_impressions` | Long | ENGAGEMENT | Total number of qualified impressions | | `billed_engagements` | Long | BILLING | Total number of billed engagements | | `billed_charge_local_micro` | Long | BILLING | Total spend in micros | | `video_total_views` | Long | VIDEO | Total number of video views | | `video_views_25` | Long | VIDEO | Total number of views where at least 25% of the video was viewed. | | `video_views_50` | Long | VIDEO | Total number of views where at least 50% of the video was viewed. | | `video_views_75` | Long | VIDEO | Total number of views where at least 75% of the video was viewed. | | `video_views_100` | Long | VIDEO | Total number of views where at least 100% of the video was viewed. | | `video_cta_clicks` | Long | VIDEO | Total clicks on the call to action | | `video_content_starts` | Long | VIDEO | Total number of video playback starts | | `video_3s100pct_views` | Long | VIDEO | Total number of views where at least 3 seconds were played while 100% in view (legacy video\_total\_views) | | `video_6s_views` | Long | VIDEO | Total number of views where at least 6 seconds of the video was viewed. | | `media_views` | Long | MEDIA | Total number of views (autoplay and click) of media across Videos, Vines, GIFs, and Images. | | `media_engagements` | Long | MEDIA | Total number of clicks of media across Videos, Vines, GIFs, and Images. | | `conversion_purchases_order_quantity_engagement` | Long | WEB\_CONVERSION | Number of order engagements of type PURCHASE | | `conversion_purchases_sale_amount_engagement` | Long | WEB\_CONVERSION | Amount of sale engagements of type PURCHASE | | `conversion_purchases_sale_amount_view` | Long | WEB\_CONVERSION | Amount of sale view of type PURCHASE | | `conversion_purchases_post_view` | Long | WEB\_CONVERSION | Number of post views of type PURCHASE | | `conversion_purchases_order_quantity` | Long | WEB\_CONVERSION | Number of orders of type PURCHASE | | `conversion_purchases_assisted` | Long | WEB\_CONVERSION | Number of assisted of type PURCHASE | | `conversion_purchases_post_engagement` | Long | WEB\_CONVERSION | Number of post engagements of type PURCHASE | | `conversion_purchases_sale_amount` | Long | WEB\_CONVERSION | Amount of sales of type PURCHASE | | `conversion_purchases_metric` | Long | WEB\_CONVERSION | Metric of type PURCHASE | | `conversion_purchases_order_quantity_view` | Long | WEB\_CONVERSION | Number of order views of type PURCHASE | | `conversion_sign_ups_order_quantity_engagement` | Long | WEB\_CONVERSION | Number of order engagements of type SIGN\_UP | | `conversion_sign_ups_sale_amount_engagement` | Long | WEB\_CONVERSION | Amount of sale engagements of type SIGN\_UP | | `conversion_sign_ups_sale_amount_view` | Long | WEB\_CONVERSION | Amount of sale view of type SIGN\_UP | | `conversion_sign_ups_post_view` | Long | WEB\_CONVERSION | Number of post views of type SIGN\_UP | | `conversion_sign_ups_order_quantity` | Long | WEB\_CONVERSION | Number of orders of type SIGN\_UP | | `conversion_sign_ups_assisted` | Long | WEB\_CONVERSION | Number of assisted of type SIGN\_UP | | `conversion_sign_ups_post_engagement` | Long | WEB\_CONVERSION | Number of post engagements of type SIGN\_UP | | `conversion_sign_ups_sale_amount` | Long | WEB\_CONVERSION | Amount of sales of type SIGN\_UP | | `conversion_sign_ups_metric` | Long | WEB\_CONVERSION | Metric of type SIGN\_UP | | `conversion_sign_ups_order_quantity_view` | Long | WEB\_CONVERSION | Number of order views of type SIGN\_UP | | `conversion_site_visits_order_quantity_engagement` | Long | WEB\_CONVERSION | Number of order engagements of type SITE\_VISIT | | `conversion_site_visits_sale_amount_engagement` | Long | WEB\_CONVERSION | Amount of sale engagements of type SITE\_VISIT | | `conversion_site_visits_sale_amount_view` | Long | WEB\_CONVERSION | Amount of sale view of type SITE\_VISIT | | `conversion_site_visits_post_view` | Long | WEB\_CONVERSION | Number of post views of type SITE\_VISIT | | `conversion_site_visits_order_quantity` | Long | WEB\_CONVERSION | Number of orders of type SITE\_VISIT | | `conversion_site_visits_post_engagement` | Long | WEB\_CONVERSION | Number of post engagements of type SITE\_VISIT | | `conversion_site_visits_sale_amount` | Long | WEB\_CONVERSION | Amount of sales of type SITE\_VISIT | | `conversion_site_visits_metric` | Long | WEB\_CONVERSION | Metric of type SITE\_VISIT | | `conversion_site_visits_order_quantity_view` | Long | WEB\_CONVERSION | Number of order views of type SITE\_VISIT | | `conversion_downloads_order_quantity_engagement` | Long | WEB\_CONVERSION | Number of order engagements of type DOWNLOAD | | `conversion_downloads_sale_amount_engagement` | Long | WEB\_CONVERSION | Amount of sale engagements of type DOWNLOAD | | `conversion_downloads_sale_amount_view` | Long | WEB\_CONVERSION | Amount of sale view of type DOWNLOAD | | `conversion_downloads_post_view` | Long | WEB\_CONVERSION | Number of post views of type DOWNLOAD | | `conversion_downloads_order_quantity` | Long | WEB\_CONVERSION | Number of orders of type DOWNLOAD | | `conversion_downloads_post_engagement` | Long | WEB\_CONVERSION | Number of post engagements of type DOWNLOAD | | `conversion_downloads_sale_amount` | Long | WEB\_CONVERSION | Amount of sales of type DOWNLOAD | | `conversion_downloads_metric` | Long | WEB\_CONVERSION | Metric of type DOWNLOAD | | `conversion_downloads_order_quantity_view` | Long | WEB\_CONVERSION | Number of order views of type DOWNLOAD | | `conversion_custom_order_quantity_engagement` | Long | WEB\_CONVERSION | Number of order engagements of type CUSTOM | | `conversion_custom_sale_amount_engagement` | Long | WEB\_CONVERSION | Amount of sale engagements of type CUSTOM | | `conversion_custom_sale_amount_view` | Long | WEB\_CONVERSION | Amount of sale view of type CUSTOM | | `conversion_custom_post_view` | Long | WEB\_CONVERSION | Number of post views of type CUSTOM | | `conversion_custom_order_quantity` | Long | WEB\_CONVERSION | Number of orders of type CUSTOM | | `conversion_custom_post_engagement` | Long | WEB\_CONVERSION | Number of post engagements of type CUSTOM | | `conversion_custom_sale_amount` | Long | WEB\_CONVERSION | Amount of sales of type CUSTOM | | `conversion_custom_metric` | Long | WEB\_CONVERSION | Metric of type CUSTOM | | `conversion_custom_order_quantity_view` | Long | WEB\_CONVERSION | Number of order views of type CUSTOM | | `mobile_conversion_spent_credits_post_view` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type SPENT\_CREDIT by post\_view | | `mobile_conversion_spent_credits_order_quantity` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type SPENT\_CREDIT by order\_quantity | | `mobile_conversion_spent_credits_assisted` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type SPENT\_CREDIT by assisted | | `mobile_conversion_spent_credits_post_engagement` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type SPENT\_CREDIT by post\_engagement | | `mobile_conversion_spent_credits_sale_amount` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type SPENT\_CREDIT by sale\_amount | | `mobile_conversion_installs_post_view` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type INSTALL by post\_view | | `mobile_conversion_installs_order_quantity` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type INSTALL by order\_quantity | | `mobile_conversion_installs_assisted` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type INSTALL by assisted | | `mobile_conversion_installs_post_engagement` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type INSTALL by post\_engagement | | `mobile_conversion_installs_sale_amount` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type INSTALL by sale\_amount | | `mobile_conversion_content_views_post_view` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type CONTENT\_VIEW by post\_view | | `mobile_conversion_content_views_order_quantity` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type CONTENT\_VIEW by order\_quantity | | `mobile_conversion_content_views_assisted` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type CONTENT\_VIEW by assisted | | `mobile_conversion_content_views_post_engagement` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type CONTENT\_VIEW by post\_engagement | | `mobile_conversion_content_views_sale_amount` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type CONTENT\_VIEW by sale\_amount | | `mobile_conversion_add_to_wishlists_post_view` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type ADD\_TO\_WISHLIST by post\_view | | `mobile_conversion_add_to_wishlists_order_quantity` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type ADD\_TO\_WISHLIST by order\_quantity | | `mobile_conversion_add_to_wishlists_assisted` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type ADD\_TO\_WISHLIST by assisted | | `mobile_conversion_add_to_wishlists_post_engagement` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type ADD\_TO\_WISHLIST by post\_engagement | | `mobile_conversion_add_to_wishlists_sale_amount` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type ADD\_TO\_WISHLIST by sale\_amount | | `mobile_conversion_checkouts_initiated_post_view` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type CHECKOUT\_INITIATED by post\_view | | `mobile_conversion_checkouts_initiated_order_quantity` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type CHECKOUT\_INITIATED by order\_quantity | | `mobile_conversion_checkouts_initiated_assisted` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type CHECKOUT\_INITIATED by assisted | | `mobile_conversion_checkouts_initiated_post_engagement` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type CHECKOUT\_INITIATED by post\_engagement | | `mobile_conversion_checkouts_initiated_sale_amount` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type CHECKOUT\_INITIATED by sale\_amount | | `mobile_conversion_reservations_post_view` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type RESERVATION by post\_view | | `mobile_conversion_reservations_order_quantity` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type RESERVATION by order\_quantity | | `mobile_conversion_reservations_assisted` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type RESERVATION by assisted | | `mobile_conversion_reservations_post_engagement` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type RESERVATION by post\_engagement | | `mobile_conversion_reservations_sale_amount` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type RESERVATION by sale\_amount | | `mobile_conversion_tutorials_completed_post_view` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type TUTORIAL\_COMPLETED by post\_view | | `mobile_conversion_tutorials_completed_order_quantity` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type TUTORIAL\_COMPLETED by order\_quantity | | `mobile_conversion_tutorials_completed_assisted` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type TUTORIAL\_COMPLETED by assisted | | `mobile_conversion_tutorials_completed_post_engagement` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type TUTORIAL\_COMPLETED by post\_engagement | | `mobile_conversion_tutorials_completed_sale_amount` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type TUTORIAL\_COMPLETED by sale\_amount | | `mobile_conversion_achievements_unlocked_post_view` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type ACHIEVEMENT\_UNLOCKED by post\_view | | `mobile_conversion_achievements_unlocked_order_quantity` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type ACHIEVEMENT\_UNLOCKED by order\_quantity | | `mobile_conversion_achievements_unlocked_assisted` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type ACHIEVEMENT\_UNLOCKED by assisted | | `mobile_conversion_achievements_unlocked_post_engagement` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type ACHIEVEMENT\_UNLOCKED by post\_engagement | | `mobile_conversion_achievements_unlocked_sale_amount` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type ACHIEVEMENT\_UNLOCKED by sale\_amount | | `mobile_conversion_searches_post_view` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type SEARCH by post\_view | | `mobile_conversion_searches_order_quantity` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type SEARCH by order\_quantity | | `mobile_conversion_searches_assisted` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type SEARCH by assisted | | `mobile_conversion_searches_post_engagement` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type SEARCH by post\_engagement | | `mobile_conversion_searches_sale_amount` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type SEARCH by sale\_amount | | `mobile_conversion_add_to_carts_post_view` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type ADD\_TO\_CART by post\_view | | `mobile_conversion_add_to_carts_order_quantity` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type ADD\_TO\_CART by order\_quantity | | `mobile_conversion_add_to_carts_assisted` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type ADD\_TO\_CART by assisted | | `mobile_conversion_add_to_carts_post_engagement` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type ADD\_TO\_CART by post\_engagement | | `mobile_conversion_add_to_carts_sale_amount` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type ADD\_TO\_CART by sale\_amount | | `mobile_conversion_payment_info_additions_post_view` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type PAYMENT\_INFO\_ADDITION by post\_view | | `mobile_conversion_payment_info_additions_order_quantity` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type PAYMENT\_INFO\_ADDITION by order\_quantity | | `mobile_conversion_payment_info_additions_assisted` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type PAYMENT\_INFO\_ADDITION by assisted | | `mobile_conversion_payment_info_additions_post_engagement` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type PAYMENT\_INFO\_ADDITION by post\_engagement | | `mobile_conversion_payment_info_additions_sale_amount` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type PAYMENT\_INFO\_ADDITION by sale\_amount | | `mobile_conversion_re_engages_post_view` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type RE\_ENGAGE by post\_view | | `mobile_conversion_re_engages_order_quantity` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type RE\_ENGAGE by order\_quantity | | `mobile_conversion_re_engages_assisted` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type RE\_ENGAGE by assisted | | `mobile_conversion_re_engages_post_engagement` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type RE\_ENGAGE by post\_engagement | | `mobile_conversion_re_engages_sale_amount` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type RE\_ENGAGE by sale\_amount | | `mobile_conversion_shares_post_view` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type SHARE by post\_view | | `mobile_conversion_shares_order_quantity` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type SHARE by order\_quantity | | `mobile_conversion_shares_assisted` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type SHARE by assisted | | `mobile_conversion_shares_post_engagement` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type SHARE by post\_engagement | | `mobile_conversion_shares_sale_amount` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type SHARE by sale\_amount | | `mobile_conversion_rates_post_view` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type RATE by post\_view | | `mobile_conversion_rates_order_quantity` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type RATE by order\_quantity | | `mobile_conversion_rates_assisted` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type RATE by assisted | | `mobile_conversion_rates_post_engagement` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type RATE by post\_engagement | | `mobile_conversion_rates_sale_amount` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type RATE by sale\_amount | | `mobile_conversion_logins_post_view` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type LOGIN by post\_view | | `mobile_conversion_logins_order_quantity` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type LOGIN by order\_quantity | | `mobile_conversion_logins_assisted` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type LOGIN by assisted | | `mobile_conversion_logins_post_engagement` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type LOGIN by post\_engagement | | `mobile_conversion_logins_sale_amount` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type LOGIN by sale\_amount | | `mobile_conversion_updates_post_view` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type UPDATE by post\_view | | `mobile_conversion_updates_order_quantity` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type UPDATE by order\_quantity | | `mobile_conversion_updates_assisted` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type UPDATE by assisted | | `mobile_conversion_updates_post_engagement` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type UPDATE by post\_engagement | | `mobile_conversion_updates_sale_amount` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type UPDATE by sale\_amount | | `mobile_conversion_levels_achieved_post_view` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type LEVEL\_ACHIEVED by post\_view | | `mobile_conversion_levels_achieved_order_quantity` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type LEVEL\_ACHIEVED by order\_quantity | | `mobile_conversion_levels_achieved_assisted` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type LEVEL\_ACHIEVED by assisted | | `mobile_conversion_levels_achieved_post_engagement` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type LEVEL\_ACHIEVED by post\_engagement | | `mobile_conversion_levels_achieved_sale_amount` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type LEVEL\_ACHIEVED by sale\_amount | | `mobile_conversion_invites_post_view` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type INVITE by post\_view | | `mobile_conversion_invites_order_quantity` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type INVITE by order\_quantity | | `mobile_conversion_invites_assisted` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type INVITE by assisted | | `mobile_conversion_invites_post_engagement` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type INVITE by post\_engagement | | `mobile_conversion_invites_sale_amount` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type INVITE by sale\_amount | | `mobile_conversion_key_page_views_post_view` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type KEY\_PAGE\_VIEW by post\_view | | `mobile_conversion_key_page_views_post_engagement` | Long | MOBILE\_CONVERSION | Breakdown of mobile conversions of type KEY\_PAGE\_VIEW by post\_engagement | | `mobile_conversion_lifetime_value_purchases_metric` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type PURCHASE by metric | | `mobile_conversion_lifetime_value_purchases_order_quantity` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type PURCHASE by order\_quantity | | `mobile_conversion_lifetime_value_purchases_sale_amount` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type PURCHASE by sale\_amount | | `mobile_conversion_lifetime_value_sign_ups_metric` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type SIGN\_UP by metric | | `mobile_conversion_lifetime_value_sign_ups_order_quantity` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type SIGN\_UP by order\_quantity | | `mobile_conversion_lifetime_value_sign_ups_sale_amount` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type SIGN\_UP by sale\_amount | | `mobile_conversion_lifetime_value_updates_metric` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type UPDATE by metric | | `mobile_conversion_lifetime_value_updates_order_quantity` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type UPDATE by order\_quantity | | `mobile_conversion_lifetime_value_updates_sale_amount` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type UPDATE by sale\_amount | | `mobile_conversion_lifetime_value_tutorials_completed_metric` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type TUTORIAL\_COMPLETED by metric | | `mobile_conversion_lifetime_value_tutorials_completed_order_quantity` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type TUTORIAL\_COMPLETED by order\_quantity | | `mobile_conversion_lifetime_value_tutorials_completed_sale_amount` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type TUTORIAL\_COMPLETED by sale\_amount | | `mobile_conversion_lifetime_value_reservations_metric` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type RESERVATION by metric | | `mobile_conversion_lifetime_value_reservations_order_quantity` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type RESERVATION by order\_quantity | | `mobile_conversion_lifetime_value_reservations_sale_amount` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type RESERVATION by sale\_amount | | `mobile_conversion_lifetime_value_add_to_carts_metric` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type ADD\_TO\_CART by metric | | `mobile_conversion_lifetime_value_add_to_carts_order_quantity` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type ADD\_TO\_CART by order\_quantity | | `mobile_conversion_lifetime_value_add_to_carts_sale_amount` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type ADD\_TO\_CART by sale\_amount | | `mobile_conversion_lifetime_value_add_to_wishlists_metric` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type ADD\_TO\_WISHLIST by metric | | `mobile_conversion_lifetime_value_add_to_wishlists_order_quantity` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type ADD\_TO\_WISHLIST by order\_quantity | | `mobile_conversion_lifetime_value_add_to_wishlists_sale_amount` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type ADD\_TO\_WISHLIST by sale\_amount | | `mobile_conversion_lifetime_value_checkouts_initiated_metric` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type CHECKOUT\_INITIATED by metric | | `mobile_conversion_lifetime_value_checkouts_initiated_order_quantity` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type CHECKOUT\_INITIATED by order\_quantity | | `mobile_conversion_lifetime_value_checkouts_initiated_sale_amount` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type CHECKOUT\_INITIATED by sale\_amount | | `mobile_conversion_lifetime_value_levels_achieved_metric` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type LEVEL\_ACHIEVED by metric | | `mobile_conversion_lifetime_value_levels_achieved_order_quantity` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type LEVEL\_ACHIEVED by order\_quantity | | `mobile_conversion_lifetime_value_levels_achieved_sale_amount` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type LEVEL\_ACHIEVED by sale\_amount | | `mobile_conversion_lifetime_value_achievements_unlocked_metric` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type ACHIEVEMENT\_UNLOCKED by metric | | `mobile_conversion_lifetime_value_achievements_unlocked_order_quantity` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type ACHIEVEMENT\_UNLOCKED by order\_quantity | | `mobile_conversion_lifetime_value_achievements_unlocked_sale_amount` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type ACHIEVEMENT\_UNLOCKED by sale\_amount | | `mobile_conversion_lifetime_value_shares_metric` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type SHARE by metric | | `mobile_conversion_lifetime_value_shares_order_quantity` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type SHARE by order\_quantity | | `mobile_conversion_lifetime_value_shares_sale_amount` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type SHARE by sale\_amount | | `mobile_conversion_lifetime_value_invites_metric` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type INVITE by metric | | `mobile_conversion_lifetime_value_invites_order_quantity` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type INVITE by order\_quantity | | `mobile_conversion_lifetime_value_invites_sale_amount` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type INVITE by sale\_amount | | `mobile_conversion_lifetime_value_payment_info_additions_metric` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type PAYMENT\_INFO\_ADDITION by metric | | `mobile_conversion_lifetime_value_payment_info_additions_order_quantity` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type PAYMENT\_INFO\_ADDITION by order\_quantity | | `mobile_conversion_lifetime_value_payment_info_additions_sale_amount` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type PAYMENT\_INFO\_ADDITION by sale\_amount | | `mobile_conversion_lifetime_value_spent_credits_metric` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type SPENT\_CREDIT by metric | | `mobile_conversion_lifetime_value_spent_credits_order_quantity` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type SPENT\_CREDIT by order\_quantity | | `mobile_conversion_lifetime_value_spent_credits_sale_amount` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type SPENT\_CREDIT by sale\_amount | | `mobile_conversion_lifetime_value_rates_metric` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type RATE by metric | | `mobile_conversion_lifetime_value_rates_order_quantity` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type RATE by order\_quantity | | `mobile_conversion_lifetime_value_rates_sale_amount` | Long | LIFE\_TIME\_VALUE\_MOBILE\_CONVERSION | Breakdown of mobile conversions of type RATE by sale\_amount | | `Entity.daily_budget_amount_local_micro` | Long | | The daily budget amount to be allocated to the campaign. The currency associated with the specified funding instrument will be used. For USD, $5.50 is represented as 5500000. | | `Entity.total_budget_amount_local_micro` | Long | | The total budget amount to be allocated to the entity. The currency associated with the specified funding instrument will be used. For USD, $37.50 is represented as 37500000. | | `Entity.duration_in_days` | Long | | The time period within which the frequency\_cap is achieved. Possible values: 1, 7, 30. | | `Entity.frequency_cap` | Long | | The maximum number of times an ad could be delivered to a user. | | `Entity.bid_amount_local_micro` | Long | | The bid amount to be associated with this line item. The currency associated with the specified funding instrument will be used. For USD, $5.50 is represented as 5500000. | | `Entity.credit_remaining_local_micro` | Decimal | | It is valid for CREDIT\_LINE and AGENCY\_CREDIT\_LINE type funding instruments. It represents the credit\_limit\_local\_micro minus the amount already spent on that funding instrument. It does not represent the difference between funded\_amount\_local\_micro and the amount spent. | | `Entity.credit_limit_local_micro` | Decimal | | It is only valid for CREDIT\_CARD or CREDIT\_LINE type funding instruments and represents the credit limit for that instrument. | | `Entity.funded_amount_local_micro` | Decimal | | It is only valid for INSERTION\_ORDER type funding instruments and represents the allocated budget. | | `Entity.tweet.favorite_count` | Long | | Indicates approximately how many times Tweet connected to the promoted tweet has been liked by Twitter users. | | `Entity.tweet.retweet_count` | Long | | Number of times Tweet connected to the promoted tweet has been retweeted. | | `{CPM}` | Double | | Calculated as billed\_charge\_local\_micro/impressions/1000 | | `{billed_charge_local}` | Double | | Calculated as billed\_charge\_local\_micro/1000000 rounded to 2 decimal places | | `Entity.favorite_count` | Long | | | | `Entity.retweet_count` | Long | | | ## Other columns | Column | Type | Metric group | Description | | ------------------------------ | ------ | ------------ | --------------------------------------------------------------------------------- | | `Entity.id` | String | | The identifier for the retrieved entity. | | `Entity.currency` | String | | The type of a currency that is identified using ISO-4217 standard. | | `Entity.funding_instrument_id` | String | | The identifier for the funding instrument under which the campaign was created. | | `Entity.campaign_id` | String | | The identifier for the campaign that this line item was created under. | | `Entity.advertiser_user_id` | Long | | The Twitter user identifier for the handle promoting a PREROLL\_VIEWS ad. | | `Entity.account_id` | String | | The identifier for the leveraged account. | | `Entity.io_header` | String | | Insertion order header ID. | | `Entity.line_item_id` | String | | A reference to the line item to which entity belongs. | | `Entity.tweet_id` | String | | Identifier of the Tweet. | | `Entity.user_id` | String | | Identifier of the User which created this account. | | `Entity.account_media_id` | String | | A reference to the account media entity that is connected to this media creative. | | `Entity.source` | String | | |