Cannot get page feed from PLACEHOLDER_FEED_ITEM_REPORT?

[at]

Hi,

I have created some page feeds using the template file and I want to get them from PLACEHOLDER_FEED_ITEM_REPORT, but seems this report doesn't support page feed?

The response is other placeholder types' items.

/bigstore/aw3-webapi-report-download/259578638be726450-3c0c-42ac-9a21-f1fd4a06e45a/fileId-null-uuid-be726450-3c0c-42ac-9a21-f1fd4a06e45a-cid-259578638.tmp.csv.gz

Thanks!

[Dhanya Sundararaju (AdWords API Team)]

Hi,

The Placeholder Report which provides statistics for feed-based ad extensions, one row per placeholder type maybe what you are looking for. But in order to confirm, could you please reply back with your client customer id and the report definition? Also, I am unable to access the csv.gz file that you have shared. You may opt to reply privately to author.

Regards,
Dhanya, AdWords API Team

[Sreelakshmi Sasidharan (AdWords API Team)]

Hi,

I am Dhanya's colleague and following up on this thread as she is OOO today. It is not possible to get the details of the Page feed using the Placeholder Feed Item Report. To get the stats of the DSA campaign and related entities, you could consider using any of the reports listed here. You will be able to get the stats related to the specific URL using the Keywordless Query report. If you are trying to get the details of the page feed and feed items, you could use the FeedService and FeedItemService to filter the specific feed and feed items. Please check the feed services guide for more details and code samples. Please note that the DSA page feeds will have the criterionType = 61 instead of a placeholder type. Let me know if you have any additional questions. 

Thanks,
Sreelakshmi, AdWords API Team

[at]

Thanks Sreelakshmi!

So there is no ways to get page feed's feed item ids via report service?

Looks like we can only get at most 100,000(Start index of request) + 10,000(Results per page) entities using Adwords API, and the limit doc suggests to use AdHoc reporting for large result set.

As we cannot get page feed item's structure data from report service, is there any other workarounds to get them if there are far more than 100,000 + 10,000 page feed items?

Thanks

[Sreelakshmi Sasidharan (AdWords API Team)]

Hello, 

You are right, using a start index greater than 100,000 will result in an error. You could follow the steps listed below to use FeedItemService to get all the FeedItems.

1. Set a variable maxFeedItemId = -1
2. Issue a get request with 'WHERE FeedItemId > maxFeedItemId ORDER BY FeedItemId LIMIT 0,10000'
3. Collect feedItemIds from the response from step #2.
4. Set maxFeedItemId = the last (largest) feedItemId in the response from step #2.
5. If the response from step #2 contained 10,000 items, repeat from step 2.

Since the result is ordered by the feedItemId, this will allow you to get all the FeedItems without encountering the START_INDEX_IS_TOO_HIGH error. Please give this a try and let me know if you face any issues. 

[at]

Thanks Sreelakshmi!