Hello Pepe, Thanks for clarifying.
The examples you should indicate that there are multiple rows for "Seach Only" statistics, and the only specific thing that I could think of that might cause the disaggregation is that there is a different firstPageCpc/qualityScore associated with each row. The qualityScore and firstPageCpc data is not historical, and show be whatever the current value is as of the time the report is run, so it's strange to see multiple values listed. When I took a look at the ad group in question, I see that the ad with that id is currently deleted. I can't help but think that this is related to what you're seeing in the report--there may be some edge case where the firstPageCpc/qualityScore calculation is not stable for deleted ads. Are you seeing this behavior for any ads that are not deleted? In any case, if you add up the impression and click informaiton for each of the rows you should get the accurate total data for that given day. Cheers, -Jeff Posnick, AdWords API Team On Feb 24, 12:59 pm, Pepe <[email protected]> wrote: > When i run a report with the ruby code from behind thru the API I get > the xml with multiple records for one Ad Copy in one Day > but when I run a report in Web Interface with the client account it > only returns two records one for Content and the other one > for Search Only, I need to know if there is a way to get the API > report like that or how could I merge the multiple performance > record. > > Client Manager: 391-450-2280 > Client: 277-219-5380 > > Ruby Code for Report Detail > > job = AdWords::DefinedReportJob.new > > # Campaigns > job.campaigns = campaigns.collect { |c| c.google_campaign_id } > > # Daily > job.aggregationTypes = 'Daily' > job.name = 'adword' + Time.now.strftime("%m%d%Y%I%M%S") + > '[email protected]_s > > # 6 Months Report > job.startDay = from_queue ? "#{(6.months.ago).strftime("%Y-%m-%d")}" : > (campaigns[0].last_sync_date).strftime("%Y-%m-%d") > job.endDay = (Date.yesterday).strftime("%Y-%m-%d") > puts '*** ' + job.startDay.to_s + " to " + job.endDay.to_s + ' ***' > job.clientEmails = user > job.crossClient = true > > # Report Columns > job.selectedColumns = %w{FirstPageCpc QualityScore AdWordsType > DailyBudget MaximumCPC MaxContentCPC TopPosition BottomPosition > Impressions Clicks CTR CPC Cost AveragePosition Conversions > CostPerConverstion ConversionRate Transactions CostPerTransaction > TotalConversionValue AverageConversionValue ValuePerCost ValuePerClick > SalesCount SalesValue LeadCount LeadValue SignupCount SignupValue > PageViewCount PageViewValue DefaultCount DefaultValue CampaignId} > > Example of xml rows returned > > Report Columns > > <columns><column name="date"></column><column name="campaignid"></ > column><column name="firstPageCpc"></column><column > name="qualityScore"></column><column name="creativeid"></ > column><column name="adwordsType"></column><column name="budget"></ > column><column name="maxCpc"></column><column name="maxContentCpc"></ > column><column name="topPosition"></column><column > name="bottomPosition"></column><column name="imps"></column><column > name="clicks"></column><column name="ctr"></column><column > name="cpc"></column><column name="cost"></column><column name="pos"></ > column><column name="conv"></column><column name="convRate"></ > column><column name="costPerConv"></column><column > name="transactions"></column><column name="cpt"></column><column > name="convValue"></column><column name="avgConvValue"></column><column > name="valueCostRatio"></column><column name="convVpc"></column><column > name="purchases"></column><column name="purchaseValue"></ > column><column name="leads"></column><column name="leadValue"></ > column><column name="signups"></column><column name="signupValue"></ > column><column name="pageviews"></column><column > name="pageviewValue"></column><column name="defaultConv"></ > column><column name="defaultConvValue"></column></columns> > > Date = 2008-11-24 > Ad Copy = 3522634265 > > <row date="2008-11-24" campaignid="37648415" firstPageCpc="" > qualityScore="" creativeid="3522634265" adwordsType="Content Only" > budget="8000000" maxCpc="" maxContentCpc="750000" topPosition="" > bottomPosition="" imps="4930" clicks="2" ctr="4.0567951318458417E-4" > cpc="685000" cost="1370000" pos="3.3421906694" conv="0" convRate="0.0" > costPerConv="0" transactions="0" cpt="0" convValue="0.0" > avgConvValue="0.0" valueCostRatio="0.0" convVpc="0.0" purchases="0" > purchaseValue="0.0" leads="0" leadValue="0.0" signups="0" > signupValue="0.0" pageviews="0" pageviewValue="0.0" defaultConv="0" > defaultConvValue="0.0"></row> > > <row date="2008-11-24" campaignid="37648415" firstPageCpc="12000000" > qualityScore="6" creativeid="3522634265" adwordsType="Search Only" > budget="8000000" maxCpc="4000000" maxContentCpc="750000" > topPosition="" bottomPosition="" imps="3" clicks="0" ctr="0.0" cpc="0" > cost="0" pos="1.3333333333" conv="0" convRate="0.0" costPerConv="0" > transactions="0" cpt="0" convValue="0.0" avgConvValue="0.0" > valueCostRatio="0.0" convVpc="0.0" purchases="0" purchaseValue="0.0" > leads="0" leadValue="0.0" signups="0" signupValue="0.0" pageviews="0" > pageviewValue="0.0" defaultConv="0" defaultConvValue="0.0"></row> > > <row date="2008-11-24" campaignid="37648415" firstPageCpc="9250000" > qualityScore="7" creativeid="3522634265" adwordsType="Search Only" > budget="8000000" maxCpc="4000000" maxContentCpc="750000" > topPosition="" bottomPosition="" imps="1" clicks="0" ctr="0.0" cpc="0" > cost="0" pos="5.0" conv="0" convRate="0.0" costPerConv="0" > transactions="0" cpt="0" convValue="0.0" avgConvValue="0.0" > valueCostRatio="0.0" convVpc="0.0" purchases="0" purchaseValue="0.0" > leads="0" leadValue="0.0" signups="0" signupValue="0.0" pageviews="0" > pageviewValue="0.0" defaultConv="0" defaultConvValue="0.0"></row> > > Date = 2008-11-25 > Ad Copy = 3522634265 > > <row date="2008-11-25" campaignid="37648415" firstPageCpc="" > qualityScore="" creativeid="3522634265" adwordsType="Content Only" > budget="8000000" maxCpc="" maxContentCpc="750000" topPosition="" > bottomPosition="" imps="7273" clicks="1" ctr="1.3749484394335213E-4" > cpc="680000" cost="680000" pos="3.7556716623" conv="0" convRate="0.0" > costPerConv="0" transactions="0" cpt="0" convValue="0.0" > avgConvValue="0.0" valueCostRatio="0.0" convVpc="0.0" purchases="0" > purchaseValue="0.0" leads="0" leadValue="0.0" signups="0" > signupValue="0.0" pageviews="0" pageviewValue="0.0" defaultConv="0" > defaultConvValue="0.0"></row> > > <row date="2008-11-25" campaignid="37648415" firstPageCpc="12000000" > qualityScore="6" creativeid="3522634265" adwordsType="Search Only" > budget="8000000" maxCpc="4000000" maxContentCpc="750000" > topPosition="" bottomPosition="" imps="4" clicks="0" ctr="0.0" cpc="0" > cost="0" pos="10.75" conv="0" convRate="0.0" costPerConv="0" > transactions="0" cpt="0" convValue="0.0" avgConvValue="0.0" > valueCostRatio="0.0" convVpc="0.0" purchases="0" purchaseValue="0.0" > leads="0" leadValue="0.0" signups="0" signupValue="0.0" pageviews="0" > pageviewValue="0.0" defaultConv="0" defaultConvValue="0.0"></row> > > <row date="2008-11-25" campaignid="37648415" firstPageCpc="24000000" > qualityScore="7" creativeid="3522634265" adwordsType="Search Only" > budget="8000000" maxCpc="4000000" maxContentCpc="750000" > topPosition="" bottomPosition="" imps="11" clicks="0" ctr="0.0" > cpc="0" cost="0" pos="13.9090909091" conv="0" convRate="0.0" > costPerConv="0" transactions="0" cpt="0" convValue="0.0" > avgConvValue="0.0" valueCostRatio="0.0" convVpc="0.0" purchases="0" > purchaseValue="0.0" leads="0" leadValue="0.0" signups="0" > signupValue="0.0" pageviews="0" pageviewValue="0.0" defaultConv="0" > defaultConvValue="0.0"></row> > > <row date="2008-11-25" campaignid="37648415" firstPageCpc="8500000" > qualityScore="7" creativeid="3522634265" adwordsType="Search Only" > budget="8000000" maxCpc="4000000" maxContentCpc="750000" > topPosition="" bottomPosition="" imps="3" clicks="0" ctr="0.0" cpc="0" > cost="0" pos="13.6666666667" conv="0" convRate="0.0" costPerConv="0" > transactions="0" cpt="0" convValue="0.0" avgConvValue="0.0" > valueCostRatio="0.0" convVpc="0.0" purchases="0" purchaseValue="0.0" > leads="0" leadValue="0.0" signups="0" signupValue="0.0" pageviews="0" > pageviewValue="0.0" defaultConv="0" defaultConvValue="0.0"></row> > > <row date="2008-11-25" campaignid="37648415" firstPageCpc="9250000" > qualityScore="7" creativeid="3522634265" adwordsType="Search Only" > budget="8000000" maxCpc="4000000" maxContentCpc="750000" > topPosition="" bottomPosition="" imps="21" clicks="0" ctr="0.0" > cpc="0" cost="0" pos="17.5238095238" conv="0" convRate="0.0" > costPerConv="0" transactions="0" cpt="0" convValue="0.0" > avgConvValue="0.0" valueCostRatio="0.0" convVpc="0.0" purchases="0" > purchaseValue="0.0" leads="0" leadValue="0.0" signups="0" > signupValue="0.0" pageviews="0" pageviewValue="0.0" defaultConv="0" > defaultConvValue="0.0"></row> > > On Feb 24, 11:08 am, AdWords API Advisor > > <[email protected]> wrote: > > Hello Pepe, > > > I'm not sure I understand the issue that you're reporting. Are you > > running identical reports via the API, one from an MCC account using > > clientEmail and the other from an AdWords account directly and seeing > > different results? If so, could you post an example of the report XML > > being returning illustrating the problem, and ideally something that I > > could use to identify the accounts, like their account id number? > > > Cheers, > > -Jeff Posnick, AdWords API Team > > > On Feb 24, 11:25 am, Pepe <[email protected]> wrote: > > > > Hi, > > > I'm having some trouble with the Ad Performance report, when requested > > > from the Client Manager access level User Interface and API with > > > aggregationTypes = Daily it returns multiple regs for one same Ad Copy > > > in one day, but when requested from the Client account with > > > Administrative Access just have two records for one Ad Copy in one day > > > one for the Content and the other for Search Only. > > > > Thanks :) --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
