A Report to download all Placeholders: sitelink (including zero-impressions)

[Denys Kovalenko]

Hi,

I'm looking for a way to download all the sitelinks on account (per ad group level) - looks like all the reports available, do not offer sitelinks without impressions.

The reason for this report, to determine which AdGroups already have sitelinks to upload new sitelinks to ONLY groups which don't, perhaps there is another way?

Thanks.

[Shwetha Vastrad (AdWords API Team)]

Hi Denys,

You can use Placeholder Feed Item Report to get sitelink extensions in your account. You should use TargetingAdGroupId and TargetingCampaignId fields instead of CampaignId and AdGroupId fields as these support zero impressions.You need to use the PlaceholderType value to distinguish between different types of extensions in this report. A list of all the placeholder types and fields is available in the Placeholder reference page.

Regards,

Shwetha, AdWords API Team.

[Denys Kovalenko]

Thanks Shwetha,

I used those two, but they returned with "0" value: targetCampaignID='0' targetAdGroupID='0'

My goal is to find all adGroups without sitelinks, how can I achieve this, if I don't have adGroupId?

Thanks.

[Shwetha Vastrad (AdWords API Team)]

Hi Denys,

Upon further investigation, I found that the TargetingCampaignId and TargetingAdGroupId are pulled from the feed data rather than the extension setting data. To get a list of AdGroups which don't have any sitelink extensions, do the following:

1. Use AdGroupService or AdGroup Performance Report to get a list of all the AdGroups in your account.
2. Use AdGroupExtensionSettingService to get a list of all adgroup-level sitelink extensions (make sure to add a predicate to filter only sitelinks).
3. Remove AdGroups from step 2 from the list obtained in step 1 to get all the AdGroups without sitelink extensions.

Let me know if this works.

Thanks,

Shwetha, AdWords API Team.

[Denys Kovalenko]

Hi,

Thanks for your advice, but AdGroupExtensionSettingService is not a report, which means a huge overhead on API (unless I can do bulk operations?), we are talking about of thousands of groups. If think I'd rather make an internal site-link accounting system if there is no report to show AdGroups with Sitelink Extensions.

Thanks for looking anyway.

Regards, Denys.