TL; DR: Using the Google Analytics API add-on for Google Sheets and this template, easily compare two time periods and find trends or percentage increases/decreases. This post was updated 11/29/15 with drop down menus for all input fields (except filter selection) . How much time do you spend each week analyzing trends in Google Analytics? Each month? Or maybe you spend more time exporting data from Google Analytics to Excel for analysis Uncle.
Sam This is the second article in a series on Google Sheet GA API integration. If you're unfamiliar, I suggest you head over to Kevin Rutter's post - Automation Innovation: A Beginner's Guide to Google Sheets GA API Integration. In this article, I'm employee email list going to introduce you to a resource I created for the purpose of quickly analyzing week after week (or month after month, or year after year, etc.) the percentage increase or decrease of two metrics and of one dimension. If you're hungry for something more complex, stay tuned for the next article.
in this series. This next article will cover a resource that will automatically create a pivot table with up to 7 dimensions and 10 metrics over two time periods! The table maker I created this resource with the goal of making this repetitive and mundane task as intuitive and easy as possible. To get started, click here to open the template, then File > Make Copy... This will allow you to make changes to the sheet. Also, be sure to use a Google ID that has access to the Google Analytics views you'll be querying. (This can be done later by granting access to that user and then opening it with that user.)Now that you have your very own Table Maker, let's dig in! To facilitate this process, I have provided an interface