Competitive charts

I wanted to show how to create a competitive chart that will help show visually how a site is doing traffic wise against its competition. Do you miss the charts that you could create for free with compete.com but now those charts are only available for paid pro accounts? Here’s a solution to help you create the same type of competitive charts for multiple competitors. Go to compete.com and enter your site or your competitor’s site and click the go button. You will get a page with the competitive information and you’ll see the traffic graph for that site on the right hand side. Next you’ll want to export the CSV and once you open the file you will see data like this image below:

Keep the monthly data and the unique visitor data, then enter other competitors
one by one and repeat downloading the csv for each. With each new competitor copy
and paste the unique visits into the next columns within the same spreadsheet
and enter the competitor name at the top. When you’re done entering the data your
spreadsheet will look like this:

Highlight the data and choose insert > line (chart)

I ended up breaking out the major carriers and the lesser to
help give each chart a better representation. When you’re working with small or
mid-size businesses who may have longer term goals to compete in the larger
markets it is good to show these types of different charts.