Can we use Summary Row setting with segment.date?

[クィグェン]

Hello 

I want to get data summary of metric by each of date. how can we do it?

body: {

query: "SELECT metrics.clicks FROM campaign 

WHERE campaign  IN ('111111111', '22222222') AND 

segments.date > '2020-01-01' AND segments.date < '2020-02-01'"

summary_row_setting: 'SUMMARY_ROW_ONLY'

  },

It returns only one of row summary for all date and all campaign

But I want to get summary clicks of campaign 1111111 and campaign 222222 by each date. 

How can I do it?

Thank you very much!

[クィグェン]

Hello support teams,

Can you help me?

Actually, we want to call API to get all data of metric by segment.date in serveral years and save it to my web system. 

How can I do it?

For example, we want to get Daily conversion rate from 2020/01/01 ~ until now of both of campaign 1 and campaign 2 

Thank you so much if we can hear from you.

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API support team.

After reviewing your concern, I understand that you want to call the API to get all data of metric by segment.date in several years and save it to your web system. Could you please provide us with the uncropped UI screenshot for the scenario for which you need assistance from our team.

You can refer to this link, which is regarding the campaign from where you can get the resources with metrics.

You can send the details via Reply privately to the author option, or direct private reply to this email.
 

This message is in relation to case "ref:_00D1U1174p._5004Q2olicw:ref"

Thanks,

Google Ads API Team

[クィグェン]

Hi, Thank you for your response.

I sent private reply to author.

Please help me to check it.

Thank you very much!

[クィグェン]

Hello 

I sent UI screenshot but still havent any response from support team.

Anyone can help me, please?

Thank you!

[Google Ads API Forum Advisor]

Hi,

Thank you for getting back to us.

Upon checking further, you need to create a separate report for each campaign. You can use the below query example to get the campaign and segment by date for many years.

"SELECT campaign.id, segments.date, metrics.clicks, metrics.impressions FROM campaign WHERE segments.year BETWEEN 2012 AND 2022"

Hope this helps. If you have any further queries, you can get back to us.