Shopping campaign - contents of "Everything else in 'All products'"?

[david]

Hi,

We have a shopping campaign with around 12,000 product partitions segmented on ProductOfferId all in a single ad group.

Every product we have SHOULD have it's own product partition leaving the "Everything Else" product group empty, but we appear to be getting impressions and clicks against "Everything Else" so it seems like this isn't the case.

So obviously we'd like to find out what is in the product group, but the GUI is giving us a generic "There was an error with your operation." error when we click on the View Products icon.

Can anyone suggest a way to get the contents programmatically?

If we do a GET request to the AdGroupCriterionService the "Other" group is distinguished solely by not having a OfferId at all, where-as populated partitions obviously list the OfferId of the product in question.

[Josh Radcliff (AdWords API Team)]

Hi,

We're aware that it would be very helpful if the Shopping Performance Report included the product partition ID, but that functionality is not available at this time.

However, you could use a combination of the Shopping Performance Report and the AdGroupCriterionService to find the offer IDs of the products that aren't explicitly covered by a product partition.

1. Run a Shopping Performance Report and include the OfferId field. This will give you the offer ID of every product that had an impression for the report's date range.

2. Use the AdGroupCriterionService to get all of your product partitions where the ProductPartition.caseValue is a ProductOfferId product dimension.

Look for OfferIds from step 1 that do not appear as the ProductOfferId.value on any of the product partitions from step 2 -- those are the offer IDs that are falling into the "Everything else" category.

Cheers,

Josh, AdWords API Team

[david]

Thanks Josh.. that worked a treat and allowed us to spot an error in our logic for creating product partitions.

Cheers for the help.