Re: Search query Report

Hi,

The KeywordTextMatchingQuery field represents the portion of the keyword text that matched the user's query, so it will not contain the + character. If you want to limit your results to a specific Keyword criterion, you can get that Keyword's ID (either from the KEYWORDS_PERFORMANCE_REPORT or from AdGroupCriterionService), and then look for rows in the SEARCH_QUERY_PERFORMANCE_REPORT where the KeywordId matches that ID.

I'm not sure what your specific use case is, but you may want to consider simply using the KEYWORDS_PERFORMANCE_REPORT, which will give you performance stats summarized by Keyword criteria. In contrast, the SEARCH_QUERY_PERFORMANCE_REPORT returns stats summarized by search term (the Query field).

Thanks,

Josh, AdWords API Team

On Thursday, January 28, 2016 at 4:50:51 PM UTC-5, jonathan@garagecoders.net wrote:

<reportDefinition xmlns='https://adwords.google.com/api/adwords/cm/v201506'>

    <selector>

        <fields>AdGroupId</fields>

        <fields>CampaignName</fields>

        <fields>CampaignId</fields>

        <fields>AdGroupName</fields>

        <fields>AdGroupStatus</fields>

        <fields>AveragePosition</fields>

        <fields>Impressions</fields>

        <fields>Clicks</fields>

        <fields>KeywordId</fields>

        <fields>AverageCpc</fields>

        <fields>Cost</fields>

        <fields>ConvertedClicks</fields>

        <fields>Ctr</fields>

        <fields>KeywordTextMatchingQuery</fields>

        <fields>CustomerDescriptiveName</fields>

        <fields>AccountDescriptiveName</fields>

        <fields>PrimaryCompanyName</fields>

        <fields>Query</fields>

        <predicates>

            <field>KeywordTextMatchingQuery</field>

            <operator>EQUALS</operator>

            <values>+truck +accident +lawyer</values>

        </predicates>

    </selector>

    <reportName>informe</reportName>

    <reportType>SEARCH_QUERY_PERFORMANCE_REPORT</reportType>

    <dateRangeType>TODAY</dateRangeType>

    <downloadFormat>XML</downloadFormat>

</reportDefinition>

<?xml version='1.0' encoding='UTF-8' standalone='yes' ?>

<report>

    <report-name name='informe' />

    <date-range date='Jan 28, 2016' />

    <table>

        <columns>

            <column name='adGroupID' display='Ad group ID' />

            <column name='campaign' display='Campaign' />

            <column name='campaignID' display='Campaign ID' />

            <column name='adGroup' display='Ad group' />

            <column name='adGroupState' display='Ad group state' />

            <column name='avgPosition' display='Avg. position' />

            <column name='impressions' display='Impressions' />

            <column name='clicks' display='Clicks' />

            <column name='keywordID' display='Keyword ID' />

            <column name='avgCPC' display='Avg. CPC' />

            <column name='cost' display='Cost' />

            <column name='convertedClicks' display='Converted clicks' />

            <column name='ctr' display='CTR' />

            <column name='keyword' display='Keyword' />

            <column name='clientName' display='Client name' />

            <column name='account' display='Account' />

            <column name='companyName' display='Company name' />

            <column name='searchTerm' display='Search term' />

        </columns>

    </table>

</report>

El jueves, 28 de enero de 2016, 15:18:14 (UTC-6), jona...@garagecoders.net escribió:

Hi I'm trying to get the search query report of an specific keyword, but I have a problem because 

when I sent the the keyword I compare the KeywordTextMatchingQuery with the keyword, this is fine 

for any keyword that does not contain the "+" sign before, because with this special keywords that contains

the "+" sign the search query report is not returning data.

Do I need to use another Report ? 

Thanks

 

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
 
You received this message because you are subscribed to the Google
Groups "AdWords API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to the Google Groups "AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscribe@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/46dc0874-ba8f-444c-9d7f-793a0ea64ac3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.