Google Ad Manager Connector Reference

62 metrics76 dimensions

Fields

https://connectors.windsor.ai/google_ad_manager?api_key=[your API key]&date_preset=last_7d&fields=campaign,clicks,spend,impressions,date,source&_renderer=csv

The Google Ad Manager connector exposes 138 fields (62 metrics, 76 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Google Ad Manager Fields

The Google Ad Manager connector includes 138 fields.

Google Ad Manager fields (account_id to creative_preview_url)

ID	Type	Name	Description
account_id	TEXT	Account ID	Breaks down reporting data by advertising company Company ID. Can be used to filter by Company.id. Compatible with any of the following report types: Historical, Future sell-through, Reach, Ad speed.
account_name	TEXT	Account name	Breaks down reporting data by advertising company. Company.name and Company.id are automatically included as columns in the report. Can be used to filter by Company.name. Corresponds to "Advertiser" in the Ad Manager UI. Compatible with any of the following report types: Historical, Future sell-through, Reach, Ad speed.
ad_exchange_cpc	NUMERIC	Ad Exchange CPC	The cost-per-click generated by mapped Ad Exchange properties. Corresponds to "CPC" in the Ad Manager UI. Compatible with the "Ad Exchange historical" report type.
ad_exchange_line_item_average_ecpm	PERCENT	Ad Exchange average eCPM	The average estimated cost-per-thousand-impressions earned from the delivery of Ad Exchange ads for line item-level dynamic allocation. Compatible with the 'Historical' report type.
ad_exchange_line_item_clicks	NUMERIC	Ad Exchange clicks	The number of clicks an Ad Exchange ad delivered for line item-level dynamic allocation. Compatible with the 'Historical' report type.
ad_exchange_line_item_clicks_percent	PERCENT	Ad Exchange clicks (%)	The ratio of the number of clicks delivered to the total clicks delivered by Ad Exchange for line item-level dynamic allocation. Represented as a percentage. Compatible with the 'Historical' report type.
ad_exchange_line_item_ctr	NUMERIC	Ad Exchange CTR	The ratio of clicks an Ad Exchange ad delivered to the number of impressions it delivered for line item-level dynamic allocation. Compatible with the 'Historical' report type.
ad_exchange_line_item_impressions_percent	PERCENT	Ad Exchange impressions (%)	The ratio of the number of impressions delivered to the total impressions delivered by Ad Exchange for line item-level dynamic allocation. Represented as a percentage. Compatible with the 'Historical' report type.
ad_exchange_line_item_revenue	NUMERIC	Ad Exchange revenue	Revenue generated from Ad Exchange ads delivered for line item-level dynamic allocation. Represented in publisher currency and time zone. Compatible with the 'Historical' report type.
ad_exchange_line_item_revenue_percent	PERCENT	Ad Exchange revenue (%)	The ratio of revenue generated by Ad Exchange to the total revenue earned by CPM and CPC ads delivered for line item-level dynamic allocation. Represented as a percentage. Compatible with the 'Historical' report type.
ad_exchange_line_item_revenue_percent_cpd	PERCENT	Ad Exchange revenue with CPD (%)	The ratio of revenue generated by Ad Exchange to the total revenue earned by CPM, CPC and CPD ads delivered for line item-level dynamic allocation. Represented as a percentage.Compatible with the 'Historical' report type.
ad_exchange_line_item_targeted_clicks	NUMERIC	Ad Exchange targeted clicks	The number of clicks an Ad Exchange ad delivered for line item-level dynamic allocation by explicit custom criteria targeting. Compatible with the 'Historical' report type.
ad_exchange_line_item_targeted_impressions	NUMERIC	Ad Exchange targeted impressions	The number of impressions an Ad Exchange ad delivered for line item-level dynamic allocation by explicit custom criteria targeting. Compatible with the 'Historical' report type.
ad_network_id	TEXT	Ad network id	The network that provided the ad for SDK ad mediation. If selected for a report, that report will include only SDK mediation ads and will not contain non-SDK mediation ads. SDK mediation ads are ads for mobile devices. They have a list of ad networks which can provide ads to serve. Not every ad network will have an ad to serve so the device will try each network one-by-one until it finds an ad network with an ad to serve. The ad network that ends up serving the ad will appear here. Note that this id does not correlate to anything in the companies table and is not the same id as is served by ADVERTISER_ID. Compatible with any of the following report types: Historical, Reach.
ad_network_name	TEXT	Ad network name	Name of the ad network.
ad_server_all_revenue	NUMERIC	Ad Server All Revenue	The CPM, CPC and CPD revenue earned, calculated in publisher currency, for the ads delivered by the ad server. Can correspond to any of the following in the Ad Manager UI: Ad server CPM, CPC, CPD, and vCPM revenue, Ad server CPM, CPC and CPD revenue. Compatible with the "Historical" report type.
ad_server_average_viewable_seconds	NUMERIC	Ad server average viewable seconds	Active View ad server average time in seconds that specific impressions are reported as being viewable. Corresponds to "Ad Server Active View Average Viewable Time (seconds)" in the Ad Manager UI. Compatible with the 'Historical' report type.
ad_server_clicks	NUMERIC	Ad server clicks	The number of clicks delivered by the ad server.
ad_server_ctr	PERCENT	Ad server CTR	The CTR for an ad delivered by the ad server.
ad_server_eligible_impressions	NUMERIC	Ad server eligible impressions	Total number of impressions delivered by the ad server that were eligible to measure viewability. Corresponds to "Ad server Active View eligible impressions" in the Ad Manager UI. Compatible with the 'Historical' report type.
ad_server_impressions	NUMERIC	Ad server impressions	The number of impressions delivered by the ad server.
ad_server_measurable_impressions	NUMERIC	Ad server measurable impressions	The number of impressions delivered by the ad server that were sampled, and measurable by active view. Corresponds to "Ad server Active View measurable impressions" in the Ad Manager UI. Compatible with the 'Historical' report type.
ad_server_measurable_impressions_rate	NUMERIC	Ad server measurable impressions rate	The percentage of impressions delivered by the ad server that were measurable by active view (out of all the ad server impressions sampled for active view). Corresponds to "Ad server Active View % measurable impressions" in the Ad Manager UI. Compatible with the 'Historical' report type.
ad_server_targeted_impressions	NUMERIC	Ad server targeted impressions	The number of impressions delivered by the ad server by explicit custom criteria targeting.
ad_server_viewable_impressions	NUMERIC	Ad server viewable impressions	The number of impressions delivered by the ad server viewed on the user's screen. Corresponds to "Ad server Active View viewable impressions" in the Ad Manager UI. Compatible with the 'Historical' report type.
ad_server_viewable_impressions_rate	NUMERIC	Ad server viewable impressions rate	The percentage of impressions delivered by the ad server viewed on the user's screen (out of the ad server impressions measurable by active view). Corresponds to "Ad server Active View % viewable impressions" in the Ad Manager UI. Compatible with the 'Historical' report type.
ad_unit_id	TEXT	Ad unit ID	The id of the ad unit.
ad_unit_name	TEXT	Ad unit name	The name of the ad unit.
adsense_line_item_level_impressions	NUMERIC	AdSense impressions	The number of impressions an AdSense ad delivered for line item-level dynamic allocation. Compatible with the "Historical" report type.
advertiser	TEXT	Advertiser	The name of the advertiser company assigned to an order.
advertiser_id	TEXT	Advertiser id	The id of the advertiser company assigned to an order.
campaign	TEXT	Campaign	Breaks down reporting data by placement. Placement.name and Placement.id are automatically included as columns in the report. Can be used to filter by Placement.name. Corresponds to "Placement" in the Ad Manager UI. Compatible with any of the following report types: Historical, Future sell-through, Reach.
city	CITY	City	City associated with the IP address included in the ad slot request.
clicks	NUMERIC	Clicks	The number of clicks delivered by the ad server. Corresponds to "Ad server clicks" in the Ad Manager UI. Compatible with the "Historical" report type.
country	COUNTRY	Country	Country associated to IP address from ad slot request
creative_click_through_url	TEXT	Click-through URL	Represents the click-through URL for Dimension.CREATIVE_NAME. Corresponds to "Click-through URL" in the Ad Manager UI. Compatible with the "Historical" report type.
creative_id	TEXT	Creative ID	The ID of the Creative that served to the ad slot request.
creative_image_url	IMAGE_URL	Creative image URL	Direct URL of the creative's primary image asset, fetched from CreativeService. Only populated for image creatives; null for creatives without an image asset (e.g. third-party, video or snippet creatives).
creative_name	TEXT	Creative Name	The name of the Creative that served to the ad slot request.
creative_preview_url	TEXT	Creative preview URL	URL of the creative's preview page in Ad Manager, fetched from CreativeService. Populated for all creative types.

Google Ad Manager fields (creative_size to month_and_year)

ID	Type	Name	Description
creative_size	TEXT	Creative size	Size of creative that served to the ad slot request. Creative size does not represent the actual size of a creative being served.
creative_type	TEXT	Creative type	Type of creative that served to the ad slot request.
custom_criteria	TEXT	Custom Criteria	Breaks down reporting data by custom criteria. Cannot be used for filtering; When using this Dimension, metrics for freeform key values are only reported on when they are registered with CustomTargetingService. Corresponds to 'Key-values' in the Ad Manager UI. Compatible with any of the following report types: Historical, Reach.
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
date	DATE	Date	Breaks down reporting data by date in the network time zone. Can be used to filter by date using ISO 8601's format 'YYYY-MM-DD'". Note: In v201802 and later, this dimension is compatible with the following time zone types: TimeZoneType.PUBLISHER TimeZoneType.PROPOSAL_LOCAL Corresponds to "Date" in the Ad Manager UI. Compatible with any of the following report types: Historical, Future sell-through, Reach, Ad speed.
day_of_month	TEXT	Day of month	Day of the month
domain	TEXT	Domain	Breaks down reporting data by top private domain. Corresponds to "Domain" in the Ad Manager UI. Compatible with any of the following report types: Historical, Reach.
impressions	NUMERIC	Impressions	The number of impressions an AdSense ad delivered for line item-level dynamic allocation. Corresponds to "AdSense impressions" in the Ad Manager UI. Compatible with the "Historical" report type.
line_item_average_number_of_viewers	TEXT	Nielsen Average Number Of Viewers (Line item)	Corresponds to 'Nielsen Average Number Of Viewers' in the Ad Manager UI. Compatible with any of the following report types: Historical, Reach.
line_item_contracted_quantity	TEXT	Contracted quantity (Line item)	Represents the LineItem.contractedUnitsBought quantity for Dimension.LINE_ITEM_NAME.
line_item_cost_per_unit	NUMERIC	Line Item Cost Per Unit	Represents Line Item cost per unit for Line item name. Corresponds to 'Rate' in the Ad Manager UI
line_item_cost_type	TEXT	Cost type (Line item)	Represents LineItem.costType for Dimension.LINE_ITEM_NAME. Can be used for filtering.
line_item_creative_end_date	DATE	Creative end date (Line item)	Represents a LineItemCreativeAssociation.endDateTime for a Dimension.LINE_ITEM_NAME and a Dimension.CREATIVE_NAME. Includes the date without the time.
line_item_creative_start_date	DATE	Creative start date (Line item)	Represents a LineItemCreativeAssociation.startDateTime for a Dimension.LINE_ITEM_NAME and a Dimension.CREATIVE_NAME. Includes the date without the time.
line_item_currency_code	TEXT	Currency code (Line item)	Represents the 3 letter currency code for Dimension.LINE_ITEM_NAME.
line_item_delivery_indicator	TEXT	Line item delivery Indicator	Indicates the progress made for the delivery of the line item.
line_item_delivery_pacing	TEXT	Line item delivery pacing	Represents delivery rate type for the line item.
line_item_discount	TEXT	Discount (Line item)	Represents the LineItem.discount for Dimension.LINE_ITEM_NAME. The number is either a percentage or an absolute value depending on LineItem.discountType.
line_item_end_date_time	DATE	Line item end date	Represents the end date (in YYYY-MM-DD format) for Dimension.LINE_ITEM_NAME. Can be used for filtering.
line_item_external_id	TEXT	External Line Item ID	Represents LineItem.externalId for Dimension.LINE_ITEM_NAME. Can be used for filtering.
line_item_frequency_cap	TEXT	Frequency cap (Line item)	Represents LineItem.frequencyCaps as a comma separated list of 'FrequencyCap.maxImpressions impressions per/every FrequencyCap.numTimeUnits FrequencyCap.timeUnit' (e.g. '10 impressions every day,500 impressions per lifetime') for Dimension.LINE_ITEM_NAME.
line_item_goal_quantity	TEXT	Line Item Goal Quantity	The total number of impressions, clicks or days that is reserved for Line item name.
line_item_id	TEXT	Line item ID	The id of the line item associated to the Creative that served to the ad slot request.
line_item_label_ids	TEXT	Line item label IDs	Represents LineItem.effectiveAppliedLabels as a comma separated list of Label.id for Dimension.LINE_ITEM_NAME.
line_item_labels	TEXT	Line item labels	Represents LineItem.effectiveAppliedLabels as a comma separated list of Label.name for Dimension.LINE_ITEM_NAME.
line_item_last_reconciliation_date_time	TEXT	Line item last reconciliation time	Represents the monthly last reconciliation date time of the line item for Dimension.LINE_ITEM_NAME and Dimension.MONTH_YEAR.
line_item_lifetime_clicks	TEXT	Line item lifetime clicks	The total number of clicks delivered over the lifetime of a Dimension.LINE_ITEM_NAME.
line_item_lifetime_impressions	TEXT	Line item lifetime impressions	The total number of impressions delivered over the lifetime of a Dimension.LINE_ITEM_NAME.
line_item_name	TEXT	Line item name	The name of the line item associated to the Creative that served to the ad slot request.
line_item_non_cpd_booked_revenue	NUMERIC	Line Item Non CPD Booked Revenue	The cost of booking for a non-CPD Line item name.
line_item_optimizable	TEXT	Line item Optimizable	Generated as true for Dimension.LINE_ITEM_NAME which is eligible for optimization, false otherwise. Can be used for filtering.
line_item_priority	TEXT	Line Item Priority	Represents Line item priority for Line item name as a valuebetween 1 and 16. Can be used for filtering.
line_item_reconciliation_status	TEXT	Line item reconciliation status	Represents the monthly reconciliation status of the line item for Dimension.LINE_ITEM_NAME and Dimension.MONTH_YEAR.
line_item_sponsorship_goal_percentage	PERCENT	Sponsorship goal (%) (Line item)	The ratio between the goal quantity for Dimension.LINE_ITEM_NAME of LineItemType.SPONSORSHIP and the LINE_ITEM_GOAL_QUANTITY. Represented as a number between 0..100.
line_item_start_date_time	DATE	Line item start date	Represents the start date (in YYYY-MM-DD format) for Dimension.LINE_ITEM_NAME. Can be used for filtering.
line_item_type	TEXT	Line item type	Type of line item associated to the Creative that served to the ad slot request.
metro	TEXT	Metro	Metro (DMA) area associated with the IP address included in the ad slot request.
month	TEXT	Month	Number of the month
month_and_year	TEXT	Month and year	Breaks down reporting data by month and year in the network time zone. Can be used to filter on month using ISO 4601 format 'YYYY-MM'. Note: In v201802 and later, this dimension is compatible with the following time zone types: TimeZoneType.PUBLISHER TimeZoneType.PROPOSAL_LOCAL Corresponds to "Month and year" in the Ad Manager UI. Compatible with any of the following report types: Historical, Future sell-through, Reach, Partner finance.

Google Ad Manager fields (now to video_viewership_completion_rate)

ID	Type	Name	Description
now	TIMESTAMP	Now	Current timestamp
order_delivery_status	TEXT	Order delivery status	Delivery status of the order. Not available as a dimension to report on, but exists as a dimension in order to filter on it using PQL. Valid values are 'STARTED', 'NOT_STARTED' and 'COMPLETED'. Compatible with any of the following report types: Historical, Reach.
order_end_date	DATE	Order end date	Represents the end date (in YYYY-MM-DD format) for Dimension.ORDER_NAME. Corresponds to "Order end date" in the Ad Manager UI. Compatible with any of the following report types: Historical, Future sell-through, Reach, Ad speed.
order_id	TEXT	Order ID	The id of the Order associated to the line item linked to the Creative that served to the ad slot request.
order_name	TEXT	Order name	The name of the Order associated to the line item linked to the Creative that served to the ad slot request.
order_start_date	DATE	Order start date	Represents the start date (in YYYY-MM-DD format) for Dimension.ORDER_NAME. Corresponds to "Order start date" in the Ad Manager UI. Compatible with any of the following report types: Historical, Future sell-through, Reach, Ad speed.
placement_id	TEXT	Placement ID	The id of the placement that currently includes an ad unit associated with an impression, click, or other event.
placement_name	TEXT	Placement name	Name of the placement that currently includes an ad unit associated with an impression, click, or other event.
postal_code	TEXT	Postal code	Postal code associated with the IP address included in the ad slot request.
programmatic_match_rate	PERCENT	Programmatic match rate	The number of programmatic responses served divided by the number of requests eligible for programmatic. Includes Ad Exchange, Open Bidding, and Preferred Deals. Compatible with the 'Historical' report type.
region	REGION	Region	Region associated with the IP address included in the ad slot request.
sell_through_available_impressions	NUMERIC	Sell-through available impressions	The number of available impressions for future sell-through reports. This metric is available for the next 90 days with a daily break down and for the next 12 months with a monthly break down. Compatible with the "Future sell-through" report type.
sell_through_forecasted_impressions	NUMERIC	Sell-through forecasted impressions	The number of forecasted impressions for future sell-through reports. This metric is available for the next 90 days with a daily break down and for the next 12 months with a monthly break down. Compatible with the "Future sell-through" report type.
sell_through_rate	PERCENT	Sell-through rate	The sell-through rate for impressions for future sell-through reports. This metric is available for the next 90 days with a daily break down and for the next 12 months with a monthly break down. Compatible with the "Future sell-through" report type.
sell_through_reserved_impressions	NUMERIC	Sell-through reserved impressions	The number of reserved impressions for future sell-through reports. This metric is available for the next 90 days with a daily break down and for the next 12 months with a monthly break down. Compatible with the "Future sell-through" report type.
source	TEXT	Source	The name of the Windsor connector returning the row
spend	NUMERIC	Spend	The total CPM and CPC revenue generated by the ad servers including line item-level dynamic allocation. Corresponds to "Total CPM and CPC revenue" in the Ad Manager UI. Compatible with the "Historical" report type.
today	DATE	Today	Today's date
total_ad_requests	NUMERIC	Total ad requests	The total number of times that an ad request is sent to the ad server including dynamic allocation.
total_average_viewable_seconds	NUMERIC	Total average viewable seconds	Active View total average time in seconds that specific impressions are reported as being viewable. Corresponds to "Total Active View Average Viewable Time (seconds)" in the Ad Manager UI. Compatible with the 'Historical' report type.
total_eligible_impressions	NUMERIC	Total eligible impressions	Total number of impressions that were eligible to measure viewability. Corresponds to "Total Active View eligible impressions" in the Ad Manager UI. Compatible with the 'Historical' report type.
total_line_item_level_all_revenue	NUMERIC	Total Line Item Level All Revenue	The total CPM, CPC and CPD revenue generated by the ad servers including line item-level dynamic allocation. Can correspond to any of the following in the Ad Manager UI: Total CPM, CPC, CPD, and vCPM revenue, Total CPM, CPC and CPD revenue. Compatible with the "Historical" report type.
total_line_item_level_clicks	NUMERIC	Total clicks	The total number of clicks delivered including line item-level dynamic allocation.
total_line_item_level_cpm_and_cpc_revenue	NUMERIC	Total CPM and CPC revenue (Line item)	The total CPM and CPC revenue generated by the ad servers including line item-level dynamic allocation. Corresponds to 'Total CPM and CPC revenue' in the Ad Manager UI. Compatible with the 'Historical' report type.
total_line_item_level_ctr	NUMERIC	Total CTR	The ratio of total clicks on ads delivered by the ad servers to the total number of impressions delivered for an ad including line item-level dynamic allocation.
total_line_item_level_impressions	NUMERIC	Total impressions	The total number of impressions delivered including line item-level dynamic allocation.
total_line_item_level_targeted_clicks	NUMERIC	Total targeted clicks (Line item)	The total number of clicks delivered including line item-level dynamic allocation by explicit custom criteria targeting Corresponds to 'Total targeted clicks' in the Ad Manager UI. Compatible with the 'Historical' report type.
total_line_item_level_targeted_impressions	NUMERIC	Total targeted impressions (Line item)	The total number of impressions delivered including line item-level dynamic allocation by explicit custom criteria targeting. Corresponds to 'Total targeted impressions' in the Ad Manager UI. Compatible with the 'Historical' report type.
total_line_item_level_with_cpd_average_ecpm	NUMERIC	Total average eCPM with CPD (Line item)	Estimated cost-per-thousand-impressions (eCPM) of CPM, CPC and CPD ads delivered by the ad servers including line item-level dynamic allocation.
total_line_item_level_without_cpd_average_ecpm	NUMERIC	Total average eCPM without CPD (Line item)	Estimated cost-per-thousand-impressions (eCPM) of CPM and CPC ads delivered by the ad servers including line item-level dynamic allocation. Corresponds to 'Total average eCPM' in the Ad Manager UI. Compatible with the 'Historical' report type.
total_measurable_impressions	NUMERIC	Total measurable impressions	The total number of impressions that were sampled and measured by active view. Corresponds to "Total Active View measurable impressions" in the Ad Manager UI. Compatible with the 'Historical' report type.
total_measurable_impressions_rate	NUMERIC	Total measurable impressions rate	The percentage of total impressions that were measurable by active view (out of all the total impressions sampled for active view). Corresponds to "Total Active View % measurable impressions" in the Ad Manager UI. Compatible with the 'Historical' report type.
total_viewable_impressions	NUMERIC	Total viewable impressions	The total number of impressions viewed on the user's screen. Corresponds to "Total Active View viewable impressions" in the Ad Manager UI. Compatible with the 'Historical' report type.
total_viewable_impressions_rate	NUMERIC	Total viewable impressions rate	The percentage of total impressions viewed on the user's screen (out of the total impressions measurable by active view). Compatible with the 'Historical' report type.
totalcost	NUMERIC	Total cost	The total CPM and CPC revenue generated by the ad servers including line item-level dynamic allocation. Corresponds to "Total CPM and CPC revenue" in the Ad Manager UI. Compatible with the "Historical" report type.
url_name	TEXT	URL	Breaks down reporting data by URL name (the URL where the ad served). Corresponds to "URL" in the Ad Manager UI. Compatible with the "Historical" report type.
video_viewership_average_view_rate	NUMERIC	Video viewership Average view rate	Average percentage of the video watched by users.
video_viewership_average_view_time	NUMERIC	Video viewership Average view time	Average time(seconds) users watched the video.
video_viewership_complete	NUMERIC	Video viewership Complete	The number of times the video played to completion.
video_viewership_completion_rate	NUMERIC	Video viewership Completion rate	Percentage of times the video played to the end.

Google Ad Manager fields (video_viewership_engaged_view to year_week_iso)

ID	Type	Name	Description
video_viewership_engaged_view	NUMERIC	Video viewership Engaged view	The number of engaged views i.e. ad is viewed to completion or for 30s, whichever comes first.
video_viewership_first_quartile	NUMERIC	Video viewership First quartile	The number of times the video played to 25% of its length.
video_viewership_midpoint	NUMERIC	Video viewership midpoint	The number of times the video reached its midpoint during play.
video_viewership_start	NUMERIC	Video viewership Start	The number of impressions where the video was played.
video_viewership_third_quartile	NUMERIC	Video viewership third quartile	The number of times the video played to 75% of its length.
video_viewership_video_length	NUMERIC	Video viewership Video length	Duration of the video creative.
video_viewership_view_through_rate	NUMERIC	Video viewership View-through rate	View-through rate represented as a percentage.
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_month_name	TEXT	Year month name	Year and month with the month name written out, e.g. "Jan 2025".
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