I'm trying to pull together a report of the number of visits over the last six months to each of the websites we have created. We have two analytics accounts that contain all the profiles and from the dashboard I can see the number of visits for the last 30 days but to get the monthly figures for Jan-June this year invloves opening each profile, setting the custom date range and exporting the figures.
There are 75+ profiles to look at so was wondering if I was missing a trick here or whether it has to be done manually (or via the API which I don't understand..)
Not aware of any trick from the interface. API would be perfect for such a task, however you could get away with using [code.google.com...]
Authenticate, then specify ga:year as your dimension, ga:visits (sessions) or ga:visitors as your metric, specify your date range and hit Get Data. You can switch between profiles without losing the other selections.
Thanks for your reply. That is a really useful tool. I've managed to change the metrics and get it to produce the results I want to see. I can't seem to get it to accept multiple ID's but it is a much quicker solution for what I need.
If anyone knows how to enter multiple ids (may just not be possible) then please let me know but many thanks for your help
Not a problem. As far as I'm aware, you can't enter multiple IDs due to the way queries are made through the data export api. You can (semi)automate the reporting process by creating a query for each id in a list and collate the output. However, you will most likely need storage for the query data due to the time it'll take to go through 30 ids.
For php I recommend [code.google.com...] . You can find the whole list of libraries/helpers here (http://code.google.com/apis/analytics/docs/gdata/gdataLibraries.html ).