Unique , Index, or Primary Key.

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. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/

Re: Unique , Index, or Primary Key.

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? On Thursday, July 7, 2022 at 1:14:55 PM UTC-4 adsapi wrote: > Hi Ahmad, > > Thank you for your question. > > If you are using the

Re: Unique , Index, or Primary Key.

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

Re: Unique , Index, or Primary Key.

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. On Thursday, July 7, 2022 at 9:57:28 PM UTC-4 adsapi wrote: > Hi Ahmad, > > > Thank you for getting back to us. I work

Re: Unique , Index, or Primary Key.

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 -- -- =~=~=~=~=~=~=~

Re: Unique , Index, or Primary Key.

Thank you, for the useful link. I can use this info in my background job to fetch data through API. On Friday, July 8, 2022 at 12:14:03 PM UTC-4 adsapi wrote: > Hi Ahmad, > > Product support's About data freshness > shows that > met