Yes, that sounds like it would be awesome. Another great update would be to add a script that populates the spreadsheet automatically from a file structure containing the downloads (organic KWs and Links) to save copying and pasting everything. I’m going to have a chat with a friend in the Analytics space to see if he can help. Will share any successful output.
What’s the difference between your brand and your keywords? Are you using both effectively? Your brand is one of your most important keywords, but it shouldn’t be your only keyword, nor should you have lots of keywords but no brand. There should be a keyword strategy behind the keywords you pick. This post highlights the why of that and explains the basis of the how, then points you to several useful posts for the how.
Jeff Baum is Director of Services at Hanapin Marketing and a seasoned PPC advertising professional with Hanapin Marketing. a 13 year track record of success in digital advertising. He has developed and implemented strategies to substantially grow revenue and profits for a variety of lead generation and e-commerce businesses. He has also been responsible and accountable for managing hundreds of thousands of dollars in PPC advertising spend per month. Jeff is a recurring writer for Hanapin's blog and PPC Hero.
Conduct a business download meeting. I meet with key stakeholders to learn everything I can about the business and the industry they compete in. Is the business itself growing or struggling? What about the industry as a whole? I use this time to learn what has worked and not worked from a PPC perspective and to determine if PPC performance goals are realistic and achievable (or if they exist at all).
For branding campaigns, your budget is often not an issue. You may have a fixed budget or your budget may be seemingly limitless. It doesn’t matter, because with this strategy the focus is on position; and in most cases only position #1 will do. This is often the easiest strategy to execute for paid search, but it’s also inefficient. The reality is that bidding into the top position in search results is often a waste of money. Google has gone on the record as saying that conversion rates don’t vary much by position, so in many cases all that the first position buys you in paid search is brand awareness (and vanity).
Whether you’ve heard a little about PPC marketing and are curious to learn more, or you already know that you want to use PPC to market your business, but aren’t sure where to start, you’ve come to the right place! This is the first lesson in PPC University, a set of three guided courses that will teach you everything you need to know about PPC and how to make it work for you.
Every company has those dreaded competitors they cannot stand, no matter what you do they are always using your ideas and taking your potential customers. Whether you are a local, national, or international company there is probably someone in your company, specifically the sales and marketing teams, that can quickly rattle off your top competitors as well as what differentiates them from you.
How do you figure out what keywords your competitors are ranking for, you ask? Aside from manually searching for keywords in an incognito browser and seeing what positions your competitors are in, SEMrush allows you to run a number of free reports that show you the top keywords for the domain you enter. This is a quick way to get a sense of the types of terms your competitors are ranking for.
In internet marketing and geomarketing, the delivery of different content based on the geographical geolocation and other personal information is automated.[3] A good example is the Ace Hardware website at www.acehardware.com. The company utilizes geolocation software to power the “My Local Ace” section of its website. Based on a site visitor’s location, the website's online locator service can show the visitor how many stores are in their area, as well as a city-level locator map to help the customer find the store closest to their address.[4]

Geo-targeting (sometimes spelled geotargeting or geo targeting) involves detecting a user’s location, and serving them communications based on that location. Those communications might be ads or other content, like an email or geo-targeted push notification. Geo-targeted communications are delivered most commonly through text or push, and might also come when you open a certain app or social media site. The benefit of geo-targeting services are simple: enhanced personalization.
Your Sales ForceYour sales staff probably has more access to competitive information than anyone else in your organization. Customers often show salespeople sales literature, contracts, price quotes, and other information from competitors. Part of a salesperson's job is to get customers to discuss problems they have with a competitor's product. Customers will also reveal your competition's product benefits, strengths, and customer service programs. Instruct your sales force to ask for copies of any competitive literature if and when that's possible. Your entire sales staff should keep a record of all competitive information they discover — even if it's just a rumor or gossip. Devote a regular portion of each sales meeting to a discussion of the competition.  
Geotargeting is a practice frequently deployed by such restaurants and brick-and-mortar businesses looking to drive local foot traffic, but it isn’t exclusively the province of these verticals. Even sports teams have gotten in on the action, targeting fans that are at (or have been to) a particular stadium or event in order to drive ticket sales, app downloads, and more.

"We've been experimenting with Quora Ads in a few client accounts and have been intrigued by the (limited) results thus far. One of our clients, Dataquest, is an online platform for learning data science. Their marketing director approached us about Quora Ads a few months ago, and we decided to give it a shot. To be fair, we are still in the middle of the trial run, so the traffic is fairly low, but what we have seen come through is enough to get us excited about it as a new channel. 
HubSpot also has a campaign tool that allows you to associate keyword phrases, related blog posts, emails and landing pages with a particular campaign so you can get a better idea of the overall performance. If a particular set of keywords doesn't seem to be bringing in new site visits or converting leads to customers, it might be time to search for alternatives.  
More importantly, take the time as you conduct your keyword research to segment and categorize your keywords to map to the right landing pages. If the page doesn’t exist on your site yet, then that is your cue to build a new page for that set of keywords. By doing this you will achieve the relevance that will lead to more engaged visitors and higher conversion rates.
Some competitors solve the same problem with the same technology but focus on a different customer. For example, Zum provides schoolchildren with rides to school, solving a transportation problem for kids and parents. Zum solves a slightly different problem too: safety. Safety is the primary concern for parents when it comes to kids riding back from school. However, it’s ultimately grounded in the same tech as Uber.
It is dependent on the pre-analysis of the entire IP address space. There are more than 4 billion possible IP addresses, and detailed analysis of each of them is a Herculean task, especially in light of the fact that IP addresses are constantly being assigned, allocated, reallocated, moved and changed due to routers being moved,[6] enterprises being assigned IP addresses or moving, and networks being built or changed. In order to keep up with these changes, complex algorithms, bandwidth measurement and mapping technology, and finely tuned delivery mechanisms are necessary.[7] Once all of the IP space is analyzed, each address must be periodically updated to reflect changes in the IP address information, without invading a user's privacy. This process is similar in scale to the task of Web spidering.
The benefit of clearly describing a strategy for your PPC campaign is that it can inform the creative, particularly when it comes to building PPC adverts with our various elements: header, ad copy, ad extensions – where does everything go? Great advertising is built on great creative, so spend as much time crafting solid messages as you do on the strategic elements of the campaign. This chapter looks at how you can craft the best ad creative to communicate your message.
Let’s take the example of a guy, we’ll call him Jerry, who runs a coworking space in the city of Bristol, UK. He’s concerned about his keyword rankings, as seen in WooRank’s SERPs tool. Even his main keywords are only providing ‘+100’ rankings. (If you have used our SERPs tool, you know that this is the number we give to search engine results that rank out of the first ten pages in Google and Bing for a certain query.)
To do this, you want to analyze your analytics frequently by keyword and observe visitors’ behavior when they come to your website or landing page. Don’t fixate on just traffic alone. How much time are they spending on your site? What is the average number of pages they are viewing? What is the bounce rate? A high bounce rate like 80 percent will tell you that most of your visitors leave your site immediately upon landing on your site. They’re not engaged and see no content clues they arrived at their desired destination. This can be fixed by making changes to your landing pages as long as they are relevant to the keywords that brought them there.
Geotargeting is a practice frequently deployed by such restaurants and brick-and-mortar businesses looking to drive local foot traffic, but it isn’t exclusively the province of these verticals. Even sports teams have gotten in on the action, targeting fans that are at (or have been to) a particular stadium or event in order to drive ticket sales, app downloads, and more.
Chesky and Gebbia believed that most people thought hotels were the only option for travelers, but the truth was that renting someone’s extra room was cheaper with an added dose of personalised hospitality – and likely a higher margin business as well. Hyman and Fleiss believed that most people thought they needed to buy the dress they wanted to wear, but the truth was that you didn’t need to own a dress that you only wear a few times. Both teams set out to challenge old customer preferences with modern technology and logic.

It's wonderful to deal with keywords that have 5,000 searches a day, or even 500 searches a day, but in reality, these popular search terms actually make up less than 30% of the searches performed on the web. The remaining 70% lie in what's called the "long tail" of search. The long tail contains hundreds of millions of unique searches that might be conducted a few times in any given day, but, when taken together, comprise the majority of the world's search volume.

SEOptimer is a free SEO Audit Tool that will perform a detailed SEO Analysis across 100 website data points, and provide clear and actionable recommendations for steps you can take to improve your online presence and ultimately rank better in Search Engine Results. SEOptimer is ideal for website owners, website designers and digital agencies who want to improve their own sites or theirs of their clients.

×