The data between the two tables of google ads is inconsistent

[William Zhou]

When I calculate the cost through the campaign table and the ad_group_ad_asset_view table, the data is inconsistent

    SELECT
             sum(metrics.cost_micros)
    FROM
            {table}
    WHERE
            segments.date >= '{start_date}'
            and segments.date <= '{end_date}'

The customer_id is 4362002335, the date is 20221104.

One result is 25923 the other is 23096

[Google Ads API Forum Advisor]

Hi William,

Thanks for reaching out to the Google Ads API Forum. 

Kindly note that Google Ads API retrieves data that you can see in the Google Ads UI. You mentioned that you are comparing the cost for the campaign and the ad_group_ad_asset_view. Having said that, please note that it is not recommended to compare the cost of these 2 as they are at different levels. The campaign report is for the campaign level and the ad_group_ad_asset_view is for the ad level. So it is expected that the cost pulled from these 2 reports are not equal.

Please see reference below:

 

For ad_group_ad_asset_view:

 

SELECT metrics.cost_micros FROM ad_group_ad_asset_view WHERE segments.date = '20221104'

 

"summaryRow": {

      "metrics": {

        "costMicros": "23061269818"

      }

    }

 

For campaign:

 

SELECT metrics.cost_micros FROM campaign WHERE segments.date = '20221104’

 

"summaryRow": {

      "metrics": {

        "costMicros": "25890341030"

      }

    }

Let me know if you have further questions.

Regards,

Marjorie Google Ads API Team

ref:_00D1U1174p._5004Q2h2KRf:ref