I've also the same problem with all the active ads in the same campaign, have more than two performances for search only / day with different data, and the sum of imps or clicks in total matches the campaign performance.
On Feb 24, 2:36 pm, AdWords API Advisor <[email protected]> wrote: > 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 > > ... > > read more » --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
