Account Ad Extensions structure with information of whether extension is bind to campaign or to an ad group

[Александр Великий]

Hi,

I'm writing AdWords script to get all campaigns and their extensions with their approval status. As approval status cannot be get by AdWords script methods, I need to send AWQL request and that's why I think I ask this question at right Forum.

As I found out, PLACEHOLDER_FEED_ITEM_REPORT report is what I need. But I've got two problems with it:

1) There is no way for me to know whether feed item (extension) is bind to Campaign or an Ad group. 

2) I've just created two new callout extension: one at AdGroup level and another at Campaign's. None of them are present in report.

[Shwetha Vastrad (AdWords API Team)]

Hi Alex,

The TargetingAdGroupId and TargetingCampaignId fields in Placeholder Feed Item Report provide the feed item's adGroupTargeting and campaignTargeting. The AdGroupId and CampaignId fields will segment the data according to AdGroup and Campaign respectively, based on where the extensions were used. As for your second problem, you need to request for zero impressions rows by including a WHERE Impressions >= 0 condition in the report query. 

Let me know if this works. 

Regards,

Shwetha, AdWords API Team.

[Александр Великий]

Hi Shwetha,

I've tried that and I have zeros in both TargetingCampaignId and TargetingAdGroupId columns.

Impressions >=0 didn't make any change.

Here's my query:

Select ValidationDetails, FeedId, FeedItemId, PlaceholderType, Status, TargetingCampaignId, TargetingAdGroupId, CampaignName, AttributeValues  from PLACEHOLDER_FEED_ITEM_REPORT WHERE Impressions >= 0 AND CampaignName='Fiinbh.ru'"

[Shwetha Vastrad (AdWords API Team)]

Hi Alex,

Are you using any DURING clause in the report query? Also, I see that you have included CampaignName in the query, which doesn't support zero impressions. If this campaign doesn't have any impression data for the time period specified, zero impression rows will not be included in the report. If this doesn't help, I suggest you post your query in the AdWords Scripts forum as they are better equipped to help you out. 

[Александр Великий]

Hi Shwetha,

I'm not using DURING clause. I've just tried to use it with TODAY value and got no rows event with WHERE Impressions >= 0 clause.

I did include CampaignName in a query as I want to see extensions and campaigns that they belong to.

I'm going to write to AdWords Script forum, but I think that this question refers more to current forum.

I'll try to reword my question:

What is the query to get campaign level only extensions and their approval satus for each capaign in account? 

[Shwetha Vastrad (AdWords API Team)]

Hi Alex,

To get the extensions at the Campaign level, you need to perform a CampaignExtensionService.get request in AdWords API. If you had specifically set the targetingCampaignId while adding the extension, this information would be available in the TargetingCampaignId field in Placeholder Feed Item Report. But if you hadn't, requesting for CampaignName in the query wouldn't help if this extension doesn't have any impressions. To get the approval status of your extensions, you can use the following query: 

"SELECT FeedId, FeedItemId, Status, AttributeValues, PlaceholderType, TargetingAdGroupId, TargetingCampaignId, ValidationDetails FROM PLACEHOLDER_FEED_ITEM_REPORT WHERE Impressions >= 0"

Please note this wouldn't provide the campaignIds associated with your extensions. You would need to query for CampaignExtensions separately.

[Александр Великий]

Did I get it right?

1. If extensions were created through AdWords interface there is no way to get whether they are of campaign or adgroup level with AdWords query to PLACEHOLDER_FEED_ITEM_REPORT.
   
2. If extension didn't have impressions, there is no way to get it with PLACEHOLDER_FEED_ITEM_REPORT.
   
3. To get ids of campaign level extensions, I need to use AdWords Script's AdWordsApp.​CampaignExtensions() method.
   

[Shwetha Vastrad (AdWords API Team)]

Hi Alex,

Please see my responses below:

1. If your extensions do not have any impressions, you'll not be ale to get the campaign-level or adGroup-level breakout from Placeholder Feed Item Report. 
2. You can get your extensions using reports even if they don't have any impressions. You shouldn't include any fields which do not support zero impressions in the report query.
3. Yes, to get the a list of all the campaign level extensions, you need to use AdWords Script's AdWordsApp.​CampaignExtensions() method.