Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unbelievably slow, trying to get customer ids and customer info #503

Open
kingmeers opened this issue Sep 18, 2024 · 2 comments
Open

Unbelievably slow, trying to get customer ids and customer info #503

kingmeers opened this issue Sep 18, 2024 · 2 comments

Comments

@kingmeers
Copy link

I believe this query is proving very slow

const customerListResponse = await googleAdsClient.listAccessibleCustomers(
      refreshToken
    );

And then, for each customer

const customerDetails = await customerService.query(`
            SELECT
              customer.id,
              customer.descriptive_name,
              customer.currency_code,
              customer.time_zone,
              customer.manager,
              customer.status
            FROM customer
`);

Is this expected since I chose so many fields? Or is there something wrong? For context, I am using the test api still, not basic or standard yet.

@visrut-at-handldigital
Copy link

Yes, it looks like the first query is slow, ended up switching to making calls using plain REST APIs instead and it's much faster.

v18: https://developers.google.com/google-ads/api/rest/reference/rest/v18/customers/listAccessibleCustomers

@kingmeers
Copy link
Author

Yes, it looks like the first query is slow, ended up switching to making calls using plain REST APIs instead and it's much faster.

v18: https://developers.google.com/google-ads/api/rest/reference/rest/v18/customers/listAccessibleCustomers

Thanks king will try this out 🙏

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants