SSIS Components for Microsoft Ads

Build 24.0.9175

Audiences

Query the available Audiences in Bing Ads.

Table Specific Information

Select

The following queries are processed server-side:

SELECT * FROM Audiences
SELECT * FROM Audiences WHERE Type = 'RemarketingList'
SELECT * FROM Audiences WHERE AccountId = '65098547' AND Type = 'RemarketingList'

Columns

Name Type Select requirement Metric Aggregate Description
Id [KEY] Long The Bing Ads identifier of the audience.
ParentId Long The Bing Ads identifier of the account or customer.
Name String The name of the audience. The name can contain a maximum of 128 characters.
Type String The type of the audience.

The allowed values are RemarketingList, Custom, InMarket, Product, SimilarRemarketingList, CombinedList, CustomerList.

Description String The description of the audience. Use a description to help you remember what audience you are targeting.
MembershipDuration Int When you create an audience, you can specify how far back in time Bing Ads should look for actions that match your audience definition.
ForwardCompatibilityMap String The list of key and value strings for forward compatibility. This element can be used to avoid otherwise breaking changes when new elements are added in future releases.
Scope String Scope defines what accounts can use this audience.

The allowed values are Account, Customer.

TagId Long The unique Bing Ads identifier of the tag.
AudienceNetworkSize Long The total number of people who are active members of this audience in the Audience network.
SearchSize Long The total number of people who are active members of this audience in the Search network.
SupportedCampaignTypes String The list of campaign types that support this audience.
CustomerShareAggregate String Contains information about CustomerAccountShares and OwnerCustomerId.
CombinationRules String Logical conditions used to determine who to add to your combined list.
AdGroupId Long The ad group identifier to associate with the impression-based remarketing list.
CampaignId Long The campaign identifier to associate with the impression-based remarketing list.
EntityType String The entity type of an impression-based remarketing list.
ProductAudienceType String Determines whether to remarket your products to general visitors, product searchers, product viewers, shopping cart abandoners, or past buyers.
RuleType String The type of the remarketing rule.
RuleNormalForm String Determines whether the rule item groups are evaluated based on conjunctive normal form (CNF) or disjunctive normal form (DNF).
RuleItemGroups String The list of rule item groups that you want applied to the remarketing list.
RuleAnotherRuleItemGroups String The list of rule item groups related to other pages the audience visited.
RuleExcludeRuleItemGroups String The list of rule item groups that you want applied as exclusions to the remarketing list.
RuleIncludeRuleItemGroups String The list of rule item groups that you want applied to the remarketing list.
RuleActionOperator String The operator that can be applied to the value of the Action element.
RuleAction String The type of user interaction you want to track. For example 'play' or 'pause'.
RuleCategoryOperator String The operator that can be applied to the value of the Category element.
RuleCategory String The category of event you want to track. For example, 'video'.
RuleLabelOperator String The operator that can be applied to the value of the Label element.
RuleLabel String The name of the element that caused the action. For example 'trailer' or 'behindthescenes'.
RuleValueOperator String The operator that can be applied to the value of the Value element.
RuleValue Int A positive integer value associated with that event. For example the value could be the duration of time that the video played.
SourceId Long The ID of the remarketing list that Bing Ads used to generate this similar audience.
AccountId Long The Bing Ads assigned identifier of an account.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175