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
-~----------~----~----~----~------~----~------~--~---
