Discrepancy between UI and API in Products

[Iván López]

Hello,

I am seeing a discrepancy between the data I can see in the Google Ads UI and the data I am receiving from the API. I know that it is not advisable to write confidential info here but I need it to explain the Problem.

In Google Ads I can see examples from Products page, where products have Product Type (1st Level), Product Type (2nd Level), Product Type (3rd Level) and Product Type (4th Level). I have and screenshot from the UI (Account ID: 1584899019, Campaign ID: 13472442855, Ad group ID: 123872851096)

But, when I ask for the same info through the API, some products have the Product Type (4th Level) empty, but it is not empty in the UI. In the past it has been empty but more than 15 hours have passed since the change it's beeing showed in the UI.

I make the following query:

SELECT
                      campaign.id,
                      campaign.status,
                      ad_group.status,
                      ad_group.id,
                      campaign.name,
                      ad_group.name,
                      metrics.clicks,
                      metrics.conversions,
                      metrics.cost_micros,
                      segments.product_type_l1, segments.product_type_l2, segments.product_type_l3, segments.product_type_l4, segments.product_item_id
                    FROM
                      shopping_performance_view
                    WHERE ad_group.id = 123872851096
                    AND metrics.cost_micros > 10000000
                    AND metrics.conversions < 1
                    AND campaign.status = 'ENABLED'
                    AND ad_group.status = 'ENABLED'
                    AND segments.date BETWEEN 20220710 AND 20221009

And a part of the response:
results {
  campaign {
    resource_name: "customers/1584899019/campaigns/13472442855"
    status: ENABLED
    name: "GG - DE - SC - W - GEN"
    id: 13472442855
  }
  ad_group {
    resource_name: "customers/1584899019/adGroups/123872851096"
    status: ENABLED
    id: 123872851096
    name: "Vestidos"
  }
  metrics {
    clicks: 36
    conversions: 0.0
    cost_micros: 12550000
  }
  segments {
    product_item_id: "0090469460005"
    product_type_l1: "mujer"
    product_type_l2: "vestidos"
    product_type_l3: "other"
  }
  shopping_performance_view {
    resource_name: "customers/1584899019/shoppingPerformanceView"
  }
}

As you can see in the screenshot, the Product with Item ID "0090469460005" have "other" in the Product Type (4th level). But in the response is empty. Why is this happening? How much time takes the API to update this info?

Thank you,

Ivan

[Google Ads API Forum Advisor]

Hi Ivan,

Thank you for raising this concern to the Google Ads API Forum.

Upon checking the provided query and checking your Google Ads accounts, I was able to get the same result. With this, allow me to raise this to the rest of our team and we will provide updates as soon as possible.

Best regards,

Jinky Google Ads API Team

ref:_00D1U1174p._5004Q2f4t9t:ref