Hi Thanet,
another request confirmed my confusion and my assumption that CategoryL5
behaves as a segment in this case.
When I do the same request without requestion the CategoryLX fields, I get
just one result with the OfferId.
SELECT OfferId, AdGroupId, AdGroupStatus, AdGroupName,
CampaignName, Brand, ProductCondition, ProductTypeL1,
ProductTypeL2, ProductTypeL3, ProductTypeL4,
ProductTypeL5, CustomAttribute0, CustomAttribute1,
CustomAttribute2, CustomAttribute3, CustomAttribute4,
Channel, ChannelExclusivity, SearchClickShare,
SearchImpressionShare, Ctr, Clicks, Impressions,
Cost, ConversionValue, ConversionRate, Conversions,
AverageCpc FROM SHOPPING_PERFORMANCE_REPORT WHERE CampaignStatus IN
[ENABLED] AND AdGroupStatus IN [ENABLED] AND ConversionValue > 0 AND Cost >
0 AND OfferId = 12044542
-> 1 Result with OfferId 12044542
SELECT OfferId, AdGroupId, AdGroupStatus, AdGroupName,
CampaignName, Brand, ProductCondition, ProductTypeL1,
ProductTypeL2, ProductTypeL3, ProductTypeL4,
ProductTypeL5, CustomAttribute0, CustomAttribute1,
CustomAttribute2, CustomAttribute3, CustomAttribute4,
CategoryL1, CategoryL2, CategoryL3, CategoryL4,
CategoryL5, Channel, ChannelExclusivity,
SearchClickShare, SearchImpressionShare, Ctr, Clicks,
Impressions, Cost, ConversionValue, ConversionRate,
Conversions, AverageCpc FROM SHOPPING_PERFORMANCE_REPORT WHERE
CampaignStatus IN [ENABLED] AND AdGroupStatus IN [ENABLED] AND
ConversionValue > 0 AND Cost > 0 AND OfferId = 12044542
-> 2 Results with OfferId 12044542 TWICE -> differing only on CategoryL5
Cheers
Marc
On Thursday, March 30, 2017 at 6:06:33 PM UTC+2, Thanet Knack Praneenararat
(AdWords API Team) wrote:
>
> Hi Marc,
>
> It's true that they're not the segment field, but it's a *key* column in
> this report type.
> The key columns are what you need to include in order to tell the
> uniqueness of the report row.
> For instance, if you look at either only *AdGroupName*, *CampaignName* in
> this report type, you can't distinguish two rows from each other.
> But if you have a look at *OfferId* and *CategoryL5*, you can tell that
> those two rows are different.
>
> Put it in another way, they're an attribute field *that even when you've
> not requested them, they're still requested implicitly.*
> You can't combine those rows that have at least one *key field* different
> from each other.
> Not requesting them in AWQL / report definition just makes the reporting
> service not return them with the results.
>
> This is different from segment fields. If you don't request them, they're
> not requested implicitly.
> Once you request them, you're likely to get more report rows than usual.
>
> Hope this help.
>
> Thanet, AdWords API Team
>
> On Thursday, March 30, 2017 at 10:40:27 PM UTC+9, Marc P wrote:
>>
>> Hi Thanet,
>>
>> yes, in this case it is CategoryL5 - for another customer id it is
>> ProductTypeL3.
>>
>> My point is: both ProductTypeL3 and CategoryL5 are attributes as
>> specified in
>> https://developers.google.com/adwords/api/docs/appendix/reports/shopping-performance-report
>>
>> They are not Segments.
>>
>> So my understanding is that they should not split the data. Rather I
>> would assume to get just one result with ProductTypeL3 and CategoryL5
>> having the most recent attribute value ?
>>
>> Thank you for your help
>> Marc
>>
>> On Thursday, March 30, 2017 at 8:56:22 AM UTC+2, Thanet Knack
>> Praneenararat (AdWords API Team) wrote:
>>>
>>> Hello,
>>>
>>> It seems what makes your returned rows look duplicate is not
>>> *ProductTypeL3*, but the *CategoryL5*.
>>> As *CategoryL5 *is also the main key of SHOPPING_PERFORMANCE_REPORT,
>>> this works as intended.
>>> In other words, to tell the uniqueness of a row in this report type,
>>> *CategoryL5* should be taken into account as well.
>>>
>>> Cheers,
>>> Thanet, AdWords API Team
>>>
>>> On Tuesday, March 14, 2017 at 10:04:37 PM UTC+9, Firma Lemundo wrote:
>>>>
>>>> Hi everyone,
>>>>
>>>> I am facing the following issue:
>>>>
>>>> I am using the SHOPPING_PERFORMANCE_REPORT to find the performance by
>>>> the products (OfferId).
>>>> I am not using Date or other segments and the product is only in a
>>>> single adgroup.
>>>>
>>>> However, I still get two entries, because the product's ProductTypeL3
>>>> <https://developers.google.com/adwords/api/docs/appendix/reports/shopping-performance-report#producttypel3>
>>>> changed
>>>> in the time frame.
>>>>
>>>> So I get different data for the same product (which is in different
>>>> time frames) which is very annoying for my purpose.
>>>>
>>>> Moreover, ProductTypeL3 is not a segment field, so I wonder if this is
>>>> a bug, or expected behavior?
>>>>
>>>> Comments and help much appreciated :)
>>>>
>>>
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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+unsubscr...@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+unsubscr...@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/0d928a33-f5e2-4dab-9404-5c02c3de302f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
