All posts
Published at Sun May 08 2022 in
For Teams
Turning your website into a growth machine and tracking it with ease
Natalia M
Natalia M
50007237 1

Websites are essential for businesses and startups. Apart from hosting information for users, investors and shareholders, it’s one of the main acquisition channels. With pandemic resulting in mass cancellation of events and trade shows, online acquisition channels became the best way to scale fast and across markets.

Website is also one of the most flexible owned channels. You can build as you envision it, without having to mold it to a certain platform (unlike your social media accounts or YouTube). 

After letting your creativity run free and providing all valuable information for your users on your website, you’ll want to focus on getting as many eyeballs as possible on it. And this is a big challenge.

You’ll be heavily engaged in improving SEO to help your website rank higher, timely releasing relevant content, running paid campaigns to increase your traffic and monitoring your results. Create, publish, track, repeat.

In this article we’ll cover the main aspects of the entire process. Especially website performance tracking. And how to make it easy for you and your team.

Read on!

Your website core vitals

Infamously over 80% of people browsing the Internet don’t click to the second page with search results. Given that each page of search engine results usually contains 10 organic listings, it doesn’t leave a lot of room for everyone.

Even ranking within the first page plays a huge role with click-through rates falling down from 31.7% for the first position to 9.5% for the fifth position, and only 3.1 to the tens search result. So, the competition is fierce.

If you aim at appearing on top of search results, pushing your website rank will be vital. You can use this free Google Rank Checker tool to see your rankings for any keyword and a website. It will show you where you stand strong and where you need to improve.

50007237 2

To boost your ranking you can follow these SEO rules:

·   Do your keywords research to see what your potential users are looking for. Also check your competition – what their key phrases are, and how they use them. Use these keywords in your content too, but avoid over-using. Google will detect and discard such pages.

·   Engage in link building – process of establishing hyperlinks within your website (link relevant product pages or templates to your blog articles). And try to place links to your website on other high credibility websites (media, external blogs, partners, social media). High number of quality links will push your website up.

·   Generate content that is highly relevant for your audience. You can add pages that cover in detail your use cases or start a blog (a go-to for startups). Here the list of keywords will come in handy. But use them wisely. Excessive repetition will not only push away your website visitors, Google might penalize you for that.

·   Use images optimized for speed. Google won’t put heavy, slow to load images in front of users. And generously compliment your images with relevant alt text. Because Google can read it (unlike text on the actual images).

·   Keep an eye on your website speed. It is a big ranking factor too. Make sure your website is hosted on a fast reliable server. Forgo bounty of high res images and other visuals thatl take too long to load. 

      If you’re looking for an effective tool to track your website speed, try our Get Google PageSpeed insights. You can also benchmark your performance versus competitors’.  

50007237 3

When organic is not enough

You might be doing a stellar job on SEO and pushing your website to the top of search engines ranking, but organic traffic could still not be enough. Or you can take current growth as an indication of high potential and look to scale. That’s where other channels and paid campaigns come into play.

Performance campaigns (Google Ads, Facebook Ads, LinkedIn Ads, etc.), paid placements with media, newsletters, collaborations with bloggers and influencers. The choices are vast, the final destination for all this traffic is often still the same – your website.

When running paid campaigns, you’ll want to monitor their effectiveness to see how well they bring you leads, what kind of leads and how well they convert to the users. Most platforms like Google Ads or Facebook Ads will provide analytics with key performance metrics for you. Media and creators would also generate and share campaign reports based on data from their tools.

But you’ll likely also want to check in your own data source to see all incoming traffic (direct, organic, paid) and analyse what performs best.

Google Analytics is a great platform to monitor your website performance. It is an integral part of most startup toolkits. It’s powerful, feature-rich and built for results. But is it always smooth sailing? Not so much…

There are typically a couple of issues most of marketer needs to solve:

·   You will want to share the key insights across your team, but Google Analytics is a tool that takes time and skills to navigate. Not everyone on your team would be able to see the key trends and data they’re interested in at a first glance.

·   You don’t necessarily want to give everyone access to Google Analytics. Especially if we’re talking stakeholders, investors or third party collaborators.

Truth is, Google Analytics is a powerful, but a complex tool. The platform can easily get overwhelming for those who aren’t using it every day.

It also doesn’t provide the easiest setup for sharing selective data with both internal and external stakeholders. Many teams often have to create multiple custom reports to share with their team and separate ones to send to your board of directors, investors, and advertisers. Been there, done that? 

We feel you! And that’s where Rows spreadsheet comes in. 

A new tool to track your website with ease

You can create a Google Analytics dashboard in Rows and share it with the entire team. It will look slick and work well on any device, and you can share it with virtually anyone on your team or external partners.

You can choose what metrics to monitor to focus on the trends and overall performance exactly with the level of details you and your team needs.

Modern design and gorgeous charts that live in a dedicated place will make your website dashboard easy to understand and work with.

50007237 4

Another great function to use is automation. You can set the report to automatically update data with any frequency you need. You can define to run hourly, daily or weekly updates and the spreadsheet will update the data automatically.

Share the dashboard with your team and define access rights. So, anyone on your team (and beyond if needed) can look at it without having the access to your Google Analytics account, and without complexities of the platform.

You can share a private link with the people inside and outside your company who need to see it most. Or you can publish it to the world to appear in Rows Community (the first ever open platform for public spreadsheets). It’s an amazing feature if you’re writing a blog, have your own course or would like to showcase your work to the world.

Eager to start? 

You can use our pre-made Google Analytics dashboards template to set up a dashboard spreadsheet in minutes.

50007237 5

Simply activate the template from your Rows account (don’t have one yet? Get yours today at www.rows.com – it’s free!). Connect built-in integration with Google Analytics, select metrics you’d like to follow and enjoy your website data appear in Rows spreadsheet.

Do you prefer building from scratch? Then we invite you to also take a peek at our video tutorial on building Google Analytics dashboard in Rows. Our awesome No-code Builder Sourabh will guide step by step through the building process.

https://www.youtube.com/watch?v=gQUbntv1Y78

1. Create your Input and Data tables.

First, you’ll want to create a new Rows spreadsheet with two tables: one for Input, and another for Data.

In the first table, your Input table, you’ll be able to use the Date Picker function to select your desired date.

2. Use the Function Wizard 🧙 to create an analytics report.

In your Data table, simply highlight cell A1 and navigate to the Rows Function Wizard. 

There, you’ll type analytics report in the search bar. Then you’ll select the function titled CUSTOM_ANALYTICS_GOOGLE.

The Function Wizard input fields allow you to enter your basic website data and desired parameters. There’s no need to manually input your functions!

On the Function Wizard page, you’ll want to input the following:

  • Your website Google Analytics ID

  • The data range as “>”, with the input value as B1 in your Input table. This sets up your chart to display website data on and after this date.

  • The desired metrics tracked in your report. 

  • Toggle on the Dimensions feature, and set it to your desired time unit. We use Month as the example in the video.

Once you’re finished here, click Add Function.

3. Generate your report.

In A1 of your Data table, click on the icon that should now be visible. 

Then click Report in the pop-up, followed by the Overwrite option. After that, simply hit Enter to populate your Data table.

4. Create a chart. 

From there, you’ll want to select the range of data cells to include in your chart and click Create Chart in the top menu. 

Once you’ve ensured that the data range in the pop-up is an open bound range, your chart is ready. You can now customise the name or re-position it in your report by dragging its title on the left sidebar.

5. Share your report!

In the upper right corner, click Share to select how you’ll broadcast your awesome Google Analytics dashboard. You can share a private link with the people inside and outside your company. 

And there you have it. A neat and easy to read Google Analytics custom dashboard to share your data easily with those who need to see it.


For more beautiful ways to create streamlined reports to be shared with anyone, be sure to visit our Templates collection or the world’s first public spreadsheets library – built entirely by our awesome community. 🙌