Unique , Index, or Primary Key.

[Ahmad Jafari]

Hi,
I get campaign performance based on segment Date and store it on DB, I want to know, is there any parameter as unique to avoid inserting duplicate records?

Thank you. 

[Google Ads API Forum Advisor]

Hi Ahmad,

Thank you for your question.

If you are using the campaign view, then, a single campaign.resource_name can have multiple rows depending on the date returned by the segments.date field, and also other rows if any of the other campaign report's segments fields were used.

Best regards,

Peter Laurence Google Ads API Team

ref:_00D1U1174p._5004Q2cTaj5:ref

[Ahmad Jafari]

Thanks for your response.

Yes, I use campaign view.

 I think you mean I should generate an index key manually by combining the metric and resource_name. that is true?

[Google Ads API Forum Advisor]

Hi Ahmad,
 

Thank you for getting back to us. I work with Peter and allow me to assist you here.

Regarding your question "I think you mean I should generate an index key manually by combining the metric and resource_name. that is true?", my colleague meant that reports would generate a new row for every unique combination of campaign.resource_name with other segment fields (for example, segments.date). You may refer to our documentation on segmentation for more information.

Let us know if you have further question.
 

Regards,

Darwin Google Ads API Team

ref:_00D1U1174p._5004Q2cTaj5:ref

[Ahmad Jafari]

Thanks for the clarification, currently there is no problem in getting the data. With this method, I can check the data entered in the local database, at the campaign level.

[Google Ads API Forum Advisor]

Hi Ahmad,

Product support's  About data freshness shows that metrics can change over time, so it's not advisable then to use a metric field in a key. All segmenting fields will need to be in the key too.

Regards,

Aryeh Google Ads API Team

ref:_00D1U1174p._5004Q2cTaj5:ref

[Ahmad Jafari]

Thank you, for the useful link. I can use this info in my background job to fetch data through API.