Missing tab in Competitor research Template

[AnkitaDwivedi]

The template provided in https://moz.com/blog/competitor-analysis-for-seo is missing the 'Audit Data' Tab.

Can you please update it or share the Original Template

[gregmattison]

This Google Sheet is great but I am experiencing the same issue. This updated sheet now includes the Audit Data tab but when I fill in the Keywords on respective competitor tabs the Keyword Gap Analysis sheet shows some rows but definitely not all the data. I saw your response saying this is awesome", did you get it resolved? Would you please share the updated sheet?  Thank you!

[thirdwavellc]

This is AWESOME Oliver, THANK YOU!!!

[FriendInCommerce]

Hello thirdwavellc.

To make things easier, I've made a complete spreadsheet template that you can just update. It is a modified version of the one John Michael posted on in the MOZ Blog but this one has the "Audit Data" tag added it. I also had to make a change to the way the Keyword Gap Analysis tab was counting. All good now

**Here is a link to the fixed spreadsheet: FIXED - Competitor Analysis Template **
Here is a link to a video screen share: Walkthrough of Competitor Analysis Template

Let me know if you have any questions and I hope this helps.   
-oliver-
Friend In Commerce

[thirdwavellc]

Thanks Oliver for this.  Unfortunately after adding the sheet, it still does not work for me.  I even changed the name of the sheet to 'Audit Data'.

Also, the Keyword Gap Analysis sheet is not really working. I did not use SEMRush for my keywords as mentioned in the original article.  I used Adwords and just pasted the Keywords and deleted all the other data. The populated data in the Keyword Gap Analysis looks weird, most likely not correct.

Any help would be GREATLY appreciated.

Regards

[FriendInCommerce]

I've had the same issue and was able to fix things by creating a new tab (sheet) in the Competitor Analysis Template. It works for me now, and I haven't seen any issues. Here is a link to an AUDIT DATA sheet I create that you can insert into your current Competitor Analysis template. Let me know if you have any issues. Good luck!

**Here is a link to the fixed spreadsheet: FIXED - Competitor Analysis Template ** 
Here is a link to a video screen share: Walkthrough of Competitor Analysis Template

-oliver-
Friend In Commerce