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

[Google Ads API Forum Advisor]

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 googleadsa...@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