Problems working with the report Placeholderitem_feed report. I can't find a variable.

[Jorge Lopez Marcos]

Hello everyone!

I was just working with the PLACEHOLDER_FEED_ITEM_REPORT, in which I'm interested in extracting the following values:

• AdGroup_Id

• Ad_Id

• Campaing_Id

• External_Customer_Id

• Feed_id

• FeedItem_Id

• Attribute_Values

• Placeholder_type

• Level

I've been succesfully able to extract all of the variables except one of them. Level.

At the time of downloading manually the report from the web page, I can select that value, which shows me at which level the ad customizer is declared ( AdGroup, Campaing or Account).

I would like to do the same with the report. But i can't find any variable which returns me that value.

Is it possible with that report (PLACEHOLDER_FEED_ITEM_REPORT ) find out at which level the ad customizer is declared??

Thank you very much in advance. :D

[Google Ads API Forum Advisor Prod]

Hello Jorge, 

You could use the TargetingAdGroupId and TargetingCampaignId in the PLACEHOLDER_FEED_ITEM_REPORT. Could you please give this a try and let us know if you have any issues?

Thanks,
Bharani, Google Ads API Team

ref:_00D1U1174p._5001UBnv3q:ref

[Jorge Lopez Marcos]

Hi!

I tried to include those two variables in the report but they returned 0  in all the rows( Which are not empty and the rest of the variables are returned perfectly).

I tried other reports with  other accounts, and It happend the same.

Which is kind strange, I belive that one of the variables at least must have a value different from 0.

Or does it mean that the ad customizer is declared at account level?

I hope that helps

thank you for your response and time!

[Google Ads API Forum Advisor Prod]

Hello Jorge, 

Thank you for clarifying this. The Placeholder Report and the Placeholder Feed Item Report will return the feed based ad extensions data. You may use the AD_CUSTOMIZERS_FEED_ITEM_REPORT to pull the Ad Customizers data. I was able to pull the data using the query below:

__rdquery: SELECT FeedId, FeedItemId, TargetingAdGroupId, TargetingCampaignId, KeywordTargetingId, GeoTargetingCriterionId FROM AD_CUSTOMIZERS_FEED_ITEM_REPORT WHERE FeedId IN ["xxxxxxxx"]

Please give this a try and let us know if you have any issues.

Thanks,
Bharani, Google Ads API Team

ref:_00D1U1174p._5001UBnv3q:ref

[Jorge Lopez Marcos]

Hello Bharani.

I tried you query, but again TargetingCampaignId, TargetingAdGroupId are returned as 0. All the variables are returned OK, except those two...

[Google Ads API Forum Advisor Prod]

Hi Jorge, 

Could you please share the client customer Id, using Reply privately to author option, to check this further?

[Jorge Lopez Marcos]

Any updates or news about the topic and the solution?

[Google Ads API Forum Advisor Prod]

Hello Jorge, 

I have replied privately to you with the response. Please find the response below: 

Thank you for sharing the details. I was able to pull the Ad Customizers Feed Item report to pull the targeting data. It looks like the specific feed is targeted based on location and hence only the location Id is returned. The TargetingAdGroupId and TargetingCampaignId attributes in this feed are not specified and hence they are not returned in the report. Please find the sample report query below:

__rdquery: SELECT FeedId, FeedItemId, TargetingAdGroupId, TargetingCampaignId, KeywordTargetingId, GeoTargetingCriterionId FROM AD_CUSTOMIZERS_FEED_ITEM_REPORT WHERE FeedId = "100441801"

Let me know if you have any questions.

Regards,

Bharani, Google Ads API Team

ref:_00D1U1174p._5001UBnv3q:ref

[Jorge Lopez Marcos]

Hello Bharani,

I believe that we are puzzling ourselves here.

What I'm exactly looking forward to get is at which level is declared the ad extension, in other words, if a ad extension belongs to a campaign or an account or an ad group.

I believe that this figure can be obtained using TargetingAdGroupId and TargetingCampaignId, but I'm not sure at all. I have tried with those variables and as it happened to you and me , They are returned always as a 0. Maybe it could be obtained using other variable...

I don't know how the location id could have any effect. Indeed the account number I shared privately with you contained ad extensions declared at the three main levels ( account , campaign and adgroup).

Do you understand what I'm trying to extract ??

Thank you very much for your help.

[Google Ads API Forum Advisor Prod]

Hello Jorge, 

Thank you for sharing the detailed explanation. From what I understand, you are looking to pull the targeting details available in the Business data for the specific feeds. These only contain details of the specific FeedItems that are targeted only to specific campaigns, ad groups, or criteria. In this scenario, the feeds available in the UI are not having any restrictive targeting (TargetingAdGroupId and TargetingCampaignId) and hence you are seeing these to be zeroes. You can check this by navigating to the Business Data Feed > Data Feeds > Locations.

Please note that if you are targeting the feeds to specific campaigns, which are not restrictive targeting, you will need to explicitly specify the AdGroupId and Campaign Id fields as below:
__rdquery: SELECT  AdId, GeoTargetingRestriction, TargetingAdGroupId, TargetingCampaignId, FeedId, FeedItemId, AdId , AdGroupId, CampaignId FROM PLACEHOLDER_FEED_ITEM_REPORT

Hope this will helps. Let me know if you have any questions. 

Thanks,