An AdWords Agency – 2013 – October
SMS logo - impossible letter initials within decision box SMS logo - impossible letter font, initials within decision box

An AdWords Agency

Systems & Marketing Solutions


Because Next is Now

Archive for October, 2013

SEO’s Best Friend! – AdWords

Posted by Bob Dumouchel in adwords expert

Tuesday, October 8th, 2013

accountant-with-abaccasSEO’s are often highly critical of AdWords which amazes me because of the value AdWords can bring to their challenge. Without AdWords, a business is forced to rely on Google Analytics and Webmaster Tools for data, but both suffer from lack of data. Let’s look at how AdWords can make you a better SEO.

The nature of the data in Analytics is that it tells you about traffic coming into your site not the potential of what it could have been.  AdWords data on the other hand can tell you the potential of the keyword and with that you can make better decisions about your keyword target.  AdWords represents a way to value SEO efforts making better business decisions possible, let’s explore how to do that.

In a broad sense, your AdWords data represents what you think the keywords are worth and how much volume is possible. To get at this data you need to consider:

  • Quality Score
  • Cost Per Click (CPC)
  • Impressions
  • Impression Share

Quality score is a very close cousin to the SEO score and when you have a quality score problem with a keyword it is very likely that you have a related SEO score problem. The cost per click is a real world market valuation of that keyword and its traffic. Impressions give you the volume of searches for that keyword and the impression share allows you to adjust the impressions to the full volume of the keyword.

To bring focus to your SEO efforts start by calculating opportunity value of the keyword. Download your keywords into a spreadsheet and add a column for Opportunity Value. Here is the formula:

=(2-G1)*C1*E1*(10-F1)

Sample Data

 

A

B

C

D

 E

 F

G

H

 

Bid

Clicks

Impressions

CTR

 Avg

CPC

 Quality Score

Impression

Share

Opp Value

1

3.26

1063

37337

2.85%

$2.20

4.0

53.06%

724,191

2

2.51

5197

88304

5.89%

$1.19

5.0

99.43%

528,404

3

3.26

459

13167

3.49%

$2.21

4.0

56.11%

251,224

4

5.01

84

8112

1.04%

$4.01

3.0

94.85%

239,431

5

2.76

156

4220

3.70%

$3.79

2.0

92.75%

137,227

6

0.39

492

15845

3.11%

 $1.02

5.0

45.94%

124,495

7

3.01

1033

17101

6.04%

$1.71

6.0

98.66%

118,538

8

0.33

405

12209

3.32%

$0.99

5.0

30.18%

102,630

9

3.01

547

14232

3.84%

$1.37

5.0

97.89%

99,546

 

This is the formula in Excel format with the data sample trimmed to the data we need. We have excluded the keyword to protect the client’s information. If you leave keyword or other data in the spreadsheet you will need to update the cells in the formula.

This formula takes the impressions (C1) and increases them by the impression share (G1) that was not purchased. In the case of the first line it took 37,337 impressions and increased that by 46.94% (100%-53.06%). This is the estimate total impressions for the keyword which we multiply by the cost per click (E1). Then finally we adjust this by taking 10 which is the maximum quality score minus the keyword’s quality score (F2) giving us a factor of how much it could improve. This gives us the opportunity score and because it is a score the actual value is not important but the relative value is! For the formula to work properly convert percentages to decimals (53.06% = .5306).

This gives us a keyword list in opportunity order so we know what we want to target in our SEO strategy and it does not hurt us to look at this in AdWords. In AdWords this is useful because we can often improve the quality score by isolating these high value keywords into their own ad group allowing us to write a more relevant ad for that keyword.

This process gives us the most valuable keywords for the account based on value and opportunity. This list should be where the SEO starts in creating highly optimized pages of these specific keywords. On the AdWords side of things the new content from the SEO is an opportunity to improve our quality score since the landing page is a part of that score.

The reason we use CPC rather than Bid in this formula is because the bid is what you are willing to pay, but the CPC is what the market is making you pay.

There are lots of things that can go wrong with this calculation and a poorly tuned AdWords account is the source of most of that. If you use the opportunity score to drive your AdWords and SEO optimization efforts you should find ways to improve things on both sides of the SERP (Search Engine Results Page).

The process here is not as simple as this one article but this should help give you focus on both sides. There are many, including myself, that question the accuracy of impression share but it is much better than no data at all.

 

Systems & Marketing Solutions Moved!

Posted by Dana in adwords expert

Tuesday, October 8th, 2013

After 9 years in our old office Systems & Marketing Solutions moved to a new office in the same complex. We still have great neighbors like Stacked Sandwiches and ManRock Brewery but we have a cooler office out of the traffic flow. To do the heavy lifting we called our friends over at Meathead Movers to move the big stuff across the parking lot for us. In true Meathead fashion the guys ran back and forth between offices when not carrying something heavy. They were so fast I almost missed them in the picture!Meathead Movers running in between our old office and the new one.

Mathew Duhon from Digital Foundation, Matthew Duhon of Digital Foundation working on the wiring.our network support firm came to take care of the technical stuff which made the move smooth as glass. We started moving at 1pm and by 5pm everything was up and running and at least roughed into place.

As with any plan there are always challenges and in our case that came from our ISP, Charter Communications. While the move seemed simple to us, it was not for Charter. First is they had to run new service to the building and they informed us ten minutes before our scheduled move that they would be there in three days. After some colorful conversation they came out that day and put some temporary wiring in place and then returned in about two weeks to finish the installation. From our perspective, their paperwork seemed at times to be more important than our Internet and Phone service but our hats are off to the technician because he made everything work and we never had any major outage.

We were asked to move by our neighbors’ at ManRock Brewery because they wanted to expand their operation but last minute details prevented that from happening. Because we had already signed leases and done lease hold improvements in the new office we went forward and our old office is now for rent.

SMS new officeWe really enjoy the new office and it is a definite upgrade for us. It is more spacious with 12 foot ceilings and no walls making the space more flexible. The office also has a 12 foot by 12 foot window and great lighting making for a much better office environment with lots of natural light. We live in a beautiful place so the outside view for everyone is wonderful.Office-1

The move also allowed us to do several upgrades that we have been putting off including cleaning up the wiring and going to wireless on many of our systems. Gone now are all the wires to keyboards and mice and the required wiring is now all cleanly put away and wired though the desks. It is nice to purge all the junk that seems to accumulate in a busy office over time.SMS new office

In closing the move went close to plan and without any real major problems and we love the new office even if the reason for our move vanished.