Buried by data overload..HELP! (3)
Hi Guys,
I've been launching campaigns for a while now and reached a point where I see some profits here and there. I'm running antivirus (pin submit) and utility apps in pretty much any geo. Some days are better than others but the problem is, I'm getting lost with data.
I really need to organize myself better. I only use
I made a search here and there and got even more confused than I already was. The point is: I would like, at the end of the day, gather all the relevant data I need and put them into a spreadsheet to easily understand how much I spent, earnt, lost, what to cut or keep running.
I've found different excel sheets (here, here, here, etc..) but didn't really get which data are essential to become more productive.
I understand that there's probably no perfect spreadsheet but would like at least to get a better idea of which data are most useful to understand what to do with my campaigns at the end of each day.
Right now, I'm a total mess, and I'm sure I'm losing a lot of opportunities by doing what I'm (not) doing.
Any help would be much appreciated. Especially in terms of data to put under my radar (CpC, CPM, eCPM, ROI, Cost, Revenue, Profit, impressions, conversions, placements, etc..).
Thanks a lot.
This is just the way I do it and there are probably better ways, but right now I have 5 spreadsheets:
1. Carrier-> OS combos, all that has to be done is paste in visits, revenue, and spend for each carrier and the spreadsheet calculates the rest and outputs some graphs
2. SiteID chart, just have to paste in siteIDs, visits, spend and revenue, it chops the placements up into different lists
3. Dayparting graph, this is more a workaround the tracker not doing it, but basically just have to paste in the amount of hour, day of week, visits, spend, revenue and it'll output some graphs, by weekday, by hour (weekday), by weekend, by hour(weekend), total, and so on
4. One "journal" for each individual campaign, noting down amount of landers running, amount of offers running, and notes on landers/offer, for each TS: Noting down visits, spend, revenue, bid, and it calculates the actual bid. Plus some daily notes per TS, like for example:
carrier A - 9482 visits @ 3.9CPM ($37 total), $45 revenue
Looking at this day-to-day it is easier to see trends, like if the actual bid for a carrier goes up and volume goes down it is likely more competition
5. One "journal" for a batch of campaigns, each of the individual campaign "journals" autogenerate a short summary based on the data and notes plotted in, the "batch journal" is where I plot in all the short summaries. It is like a timeline that moves sideways from left to right, and each campaign has its own row.
Creating the spreadsheets and the "system" took like a day and some learning, writing the reports isn't so bad, takes about 10-20min depending on how many campaigns, and it helps me look through the data and see trends between the campaigns, or day-to-day trends etc. Haven't really used SiteIDs much, checking them every day would be a bit too extensive... But now basically all I have to do to analyze is export all the data into a csv, and paste them into the spreadsheets and it generates graphs and stuff.
If you first have a spreadsheet going it is super easy to make graphs, bar charts, pie charts etc if you have the data ready in cells.
This has made it a bit easier to keep track but it is no magic pill, but it helps with not losing track of things
Each campaign folder contains:
- One campaign journal spreadsheet
- One dayparting spreadsheet
- One carrier -> OS spreadsheet + one siteID spreadsheet PER traffic source
It may be a bit rigid and stuff... Ideally you would configure a tracker autogenerate all this from the data since it is totally possible
1. Keep all of your notes in one location; either ONE single spreadsheet with multiple sheets in google drive - so you can access it from anywhere
-or- use trello, or evernote to keep all the stuff everywhere.
I personally use trello, because I just like to have cards for everything, it lets me drop screenshots using cut n paste command so its awesome
2. Label your campaigns in your tracker so when you do campaign overview all is straight forward, this includes offers, cpa networks, geos, etc.
When naming landers make it clean - instead of calling it LP1 Angle 1 ZA, write Android Alert LP with Your phone will explode Angle
3. Use dropbox/google drive, and keep your stuff organized in a folder. All spied landers in a folder called SPY>Landers and then name the lander as you save it ENGLISH-Antivirus-MCAFEE for example.
Home > The Newbie Zone > Questions and Answers