From the course: Excel: Market Research Strategies
Unlock the full course today
Join today to access over 22,700 courses taught by industry experts or purchase this course individually.
Cost-per-click and customer value - Microsoft Excel Tutorial
From the course: Excel: Market Research Strategies
Cost-per-click and customer value
- [Instructor] Perhaps the most important tool in all of marketing today is Google. We all know that the Internet has exploded in popularity and the reality is that more and more advertising is being done through the Internet and Google is one of the seminal tools to do that. So I'm here at the Google Ads site. Now the nice thing about Google Ads is that it gives us a real quantitative look at how our advertising spend is doing and the results that come out of it. So I'm here on the overview page for our Google Ads campaign, and we're just looking at a sample campaign for a firm that I helped set one up for. But what I want to do is kind of drill down a little bit more by looking at keywords. We could look at some of the different metrics here as an example. So different ad groups, new product development. They had a cost of $2,408 for this particular campaign. They had 2,400 clicks with a click through rate of 2.15%.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.