How to Get Search Top IS and Search Abs Top IS with start & end date

[Khoa Nguyen]

I want to get Search Top IS and Search Abs Top IS showing on Google BM from API with start & end date. Currently API only return metric data for daily. I want to get it same on Google BM

[Google Ads API Forum Advisor]

Hello,

Thank you for reaching out to Google Ads API Support.

Can you please provide us with with more details on what you mean by “get Search Top IS and Search Abs Top IS showing on Google BM from API”?

As for obtaining the start/end date field, Please try using the sample query below to see if you will get your expected data, This query has campaign.start_date and campaign.end_date added to the query in your screenshot.

SELECT 
  customer.id, 
  customer.resource_name,   
  campaign.start_date, 
  campaign.end_date,
  campaign.advertising_channel_type, 
  campaign.resource_name, 
  campaign.id, 
  segments.date, 
  segments.month, 
  metrics.search_absolute_top_impression_share, 
  metrics.search_top_impression_share, 
  metrics.clicks, 
  metrics.conversions, 
  metrics.all_conversions, 
  metrics.conversions_value, 
  metrics.impressions, 
  metrics.cost_micros 
FROM campaign 
WHERE 
  segments.date >= '20230404' 
  AND segments.date <= '20230405' 
  AND campaign.id = XXXXXXXXXX

Let me know if you have any questions.

Regards,

Google Ads API Team

ref:_00D1U1174p._5004Q2kTZn8:ref