Basic report for many clients

[Mike Young]

How do I use a basic report for many clients. (Cost, Conversions, Impressions etc)

I have 1 MCC with 30 clients (all different IDs)

I would usually add the clientID in auth.ini , but as it changes have wrote a script with a counter that each time the API is run using a scheduled task (every 1 minute) the clientID changes, and increments to the next.
I have a file that contains all the client ID's and can add as many as I want.
This works.

PROBLEM
Each client only gets updated every 30 minutes due to there being 30 clients. (one every min)
How can I run all clients every 10 minutes at the same time?

I'm using PHP coding.
I have read all the documentation for Adwords, but cant find anything to support this answer.





 

[Jeremy Aube]

You can run each client in a separate thread rather than sequentially. You may not be able to run all 30 at once as there are limits to the number of simultaneous requests, but I believe you can do 10 or so at the same time this way.

[Mike Young]

By a separate thread, are you meaning a copy of the whole google adwords folder as it contains only one clientID in the auth.ini file. The whole folder download is 29mb. I cant replicate this 30 times. I do not want to produce spaghetti coding.

Surely you have a procedure that gets all the campaigns in the MCC then runs these to get the stats and downloads it.

Is this too much?

Seems very long winded to me....

What I would like to do is

1. Run a basic stats report for 30 clients

2. This report must have Todays and Yesterdays stats. (conversions, cost,cpc ect)

3. Be able to import the data into a database.

You don't seem to have the most basic examples anywhere?

Adwords scripts was easy to do....but you have reduced the amount we can now send out each day.......

Please help!

[Jeremy Aube]

http://stackoverflow.com/questions/70855/how-can-one-use-multi-threading-in-php-applications

[Mike Young]

Ok, if I run the same page in 10 threads (running it 10 times) it will still pick up the same clientID in the auth.ini file (123-456-7890)

How do I get it to change and use the rest of the client IDs that I need?

[Jeremy Aube]

There should be a way for you to specify the client id for each request. I'm not very familiar with the PHP library, so I can't help in terms of actual implementation, but that's how it typically works for other libraries.

[Ray Tsang (AdWords API Team)]

Mike,

You could potentially run it in a batched fashion from the command line, and launching multiple processes with each process grabbing data for a different client customer ID.

That being said, if serial execution is too slow, I feel your best option is to execute in parallel.  Implementation really depends on your platform and your use case.

There is an open source project called aw-reporting that does similar to what you need.

Thanks,

--

Ray Tsang (AdWords API Advisor)