Welcome to the Q&A Forum

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

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

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

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