Eric,
I downloaded your code and this is definitely a good start. I'd like
to throw a couple of ideas out there, not only as feedback for you,
but also for the community in general.
First, I would strongly suggest you create an Open Source Google Code
project and put the code in there. I believe there are a lot of
people, such as myself, who are interested in this project.
Second, have you investigated the possibility of using the Google
Account Authentication API to log into Google? I'm not sure if that's
even possible (yet) in this case, but it may be worth looking at.
Ideally, that would definitely be the way to do this if Google has
extended the Analytics interface to allow for it. I can't imagine
that it would be that difficult for Google to provide for this - it's
probably just a matter of having the time to do it and how big of a
priority that it is for them.
Lastly, I'm not sure the approach of putting each report into its own
table is the way to go. I'm looking at the code now and may have an
alternative way of storing that data shortly.
Overall, it's not a bad piece of code to use as a starting point.
Let's get this into an open source project and get more people working
on it.
Thanks,
Scott
On Sep 24, 12:43 pm, Er1c wrote:
> I just released a first version of a Visual Studio C# project to
> download data from Google Analytics & import it into SQL Server - I'd
> love any early adopter feedback - or if anyone wants to contribute
> some code to import into other DBs/etc.
> Check it out & let me know if you end up using it!
> http://blog.secondspace.com/google-analytics-data-extractor/
> -Eric
