get ExtensionFeedItems of type AFFILIATE_LOCATION

[Seungha Kim]

I am trying to get ExtensionFeedItems(type=AFFILIATE_LOCATION)data, using CustomerExtensionSetting

but, the following query does not return resourceNames.

SELECT customer_extension_setting.extension_type, customer_extension_setting.extension_feed_items

FROM customer_extension_setting

result : 

customer_extension_setting.extension_type : AFFILIATE_LOCATION

customer_extension_setting.extension_feed_items : []

There is no result only when executing a query with AFFILIATE_LOCATION type.

I don't know why.

Thanks, :)

[Google Ads API Forum Advisor Prod]

Hi Seungha,

Thank you for reaching out. What is your client customer ID? Also, what level is the affiliate location set at?

Regards,
Mitchell
Google Ads API Team

ref:_00D1U1174p._5001UXUlhr:ref

[Seungha Kim]

I wrote the clientid with a private reply. Please check.

Thanks, :)

2020년 3월 12일 목요일 오전 3시 2분 34초 UTC+9, adsapiforumadvisor 님의 말:

[Seungha Kim]

Thanks for the reply. Please check again.

2020년 3월 12일 목요일 오전 3시 2분 34초 UTC+9, adsapiforumadvisor 님의 말:

Hi Seungha,

[Google Ads API Forum Advisor Prod]

Hi Seungha,

Looking at your account, I noticed that that sitelink extension is set at the ad group level. Can you confirm that it only shows up when using the ad_group_extension_settings report?

[Seungha Kim]

HI,

When all three resources are queried with aa type, the items value continues to be empty.

1. 

SELECT customer_extension_setting.extension_type, customer_extension_setting.extension_feed_items 

FROM customer_extension_setting 

WHERE customer_extension_setting.extension_type = 'AFFILIATE_LOCATION'

result :

googleAdsRow.getCustomerExtensionSetting().getExtensionType().getValueDescriptor().getName() =>

googleAdsRow.getCustomerExtensionSetting().getExtensionFeedItemsList() => [] (=size 0)

2.

SELECT campaign.id, campaign.name, campaign_extension_setting.extension_type, campaign_extension_setting.extension_feed_items 

FROM campaign_extension_setting 

WHERE campaign_extension_setting.extension_type = 'AFFILIATE_LOCATION'

result :

googleAdsRow.getCampaign().getId().getValue() => 8963******

googleAdsRow.getCampaign().getName().getValue() => 검색_T_01

googleAdsRow.getCampaignExtensionSetting().getExtensionType().getValueDescriptor().getName() => AFFILIATE_LOCATION

googleAdsRow.getCampaignExtensionSetting().getExtensionFeedItemsList() => [] (=size 0)

3.

SELECT ad_group.id, ad_group.name, ad_group_extension_setting.extension_type, ad_group_extension_setting.extension_feed_items  

FROM ad_group_extension_setting 

WHERE ad_group_extension_setting.extension_type = 'AFFILIATE_LOCATION'

result :

googleAdsRow.getAdGroup().getId().getValue() => 8583*******

googleAdsRow.getAdGroup().getName().getValue() => 광고그룹 2

googleAdsRow.getAdGroupExtensionSetting().getExtensionType().getValueDescriptor().getName() => AFFILIATE_LOCATION

googleAdsRow.getAdGroupExtensionSetting().getExtensionFeedItemsList() => [] (=size 0)

only 'AFFILIATE_LOCATION' type!!

Thanks, :)

2020년 3월 14일 토요일 오전 4시 2분 16초 UTC+9, adsapiforumadvisor 님의 말:

[Google Ads API Forum Advisor Prod]

Hi Seungha,

The reason there is no response is because there are no feed items associated with the Affiliate Location extension you created at the account/campaign/ad group levels. If you go to the UI and add the column "Item ID" to the Extensions tab, you will see that it is 0 for the Affiliate Location extensions so this is the expected API response.

The data feed you set up does have an item ID which is why it shows up in the extension_feed_item report but it is not associated with any specific level.

[Seungha Kim]

Thank you for answer.

However, there are some parts I don't understand.

If so, I think there should be no data from customer_extension_setting.

When I run the query below, 

The result of customer_extension_setting exists. 

But extension_feed_items column only empty.

SearchGoogleAdsRequest request = SearchGoogleAdsRequest.newBuilder()

.setCustomerId(***********)

.setPageSize(PAGE_SIZE)

.setQuery("SELECT customer_extension_setting.extension_type, customer_extension_setting.extension_feed_items FROM customer_extension_setting WHERE customer_extension_setting.extension_type = 'AFFILIATE_LOCATION'")

.build();

searchPagedResponse searchPagedResponse = googleAdsServiceClient.search(request);

for (GoogleAdsRow googleAdsRow : searchPagedResponse.iterateAll()) {

System.out.println(googleAdsRow.getCustomerExtensionSetting().getExtensionType().getValueDescriptor().getName());

System.out.println(googleAdsRow.getCampaignExtensionSetting().getExtensionFeedItemsList().toString());

}

result :

AFFILIATE_LOCATION

[]

Shouldn't 'searchPagedResponse' be null?

2020년 3월 17일 화요일 오전 2시 50분 58초 UTC+9, adsapiforumadvisor 님의 말:

[Google Ads API Forum Advisor Prod]

Hi Seungha,

The Extension Setting exists but it is not populated by any items which is why the items array is empty but you see a return value.