Sorry about that!
--------------------the missing columns & raw
data----------------------------
Each row of data from Google from this one client comes in like this:
(I've replaced client information with ______'s)
(Notice that the raw data is coming in differently on a per client
basis.)
This one client has these columns:
keyword
kwType
kwStatus
Other clients have these columns:
kwSite
kwSiteType
siteKwStatus
>>>>>>> this one client's data
SimpleXMLElement Object
(
[EMAIL PROTECTED] => Array
(
[weekStart] => 8/18/08 - 8/24/08
[campaign] => Campaign #1 content
[adgroup] => ___________
[keyword] => Total - content targeting
[kwType] => Content
[kwStatus] =>
[keywordMinCpc] => 0
[preview] => Not available
[headline] => _________
[desc1] => _________________
[desc2] => ________________
[creativeVisUrl] => _____________
[creativeid] => _____________
[creativeType] => text
[creativeStatus] => Enabled
[adwordsType] => Content Only
[budget] => 2
[maxCpc] => 0
[maxContentCpc] => 0
[topPosition] =>
[bottomPosition] =>
[kwDestUrl] =>
[agStatus] => Enabled
[creativeDestUrl] => ________________
[campStatus] => Active
[imps] => 116
[clicks] => 0
[ctr] => 0.0
[cpc] => 0
[cost] => 0
[pos] => 4.0862068966
[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
[budgetAmount] => 0
[cpmHeads] => 0
[costPerHead] => 0
[estimatedVideoCpm] => 0
[convCost] => 0
[lostImpShareBudget] => 0
[conversionMaxCpa] => 0
[maxCpp] => 0
[agMaxCpa] => 0
[preferredCpm] => 0
[preferredCpc] => 0
[maxCpm] => 0
[cpm] => 0
)
)
>>>>>>>>>>>>>>>Other client's data
SimpleXMLElement Object
(
[EMAIL PROTECTED] => Array
(
[weekStart] => 7/7/08 - 7/13/08
[campaign] => __________
[adgroup] => __________
[kwSite] => _____________
[kwSiteType] => _________
[siteKwStatus] => Active
[keywordMinCpc] => 0
[preview] => Not available
[headline] => ____________
[desc1] => ______________
[desc2] => ___________
[creativeVisUrl] => _________
[creativeid] => ___________
[creativeType] => text
[creativeStatus] => Enabled
[adwordsType] => Content Only
[budget] => 0.01
[maxCpc] => 3
[maxContentCpc] => 0
[topPosition] =>
[bottomPosition] =>
[kwDestUrl] => default URL
[agStatus] => Enabled
[creativeDestUrl] => ___________
[campStatus] => Paused
[imps] => 3
[clicks] => 0
[ctr] => 0.0
[cpc] => 0
[cost] => 0
[pos] => 2.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
[budgetAmount] => 0
[cpmHeads] => 0
[costPerHead] => 0
[estimatedVideoCpm] => 0
[convCost] => 0
[lostImpShareBudget] => 0
[conversionMaxCpa] => 0
[maxCpp] => 0
[agMaxCpa] => 0
[preferredCpm] => 0
[preferredCpc] => 0
[maxCpm] => 0
[cpm] => 0
)
)
---------------The way I'm requesting data is like
this:--------------------
I'm using the latest version of Apility
I first login with apility. (I do have the right logins, otherwise I
wouldn't be getting data in the first place)
Then, I get the Creative Xml Report. (This is an Gets an Ad
performance report.) The value of the $report variable is something
random. I think I just tossed something in there because it didn't
seem to make much of a difference with other accounts.
$output = getCreativeXmlReport(
$report,
$begindate,
$enddate,
array('Campaign', 'AdGroup', 'Keyword', 'KeywordTypeDisplay',
'KeywordStatus', 'KeywordMinCPC', 'Preview', 'DescriptionLine1',
'DescriptionLine2', 'DescriptionLine3', 'VisibleUrl',
'CreativeDestUrl', 'CreativeId', 'CreativeType', 'AdStatus',
'AdWordsType', 'DailyBudget', 'MaximumCPC', 'MaxContentCPC',
'TopPosition', 'BottomPosition', 'KeywordDestUrlDisplay',
'AdGroupStatus', 'CampaignStatus', 'Impressions', 'Clicks', 'CTR',
'CPC', 'Cost', 'AveragePosition', 'Conversions', 'ConversionRate',
'CostPerConverstion', 'Transactions', 'CostPerTransaction',
'TotalConversionValue', 'AverageConversionValue', 'ValuePerCost',
'ValuePerClick', 'SalesCount', 'SalesValue', 'LeadCount', 'LeadValue',
'SignupCount', 'SignupValue', 'PageViewCount', 'PageViewValue',
'DefaultCount', 'DefaultValue', 'AverageConversionValue',
'ConversionCost'),
array($period),
array(),
array(),
array(),
array(),
array(),
array(),
'',
'',
false,
array($authentication['Client_Email']),
false,
30,
false
);
I parse the $output variable & iterate through the rows:
$xml = new SimpleXMLElement($output); // parse xml data
$Rows = $xml->xpath('/report/table/rows/row'); // get rows of data
Then, I print the row of data from the report.
foreach($Rows as $row) {
print_r($row);
}
-------------------The question---------------------
What on earth is going on here..
On Aug 27, 10:58 am, AdWords API Advisor
<[EMAIL PROTECTED]> wrote:
> Hello,
>
> I'm not clear on the behavior you're seeing, and I don't know of any
> reason you'd see slightly different reports behavior due to whether
> your MCC was linked as API-only or web interface and API.
>
> Could you provide an example of a row that you're getting back from
> the reports service that illustrates the problem? If you have access
> to the credentials for the AdWords account in question, can you try
> scheduling the report via the API using the credentials of the account
> instead of your MCC credentials and see if the results are the same?
>
> Cheers,
> -Jeff Posnick, AdWords API Team
>
> On Aug 26, 5:06 pm, sneilan <[EMAIL PROTECTED]> wrote:
>
> > I forgot to mention, the other accounts in my MCC (which are not API
> > access only) work. Meaning, they do get Keyword data from Google.
>
> > Again, thank you for your time.
>
> > On Aug 26, 2:53 pm, sneilan <[EMAIL PROTECTED]> wrote:
>
> > > I've got an MCC account with API access only. When I request the
> > > following columns of data in a Weekly or Monthly Ad Performance
> > > Report, I do not recieve the Keyword column in the response from
> > > Google. (In addition to other columns).
>
> > > I'm requesting the following columns in my Soap Request:
> > > ('Campaign', 'AdGroup', 'Keyword', /* no match type */
> > > 'KeywordTypeDisplay', 'KeywordStatus', 'KeywordMinCPC', 'Preview',
> > > 'DescriptionLine1', 'DescriptionLine2', 'DescriptionLine3',
> > > 'VisibleUrl', 'CreativeDestUrl', 'CreativeId', 'CreativeType',
> > > 'AdStatus', 'AdWordsType', 'DailyBudget', 'MaximumCPC',
> > > 'MaxContentCPC', 'TopPosition', 'BottomPosition',
> > > 'KeywordDestUrlDisplay', 'AdGroupStatus', 'CampaignStatus',
> > > 'Impressions', 'Clicks', 'CTR', 'CPC', 'Cost', 'AveragePosition',
> > > 'Conversions', 'ConversionRate', 'CostPerConverstion', 'Transactions',
> > > 'CostPerTransaction', 'TotalConversionValue',
> > > 'AverageConversionValue', 'ValuePerCost', 'ValuePerClick',
> > > 'SalesCount', 'SalesValue', 'LeadCount', 'LeadValue', 'SignupCount',
> > > 'SignupValue', 'PageViewCount', 'PageViewValue', 'DefaultCount',
> > > 'DefaultValue', 'AverageConversionValue', 'ConversionCost')
>
> > > I'm running PHP 5.2.4 with the Apility Library on Ubuntu 8.04 (Hardy
> > > Heron). Please tell me if I should provide for information.
>
> > > Thank you very much for your time.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
