RE: duplicate rows from google campaign_criterion report

['Google Ads API Forum Advisor' via Google Ads API and AdWords API Forum]

Hi Shreya,

Thank you for reaching out to Google Ads API Forum.

I understand that you are getting a lot of duplicate rows for getting the 
mentioned columns using campaign_criterion report. With this, could you provide 
us with the complete API logs (request and response with request-id and request 
header) generated on your end along with the un-cropped UI screenshot showing 
the data that you want to retrieve via API? I am asking this so we could 
further check and provide more appropriate guidance.

If you haven't enabled the logging yet, logging can be enabled by navigating to 
the Client libraries > Your client library (ex. Java) > Logging documentation, 
which you can access from this link 
(https://developers.google.com/google-ads/api/docs/client-libs?hl=en). For REST 
interface requests, you can enable logging via the curl command by using the -i 
flag.

You may then send the requested information privately via the Reply to author 
option. If this option is not available, you may send the details directly to 
our googleadsapi-supp...@google.com alias instead.

Reference Links:

request - 
https://developers.google.com/google-ads/api/docs/concepts/field-service#request
response - 
https://developers.google.com/google-ads/api/docs/concepts/field-service#response
request ID - 
https://developers.google.com/google-ads/api/docs/concepts/call-structure#request-id
request header - 
https://developers.google.com/google-ads/api/docs/concepts/call-structure#request_headers

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

Thanks,

Google Ads API Team

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/I3AAe0RZWCRF00hNTshkM9Tm-xrFHRF0iRAw%40sfdc.net.

Duplicate rows from google campaign_criterion report

[Shreya Arora]

Hello team,

I am currently using campaign_criterion reports from google ads api to 
retrieve following columns: 
1. campaign.id
2. campaign.name
3. campaign.status
4. campaign.advertising_channel_type
5. campaign.bidding_strategy_type
6. campaign_criterion.location.geo_target_constant

I am combining these columns with the following columns from 
customer_client report
1. customer_client.id
2. customer_client.descriptive_name

But I am getting a lot of duplicate rows in the dataset. Can you please 
help me with this. Is there any primary key from campaign_criterion which I 
can use to avoid duplicate rows ?
Thank you in advance.

Regards
Shreya Arora

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/d3e94b1d-a328-433a-b348-413dbc56ced5n%40googlegroups.com.