Conversions where clause not working in PRODUCT_PARTITION_REPORT

34 views
Skip to first unread message

mubbashar husain

unread,
Apr 1, 2017, 12:05:54 AM4/1/17
to AdWords API Forum
Hi Guys,


SELECT ProductGroup,CampaignName,AdGroupName,CampaignId,AdGroupId,Id,SearchImpressionShare,Impressions,Clicks,Ctr,AverageCpc,Cost,Conversions,CostPerConversion,ConversionRate,ConversionValue,CpcBid FROM PRODUCT_PARTITION_REPORT   where Conversions > 2 and Clicks > 10 and  CpcBid  > 0   and  AdGroupStatus  = ENABLED   and  CampaignStatus  = ENABLED   DURING 20170301,20170330

the conversions filter in where is not working and affecting all my clients. The adwords api just ignoring the conversion where clause. Please help ASAP. 
It start doing this from today. Urgent help needed

thanks!
Message has been deleted

Peter Oliquino

unread,
Apr 2, 2017, 10:59:51 PM4/2/17
to AdWords API Forum
Hi Mubbashar,

For your first concern, could you provide me you clientCustomerId and any report file generated using your query so I can have a better look?

For your second concern, upon seeing your request, you may be passing "null" values that is possibly causing the INVALID_BID errors :

         'biddingStrategyId' => NULL,
'biddingStrategyName' => NULL,
'biddingStrategyType' => NULL,
'biddingStrategySource' => NULL,
'biddingScheme' => NULL,

You may refer to our bidding strategy guide for more information on how to setup your bids. If the issue persists, could you provide the complete SOAP request and response (in XML format if possible) so I can further investigate? If you have not enabled your SOAP logs, you may refer to this guide as to how.

Please reply via Reply privately to author.

Thanks and regards,
Peter
AdWords API Team
Reply all
Reply to author
Forward
0 new messages