How To Import Google Analytics Data Into Google Sheets

in /by

If you’re like us sometimes you just want to play around with your data a bit more than Google Analytics provides. Maybe you want a different type of chart or simply want to combine your data with some other source. While Google Data Studio is a super useful tool for this type of task, there can be a learning curve in order to get the exact type of data you seek. Enter the Google Analytics Add on for Google Sheets.

What can you do with this data?

If there’s data in your GA account you can pull it into Google Sheets with this plugin. Dates, goals, users, sessions; it’s all there for the taking. What we like to do with this plugin is to leverage this data to create better dashboards than what GA provides as the Sheets plugin allows you to schedule this data to be pulled automatically and thus you can send your team a link that they can access at any time to see fresh data in the format you wish. While the Sheets charts have a long way to go in order to be as useful as Excel, there is still plenty of visualization options at your fingertips.

Take a look at Google’s documentation and tutorial to see what is possible. Then, start putting questions on a white board that your Google Analytics data can provide answers to. Once you know what you’re asking from your data you can begin to query the vast Google Analytics API easily using the Dimensions & Metrics Explorer. As you click on different dimensions or metrics others will gray out if no correlations are available. This Add on is a simple way to start seeing your data in a whole new light and providing better visual insight into new opportunities!

How to Leverage Zero Based Budgeting in Digital Marketing

in , /by

As a myriad of items swirl around the economy these days and idea is beginning to surface in many company boardrooms. Zero Based Budgeting is essentially the review of budgeting line items to ensure viability and efficiency. There’s obviously more to it than that and you can read a great article from McKinsey about the 5th myths of zero-based budgeting to learn more. However, for our intent and purpose we want to leverage this methodology to ensure you’re thinking through your digital marketing expenditures. We’ve written a lot of about budgeting recently and the reasoning is that as we approach the end of the year it is imperative that the budgets you create for 2019 are accurate and viable.

How to Apply Zero-Based Budgeting to Digital Marketing

What is your goal? We ask that a lot, I know. But it is a fundamental question that often is never fully fleshed out. Zero-Based Budgeting forces organizations to think through their goals and revenue targets so that each dollar that goes out is accounted for. It all starts with the organization understanding and agreeing on specific targets, then each department is forced to be accountable to those targets. So to begin, ensure that you understand the revenue goals set by the executive leadership. Secondly, work backwards from your revenue goals (ensuring margin is calculated) by estimating conversion rates and click through rates to determine your overall cost threshold. Lastly, track to these goals by evaluating your return on ad spend on a week-to-week basis. If you’re not on target then evaluate which tactics are throwing things off course. Is it Pay Per Click Advertising? Perhaps it’s particular keywords driving up your cost? Knowing your revenue targets and budgeting to them is job number one as marketers and can ensure that you become a leading voice in the zero-based budgeting game!

Digital Strategists & Zero-Based Budgeting

As any digital strategist worth their salt will tell you, we’ve been doing this for years. The ability to track costs and follow that through to conversion is the cornerstone to any digital marketing plan. More importantly, digital marketers have always had a clear understanding of the full conversion funnel and ensuring that each step along the way is tracked. This gives us a unique opportunity to become leaders within a zero-based budgeting organization and ensure the entire organization accounts for each and every dollar that goes out the door!