asset metrics Report

[梁生]

hello,

   how can i can get asset level metrics.cost_micros?

thank you

[Google Ads API Forum Advisor]

Hello,

Michael here from Google Ads API Support team. Thank you for reaching out to us.

With regards to your concern, if you are referring to getting the metrics at campaign asset level, you may try the below query:
SELECT metrics.cost_micros FROM campaign_asset

On the other hand, if this is for Ad group asset, then the one should work for you:
SELECT metrics.cost_micros FROM ad_group_asset

Nonetheless, you may also check our Query Builder and it should help you in building your desired Ads API queries.

Note that Google Ads API mirrors Google Ads UI. Meaning, the data that can be seen in the Google Ads UI can be retrieved or managed using the Google Ads API. If you have specific data that you want to retrieve, then you may send us the uncropped UI screenshot so we can provide the accurate report and fields that you need to use.

Regards,

Michael Angelo Google Ads API Team

ref:_00D1U1174p._5004Q2jEyoO:ref

[梁生]

Hello, 

        "SELECT metrics.cost_micros FROM campaign WHERE segments.date = 2023-02-10 "    What kinds of asset are included in this  cost_micros  of  a campaign?

         By calculating the  cost_micros   of all the  asset  in a campaign，I found these two kinds of  cost_micros  is not equal：

         "SELECT metrics.cost_micros FROM campaign WHERE segments.date = 2023-02-10 " 

          "SELECT campaign.id, asset.id, metrics.cost_micros FROM ad_group_ad_asset_view  where ad_group_ad_asset_view.field_type IN ('AD_IMAGE', 'MARKETING_IMAGE', 'PORTRAIT_MARKETING_IMAGE', 'SQUARE_MARKETING_IMAGE', 'VIDEO', 'YOUTUBE_VIDEO') AND segments.date = 2023-02-10 "    

thank you

[Google Ads API Forum Advisor]

Hi,
 

Thank you for getting back to us. I work with Michael, so allow me to assist you here. I hope you are doing well today.
 

Moving forward to your concern about this, "What kinds of assets are included in this cost_micros of a campaign?" Could you please elaborate more on what you mean by this?

Additionally, the metrics cost_micros is the sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period. Also, the campaign and ad_group_ad_asset_view are different reports.

ad_group_ad_asset_view is a link between an AdGroupAd and an Asset. Currently, we only support AdGroupAdAssetView for app ads and responsive search ads.

Regards,

Darwin Google Ads API Team

ref:_00D1U1174p._5004Q2jEyoO:ref