Search query Report

[jona...@garagecoders.net]

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

 

[Yin Niu]

Hello, 

Could you send your query and the keyword that is having issue? 

Thanks,

Yin, AdWords API Team. 

[jona...@garagecoders.net]

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

[Josh Radcliff (AdWords API Team)]

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

[jona...@garagecoders.net]

Yeah but the problem is that SEARCH_QUERY_REPORT not allows to filter by keywordID (keywordID it's not filterable ), that is why i use the  KeywordTextMatchingQuery.

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

[Josh Radcliff (AdWords API Team)]

Hi,

Could you describe what you are trying to achieve, e.g., why you are using the SEARCH_QUERY_PERFORMANCE_REPORT instead of the KEYWORDS_PERFORMANCE_REPORT?

Thanks,

Josh, AdWords API Team

[jona...@garagecoders.net]

Hi, I'm trying to get the search query report of a specific keyword.

First I consume the KEYWORD_PERFORMANCE_REPORT, after is the user select an specific keyword

I show the SEARCH_QUERY_REPORT data of that specific keyword, as I said I compare the "KeywordTextMatchingQuery"

with the keyword selected but this it's not working with the keywords that contains the + sign.

Also in SEARCH_QUERY_REPORT I can´t use the keywordID, because this field it's not filterable.

Thanks and sorry for not describe this before.

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

[Josh Radcliff (AdWords API Team)]

Hi,

Thanks for clarifying. In that case, since KeywordId is not filterable on the Search Query report, I think your only option is to run that report with whatever other filters you can (e.g., you could filter by the AdGroupId to limit to only keywords in the selected keyword's ad group), and then process the results on your side, pulling out only the rows where KeywordId matches the selected keyword.

Cheers,

Josh, AdWords API Team