AdWordsApp.ProductGroup when otherCase is true (ie catch all) how to identify itemIds?

[Brandon B]

Hi,

I am trying to identify the itemIds from catch-all (identified by productGroup.isOtherCase()==1) product groups that have converted within x period of time. I have no problems identifying these catch-all product groups, but how can I access the information about what itemIds are within them? They have no children. After converting them to AdWordsApp.ProductItemIds they still don't have children.

Once I can identify the itemIds with conversions I intend to move them out of catch-all product groups into their own product group by using the productGroupBuilder.

Sincerely,
Brandon B

[Tyler Sidell (AdWords Scripts Team)]

Hi Brandon,

You could grab the item ids of the 'everything else' product group through a Product Partition Report. The "ProductGroup CONTAINS ' *'" filter will fetch all product groups that contain an "everything else" node in their path.

Example:

function main() {
  var url = 'SPREADSHEET URL';
  var sheet = SpreadsheetApp.openByUrl(url).getActiveSheet();
  var query = AdWordsApp.report("SELECT Id, ProductGroup FROM PRODUCT_PARTITION_REPORT WHERE ProductGroup CONTAINS ' *' DURING 20130101, 20161203");
  query.exportToSheet(sheet);
}

Thanks,

Tyler Sidell

AdWords Scripts Team

[Brandon B]

Hi Tyler,

Thanks for pointing me to this report, it includes the information I was looking for with regard to item id. For my purposes, however, item id is not enough. I also must find something to cross reference against while I iterate through the product group tree. Since I can't access information about item id for items within catch-all product groups by doing this, I need something else to match.

The ProductGroup field includes the full path to the product such as:

* / category = "Arts & Entertainment" / category = "Hobbies & Creative Arts" / category = "Arts & Crafts" / category = * / brand = * / item id = "wd7584" id: 149296836975"

Perhaps "id: 149296836975" is something I can match against while I iterate through product groups but I'm not sure what it represents. I have made several guesses but I haven't found any matches while checking against product groups.

Can you think of a way for me to reconcile product groups against the Product Partition Report?

Sincerely,
Brandon

[Tyler Sidell (AdWords Scripts Team)]

Hi Brandon,

Perhaps you can cross reference against fields from the Shopping Performance Report.  These are all of the fields that are available through reports.  These may be helpful for you to cross reference. 

Thanks,

Tyler Sidell

AdWords Scripts Team

[Brandon B]

Hi Tyler,

I took another look at the Product Partition Report and found that the rows I am interested in, such as:

ProductGroup: * / category = "Arts & Entertainment" / category = "Hobbies & Creative Arts" / category = "Arts & Crafts" / category = * / brand = * / item id = * id: 134139959295 ParentCriterionId: undefined

These rows still do not have item id defined. If the conversion happens for an itemId within one of the catch-all product groups, the conversion apparently gets allocated to item id = *.

I need to find a way to identify the particular item id (offerId) that the conversion should be allocated to.

Sincerely,
Brandon

[Tyler Sidell (AdWords Scripts Team)]

Hi Brandon,

Have you tried to cross reference against the Shopping Performance Report as OfferId is an available field?

Thanks,

Tyler Sidell
AdWords Scripts Team

[Brandon B]

Hi Tyler,

Yes, I looked at the documentation for that report:

https://developers.google.com/adwords/api/docs/appendix/reports/shopping-performance-report

Although the shopping performance report does have offerId, it doesn't have productGroupId which I need to be able to cross-reference against. With the process of elimination I could potentially identify what productGroups don't have matching offerIds and then I would know what offerIds have conversions and must be part of catch-all productGroups. However, I need to know what specific catch-all productGroup contains the conversion that happened for each and every converting offerId that doesn't already have its own productGroup. Otherwise, I won't know where in the tree to create a new productGroup for that converting offerId.

Sincerely,
Brandon B

[Tyler Sidell (AdWords Scripts Team)]

Hi Brandon,

Apologies for the delay but from AdWords Scripts and reporting, you would not be able to cross reference the specific catch-all productGroup that contains the conversion. You could look into cross referencing the information against your Merchant Center account specifically within the Shopping Content API but that would be out of my realm of expertise.

Thanks,
Tyler Sidell

AdWords Scripts Team