SSIS Components for Microsoft Ads

Build 24.0.9175

AssetGroups

Query the available Asset Groups in Bing Ads.

Table Specific Information

Select

The following queries are processed server-side:

SELECT * FROM AssetGroups
SELECT * FROM AssetGroups WHERE CampaignId = '2562405'
SELECT * FROM AssetGroups WHERE CampaignId IN ('1562405', '2562405', '3562405')
SELECT * FROM AssetGroups WHERE AccountId = '2562405'
SELECT * FROM AssetGroups WHERE AccountId IN ('1562405', '2562405', '3562405')

Columns

Name Type Select requirement Metric Aggregate Description
Id [KEY] Long The asset group ID.
Name String The name of the asset group.
BusinessName String The name of the business.
Status String The status of the Asset group.
EditorialStatus String The editorial review status of the asset group, which indicates whether the asset group is pending review, has been approved, or has been disapproved.
CallToAction String A brief, punchy reason for customers to click your ad right now.
FinalUrls String The landing page URL.
FinalMobileUrls String The mobile landing page URL.
Path1 String The first part of the optional path that will be appended to the domain portion of your display URL.
Path2 String The second part of the optional path that will be appended to the domain portion of your display URL.
StartDate Date The date that the asset group can begin serving; otherwise, the service can begin serving ads the day that the asset group becomes active.
EndDate Date The date that the asset group will expire.
Descriptions String The descriptions that are shown below the path in your ad.
Headlines String Short headlines that appear in your ad.
LongHeadlines String Long headlines that appear in your ad.
Images String Image assets with different sizes and aspect ratios so they can flexibly display across a variety of publishers and placements.
AssetGroupSearchThemes String A list of asset group search themes.
CampaignId Long The system generated identifier of the campaign.
AccountId Long The Bing Ads assigned identifier of an account.

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