GAQL Group By Date

[Shannon]

We are running a placements report using: 

======QUERY======

  SELECT

  campaign.id, campaign.name, 

  detail_placement_view.group_placement_target_url,               

  metrics.impressions,

  metrics.ctr,

  metrics.clicks

  FROM detail_placement_view

  WHERE  segments.date DURING LAST_30_DAYS

The issue is that each placement has multiple entries in the returned recordset: 

campaign.name
detail_placement_view.group_placement_target_url
metrics.impressions
metrics.ctr
metrics.clicks


Faqtive | Display
alon.hu
5
0
0
Faqtive | Display
alon.hu
17
0
0
Faqtive | Display
alon.hu
5
0
0
Faqtive | Display
alon.hu
6
0
0

Is there a way to GROUP BY or some other way to have them combined into a single row line item? If not, we will have to aggregate them on our end. I am just trying to confirm. 

[Google Ads API Forum Advisor]

Hi,

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

Could you please provide us with the complete API logs (request and response logs with request-id and request header) generated at your end. This would help us understand the issue and assist you accordingly.

If you are using a client library and haven't enabled logging yet, I would request that you enable logging for the specific client library that you are using. You can refer to the guides Java, .Net, PHP, Python, Ruby or Perl to enable logging at your end. For REST interface requests, you can enable logging via the curl command by using the -i flag.

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:!00D1U01174p.!5004Q02vE622:ref" (ADR-00259402)

Thanks,
 

Google Ads API Team

Register for the upcoming workshop: Performance Max and the Google Ads API!
 

[Dmytro Tonkikh]

If you'd like to get unsegmented data - don't use  campaign.id, campaign.name in your query.