7 Levers of Business

This taken from 7leversofbusiness

1. Traffic
– advertise
– get leads/traffic
– from events,

2. Opt-Ins
– convert leads to real prospect
– phone/email queries, subscription
– offer something free to get in touch/follow up
– get minimum info – name, email or phone

3. Conversions
– testimonials
– guarantees
– money back
– payment options
– strong brand
– ask for the sale

4. Items per Sale
– offer add-ons – (e.g. date entry, website building)
– package the deal

5. Average Sale Price
– increase price. – give more value
– be a market leader

6. Transactions per Customer
– recurring bills
– repeat sales.
– sales other things – membership, info product
– sales same things again

7. Profit Margin
– decrease cost
– nego with suppliers
– improve product line. push for high margin products
– reduce expenditure
– reduce staff, automate things, find partners

Increase small percentage on each level will contribute significant improvement in business profit.

Internet marketing and sales

Steps for doing sales and marketing on the internet.

  1. Set several advertisement online – classifieds, google adwords, facebook ads
  2. Let the visitors land on the squeeze page and leave their email address. In return, provide free tips, free report
  3. Set at least 5 autoresponders to send out the promised report and tips to build credibility
  4. Send subscribers to a sales page to sell products
  5. Send subscribers to other recommended products as well
  6. Anyway don’t just sell, give also valuable free information
  7. Once in a while, can also broadcast email for some good news (normally more free information, tools and promotions)

Angular JS basic

<script src="http://ajax.googleapis.com/ajax/libs/angularjs/1.4.8/angular.min.js"></script>
<div>
 
Name : <input type="text" />
<h1>Hello {{name}}</h1>
</div>

Some quick notes

  • must be within ng-app
  • can specify default value with ng-init
  • ng-model to define value to be displayed later in place holder
  • use double curly braces as place holder to display value hold by ng-model

Google spreadsheet – function to split comma separated string to few lines

Face this problem to split address to few lines for printing purpose.

Example address:

No. 1 Road 2, Happy Park, 43800 Big Town, My State

to

No. 1 Road 2,
Happy Park,
43800 Big Town,
My State

Just use this function besides the cell.

=SUBSTITUTE(A1, ",", char(10))

Replace A1 with the cell number.

Another related function is SPLIT.

Cloud accounting

Some choices for accounting software hosted on cloud.

International

  1. xero
  2. quick books (for malaysia)

From Malaysia

  1. treezsoft (RM120/mo)
  2. biztory
  3. office central
  4. swancount.com (free for 90 trans per month)
  5. niagawan.com

Free open source

  1. simpleInvoices (not full account. just invoice)
  2. webzash.org
  3. accounter
  4. invoice plane

Free for small business (paid with extra features)

  1. pandle
  2. wave
  3. due invoicing (invoice only)

Some uncommon mysql command

https://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html#function_coalesce

COALESCE()

IN

NOT_IN

NOT_LIKE

FIND_IN_SET

Example: select * from users where (find_in_set (5, access_string) > 0);

will return position of the key if found in string. else will return 0 for not found or NULL if field is NULL