PRODUCT_PARTITION_REPORT Running very slowly (several minutes)

[AdWordsApiUser]

Hi,

We're seeing this report running really slowly for a few accounts (10s of minutes to get a response):

SELECT CampaignId, AdGroupId, Id, AdGroupName, Impressions, Clicks, Cost, CpcBid, Conversions, ConversionValue, SearchImpressionShare, BenchmarkAverageMaxCpc, BenchmarkCtr, ProductGroup FROM PRODUCT_PARTITION_REPORT WHERE IsNegative=FALSE AND CampaignStatus=ENABLED AND AdGroupStatus=ENABLED AND CpcBid > 0  DURING LAST_30_DAYS

I can privately send the account ids if required.

Thanks,
MG

[Shwetha Vastrad (AdWords API Team)]

Hi MG,

Could you send over the IDs of the accounts where you face this issue? Could you also provide the client library you use along with the report download logs if available? Please use Reply privately to author when responding.

Thanks,

Shwetha, AdWords API Team.

[AdWordsApiUser]

Thanks! Just sent the details.

MG

[Shwetha Vastrad (AdWords API Team)]

Hi Mg, 

This account has quite a few Shopping campaigns. The report download request may time out on extremely large data sets. Could you include predicates to retrieve the product partition from a few campaigns and retry the request and let me know if it works?