Rich-text Reply

Automate data collection for experiments - Feedback!

corneliusdo 02-02-16

Automate data collection for experiments - Feedback!

[ Edited ]

A client wanted a fast way to grab all their experiment data so that they could build a dashboard in Google sheets and watch their numbers tick. I found this original verison, but it was inadequete, so here's version 2 (with blood, sweat and tears).

 

My aim was to cut down a day's worth of reporting/data collecting, make it run faster, print vlookup friendly data (yay!) and make life a tad smoother. 

 

Feedback welcome! 

Cornelius Do
Digital Channels @ CommBank
JDahlinANF 02-02-16
 

Re: Automate data collection for experiments - Feedback!

Excellent work!
If I used Optimizely's numbers for anything, this would be awesome!
corneliusdo 02-02-16
 

Re: Automate data collection for experiments - Feedback!

Cheers! Smiley LOL

Cornelius Do
Digital Channels @ CommBank
lorimcneill 02-03-16
 

Re: Automate data collection for experiments - Feedback!

[ Edited ]
 
corneliusdo 02-03-16
 

Re: Automate data collection for experiments - Feedback!

I sent you an email to sort this mess out! Smiley Very Happy

Cornelius Do
Digital Channels @ CommBank
lorimcneill 02-03-16
 

Re: Automate data collection for experiments - Feedback!

Thanks again.This is a lifesaver! =)
Tammy 02-10-16
 

Re: Automate data collection for experiments - Feedback!

It's really awesome!
you helped me a lot from reporting!
Now I actually got an error "TypeError: Cannot call method "getRange" of null." but still it's super helpful!
Thank you!!!!
Tamie
Level 6
corneliusdo 02-10-16
 

Re: Automate data collection for experiments - Feedback!

Hi Tammy, 

 

Glad you like it and thanks for the feedback! 

 

I'll have to try and reproduce the error on my end. Simply speaking, the error is occuring because the sheet is trying to copy something that's empty. Any more information you could provide would be a great help Smiley Very Happy

 

The most important question here is were you able to get a complete print out of your data? 

Cornelius Do
Digital Channels @ CommBank
Tammy 02-10-16
 

Re: Automate data collection for experiments - Feedback!

Hello corneliusdo,

 

I appreciate for your effort!

But no, I couldn't get my data on spread sheet.

 

Thank you,

Tammy

Tamie
Level 6
corneliusdo 02-10-16
 

Re: Automate data collection for experiments - Feedback!

Hey Tammy, 

 

Had a check through it and noticed that an addition I put in right before release was overlooked in QA! Smiley Sad

 

I tested it a few times on a personal account and it should be working correctly now. Make another copy of the original spreadsheet and give it a go. Make sure you try pulling your data more than once! 

 

Let me know if there are still any problems - happy to fix any issues. It was a personal project after all haha!

Cornelius Do
Digital Channels @ CommBank
Tammy 02-10-16
 

Re: Automate data collection for experiments - Feedback!

Hello corneliusdo,

 

I just tried and it worked perfectly!!!

Oh my goodness, it's super awesome!!

I deeply appreciate you so so much!!!!

 

Thank you!

Tamie

Tamie
Level 6
corneliusdo 02-11-16
 

Re: Automate data collection for experiments - Feedback!

Smiley LOL

 

Glad I could be of help!

 

Let me know through email or LinkedIn if anything else pops up (fastest way to get a reply out of me)! 

Cornelius Do
Digital Channels @ CommBank
Allison 02-15-16
 

Re: Automate data collection for experiments - Feedback!

[ Edited ]

This is so sweet. Thanks @corneliusdo!

Optimizely
corneliusdo 02-15-16
 

Re: Automate data collection for experiments - Feedback!

Thanks Allison! Means a lot to me Smiley Happy

 

Getting a tad more nervous as more people see it... the code isn't exactly "pretty" or "clean" haha

Cornelius Do
Digital Channels @ CommBank