monetizer expertmobi
Dismiss Notice
Welcome to Our Community
Wanting to join the rest of our members? Feel free to sign up today.

How do you track profit/loss on your campaigns?

Discussion in 'General Affiliate Marketing Forum' started by Serious, Mar 13, 2013.

  1. Serious

    Serious Affiliate affiliate

    37
    0
    0
    Do you keep an excel sheet or some 3rd party software?
     
  2. monetizer
  3. Andy Haskins

    Andy Haskins Affiliate affiliate

    I use an excel spreadsheet for my tracking, records spend/revenue on different campaigns and sources and calculates ROI etc.

    Quick and easy way once you are in a daily habit of entering the data.

    It's based off of the one Kris had put on Cash Tactics a few years back but has been amended over the years.
     
  4. CashAdsSarrah

    CashAdsSarrah Affiliate Manager Affiliate Manager affiliate

    183
    3
    0
    Click Cell A1. Type “Product Revenue,” “Service Revenue” and “Total Revenue” in cells A1 through A3, respectively. Press “Enter” after typing in each cell.
    Click Cell B1. Type the amount of revenue you generated selling merchandise in Cell B1 and the amount you earned providing services in Cell B2. Press “Enter” after typing each amount. For example, assume you had $5,000 in product revenue and $10,000 in service revenue last month. Type “$5,000” in Cell B1 and “$10,000” in Cell B2.

    Click Cell B3. Type “=B1+B2” and press “Enter.” Excel adds your revenues in Cells B1 and B2 to calculate your total revenue. In this example, you get “$15,000” in total revenue in Cell B3.
    Click Cell A5. Type the name of one of your expenses in Cell A5 and the names of your other expenses in the cells below Cell A5. Press “Enter” after each expense. In this example, assume you paid $7,000 in cost of goods sold and $2,000 in wages. Type “Cost of Goods Sold” in Cell A5 and “Wages” in Cell A6




    Click Cell B5. Type the amount of each of your expenses in the cell in Column B that is adjacent to the corresponding expense in Column A. Press “Enter” after each amount. In this example, type “$7,000” in Cell B5 and “$2,000” in Cell B6.




    Click the cell below your last expense in column A. Type “Total Expenses” and press “Enter.” In this example, type “Total Expenses” in Cell A7.




    Click the cell in Column B that is adjacent to the Total Expenses cell. Type the formula “=SUM(first:last)” but replace “first” with the column and row of the cell that contains the amount of your first expense, and replace “last” with the cell that contains your last expense. Excel adds all of your expenses in column B and shows the total in the cell adjacent to Total Expenses. In this example, click Cell B7, type “=SUM(B5:B6)” and press “Enter.” Excel shows “$9,000” in Cell B7.




    Click the cell two cells below “Total Expenses” in Column A. Type “Net Profit/Loss” and press “Enter.”




    Click the adjacent cell in Column B. Type “=B3-total expenses” but replace “total expenses” with the cell that contains your total expenses. Excel subtracts total expenses from total revenue to calculate your net profit or loss. A negative result represents a net loss. Concluding the example, type “=B3-B7” in Cell B9. Excel shows a “$6,000” net profit.
     
  5. operationoffers

    operationoffers Affiliate Manager Affiliate Manager affiliate

    664
    58
    28
    I use Excel for just about everything from business expense tracking to personal expenses. I have tabs for just about everything
     
  6. cord marston

    cord marston Affiliate affiliate

    15
    0
    1
    Same for me, excel is very powerful and I have multiple documents. I create a new document for every traffic source and then a new tab for every campaign. Track spend, revenue, profit, conversions, conversion rate, ...the whole 9 yards. It's been very helpful so far.
     
  7. K

    K Administrator Administrator affiliate

    Would be great to see some of your templates.
     
  8. ezeey

    ezeey Affiliate affiliate

    55
    0
    0
    Excel all the way. I usually do it at the end of every month
     
  9. Hacder

    Hacder Affiliate affiliate

    83
    13
    8
    How about a web based tool with various templates ? :D
    Anyone?


    Sent from my iPhone using Tapatalk
     
  10. K

    K Administrator Administrator affiliate

    I'm sure there would be one around...haven't used one myself but hey!
     
  11. mattyboy

    mattyboy Affiliate affiliate

    327
    5
    18
  12. CashAdsSarrah

    CashAdsSarrah Affiliate Manager Affiliate Manager affiliate

    183
    3
    0
    I would create and excel sheet look for my previous post I put some good advice on how to format it.
     

Featured Resources (View All)

MI