Hmm.. Why don't I use gets? I assume that you are meaning, why don't I traverse our entire account structure, getting campaigns/adgroups/ keywords.. synchronizing via get calls.
Basically it comes down to counts. In our database we have 7151368 keywords. 662226 ads, 560203 adgroups. Not all active now of course. -- The people doing the advertising are always rebuilding things. When we get a new client, all of a sudden we have a hundred thousand new keywords... sometimes much more.. And I go and download statistics for the last year. So we can see what worked in the past and what didn't. Before, getting all of these items via get calls would have been ridiculously slow. Maybe 2009 it isn't? -- What use do we have for full data downloads: We run "automations" on our data. So that if something isn't performing well, either someone gets and e-mail or it is automatically turned off. We also do this thing, where our clients can give us these raw data sheets of products that they have in stock and out of stock, discontinued etc etc. We have automations go in and modify the linked items. Our history ability stems from a client that was freaking out a year ago; and also once, one of our client accounts was hacked. Actually in yahoo, not in google. At that point I decided we should know all of the changes and when they take place. Yahoo has/had, I think they removed it actually, this nice ability to see when parts of the data changed, so we could get exact time stamps. So, here is my question for you: In V13... What is the oldest line of code still around. What year/ month did it come from? And extra credit for the single line of code. (although I'm not expecting it) [ no credit for blank lines btw ] -tim On Dec 4, 5:06 pm, AdWords API Advisor <[email protected]> wrote: > Hi Tim, > > Thanks for feedback, always helpful to hear how people are using the > API. I apologize if you've covered this one of my predecessors, but > I'd be interested to hear about your reasons for using reports instead > of get() calls to retrieve the campaign data? In what situations has > it been helpful to have a complete record of your accounts locally? > > Thanks for the insight, > - Eric > > On Dec 3, 8:16 pm, timprepscius <[email protected]> wrote: > > > > > I haven't taken a look at the api really for quite a while. These > > issues may already be addressed. > > And at least the last two "crews" knew of my existence, so.. > > > In a nutshell: > > > I download all of our MCC's everyday. I record within our database > > everything. > > I keep track of all changes that have occurred. > > I can go back in time and see how something was going 3 months ago, > > and see what is going on now. > > > Long long ago, google introduced the structure report. > > However, > > 1) it was buggy > > 2) it used different enum labels for data than in other reports (which > > is quite frustrating) > > 3) was not mcc friendly > > 4) left out information > > 5) was missing columns and sometimes combined columns > > > So basically after giving up on the structure report, I synthesized a > > structure report by doing a statistics report with no statistics > > (however actually, when I left out all statistics, items were left > > out, so I started including impressions I believe) > > > But now I guess this synthesized structure report is becoming too > > large. Cause it continues to time out whereas a week ago it didn't. > > It's timing out right now actually. I think. > > > Maybe 2009 already has a a simple api call: > > "get me everything, and I mean everything, across this entire mcc > > account; and don't worry our data columns will stay the same all of > > the time, and the enums will be properly documented; we don't leave > > out any crucial data; and it will only take 15 minutes to generate;" > > > -tim > > > On Dec 2, 6:16 pm, AdWords API Advisor <[email protected]> > > wrote: > > > > Hi Tim, > > > > Out of curiosity, what is your use case that involves downloading the > > > entire MCC? I can't guarantee that the v2009 API will address your > > > concerns, but at the very least I could pass your feedback to the core > > > engineering team. > > > > Best, > > > - Eric > > > > On Dec 2, 3:26 pm, timprepscius <[email protected]> wrote: > > > > > I suppose so... > > > > > <said the programmer, who turned back to his terminal and gave a large > > > > sigh; from which his manager walked away and gave an even larger and > > > > longer sigh while looking wistfully at the bland white plasti-board > > > > ceiling> > > > > > [just wanted to add some non-essentials :-) ] > > > > > I hope this 2009 service update is going to include an easy way to > > > > download an entire MCC. In a report that doesn't take hours to > > > > generate. Maybe it already does. Have to look again. > > > > > -tim > > > > > On Dec 2, 2:32 pm, AdWords API Advisor <[email protected]> > > > > wrote: > > > > > > Hi Tim, > > > > > > I am not aware in any changes to the way reports are processed. From > > > > > your description it sounds like this report has been on the cusp to > > > > > "too large" for some time. Is there any way you can scale back the > > > > > size of the report? Perhaps split it into multiple reports? > > > > > > Best, > > > > > - Eric Koleda, AdWords API Team > > > > > > On Dec 2, 2:06 pm, timprepscius <[email protected]> wrote: > > > > > > > Greetings, > > > > > > > Has anything changed about the allocation of resources for reports > > > > > > in > > > > > > the last week? > > > > > > > All of a sudden a few reports are constantly timing out. Meaning > > > > > > they > > > > > > never ever finish. They are large, however, they previously timed > > > > > > out maybe once a month. > > > > > > > (except about 1.5 years ago they timed out once every 3 days, but > > > > > > then > > > > > > all of a sudden it seemed your resources became much larger) > > > > > > > Thanks, > > > > > > > -tim -- You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en.
