Hi,
Is there any way I can get a report having only one row for each keyword I have noticed that when I download the keywordperformance report, some keywords are repeating for the same campaign and AdGroup.
ex:
Code Snippet
<Table><AccountId>xxxx</AccountId>
<CampaignId>xxx</CampaignId>
<OrderId>xxxx</OrderId>
<OrderItemId>xxxx</OrderItemId>
<AdId>xxxxx</AdId>
<AccountName>xxxxx</AccountName>
<CampaignName>Campaign1</CampaignName>
<Keyword>Apple</Keyword>
<DestinationURL>xxxx</DestinationURL>
<KeywordOrderName>Order1</KeywordOrderName>
<MatchTypeDesc>Phrase</MatchTypeDesc>
<Impressions>1</Impressions>
<Clicks>0</Clicks>
<CTR>0</CTR>
<AvgCPC>0</AvgCPC>
<TotalCost>0</TotalCost>
<AvgPosition>21</AvgPosition>
<ConversionRate xsi:nil="true" />
<Conversions>0</Conversions>
<CostPerConversion xsi:nil="true" />
</Table>
- <Table>
<AccountId>xxxxx</AccountId>
<CampaignId>xxxxx</CampaignId>
<OrderId>xxxx</OrderId>
<OrderItemId>xxxx</OrderItemId>
<AdId>xxxx</AdId>
<AccountName>xxxx</AccountName>
<CampaignName>Campaign1</CampaignName>
<Keyword>Apple</Keyword>
<DestinationURL>xxxx</DestinationURL>
<KeywordOrderName>Order1</KeywordOrderName>
<MatchTypeDesc>Phrase</MatchTypeDesc>
<Impressions>2</Impressions>
<Clicks>0</Clicks>
<CTR>0</CTR>
<AvgCPC>0</AvgCPC>
<TotalCost>0</TotalCost>
<AvgPosition>21.5</AvgPosition>
<ConversionRate xsi:nil="true" />
<Conversions>0</Conversions>
<CostPerConversion xsi:nil="true" />
</Table>
In the above example both keywords and its match type are same. Here Impression and avg position are different. Is that the reason I'm getting the same keyword in 2 rows
Is there any way I can get the above as one row rather than 2 rows
If a keyword does not have any impression can I get that keyword also in the report
Thanks