Re: Using reports to sync account structure

Hi Brad, You may see adjustments coming in after 5 days, although that should be somewhat rare. One approach some users have used is: *Daily* - Run report for the last 7 days and completely replace any previous reporting data in your DB with this information. *Monthly* Using

Re: Using reports to sync account structure

Hello, You could use the AdGroupChangeData.changedCriteria , AdGroupChangeData,removedCriteria

Re: Using reports to sync account structure

I am still unclear how to determine which days have changed. I understand the "CustomerSyncService" returns back different levels that have changed, however I need to know the DAYS which data has changed for. If I pass in a min/max of last sync time, where do I then get the days that need to be

Re: Using reports to sync account structure

Hi Brad, I don't think that *CustomerSyncService* is going to provide the information you want for your use case. That service returns IDs of objects that were added or removed, or whose *attributes* have changed during the date range specified. However, it sounds like you are looking for the

Re: Using reports to sync account structure

Josh, That is correct. I was doing the last 5 days of sync. I still was able to find discrepancies, looking historically from last month. I actually know exactly which record had discrepancies and when I polled that data if that helps. Thanks, Brad On Wednesday, November 18, 2015 at 1:36:41

Re: Using reports to sync account structure

Do you have any recommendations about how to properly sync beyond the 5 days to ensure the data is accurate and valid. Thanks, Brad On Wednesday, November 18, 2015 at 2:27:52 PM UTC-8, Brad Ruderman wrote: > > Josh, > That is correct. I was doing the last 5 days of sync. I still was able to >

Re: Using reports to sync account structure

I would like to revisit this topic. I am currently trying to sync the KEYWORD_PERFORMANCE_REPORT, so everyday after the "data freshness time" (https://support.google.com/adwords/answer/2544985), I was running a query for the past 5 days and replacing the data. However I noticed that as of

Re: Using reports to sync account structure

Hi Oliver, If you include a field such as Impressions, while still making sure none of the other fields prevent zero impression rows from returning, you'll get back your structural data with an impression of 0 (for those with no impressions). I.E. including the Impressions field should not

Re: Using reports to sync account structure

I ran reports specifying only the attribute type of fields (as discussed in this thread) but they all come back blank. No structural data seem to be included in the reports unless I specify metric or segment fields as well. David, this seems to not be consistent with the recommendation you

Re: Using reports to sync account structure

Thanks David. How else would you recommend one gets only the account structure in a way that remains consistent? Is there any other way an account structure can be fetched without using the method I described? Oliver On Tuesday, June 19, 2012 1:31:39 AM UTC+1, David Torres wrote: Hi Oliver,

Re: Using reports to sync account structure

Hi Oliver, Your assumptions are correct at the moment, so you can use attribute type of fields to obtain all structural data including zero impressions. But there is no guarantee that we won't introduce attribute fields that will prevent zero impressions in the future. Best, -David Torres -

Re: Using reports to sync account structure

mm, thanks for your help. Anash, I went through all the reports types looking for the 'prevents zero impressions' note. Here is my conclusion: - The account structure is defined by fields that have Behavior=Attribute in the performance reports. I don't care about other fields when updating

Re: Using reports to sync account structure

Oliver - Use a predicate for Impressions = 0; this seems to return all entities regardless of the value of the includeZeroImpressions flag. HTH - mm On Tuesday, June 12, 2012 10:10:27 AM UTC-5, Oliver wrote: Hi, What is the best way to synchronize our local database record of the account

Re: Using reports to sync account structure

Hi Oliver, See the report fields listed on https://developers.google.com/adwords/api/docs/appendix/reports. If you include certain fields in a report, it prevents zero impression rows from being returned even if you have set includeZeroImpressions as true. Such columns are explicitly