Hi, reporting in newer versions is completely different than in v13. Reports are generates synchronously and new service with different data types is used: ReportDefinitionService<http://code.google.com/apis/adwords/docs/reference/latest/ReportDefinitionService.html> .
For more details about reporting, see Reporting Basics<http://code.google.com/apis/adwords/docs/reportingtopics.html> . On Wed, Jun 1, 2011 at 3:02 PM, uttam mohanty <[email protected]>wrote: > Hi All, > Can any one share the code for report job structure for adwords api v201101 > > > > On Wed, Jun 1, 2011 at 5:47 PM, munna <[email protected]> wrote: > >> Hi, >> I was using adwords api v13.Now need to upgrade to v201101. >> I am not able to generate the report job structure properly.I am using >> PHP. >> code: >> <?php >> require '/mnt/www/html/reports/googleapi/header.php'; >> //require 'header.php'; >> chdir('/mnt/www/html/reports/googleapi/'); >> >> $apis = getApis(); >> if(sizeof($apis)){ >> foreach($apis as $api){ >> $sql = "SELECT accounts.* >> FROM accounts, api_account >> WHERE accounts.id = >> api_account.account_id >> AND api_account.api_id = >> ".$api['id']." >> AND accounts.searchengine = >> 'google' >> AND accounts.timezone = >> '".$argv[1]."' >> AND accounts.username != '' >> AND accounts.status = 'active'"; >> $res = mysql_query($sql); >> $num = mysql_num_rows($res); >> if($num){ >> $clientEmails = ''; >> while($row = mysql_fetch_assoc($res)){ >> $clientEmails .= >> '<clientEmails>'.$row['username'].'</ >> clientEmails>'; >> } >> //echo $clientEmails;exit; >> $apilityUser = new APIlityUser($api['username'], >> $api['password'], >> $api['client_email'], $api['devtoken'], $api['apptoken']); >> >> $soapClients = &APIlityClients::getClients(); >> $someSoapClient = $soapClients->getReportClient(); >> $reportNumber = 1; >> >> $day = $argv[1] == 'IN' ? 0 : 1; >> for($i = $day; $i<3; $i++){ >> $startDay = date('Y-m-d', mktime(0, 0, 0, >> date("m") , date("d")- >> $i, date("Y"))); >> $endDay = $startDay; >> >> # Create report job structure. >> $report_job = >> >> '<selectedReportType>Keyword</selectedReportType>' . >> '<name>Keyword Report - >> '.$startDay.'</name>' . >> >> '<aggregationTypes>Daily</aggregationTypes>' . >> '<crossClient>true</crossClient>' . >> $clientEmails. >> >> '<includeZeroImpression>false</includeZeroImpression>' . >> >> '<startDay>'.$startDay.'</startDay>' . >> '<endDay>'.$endDay.'</endDay>' . >> >> '<selectedColumns>CustomerName</selectedColumns>' . >> >> '<selectedColumns>ExternalCustomerId</selectedColumns>' . >> >> '<selectedColumns>Campaign</selectedColumns>' . >> >> '<selectedColumns>CampaignId</selectedColumns>' . >> >> '<selectedColumns>AdGroup</selectedColumns>' . >> >> '<selectedColumns>AdGroupId</selectedColumns>' . >> >> '<selectedColumns>Keyword</selectedColumns>' . >> >> '<selectedColumns>KeywordId</selectedColumns>' . >> >> '<selectedColumns>KeywordTypeDisplay</selectedColumns>' . >> >> '<selectedColumns>KeywordStatus</selectedColumns>' . >> >> '<selectedColumns>FirstPageCpc</selectedColumns>' . >> >> '<selectedColumns>QualityScore</selectedColumns>' . >> >> '<selectedColumns>MaxContentCPC</selectedColumns>' . >> >> '<selectedColumns>MaximumCPC</selectedColumns>' . >> >> '<selectedColumns>MaximumCPM</selectedColumns>' . >> >> '<selectedColumns>PreferredCPC</selectedColumns>' . >> >> '<selectedColumns>PreferredCPM</selectedColumns>' . >> >> '<selectedColumns>KeywordDestUrlDisplay</selectedColumns>' . >> >> '<selectedColumns>Impressions</selectedColumns>' . >> >> '<selectedColumns>Clicks</selectedColumns>' . >> >> '<selectedColumns>CTR</selectedColumns>' . >> >> '<selectedColumns>CPC</selectedColumns>' . >> >> '<selectedColumns>CPM</selectedColumns>' . >> >> '<selectedColumns>Cost</selectedColumns>' . >> >> '<selectedColumns>AveragePosition</selectedColumns>' . >> >> '<selectedColumns>CustomerTimeZone</selectedColumns>' . >> >> '<selectedColumns>Conversions</selectedColumns>' . >> >> '<selectedColumns>ConversionCost</selectedColumns>' . >> >> '<selectedColumns>ConversionRate</selectedColumns>' . >> >> '<selectedColumns>CostPerConverstion</selectedColumns>' . >> >> '<selectedColumns>SalesCount</selectedColumns>' . >> >> '<selectedColumns>LeadCount</selectedColumns>' . >> >> '<selectedColumns>SignupCount</selectedColumns>' . >> '<selectedColumns>View-through conv.</ >> selectedColumns>' . >> >> '<selectedColumns>DefaultCount</selectedColumns>'; >> >> $request_xml = >> '<validateReportJob xmlns=" >> https://adwords-sandbox.google.com/api/ >> adwords/cm/'.API_VERSION.'">' . >> '<job xsi:type="DefinedReportJob">' >> . >> $report_job . >> '</job>' . >> '</validateReportJob>'; >> echo $request_xml; >> # Validate report. >> $someSoapClient->call('validateReportJob', >> $request_xml); >> if ($someSoapClient->fault){ >> >> show_fault($someSoapClient, 'for >> Api Id : '.$api['id'], $i); >> continue; >> } >> >> # Schedule report. >> $request_xml = >> '<scheduleReportJob xmlns=" >> https://adwords-sandbox.google.com/api/ >> adwords/cm/'.API_VERSION.'"> >> <job xsi:type="DefinedReportJob">' . >> $report_job . >> '</job>' . >> '</scheduleReportJob>'; >> $job_id = >> $someSoapClient->call('scheduleReportJob', >> $request_xml); >> echo "<pre>"; >> print_r($job_id); >> $job_id = >> $job_id['scheduleReportJobReturn']; >> echo "Schedule report JOB ID".$job_id." >> \n"; >> >> ?> >> I am not able to get the report job id.This code is working fine for >> v13 not for the v201101.Please suggest me what needs to be done.As i >> need dis badly.Waiting for the response. > > > > > -- > Uttam mohanty. > > -- > =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ > 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 [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 > -- AdWords API in C# / VB.NET <http://www.gemboxsoftware.com/Ppc/Overview.htm> adCenter API in C# / VB.NET <http://www.gemboxsoftware.com/Ppc/Overview.htm> - GemBox.Ppc component -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 [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
