Author Photo

Sergio Aicardi

Content Writer

Sergio Aicardi is the owner of The Miami SEO Company and lives in sunny South Florida. He offers consulting to many marketing companies in Miami and business owners alike. His responsibilities include developing business relationships and optimizing internal processes to ensure the business is constantly growing, while constantly enhancing the quality of services rendered.

Author

article illustration
Analytics5 min read

5 Simple Google Analytics Clean-Up Tips

From time to time there are little chores you need to do the keep the Google Analytics data clean and organized properly so that the numbers you analyze are as good as they can be. Nothing can ever be absolutely perfect (yes, even with data!), but embrace these tips and you’ll have a killer dataset at your disposal.

article illustration

4 Reasons Why Google's Firebase Is Essential if You Have a Business App

Having an app for your business is becoming more important, especially depending on your industry. The fact is that many users like to know that they can gain access to everything they need to interact with your business on a mobile app rather than having to use a mobile page on their smartphone or tablet. If you have designed a business app, or are looking to design one, then Google’s Firebase is absolutely essential, and in our opinion as a marketing agency, the best out there.

article illustration

Everything You Need To Do Online When You Move Business Locations

If you have ever decided to take on the daunting task of a move for your business, you know how stressful it can be. There is a lot to take care of, but what many business owners forget is that it is really important you don’t compromise your online ranking in the process. You have to make sure all of your bases are covered when it comes to your online move.

article illustration

How To Use Excel To Create a Keyword Strategy

Everyone knows keywords are a big part of SEO, but I feel most people don’t really appreciate the work that goes behind setting up a strategy that is based on keyword performance. Maybe it’s because most people don’t understand what measures are taken to create large SEM campaigns with thousands of keywords that need to be strategically selected. When dealing with large pay per click campaigns in AdWords, using the right keywords means everything. Since there are great tools out there like Semrush and Google Analytics, we can get great keyword data from our competitors or our websites that we manage easily. But managing that data can be tricky at times (especially with ecommerce data). As a member of a PPC management company, it’s important that I am efficient and strategic when selecting keywords for our clients. I wanted to share some of the ways I use Excel to create a keyword strategy very quickly using simple concatenation in a not-so-simple way.