ASKANER

Microsoft Ads (Bing Ads)

Outros · Disponível
Consultar via API
GET https://askaner.askan.com.br/api/v1/data/bing?fields=date,account_id&date_preset=last_30d
Authorization: Bearer ik_...

Campos (88 métricas, 150 dimensões)

IDTipoNaturezaDescrição
dayTEXTDimensãoEach row of the report identifies the month, day, and year when the transaction occurred. The report data will be aggregated by each day. The time period will be formatted as yyyy-mm-dd.share_of_voice, campaign_performance, ad_performance, keyword_performance, conversion_performance, budget_summary, user_location_performance, age_gender_report, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
day_of_weekTEXTDimensãoEach row of the report identifies the day of the week when the transaction occurred. The report data will be aggregated by each of the seven days in a week. The possible data values are 1 - 7 where 1 represents Sunday and 7 represents Saturday. If the report time spans multiple weeks, then the performance data across all weeks for a given day of the week will be aggregated in one row. For example if Campaign A has 5 impressions every Monday (day 2) throughout each of the 3 weeks included in the report time range, then the report will include one row with a 2 in the date column and the impressions in that row totaling 15.share_of_voice, campaign_performance, ad_performance, keyword_performance, conversion_performance, user_location_performance, age_gender_report, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
day_of_week_monTEXTDimensãoEach row of the report identifies the week when the transaction occurred. The report data will be aggregated by each week running from Monday through Sunday. The time period that contains the date of the Monday for each week will be formatted as yyyy-mm-dd. NOTE: partial data aggregation for weekly time period is not supported. If the selected dates are not full weeks and the corresponding weekly time period column is requested, the selected dates will be converted to full weeks.share_of_voice, campaign_performance, ad_performance, keyword_performance, conversion_performance, user_location_performance, age_gender_report, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
hourTEXTDimensãoEach row of the report identifies the hour when the transaction occurred. The report data will be aggregated by each hour of the day. The possible values for the hour component are 0 - 23. If the report time spans multiple days, then the performance data for a given hour will be provided separately across multiple rows i.e. the report will include one row for each unique day and hour. For example if Campaign A has 5 impressions during Hour 7 on each of the 3 days included in the report time range, then the report will include three rows each with 5 impressions for Hour 7.campaign_performance, ad_performance, keyword_performance, conversion_performance, user_location_performance, age_gender_report, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
hour_of_dayNUMERICMétricaEach row of the report identifies the hour of the day when the transaction occurred. The report data will be aggregated by each of the 24 hours across all days. The possible values are 0 - 23. If the report time spans multiple days, then the performance data across all days for a given hour will be aggregated in one row. For example if Campaign A has 5 impressions during hour 7 on each of the 3 days included in the report time range, then the report will include one row with impressions for HourOfDay totaling 15.campaign_performance, ad_performance, keyword_performance, conversion_performance, user_location_performance, age_gender_report, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
monthTEXTDimensãoEach row of the report identifies the month when the transaction occurred. The report data will be aggregated by each month. The month number will be formatted as mm, e.g. 07. NOTE: partial data aggregation for monthly time period is not supported. If the selected dates are not full months and the corresponding monthly time period column is requested, the selected dates will be converted to full months.share_of_voice, campaign_performance, ad_performance, keyword_performance, conversion_performance, user_location_performance, age_gender_report, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
summaryTEXTDimensãoThe report data will be aggregated by the entire specified report time. The report column will be equal in the format 'start_date - end_date'.share_of_voice, campaign_performance, ad_performance, keyword_performance, conversion_performance, user_location_performance, age_gender_report, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
weekTEXTDimensãoEach row of the report identifies the week when the transaction occurred. The report data will be aggregated by each week running from Sunday through Saturday. The time period that contains the date of the Sunday for each week will be formatted as yyyy-mm-dd. NOTE: partial data aggregation for weekly time period is not supported. If the selected dates are not full weeks and the corresponding weekly time period column is requested, the selected dates will be converted to full weeks.share_of_voice, campaign_performance, ad_performance, keyword_performance, conversion_performance, user_location_performance, age_gender_report, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
yearTEXTDimensãoEach row of the report identifies the year when the transaction occurred. The report data will be aggregated by each year. The time period that contains the year will be formatted as yyyy. NOTE: partial data aggregation for yearly time period is not supported. If the selected dates are not full years and the corresponding yearly time period column is requested, the selected dates will be converted to full years.share_of_voice, campaign_performance, ad_performance, keyword_performance, conversion_performance, user_location_performance, age_gender_report, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
absolute_top_impression_rate_percentPERCENTMétricaHow often your ad was in the first position of all results, as a percentage of your total impressions.share_of_voice, ad_performance, campaign_performance, keyword_performance, user_location_performance, age_gender_report, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
absolute_top_impression_share_lost_to_budgetNUMERICMétricaAbsolute Top Impression Lost To Budgetcampaign_performance
absolute_top_impression_share_lost_to_budget_percentPERCENTMétricaThe estimated percentage of how often your ad missed showing in the very top ad position, above search results, due to insufficient budget.share_of_voice, campaign_performance, ad_group_performance
absolute_top_impression_share_lost_to_rankNUMERICMétricaAbsolute Top Impression Lost To Rankcampaign_performance
absolute_top_impression_share_lost_to_rank_percentPERCENTMétricaThe estimated percentage of how often poor ad rank kept your ad from showing in the first ad position at the top of search results.share_of_voice, campaign_performance, ad_group_performance
absolute_top_impression_share_percentPERCENTMétricaThe estimated percentage of times your ad was in the first position of all results, out of the estimated number of first position impressions you were eligible to receive.share_of_voice, campaign_performance
absolute_top_impressionsNUMERICMétricaAbsolute Top Impressionsad_performance, campaign_performance, keyword_performance, user_location_performance, age_gender_report, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
account_idTEXTDimensãoThe account idshare_of_voice, ad_performance, campaign_performance, keyword_performance, conversion_performance, budget_summary, user_location_performance, age_gender_report, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance
account_nameTEXTDimensãoThe account nameshare_of_voice, ad_performance, campaign_performance, keyword_performance, conversion_performance, budget_summary, user_location_performance, age_gender_report, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
account_numberTEXTDimensãoThe Microsoft Advertising assigned number of an account.share_of_voice, ad_performance, campaign_performance, keyword_performance, conversion_performance, budget_summary, user_location_performance, age_gender_report, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
account_statusTEXTDimensãoThe account statusshare_of_voice, ad_performance, campaign_performance, keyword_performance, conversion_performance, age_gender_report, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, product_dimension_performance
ad_descriptionTEXTDimensãoThe first ad description that appears below the path in your ad.ad_performance
ad_description2TEXTDimensãoThe second ad description that appears below the path in your ad. Ad description 2 might not appear in your ad.ad_performance
ad_distributionTEXTDimensãoThe network where you want your ads to show. This can be the entire Microsoft Advertising Network, Microsoft sites and select traffic, or only partner traffic.user_location_performance, age_gender_report, dsa_auto_target_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
ad_group_current_statusTEXTDimensãoThe current ad group status.ad_group_performance
ad_group_idTEXTDimensãoThe ID of the AdGroup.share_of_voice, ad_performance, keyword_performance, conversion_performance, user_location_performance, age_gender_report, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
ad_group_nameTEXTDimensãoThe name of the AdGroup.share_of_voice, ad_performance, keyword_performance, conversion_performance, user_location_performance, age_gender_report, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
ad_group_statusTEXTDimensãoThe Ad Group status.share_of_voice, ad_performance, keyword_performance, conversion_performance, age_gender_report, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, product_dimension_performance
ad_group_typeTEXTDimensãoThe ad group type. In a Search campaign, the possible values are 'SearchDynamic' and 'SearchStandard'. The field will be empty for other campaign types.ad_group_performance
ad_idTEXTDimensãoThe ad idad_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, product_dimension_performance
ad_labelsTEXTDimensãoThe labels applied to the ad. Delimited by a semicolon (;).ad_performance
ad_long_headlineTEXTDimensãoThe longer of two possible responsive ad headlines for Audience campaigns.ad_performance
ad_path_1TEXTDimensãoThe path 1 attribute of an ad.ad_performance
ad_path_2TEXTDimensãoThe path 2 attribute of an ad.ad_performance
ad_quality_scoreNUMERICMétricaThe numeric score shows you how competitive your ads are in the marketplace by measuring how relevant your keywords and landing pages are to customers' search terms. The quality score is calculated by Microsoft Advertising using the ExpectedCtr, AdRelevance, and LandingPageExperience sub scores. If available, the quality score can range from a low of 1 to a high of 10. Quality score is based on the last rolling 30 days for the owned and operated search traffic. A quality score can be assigned without any impressions, in the case where a keyword bid did not win any auctions. The score is calculated only based on Search Traffic. The value in the report will be null if the score was not computed. This can occur if there have been no impressions for the keyword for 30 days or more. Quality score is typically updated 14-18 hours after the UTC day ends. Keywords in all time zones will be assigned a quality score for the corresponding UTC day. If you run the report multiple times in a day, the quality score values could change from report to report based on when you run the report relative to when the scores are calculated. If you specify a time period that spans multiple days, the quality score is the current and most recently calculated score and will be reported as the same for each day in the time period.campaign_performance, keyword_performance, ad_group_performance
ad_relevanceTEXTDimensãoHow closely related your ads is to the customer's search query or other input. It tells you how relevant your ad and landing page are to potential customers.campaign_performance, keyword_performance, ad_group_performance
ad_short_headlineTEXTDimensãoThe shorter of two possible responsive ad headlines for Audience campaigns.ad_performance
ad_statusTEXTDimensãoThe ad status.ad_performance, search_query_performance, dsa_search_query_performance, product_dimension_performance
ad_titleTEXTDimensãoThe ad titlead_performance
ad_title_part_1TEXTDimensãoThe title part 1 attribute of an ad.ad_performance
ad_title_part_2TEXTDimensãoThe title part 2 attribute of an ad.ad_performance
ad_title_part_3TEXTDimensãoThe title part 3 attribute of an ad.ad_performance
ad_typeTEXTDimensãoThe ad type.ad_performance, keyword_performance, search_query_performance
adnetwork_conversionsNUMERICMétricaThe ad network reported conversionsad_performance, campaign_performance, keyword_performance, conversion_performance, user_location_performance, age_gender_report, audience_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
adnetwork_revenueNUMERICMétricaThe ad network reported revenuead_performance, campaign_performance, keyword_performance, conversion_performance, user_location_performance, age_gender_report, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
age_groupTEXTDimensãoThe age group of the audience who viewed the ad. The possible values are 13-17, 18-24, 25-34, 35-49, 50-64, and 65+.age_gender_report
all_conversion_ratePERCENTMétricaThe conversion rate as a percentage.ad_performance, campaign_performance, keyword_performance, conversion_performance, user_location_performance, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
all_conversionsNUMERICMétricaThe number of conversions. This column is deprecated in 2022, so you should use the all_conversions_qualified column instead. Going forward, performance reports will return '0' (zero) in this column.share_of_voice, ad_performance, campaign_performance, keyword_performance, conversion_performance, user_location_performance, age_gender_report, audience_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
all_conversions_qualifiedNUMERICMétricaThe number of conversions.ad_performance, campaign_performance, keyword_performance, conversion_performance, user_location_performance, age_gender_report, audience_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
all_cost_per_conversionNUMERICMétricaThe cost per conversion.ad_performance, campaign_performance, keyword_performance, conversion_performance, user_location_performance, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
all_revenueNUMERICMétricaThe revenue optionally reported by the advertiser as a result of conversions.ad_performance, campaign_performance, keyword_performance, conversion_performance, user_location_performance, age_gender_report, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
all_revenue_per_conversionNUMERICMétricaThe revenue per conversion.The formula for calculating the revenue per conversion is (Revenue / Conversions).ad_performance, campaign_performance, keyword_performance, conversion_performance, user_location_performance, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
all_roasNUMERICMétricaThe return on ad spend (ROAS).The formula for calculating the ROAS is (Revenue / Spend).ad_performance, campaign_performance, keyword_performance, conversion_performance, user_location_performance, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
asset_group_idTEXTDimensãoThe Microsoft Advertising assigned identifier of an asset group.user_location_performance, product_dimension_performance
asset_group_nameTEXTDimensãoThe asset group name.user_location_performance, product_dimension_performance
asset_group_statusTEXTDimensãoThe asset group status.product_dimension_performance
assistsNUMERICMétricaThe number of conversions from other ads within the same account that were preceded by one or more clicks from this ad. An ad is considered to have assisted the conversion if it was clicked before the most recently clicked ad that was credited with the conversion. Additionally, the click corresponding to the assist must occur within the conversion period of the goal.ad_performance, campaign_performance, keyword_performance, conversion_performance, user_location_performance, age_gender_report, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance
association_idTEXTDimensãoThe Microsoft Advertising assigned identifier of the association between the audience and either an ad group or campaign.audience_performance
association_levelTEXTDimensãoThe level of the audience's association. The possible values are 'Ad group' or 'Campaign'.audience_performance
association_statusTEXTDimensãoThe status of the association between the audience and either an ad group or campaign.audience_performance
audience_idTEXTDimensãoThe Microsoft Advertising assigned identifier of the audience, for example the remarketing list ID.audience_performance
audience_nameTEXTDimensãoThe audience name.audience_performance
audience_typeTEXTDimensãoThe audience type.audience_performance
average_cpcNUMERICMétricaThe average cost per click (CPC). The total cost of all clicks on an ad divided by the number of clicks. This is the average amount you're actually charged each time your ad is clicked.share_of_voice, ad_performance, campaign_performance, keyword_performance, user_location_performance, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
average_cpmNUMERICMétricaThe total advertising cost divided by the number of impressions (in thousands).share_of_voice, ad_performance, campaign_performance, keyword_performance, user_location_performance, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
average_cpvNUMERICMétricaAverage total spend divided by video views.ad_performance, campaign_performance, ad_group_performance
base_campaign_idTEXTDimensãoThe Microsoft Advertising assigned identifier of an experiment campaign. This will be the same value as the CampaignId if the campaign is not an experiment.share_of_voice, ad_performance, campaign_performance, keyword_performance, age_gender_report, audience_performance, ad_group_performance
bid_adjustmentNUMERICMétricaThis attribute reflects the current value of your ad group's audience bid adjustment, even if a different bid adjustment value was used when the ad was shown. This value is the requested percentage to increase or decrease the bid amount for the remarketing list.audience_performance
bid_match_typeTEXTDimensãoThe keyword bid match type. This can be different from the DeliveredMatchType column, for example if you bid on a broad match and the search term was an exact match. For more information, see Budget and Bid Strategies. The possible values are Broad, Exact, Phrase, and Unknown.ad_performance, campaign_performance, keyword_performance, user_location_performance, search_query_performance
bid_strategy_typeTEXTDimensãoThe bid strategy type. Possible values include EnhancedCpc, ManualCpc, MaxClicks, MaxConversions, and TargetCpa.keyword_performance, dsa_auto_target_performance, product_dimension_performance
budget_amountNUMERICMétricaThe configured daily budget cap for the campaign, in the account currency major unit. The value is the current cap rather than a date-range aggregate.ad_performance, campaign_performance, keyword_performance, conversion_performance, budget_summary, user_location_performance, age_gender_report, audience_performance, dsa_auto_target_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
budget_idTEXTDimensãoThe unique identifier of the shared Budget object if the campaign uses one, otherwise empty. Campaigns sharing a Budget ID also share a single daily spend cap.ad_performance, campaign_performance, keyword_performance, conversion_performance, budget_summary, user_location_performance, age_gender_report, audience_performance, dsa_auto_target_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
business_nameTEXTDimensãoDepending on your responsive ad's placement, your business's name may appear in your ad. This column only applies to Audience campaigns.ad_performance
campaignTEXTDimensãoThe campaign Nameshare_of_voice, ad_performance, campaign_performance, keyword_performance, conversion_performance, budget_summary, user_location_performance, age_gender_report, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
campaign_idTEXTDimensãoThe campaign IDshare_of_voice, ad_performance, campaign_performance, keyword_performance, conversion_performance, budget_summary, user_location_performance, age_gender_report, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
campaign_labelsTEXTDimensãoThe labels applied to the campaign. Delimited by a semicolon (;).campaign_performance
campaign_statusTEXTDimensãoThe campaign status.share_of_voice, ad_performance, campaign_performance, keyword_performance, conversion_performance, age_gender_report, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, product_dimension_performance
campaign_typeTEXTDimensãoThe campaign type.ad_performance, campaign_performance, user_location_performance, ad_group_performance, product_dimension_performance, search_query_performance
cityCITYDimensãoThe city where the user was physically located when they clicked the ad.user_location_performance
click_share_percentPERCENTMétricaThe percentage of clicks that went to your ads. It is the share of the prospective customer's mindshare and buying intent you captured. You can use this performance metric to see where your growth opportunites are.share_of_voice, campaign_performance, ad_group_performace
clicksNUMERICMétricaThe number of clicksshare_of_voice, ad_performance, campaign_performance, keyword_performance, conversion_performance, user_location_performance, age_gender_report, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
conversion_ratePERCENTMétricaThe conversion rate as a percentage.share_of_voice, ad_performance, campaign_performance, keyword_performance, conversion_performance, user_location_performance, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
conversionsNUMERICMétricaThe number of conversions. This column is deprecated in 2022, so you should use the conversions_qualified column instead. Going forward, performance reports will return '0' (zero) in this column.share_of_voice, ad_performance, campaign_performance, keyword_performance, conversion_performance, user_location_performance, age_gender_report, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
conversions_qualifiedNUMERICMétricaThe number of conversions.ad_performance, campaign_performance, keyword_performance, conversion_performance, user_location_performance, age_gender_report, audience_performance, dsa_auto_target_performance, ad_group_performance, product_dimension_performance, search_query_performance
cost_per_conversionNUMERICMétricaThe cost per conversion.share_of_voice, ad_performance, campaign_performance, keyword_performance, conversion_performance, user_location_performance, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
cost_per_installNUMERICMétricaThe cost per install. The formula for calculating the cost per install is (Spend / Installs)campaign_performance, ad_group_performance, product_dimension_performance
cost_per_salePERCENTMétricaThe cost per sale. The formula for calculating the cost per sale is (Spend / Sales)campaign_performance, ad_group_performance, product_dimension_performance
countryCOUNTRYDimensãoThe country where the user was physically located when they clicked the ad.user_location_performance
countyTEXTDimensãoThe county where the user was physically located when they clicked the ad.user_location_performance
cpaNUMERICMétricaThe cost per assist. The formula for calculating the CPA is (Spend / Assists).ad_performance, campaign_performance, keyword_performance, conversion_performance, user_location_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance
cpcNUMERICMétricaThe average cost per click (CPC). The total cost of all clicks on an ad divided by the number of clicks. This is the average amount you're actually charged each time your ad is clicked.ad_performance, campaign_performance, keyword_performance, user_location_performance, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
ctrPERCENTMétricaThe number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions).share_of_voice, ad_performance, campaign_performance, keyword_performance, conversion_performance, user_location_performance, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
currencyTEXTDimensãoThe account currency type.ad_performance, campaign_performance, keyword_performance, budget_summary, user_location_performance, ad_group_performance, product_dimension_performance
currency_codeTEXTDimensãoThe account currency type.ad_performance, campaign_performance, keyword_performance, budget_summary, user_location_performance, ad_group_performance, product_dimension_performance
customer_idTEXTDimensãoThe Microsoft Advertising assigned identifier of a customer.ad_performance, campaign_performance, search_query_performance, dsa_search_query_performance
customer_nameTEXTDimensãoThe customer name.ad_performance, campaign_performance, search_query_performance, dsa_search_query_performance
daily_budget_spendNUMERICMétricaThe average amount of campaign budget spent per day.budget_summary
data_fetched_atTIMESTAMPDimensãoUTC 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.
datasourceTEXTDimensãoThe name of the Windsor connector returning the row
dateDATEDimensãoThe dateshare_of_voice, ad_performance, campaign_performance, keyword_performance, conversion_performance, budget_summary, user_location_performance, age_gender_report, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
day_of_monthTEXTDimensãoDay of the month
delivered_match_typeTEXTDimensãoThe match type used to deliver an ad. This can be different from the BidMatchType column, for example if you bid on a broad match and the search term was an exact match. For more information, see Budget and Bid Strategies. The possible values are Broad, Exact, Phrase, and Unknown.ad_performance, campaign_performance, keyword_performance, user_location_performance, search_query_performance
destination_urlTEXTDimensãoThe destination URL attribute of the ad, keyword, or ad group criterion.ad_performance, keyword_performance, search_query_performance
deviceTEXTDimensãoDevice typead_performance, campaign_performance, keyword_performance, user_location_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
device_osTEXTDimensãoThe operating system of the device reported in the DeviceType column. The possible values include Android, Blackberry, iOS, Other, Unknown, and Windows. If the operating system of the device cannot be determined or is not one of the operating systems that you can target, the value in this column will be Unknown.ad_performance, campaign_performance, keyword_performance, user_location_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance
display_urlTEXTDimensãoThe ad display URL.ad_performance
dynamic_ad_targetTEXTDimensãoThe dynamic ad target or webpage condition that Bing matched to your website. For example the condition could be returned in the report as URL contains xyz.dsa_auto_target_performance, dsa_search_query_performance
dynamic_ad_target_idTEXTDimensãoThe Microsoft Advertising assigned identifier of the dynamic ad target, also known in Campaign Management and Bulk API as the ad group criterion ID.dsa_auto_target_performance, dsa_search_query_performance
dynamic_ad_target_statusTEXTDimensãoThe current status of the dynamic ad target.dsa_auto_target_performance
dynamic_search_ad_descriptionTEXTDimensãoThe dynamic search ad text automatically generated by Microsoft Advertising when DynamicDescriptionEnabled is set to true.dsa_search_query_performance
dynamic_search_headlineTEXTDimensãoThe Dynamic Search Ad headline that was dynamically generated by Microsoft Advertising.dsa_search_query_performance
eligible_absolute_top_impressionsNUMERICMétricaEligible Absolute Top Impressionscampaign_performance
eligible_top_impressionsNUMERICMétricaEligible Top Impressionscampaign_performance
expected_ctrNUMERICMétricaHow well your keyword competes against other keywords targeting the same traffic. Ads that are relevant to searchers' queries or other input are more likely to have a higher click-through rate. This metric tells you if a keyword is underperforming and causing a loss in impression share, so you can make keyword changes or remove ads altogether. A score of 3 is Above Average; a score of 2 is Average; and a score of 1 is considered Below Average. The score is calculated only based on Search Traffic. The value in the report will be null if the score was not computed. If you specify a time period that spans multiple days, the score will be the same for each day in the time period, and the value is the most recent calculated score. Data for this column is typically updated 14-18 hours after the UTC day ends.campaign_performance, keyword_performance, ad_group_performance
feed_urlTEXTDimensãoThe feed URL will appear either as 'True' or 'False'. If it's 'True', the final URL came from a page feed associated to the campaign. If it's 'False', the final URL did not come from a page feed.dsa_search_query_performance
final_mobile_urlTEXTDimensãoThe Final Mobile URL of the ad, keyword, or criterion. Only the first URL in the list is reported. If the URL contains dynamic text substitution parameters (for example, {param1}), the report will contain the URL before substitution.ad_performance, keyword_performance
final_urlTEXTDimensãoOnly the first URL in the list is reported. If the URL contains dynamic text substitution parameters (for example, {param1}), the report will contain the URL before substitution.ad_performance, keyword_performance, dsa_search_query_performance
final_url_suffixTEXTDimensãoA place in your final URL where you can add parameters that will be attached to the end of your landing page URL.ad_performance, campaign_performance, keyword_performance
first_page_bidNUMERICMétricaBased on your campaign performance and marketplace dynamics, this estimate is the bid amount that Microsoft Advertising calculates for your ad to be placed on the first page in the search results. These estimates are provided as a reference only. They are automatically generated by Microsoft Advertising and are not a guarantee of ad position.keyword_performance
genderTEXTDimensãoThe gender (male or female) of the search users to whom the ad was delivered.age_gender_report
goalTEXTDimensãoThe name of the goal you set for the conversions you want, meaning actions customers take after clicking your ad.ad_performance, campaign_performance, keyword_performance, conversion_performance, user_location_performance, age_gender_report, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
goal_idTEXTDimensãoThe Microsoft Advertising assigned identifier of a conversion goal.conversion_performance, product_dimension_performance
goal_typeTEXTDimensãoThe type of conversion goal. Possible values include AppInstall, Duration, Event, InStoreTransaction, OfflineConversion, PagesViewedPerVisit, and Url.ad_performance, conversion_performance, keyword_performance, user_location_performance, age_gender_report, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
impression_lost_to_budgetNUMERICMétricaImpression Lost To Budgetcampaign_performance
impression_lost_to_budget_percentPERCENTMétricaThe estimated percentage of impressions your ad did not receive due to issues with your daily or monthly budget.share_of_voice, campaign_performance, ad_group_performance, product_dimension_performance
impression_lost_to_rankNUMERICMétricaImpression Lost To Rankcampaign_performance, ad_group_performance
impression_lost_to_rank_percentPERCENTMétricaThe estimated percentage of impressions your ad did not receive due to poor Ad Rank.campaign_performance, ad_group_performance
impression_share_percentPERCENTMétricaThe estimated percentage of impressions, out of the total available impressions in the market you were targeting.share_of_voice, campaign_performance, ad_group_performance, product_dimension_performance
impressionsNUMERICMétricaThe number of impressionsshare_of_voice, ad_performance, campaign_performance, keyword_performance, conversion_performance, user_location_performance, age_gender_report, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
installsNUMERICMétricaThe total number of installs.campaign_performance, ad_group_performance, product_dimension_performance
keywordTEXTDimensãoThe keyword.share_of_voice, keyword_performance, conversion_performance, search_query_performance
keyword_idTEXTDimensãoThe keyword ID.share_of_voice, keyword_performance, conversion_performance, search_query_performance
keyword_labelsTEXTDimensãoThe labels applied to the keyword. Delimited by a semicolon (;).share_of_voice, keyword_performance
keyword_statusTEXTDimensãoThe keyword status (Active/Deleted/Paused).share_of_voice, keyword_performance, conversion_performance, search_query_performance
landing_page_experienceTEXTDimensãoAn aggregate quality assessment of all landing pages on your site. The landing page experience score measures whether your landing page is likely to provide a good experience to customers who click your ad and land on your website.campaign_performance, keyword_performance, ad_group_performance
landing_page_titleTEXTDimensãoThe title of your webpage where the search user landed.dsa_search_query_performance
languageTEXTDimensãoThe language of the publisher where the ad was shown. The language display name will be provided in the report e.g. English.ad_performance, keyword_performance, user_location_performance, age_gender_report, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
location_idTEXTDimensãoThe Microsoft Advertising identifier of the location where the user was physically located when they clicked the ad. For geographical location identifiers, see Geographical Location Codes. If the location ID is in the report but not found in the file downloaded via GetGeoLocationsFileUrl, it is not targetable.user_location_performance
mainline_bidNUMERICMétricaBased on your campaign performance and marketplace dynamics, this estimate is the bid amount that Microsoft Advertising calculates for your ad to be placed on the first page in the search results. These estimates are provided as a reference only. They are automatically generated by Microsoft Advertising and are not a guarantee of ad position.keyword_performance
mainline_bid_1NUMERICMétricaBased on your campaign performance and marketplace dynamics, this estimate is the bid amount that Microsoft Advertising calculates will place your ad at the top of search results. These estimates are provided as a reference only. They are automatically generated by Microsoft Advertising and are not a guarantee of ad position.keyword_performance
metro_areaTEXTDimensãoThe metro area (Nielsen DMA in the United States) where the user was physically located when they clicked the ad.user_location_performance
month_to_date_budget_spendNUMERICMétricaThe amount of money spent to date for the month.budget_summary
monthly_budgetNUMERICMétricaThe anticipated maximum monthly budget amount that was calculated on the date of the most recent budget change.budget_summary
neighborhoodTEXTDimensãoThe neighborhood where an ad was physically served, or the neighborhood that your customer had shown interest in through searches or content they had viewed. This helps you find out how your ads are doing in different locations, which can help you decide where to focus more of your advertising efforts.user_location_performance
networkTEXTDimensãoThe entire Microsoft Advertising Network made up of Microsoft sites and select traffic, and only partner traffic. Use this data to make the best decision on network selection for your ad groups.ad_performance, campaign_performance, keyword_performance, user_location_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, product_dimension_performance
nowTIMESTAMPDimensãoCurrent timestamp
phone_callsNUMERICMétricaThe number of total calls to the tracked phone number that showed with your ad.campaign_performance, ad_group_performance
postal_codeTEXTDimensãoThe postal code where the user was physically located when they clicked the ad.user_location_performance
potential_clicksNUMERICMétricaPotential Clickscampaign_performance
product_assisted_clicksNUMERICMétricaClicks on your ads that have received co-bids from your manufacturer partners. Clicks are what you pay for. Clicks typically include a customer clicking an ad on a search results page or on a website on the search network. Clicks can also come from other sources (for example, spiders, robots, and test servers).This performance statistic is only available for Sponsored Products in Microsoft Shopping Campaigns.product_dimension_performance
product_assisted_conversionsNUMERICMétricaThe number of conversions. A conversion is the completion of an action by a customer after viewing your ad. The action could be purchasing your product, registering for your webinar, joining an organization, or whatever you consider your goal and best measure of the ad's success.Available for accounts that are setup to use analytics with Microsoft Advertising Universal Event Tracking.product_dimension_performance
product_assisted_impressionsNUMERICMétricaThe number of times an ad that is being co-bid by your manufacturer partners has been displayed on search results pages or other sites on the Microsoft Advertising Network. This performance statistic is only available for Sponsored Products in Microsoft Shopping Campaigns.product_dimension_performance
product_benchmark_ctrNUMERICMétricaShows you how other product ads for similar products are performing on average based on how often people who see the ad end up clicking on it. If the benchmark CTR is significantly higher than the CTR for your product group, you might consider raising your bid for that product group, or improving the product information, particularly product images and titles.product_dimension_performance
product_boughtTEXTDimensãoThe product purchased from your catalog or via your retail partner. The purchased product will always match the same brand, but can differ from the specific product ad that was clicked on. If different products were purchased as a result of one click, the report will include multiple rows with the same ad ID and Merchant product ID, and each will contain a unique ProductBought value. You can also include the QuantityBought column to get data on quantity purchased per product.product_dimension_performance
product_bought_titleTEXTDimensãoThe title associated with the purchased product.product_dimension_performance
product_brandTEXTDimensãoThe product item's manufacturer, brand, or publisher.product_dimension_performance
product_category_1TEXTDimensãoThe first level value of the Product_category field in your Microsoft Merchant Center catalog.product_dimension_performance
product_category_2TEXTDimensãoThe second level value of the Product_category field in your Microsoft Merchant Center catalog.product_dimension_performance
product_category_3TEXTDimensãoThe third level value of the Product_category field in your Microsoft Merchant Center catalog.product_dimension_performance
product_category_4TEXTDimensãoThe fourth level value of the Product_category field in your Microsoft Merchant Center catalog.product_dimension_performance
product_category_5TEXTDimensãoThe fifth level value of the Product_category field in your Microsoft Merchant Center catalog.product_dimension_performance
product_click_typeTEXTDimensãoClick type refers to each component of an ad that a customer can click. The possible click types are ad title, image, phone number, driving directions, sitelink, and review.product_dimension_performance
product_click_type_idTEXTDimensãoThe click type ID.product_dimension_performance
product_conditionTEXTDimensãoThe condition of a product item.product_dimension_performance
product_country_of_saleCOUNTRYDimensãoThe country/region of sale for the product catalog.product_dimension_performance
product_custom_label_0TEXTDimensãoThe value of the Custom_label_0 field in your Microsoft Merchant Center catalog.product_dimension_performance
product_custom_label_1TEXTDimensãoThe value of the Custom_label_1 field in your Microsoft Merchant Center catalog.product_dimension_performance
product_custom_label_2TEXTDimensãoThe value of the Custom_label_2 field in your Microsoft Merchant Center catalog.product_dimension_performance
product_custom_label_3TEXTDimensãoThe value of the Custom_label_3 field in your Microsoft Merchant Center catalog.product_dimension_performance
product_custom_label_4TEXTDimensãoThe value of the Custom_label_4 field in your Microsoft Merchant Center catalog.product_dimension_performance
product_gtinTEXTDimensãoGlobal Trade Item Number (GTIN) is a unique numerical value for commercial products that usually appears printed under the barcode on retail products.product_dimension_performance
product_idTEXTDimensãoThe unique identifier provided by a merchant for each product offer.product_dimension_performance
product_local_store_codeTEXTDimensãoAn alphanumeric identifier defined by the merchant to uniquely identify each local store.product_dimension_performance
product_mpnTEXTDimensãoManufacturer Part Number (MPN) is a unique number that identifies the product to its manufacturer.product_dimension_performance
product_offer_languageTEXTDimensãoThe language for the product offer.product_dimension_performance
product_priceNUMERICMétricaThe different price for products in your catalog.product_dimension_performance
product_quantity_boughtNUMERICMétricaThe quantity of the product purchased (product_bought) from your catalog or via your retail partner.product_dimension_performance
product_seller_nameTEXTDimensãoThe merchant or store name that offers the product.product_dimension_performance
product_store_idTEXTDimensãoThe unique identifier for the Microsoft Merchant Center store.product_dimension_performance
product_total_clicksTEXTDimensãoThe number of clicks when this ad element was present in the ad copy, whether this or another ad element was clicked on.product_dimension_performance
product_type_1TEXTDimensãoThe first level value of the Product_type field in your Microsoft Merchant Center catalog.product_dimension_performance
product_type_2TEXTDimensãoThe second level value of the Product_type field in your Microsoft Merchant Center catalog.product_dimension_performance
product_type_3TEXTDimensãoThe third level value of the Product_type field in your Microsoft Merchant Center catalog.product_dimension_performance
product_type_4TEXTDimensãoThe fourth level value of the Product_type field in your Microsoft Merchant Center catalog.product_dimension_performance
product_type_5TEXTDimensãoThe fifth level value of the Product_type field in your Microsoft Merchant Center catalog.product_dimension_performance
proximity_target_locationTEXTDimensãoThe radius target bid name. The name of the geographic radius where the user was physically located when they clicked the ad. The Radius attribute column contains the distance of the radius.user_location_performance
query_intent_cityCITYDimensãoThe name of a city if the user's geographical intent can be determined. The city is set if the user's intent is a city, and not necessarily if they are physically located in the city.user_location_performance
query_intent_countryCOUNTRYDimensãoThe name of a country if the user's geographical intent can be determined. The country is set if the user's intent is related to a country, and not necessarily if they are physically located in the county.user_location_performance
query_intent_countyTEXTDimensãoThe name of a county if the user's geographical intent can be determined. The county is set if the user's intent is related to a county, and not necessarily if they are physically located in the county.user_location_performance
query_intent_dmaTEXTDimensãoThe name of a metro area (Nielsen DMA in the United States) if the user's geographical intent can be determined. The metro area is set if the user's intent is a metro area or city within the metro area, and not necessarily if they are physically located in the metro area.user_location_performance
query_intent_location_idTEXTDimensãoThe location identifier if the user's geographical intent can be determined.user_location_performance
query_intent_neighborhoodTEXTDimensãoThe name of a neighborhood if the user's geographical intent can be determined. The neighborhood is set if the user's intent is related to a neighborhood, and not necessarily if they are physically located in the neighborhood. For example, the user's search query was rental cars in Encino.user_location_performance
query_intent_postal_codeTEXTDimensãoThe name of a postal code if the user's geographical intent can be determined. The postal code is set if the user's intent is a postal code, and not necessarily if they are physically located in the postal code.user_location_performance
query_intent_stateTEXTDimensãoThe name of a state if the user's geographical intent can be determined. The state is set if the user's intent is a state or sub geography of the state, and not necessarily if they are physically located in the state.user_location_performance
radiusNUMERICMétricaThe radius of a radius target bid. The geographic radius where the user was physically located when they clicked the ad. The ProximityTargetLocation attribute column contains the address or landmark name of the radius.user_location_performance
revenueNUMERICMétricaThe amount of revenuead_performance, campaign_performance, keyword_performance, conversion_performance, user_location_performance, age_gender_report, audience_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
revenue_per_installPERCENTMétricaThe revenue per install. The formula for calculating the revenue per install is (Revenue / Installs)campaign_performance, ad_group_performance, product_dimension_performance
revenue_per_salePERCENTMétricaThe revenue per sale. The formula for calculating the revenue per sale is (Revenue / Sales)campaign_performance, ad_group_performance, product_dimension_performance
rpaNUMERICMétricaThe revenue per assist. The formula for calculating the RPA is (Revenue / Assists).ad_performance, campaign_performance, keyword_performance, conversion_performance, user_location_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance
salesNUMERICMétricaThe total number of sales.campaign_performance, ad_group_performance, product_dimension_performance
search_queryTEXTDimensãoThe search term used by your potential audience.search_query_performance, dsa_search_query_performance
sourceTEXTDimensãoThe name of the Windsor connector returning the row
spendNUMERICMétricaThe media spendshare_of_voice, ad_performance, campaign_performance, keyword_performance, conversion_performance, user_location_performance, age_gender_report, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
stateTEXTDimensãoThe state where the user was physically located when they clicked the ad.user_location_performance
targeting_settingTEXTDimensãoThis attribute reflects the current value of your ad group's audience targeting setting. The possible values are 'Target and bid' or 'Bid only'. Target and bid: Show ads only to people included in the remarketing list, with the option to change the bid amount. Bid only: Show ads to people searching for your ad, with the option to change the bid amount for people included in the remarketing list.audience_performance
todayDATEDimensãoToday's date
top_impression_rate_percentPERCENTMétricaThe percentage of times your ad showed in the mainline, the top placement where ads appear above the search results, out of your total impressions.share_of_voice, ad_performance, campaign_performance, keyword_performance, age_gender_report, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance
top_impression_share_lost_to_budgetNUMERICMétricaTop Impression Lost To Budgetcampaign_performance
top_impression_share_lost_to_budget_percentPERCENTMétricaThe estimated percentage of mainline impressions, where ads appear above the search results, that were lost due to insufficient budget.share_of_voice, campaign_performance, ad_group_performance
top_impression_share_lost_to_rankNUMERICMétricaTop Impression Share Lost To Rankcampaign_performance
top_impression_share_lost_to_rank_percentPERCENTMétricaA percentage estimate of how often poor ad rank kept your ad from showing in the mainline, the top ad placements above the search results.share_of_voice, campaign_performance, ad_group_performance
top_impression_share_percentPERCENTMétricaThe percentage of impressions for your ad in the mainline, the top ad placements above the search results, out of the estimated number of mainline impressions you were eligible to receive.share_of_voice, campaign_performance, ad_group_performance
top_impressionsNUMERICMétricaTop Impressionsad_performance, campaign_performance, keyword_performance, search_query_performance
top_vs_otherTEXTDimensãoIndicates whether the ad impression appeared in a top position or elsewhere. The possible values include AOL search - Top, AOL search - Other, Audience network, Bing and Yahoo! search - Top, Bing and Yahoo! search - Other, Syndicated search partners - Top, Syndicated search partners - Other, Content network, and Unknown.ad_performance, campaign_performance, keyword_performance, user_location_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, product_dimension_performance
totalcostNUMERICMétricaThe media spend (Duplicate)ad_performance, campaign_performance, keyword_performance, conversion_performance, user_location_performance, age_gender_report, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
tracking_templateTEXTDimensãoThe current tracking template of the ad, keyword, or criterion.ad_performance, campaign_performance, keyword_performance, dsa_auto_target_performance
transactionrevenueNUMERICMétricaThe amount of revenuead_performance, campaign_performance, keyword_performance, conversion_performance, user_location_performance, age_gender_report, audience_performance, dsa_auto_target_performance, search_query_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
video_average_watch_time_per_impressionPERCENTMétricaTotal video watch time divided by the number of impressions.ad_performance, campaign_performance, ad_group_performance
video_average_watch_time_per_viewPERCENTMétricaTotal video watch time divided by the number of video views.ad_performance, campaign_performance, ad_group_performance
video_completion_rateNUMERICMétricaThe number of completed video views divided by the number of total video views.ad_performance, campaign_performance, ad_group_performance
video_total_watch_time_msNUMERICMétricaTotal amount of time a person spent watching the video in milliseconds.ad_performance, campaign_performance, ad_group_performance
video_viewsNUMERICMétricaThe number of times the video was played and watched for at least two continuous seconds with more than 50% of the screen in view.ad_performance, campaign_performance, ad_group_performance
video_views_100NUMERICMétricaNumber of times a person watched the entire video to completion.ad_performance, campaign_performance, ad_group_performance
video_views_25NUMERICMétricaThe number of times a person completed at least 25% of a video.ad_performance, campaign_performance, ad_group_performance
video_views_50NUMERICMétricaThe number of times a person completed at least 50% of a video.ad_performance, campaign_performance, ad_group_performance
video_views_75NUMERICMétricaThe number of times a person completed at least 75% of a video.ad_performance, campaign_performance, ad_group_performance
view_through_conversionsNUMERICMétricaView-through conversions are conversions that people make after they have seen your ad, even though they did not click the ad. View-through conversions don't have a click associated but do have an impression associated within the advertiser defined conversion window. If the user also clicked on an ad that was delivered via the Microsoft Audience or Search network, there won't be any view-through conversion counted. Only the click-based conversion would be counted. View-through conversions are only counted for ads in the Microsoft Audience network.ad_performance, campaign_performance, keyword_performance, conversion_performance, user_location_performance, age_gender_report, audience_performance, dsa_auto_target_performance, dsa_search_query_performance, ad_group_performance, product_dimension_performance
view_through_ratePERCENTMétricaThe number of video views divided by the number of impressions.ad_performance, campaign_performance, ad_group_performance
view_through_revenueNUMERICMétricaThe revenue optionally reported by the advertiser as a result of view-through conversions.ad_performance, campaign_performance, keyword_performance, conversion_performance, user_location_performance, age_gender_report, audience_performance, dsa_auto_target_performance, ad_group_performance, product_dimension_performance
website_coverageNUMERICMétricaA score from 0.0 to 1.0 that indicates the percentage of pages in the requested language that belong to a particular domain out of all the pages that Bing has indexed for the same language your website's domain. In other words coverage is the percentage of webpages that match a category and language divided by the total number of webpages using the same language in the domain. For example, if the category US/CA/SFO matches 500 english webpages and US/CA matches 1,000 english webpages, then the coverage will be 0.50 (50 percent).dsa_auto_target_performance
week_dayTEXTDimensãoWeekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_isoTEXTDimensãoWeekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_isoTEXTDimensãoWeek, ISO format (Mon-Sun).
year_monthTEXTDimensãoYear and month, e.g. 2024|3
year_month_nameTEXTDimensãoYear and month with the month name written out, e.g. "Jan 2025".
year_of_weekTEXTDimensãoThe year that contains first day of the week (Sun-Sat).
year_of_week_isoTEXTDimensãoThe year that contains first day of the ISO week (Mon-Sun).
year_weekTEXTDimensãoYear and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_isoTEXTDimensãoYear and week for ISO weeks (Mon-Sun), e.g. 2024|20