Blog analysis January- February

As you may know I am extremely data driven. I love numbers and finding trends and all that kind of stuff, that probably why I ended up studying engineering.  Anyway after 2 solid months of putting my heart and soul into this blog or as much of both as I could I wanted to look at what I had and see if I couldn’t find any trends or anything special with it. Hopefully by the end of this I can give other bloggers out there some tips and advice or if you have any please share it with me!

Below is the stats board for January 2018.

January stats

Unfortunately, I didn’t think I could fit everything well in one screen snip, but I had 152 views and 97 visitors. Fairly respectable for a full first month’s effort. At this time, I was experimenting with Facebook advertising as you can see 55 of my views all of which were driven by the Modern Long Term Stock Market investing book drove many of my visitors and views. Instagram contributed 27 visitors and search engines managed 7 visitors. If you turn those all into percentages it would read 56.7% Facebook, 27.8% Instagram, 7.2% search engine. All should be noted that many of the views came within the United States and the runner up was UK with approximately 10% of the total views. About $29 was spent on advertising in January.

Next up we have February 2018. While not completely over we are pretty darn close so we will call it as we see it.

February stats

February boosts 260 views and 177 visitors, a sizeable margin over January. Now with 2 front runners for article views, both Freedom Funnel and Millionaire Booklet were advertised heavily. The runner up 10X Rule didn’t do bad either. Facebook comprised 125 out of 177 referrals, Instagram 35, search engines 7 it looks like. In percentages we have Facebook 70.6%, Instagram 19.8%, and Search engines at 4%. Lets also look at viewership. Majority United States again comprising of 64% of the demographic, and UK in second with 16.5% of the demographic. Advertising costs for January were about $43 maybe slightly less than that.

Digging further into the data we find that both January and February had 8 new blog posts each so that remains a consistent factor. I also cut down the Facebook advertising after mid-February, I was at 150+ visitors around that time as well. The lack of effort in the second half of February killed the growth of this blog. I have mentioned in earlier posts my extra effort required at school around that time prevented some of that growth.

After looking at the above data, I can deduct that advertising has a direct correlation to viewership however I still have not made any income from the blog in terms of referrals to apps, amazon affiliate sales, or any other revenue of that manner. Until I can increase my income organically I will be taking it easy on the advertising costs. I have been putting more emphasis in my Instagram account and hope that will drive future growth. I believe more posts and the catalog of old posts will also increase visitors and viewership. I am currently working on setting up a mailing list to further hit on returning visitors and keep the blog growth steady.

Hopefully this gave you all some insight on what’s going on behind the scenes here at B^2, please let me know if you have any suggestions!

Until next time,

B^2

What I keep track of and Why

So naturally as an engineer I am very numbers and data driven. Fluff is not my game, numbers, charts, graphs, hard tangible data is where I thrive. I started tracking my spending while on co-op and internship, I figured it would be good practice for when I got out in the real world on my own and needed to be financially responsible. So, at that point I created what is now my most useful tool that I use to track my finances and goals, the co-op money breakdown google sheet. Doesn’t sound exciting but contained in these 8 pages excel spreadsheet is a lot of cool stuff. We’ll start with what started it all, the daily tracking of my finances.

color coded

I color coded my categories of expenses, from left to right they are Food, gas, fun money, fitness, Significant other, and other costs. I would track every cost that came in with running totals at the bottom, weekly amount spent on each category as well as the percentage of my costs it represents. This helped figure out where I was over spending and what needed to be adjusted. Next, on the same page of the excel sheet right next to the color-coded spending category is my income category. Here I would track my income (mainly paychecks) as well as how much of that income I saved. I also tracked my 401k contributions on every paycheck and kept a running total of that as well. Yes, I had a 401k through my co-op company at 20 years old, it was pretty frickin cool. Moving on, I would run totals on all of that, run percentages for amount of money I was saving compared to making and how much I was investing compared to how much I made in total etc.

Date: Income: Net profit Savings Invested (401k)
5/24/16 tax return $74.00 $7,629.20 $900.00 $378.00
5/27/2016 paycheck $660.50 $925.00 $345.00
6/10 paycheck $1,192.00 $548.00 $395.80
Baseball tickets $45.00 $507.00 $42.09
6/24 paycheck $1,234.00 $562.00 $384.72
7/8 paycheck $1,097.00 $106.80 $388.87
7/22 paycheck $1,014.00 $600.00 $339.00
Amazon $80.00 $889.00 $375.00
8/5 paycheck $1,124.00 $551.00 $123.30
bonus $106.80 $295.00 $324.00
8/19 paycheck $1,099.00 ** $550.00 $622.12

After that I believe I started tracking my net worth in specific categories. As you can see below I would track it every month and I have a nice little graph and everything, but I would track cash, emergency fund, P2P lending, Robinhood stock account, Stash and acorn, and finally my 401k. Add all that up in a couple different columns and there’s my net worth tracking.

networth

Another critical tool that I use on this spreadsheet is my Robinhood portfolio spreadsheet. Shown below it contains all the information on my stocks, shares, cost average, value into the position, market value and then the gain/loss with percentages. Also, the conditional formatting is a nice touch to quickly assess the portfolio. I usually update this sheet twice a week or more if I make big moves in the portfolio which I have recently.

Ticker shares cost average value in market value gain/loss gain/loss %
CHK 399 $4.92 $1,963.08 $4.00 -$367.08 -18.70%
ULTA 7 $241.25 $1,688.75 $227.69 -$94.92 -5.62%
O 25 $56.23 $1,405.75 $54.21 -$50.50 -3.59%
F 50 $11.38 $569.00 $11.64 $13.00 2.28%
BPMX 1624 $0.30 $483.46 $0.13 -$272.34 -56.33%
OHI 15 $27.12 $406.80 $27.41 $4.35 1.07%
STAG 15 $26.77 $401.55 $25.69 -$16.20 -4.03%
ATRS 130 $2.42 $314.60 $2.26 -$20.80 -6.61%
ELF 15 $19.87 $298.05 $20.05 $2.70 0.91%
AMBA 10 $52.94 $529.40 $50.25 -$26.90 -5.08%
CEFL 10 $17.72 $177.20 $17.95 $2.30 1.30%
T 5 $33.64 $168.20 $37.82 $20.90 12.43%
IP 1 $57.54 $57.54 $64.75 $7.21 12.53%
TTS 5 $9.48 $47.40 $9.75 $1.35 2.85%
JD 0 $41.82 $0.00 $0.00 $0.00 -100.00%
BAC 0 $23.95 $0.00 $0.00 $0.00 -100.00%
BABA 0 $0.00 $0.00
cash $4.35
updated $8,515.13 profits and dividends -$796.93 Current Value
1/18/18 money in $8,000.00 $515.13 current market ROI
started face value ROI 6.44%
12/2/16 net annual profit $456.37

Following the stock portfolio, I have two tables for dividend tracking however I’m only going to show the monthly counting dividend table. Below is a table showing how much I’ve received in dividends by each month and then sum it all together for the yearly total. As you can see I was relatively close to my goal this past year, a lot of my money was tied up in bad positions that didn’t pay dividends which ultimately hurt my portfolio as well. The other table features all the stocks I own that pay dividends, their payout on a yearly basis, how many shares I own, total yearly dividend income from those stocks, etc. I believe I am right at the $200 a year in dividends mark as we are speaking, that is not including interest payments I receive from Robinhood or the dividends I receive in stash.

Dividend tracking 2017 2018
January $0.00 $12.32
February $0.00 $3.10
March $0.00
April $0.00
May $0.00
June $12.54
July $6.39
August $5.55
September $20.68
October $17.86
November $23.12
December $28.13
$114.27 $15.42
Goal: $125 $500

I also use 2 tables for my Lending Club portfolio, the one below just tracks the interest I receive each month as it says on the account statement I get. Very simple and easy to fill out, nice little tool to figure out how the portfolio is doing overall at a quick glance.

Lending club interest collected
month amount
April 2017 $0.00
May 2017 $11.04
June 2017 $29.03
July 2017 $21.33
August 2017 $37.25
September 2017 $38.81
October 2017 $40.66
November 2017 $41.20
December 2017 $35.15
January 2018
February 2018
March 2018
April 2018
1 year gain $254.47

This next one is a bit more intimidating. This is a detailed depiction of the Lending Club portfolio, I fill this one out biweekly and the immediate return column is the only one that is self-calculated, everything else is straight from the Lending Club dashboard/summary screen. I use the immediate return to gauge my APY % as it comes in rather than the speculative NAR % return.

Lending Club info deposited account value NAR % return date immediate return monthly payments
active notes $1,500.00 16.50% 6/5/17
70 $1,700.00 $1,720.00 16.74% 6/19/17 1.176%
103 $2,500.00 $2,534.00 14.70% 7/7/17 1.360% ?
107 $2,500.00 $2,546.72 17.58% 7/21/17 1.869% $91.48
128 $3,000.00 $3,063.65 15.72% 8/4/17 2.122% $92.13
129 $3,000.00 $3,066.90 13.95% 8/29/17 2.230% $111.66
128 $2,900.00 $2,963.39 11.41% 9/15/17 2.186% $111.74
127 $2,850.00 $2,931.35 10.05% 10/3 2.854% $110.83
127 $2,800.00 $2,905.65 11.78% 10/17/17 3.773% $110.83
125 $2,650.00 $2,765.00 12.28% 11/1/17 4.340% $109.00
123 $2,600.00 $2,729.38 11.79% 11/15/17 4.976% $107.18
121 $2,500.00 $2,628.97 11.32% 12/1/17 5.159% $105.49
121 $2,450.00 $2,615.00 11.84% 12/16/17 6.735% $105.49
120 $2,400.00 $2,558.22 10.76% 1/1/18 6.593% $103.63
122 $2,400.00 $2,591.66 12.54% 1/15/18 7.986% $105.00

Finally, I track my blog statistics and posting schedule on my spreadsheet. As you can see I have tracked my advertising costs as well as the WordPress cost of the blog. I also track my views, visitors each month. Now if you are familiar with blogging or have one already you know that jetpack tracks this all for you currently. I just like the convenience of pulling up this spreadsheet and having all the numbers and data I’d ever care to know about right at the tip of my fingertips and easily analyzed. I think It is worth the extra time to fill out the spreadsheet.

Blog sheet blog was created 11/24/2017 Blog stats 2018
Date expense Month: November December January
11/24 $46.98 wordpress 1 year views 3 81
1/5/18 $3.00 IG promotion visitors 2 7
1/12/18 $20.00 IG promotion Revenue $0.00 $0.00
1/15/18 $3.00 IG promotion expense $46.98 $0.00 $29.00
1/17/18 $3.00 IG pormotion NET -$46.98 $0.00 -$29.00

Like I said, just a schedule of what I’ve posted and when, I also anticipate a posting schedule but that is never correct, I always have too much on my plate or other things that need my attention before this. The yellow highlighted posts are blog posts that have the potential to profit through affiliate sales, referral codes, etc. I have a column next to it with the amount they’ve made so far. Unfortunately that’s a big fat goose egg right now.

Schedule content
11/30/17 future real estate investment
12/3/17 Stretch investing
12/7/17 side money challenge
12/11/17 lending club review
12/12/17 change of plans
12/17/17 stock portfolio
12/20/17 Aspiration|Summit
12/20/17 stash investing
12/21/17 acorn investing
12/27/17 Discover Credit Card
12/27/17 Dividend update 12/27/17
12/28/17 2018 Goals
1/3/18 stock market book FE
1/5/18 review Robinhood
1/5/18 side money update 1
1/16/18 status update
1/22/18 airsoft entrepreneur

As always let me know that you think!Hope you got some useful information from this post, and may apply some of the ideas and concepts to help organize your finances or something else important to you.

Thanks, B^2