Keyword Analysis Report Excel Password protected
-
I am having a problem with the Keyword Analysis report that i am downloading as excell docs. There are password protected. Anyone knows the password?
-
HI Angelos,
Excel has a Protected View feature which prevents files from the internet from being opened in full view mode. All the Keyword Analysis I have ever downloaded simply required me to "Enable Editing" to manipulate the document. This is usually a ribbon across the top of Excel.
You can disable this by going to FILE -> OPTIONS, 1st Pop Up click TRUST CENTER, then Trust Center Settings (button), 2cnd PopUp click Protected View and disable "Enable Protected View for files origination from the Internet".
*Note this may effect all Office programs like Word / Access etc..
The only other things I can think causing password protection would be you don't have SEOmoz credits, or there is some security features that an admin has enabled.
Alternatively, you can download it as an .CSV file and open it with something else besides Excel.
Hope that helps,
Don
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
Bye Bye Keyword Difficulty Tool :(
So the Keyword Difficulty Tool will be retired from the end of this month. Is anyone else worried about this? - because I just don't trust the numbers coming back from Keyword Explorer. Never have. I've even raised this with Moz staff previously, when there was a huge difference between the score given by the keyword difficulty tool vs keyword explorer. From what I see in Domain and Page authority and in the SERPs then the score from keyword difficulty tool, was always more accurate, and thankfully have been able to use both tools, but from next month I feel somewhat uneasy about solely relying on the score from Keyword Explorer. Thoughts? and feel free to run your own tests on keywords and I'm sure you'll see what I mean.
Keyword Research | | GregDixson0 -
On-page optimization for closely related keywords or acronyms of keywords
We are in the process of on-page optimization for a site that sells one kind of software. We are trying to optimize each page for a target keyword and variations of the keyword, however we have more pages than keyword variation types, so I'm looking for feedback on whether the below plan would be keyword cannibalization. Examples: URL: www.domain.com/product
Keyword Research | | seo_1234b
Tarket Keyword: device imaging software
Title Tag: Device Imaging Software | Company Name URL: www.domain.com/solutions
Target Keyword: device imaging solutions
Title Tag: Device Imaging Solutions | Company Name URL: www.domain.com/products/product-name
Target Keyword: dis (acronym)
Title Tag: DIS Software | Product Name | Company Name My question is are these keyword too closely related for each of the pages? Will they be considered duplicate title tags? Keyword cannibalization? etc. Thanks!0 -
How to Conduct a Gaps and Opportunities report with not provided
Hi all Does anyone have any advice on how to conduct a successful gaps and opps audit for your SEO strategy in light of "not provided"? I've been a big fan of Laura Lippay's content audit in finding Gaps and Opps: http://moz.com/blog/finding-gaps-and-opportunities-step-3-of-the-8step-seo-strategy However I'm keen to understand alternatives to run a successful audit in finding opportunities Any advice would be much appreciated! Simon
Keyword Research | | simonsw0 -
How to finalize the keywords for SEO?
Hi, I use the following method for keyword research: Create a long raw list of keywords. Use Google AdWords Keyword tool to find monthly searches. Find raw competition. Find direct competition (via allinanchor: search operator) Calculate KEI (Keyword Effectiveness Index) Calculate KOI (Keyword Opportunity Index) Is there any other (better) way to execute the keyword research? Or is finalizing/selecting the keywords only on the basis of monthly searches sufficient? In short, how to select the best keywords from a long list? Thanks & Regards
Keyword Research | | IM_Learner0 -
SEO beginner- How to decide what keyword to go after?
I started a website called Think and Grow Entrepreneur. I'm not sure where to start with Keywords and which ones to go after. Should I input the same keywords over and over my blog to rank in those or should I look at every post as a single entity and try to rank different keywords in each blog. Ideally I would like to rank for the keyword Entrepreneur, but there are already very powerful companies with the same keyword. How should I go about this situation? I appreciate any feedback. Thanks!
Keyword Research | | johnmoon60 -
What came first the content or the keyword research?
So I've been searching high and low to try and answer this. I just cant seem to get this part down and i know its the most important part. I always run into the issue where i am building a e commerce or some other site and i have it all set up but no content. So i start doing keyword research. In which the market niche that i am working on now is really broad, so its really hard to research. I then end up getting frustrated because the competition for the words are really high. But back on track, i get frustrated and then kaboom! i don't get the results i want and i am back to square one and no content is made or nothing. So my webpage gets nothing. So i took a step back and wondered, should i make all the content first and then the keyword research and then go back and "revise" my website content with all my keywords that i a trying to target? Sounds like a dumb question but i just wanted feedback and input on how people do this and go forth with everything.
Keyword Research | | Dante130 -
Do you use broad match or exact match on Adwords Keyword Tool when doing keyword research?
I wasn't sure whether to classify this as a discussion or a question. I'd love "the right answer" but I'm not sure if we're going to get one... Let's try. When you use the Adwords Keyword Tool for doing keyword research, do you use the numbers from "broad match" or "exact match" when comparing relative search volume of keywords? (And yes, I know the numbers need to be taken with a grain of salt, but when it comes down to it, you're using the numbers to compare and come to conclusions regarding the best keyword to use - so which match type gives you the data you're looking for?) To be a little more specific - when you select "exact match" for, let's say the keyword "baking supplies", is that telling you how many people searched for that phrase within quotes <"baking supplies">, or how many people searched for only <baking supplies="">, as opposed to that word within a phrase <baking supplies="" stores="">or with the words reversed <supplies baking="">?</supplies></baking></baking> Based on some keyword research we had done a year ago where any phrase reversals like <water bottles="">and <bottles water="">were coming out with the exact same numbers, even when it wasn't so intuitive that there would be the same search volume, we came to the conclusion - with the tentative suggestion of the SEOMoz staff on the old Q & A - that broad match would include all instances of the keywords in reverse order, so if you wanted to know how many people were searching for <water bottles="">only, you needed to use exact match. </water></bottles></water> That's what we did for about a year (I also think I saw Rand mention that somewhere in a presentation slide recently, although I could be mistaken and I don't recall exactly where it was to check it up) and then based on a recent forum discussion I had where someone was questioning that premise, I did another check with two KW reversals and while <water bottles="">and <bottles water="">still give the same number, <baking supplies="">and <supplies baking="">do not. </supplies></baking></bottles></water> So I'm left with a big question here as to what the best policy is. Google Adwords Help is very vague on what the match type means in the tool (it seems to be talking about only your settings for your campaigns). So - any input after this long saga? Thanks!
Keyword Research | | debi_zyx0