Automated Email and Google Spreadsheet Reporting with the Results API [a step-by-step guide]
Hey fellow optimizers,
I am really enjoing this community of like-minded folks. I just wanted to share something I put together with Google Apps Script, Google Spreadsheets and Optimizely Results API to automatically report the status of active experiments. Please have a look at the post and give it a try. I would love to hear how it works out for you and any improvement opportunities!
This is great, Trevor. Thanks for sharing!
Optimizely, Inc. 415.409.9169
Tried it out and it works like a charm. Thanks for posting this, Trevor!
I've been looking to do this and came across your step-by-step guide when searching this topic and then also found it here on Optiverse. I know that the Optimizely interface changed since your wrote this and now I'm having trouble figuring out where to go to email reports (Step 2). Any idea on where I need to go to do this now?
I could be wrong here, and I'll let @tFox confirm, but I believe the "email reports" from Step 2 is actually within the spreadsheet he linked to. Once you populate your API token in the spreadsheet, you'll see a tab at the top called "Optimizely Reports." The last option in the dropdown is "email reports". See the attached image below for reference.
Just got the following message trying to generate an email report:
"The Optimizely API returned status code 410. Check your API key."
I just tested with my own key on a copy of of the spreadsheet as described here (http://www.swellpath.com/2014/10/optimizely-report-automation/) and it successfully worked for me.
I would also encourage you to ensure you don't have any extra spaces in there by accident.
Can you let me know if you are able to get this working or if you continue to have issues?
Thanks for the awesome tool! Is there a way to get this to extract the results from all of my projects instead of just one?
Hi everyone! @corneliusdo modified this spreadsheet and iterated on it to make it better. Check it out: https://community.optimizely.com/t5/Using-Optimizely/Automate-data-collection-for-experiments-Feedba...