Monthly Archives :

June 2015

Microsoft Excel: How to Count Number of Spaces in Cell String

388 321 rhecht

excel

B1: =LEN(A1)-LEN(SUBSTITUTE(A1,” “,””))

Notice the space there. You can replace that with any other letter to see how many instances of that character are present. It’s simple and genius.

Excel on Mac – How to Delete Contents of Multiple Cells

256 256 rhecht

excel_logo

fn+delete

Also, you can do control+B

I know, with Excel on Windows it’s easier 🙂

Kudos to ExcelJet for this gem.

10 Free OnePlus One Apps You Need Right Now

rhecht

Courtesy of oneplus.net

Without a doubt, the OnePlus One has taken over the world by storm. Based out of China, OnePlus devised an affordable, budget-friendly alternative to pricier smartphones, such as the iPhone, Samsung Galaxy and recently the Nexus, which doubled in price once the Nexus 6 came out. Even with its upcoming price increase it’s still competitively priced considering you are getting the phone unlocked.

All that having been said, as awesome as the phone is, there are always apps that can be purchased to enhance your phones’ experience. Here are ten of my favourites:

1. Camera: CameraNext Mod

One massive complaint the phone had was in the camera quality: it produces photos that are too grainy, especially in low lighting. Looking into it, I realized that the issue must be software-related since OnePlus took the camera hardware from Sony, making the hardware component top-rate.

I was looking for different alternatives. Of them, the best one was the Cyanogen-modded CameraNext app. The pics and videos there are among the clearest I’ve seen. Here are the links:

Why are there two different apps? Because, when you upgrade to CM12, Panorama crashes the CM11 version of the app. Why the links? Because the apps were fan-modded by pro developers and aren’t available on Google Play. I still prefer this app over to what’s commercially available at the Play store.

Honorable mention goes to Google Camera, though my issue with it is in the video where it seems to auto-focus in and out.

2. Recording: Titanium Recorder

My issue with the stock recorder was that it would only record a message for a minute, then stop once the phone went to sleep. Titanium Recorder continues playing after the phone sleeps, and produces excellent audio quality.

The App is available on Google Play.

3. Messaging: GoSMS Pro

I personally find the stock Messaging app to freeze and crash too often. Apparently it cannot process/handle the contacts and messages. Enter GoSMS Pro. It’s free, gives a choice of six colors, and works amazingly well.

The App is available on Google Play.

4. Messaging: WhatsApp

Need I say more?

The App is available on Google Play.

5. Battery Management: Qualcomm Snapdragon BatteryGuru

One issue with OnePlus, which also goes for all Android devices, is battery management. Battery management especially became an issue once the Cyanogen Mod 12 (CM12) came out. BatteryGuru saves some of that juice.

The App is available on Google Play.

6. Contacts

I personally use Contacts+ to import my contacts from GMail, Facebook, and iCloud. To backup your contacts into a CSV file, SuperBackup does the trick.

These Apps are available on Google Play.

7. Readers

For readers, there are:

a. Pocket, which lets you locally download any web page into your account for future access in areas where no wifi/data is accessible

b. Amazon Kindle, for those eBooks requiring Kindle reading (and where I can download my purchases)

c. Aldiko, for other eBooks

The Apps are available on Google Play.

8. Skype

To communicate with other users with video for free across Wifi, there’s still nothing better out there.

The App is available on Google Play.

9. Social Media

Facebook/Twitter/LinkedIN. Goes without saying.

The Apps are available on Google Play.

10. Coffee Shop Apps

I’m referring to Starbucks and Second Cup.

When you need a coffee and are in a bind without your card, you simply add your card number to an account that you tie in with an app on your phone. It simplifies the process greatly.

The Apps are available on Google Play.

 

Glad you enjoyed!

“Build A Law Site” – WordPress-Powered Websites for Lawyers in 24 Hours

rhecht

buildalawsite-logoIn today’s and age of the internet, it appears that everyone needs a strong online presence. Lawyers especially need that extra “oomph” when marketing themselves to clients, but not every lawyer shockingly has the financial means to afford a full-fledged website, which can easily run into the thousands of dollars depending on the desired features. Not only that, but building a website can take weeks, if not months, to build.

Enter “Build a Law Site.” Build a Law Site allows a lawyer to have a professionally built website built within 24 hours, utilizing the popular, easy-to-use WordPress Content Management System (CMS).

Build a Law Site offers a competitive package: starting at only $49 a month, a small-to-medium size lawyer (or a fresh out of school law student) can have his/her own professional, mobile-responsive website, which includes web hosting, for a mere fraction of the cost it would cost elsewhere. In short, it’s an amazing deal.

So, if you’re a lawyer looking for the best budget-friendly website money can buy, look no further. Sign up and build a law site today!

The Simple Link Building Technique Most SEOs Get Wrong

404 270 anon
backlinks-street-signWe found this article to be an eye-opener and therefore decided to re-post with credit. -RJH Solutions Staff
Ken Mcaffin discusses the simple link building techniques most SEOs get wrong and outlines the method using Scout that will give you some great ideas.

The more ways you can generate quality inbound links to your site, the better. Google has raised the bar and we all need to get the most from the link building work we do. ‘Broken Link Building’ is a white-hat technique that can really be done at scale. Yet it is a technique that is misunderstood and therefore many SEOs are not getting the results they could.

In this article I want to explain where many people go wrong in broken link building and outline a method that is likely to greatly improve results.
Broken Link Building as it is understood by many SEOs is a simple process. There are three steps:

  • Step 1: Find quality resource or links pages
  • Step 2: Check each page for broken links
  • Step 3: When you find a broken link, tell the webmaster and suggest a resource of your own to replace it.

Let’s work through this process step by step, and then look at how it can be radically improved.

Step 1: Find links or resources pages in your industry – these are sites that list a long list of resources. Suppose we were promoting a website on organic foods and had designed a content marketing campaign around a guide on the nutritional benefits of organic food.

In our campaign, we’d want to get links from resources lists – lots of them – like this one published by nutrition consultant, Nicole Meadow.

 

You can easily find such resources by doing a clever search on Google – like [nutrition inurl:links].

 

This search has returned over 500,000 results – of which you can see up to 1000 in Google results.

You can do the same type of search for your own sites. Start the search phrase with your keyword followed by inurl:links.
keyword inurl:links

This tells Google to return pages that are relevant to your keyword, and have the word ‘links’ in the URL.

So if you sold mountain bikes, you’d do this search:
mountain bikes inurl:links

Which would give you these results (with one of the resources pages inserted):

 

The links and resources pages such searches uncover can be extremely popular and attract a lot of links.

But sometimes, the links on the page can be broken – a reader clicks on one of the resources and gets a 404 page not found message. That’s bad news for the reader because they can’t find the resource that they’re interested in.

And it’s also bad news for the publisher because their readers are disappointed and therefore think less of the site.

So we’d be doing the webmaster a favor if we found such broken links and told them about it – and because we’ve done them a favor, they’ll be keener to give us a link in return.

Step 2: Next, we’ve got to find which links on the page are broken. Go to any of the resource pages and look for broken links by using a free link checker like this one Link Checker. We ran the check on the NutritionWise page and sure enough, we found a broken link pointing to a site called www.mypyramid.gov – the Link Checker highlights it on the page:

 

Step 3: Now that we’ve found a broken link, we can write to the publisher, tell them about the broken link on the page and hope that they’ll be grateful enough to list our site instead.

That’s it – a very simple process.

 

The bad news about this simple process

You’ll find many articles on the web telling you this is the way to do broken link building – and it does work – sometimes the webmaster will pay attention to your email, fix the link and give you a link as well.

But the bad news is that it takes so much time – and you’ve got to suggest a pretty good piece of content to get the site to correct the mistake and link to you as a reward for your good work.

So after trying to do it this way, many SEOs realise how much time it takes and that the relatively meagre rewards do not justify the effort. They decide that broken link building is not for them.

But this is not the way to do broken link building at scale.

The method sounds reasonable but a fantastic opportunity was missed at Step 3 and this is where most SEOs get it wrong.

How broken link building can be done at scale

So where was the missed opportunity?

What this process fails to recognize is the full potential of finding a resource like MyPyramid.gov.

Nicole Meadow linked to MyPyramid.gov because she thought it was a quality resource. She thought that visitors to her own site would find it useful and she’d get some kudos for pointing it out. That is why people create links and resources pages – to share great stuff.

So if Nicole thought MyPyramid.gov was a quality resource, then lots of other people would think so too – and link to it to share with their readers. And every link from those sites to MyPyramid.gov will also be broken. So if we collect all the domains pointing to MyPyramid.gov, we have multiple broken link building opportunities.

So how many domains link to MyPyramid.gov? Here’s an analysis of MyPyramid.gov using MajesticSEO.com – it shows that there are over 56,000 domains that link to the site – and each of these links will be broken! What a treasure trove of broken link building opportunities.

 

This means that when you find a broken link on a resource page, your first step should not be to rush off and send an email to the webmaster. Your first step should be to find other domains that link to the same broken resource.

So when working at scale the broken link building process becomes:

Step 1: Find multiple resource pages in your industry. Each of these will list multiple quality resources – a percentage of which will be broken (on average 10%). The more resource pages you find, the more broken link opportunities you will uncover.

Step 2: Scrape all the links from these resource pages and check their status to find broken links. The majority of these broken links will point to valuable resources that have moved or no longer exist.

Step 3: For each resource that has moved or no longer exists, do a link analysis to find other pages that link to the same broken resource. Concentrate your efforts on those that have around 100 linking domains or more.

Step 4: Create a customizable email pitch template for each broken resource and send a pitch to each linking domain.

This process dramatically increases the volume of broken links that you find for just a little extra effort. Follow these steps and you’re in a position to do broke link building at scale.

 

The importance of keywords in broken link building research

Fundamental to broken link building at scale is the need to find as many prospects as possible. To do that you’ve got to conduct multiple searches.

For example, we could do searches such as:

  • [nutrition inurl:resources] or
  • [nutrition inurl:links] or
  • [nutrition inurl:websites] or
  • [nutrition inurl:”recommended resources” and so on.

And the same, say on food health:

  • [“food health” inurl:resources] or
  • [“food health” inurl:links] or
  • [“food health” inurl:websites] or
  • [“food health” inurl:”recommended resources” and so on.

And organic food:

  • [“organic food” inurl:resources] or
  • [“organic food” inurl:links] or
  • [“organic food” inurl:websites] or
  • [“organic food” inurl:”recommended resources” and so on.

All of these searches will produce relevant resources pages.

The choice of keywords in these searches is important.

One common mistake is to use the keywords you are trying to optimize for to find resource pages. Say we were optimizing for the phrase “nutritional benefits of organic food” and used that in the search for resources. We’d not get many results:

 

We’d only find two resource pages.

Sites that are interested in nutrition per se, are likely to have some interest in the nutritional benefits of organic food.

And when we just use the word ‘nutrition in our search string, we find many more results:

 

 

Improving your creativity with Wordtracker’s Free Scout

When you’re buried deep in SEO, your optimization targets are sure to dominate your thinking. So you need some help in stretching your creativity.

One exercise I’ve been using for years is to take a few articles from top sites like the NYTimes.com or the BBC and then analyse them for phrases that I might not immediately spring to mind.

Now, there a new free Wordtracker tool to help you. It’s called Scout and it picks out the phrases on a page. Apply it to a quality articles and you’re sure to get some great ideas:

 

Repeat this process several times and the number of relevant concepts you gather will definitely expand.

 

Final words

Broken link building is one of the few white-hat link building techniques that can be done at scale. But the simple process most people use will not give you sufficient volume. However, concentrate on finding popular resources that are no longer live – and have many domains pointing to them – and you will find a wealth of opportunity.

 

Need to Get More Quality, White-hat Links?

Broken Link Building can be a fantastic source of quality, white-hat links. It’s a strategy that fits easily into any campaign. Ken McGaffin and Garrett French will teach you step-by-step in a new 12-part online video course. Just click BROKEN LINK BUILDING VIDEO COURSE to find out more..

Originally from: http://www.wordtracker.com/academy/the-simple-link-building-technique-most-seos-get-wrong

10 Cool Things You Need to Best Optimize Adwords Campaigns Today

rhecht

Adwords-logoIn my last few years managing Adwords accounts, I learned a few tricks and shortcuts. These are meant to not only make ones Adwords life easier but also more efficient when optimizing campaigns. Here are some of these tricks/tips.

1. Search All Accounts

Managing a ton of accounts? Need to find that one campaign/account? A small link called “Search All Accounts” in the MCC dashboard should help.

2. Adwords Editor

Adwords Editor becomes a huge resource when managing multiple campaigns by city, season, etc. and you need to do repetitive tasks like copying accounts over, or importing data from Excel, or setting a bulk keyword bid, etc. The sooner you utilize Adwords Editor, the easier your life will be.

3. Bulk Budgets

In Shared Library you can do Budgets. This helps consolidate many accounts of the same type so when doing budget adjustments, the time spent gets reduced to a fraction.

4. Filter, then increase/decrease bids

Need to reduce CPC in a jiffy and run through tens of thousands of keywords? No problem. Set up a filter (Create Filter) in Keywords for top impression share, then reduce by a certain percentage. Keep doing so daily to get your optimal number.

5. Lost Impression Share (IS)

Lost Impression Share will give you a good percentage of how many impressions a given keyword is missing. This can be due to low CPCs, limited budget or low quality score.

6. Est. 1st Page Bid

Incredibly valuable. This will tell you how much you need to spend to get your keyword on the page 1 of Google. You can risk having your CPCs a bit lower, but that means the keyword term will fall off of page 1 much of the time, and only on a few occasions will the Ad show up, generally at the bottom of Page 1. This then leads to a lower CPC which then causes the first-page bid to go even higher. It’s actually cheaper (relatively) to increase the keyword CPC to the Page 1 bid, and if you’re feeling adventurous, the “Top of Page” bid.

7. Display URL and On-Page SEO Mean Nothing

That’s correct – in terms of Adwords that is. Page load time and low bounce rate do. I admittedly used to think that on-page SEO caused higher quality score per keyword. I was wrong: low bounce rate does, and this usually is catalyzed by fast page-load time and if an offer is compelling enough for one to stay on the page and not “bounce.”

8. “Rotate Indefinitely” is Your Enemy

One of the campaign settings is “Rotate Indefinitely.” This is Adwords’ version of evil in my humble opinion. This causes all Ads to rotate evenly whether they are good or not. The bad ones when rotated will cause fewer CTRs, and thereby higher CPC’s. Avoid at all costs. If experimenting, use “rotate evenly” instead which serves to optimize Ads; otherwise, just do “optimize for clicks” – it’s easier.

9. Callout Extensions Are Your Friend

Callout Extensions is one of Google’s “latest and greatest” new features to roll out, especially now in Canada. Callout extensions contain compelling text that state “30% off until June 1st,” etc. Callout extensions differ from sitelinks in that sitelinks are physical links to other pages on ones site (though they can contain small descriptions with Advanced sitelinks), whereas callout extensions contain compelling text. Callout extensions can increase keyword CTR by up to 30% (source: don’t ask).

One bummer about Callout Extensions is that it isn’t available yet in Adwords Editor. This can be time consuming when dealing with tens of campaigns to copy them over. Perhaps Google will add this in a future version of Adwords Editor.

10. Learn Adwords’ API structure with Google Docs

Adwords’ API is supposed to automate/ease tasks better. What’s awesome here is that you can place data in a Google Docs spreadsheet and connect the two together. Not feeling up to learning the API from scratch? No problem. There are lots of free samples to copy/paste from from resources such as Search Engine Land.

 

So that’s it in a nutshell. Let me know how your Adwords experience has been today after reading these tips!