MCC API Access Only Doesn't Return Keyword Data

[sneilan]

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.

[sneilan]

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.

[AdWords API Advisor]

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

[sneilan]

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
(
[@attributes] => 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
(
[@attributes] => 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

[sneilan]

I forgot to mention, I don't have access to the AdWords account in
Question.

On Aug 27, 10:58 am, AdWords API Advisor
<adwordsapiadvi...@google.com> wrote:

[AdWords API Advisor]

Hello,

Thanks for passing that along. The different return columns have to
do with whether the campaign in question is targeted using keywords,
websites (placements), or both. This is a longstanding source of
confusion and actually has made it into our Developer's Guide, though
it only goes into detail on the page describing the Placement /
Keyword Performance Report, not the Campaign Performance report. If
you take a look at

http://www.google.com/apis/adwords/developer/adwords_api_report_keyword.html

you should see a "Note:" section that explains the factors that could
lead to different response columns. The actual column names are listed
under the "Response XML" heading.

Sorry for the confusion, but this is considered to be working as
expected.

Cheers,
-Jeff Posnick, AdWords API Team

[sneilan]

Cool! Thank you very much!

On Aug 27, 2:58 pm, AdWords API Advisor <adwordsapiadvi...@google.com>
wrote:
> Hello,
>

>  Thanks for passing that along. The different return columns have to
> do with whether the campaign in question is targeted using keywords,
> websites (placements), or both. This is a longstanding source of
> confusion and actually has made it into our Developer's Guide, though
> it only goes into detail on the page describing the Placement /
> Keyword Performance Report, not the Campaign Performance report. If
> you take a look at
>

>  http://www.google.com/apis/adwords/developer/adwords_api_report_keywo...