Can get AdW data from multiple clientcustomerids in single request - SHOPPING_PERFORMANCE_REPORT

[Bala Murugan]

Hi

We have MCC and Sub MCC accounts and lot of client accounts under it. Need to get traffic data from 2 accounts which is in a sub-mcc. through single AWQL query using IN operator. 

Getting single account traffic only. bcaz creating session with one client-customer-id.

Can you please suggest any possibility for this to create session for sub-mcc account and get traffic data from more than one client-customer-ids?

SELECT OfferId, Impressions, Clicks, Cost, ConversionValue,  Conversions, AverageCpc, Ctr, ConversionRate, Brand, Date,  SearchImpressionShare, SearchClickShare, AllConversions  FROM SHOPPING_PERFORMANCE_REPORT WHERE ExternalCustomerId IN [Client-ID-1, Client-ID-2]  DURING From-Date, To-Date

create session builder like this

 $oAuth2Credential = (new OAuth2TokenBuilder())

            ->fromFile()

            ->build();

        

        $session = (new AdWordsSessionBuilder())

            ->fromFile()

            ->withOAuth2Credential($oAuth2Credential)

   ->withClientCustomerId( [CLIENT_CUST_ID]            

            ->build();

[Google Ads API Forum Advisor Prod]

Hello Bala,

It is not possible to create session with more than 1 client customer id and to get data on both the accounts in a single query.

Regards,
Sai Teja, Google Ads API Team

ref:_00D1U1174p._5001UCZMTs:ref