me and my big mouth...
 

Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop

[Closed] me and my big mouth, Google Analytics and excel

8 Posts
7 Users
0 Reactions
77 Views
 mrmo
Posts: 10708
Free Member
Topic starter
 

Started new job on Monday, mentioned today that i had done some work automating Google analytics and Excel 2007 to produce reports in a previous job. Response was along the lines oh didn't know you could do that, that would save some time... as your the only person with any knowledge could you sort something out...

So, new company is using Excel 2010, is there a solution? and what would be the best starting point. At this point i am looking at web traffic figures, and am happy playing with some VBA, just need some pointers.


 
Posted : 15/06/2011 6:52 pm
Posts: 91095
Free Member
 

So did you lie about having done it before?


 
Posted : 15/06/2011 6:57 pm
Posts: 50252
Free Member
 

Nothing to see here....

😉

*Cheeky edit*


 
Posted : 15/06/2011 6:59 pm
Posts: 401
Free Member
 

If you read his post, he did it in 2007 previously and is asking about 2010.


 
Posted : 15/06/2011 7:10 pm
Posts: 45665
Free Member
 

Can you not use Google's own analytics tools - I spit out a report to my bosses each month by email, but it is all automated from the site with a custom report.


 
Posted : 15/06/2011 7:15 pm
Posts: 2758
Full Member
 

just make some shit up....they'll never know 😀


 
Posted : 15/06/2011 7:20 pm
 mrmo
Posts: 10708
Free Member
Topic starter
 

i didn't mention it in the interview as was of no relevance, the job was excel and cognos, just having a chat with my manager today and i mentioned that one of marketing reports could be done another way.


 
Posted : 15/06/2011 7:24 pm
Posts: 0
Free Member
 

See, this is what happens when you give it 110%.


 
Posted : 15/06/2011 7:26 pm
 mrmo
Posts: 10708
Free Member
Topic starter
 

well i managed to find the code i used in the last job, which worked then, tried it at work and it didn't, then installed a demo of Office 2010 on home computer and it did work???? So a little confused.

I might have to speak to IT in case they have blocked something???


 
Posted : 16/06/2011 8:02 pm