Keyword Not Provided Tool

One of the KPIs for SEO performance is tracking Brand vs. Generic keyword traffic. Due to secure search functionality on Google (https), more and more keywords are showing up as (not provided). To get a more accurate picture, I’ve created a simple tool that calculates the ratio of Brand vs. Generic on all of the keywords we can see, and applies that same ratio to the (not provided) value, then divides it appropriately into Brand and Generic. The end result will give more accurate grand totals for both Brand and Generic keywords.

The tool features 3 columns for Input Data for your total Generic Visits, Brand Visits and Not Provided Visits – these are the only fields you must populate. Once you input data, everything else will calculate automatically including the chart (the chart can be adjusted easily by selecting data on the chart and sliding the corresponding brackets in the table). You must pull data for each month, which will help you track how the % of Generic is changing over time.

Check it out! Keyword Not Provided Tool

Here is an example of the tool in action with fake data:



*please fill in all fields. Thanks!

My New Home

I've taken up a few new hobbies in the Pacific Northwest including hiking and photography. Here is one of my favorite shots so far. [caption id="" align="alignnone" width="1080"] Mt. Hood National Forest[/caption]
Read More

Stress at Work is Good!

I have always tended to perform at my best under pressure, but how much is too much? I love this infographic showing the ideal zone, since there certainly is a breaking point. Click it to read the full post.
Read More

Tru by Hilton

Tru by Hilton

Hey. We’re new here. Take a look around while we get settled. We’ll be introducing ourselves over the next few months, so like and watch to learn more about Tru.

Posted by Tru by Hilton on Monday, January 25, 2016
Read More

Hide Meeting Attendees in Outlook

If you are hosting a meeting or webinar and do not want your attendees to see the guest list, follow these instructions. Create a new meeting in Outlook Click Invite Attendees Click To Add your attendees as a Resource Add as resource When Outlook prompts you to update the location, select NO Then send the meeting and the recipients will not see who else is attending/invited.
Read More


[embed][/embed] A boss's nightmare in which her team doesn't adhere to legal and compliance rules.
Read More

Automatically Insert Delta Symbol for Reporting % Change

When reporting % change in email, excel, powerpoint or word, it is possible to make it easy to insert the delta symbol to indicate change (i.e. YoY % ?, or 33% ?, or 33% ? YoY). In Outlook, navigate to File -> Options -> Mail -> Spelling and Autocorrect Click AutoCorrect Options Then, under Replace text as you type: - Enter what text you would like to be automatically replaced with the symbol. I used: (delta) - Copy and paste the delta symbol into the "With" column: ? Click OK and it should be set for all Office programs. Test it in one of these programs by typing (delta) or what you chose to be replaced, and the symbol should automatically appear.
Read More

Must Watch Video on Net Neutrality

Cable companies are trying to create an unequal playing field for internet speeds, but they're doing it so boringly that most news outlets aren't covering it. John Oliver explains the controversy and lets viewers know how they can voice their displeasure to the FCC.
Read More