Xfactor Course - Practical Question (and good news)

I have a spreadsheet that I created that has several tabs:

Tab 1 - Site Info. This lists each domain name and all the relevant login/passwords (FTP, WordPress, email, etc.). I also have my checklist of what I need to do for each new site I create (dummy-proof for me so I can walkthrough it even when I'm tired), from registering, Hosting setup, DNS registration, WP installation and editing, etc.

Tab 2 - Article Tracker - article ID (used on later tabs), Article Name, Article Site (EZA, GOA, etc.), Date submitted, Date approved, link1 Anchor Text, link 2 Anchor Text

Tab 3 - Marketing Progress - the standard list of article 'To Dos' down the side, with each site across the top. For example, Main Content GOA 1, GOA 2, EZA 1, Deep Content 1 GOA, Deep Content 1 EZA, etc. (Basically I uniquely identify each article that he recommends we write in the seven-day step). Each domain goes across the top. When I submit an article, I use the article ID from Tab 2 in the right cell so I can correlate them. For articles that need to be approved, I change the cell color gray until they are approved. I've also added some of my own traffic generation ToDos down the side, apart from just the articles, and put an 'X' in the cell when I'm done.

On this tab, above each domain, I have the day the domain was registered (pulled from Tab1), a place to input the date for which I pull Adsense data, and a place to input the total earned for the Adsense channels associated with that site. Then another cell calculates the average $ earned per day for the life of the site.

Tab 4 - Keyword Stats - When I find a niche with MNF, I check the results (searches, exact results, SOC), and export them, then paste them in this tab. This helps me know which phrases I need to write content for. If I'm building, say, 5 pages, I can look at the stats and see which one I should write for next. I also append the SpyFu data to the header keyword. I'm using this to track how well my sites are doing based on the stats they had when I started so I can know what to look for in future sites (as far as search/result ratio and SOC).

Once John puts up his own message forum, I'll probably post a cleaned-up version of my spreadsheet for others to use.

I'm also considering adding a tab to track the SEO Rank Checker results, but that feels a bit extraneous at this point.

Note: I'm a Data Analyst by day. So yes, I value collecting and analyzing the data. lol In fact I probably spend too much time doing that and should be doing more article writing. But since I'm starting up, I'm trying to track properly from the beginning so I can best sharpen my efforts in the future.

Adsense Masters Course - Adsense Masters Course

That's because you're comparing apples to oranges.

SOC numbers are different from niche to niche.

Dogs and pets are different,so they'll have different SOC data.

Dog is specific. Pets is broad.



Ron