Windsor brings all your Line Ads data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Line Ads Field Reference
Fields
| ID | Type | Name | Description | Reports |
|---|---|---|---|---|
| account_available_campaign_objective | TEXT | Account Available Campaign Objective | Ad account available campaign objectives. Possible values are VISIT_MY_WEBSITE, APP_INSTALL, APP_ENGAGEMENT, WEBSITE_CONVERSION, DYNAMIC_PRODUCT, GAIN_FRIENDS, VIDEO_VIEW. | campaign; adgroup; ad; |
| account_country | COUNTRY | Account Country | Ad account country. | campaign; adgroup; ad; |
| account_created_date | DATE | Account Created Date | The created date in ISO 8601 format and in ad account timezone. | campaign; adgroup; ad; |
| account_currency | TEXT | Account Currency | Ad account currency. | campaign; adgroup; ad; |
| account_delivery_status | TEXT | Account Delivery Status | The status of delivery ad. Possible values are ACTIVE, PAUSED, REMOVED, NOT_DELIVERING, NOT_APPROVED. | campaign; adgroup; ad; |
| account_id | TEXT | Account ID | Ad account ID. | campaign; adgroup; ad; |
| account_modified_date | DATE | Account Modified Date | The last modified date in ISO 8601 format and in ad account. | campaign; adgroup; ad; |
| account_name | TEXT | Account Name | Ad account name. | campaign; adgroup; ad; |
| account_product_type | TEXT | Account Product Type | Ad account product type. Ad Account for performance has PERFORMANCE type. Ad Account for reservation ads has BRAND type. | campaign; adgroup; ad; |
| account_removed_date | DATE | Account Removed Date | The removed date in ISO 8601 format and in ad account timezone. | campaign; adgroup; ad; |
| account_status | TEXT | Account Status | Ad account status. Possible values are ACTIVE, PAUSED, REMOVED. | campaign; adgroup; ad; |
| account_timezone | TEXT | Account Timezone | Ad account timezone. | campaign; adgroup; ad; |
| ad_configured_status | TEXT | Ad Status | Ad status. Possible values are ACTIVE, PAUSED, DRAFT, REMOVED. | ad; |
| ad_created_date | DATE | Ad Created Date | The created date in ad account timezone. | ad; |
| ad_delivery_status | TEXT | Ad Delivery Status | The status of delivery ad. Possible values are ACTIVE, PAUSED, REMOVED, NOT_DELIVERING, NOT_APPROVED. | ad; |
| ad_group_auto_bid_conversion_id | TEXT | Ad Group Auto Bid Conversion ID | The custom conversion ID. | adgroup; ad; |
| ad_group_auto_bid_type | TEXT | Ad Group Auto Bid Type | The type of auto bidding. Possible values are MANUAL, CLICK, CONVERSION, CUSTOM_CONVERSION, STANDARD_CV_PURCHASE, CV_INSTALL, CV_OPEN, FRIEND, VIDEO_VIEW_3S, VIDEO_VIEW_COMPLETION, REACH, CV_SKADNETWORK. | adgroup; ad; |
| ad_group_bid_amount_micro | NUMERIC | Ad Group Bid Amount Micro | Bid amount in micros and in ad account currency. | adgroup; ad; |
| ad_group_bid_strategy | TEXT | Ad Group Bid Strategy | The strategy of auto bidding. Possible values are LOWEST_COST (no limit; expend daily budget as aggressively as possible), COST_CAP (set a target event cost cap), TARGET_COST (set target event cost). | adgroup; ad; |
| ad_group_bid_type | TEXT | Ad Group Bid Type | The type of bidding. Possible values are CPC, CPF, CPM. | adgroup; ad; |
| ad_group_created_date | DATE | Ad Group Created Date | The created date in ad account timezone. | adgroup; ad; |
| ad_group_daily_budget_micro | NUMERIC | Ad Group Daily Budget Micro | Daily budget in micros and in ad account currency. | adgroup; ad; |
| ad_group_delivery_status | TEXT | Ad Group Delivery Status | The status of delivery ad. Possible values are ACTIVE, PAUSED, REMOVED, NOT_DELIVERING, NOT_APPROVED. | adgroup; ad; |
| ad_group_dpa_destination_type | TEXT | Ad Group DPA Destination Type | The type of DPA destination. Possible values are APP_STORE_URL, WEB_URL, TRACKING_URL_CMS. (DPA only) | adgroup; ad; |
| ad_group_dpa_destination_url | TEXT | Ad Group DPA Destination URL | The URL of DPA destination. (DPA only) | adgroup; ad; |
| ad_group_dpa_feed_type | TEXT | Ad Group DPA Feed Type | The DPA feed type. Possible values are CATALOG, PRODUCT_SET. (DPA only) | adgroup; ad; |
| ad_group_first_auto_bid_conversion_id | TEXT | Ad Group First Auto Bid Conversion ID | The first custom conversion ID set to this adgroup. | adgroup; ad; |
| ad_group_id | TEXT | Ad Group ID | Ad group ID. | adgroup; ad; |
| ad_group_in_stream_video_included | BOOLEAN | Ad Group In-Stream Video Included | Whether this adgroup is in-stream type or not. | adgroup; ad; |
| ad_group_modified_date | DATE | Ad Group Modified Date | The last modified date in ad account timezone. | adgroup; ad; |
| ad_group_name | TEXT | Ad Group Name | Ad group name. | adgroup; ad; |
| ad_group_product_set_id | TEXT | Ad Group Product Set ID | The product set ID. (DPA only) | adgroup; ad; |
| ad_group_removed_date | DATE | Ad Group Removed Date | The removed date in ad account timezone. | adgroup; ad; |
| ad_group_rnf_end_date | DATE | Ad Group RNF End Date | Reach's end date in ad account timezone. | adgroup; ad; |
| ad_group_rnf_frequency | NUMERIC | Ad Group RNF Frequency | Reach's frequency cap. | adgroup; ad; |
| ad_group_rnf_frequency_interval | NUMERIC | Ad Group RNF Frequency Interval | Reach's frequency interval. Time interval which frequency resets for the ad group. | adgroup; ad; |
| ad_group_rnf_start_date | DATE | Ad Group RNF Start Date | Reach's start date in ad account timezone. | adgroup; ad; |
| ad_group_status | TEXT | Ad Group Status | Ad group status. Possible values are ACTIVE, PAUSED, REMOVED. | adgroup; ad; |
| ad_id | TEXT | Ad ID | Ad ID. | ad; |
| ad_imp_track_url | TEXT | Ad Impression Track URL | The impression tracking URL of Nielsen, Flashtalking and Cinarra. | ad; |
| ad_modified_date | DATE | Ad Modified Date | The last modified date in ad account timezone. | ad; |
| ad_name | TEXT | Ad Name | Ad name. | ad; |
| ad_removed_date | DATE | Ad Removed Date | The removed date in ad account timezone. | ad; |
| ad_view_track_url | TEXT | Ad View Track URL | The URL for measuring view through conversion of ad. It is shown as Impression URL at the management site. | ad; |
| add_to_carts | NUMERIC | Add To Carts | The number of adding to cart. | campaign; adgroup; ad; |
| add_to_carts_with_engagement_view | NUMERIC | Add To Carts (Engagement View) | The number of adding to cart with engagement view (ALL). | campaign; adgroup; ad; |
| campaign | TEXT | Campaign Name | Campaign name. | campaign; adgroup; ad; |
| campaign_active_cbo | BOOLEAN | Campaign Active CBO | Campaign active budget optimization. | campaign; adgroup; ad; |
| campaign_bid_strategy | TEXT | Campaign Bid Strategy | Bidding strategy for campaign budget optimization. Possible values are LOWEST_COST (no limit; expend daily budget as aggressively as possible), COST_CAP (set a target event cost cap), TARGET_COST (set target event cost). | campaign; adgroup; ad; |
| campaign_created_date | DATE | Campaign Created Date | The created date in ad account timezone. | campaign; adgroup; ad; |
| campaign_daily_budget_micro | NUMERIC | Campaign Daily Budget Micro | Daily budget in micros and in ad account currency. | campaign; adgroup; ad; |
| campaign_delivery_status | TEXT | Campaign Delivery Status | The status of delivery ad. Possible values are ACTIVE, PAUSED, REMOVED, NOT_DELIVERING, NOT_APPROVED. | campaign; adgroup; ad; |
| campaign_end_date | DATE | Campaign End Date | The date of suspending delivering ads in ad account timezone. | campaign; adgroup; ad; |
| campaign_id | TEXT | Campaign ID | Campaign ID. | campaign; adgroup; ad; |
| campaign_modified_date | DATE | Campaign Modified Date | The last modified date in ad account timezone. | campaign; adgroup; ad; |
| campaign_objective | TEXT | Campaign objective | Campaign objective. Possible values are VISIT_MY_WEBSITE, APP_INSTALL, APP_ENGAGEMENT, WEBSITE_CONVERSION, DYNAMIC_PRODUCT, GAIN_FRIENDS, VIDEO_VIEW. | campaign; adgroup; ad; |
| campaign_removed_date | DATE | Campaign Removed Date | The removed date in ad account timezone. | campaign; adgroup; ad; |
| campaign_spending_limit_micro | NUMERIC | Campaign Spending Limit Micro | The spending limit of this campaign in micros and in ad account currency. Campaigns that reach their spending limit will be paused automatically. | campaign; adgroup; ad; |
| campaign_spending_limit_type | TEXT | Campaign Spending Limit Type | The type of spending limit. Possible values are NONE (no spending limit), MONTHLY (spending limit is monthly budget), LIFETIME (spending limit is total budget). | campaign; adgroup; ad; |
| campaign_start_date | DATE | Campaign Start Date | The date of starting to delivery ads in ad account timezone. | campaign; adgroup; ad; |
| campaign_status | TEXT | Campaign Status | Campaign status. Possible values are ACTIVE, PAUSED, REMOVED. | campaign; adgroup; ad; |
| clicks | NUMERIC | clicks | Clicks. | campaign; adgroup; ad; |
| conversions | NUMERIC | Conversions | Conversions. | campaign; adgroup; ad; |
| conversions_add_to_cart | NUMERIC | Conversions (Add To Cart) | The number of Conversion Add To Cart events. | campaign; adgroup; ad; |
| conversions_api | NUMERIC | Conversions API | Conversions API. | campaign; adgroup; ad; |
| conversions_complete_registration | NUMERIC | Conversions (Complete Registration) | The number of Conversion Complete Registration (ALL) events. | campaign; adgroup; ad; |
| conversions_complete_reservation | NUMERIC | Conversions (Complete Reservation) | The number of Conversion Complete Reservation (ALL) events. | campaign; adgroup; ad; |
| conversions_generate_lead | NUMERIC | Conversions (Generate Lead) | The number of Conversion Generate Lead events. | campaign; adgroup; ad; |
| conversions_initiate_check_out | NUMERIC | Conversions (Initiate Check Out) | The number of Conversion Initiate Check Out events. | campaign; adgroup; ad; |
| conversions_purchase | NUMERIC | Conversions (Purchase) | The number of Conversion Purchase events. | campaign; adgroup; ad; |
| conversions_purchase_value | NUMERIC | Conversions Value (Purchase) | The value of Conversion Purchase events. | campaign; adgroup; ad; |
| conversions_view_item_detail | NUMERIC | Conversions (View Item Detail) | The number of Conversion View Item Detail events. | campaign; adgroup; ad; |
| conversions_with_conversions_api | NUMERIC | Conversions with Conversions API | Conversions with Conversions API. | campaign; adgroup; ad; |
| conversions_with_conversions_api_with_engagement_view | NUMERIC | Conversions with Conversions API with Engagement View | Conversions with Conversions API with Engagement View | campaign; adgroup; ad; |
| conversions_with_engagement_view_add_to_cart | NUMERIC | Conversions with Engagement View (Add To Cart) | The number of Conversion Add To Cart (ALL) events. | campaign; adgroup; ad; |
| conversions_with_engagement_view_complete_registration | NUMERIC | Conversions with Engagement View (Complete Registration) | The number of Conversion Complete Registration (ALL) events. | campaign; adgroup; ad; |
| conversions_with_engagement_view_complete_reservation | NUMERIC | Conversions with Engagement View (Complete Reservation) | The number of Conversion Complete Reservation (ALL) events. | campaign; adgroup; ad; |
| conversions_with_engagement_view_generate_lead | NUMERIC | Conversions with Engagement View (Generate Lead) | The number of Conversion Generate Lead (ALL) events. | campaign; adgroup; ad; |
| conversions_with_engagement_view_initiate_check_out | NUMERIC | Conversion with Engagement View (Initiate Check Out) | The number of Conversion Initiate Check Out (ALL) events. | campaign; adgroup; ad; |
| conversions_with_engagement_view_purchase | NUMERIC | Conversions with Engagement View (Purchase) | The number of Conversion Purchase (ALL) events | campaign; adgroup; ad; |
| conversions_with_engagement_view_view_item_detail_conversions | NUMERIC | Conversions with Engagement View (View Item Detail) | The number of Conversion View Item Detail (ALL) events | campaign; adgroup; ad; |
| cost | NUMERIC | Cost | Cost. | campaign; adgroup; ad; |
| cost_per_video_completion | NUMERIC | Cost Per Video Completion | Cost per video completion. | campaign; adgroup; ad; |
| cost_per_video_view_3s | NUMERIC | Cost Per Video 3s Views | Cost per 3 seconds video view. | campaign; adgroup; ad; |
| cpa | NUMERIC | CPA | CPA. | campaign; adgroup; ad; |
| cpa_add_to_cart | NUMERIC | CPA (Add To Cart) | The number of CPA in Conversion Add To Cart events. | campaign; adgroup; ad; |
| cpa_add_to_carts | NUMERIC | CPA (Add To Carts) | Add to cart CPA | campaign; adgroup; ad; |
| cpa_add_to_carts_with_engagement_view | NUMERIC | CPA (Add To Carts) (Engagement View) | Add to cart CPA with engagement view (ALL). | campaign; adgroup; ad; |
| cpa_complete_registration | NUMERIC | CPA (Complete Registration) | The number of CPA in Conversion Complete Registration events. | campaign; adgroup; ad; |
| cpa_complete_reservation | NUMERIC | CPA (Complete Reservation) | The number of CPA in Conversion Complete Reservation events. | campaign; adgroup; ad; |
| cpa_conversions_with_conversions_api | NUMERIC | CPA (Conversions with Conversions API) | The number of CPA in Conversions with Conversions API. | campaign; adgroup; ad; |
| cpa_conversions_with_conversions_api_with_engagement_view | NUMERIC | CPA (Conversions with Conversions API with Engagement View) | The number of CPA in Conversions with Conversions API with Engagement View. | campaign; adgroup; ad; |
| cpa_conversions_with_engagement_view_add_to_cart | NUMERIC | CPA (Conversions with Engagement View) (Add To Cart) | The number of CPA in Conversion Add To Cart (ALL) events. | campaign; adgroup; ad; |
| cpa_conversions_with_engagement_view_complete_registration | NUMERIC | CPA (Conversions with Engagement View) (Complete Registration) | The number of CPA in Conversion Complete Registration (ALL) events. | campaign; adgroup; ad; |
| cpa_conversions_with_engagement_view_complete_reservation | NUMERIC | CPA (Conversions with Engagement View) (Complete Reservation) | The number of CPA in Conversion Complete Reservation (ALL) events. | campaign; adgroup; ad; |
| cpa_conversions_with_engagement_view_generate_lead | NUMERIC | CPA (Conversions with Engagement View) (Generate Lead) | The number of CPA in Conversion Generate Lead (ALL) events. | campaign; adgroup; ad; |
| cpa_conversions_with_engagement_view_initiate_check_out | NUMERIC | CPA (Conversions with Engagement View) (Initiate Check Out) | The number of CPA in Conversion Initiate Check Out (ALL) events. | campaign; adgroup; ad; |
| cpa_conversions_with_engagement_view_purchase | NUMERIC | CPA (Conversions with Engagement View) (Purchase) | The number of CPA in Conversion Purchase (ALL) events. | campaign; adgroup; ad; |
| cpa_conversions_with_engagement_view_view_item_detail | NUMERIC | CPA (Conversions with Engagement View) (View Item Detail) | The number of CPA in Conversion View Item Detail (ALL) events. | campaign; adgroup; ad; |
| cpa_generate_lead | NUMERIC | CPA (Generate Lead) | The number of CPA in Conversion Generate Lead events. | campaign; adgroup; ad; |
| cpa_initiate_check_out | NUMERIC | CPA (Initiate Check Out) | The number of CPA in Conversion Initiate Check Out events. | campaign; adgroup; ad; |
| cpa_installs | NUMERIC | CPA (Installs) | Install CPA. | campaign; adgroup; ad; |
| cpa_installs_total | NUMERIC | CPA (Installs) (Total) | Install CPA (click + view). (JP only) | campaign; adgroup; ad; |
| cpa_installs_total_with_engagement_view | NUMERIC | CPA (Installs) (Total with Engagement View) | Install CPA (click + view + engagement view). (JP only) | campaign; adgroup; ad; |
| cpa_levels_achieved | NUMERIC | CPA (Levels Achieved) | Level achieved CPA. | campaign; adgroup; ad; |
| cpa_levels_achieved_with_engagement_view | NUMERIC | CPA (Levels Achieved) (Engagement View) | Level achieved CPA with engagement view (ALL). | campaign; adgroup; ad; |
| cpa_opens | NUMERIC | CPA (Opens) | Open CPA | campaign; adgroup; ad; |
| cpa_opens_with_engagement_view | NUMERIC | CPA (Opens) (Engagement View) | Open CPA with engagement view (ALL). | campaign; adgroup; ad; |
| cpa_purchase | NUMERIC | CPA (Purchase) | The number of CPA in Conversion Purchase events. | campaign; adgroup; ad; |
| cpa_purchases | NUMERIC | CPA (Purchases) | Purchase CPA. | campaign; adgroup; ad; |
| cpa_purchases_with_engagement_view | NUMERIC | CPA (Purchases) (Engagement View) | Purchase CPA with engagement view (ALL). | campaign; adgroup; ad; |
| cpa_searches | NUMERIC | CPA (Searches) | Search CPA. | campaign; adgroup; ad; |
| cpa_searches_with_engagement_view | NUMERIC | CPA (Searches) (Engagement View) | Search CPA with engagement view (ALL). | campaign; adgroup; ad; |
| cpa_skad_installs | NUMERIC | CPA (Installs) (SKAdNetwork) | Install CPA measured by SKAdNetwork. | campaign; adgroup; ad; |
| cpa_tutorials_completed | NUMERIC | CPA (Tutorials Completed) | Tutorial completed CPA. | campaign; adgroup; ad; |
| cpa_tutorials_completed_with_engagement_view | NUMERIC | CPA (Tutorials Completed) (Engagement View) | Tutorial completed CPA with engagement view (ALL). | campaign; adgroup; ad; |
| cpa_view_item_detail | NUMERIC | CPA (View Item Detail) | The number of CPA in Conversion View Item Detail events. | campaign; adgroup; ad; |
| cpa_views_category | NUMERIC | CPA (Views (Category)) | View category CPA. | campaign; adgroup; ad; |
| cpa_views_category_with_engagement_view | NUMERIC | CPA (Views (Category)) (Engagement View) | View category CPA with engagement view (ALL). | campaign; adgroup; ad; |
| cpa_views_home | NUMERIC | CPA (Views (Home)) | View home CPA. | campaign; adgroup; ad; |
| cpa_views_home_with_engagement_view | NUMERIC | CPA (Views (Home)) (Engagement View) | View home CPA with engagement view (ALL). | campaign; adgroup; ad; |
| cpa_views_item | NUMERIC | CPA (Views (Item)) | View item CPA. | campaign; adgroup; ad; |
| cpa_views_item_with_engagement_view | NUMERIC | CPA (Views (Item)) (Engagement View) | View item CPA with engagement view(ALL). | campaign; adgroup; ad; |
| cpc | NUMERIC | CPC | CPC. | campaign; adgroup; ad; |
| cpm | NUMERIC | CPM | CPM. | campaign; adgroup; ad; |
| ctr | PERCENT | CTR | CTR. | campaign; adgroup; ad; |
| currency | TEXT | Currency | The currency of statistics. | campaign; adgroup; ad; |
| cvr | NUMERIC | CVR | CVR. | campaign; adgroup; ad; |
| cvr_add_to_cart | NUMERIC | CVR (Add To Cart) | The number of CVR in Conversion Add To Cart events. | campaign; adgroup; ad; |
| cvr_add_to_carts | NUMERIC | CVR (Add To Carts) | Add to cart CVR. | campaign; adgroup; ad; |
| cvr_add_to_carts_with_engagement_view | NUMERIC | CVR (Add To Carts) (Engagement View) | Add to cart CVR with engagement view (ALL). | campaign; adgroup; ad; |
| cvr_complete_registration | NUMERIC | CVR (Complete Registration) | The number of CVR in Conversion Complete Registration events. | campaign; adgroup; ad; |
| cvr_complete_reservation | NUMERIC | CVR (Complete Reservation) | The number of CVR in Conversion Complete Reservation events. | campaign; adgroup; ad; |
| cvr_conversions_with_conversions_api | NUMERIC | CVR (Conversions with Conversions API) | The number of CVR in Conversions with Conversions API. | campaign; adgroup; ad; |
| cvr_conversions_with_conversions_api_with_engagement_view | NUMERIC | CVR (Conversions with Conversions API with Engagement View) | The number of CVR in Conversions with Conversions API with Engagement View. | campaign; adgroup; ad; |
| cvr_conversions_with_engagement_view_add_to_cart | NUMERIC | CVR (Conversions with Engagement View) (Add To Cart) | The number of CVR in Conversion Add To Cart (ALL) events. | campaign; adgroup; ad; |
| cvr_conversions_with_engagement_view_complete_registration | NUMERIC | CVR (Conversions with Engagement View) (Complete Registration) | The number of CVR in Conversion Complete Registration (ALL) events. | campaign; adgroup; ad; |
| cvr_conversions_with_engagement_view_complete_reservation | NUMERIC | CVR (Conversions with Engagement View) (Complete Reservation) | The number of CVR in Conversion Complete Reservation (ALL) events. | campaign; adgroup; ad; |
| cvr_conversions_with_engagement_view_generate_lead | NUMERIC | CVR (Conversions with Engagement View) (Generate Lead) | The number of CVR in Conversion Generate Lead (ALL) events. | campaign; adgroup; ad; |
| cvr_conversions_with_engagement_view_initiate_check_out | NUMERIC | CVR (Conversions with Engagement View) (Initiate Check Out) | The number of CVR in Conversion Initiate Check Out (ALL) events. | campaign; adgroup; ad; |
| cvr_conversions_with_engagement_view_purchase | NUMERIC | CVR (Conversions with Engagement View) (Purchase) | The number of CVR in Conversion Purchase (ALL) events. | campaign; adgroup; ad; |
| cvr_conversions_with_engagement_view_view_item_detail | NUMERIC | CVR (Conversions with Engagement View) (View Item Detail) | The number of CVR in Conversion View Item Detail (ALL) events. | campaign; adgroup; ad; |
| cvr_generate_lead | NUMERIC | CVR (Generate Lead) | The number of CVR in Conversion Generate Lead events. | campaign; adgroup; ad; |
| cvr_initiate_check_out | NUMERIC | CVR (Initiate Check Out) | The number of CVR in Conversion Initiate Check Out events. | campaign; adgroup; ad; |
| cvr_installs | NUMERIC | CVR (Installs) | Install CVR. | campaign; adgroup; ad; |
| cvr_installs_total_with_engagement_view | NUMERIC | CVR (Installs) (Total with Engagement View) | Install CVR (click + view + engagement view). | campaign; adgroup; ad; |
| cvr_levels_achieved | NUMERIC | CVR (Levels Achieved) | Level achieved CVR. | campaign; adgroup; ad; |
| cvr_levels_achieved_with_engagement_view | NUMERIC | CVR (Levels Achieved) (Engagement View) | Level achieved CVR with engagement view (ALL). | campaign; adgroup; ad; |
| cvr_opens | NUMERIC | CVR (Opens) | Open CVR. | campaign; adgroup; ad; |
| cvr_opens_with_engagement_view | NUMERIC | CVR (Opens) (Engagement View) | Open CVR with engagement view (ALL). | campaign; adgroup; ad; |
| cvr_purchase | NUMERIC | CVR (Purchase) | The number of CVR in Conversion Purchase events. | campaign; adgroup; ad; |
| cvr_purchases | NUMERIC | CVR (Purchases) | Purchase CVR. | campaign; adgroup; ad; |
| cvr_purchases_with_engagement_view | NUMERIC | CVR (Purchases) (Engagement View) | Purchase CVR with engagement view (ALL). | campaign; adgroup; ad; |
| cvr_searches | NUMERIC | CVR (Searches) | Search CVR. | campaign; adgroup; ad; |
| cvr_searches_with_engagement_view | NUMERIC | CVR (Searches) (Engagement View) | Search CVR with engagement view (ALL). | campaign; adgroup; ad; |
| cvr_skad_installs | NUMERIC | CVR (Installs) (SKAdNetwork) | Install CVR measured by SKAdNetwork. | campaign; adgroup; ad; |
| cvr_tutorials_completed | NUMERIC | CVR (Tutorials Completed) | Tutorial completed CVR. | campaign; adgroup; ad; |
| cvr_tutorials_completed_with_engagement_view | NUMERIC | CVR (Tutorials Completed) (Engagement View) | Tutorial completed CVR with engagement view (ALL). | campaign; adgroup; ad; |
| cvr_view_item_detail | NUMERIC | CVR (View Item Detail) | The number of CVR in Conversion View Item Detail events. | campaign; adgroup; ad; |
| cvr_views_category | NUMERIC | CVR (Views (Category)) | View category CVR. | campaign; adgroup; ad; |
| cvr_views_category_with_engagement_view | NUMERIC | CVR (Views (Category)) (Engagement View) | View category CVR with engagement view (ALL). | campaign; adgroup; ad; |
| cvr_views_home | NUMERIC | CVR (Views (Home)) | View home CVR. | campaign; adgroup; ad; |
| cvr_views_home_with_engagement_view | NUMERIC | CVR (Views (Home)) (Engagement View) | View home CVR with engagement view (ALL). | campaign; adgroup; ad; |
| cvr_views_item | NUMERIC | CVR (Views (Item)) | View item CVR. | campaign; adgroup; ad; |
| cvr_views_item_with_engagement_view | NUMERIC | CVR (Views (Item)) (Engagement View) | View item CVR with engagement view(ALL). | campaign; adgroup; ad; |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| date | DATE | Date | Date. | |
| day_of_month | TEXT | Day of month | Day of the month | |
| impressions | NUMERIC | Impressions | Impressions. | campaign; adgroup; ad; |
| impressions_share_by_budget_lost_rate | NUMERIC | Impressions Share By Budget Lost Rate | The percentage of ads that couldn't be shown to users due to insufficient budget out of all display opportunities. | adgroup; |
| impressions_share_by_rank_lost_rate | NUMERIC | Impressions Share By Rank Lost Rate | The percentage of ads that couldn't be shown to users due to a low auction rank out of all display opportunities. | adgroup; |
| impressions_share_rate | NUMERIC | Impressions Share Rate | The percentage of ads actually shown to users out of all display opportunities. | adgroup; |
| installs | NUMERIC | Installs | Install count. | campaign; adgroup; ad; |
| installs_total | NUMERIC | Installs (Total) | Install count (click + view). (JP only) | campaign; adgroup; ad; |
| installs_total_with_engagement_view | NUMERIC | Installs (Total with Engagement View) | Install count (click + view + engagement view). (JP only) | campaign; adgroup; ad; |
| installs_view | NUMERIC | Installs (View) | Installs count (view). (JP only) | campaign; adgroup; ad; |
| levels_achieved | NUMERIC | Levels Achieved | Level achieving count | campaign; adgroup; ad; |
| levels_achieved_with_engagement_view | NUMERIC | Levels Achieved (Engagement View) | Level achieving count with engagement view (ALL). | campaign; adgroup; ad; |
| month | TEXT | Month | Number of the month | |
| opens | NUMERIC | Opens | Open count. | campaign; adgroup; ad; |
| opens_with_engagement_view | NUMERIC | Opens (Engagement View) | Open count with engagement view (ALL). | campaign; adgroup; ad; |
| purchases | NUMERIC | Purchases | Purchasing count. | campaign; adgroup; ad; |
| purchases_with_engagement_view | NUMERIC | Purchases (Engagement View) | Purchasing count with engagement view (ALL). | campaign; adgroup; ad; |
| reach | NUMERIC | Reach | Reach of reach. | campaign; adgroup; ad; |
| recommended_budget_micro | NUMERIC | Recommended Budget Micro | Estimated lowest budget amount at which the campaign or the adgroup wouldn't lose any bidding opportunities due to budget constraints. Represented in micros and in the local currency of the account. | campaign; adgroup; |
| roas | PERCENT | ROAS | Return on ads spend for purchase event. | campaign; adgroup; ad; |
| searches | NUMERIC | Searches | Search count. | campaign; adgroup; ad; |
| searches_with_engagement_view | NUMERIC | Searches (Engagement View) | Search count with engagement view (ALL). | campaign; adgroup; ad; |
| skad_installs | NUMERIC | Installs (SKAdNetwork) | Install count measured by SKAdNetwork. | campaign; adgroup; ad; |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| tutorials_completed | NUMERIC | Tutorials Completed | Tutorial completion count. | campaign; adgroup; ad; |
| tutorials_completed_with_engagement_view | NUMERIC | Tutorials Completed (Engagement View) | Tutorial completion count with engagement view (ALL). | campaign; adgroup; ad; |
| video_starts | NUMERIC | Video Starts | Video play start. | campaign; adgroup; ad; |
| video_views_100 | NUMERIC | Video 100% Views (completions) | Video 100% watched. | campaign; adgroup; ad; |
| video_views_25 | NUMERIC | Video 25% Views | Video 25% watched. (JP only) | campaign; adgroup; ad; |
| video_views_3s | NUMERIC | Video 3s Views | Video watched for at least 3 seconds. (JP only) | campaign; adgroup; ad; |
| video_views_50 | NUMERIC | Video 50% Views | Video 50% watched. (JP only) | campaign; adgroup; ad; |
| video_views_75 | NUMERIC | Video 75% Views | Video 75% watched. (JP only) | campaign; adgroup; ad; |
| video_views_95 | NUMERIC | Video 95% Views | Video 95% watched. (JP only) | campaign; adgroup; ad; |
| viewable_impressions | NUMERIC | Viewable Impressions | Viewable impressions. | campaign; adgroup; ad; |
| views_category | NUMERIC | Views (Category) | The number of viewing category. | campaign; adgroup; ad; |
| views_category_with_engagement_view | NUMERIC | views (Category) (Engagement View) | The number of viewing category with engagement view conversion | campaign; adgroup; ad; |
| views_home | NUMERIC | Views (Home) | The number of viewing home. | campaign; adgroup; ad; |
| views_home_with_ev | NUMERIC | Views (Home) (Engagement View) | The number of viewing home with engagement view (ALL). | campaign; adgroup; ad; |
| views_item | NUMERIC | Views (Item) | The number of viewing item | campaign; adgroup; ad; |
| views_item_with_engagement_view | NUMERIC | Views (Item) (Engagement View) | The number of viewing item with engagement view (ALL). | campaign; adgroup; ad; |
| week | TEXT | Week | Week (Sun-Sat). | |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
| year | TEXT | Year | Year | |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
| year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |