This sheet helps you to get a handle on your funnel conversion performance.It pulls in Google Analytrics data and automatically calculates metrics like visit-to-purchase conversion rate, average order size, and more.
Google Analytics event tracking is a useful feature for tracking visitor interactions with your website that would not be normally tracked. Use this sheet to generate your event tracking codes (and keep track of event tracking in GA).
Want to heatmap specific metrics in order to identify growing or hot trends over time? This sheet pulls in your Google Analytics data and then displays traffic heatmaps so you can easily see peaks and troughs.
Doing a regular social media audit can be time consuming. Thankfully this sheet makes it easy to track all your social profiles in one place and pull out things like posting frequency, followers growth and engagement.
This template allows you to run a quick SEO content audit without ever leaving Google Sheets. It pulls raw data from 6 sources (Google Analytics, Google Search Console, Screaming Frog, Ahrefs, Majestic SEO, and Moz) using the super-handy Supermetrics.
This technical audit checklist makes SEO work faster, more effective, and more impactful by considering the underlying problems to tackle/prevent. It then presents them in an easy to use format with handy colour coded grading.
This simple free site audit tool uses sheets formulas to analyze a website from a sitemap URL or list of URLs. It checks for things like Schema usage, titles, meta descriptions, heading issues, and for any duplication issues.
Manually review every page on a site can take ages. This content audit automates over 90% of the process for you, by crosswalking large amounts of data from GA, Ahrefs and Sitemaps. Quickly analyze page level quality – links, bounce rate, organic traffic and more.
Use this free Google Sheets template to conduct competitor analysis as part of your SEO strategy. Find out what keywords and backlinks your competition has, but you do not. Then take advantage of this analysis for your campaign.
This competitor keyword research sheet allows you to explore your competitor's keywords using SEMRush. Then, identify content gaps in your client’s keyword footprint vs the keywords that their competitors rank for (but your client does not).
This post walk you through how to do a competitor content gap analysis using SEMRush. Then using the nifty sheet, you can use Google Search Console to determine if title tags & meta descriptions can be improved.
Clique Hunter is a backlink analysis tool that helps you find out which backlinks your competitors have in common (by analyzing up to 10 of your competitors backlink profiles). The sheet templates helps you do this at scale by analysing your data more efficiently so you can build out your backlink strategy.
Looking for quick insights into popular content topics across the web? This sheet template has got you covered. It finds topic inspiration for your content marketing efforts in no time, using a large number of new social sites, content aggregators and news sources.
Find target topics instead of keywords with the Topic Opportunity Finder. It aggregates your competitors’ ranking keywords into general topics so you can identify the overall topics that your competitors rank for.
This sheet helps you to find content gaps on your site. If you were wondering, content gaps are keywords ranking past page 3. They can be related topics not being targeted or maybe in need of better on-page optimisation.
If you work in the adult niche, Google doesn't give keyword search volumes for certain queries. Even if you aren't in that industry your SEO and PPC tracking and reporting could be effected... Unless you use this sheet to claw back your data.
This template matches up Search Console and Google Analytics data into a sheet so you can see your top keywords and engagement metrics side by side. Great for seeing which keywords are driving organic traffic.
Using this sheet, you'll be able to find link reclamation and unlinked mention opportunities easily. You can then filter by time to find recent opportunities and use the integrated DA metrics to decide on which to go after.
This sheet shows queries and landing page combinations that receive a high number of impressions but have a low CTR. It also pulls in title tag, meta description and character counts, so you can quickly see which search snippets can be improved to increase CTR.
This report template pulls in Google Analytics data into a Google Sheet, to see how usability and page load speed impacts conversion rates. It analyzes where the conversion leaks are hiding in your funnel, across browsers, devices and screen sizes.
This report uses Google Analytics to dig into the overall acquisition efficiency of your site. It analyzes the overall effectiveness of your site at converting visitors into customers, by page and by channel.
This custom SEO dashboard let's you easily analyze what’s causing organic traffic to drop. In fact, you can see organic visibility in specific cities, landing paages, impact on conversion metrics, devices types and more. Seriosuly, it does all the hard work for you.
Easily scrape Google search results pages and save the keyword ranking data inside this sheet using the ImportXML formula. Useful for monitoring organic rankings, keeping tabs on competing websites or exporting for further analysis.
This social media report sheet is designed to give you a snapshot view of your last 7 days of social media stats, using Buffer data exports. It can also be modified to work with exported data from Twitter, Facebook, or Instagram.
Use this Google Sheet to know which social media posts are on track and which are taking off. Just enter your social media data and the formulas do the rest, highlighting any update that goes above and beyond your average.
This generator creates error-free hreflang tags for your website. It also keeps a list of all accepted language and region codes, so you don't accidentally use the wrong language or region code and mess up your rankings.
Using the Search Console API to pull in search performance data (impressions, clicks and CTRs by landing page and query), this Google Sheet analyzes each page and query combination’s performance over a chosen period.
Ceva has built all its web sites on a common Content Management Solution called Ez-Publish, which allows all countries to translate and
customize their version of the product web site, the subsidiary web
site or other initiatives taken by Sales and Marketing teams