Thanks Ramon! You can easily add more tabs to input more backlink data for additional competitors and then adjust the query formula to use the new tabs. I often increase this to 10, 15 or even 20 competitors for larger clients. The beauty of Google Sheets templates is the ease in which you can make these adjustments. Let me know if you need any help with that.
Working on common practice tasks such as negative matching, keyword expansion and more are the right things to do for an account, and there’s a proper place and time to do them. Without a policy governing how to manage our PPC accounts, we’re “stringing tactics together,” which creates misalignment between volume of work done versus meaningful work that’s impacting results positively.
If your account is currently achieving a return on ad spend (ROAS) of 5, and your goal is to achieve a ROAS of 6, your strategy should focus on efficiency optimizations to improve ROAS. If your account is achieving a ROAS of 5 and your goal is to increase revenue as long as your ROAS is at or above 4 (and you have additional budget to spend), then your strategy will need to focus on growth initiatives.
When using the Keyword Explorer, Ahrefs will also produce the "parent topic" of the keyword you looked up, as you can see in the screenshot above, underneath the Keyword Difficulty meter. A keyword's parent topic is a broader keyword with higher search volume than your intended keyword, but likely has the same audience and ranking potential -- giving you more a valuable SEO opportunity when optimizing a particular blog post or webpage.