Hello J,
I actually like the solution provided by Zweitze. Querying the oldest campaign (make sure you include inactive campaigns too) will product the date which is guaranteed to be same or earlier as the first impression date. This should be more reliable than the empty report case. -Danial, AdWords API Team. On Wednesday, October 31, 2012 4:24:24 AM UTC+4, J wrote: > > I have the same need to know the account creation date. > > In my case, I need to know the account creation date because I'm building > a reporting service that queries the CAMPAIGN_PERFORMANCE_REPORT (AdHoc > reports). The algorithm I'm using is to start with today's date, then > query backwards (reverse chronologically) one month at a time. The problem > is I need a reliable way to know when to stop querying. My current method > is to stop querying when I get 0 records for a query. I'm not sure if this > is reliable as I'm guessing it's possible that there could be no activity > for a month (perhaps when campaigns are paused)? > > Knowing the account creation date would give me a reliable way to stop > querying since this will ensure that I'm querying the entire period of the > account's existence. > > Zweitze - I will try your way of using CampaignService. It's too bad the > account creation date is not returned in the CustomerService.get() call. > > Any better ideas? > > On Wednesday, September 12, 2012 1:41:17 AM UTC-7, Zweitze wrote: >> >> I use a different, slightly better method: >> >> Use campaignservice, just get campaigns and make sure you ask for the >> campaign start date. The campaign start date is NOT the date the campaign >> was created, still, it is usual earlier than the date of the first >> impression. >> >> To get the earliest date of an account I ask for campaigns sorted on >> campaign start date and limit the results to 1, costing me 1 unit. >> >> Another direction would be the customersyncservice, just get the date of >> the first change in the account. BTW I never tested this. >> >> Hope this helps >> >> >> On Tuesday, September 11, 2012 10:20:00 AM UTC+2, Oliver wrote: >> >>> Thanks. However, I think the first date in the report will be the date >>> the account started accruing impressions rather than the account creation >>> date (since Date prevents zero impressions). >>> >>> I tested it in one of our accounts and confirmed this is the case. >>> >>> Hence, I guess the account creation date cannot be retrieved unless the >>> account started accruing impressions on the same day it was created. >>> Oliver >>> >>> >>> On Monday, September 10, 2012 4:21:11 PM UTC+1, Danial Klimkin wrote: >>>> >>>> Hello Oliver, >>>> >>>> >>>> I meant the data itself. In a report with the date column the very >>>> early date present could be the one you are looking for. >>>> >>>> >>>> -Danial, AdWords API Team. >>>> >>>> >>>> On Monday, September 10, 2012 6:23:59 PM UTC+4, Oliver wrote: >>>>> >>>>> Hi Danial, >>>>> >>>>> Can you please elaborate? >>>>> >>>>> I presume you mean get an account performance report, specifying >>>>> ALL_TIME as the date range. Correct? The report returned has this in the >>>>> first line: >>>>> >>>>> <report name> (All Time) >>>>> >>>>> I can't see the date you were referring to? >>>>> >>>>> >>>>> Oliver >>>>> >>>>> >>>>> On Monday, September 10, 2012 2:19:58 PM UTC+1, Danial Klimkin wrote: >>>>>> >>>>>> Hello spetz, >>>>>> >>>>>> >>>>>> I believe this date comes from the very first row of impressions data >>>>>> ran with no filter rather than from any stored value. The API does not >>>>>> provide the account creation date. >>>>>> >>>>>> >>>>>> -Danial, AdWords API Team. >>>>>> >>>>>> >>>>>> On Friday, September 7, 2012 4:21:14 PM UTC+4, spetz wrote: >>>>>>> >>>>>>> Actually, what I want to show in my application is the start date >>>>>>> that you see when you click on "All time" from the date template list >>>>>>> in >>>>>>> your Adwords account. >>>>>>> >>>>>>> forexample if you've created your account in 1 January 2012, you >>>>>>> will see this date and today's date if you click to "All time" reports >>>>>>> in >>>>>>> Adwords. So I would like to show this date when I attemp to get >>>>>>> campaign >>>>>>> list for all time (I use "01/01/1970" as starDate in dateRange >>>>>>> selector, so >>>>>>> I get this date in the campaignStats object as response!) >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> 5 Eylül 2012 Çarşamba 18:06:11 UTC+3 tarihinde Oliver yazdı: >>>>>>>> >>>>>>>> Are you asking about the creation date of a campaign (as in >>>>>>>> question title) or the creation date of an account (as in your >>>>>>>> question >>>>>>>> body)? >>>>>>>> >>>>>>>> If for a campaign, you can find this out by fetching the campaign's >>>>>>>> "StartDate" from the CampaignService object. >>>>>>>> >>>>>>>> Not sure a start date of an account is available anywhere. >>>>>>>> >>>>>>>> Oliver >>>>>>>> >>>>>>>> On Wednesday, September 5, 2012 1:37:30 PM UTC+1, spetz wrote: >>>>>>>>> >>>>>>>>> hey there, >>>>>>>>> >>>>>>>>> I query campaigns in "all time" as google adwords does. I know >>>>>>>>> that I could fetch the whole campaign data by setting start date to >>>>>>>>> something 01/01/1900 and it works as I see the same results (amounts >>>>>>>>> and >>>>>>>>> numbers I mean) with adwords. but the question is what is the exact >>>>>>>>> start >>>>>>>>> date of that result set, that is not year 1900 for example. This >>>>>>>>> means >>>>>>>>> Google is able to show the creation date of an account to use it to >>>>>>>>> fetch >>>>>>>>> all data from the beginning, how will we do that using API? >>>>>>>>> >>>>>>>> -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http://groups.google.com/group/adwords-api =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en
