Changelog

General Changes


Date	Version	Source	Category	Type	Description
2026-06-03	26.0.9650	Google Ads	Data Model	Removed	Removed the following columns from the Ad view: AdCallAdBusinessName, AdCallAdCallTracked, AdCallAdConversionAction, AdCallAdConversionReportingState, AdCallAdCountryCode, AdCallAdDescription1, AdCallAdDescription2, AdCallAdDisableCallConversion, AdCallAdHeadline1, AdCallAdHeadline2, AdCallAdPath1, AdCallAdPath2, AdCallAdPhoneNumber, AdCallAdPhoneNumberVerificationUrl, and AdDemandGenMultiAssetAdLeadFormOnly. Removed the following columns from the AdGroupAd view: AdGroupAdAdCallAdBusinessName, AdGroupAdAdCallAdCallTracked, AdGroupAdAdCallAdConversionAction, AdGroupAdAdCallAdConversionReportingState, AdGroupAdAdCallAdCountryCode, AdGroupAdAdCallAdDescription1, AdGroupAdAdCallAdDescription2, AdGroupAdAdCallAdDisableCallConversion, AdGroupAdAdCallAdHeadline1, AdGroupAdAdCallAdHeadline2, AdGroupAdAdCallAdPath1, AdGroupAdAdCallAdPath2, AdGroupAdAdCallAdPhoneNumber, AdGroupAdAdCallAdPhoneNumberVerificationUrl, and AdGroupAdAdDemandGenMultiAssetAdLeadFormOnly. Removed CampaignStartDate and CampaignEndDate from the Campaign view. Removed the following columns from the CampaignAggregateAssetView and ChannelAggregateAssetView views: AssetBestPerformanceCostPercentage, AssetBestPerformanceImpressionPercentage, AssetGoodPerformanceCostPercentage, AssetGoodPerformanceImpressionPercentage, AssetLearningPerformanceCostPercentage, AssetLearningPerformanceImpressionPercentage, AssetLowPerformanceCostPercentage, AssetLowPerformanceImpressionPercentage, AssetUnratedPerformanceCostPercentage, AssetUnratedPerformanceImpressionPercentage, SampleBestPerformanceEntities, SampleGoodPerformanceEntities, SampleLearningPerformanceEntities, SampleLowPerformanceEntities, and SampleUnratedPerformanceEntities.
2026-06-03	26.0.9650	Google Ads	Data Model	Added	Added 5 new views: AppliedIncentive, AppTopCombinationView, MatchedLocationInterestView, VideoEnhancement, and YouTubeVideoUpload. Added the following columns to the Ad view: AdDemandGenVideoResponsiveAdCompanionBanners, AdVideoResponsiveAdBusinessName, and AdVideoResponsiveAdLogoImages. Added the following columns to the AdGroup view: ActiveViewAudibilityInvalidGivtMeasurableImpressionsRate, ActiveViewAudibilityInvalidMeasurableImpressionsRate, ActiveViewAudibilityMeasurableImpressions, ActiveViewAudibilityMeasurableImpressionsRate, ActiveViewAudibleImpressions, ActiveViewAudibleImpressionsRate, ActiveViewAudibleQuartileP100Rate, ActiveViewAudibleQuartileP25Rate, ActiveViewAudibleQuartileP50Rate, ActiveViewAudibleQuartileP75Rate, ActiveViewAudibleThirtySecondsImpressions, ActiveViewAudibleThirtySecondsImpressionsRate, ActiveViewAudibleTwoSecondsImpressions, ActiveViewAudibleTwoSecondsImpressionsRate, AdGroupVerticalAdsFormatSettingDisableTextAds, AdGroupVerticalAdsFormatSettingEnableBookingLinks, AdGroupVerticalAdsFormatSettingEnableVerticalPromotionAds, AdSubNetworkType, BiddableIndirectInstallFirstInAppConversionMicros, CostConvertedCurrencyPerPlatformComparableConversion, CostPerPlatformComparableConversion, CrossDeviceConversionsByConversionDate, CrossDeviceConversionsValueByConversionDate, PlatformComparableConversions, PlatformComparableConversionsByConversionDate, PlatformComparableConversionsFromInteractionsRate, PlatformComparableConversionsFromInteractionsValuePerInteraction, PlatformComparableConversionsValue, PlatformComparableConversionsValueByConversionDate, PlatformComparableConversionsValuePerCost, ValuePerPlatformComparableConversion, ValuePerPlatformComparableConversionsByConversionDate, VerticalAdsEventParticipantDisplayNames, VerticalAdsHotelClass, VerticalAdsListing, VerticalAdsListingBrand, VerticalAdsListingCity, VerticalAdsListingCountry, VerticalAdsListingRegion, VerticalAdsPartnerAccount, VerticalAdsVertical, VideoTrueviewViewRateInFeed, VideoTrueviewViewRateInStream, and VideoTrueviewViewRateShorts. Added the following columns to the AdGroupAd view: ActiveViewAudibilityInvalidGivtMeasurableImpressionsRate, ActiveViewAudibilityInvalidMeasurableImpressionsRate, ActiveViewAudibilityMeasurableImpressions, ActiveViewAudibilityMeasurableImpressionsRate, ActiveViewAudibleImpressions, ActiveViewAudibleImpressionsRate, ActiveViewAudibleQuartileP100Rate, ActiveViewAudibleQuartileP25Rate, ActiveViewAudibleQuartileP50Rate, ActiveViewAudibleQuartileP75Rate, ActiveViewAudibleThirtySecondsImpressions, ActiveViewAudibleThirtySecondsImpressionsRate, ActiveViewAudibleTwoSecondsImpressions, ActiveViewAudibleTwoSecondsImpressionsRate, AdGroupAdAdDemandGenVideoResponsiveAdCompanionBanners, AdGroupAdAdVideoResponsiveAdBusinessName, AdGroupAdAdVideoResponsiveAdLogoImages, AdGroupAdEndDateTime, AdGroupAdStartDateTime, AdSubNetworkType, CostConvertedCurrencyPerPlatformComparableConversion, CostPerPlatformComparableConversion, PlatformComparableConversions, PlatformComparableConversionsByConversionDate, PlatformComparableConversionsFromInteractionsRate, PlatformComparableConversionsFromInteractionsValuePerInteraction, PlatformComparableConversionsValue, PlatformComparableConversionsValueByConversionDate, PlatformComparableConversionsValuePerCost, ValuePerPlatformComparableConversion, ValuePerPlatformComparableConversionsByConversionDate, VideoTrueviewViewRateInFeed, VideoTrueviewViewRateInStream, and VideoTrueviewViewRateShorts. Added the following columns to the AdGroupAdAssetView view: AdSubNetworkType and ConversionActionName. Added AdSubNetworkType to the following views: AdGroupAdAssetCombinationView, AdGroupAudienceView, AgeRangeView, AssetFieldTypeView, AssetGroupProductGroupView, AssetSetAsset, AssetSetTypeView, BiddingStrategy, CampaignAsset, CampaignAudienceView, CampaignBudget, CampaignSearchTermView, ClickView, ContentCriterionView, CustomerAsset, DetailPlacementView, DisplayKeywordView, DistanceView, ExpandedLandingPageView, GenderView, GroupPlacementView, HotelPerformanceView, IncomeRangeView, KeywordView, LandingPageView, LocationInterestView, ManagedPlacementView, ParentalStatusView, ProductGroupView, SearchTermView, TopicView, and TravelActivityPerformanceView. Added the following columns to the AssetGroup view: AdSubNetworkType, AverageCpe, EngagementRate, and Engagements. Added the following columns to the AssetGroupAsset view: AdSubNetworkType, AverageCpe, AverageCpm, InteractionEventTypes, TrueviewAverageCpv, VideoTrueviewViewRate, and VideoTrueviewViews. Added the following columns to the Asset view: AssetBusinessMessageAssetFacebookMessengerInfoPageName, AssetBusinessMessageAssetZaloInfoCustomName, AssetBusinessMessageAssetZaloInfoOaId, and AssetOrientation. Added the following columns to the Campaign view: ActiveViewAudibilityInvalidGivtMeasurableImpressionsRate, ActiveViewAudibilityInvalidMeasurableImpressionsRate, ActiveViewAudibilityMeasurableImpressions, ActiveViewAudibilityMeasurableImpressionsRate, ActiveViewAudibleImpressions, ActiveViewAudibleImpressionsRate, ActiveViewAudibleQuartileP100Rate, ActiveViewAudibleQuartileP25Rate, ActiveViewAudibleQuartileP50Rate, ActiveViewAudibleQuartileP75Rate, ActiveViewAudibleThirtySecondsImpressions, ActiveViewAudibleThirtySecondsImpressionsRate, ActiveViewAudibleTwoSecondsImpressions, ActiveViewAudibleTwoSecondsImpressionsRate, AdSubNetworkType, BiddableIndirectInstallFirstInAppConversionMicros, CampaignEndDateTime, CampaignHotelSettingDisableHotelSetting, CampaignStartDateTime, CampaignTargetRoasTargetRoasTolerancePercentMillis, CampaignTextGuidelinesMessagingRestrictions, CampaignTextGuidelinesTermExclusions, CampaignVideoCampaignSettingsBookingDetailsCancellationDateTime, CampaignVideoCampaignSettingsBookingDetailsHoldExpirationDateTime, CampaignVideoCampaignSettingsBookingDetailsStatus, CampaignVideoCampaignSettingsReservationAdCategorySelfDisclosureAlcohol, CampaignVideoCampaignSettingsReservationAdCategorySelfDisclosureGambling, CampaignVideoCampaignSettingsReservationAdCategorySelfDisclosurePolitics, CrossDeviceConversionsByConversionDate, CrossDeviceConversionsValueByConversionDate, Svr, UniqueUsersFivePlus, UniqueUsersFourPlus, UniqueUsersTenPlus, UniqueUsersThreePlus, UniqueUsersTwoPlus, VerticalAdsEventParticipantDisplayNames, VerticalAdsHotelClass, VerticalAdsListing, VerticalAdsListingBrand, VerticalAdsListingCity, VerticalAdsListingCountry, VerticalAdsListingRegion, VerticalAdsPartnerAccount, and VerticalAdsVertical. Added the following columns to the Customer view: ActiveViewAudibilityInvalidGivtMeasurableImpressionsRate, ActiveViewAudibilityInvalidMeasurableImpressionsRate, ActiveViewAudibilityMeasurableImpressions, ActiveViewAudibilityMeasurableImpressionsRate, ActiveViewAudibleImpressions, ActiveViewAudibleImpressionsRate, ActiveViewAudibleQuartileP100Rate, ActiveViewAudibleQuartileP25Rate, ActiveViewAudibleQuartileP50Rate, ActiveViewAudibleQuartileP75Rate, ActiveViewAudibleThirtySecondsImpressions, ActiveViewAudibleThirtySecondsImpressionsRate, ActiveViewAudibleTwoSecondsImpressions, ActiveViewAudibleTwoSecondsImpressionsRate, AdSubNetworkType, BiddableIndirectInstallFirstInAppConversionMicros, CrossDeviceConversionsByConversionDate, CrossDeviceConversionsValueByConversionDate, VerticalAdsEventParticipantDisplayNames, VerticalAdsHotelClass, VerticalAdsListing, VerticalAdsListingBrand, VerticalAdsListingCity, VerticalAdsListingCountry, VerticalAdsListingRegion, VerticalAdsPartnerAccount, VerticalAdsVertical, VideoTrueviewViewRateInFeed, VideoTrueviewViewRateInStream, and VideoTrueviewViewRateShorts. Added the following columns to the GeographicView view: AdSubNetworkType, AllConversionsByConversionDate, AllConversionsValueByConversionDate, ConversionsByConversionDate, ConversionsValueByConversionDate, CrossDeviceConversionsByConversionDate, CrossDeviceConversionsValueByConversionDate, ValuePerAllConversionsByConversionDate, and ValuePerConversionsByConversionDate. Added the following columns to the PerStoreView view: AdSubNetworkType, PerStoreViewAddress1, PerStoreViewAddress2, PerStoreViewBusinessName, PerStoreViewCity, PerStoreViewCountryCode, PerStoreViewPhoneNumber, PerStoreViewPostalCode, and PerStoreViewProvince. Added ProductLinkAdvertisingPartnerPropertiesAllowedDomain to the ProductLink view. Added ProductLinkInvitationAdvertisingPartnerPropertiesAllowedDomain to the ProductLinkInvitation view. Added the following columns to the SharedCriterion view: SharedCriterionNegative, SharedCriterionVerticalAdsItemGroupRuleCityCriterionId, SharedCriterionVerticalAdsItemGroupRuleCountryCriterionId, SharedCriterionVerticalAdsItemGroupRuleHotelClass, SharedCriterionVerticalAdsItemGroupRuleItemCode, and SharedCriterionVerticalAdsItemGroupRuleRegionCriterionId. Added SharedSetVerticalAdsItemVerticalType to the SharedSet view. Added the following columns to the ShoppingPerformanceView view: AdSubNetworkType, AllConversionsByConversionDate, AllConversionsValueByConversionDate, ConversionsByConversionDate, ConversionsValueByConversionDate, SearchBudgetLostAbsoluteTopImpressionShare, SearchBudgetLostImpressionShare, SearchRankLostAbsoluteTopImpressionShare, SearchRankLostImpressionShare, ValuePerAllConversionsByConversionDate, and ValuePerConversionsByConversionDate. Added ShoppingProductProductImageUri to the ShoppingProduct view. Added TrueviewAverageCpv to the TargetingExpansionView view. Added the following columns to the UserLocationView view: AdSubNetworkType, AllConversionsByConversionDate, AllConversionsValueByConversionDate, ConversionsByConversionDate, ConversionsValueByConversionDate, CrossDeviceConversionsByConversionDate, CrossDeviceConversionsValueByConversionDate, ValuePerAllConversionsByConversionDate, and ValuePerConversionsByConversionDate. Added the following columns to the Video view: ActiveViewAudibilityInvalidGivtMeasurableImpressionsRate, ActiveViewAudibilityInvalidMeasurableImpressionsRate, ActiveViewAudibilityMeasurableImpressions, ActiveViewAudibilityMeasurableImpressionsRate, ActiveViewAudibleImpressions, ActiveViewAudibleImpressionsRate, ActiveViewAudibleQuartileP100Rate, ActiveViewAudibleQuartileP25Rate, ActiveViewAudibleQuartileP50Rate, ActiveViewAudibleQuartileP75Rate, ActiveViewAudibleThirtySecondsImpressions, ActiveViewAudibleThirtySecondsImpressionsRate, ActiveViewAudibleTwoSecondsImpressions, ActiveViewAudibleTwoSecondsImpressionsRate, AdSubNetworkType, CostConvertedCurrencyPerPlatformComparableConversion, CostPerPlatformComparableConversion, PlatformComparableConversions, PlatformComparableConversionsByConversionDate, PlatformComparableConversionsFromInteractionsRate, PlatformComparableConversionsFromInteractionsValuePerInteraction, PlatformComparableConversionsValue, PlatformComparableConversionsValueByConversionDate, PlatformComparableConversionsValuePerCost, ValuePerPlatformComparableConversion, ValuePerPlatformComparableConversionsByConversionDate, VideoTrueviewViewRateInFeed, VideoTrueviewViewRateInStream, and VideoTrueviewViewRateShorts. Added AdSubNetworkType and TrueviewAverageCpv to the WebpageView view. Added AdGroupCriterionVerticalAdsItemGroupRuleListSharedSet to the AdGroupCriterion view. Added the following enum values to AdFormatType in the AdGroup, AdGroupAd, Campaign, Customer, and Video views and the AdGroupAdAssetView view: TEXT, VERTICAL_ADS_BOOKING_LINK, and VERTICAL_ADS_PROMOTION. Added the following enum values to field type enums across the following views: CALL_TO_ACTION and LONG_DESCRIPTION to AdGroupExcludedParentAssetFieldTypes (AdGroup view), AdGroupAdAssetViewFieldType (AdGroupAdAssetView view), AdGroupAssetFieldType (AdGroupAsset view), AssetFieldTypeViewFieldType (AssetFieldTypeView view), AssetGroupAssetFieldType (AssetGroupAsset view), CampaignAggregateAssetViewFieldType (CampaignAggregateAssetView view), CampaignAssetFieldType (CampaignAsset view), ChannelAggregateAssetViewFieldType (ChannelAggregateAssetView view), CustomerAssetFieldType (CustomerAsset view), CampaignExcludedParentAssetFieldTypes (Campaign view), and FinalUrlExpansionAssetViewFieldType (FinalUrlExpansionAssetView view). Added the following enum values to criterion type enums across the following views: VERTICAL_ADS_ITEM_GROUP_RULE and VERTICAL_ADS_ITEM_GROUP_RULE_LIST to AdGroupCriterionType (AdGroupCriterion view), CampaignCriterionType (CampaignCriterion view), CustomerNegativeCriterionType (CustomerNegativeCriterion view), and SharedCriterionType (SharedCriterion view). Added the following enum value to SharedSetType in the SharedSet view: VERTICAL_ADS_ITEM_GROUP_RULE_LIST. Added the following enum value to SearchTermMatchSource in the CampaignSearchTermView and SearchTermView views: VERTICAL_ADS_DATA_FEED. Added the following enum value to AdGroupAdAssetViewPerformanceLabel in the AdGroupAdAssetView view: NOT_APPLICABLE. Added the following enum values to AdGroupAdAssetViewPinnedField in the AdGroupAdAssetView view: DESCRIPTION_LINE_HEADLINE_AS_SITELINK_POSITION_ONE, DESCRIPTION_LINE_HEADLINE_AS_SITELINK_POSITION_TWO, HEADLINE_AS_SITELINK_POSITION_ONE, and HEADLINE_AS_SITELINK_POSITION_TWO. Added the following enum values to AssetBusinessMessageAssetMessageProvider in the Asset view: FACEBOOK_MESSENGER and ZALO. Added the following enum value to ConversionActionCategory across all applicable views: YOUTUBE_FOLLOW_ON_VIEWS.
2026-05-27	26.0.9643	General	Connection	Removed	Removed the deprecated ReplaceInvalidTypesWithNull connection property. Use the ReplaceInvalidValuesWithNull property instead.
2026-05-07	26.0.9623	General	Data Model	Added	Added the ColumnCapabilities column to the sys_tablecolumns system table. This column is a bit mask denoting the column's write capabilities.
2026-04-28	26.0.9614	ADO.NET	Connection	Added	Added the following functions to the driver class. If you pass these functions an exception with no error records, an InvalidArgumentException is thrown. containsErrorSource: Returns true if the exception contains an error record for the provided source name, or false otherwise. getErrorCodeFromSource: Returns the numeric error code from the error record with the given source, or -1 if there is no error record from that source. containsErrorCode: Returns true if the exception contains an error record with the provided error code, or false otherwise. findErrorProperty: Returns the value of the property with the given name, or null if no property with that name is defined. formatErrorRecords: Returns a string containing all the exception's error records, including messages, codes, properties, and error locations.
2026-04-15	26.0.9601	General	Query Exec	Changed	String comparisons using GREATER, LESS, and CONTAINS operators are now case-insensitive by default.
2026-04-08	26.0.9594	Google Ads	Security	Changed	TLS 1.3 is now supported by default for HTTP connections.
2026-04-01	26.0.9587	ADO.NET		Added	Added support for EFCore 10.
2026-04-01	26.0.9587	Google Ads		Removed	Removed the BatchSize connection property.
2026-03-12	25.0.9567	Google Ads	Data Model	Added	Added the CampaignGoalConfig view. Added the Goal view. Added the TargetingExpansion view. Added the following columns to the AdGroup view: AdGroupEffectiveTargetCpc, AdGroupEffectiveTargetCpcSource, AdGroupTargetCpcMicros, AverageVideoWatchTimeDurationMillis, TrueviewAverageCpv, and VideoWatchTimeDurationMillis. Added the following columns to the AdGroupAd view: AverageVideoWatchTimeDurationMillis, VideoWatchTimeDurationMillis. Added the following columns to the AdGroupAdAssetView view: AllConversionsFromInteractionsRate, AverageCost, AverageCpe, AverageCpm, ConversionsFromInteractionsRate, CrossDeviceConversions, EngagementRate, Engagements, InteractionEventTypes, InteractionRate, Interactions, TrueviewAverageCpv, VideoTrueviewViewRate, and VideoTrueviewViews. Added the following columns to the AssetGroupAsset view: ConversionAction, ConversionActionCategory, ConversionActionName, and Device. Added the following columns to the Campaign view: CampaignFeedTypes, CampaignTargetCpcTargetCpcMicros, AverageVideoWatchTimeDurationMillis, VideoWatchTimeDurationMillis, and AdUsingVideo. Added the following columns to the Customer view: AverageVideoWatchTimeDurationMillis, VideoWatchTimeDurationMillis, AdUsingProductData, and AdUsingVideo. Added the following columns to the Video view: AverageVideoWatchTimeDurationMillis, VideoWatchTimeDurationMillis. Added the following enums for the ClickType column in all views it appears in: CLICK_TO_MESSAGE_LANDING_PAGE_CLICK, CLICK_TO_MESSAGE_THIRD_PARTY_CLICK. Added the following enums to the AccessibleBiddingStrategyType column in the AccessibleBiddingStrategy view: FIXED_SHARE_OF_VOICE, TARGET_CPC. Added the LANDING_PAGE_PREVIEW enum to fields in views pertaining to AssetFieldType, For example the AdGroupExcludedParentAssetFieldTypes column in the AdGroup view and the CustomerAssetFieldType column in the CustomerAsset view. Added the following enums to the AccessibleBiddingStrategyType column in the AccessibleBiddingStrategy view: FIXED_SHARE_OF_VOICE, TARGET_CPC. Added the following enums to the BiddingStrategyType column in the BiddingStrategy view: TARGET_CPC, FIXED_SHARE_OF_VOICE. Added the following enums to the CampaignAppCampaignSettingBiddingStrategyGoalType column in the Campaign view: OPTIMIZE_TOTAL_VALUE_WITHOUT_TARGET_ROAS, OPTIMIZE_IN_APP_CONVERSIONS_WITHOUT_TARGET_CPA. Added the following enums to the CampaignBiddingStrategyType column in the Campaign view: FIXED_SHARE_OF_VOICE, TARGET_CPC. Added the following enum to the CampaignExcludedPArentAssetFieldTypes column in the Campaign view: LANDING_PAGE_PREVIEW. Added the following enum to the UserListCrmBasedUserListDataSourceType column in the USerList view: THIRD_PARTY_PARTNER_DATA.
2026-03-12	25.0.9567	Google Ads	Connection	Changed	Changed the default API version from v21 to v22.
2026-03-12	25.0.9567	Google Ads	Data Model	Changed	The VideoViewRate column is renamed to VideoTrueviewViewRate in all views it appears in. The VideoViews column is renamed to VideoTrueviewViews in all views it appears in. The AverageCpv column is renamed to TrueviewAverageCpv in all views it appears in. The VideoViewRateInFeed column is renamed to VideoTrueviewViewRateInFeed in the Campaign view. The VideoViewRateInStream column is renamed to VideoTrueviewViewRateInStream in the Campaign view. The VideoViewRateShorts column is renamed to VideoTrueviewViewRateShorts in the Campaign view. The AverageCpv column is renamed to TrueviewAverageCpv in the CampaignGroup view.
2026-03-12	25.0.9567	Google Ads	Data Model	Removed	Removed the AssetGroupAssetPerformanceLabel column from the AssetGroupAsset view. Removed the CampaignUrlExpansionOptOut column from the Campaign view. Removed the AverageCpv column from the Webpage view.
2026-01-13	25.0.9509	General		Added	Added support for the REGEXP_REPLACE() string function.
2025-12-05	25.0.9470	General		Added	Added support for the INSERT INTO SELECT statement, with driver-side execution for providers that do not support the operation natively.
2025-11-05	25.0.9440	Google Ads		Added	Added a CustomerId column to the following views: CarrierConstant, CurrencyConstant, CustomerSearchTermInsight, GeoTargetConstant, HotelPerformanceView, KeywordThemeConstant, LanguageConstant, LifeEvent, MobileAppCategoryConstant, MobileDeviceConstant, OperatingSystemVersionConstant, ProductCategoryConstant, QualifyingQuestion, TopicConstant, TravelActivityPerformanceView, and UserInterest. Added the following views: AiMaxSearchTermAdCombinationView, CampaignSearchTermView, DetailContentSuitabilityPlacementView, FinalUrlExpansionAssetView, GroupContentSuitabilityPlacementView, and LocationInterestView. Added the AdGroupAiMaxAdGroupSettingDisableSearchTermMatching and AdGroupVideoAdGroupSettingsVideoAdSequenceStepId columns to the AdGroup view. Added the Device column to the AdGroupAdAssetView view. Added the AdGroupCriterionBrandListSharedSet, AdGroupCriterionExtendedDemographicExtendedDemographicId, AdGroupCriterionLifeEventLifeEventId, and AdGroupCriterionVideoLineupVideoLineupId columns to the AdGroupCriterion view. Added the AssetPromotionAssetPromotionBarcodeInfoBarcodeContent, AssetPromotionAssetPromotionBarcodeInfoType, AssetPromotionAssetPromotionQrCodeInfoQrCodeContent, AssetPromotionAssetTermsAndConditionsText, AssetPromotionAssetTermsAndConditionsUri, and AssetYoutubeVideoListAssetYoutubeVideos columns to the Asset view. Added the AllConversionsByConversionDate, AllConversionsValueByConversionDate, AllNewCustomerLifetimeValue, AllValueAdjustment, ConversionsByConversionDate, ConversionsValueByConversionDate, NewCustomerLifetimeValue, ValueAdjustment, ValuePerAllConversionsByConversionDate, ValuePerConversionsByConversionDate, AdNetworkType, ClickType, ConversionAction, ConversionActionCategory, ConversionActionName, ConversionAdjustment, ConversionAttributionEventType, ConversionLagBucket, ConversionOrAdjustmentLagBucket, Device, ExternalConversionSource, NewVersusReturningCustomers, and Slot columns to the AssetGroup view. Added the AllConversions, AllConversionsFromInteractionsRate, AllConversionsFromInteractionsValuePerInteraction, AllConversionsValue, AllConversionsValuePerCost, AverageCost, AverageCpc, Clicks, ConversionsFromInteractionsRate, ConversionsFromInteractionsValuePerInteraction, ConversionsValuePerCost, CostMicros, CostPerAllConversions, CostPerConversion, CrossDeviceConversions, CrossDeviceConversionsValue, Ctr, EngagementRate, Engagements, Impressions, InteractionRate, Interactions, ValuePerAllConversions, ViewThroughConversions, and AdNetworkType columns to the AssetGroupAsset view. Added the BiddingStrategyMaximizeConversionValueTargetRoasTolerancePercentMillis, BiddingStrategyTargetRoasTargetRoasTolerancePercentMillis, ClicksUniqueQueryClusters, ConversionsUniqueQueryClusters, and ImpressionsUniqueQueryClusters columns to the BiddingStrategy view. Added the CampaignAiMaxSettingBundlingRequired, CampaignAiMaxSettingEnableAiMax, CampaignContainsEuPoliticalAdvertising, CampaignMaximizeConversionValueTargetRoasTolerancePercentMillis, CampaignThirdPartyIntegrationPartnersBrandLiftIntegrationPartners, CampaignThirdPartyIntegrationPartnersBrandSafetyIntegrationPartners, CampaignThirdPartyIntegrationPartnersReachIntegrationPartners, CampaignThirdPartyIntegrationPartnersViewabilityIntegrationPartners, CampaignVideoCampaignSettingsVideoAdFormatControlFormatRestriction, CampaignVideoCampaignSettingsVideoAdFormatControlNonSkippableInStreamRestrictionsMaxDuration, CampaignVideoCampaignSettingsVideoAdFormatControlNonSkippableInStreamRestrictionsMinDuration,CampaignVideoCampaignSettingsVideoAdInventoryControlAllowNonSkippableInStream, CampaignVideoCampaignSettingsVideoAdSequenceMinimumDuration, CampaignVideoCampaignSettingsVideoAdSequenceSteps, ClicksUniqueQueryClusters, ConversionsUniqueQueryClusters, CostConvertedCurrencyPerPlatformComparableConversion, CostPerPlatformComparableConversion, ImpressionsUniqueQueryClusters, PlatformComparableConversions, PlatformComparableConversionsByConversionDate, PlatformComparableConversionsFromInteractionsRate, PlatformComparableConversionsFromInteractionsValuePerInteraction, PlatformComparableConversionsValue, PlatformComparableConversionsValueByConversionDate, PlatformComparableConversionsValuePerCost, ValuePerPlatformComparableConversion, and ValuePerPlatformComparableConversionsByConversionDate columns to the Campaign view. Added the AllConversions, AllConversionsFromInteractionsRate, AllConversionsFromInteractionsValuePerInteraction, AllConversionsValue, AllConversionsValuePerCost, AverageCost, AverageCpc, Clicks, ConversionsFromInteractionsRate, ConversionsFromInteractionsValuePerInteraction, ConversionsValuePerCost, CostMicros, CostPerAllConversions, CostPerConversion, CrossDeviceConversions, CrossDeviceConversionsValue, Ctr, EngagementRate, Engagements, InteractionRate, Interactions, ValuePerAllConversions, and ViewThroughConversions columns to the ChannelAggregateAssetView view. Added the AllConversions, AllConversionsFromInteractionsRate, AllConversionsFromInteractionsValuePerInteraction, AllConversionsValue, AllConversionsValuePerCost, AverageCost, AverageCpc, Clicks, ConversionsFromInteractionsRate, ConversionsFromInteractionsValuePerInteraction, ConversionsValuePerCost, CostMicros, CostPerAllConversions, CostPerConversion, CrossDeviceConversions, CrossDeviceConversionsValue, Ctr, EngagementRate, Engagements, InteractionRate, Interactions, ValuePerAllConversions, and ViewThroughConversions to the CampaignAggregateAssetView view. Added the CustomerVideoCustomerThirdPartyIntegrationPartnersBrandLiftIntegrationPartners, CustomerVideoCustomerThirdPartyIntegrationPartnersBrandSafetyIntegrationPartners, CustomerVideoCustomerThirdPartyIntegrationPartnersReachIntegrationPartners, CustomerVideoCustomerThirdPartyIntegrationPartnersViewabilityIntegrationPartners, ClicksUniqueQueryClusters, ConversionsUniqueQueryClusters, CostConvertedCurrencyPerPlatformComparableConversion, CostPerPlatformComparableConversion, ImpressionsUniqueQueryClusters, PlatformComparableConversions, PlatformComparableConversionsByConversionDate, PlatformComparableConversionsFromInteractionsRate, PlatformComparableConversionsFromInteractionsValuePerInteraction, PlatformComparableConversionsValue, PlatformComparableConversionsValueByConversionDate, PlatformComparableConversionsValuePerCost, ValuePerPlatformComparableConversion, and ValuePerPlatformComparableConversionsByConversionDate columns to the Customer view. Added the CustomerNegativeCriterionPlacementListSharedSet column to the CustomerNegativeCriterion view. Added the LandingPageSource column to the ExpandedLandingPageView view. Added the MatchType column to the KeywordView view. Added the LandingPageSource column to the LandingPageView view. Added the SearchTermMatchSource column to the SearchTermView view. Added the SharedCriterionWebpageConditions, SharedCriterionWebpageCoveragePercentage, SharedCriterionWebpageCriterionName, and SharedCriterionWebpageSampleSampleUrls columns to the SharedCriterion view. Added the CampaignCriterionExtendedDemographicExtendedDemographicId, CampaignCriterionLifeEventLifeEventId, CampaignCriterionVideoLineupVideoLineupId, and CampaignCriterionWebpageListSharedSet columns to the CampaignCriterion view. Added the ChangeStatusAssetSet and ChangeStatusCampaignAssetSet columns to the ChangeStatus view. In the AdGroup view, added the RELATED_YOUTUBE_VIDEOS enum to the AdGroupExcludedParentAssetFieldTypes column and the PAUSE enum to the AdGroupPrimaryStatus view. In the AdGroupAd view, added the PAUSE enum to the AdFormatType column. In the AdGroupAdAssetView view, added the RELATED_YOUTUBE_VIDEOS enum to the AdGroupAdAssetViewFieldType column, the DESCRIPTION_PREFIX enum to the AdGroupAdAssetViewPinnedField column, and the PAUSE enum to the AdFormatType. In the AdGroupAssset view, added the RELATED_YOUTUBE_VIDEOS enum to the AdGroupAssetFieldType column. In the AdGroupCriterion view, added the PLACEMENT_LIST, VIDEO_LINEUP, and WEBPAGE_LIST enums to the AdGroupCriterionType column. In the Asset view, added the YOUTUBE_VIDEO_LIST enum to the AssetType column. In the AssetFieldTypeView view, added the RELATED_YOUTUBE_VIDEOS enum to the AssetFieldTypeViewFieldType column. In the AssetGroupAsset view, added the RELATED_YOUTUBE_VIDEOS to the AssetGroupAssetFieldType column. In the Campaign view, added the RELATED_YOUTUBE_VIDEOS enum to the CampaignExcludedParentAssetFieldTypes column, the MISSING_LOCATION_TARGETING enum to the CampaignPrimaryStatusReasons column, the PAUSE enum to the AdFormatType column, and the ENGAGED_VIEW enum to the ConversionAttributionEventType column. In the CampaignAggregateAssetView view, added the RELATED_YOUTUBE_VIDEOS enum to the CampaignAggregateAssetViewFieldType column. In the CampaignAsset view, added the RELATED_YOUTUBE_VIDEOS enums to the CampaignAssetFieldType column. In the CampaignCriterion view, added the PLACEMENT_LIST, VIDEO_LINEUP, and the WEBPAGE_LIST enums to the CampaignCriterionType column. In the ChannelAggregateAssetView view, added the RELATED_YOUTUBE_VIDEOS enum to the ChannelAggregateAssetViewFieldType column. In the Customer view, added the PAUSE enum to the AdFormatType column. In the CustomerNegativeCriterion view, added the PLACEMENT_LIST, VIDEO_LINEUP, and WEBPAGE_LIST enums to the CustomerNegativeCriterionType column. In the SearchTermView view, added the AI_MAX and PERFORMANCE_MAX enums to the SearchTermMatchType column. In the SharedCriterion view, added the PLACEMENT_LIST, VIDEO_LINEUP, and WEBPAGE_LIST enums to the SharedCriterionType column. In the SharedSet view, added the WEBPAGES enum to the SharedSetType column. In the UserLocationView, TravelActivityPerformanceView, and Video views, added the PAUSE enum to the AdNetworkType column. The DISCOVER, GMAIL, and MAPS enums have been added to the AdNetworkType column in all views where this column is available. The PRODUCT_ASSETS, VEHICLE_ASSETS, VIDEO_RELATED_VIDEOS_CLICK, and VIDEO_CHANNEL_CLICK enums have been added to the ClickType column in all views where this column is available.
2025-11-05	25.0.9440	Google Ads		Changed	Updated the default API version from v19 to v21.
2025-10-06	25.0.9410	General		Added	Support for parsing datetime formats using ".S" and ",S" for milliseconds and nanoseconds.
2025-09-16	25.0.9390	Google Ads		Changed	When you run SELECT * queries, NULL segment columns are no longer included in the result set.
2025-09-12	25.0.9386	General		Added	Added the IsInsertable, IsUpdateable, and IsDeleteable columns to the sys_tables table.
2025-09-10	25.0.9384	General		Changed	All columns in statically defined Views are now reported as read-only.
2025-09-03	25.0.9377	General		Changed	Corrected the behavior when IN criteria with NULL values are used in the projection part. It now returns NULL instead of 0. For example, "NULL IN (1,2)" returns "NULL".
2025-09-01	25.0.9375	General		Added	Added support for using the CAST function with infinity values. This function can cast "inf" and "-inf" to DOUBLE, FLOAT, or REAL.
2025-08-21	25.0.9364	General		Changed	Report behavior change: Fixed inconsistent string value comparisons in non-table queries. For example, "SELECT 'A' = 'a'" previously returned false, but it now returns true.
2025-08-13	25.0.9356	General		Changed	Changed the maximum number of pages held in memory from 15 to 5 for the page providers to decrease heap usage.
2025-07-08	25.0.9320	Google Ads		Changed	The following fields are now filtered using Date values (yyyy-mm-dd) instead of DateTime values (yyyy-mm-ddthh:mm:ssz): AccountBudgetProposal view: AccountBudgetProposalApprovalDateTime and AccountBudgetProposalCreationDateTime CallView view: CallViewEndCallDateTime and CallViewStartCallDateTime ChangeEvent view: ChangeEventChangeDateTime ChangeStatus view: ChangeStatusLastChangeDateTime ConversionAction view: ConversionLastReceivedRequestDateTime
2025-06-25	25.0.9307	General		Removed	Removed the "ADLS Gen 1" value from the ConnectionType property.
2025-06-20	25.0.9302	General		Added	Created the following functions: TEXT_ENCODE: encodes a string into a different charset (UTF8 → UTF7 and returns a binary array as the result). TEXT_DECODE: takes a binary array and decodes it back into a string when provided the charset. BASE64_ENCODE: takes a binary array and encodes it as a base64 string (varchar). BASE64_DECODE: takes a base 64-encoded string and decodes it into a binary array.
2025-06-18	25.0.9300	General		Changed	The internal code for exception handling has been refactored. Exception messages returned during certain error conditions may now have different wording or formatting.
2025-06-10	25.0.9292	Google Ads		Added	Added 3 columns to the Ad view. Added 9 columns to the AdGroup view. Added 3 columns to the AdGroupAd view. Added 7 columns to the Asset view. Added 1 column to the AssetGroup view. Added 10 columns to the AssetGroupAsset view. Added 11 columns to the Campaign view. Added 3 columns to the CampaignAggregateAssetView view. Added 1 column to the ChangeStatus view. Added 3 columns to the ChannelAggregateAssetView view. Added 1 column to the CustomerLifecycleGoal view. Added 1 column to the LocalServicesLead view. Added value YOUTUBE_AUDIO_AD: In the Ad view's AdType column. In the AdGroupAd view's AdGroupAdType column. Added value YOUTUBE_AUDIO: In the AdGroup view's AdGroupType column. Added values BUSINESS_MESSAGE and TALL_PORTRAIT_MARKETING_IMAGE: In the AdGroup view's AdGroupCpcBidMicros column. In the AdGroupAdAssetView view's AdGroupAdAssetViewFieldType column. In the AdGroupAsset view's AdGroupAssetFieldType column. In the AssetFieldTypeView's AssetFieldTypeViewFieldType column. In the AssetGroupAsset view's AssetGroupAssetFieldType column. In the CampaignAsset view's CampaignAssetFieldType column. In the CustomerAsset view's CustomerAssetFieldType column. In the CampaignAggregateAssetView view's CampaignAggregateAssetViewFieldType column. In the ChannelAggregateAssetView view's ChannelAggregateAssetViewFieldType column. Added values APP_DEEP_LINK and BUSINESS_MESSAGE: In the Asset view's AssetType column. Added value MONTHLY: In the Campaign view's CampaignFixedCpmTargetFrequencyInfoTimeUnit column. Added values ASSET_SET, CAMPAIGN_ASSET_SET, and CAMPAIGN_BUDGET: In the ChangeStatus view's ChangeStatusResourceType column.
2025-06-10	25.0.9292	Google Ads		Changed	Updated the default API version from v18 to v19.
2025-06-10	25.0.9292	Google Ads		Removed	Removed the following views: AdGroupExtensionSetting, AdGroupFeed, CampaignExtensionSetting, CampaignFeed, CustomerExtensionSetting, CustomerFeed, ExtensionFeedItem, Feed, FeedItem, FeedItemSet, FeedItemSetLink, FeedItemTarget, FeedMapping, and FeedPlaceholderView. Removed 1 column in Campaign view: CampaignDynamicSearchAdsSettingFeeds. Removed 1 column in CampaignCriterion view: CampaignCriterionLocationGroupFeed. Removed 2 columns in ChangeEvent view: ChangeEventFeed and ChangeEventFeedItem. Removed 4 columns in ChangeStatus view: ChangeStatusAdGroupFeed, ChangeStatusCampaignFeed, ChangeStatusFeed, and ChangeStatusFeedItem. Removed the following enum values: In the Ad view's AdType column, removed value: VIDEO_OUTSTREAM_AD. In the AdGroup view's AdGroupType column, removed value: VIDEO_OUTSTREAM.
2025-05-29	25.0.9280	ADO.NET		Changed	We have improved our implementation of the ADO.NET DbDataReader.GetDataTypeName so that it now returns database data type names, such as varchar, tinyint, and datetime. Previously we returned the fully-qualified name of the column’s .NET type, in a format like "System.String, System.Private.CoreLib, Version=6.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e".
2025-05-29	25.0.9280	Google Ads		Removed	Removed the PageSize connection property, which has been deprecated in GoogleAds.
2025-05-27	25.0.9278	ADO.NET		Removed	Removed support for the C# implementation of SQLite. Features that previously used this implementation by default, such as AutoCache and EF6 schema caching, now require the native SQLite driver.
2025-05-27	25.0.9278	General		Removed	Removed the "Proprietary" enum option from ProxyAuthscheme.
2025-02-17	24.0.9179	Google Ads		Added	Three new views: ContentCriterionView, Datalink, and PerformanceMaxPlacementView. New columns in AdGroup: AdGroupExcludeDemographicExpansion, TravelDestinationCity, TravelDestinationRegion, TravelDestinationCountry. New columns in AdGroupAd: AdGroupAdAdGroupAdAssetAutomationSettings New columns in Campaign: StoreVisitsLastClickModelAttributedConversions, VideoViewRateInFeed, VideoViewRateInStream, VideoViewRateShorts, ResultsConversionsPurchase, GeneralInvalidClickRate, GeneralInvalidClicks New columns in ConversionValueRule: ConversionValueRuleItineraryConditionAdvanceBookingWindowMaxDays, ConversionValueRuleItineraryConditionAdvanceBookingWindowMinDays, ConversionValueRuleItineraryConditionTravelLengthMaxNights, ConversionValueRuleItineraryConditionTravelLengthMinNights, ConversionValueRuleItineraryConditionTravelStartDayFriday, ConversionValueRuleItineraryConditionTravelStartDayMonday, ConversionValueRuleItineraryConditionTravelStartDaySaturday, ConversionValueRuleItineraryConditionTravelStartDaySunday, ConversionValueRuleItineraryConditionTravelStartDayThursday, ConversionValueRuleItineraryConditionTravelStartDayTuesday, ConversionValueRuleItineraryConditionTravelStartDayWednesday.
2025-02-15	24.0.9177	General		Added	Added support for converting unsigned integer types to the nearest signed data type that has enough precision to hold the unsigned value.This is done for JDBC only because it does not have support for unsigned data types.
2024-11-27	24.0.9097	General		Added	Added ThreadId to LogModule output. Logfile lines now include the Thread ID associated with the action being performed.
2024-10-17	24.0.9056	Google Ads		Added	Added support for Workload Identity Federation using AWS accounts.
2024-10-14	24.0.9053	Google Ads		Added	Added a new view, ShoppingProduct.
2024-10-14	24.0.9053	Google Ads		Removed	In the AdGroup, Campaign, Custom, and KeywordView views, removed 6 columns: AuctionInsightSearchAbsoluteTopImpressionPercentage AuctionInsightSearchImpressionShare AuctionInsightSearchOutrankingShare AuctionInsightSearchOverlapRate AuctionInsightSearchPositionAboveRate AuctionInsightSearchTopImpressionPercentage
2024-08-20	24.0.8998	Google Ads		Added	Added support for V17 of the Google Ads API. This is now the default value for the APIVersion connection property. Added the Ad, CampaignAggregateAssetView, ChannelAggregateAssetView, OfflineConversionUploadConversionActionSummary, and UserListCustomerType views. For all views with a ClickType column, the value AD_IMAGE has been added to them. In the AdGroup view, added the AdGroupFixedCpmMicros, AdGroupTargetCpvMicros, and AdFormatType columns. In the AdGroupAd view, added the column AdFormatType. In the AdGroupAdAssetView view, added the AdFormatType column. In the AdGroupCriterion view, added the AdGroupCriterionPrimaryStatus and AdGroupCriterionPrimaryStatusReasons columns. In the BiddingDataExclusion view's BiddingDataExclusionAdvertisingChannelTypes column, added the value DEMAND_GEN. In the BiddingSeasonalityAdjustment view's BiddingSeasonalityAdjustmentAdvertisingChannelTypes column, added the value DEMAND_GEN. In the Campaign view, added the CampaignFixedCpmGoal, CampaignFixedCpmTargetFrequencyInfoTargetCount, CampaignFixedCpmTargetFrequencyInfoTimeUnit, CampaignKeywordMatchType, CampaignTargetCpv, CampaignVideoCampaignSettingsVideoAdInventoryControlAllowInFeed, CampaignVideoCampaignSettingsVideoAdInventoryControlAllowInStream, CampaignVideoCampaignSettingsVideoAdInventoryControlAllowShorts, AdFormatType, SkAdNetworkRedistributedFineConversionValue and SkAdNetworkVersion columns. In the Campaign view's CampaignAdvertisingChannelType column, added the value DEMAND_GEN. In the ChangeStatus view, added the ChangeStatusAssetGroup column. In the Customer view, added the AdFormatType, SkAdNetworkRedistributedFineConversionValue, and SkAdNetworkVersion columns. In the CustomerClientLink view, added the CustomerId column. In the CustomerNegativeCriterion's CustomerNegativeCriterionContentLabelType column, added the BRAND_SUITABILITY_CONTENT_FOR_FAMILIES,BRAND_SUITABILITY_GAMES_FIGHTING,BRAND_SUITABILITY_GAMES_MATURE,BRAND_SUITABILITY_HEALTH_SENSITIVE,BRAND_SUITABILITY_HEALTH_SOURCE_UNDETERMINED,BRAND_SUITABILITY_NEWS_RECENT,BRAND_SUITABILITY_NEWS_SENSITIVE,BRAND_SUITABILITY_NEWS_SOURCE_NOT_FEATURED,BRAND_SUITABILITY_POLITICS, and BRAND_SUITABILITY_RELIGION values. In the GenderView view, added the SearchImpressionShare column. In the KeywordView view, added the PhoneCalls column. In the LocalServicesLeadConversation view's LocalServicesLeadConversationConversationChannel column, added the WHATSAPP value. In the LocalServicesVerificationArtifact view, added the LocalServicesVerificationArtifactLicenseVerificationArtifactExpirationDateTime and LocalServicesVerificationArtifactInsuranceVerificationArtifactExpirationDateTime columns. In the OfflineConversionUploadClientSummary view, added the OfflineConversionUploadClientSummaryPendingEventCount and OfflineConversionUploadClientSummaryPendingRate columns. In the PerStoreView view, added the Date and Period columns. In the Video view, added the AdFormatType column.
2024-08-20	24.0.8998	Google Ads		Removed	In the AdGroupAd view's AdGroupAdAdType column, removed the DISCOVERY_CAROUSEL_AD value. In the BiddingDataExclusion view's BiddingDataExclusionAdvertisingChannelTypes column, removed the value DISCOVERY. In the BiddingSeasonalityAdjustment view's BiddingSeasonalityAdjustmentAdvertisingChannelTypes column, removed the value DISCOVERY. In the Campaign view's CampaignAdvertisingChannelType column, removed the value DISCOVERY. Removed the CustomerClientLink view's LinkedManagerId column and CustomerId pseudocolumn. Removed the CustomerLifecycleGoal's CustomerLifecycleGoalLifecycleGoalCustomerDefinitionSettingsExistingUserLists and CustomerLifecycleGoalLifecycleGoalCustomerDefinitionSettingsHighLifetimeValueUserLists columns.
2024-08-20	24.0.8998	Google Ads		Changed	In the AdGroup view's AdGroupExcludedParentAssetFieldTypes column, renamed the value DISCOVERY_CAROUSEL_CARD to DEMAND_GEN_CAROUSEL_CARD. Renamed the AdGroupAd view's AdGroupAdAdDiscoveryCarouselAdBusinessName column to AdGroupAdAdDemandGenCarouselAdBusinessName. Renamed the AdGroupAd view's AdGroupAdAdDiscoveryCarouselAdCallToActionText column to AdGroupAdAdDemandGenCarouselAdCallToActionText. Renamed the AdGroupAd view's AdGroupAdAdDiscoveryCarouselAdCarouselCards column to AdGroupAdAdDemandGenCarouselAdCarouselCards. Renamed the AdGroupAd view's AdGroupAdAdDiscoveryCarouselAdDescription column to AdGroupAdAdDemandGenCarouselAdDescription. Renamed the AdGroupAd view's AdGroupAdAdDiscoveryCarouselAdHeadline column to AdGroupAdAdDemandGenCarouselAdHeadline. Renamed the AdGroupAd view's AdGroupAdAdDiscoveryCarouselAdLogoImage column to AdGroupAdAdDemandGenCarouselAdLogoImage. Renamed the AdGroupAd view's AdGroupAdAdDiscoveryMultiAssetAdBusinessName column to AdGroupAdAdDemandGenMultiAssetAdBusinessName. Renamed the AdGroupAd view's AdGroupAdAdDiscoveryMultiAssetAdCallToActionText column to AdGroupAdAdDemandGenMultiAssetAdCallToActionText. Renamed the AdGroupAd view's AdGroupAdAdDiscoveryMultiAssetAdDescriptions column to AdGroupAdAdDemandGenMultiAssetAdDescriptions. Renamed the AdGroupAd view's AdGroupAdAdDiscoveryMultiAssetAdHeadlines column to AdGroupAdAdDemandGenMultiAssetAdHeadlines. Renamed the AdGroupAd view's AdGroupAdAdDiscoveryMultiAssetAdLeadFormOnly column to AdGroupAdAdDemandGenMultiAssetAdLeadFormOnly. Renamed the AdGroupAd view's AdGroupAdAdDiscoveryMultiAssetAdLogoImages column to AdGroupAdAdDemandGenMultiAssetAdLogoImages. Renamed the AdGroupAd view's AdGroupAdAdDiscoveryMultiAssetAdMarketingImages column to AdGroupAdAdDemandGenMultiAssetAdMarketingImages. Renamed the AdGroupAd view's AdGroupAdAdDiscoveryMultiAssetAdPortraitMarketingImages column to AdGroupAdAdDemandGenMultiAssetAdPortraitMarketingImages. Renamed the AdGroupAd view's AdGroupAdAdDiscoveryMultiAssetAdSquareMarketingImages column to AdGroupAdAdDemandGenMultiAssetAdSquareMarketingImages. Renamed the AdGroupAd view's AdGroupAdAdDiscoveryVideoResponsiveAdBreadcrumb1 column to AdGroupAdAdDemandGenVideoResponsiveAdBreadcrumb1. Renamed the AdGroupAd view's AdGroupAdAdDiscoveryVideoResponsiveAdBreadcrumb2 column to AdGroupAdAdDemandGenVideoResponsiveAdBreadcrumb2. Renamed the AdGroupAd view's AdGroupAdAdDiscoveryVideoResponsiveAdBusinessName column to AdGroupAdAdDemandGenVideoResponsiveAdBusinessName. Renamed the AdGroupAd view's AdGroupAdAdDiscoveryVideoResponsiveAdCallToActions column to AdGroupAdAdDemandGenVideoResponsiveAdCallToActions. Renamed the AdGroupAd view's AdGroupAdAdDiscoveryVideoResponsiveAdDescriptions column to AdGroupAdAdDemandGenVideoResponsiveAdDescriptions. Renamed the AdGroupAd view's AdGroupAdAdDiscoveryVideoResponsiveAdHeadlines column to AdGroupAdAdDemandGenVideoResponsiveAdHeadlines. Renamed the AdGroupAd view's AdGroupAdAdDiscoveryVideoResponsiveAdLogoImages column to AdGroupAdAdDemandGenVideoResponsiveAdLogoImages. Renamed the AdGroupAd view's AdGroupAdAdDiscoveryVideoResponsiveAdLongHeadlines column to AdGroupAdAdDemandGenVideoResponsiveAdLongHeadlines. Renamed the AdGroupAd view's AdGroupAdAdDiscoveryVideoResponsiveAdVideos column to AdGroupAdAdDemandGenVideoResponsiveAdVideos. In the AdGroupAd view's AdGroupAdAdType column, renamed the value DISCOVERY_MULTI_ASSET_AD to DEMAND_GEN_MULTI_ASSET_AD. In the AdGroupAd view's AdGroupAdAdType column, renamed the value DISCOVERY_VIDEO_RESPONSIVE_AD to DEMAND_GEN_VIDEO_RESPONSIVE_AD. Renamed the Asset view's AssetDiscoveryCarouselCardAssetCallToActionText column to AssetDemandGenCarouselCardAssetCallToActionText. Renamed the Asset view's AssetDiscoveryCarouselCardAssetHeadline column to AssetDemandGenCarouselCardAssetHeadline. Renamed the Asset view's AssetDiscoveryCarouselCardAssetMarketingImageAsset column to AssetDemandGenCarouselCardAssetMarketingImageAsset. Renamed the Asset view's AssetDiscoveryCarouselCardAssetPortraitMarketingImageAsset column to AssetDemandGenCarouselCardAssetPortraitMarketingImageAsset. Renamed the Asset view's AssetDiscoveryCarouselCardAssetSquareMarketingImageAsset column to AssetDemandGenCarouselCardAssetSquareMarketingImageAsset. In the AssetGroupAsset view's AssetGroupAssetFieldType column, renamed the value DISCOVERY_CAROUSEL_CARD to DEMAND_GEN_CAROUSEL_CARD. Renamed the Campaign view's CampaignDiscoveryCampaignSettingsUpgradedTargeting column to CampaignDemandGenCampaignSettingsUpgradedTargeting. Renamed the Campaign view's SkAdNetworkConversionValue column to SkAdNetworkFineConversionValue. In the Campaign view's CampaignExcludedParentAssetFieldTypes column, renamed the value DISCOVERY_CAROUSEL_CARD to DEMAND_GEN_CAROUSEL_CARD. Renamed the Customer view's SkAdNetworkConversionValue column to SkAdNetworkFineConversionValue. Renamed the CustomerClientLink view's ClientCustomerId column to CustomerClientLinkClientCustomer. Renamed the CustomerClientLink view's Hidden column to CustomerClientLinkHidden. Renamed the CustomerClientLink view's ManagerLinkId column to CustomerClientLinkManagerLinkId. Renamed the CustomerClientLink view's ResourceName column to CustomerClientLinkResourceName. Renamed the CustomerClientLink view's Status column to CustomerClientLinkStatus.
2024-07-12	24.0.8959	Google Ads		Added	Added a new "ServerTimeZone" connection property. When you set a timezone in this property, the driver assumes that datetime values from the server are in the specified timezone.
2024-07-04	24.0.8951	Google Ads		Removed	Removed the ProductBiddingCategoryConstant view since it has been deprecated from the API.
2024-06-14	24.0.8931	Google Ads		Added	Added support for V16 of the Google Ads API. This is now the default value for the APIVersion connection property. Added LocalServicesEmployee view. Added columns to various views.
2024-06-14	24.0.8931	Google Ads		Removed	Removed columns from various views.
2024-05-09	24.0.8895	General		Changed	The ROUND function previously did not accept negative precision values. That feature has now been restored.
2024-03-15	23.0.8840	General		Added	Created a new SQL function called STRING_COMPARE that provides java's String.compare() ability to SQL queries. Returns a number representative of the compared value of two strings
2024-01-18	23.0.8783	ADO.NET		Added	Added support for EFCore 8.
2023-12-11	23.0.8745	Google Ads		Changed	Updated the GoogleAds schema to be compatible with Google Ads API v15.
2023-11-29	23.0.8733	General		Changed	The ROUND function doesn't accept the negative precision values anymore.
2023-11-29	23.0.8733	General		Changed	The returning types of the FDMonth, FDQuarter, FDWeek, LDMonth, LDQuarter, LDWeek functions are changed from Timestamp to Date. The return type of the ABS function will be consistent with the parameter value type.
2023-11-28	23.0.8732	General		Added	Added the HMACSHA256 formatter to allow for secrets to be decoded if it is in base64 format
2023-11-15	23.0.8719	ADO.NET		Changed	NuGet license and icon are now embedded within the package itself, in compliance with the package authoring best practices.
2023-10-20	23.0.8693	Google Ads		Added	Added all missing metrics and the following column for Customer view: CustomerCustomerAgreementSettingAcceptedLeadFormTerms. Added columns AllNewCustomerLifetimeValue, NewCustomerLifetimeValue, NewVersusReturningCustomers to AdGroup, AdGroupAd, Campaign views. Added column NewVersusReturningCustomers to KeywordView, LocationView views. Added columns RecommendationImprovePerformanceMaxAdStrengthRecommendation, RecommendationMigrateDynamicSearchAdsCampaignToPerformanceMaxRecommendation, RecommendationPerformanceMaxOptInRecommendation to Recommendation view. Added columns AdGroupAdAdDiscoveryVideoResponsiveAdBreadcrumb1, AdGroupAdAdDiscoveryVideoResponsiveAdBreadcrumb2, AdGroupAdAdDiscoveryVideoResponsiveAdBusinessName, AdGroupAdAdDiscoveryVideoResponsiveAdCallToActions, AdGroupAdAdDiscoveryVideoResponsiveAdDescriptions, AdGroupAdAdDiscoveryVideoResponsiveAdHeadlines, AdGroupAdAdDiscoveryVideoResponsiveAdLogoImages, AdGroupAdAdDiscoveryVideoResponsiveAdLongHeadlines, AdGroupAdAdDiscoveryVideoResponsiveAdVideos to AdGroupAd view. Added columns AdGroupCriterionLanguageLanguageConstant, AdGroupCriterionListingGroupPath, AdGroupCriterionLocationGeoTargetConstant to AdGroupCriterion view. Added columns AssetGroupPrimaryStatus, AssetGroupPrimaryStatusReasons to AssetGroup view. Added columns AssetGroupAssetPrimaryStatus, AssetGroupAssetPrimaryStatusDetails, AssetGroupAssetPrimaryStatusReasons to AssetGroupAsset view. Added column AssetGroupListingGroupFilterPath to AssetGroupListingGroupFilter view. Added columns CampaignDiscoveryCampaignSettingsUpgradedTargeting, CampaignShoppingSettingAdvertisingPartnerIds to Campaign view. Added the following value to AdGroupAd.AdGroupAdAdType: DISCOVERY_VIDEO_RESPONSIVE_AD Added the following values to Asset.AssetCallToActionAssetCallToAction: BUY_NOW, DONATE_NOW, ORDER_NOW, PLAY_NOW, SEE_MORE, START_NOW, VISIT_SITE, WATCH_NOW. Added the following values to Campaign.CampaignPrimaryStatusReasons: HAS_ASSET_GROUPS_DISAPPROVED, HAS_ASSET_GROUPS_LIMITED_BY_POLICY, MOST_ASSET_GROUPS_UNDER_REVIEW. Added the following values to Campaign.RecommendationType: IMPROVE_PERFORMANCE_MAX_AD_STRENGTH, MIGRATE_DYNAMIC_SEARCH_ADS_CAMPAIGN_TO_PERFORMANCE_MAX, PERFORMANCE_MAX_OPT_IN. Added the following values to Recommendation.RecommendationType: IMPROVE_PERFORMANCE_MAX_AD_STRENGTH, MIGRATE_DYNAMIC_SEARCH_ADS_CAMPAIGN_TO_PERFORMANCE_MAX, PERFORMANCE_MAX_OPT_IN. Added views CampaignSearchTermInsight, CustomerSearchTermInsight.
2023-08-03	23.0.8615	Google Ads		Changed	Renamed the following pre-defined views, AccountStats to AccountStatsReport, AccountHourlyStats to AccountHourlyStatsReport, AdGroupStats to AdGroupStatsReport, AdGroupHourlyStats to AdGroupHourlyStatsReport, AdStats to AdStatsReport, AudienceStats to AudienceStatsReport, CampaignStats to CampaignStatsReport, CampaignHourlyStats to CampaignHourlyStatsReport, KeywordStats to KeywordStats Report.
2023-08-02	23.0.8614	Google Ads		Changed	Updated the GoogleAds schema to be compatible with Google Ads API v14.
2023-06-23	23.0.8574	Google Ads		Added	Added ClickViewFiltredReport view. Using this view, filtered operator in DATE column for getting data in multiple days are supported.
2023-06-20	23.0.8571	General		Added	Added the new sys_lastresultinfo system table.
2023-04-25	23.0.8515	General		Removed	Removed support for the SELECT INTO CSV statement. The core code doesn't support it anymore.
2023-04-19	23.0.8509	ADO.NET		Removed	Removed support for EFCore 3.1.
2023-04-18	23.0.8508	ADO.NET		Removed	Removed support for SSRS 2012
2023-04-18	23.0.8508	ADO.NET		Added	Added support for SSRS 2022.
2023-03-23	22.0.8482	Google Ads		Added	Added the following pre-defined views, AccountStats, AccountHourlyStats, AdGroupStats, AdGroupHourlyStats, AdStats, AudienceStats, CampaignStats, CampaignHourlyStats, KeywordStats.
2023-01-25	22.0.8425	Google Ads		Added	Added support for PKCE using the OAuthPKCE auth scheme
2023-01-16	22.0.8416	Google Ads		Changed	Changed FeedItemSet.FeedItemSetDynamicAffiliateLocationSetFilterChainIds's xs:type attribute from 'long' to 'string'. Changed Feed.FeedAffiliateLocationFeedDataChainIds's xs:type attribute from 'long' to 'string'. Changed AssetSet.AssetSetLocationSetBusinessProfileLocationSetListingIdFilters's xs:type attribute from 'long' to 'string'.
2022-12-14	22.0.8383	General		Changed	Added the Default column to the sys_procedureparameters table.
2022-12-06	22.0.8375	Google Ads		Added	Added WriteToFile as an input for CreateReportSchema. If set to True, the schema file will be written to the directory specified by the Location connection property. If set to False, the schema data will either be written to the FileStream or be output as BASE64 encoded data. Defaults to True.
2022-12-06	22.0.8375	Google Ads		Removed	Removed OutputFolder from the CreateReportSchema stored procedure. If WriteToFile is set to true, all schema files will be written to the directory specified by the Location connection property.
2022-11-11	22.0.8350	Google Ads		Added	Updated the driver to be compliant with the v12 release of GoogleAds. Added the following tables PerStoreView, CustomerAssetSet, AssetSetTypeView and AdGroupAssetSet. Added the following column to the AccountLink table, AccountLinkAdvertisingPartnerCustomer. Added the following column to the BiddingStrategy table, BiddingStrategyAlignedCampaignBudgetId. Added the following column to the CampaignBudget table, CampaignBudgetAlignedBiddingStrategyId. Added the following column to the CampaignCriterion table, CampaignCriterionLocationGroupEnableCustomerLevelLocationAssetSet. Added the following column to the LeadFormSubmissionData table, LeadFormSubmissionDataCustomLeadFormSubmissionFields. Added the following column to the AdGroup table, AdGroupExcludedParentAssetSetTypes. Added the following columns to the AdGroupAdAssetView table, AdGroupAdAssetViewPinnedField, ConversionAction. Added the following columns to the Asset table, AssetLocationAssetBusinessProfileLocations, AssetLocationAssetLocationOwnershipType, AssetLocationAssetPlaceId. Added the following columns to the AssetSet table, AssetSetBusinessProfileLocationGroupDynamicBusinessProfileLocationGroupFilterBusinessNameFilterBusinessName, AssetSetBusinessProfileLocationGroupDynamicBusinessProfileLocationGroupFilterBusinessNameFilterFilterType, AssetSetBusinessProfileLocationGroupDynamicBusinessProfileLocationGroupFilterLabelFilters, AssetSetLocationSetBusinessProfileLocationSetBusinessNameFilter, AssetSetLocationSetBusinessProfileLocationSetLabelFilters, AssetSetLocationSetBusinessProfileLocationSetListingIdFilters, AssetSetLocationSetChainLocationSetRelationshipType, AssetSetLocationSetLocationOwnershipType. Added the following columns to the AssetSetAsset table, AbsoluteTopImpressionPercentage, AllConversions, AllConversionsFromInteractionsRate, AllConversionsValue, AverageCost, AverageCpc, AverageCpm, Clicks, Conversions, ConversionsFromInteractionsRate, ConversionsValue, CostMicros, CostPerAllConversions, CostPerConversion, CrossDeviceConversions, Ctr, EngagementRate, Engagements, Impressions, InteractionEventTypes, InteractionRate, Interactions, PhoneCalls, PhoneImpressions, PhoneThroughRate, TopImpressionPercentage, ValuePerAllConversions, ValuePerConversion, AdNetworkType, AssetInteractionTargetAsset, AssetInteractionTargetInteractionOnThisAsset, ClickType, ConversionAction, ConversionActionCategory, ConversionActionName, Date, DayOfWeek, Device, ExternalConversionSource, Month, MonthOfYear, Period, Quarter, Slot, Week, Year. Added the following columns to the Campaign table, CampaignExcludedParentAssetSetTypes, CampaignPrimaryStatus, CampaignPrimaryStatusReasons, AllConversionsFromLocationAssetClickToCall, AllConversionsFromLocationAssetDirections, AllConversionsFromLocationAssetMenu, AllConversionsFromLocationAssetOrder, AllConversionsFromLocationAssetOtherEngagement, AllConversionsFromLocationAssetStoreVisits, AllConversionsFromLocationAssetWebsite, EligibleImpressionsFromLocationAssetStoreReach, PublisherOrganicClicks, PublisherPurchasedClicks, PublisherUnknownClicks, ViewThroughConversionsFromLocationAssetClickToCall, ViewThroughConversionsFromLocationAssetDirections, ViewThroughConversionsFromLocationAssetMenu, ViewThroughConversionsFromLocationAssetOrder, ViewThroughConversionsFromLocationAssetOtherEngagement, ViewThroughConversionsFromLocationAssetStoreVisits, ViewThroughConversionsFromLocationAssetWebsite. Added the following value to AccountLink.AccountLinkType: ADVERTISING_PARTNER. Added the following value to AdGroup.AdGroupExcludedParentAssetFieldTypes: AD_IMAGE. Added the following value to AdGroupAdAssetView.AdGroupAdAssetViewFieldType: AD_IMAGE. Added the following value to AdGroupAsset.AdGroupAssetFieldType: AD_IMAGE. Added the following value to Asset.AssetType: LOCATION. Added the following value to AssetFieldTypeView.AssetFieldTypeViewFieldType: AD_IMAGE. Added the following value to AssetGroupAsset.AssetGroupAssetFieldType: AD_IMAGE. Added the following value to Campaign.CampaignExcludedParentAssetFieldTypes: AD_IMAGE. Added the following value to Campaign.RecommendationType: FORECASTING_SET_TARGET_ROAS, RAISE_TARGET_CPA_BID_TOO_LOW. Added the following value to CampaignAsset.CampaignAssetFieldType: AD_IMAGE. Added the following value to CustomerAsset.CustomerAssetFieldType: AD_IMAGE. Added the following value to Recommendation.RecommendationType: FORECASTING_SET_TARGET_ROAS, RAISE_TARGET_CPA_BID_TOO_LOW. Added the following values to AssetSet.AssetSetType: BUSINESS_PROFILE_DYNAMIC_LOCATION_GROUP, CHAIN_DYNAMIC_LOCATION_GROUP, LOCATION_SYNC, STATIC_LOCATION_GROUP. Added the following values to OfflineUserDataJob.OfflineUserDataJobFailureReason: HIGH_AVERAGE_TRANSACTION_VALUE, LOW_AVERAGE_TRANSACTION_VALUE, NEWLY_OBSERVED_CURRENCY_CODE.
2022-11-11	22.0.8350	Google Ads		Changed	Updated the schema to be compatible with Google Ads API v12. The default APIVersion is now v12. Google has sunset V9. v10 will sunset on January 2023. v11 will sunset on March/April 2023. Renamed ExperimentArm.ExperimentArmTrial to ExperimentArm.ExperimentArmExperiment.
2022-11-11	22.0.8350	Google Ads		Removed	Removed the following columns from the AdGroupAd table, AdGroupAdAdGmailAdHeaderImage, AdGroupAdAdGmailAdMarketingImage, AdGroupAdAdGmailAdMarketingImageDescription,AdGroupAdAdGmailAdMarketingImageDisplayCallToActionText, AdGroupAdAdGmailAdMarketingImageDisplayCallToActionTextColor, AdGroupAdAdGmailAdMarketingImageDisplayCallToActionUrlCollectionId,AdGroupAdAdGmailAdMarketingImageHeadline, AdGroupAdAdGmailAdProductImages, AdGroupAdAdGmailAdProductVideos, AdGroupAdAdGmailAdTeaserBusinessName, AdGroupAdAdGmailAdTeaserDescription,AdGroupAdAdGmailAdTeaserHeadline, AdGroupAdAdGmailAdTeaserLogoImage. Removed the following value from AdGroupAd.AdGroupAdAdType: GMAIL_AD.
2022-11-11	22.0.8350	Google Ads		Deprecated	Deprecated CampaignExperiment. This table can only be used with APIVersion v11 or older.
2022-10-13	22.0.8321	Google Ads		Deprecated	The ClientCustomerId field now has support for multiple ids in addition to All, which will use all currently active ids. SELECT CustomerID FROM Customer can now be used to retrieve all the client's ids.
2022-09-30	22.0.8308	General		Changed	Added the IsPath column to the sys_procedureparameters table.
2022-09-01	22.0.8279	Google Ads		Added	Updated the driver to be compliant with the v11 release of GoogleAds. Added the following tables, LeadFormSubmissionData and CampaignGroup. Added the following columns to the AccountLink table, AccountLinkHotelCenterHotelCenterId. Added the following columns to the AdGroup table, AssetInteractionTargetAsset, AssetInteractionTargetInteractionOnThisAsset, AuctionInsightDomain. Added the following columns to the AdGroupAd table, AdGroupAdAdDiscoveryCarouselAdBusinessName, AdGroupAdAdDiscoveryCarouselAdCallToActionText, AdGroupAdAdDiscoveryCarouselAdCarouselCards, AdGroupAdAdDiscoveryCarouselAdDescription, AdGroupAdAdDiscoveryCarouselAdHeadline, AdGroupAdAdDiscoveryCarouselAdLogoImage, AdGroupAdAdDiscoveryMultiAssetAdBusinessName, AdGroupAdAdDiscoveryMultiAssetAdCallToActionText, AdGroupAdAdDiscoveryMultiAssetAdDescriptions, AdGroupAdAdDiscoveryMultiAssetAdHeadlines, AdGroupAdAdDiscoveryMultiAssetAdLeadFormOnly, AdGroupAdAdDiscoveryMultiAssetAdLogoImages, AdGroupAdAdDiscoveryMultiAssetAdMarketingImages, AdGroupAdAdDiscoveryMultiAssetAdPortraitMarketingImages, AdGroupAdAdDiscoveryMultiAssetAdSquareMarketingImages, AdGroupAdAdVideoResponsiveAdBreadcrumb1, AdGroupAdAdVideoResponsiveAdBreadcrumb2. Added the following columns to the AdGroupAdAssetCombinationView table, AdGroupAdAssetCombinationViewEnabled. Added the following columns to the AdGroupAsset table, AdGroupAssetSource. Added the following columns to the AdGroupAudienceView table, AbsoluteTopImpressionPercentage, TopImpressionPercentage. Added the following columns to the Asset table, AssetDiscoveryCarouselCardAssetCallToActionText, AssetDiscoveryCarouselCardAssetHeadline, AssetDiscoveryCarouselCardAssetMarketingImageAsset, AssetDiscoveryCarouselCardAssetPortraitMarketingImageAsset, AssetDiscoveryCarouselCardAssetSquareMarketingImageAsset, AssetDynamicCustomAssetAndroidAppLink, AssetDynamicCustomAssetContextualKeywords, AssetDynamicCustomAssetFormattedPrice, AssetDynamicCustomAssetFormattedSalePrice, AssetDynamicCustomAssetId, AssetDynamicCustomAssetId2, AssetDynamicCustomAssetImageUrl, AssetDynamicCustomAssetIosAppLink, AssetDynamicCustomAssetIosAppStoreId, AssetDynamicCustomAssetItemAddress, AssetDynamicCustomAssetItemCategory, AssetDynamicCustomAssetItemDescription, AssetDynamicCustomAssetItemSubtitle, AssetDynamicCustomAssetItemTitle, AssetDynamicCustomAssetPrice, AssetDynamicCustomAssetSalePrice, AssetDynamicCustomAssetSimilarIds, AssetDynamicFlightsAssetAndroidAppLink, AssetDynamicFlightsAssetCustomMapping, AssetDynamicFlightsAssetDestinationId, AssetDynamicFlightsAssetDestinationName, AssetDynamicFlightsAssetFlightDescription, AssetDynamicFlightsAssetFlightPrice, AssetDynamicFlightsAssetFlightSalePrice, AssetDynamicFlightsAssetFormattedPrice, AssetDynamicFlightsAssetFormattedSalePrice, AssetDynamicFlightsAssetImageUrl, AssetDynamicFlightsAssetIosAppLink, AssetDynamicFlightsAssetIosAppStoreId, AssetDynamicFlightsAssetOriginId, AssetDynamicFlightsAssetOriginName, AssetDynamicFlightsAssetSimilarDestinationIds, AssetDynamicHotelsAndRentalsAssetAddress, AssetDynamicHotelsAndRentalsAssetAndroidAppLink, AssetDynamicHotelsAndRentalsAssetCategory, AssetDynamicHotelsAndRentalsAssetContextualKeywords, AssetDynamicHotelsAndRentalsAssetDescription, AssetDynamicHotelsAndRentalsAssetDestinationName, AssetDynamicHotelsAndRentalsAssetFormattedPrice, AssetDynamicHotelsAndRentalsAssetFormattedSalePrice, AssetDynamicHotelsAndRentalsAssetImageUrl, AssetDynamicHotelsAndRentalsAssetIosAppLink, AssetDynamicHotelsAndRentalsAssetIosAppStoreId, AssetDynamicHotelsAndRentalsAssetPrice, AssetDynamicHotelsAndRentalsAssetPropertyId, AssetDynamicHotelsAndRentalsAssetPropertyName, AssetDynamicHotelsAndRentalsAssetSalePrice, AssetDynamicHotelsAndRentalsAssetSimilarPropertyIds, AssetDynamicHotelsAndRentalsAssetStarRating, AssetDynamicJobsAssetAddress, AssetDynamicJobsAssetAndroidAppLink, AssetDynamicJobsAssetContextualKeywords, AssetDynamicJobsAssetDescription, AssetDynamicJobsAssetImageUrl, AssetDynamicJobsAssetIosAppLink, AssetDynamicJobsAssetIosAppStoreId, AssetDynamicJobsAssetJobCategory, AssetDynamicJobsAssetJobId, AssetDynamicJobsAssetJobSubtitle, AssetDynamicJobsAssetJobTitle, AssetDynamicJobsAssetLocationId, AssetDynamicJobsAssetSalary, AssetDynamicJobsAssetSimilarJobIds, AssetDynamicLocalAssetAddress, AssetDynamicLocalAssetAndroidAppLink, AssetDynamicLocalAssetCategory, AssetDynamicLocalAssetContextualKeywords, AssetDynamicLocalAssetDealId, AssetDynamicLocalAssetDealName, AssetDynamicLocalAssetDescription, AssetDynamicLocalAssetFormattedPrice, AssetDynamicLocalAssetFormattedSalePrice, AssetDynamicLocalAssetImageUrl, AssetDynamicLocalAssetIosAppLink, AssetDynamicLocalAssetIosAppStoreId, AssetDynamicLocalAssetPrice, AssetDynamicLocalAssetSalePrice, AssetDynamicLocalAssetSimilarDealIds, AssetDynamicLocalAssetSubtitle, AssetDynamicRealEstateAssetAddress, AssetDynamicRealEstateAssetAndroidAppLink, AssetDynamicRealEstateAssetCityName, AssetDynamicRealEstateAssetContextualKeywords, AssetDynamicRealEstateAssetDescription, AssetDynamicRealEstateAssetFormattedPrice, AssetDynamicRealEstateAssetImageUrl, AssetDynamicRealEstateAssetIosAppLink, AssetDynamicRealEstateAssetIosAppStoreId, AssetDynamicRealEstateAssetListingId, AssetDynamicRealEstateAssetListingName, AssetDynamicRealEstateAssetListingType, AssetDynamicRealEstateAssetPrice, AssetDynamicRealEstateAssetPropertyType, AssetDynamicRealEstateAssetSimilarListingIds, AssetDynamicTravelAssetAndroidAppLink, AssetDynamicTravelAssetCategory, AssetDynamicTravelAssetContextualKeywords, AssetDynamicTravelAssetDestinationAddress, AssetDynamicTravelAssetDestinationId, AssetDynamicTravelAssetDestinationName, AssetDynamicTravelAssetFormattedPrice, AssetDynamicTravelAssetFormattedSalePrice, AssetDynamicTravelAssetImageUrl, AssetDynamicTravelAssetIosAppLink, AssetDynamicTravelAssetIosAppStoreId, AssetDynamicTravelAssetOriginId, AssetDynamicTravelAssetOriginName, AssetDynamicTravelAssetPrice, AssetDynamicTravelAssetSalePrice, AssetDynamicTravelAssetSimilarDestinationIds, AssetDynamicTravelAssetTitle, AssetLeadFormAssetCustomQuestionFields, AssetSource. Added the following columns to the AssetGroup table, AssetGroupAdStrength. Added the following columns to the AssetSet table, AssetSetId. Added the following columns to the Campaign table, CampaignBiddingStrategySystemStatus, CampaignCampaignGroup, CampaignLocalServicesCampaignSettingsCategoryBids, CampaignManualCpa, CampaignPerformanceMaxUpgradePerformanceMaxCampaign, CampaignPerformanceMaxUpgradePreUpgradeCampaign, CampaignPerformanceMaxUpgradeStatus, CampaignShoppingSettingFeedLabel, AllConversionsFromClickToCall, AllConversionsFromDirections, AllConversionsFromMenu, AllConversionsFromOrder, AllConversionsFromOtherEngagement, AllConversionsFromStoreVisit, AllConversionsFromStoreWebsite, AssetInteractionTargetAsset, AssetInteractionTargetInteractionOnThisAsset, AuctionInsightDomain, SkAdNetworkAttributionCredit. Added the following columns to the CampaignAsset table, CampaignAssetSource. Added the following columns to the CampaignAudienceView table, AbsoluteTopImpressionPercentage, TopImpressionPercentage. Added the following columns to the ConversionAction table, ConversionActionFirebaseSettingsPropertyId, ConversionActionFirebaseSettingsPropertyName, AllConversions, AllConversionsValue, Date, Month, Period, Quarter, Week. Added the following columns to the Customer table, CustomerConversionTrackingSettingGoogleAdsConversionCustomer. Added the following columns to the CustomerAsset table, CustomerAssetSource. Added the following columns to the KeywordView table, AuctionInsightDomain. Added the following columns to the Recommendation table, RecommendationDisplayExpansionOptInRecommendation, RecommendationResponsiveSearchAdImproveAdStrengthRecommendation, RecommendationUpgradeLocalCampaignToPerformanceMaxRecommendation, RecommendationUpgradeSmartShoppingCampaignToPerformanceMaxRecommendation. Added the following columns to the SmartCampaignSetting table, SmartCampaignSettingAdOptimizedBusinessProfileSettingIncludeLeadForm, SmartCampaignSettingBusinessProfileLocation. Added the following columns to the UserList table, UserListRuleBasedUserListFlexibleRuleUserListExclusiveOperands, UserListRuleBasedUserListFlexibleRuleUserListInclusiveOperands, UserListRuleBasedUserListFlexibleRuleUserListInclusiveRuleOperator.
2022-09-01	22.0.8279	Google Ads		Changed	Updated the schema to be compatible with Google Ads API v11. The default APIVersion is now v11. Google has sunset v7 and v8. V9 will sunset on September 2022. Renamed AccessibleBiddingStrategy.AccessibleBiddingStrategyMaximizeConversionsTargetCpa to AccessibleBiddingStrategy.AccessibleBiddingStrategyMaximizeConversionsTargetCpaMicros. Renamed BiddingStrategy.BiddingStrategyMaximizeConversionsTargetCpa to BiddingStrategy.BiddingStrategyMaximizeConversionsTargetCpaMicros. Renamed Campaign.CampaignMaximizeConversionsTargetCpa to Campaign.CampaignMaximizeConversionsTargetCpaMicros. Removed SmartCampaignSettings.SmartCampaignSettingBusinessLocationId. Removed UserList.UserListRuleBasedUserListDateSpecificRuleUserListEndDate. Removed UserList.UserListRuleBasedUserListDateSpecificRuleUserListRuleRuleItemGroups. Removed UserList.UserListRuleBasedUserListDateSpecificRuleUserListRuleRuleType. Removed UserList.UserListRuleBasedUserListDateSpecificRuleUserListStartDate. Removed 'SMART_DISPLAY' value for ExperimentType column (Experiment table).
2022-07-01	22.0.8217	Google Ads		Added	Added support for Google Ads Native Queries with Query Passthrough.
2022-06-23	22.0.8209	Google Ads		Added	Added back embedded credentials.
2022-06-08	22.0.8194	ADO.NET		Removed	Removed support for VS2010.
2022-05-19	22.0.8174	ADO.NET		Removed	Removed support for .NET 2.0.
2022-04-27	22.0.8152	ADO.NET		Removed	Removed support for EFCore 3.0 and EFCore5.0.
2022-04-22	22.0.8147	Google Ads		Removed	Removed the AdWords schema as it has been sunset.
2022-03-23	21.0.8117	Google Ads		Added	Added support for using predefined date ranges by introducing the Period column to many tables.
2022-03-04	21.0.8098	Google Ads		Added	Added the tables AdGroupAdAssetCombinationView, AssetGroupSignal, Audience, Experiment, ExperimentArm Added the following columns to the AdGroup table: AdGroupAudienceSettingUseAudienceGrouped, AdGroupEffectiveCpcBidMicros Added the following columns to the AdGroupAdAssetView table: BiddableAppInstallConversions, BiddableAppPostInstallConversions Added the following columns to the AdGroupCriterion table: AdGroupCriterionAudienceAudience Added the following columns to the Campaign table: CampaignAudienceSettingUseAudienceGrouped, CampaignShoppingSettingUseVehicleInventory, SkAdNetworkAdEventType, SkAdNetworkSourceAppSkAdNetworkSourceAppId, SkAdNetworkUserType Added the following columns to the ConversionValueRuleSet table: ConversionValueRuleSetConversionActionCategories Added the following columns to the Customer table: CustomerConversionTrackingSettingAcceptedCustomerDataTerms, CustomerConversionTrackingSettingConversionTrackingStatus, CustomerConversionTrackingSettingEnhancedConversionsForLeadsEnabled, CustomerStatus Added the following columns to the CustomerClient table: CustomerClientStatus Added the following columns to the GeographicView table: AbsoluteTopImpressionPercentage, TopImpressionPercentage Added the following columns to the HotelReconciliation table: HotelReconciliationCampaign, HotelCommissionRateMicros, HotelExpectedCommissionCost Added the following columns to the Recommendation table: RecommendationResponsiveSearchAdAssetRecommendation, RecommendationUseBroadMatchKeywordRecommendation
2022-03-04	21.0.8098	Google Ads		Changed	Updated the GoogleAds schema to be compatible with Google Ads API v10. Renamed AdGroupAd.AdGroupAdAdVideoAdDiscoveryDescription1 to AdGroupAd.AdGroupAdAdVideoAdInFeedDescription1 Renamed AdGroupAd.AdGroupAdAdVideoAdDiscoveryDescription2 to AdGroupAd.AdGroupAdAdVideoAdInFeedDescription2 Renamed AdGroupAd.AdGroupAdAdVideoAdDiscoveryHeadline to AdGroupAd.AdGroupAdAdVideoAdInFeedHeadline Renamed AdGroupAd.AdGroupAdAdVideoAdDiscoveryThumbnail to AdGroupAd.AdGroupAdAdVideoAdInFeedThumbnail
2022-02-09	21.0.8075	Google Ads		Added	Added support for using CustomerId in a query. For example, let's say you have a lot of accounts from which you want to get data. Instead of opening multiple connections, each with their own ClientCustomerId connection property, you can now specify the customer ids in a list: SELECT * FROM AdGroupAd WHERE CustomerId IN ('1111111111', '2222222222'). You can also specify just one CustomerId: SELECT * FROM AdGroupAd WHERE CustomerId='3333333333'
2022-02-09	21.0.8075	Google Ads		Changed	ClientCustomerId is no longer a required connection property.
2022-02-09	21.0.8075	Google Ads		Removed	Removed unsupported columns from the tables: AdGroup, AdGroupAd, BiddingStrategy, Campaign, KeywordView. The unsupported columns can not be selected if the table is specified in the FROM clause of the query.
2021-11-12	21.0.7986	Google Ads		Added	Added the tables: AdGroupCriterionCustomizer, AdGroupCustomizer, AssetGroup, AssetGroupAsset, AssetGroupListingGroupFilter, AssetSet, AssetSetAsset, CampaignAssetSet, CampaignConversionGoal, CampaignCustomizer, ConversionGoalCampaignConfig, CustomConversionGoal, CustomerConversionGoal, CustomerCustomizer, CustomizerAttribute, HotelReconciliation.
2021-11-12	21.0.7986	Google Ads		Changed	The view Resources now shows the resource name, attribute resources and segmenting resources. They are needed when executing the stored procedure CreateReportSchema.
2021-11-12	21.0.7986	Google Ads		Removed	Removed CustomerId from the following tables where it is not available: CarrierConstant, CurrencyConstant, GeoTargetConstant, KeywordThemeConstant, LanguageConstant, LifeEvent, HotelPerformanceView, MobileAppCategoryConstant, MobileDeviceConstant, OperatingSystemVersionConstant, ProductBiddingCategoryConstant, TopicConstant, UserInterest
2021-11-04	21.0.7978	Google Ads		Added	Added the following columns to the Asset table: AssetCallAssetAdScheduleTargets, AssetCallAssetCallConversionAction, AssetCallAssetCallConversionReportingState, AssetCallAssetCountryCode, AssetCallAssetPhoneNumber, AssetCallToActionAssetCallToAction, AssetHotelCalloutAssetLanguageCode, AssetHotelCalloutAssetText, AssetMobileAppAssetAppId, AssetMobileAppAssetAppStore, AssetMobileAppAssetEndDate, AssetMobileAppAssetLinkText, AssetMobileAppAssetStartDate, AssetPriceAssetLanguageCode, AssetPriceAssetPriceOfferings, AssetPriceAssetPriceQualifier, AssetPriceAssetType. Added the following columns to the BiddingStrategy table: BiddingStrategyMaximizeConversionValueCpcBidCeilingMicros, BiddingStrategyMaximizeConversionValueCpcBidFloorMicros, BiddingStrategyMaximizeConversionValueTargetRoas, BiddingStrategyMaximizeConversionsCpcBidCeilingMicros, BiddingStrategyMaximizeConversionsCpcBidFloorMicros, BiddingStrategyMaximizeConversionsTargetCpa.
2021-11-04	21.0.7978	Google Ads		Changed	Updated the GoogleAds schema to be compatible with Google Ads API v9.
2021-09-02	21.0.7915	General		Added	Added support for the STRING_SPLIT table-valued function in the CROSS APPLY clause.
2021-08-07	21.0.7889	General		Changed	Added the KeySeq column to the sys_foreignkeys table.
2021-08-06	21.0.7888	General		Changed	Added the new sys_primarykeys system table.
2021-07-23	21.0.7874	General		Changed	Updated the Literal Function Names for relative date/datetime functions. Previously, relative date/datetime functions resolved to a different value when used in the projection as opposed to the predicate. For example: SELECT LAST_MONTH() AS lm, Col FROM Table WHERE Col > LAST_MONTH(). Formerly, the two LAST_MONTH() methods would resolve to different datetimes. Now, they will match. As a replacement for the previous behavior, the relative date/datetime functions in the criteria may have an 'L' appended to them. For example: WHERE col > L_LAST_MONTH(). This will continue to resolve to the same values that were previously calculated in the criteria. Note that the "L_" prefix will only work in the predicate - it not available for the projection.
2021-07-21	21.0.7872	Google Ads		Removed	Removed the embedded credentials since they are no longer working for other Developer Keys.
2021-06-21	21.0.7842	Google Ads		Added	Added the connection property APIVersion, which defaults to v8. This connection property controls the Google Ads API version.
2021-06-21	21.0.7842	Google Ads		Changed	Updated the GoogleAds schema to be compatible with Google Ads API v8. Renamed the v201809 schema to AdWords, and the googleadsv6 schema to GoogleAds.
2021-06-18	21.0.7839	Google Ads		Added	Added support for the GOOGLEJSONBLOB JWT certificate type. This works like the existing GOOGLEJSON certificate type except that the certificate is provided as JSON text instead of as a file path.
2021-06-07	21.0.7828	ADO.NET		Added	Added support for the DbCommand.CommandTimeout property.
2021-05-29	21.0.7819	ADO.NET		Removed	Removed support for SSRS 2008.
2021-04-23	21.0.7783	General		Changed	Updated how display sizes are determined for varchar primary key and foreign key columns so they will match the reported length of the column.
2021-04-16	21.0.7776	ADO.NET		Changed	Separated the ADO.NET Provider assembly and Entity Framework Core 5 Nuget packages. Single precision floating point numbers are now reported as with the Data Type Name as "real". Double precision floating point numbers now have their Data Type Name reported as "float". This change does not impact the actual data types of these columns - only the reported data type name. Separate EFCore 3.0, 3.1 and EFCore 5 dlls are now shipped with the driver. The 2.0 and 2.1 EFCore dlls are removed.
2021-04-16	21.0.7776	General		Changed	Reduced the length to 255 for varchar primary key and foreign key columns.
2021-04-16	21.0.7776	General		Changed	Updated implicit and metadata caching to improve performance and support for multiple connections. Old metadata caches are not compatible - you need to generate new metadata caches if you are currently using CacheMetadata.
2021-04-16	21.0.7776	General		Changed	Updated index naming convention to avoid duplicates.
2020-11-15	20.0.7624	Google Ads		Added	Added schema GoogleAdsV6 which uses the Google Ads API V6 to connect to Google Ads data. Added the corresponding 'Data Model' subsection in the Help Documentation. Removed deprecated columns (GoogleAdsV3 and GoogleAdsV6 schemas): HotelPerformanceView.CustomerId and BiddingStrategyTargetOutrankShareCompetitorDomain, BiddingStrategyTargetOutrankShareCpcBidCeilingMicros, BiddingStrategyTargetOutrankShareOnlyRaiseCpcBids, BiddingStrategyTargetOutrankShareRaiseCpcBidWhenQualityScoreIsLow, BiddingStrategyTargetOutrankShareTargetOutrankShareMicros from the BiddingStrategy View. The aggregate column AdGroupAdPolicySummary in the AdGroupAd and AdGroupAdAssetView views of the GoogleAdsV6 schema has been expanded to AdGroupAdPolicySummaryApprovalStatus, AdGroupAdPolicySummaryPolicyTopicEntries, AdGroupAdPolicySummaryReviewStatus. Added new columns (GoogleAdsV6 schema): Customer.CustomerOptimizationScore, AdGroupCriterion.AdGroupCriterionDisapprovalReasons, HotelGroupView.HotelEligibleImpressions, HotelPerformanceView.HotelEligibleImpressions, BiddingStrategy.BiddingStrategyEffectiveCurrencyCode, ClickView.ClickViewCampaignLocationTarget, ClickView.ClickViewUserList, CampaignCriterion.CampaignCriterionCustomAudience, AdGroupCriterion. AdGroupCriterionCustomAudience, Customer.CustomerOptimizationScoreWeight.

ADO.NET Provider for Google Ads

Changelog

General Changes