Reporting data on campaign-level vs item-level cost matching

[Vipul]

Hello, on Google Ads reports

When I build a report with columns "campaign," "campaign type," and "cost" the total cost displayed is matched with the cost displayed on the dashboard UI.
but when I add the item id column (i.e. segments.product_item_id) in the report, the cost reduces and doesn't match !

So there is definitely some ad cost that is not applied to any items.

on Google Ads api,

SELECT
    customer.id,
    campaign.id,
    campaign.name,
    campaign.advertising_channel_type,
    segments.product_item_id,
    metrics.cost_micros,
    segments.date
FROM shopping_performance_view

I am using the above query to fetch item-wise cost, but I am not able to get the cost that is missing on the item level.
So is there any way I can get campaign-wise missing cost that was not applied to any items ?

[Google Ads API Forum Advisor]

Hi,

Thank you for raising this concern to the Google Ads API Forum. We hope that today is going well for you!

To take a closer look at this issue and to answer your questions, could you please share your complete request and response logs, and request-id that generated on your end? Also, the whole screenshot of the Google Ads UI without the crop portion where we can see the discrepancies is helpful in our investigations. If you haven't yet, logging can be enabled by navigating to the Client libraries > Your client library (ex. Java) > Logging documentation, and by using the DEBUG log level.

You can provide it via Reply privately to the author option. If this option is not available, then send it instead on this email address googleadsa...@google.com.

Best regards,

Google Ads API Team

ref:_00D1U1174p._5004Q2kDn0B:ref