Hi Mark,
Thank you for posting your concern.
You are correct that you can use the
PLACEHOLDER_FEED_ITEM_REPORT to get the data and statistics of your sitelinks. However, the Final URL field is not supported in this report type.
As a workaround, you may try to follow the instruction below on how to get all the sitelinks Final URLs in your account.
1. Use the
Final Url Report and include the
ClickType field in the report.
2. Filter the
ClickType field with
SITELINKS so that it will only return placeholder which type is sitelink.
3. Then, use the
EffectiveFinalUrl field of this report type to pull all sitelink Final URLs from your account.
4. Lastly, since you want to download the sitelink Final URLs from multiple account, you can use this
sample code for Java (which also have equivalent to other
client libraries) as it will process all the client accounts that belongs to manager account you specified in the request header.
Please let me know if you have further questions.
Regards,
Ejay
Google Ads API Team

ref:_00D1U1174p._5001UBnYA9:ref