dizzyweazl - aggregated live leads for afflow (16)
Hey,
i've build a few tools to automate my afflow campaigns (auto bidding, auto blacklisting, auto vertical rotation and some more stuff), for internal use.
But, i've learned so much from STM, so i decided to make some tools public. ATM, i don't know how it goes, but maybe my tools are usefull for somebody.
First, i polished my live lead scrapper http://dizzyweazl.com/. It just pull the live leads from afflow every minute, and aggregate the data for each geo.
ATM it's very simple, it shows lead data for all verticals in all geos for the last 2 hours (updated all 10 min) and you could search for a specific geo (updated every minute).
- no signup
- dont need your login credits
I hope i could add more features soon i have for my internal tools (top offers, trending alerts, ...)
Check it out and tell me if it useful for you or not, do you like the shitty name, or abuse me for build a useless tool.
Cheers Martin
http://dizzyweazl.com/
First of all, thank you so much for being so generous in sharing your custom tool! 
Looking good!
Some suggestions (that MAY help - I don't have experience coding such a tool so wouldn't know for sure):
-Displaying stats by geo is a start. Next, add geo+carrier combinations.
-Aggregating data over the past 2 hours is a start. Next, also display data for the past hour, and the past 30 minutes, and the past 5 minutes. This way you can compare and spot a geo+vertical or geo+vertical+carrier combination that suddenly takes off. You could even program the tool to send you alerts when certain conditions are met, e.g. when the difference between 1-hour-eCPM and 30-minute-eCPM > x, or when 1-hour-revenue and 30-minute-revenue > x.
Can't think of anything else at the moment. I think this has the potential to evolve into a powerful tool. I can't code myself, so have immense respect for anyone that can. Great job! And thanks again for sharing!
Amy
Nice tool, thanks for releasing it for public!
Hey Amy, hey erik,
thanks for your feedback.
@vortex: Thanks for your reply and ideas. I've started to play with afflow, because i read your awesome Afflow-zeropark Tutorial ;-)
I've just added two more features:
- vertical search. Now you could search for a specific vertical and it shows a list of all geo's in this vertical
- Payout trends. Now it show's payout data for 2h, 1h and 30. (I'll add a shorter timeframe soon, but i have to optimize DB performance first).
I dont know if the trends are easy to read. Any suggestions how to display are welcome.
- some bugfixing
Cheers
Thank you @manamanamedia for sharing your tool. I'm new to Afflow as well your tool has been helpful setting up some campaigns.
What programming languages did you need to know to build a tool like this? I'm currently learning python in the hope to build tools to help automate my business.
Hey jresults,
imho you could build this kind of tools with nearly any programming language. Any programming language which could have a kind of tcp support like php, python, ruby, c+ will do the job. For this tool i use php for the backend and javascript for the frontend.
Python is a nice language too start and it's great to handle large sets of data, for example big parts of google is build or was build with python. And when you know python and the general concepts it's very easy to switch to any high level language. Concepts and syntax are really similar.
Awesome! Looking really good - LOVE the little arrows!
A reminder: To be able to jump on a trend, you'd need to have many camps targeting many different geos, set up ahead of time and approved and ready to be unpaused.
Will pour over those stats later to see if I could spot any gems...
Amy
I made my own internal tool using Node.js, but any language will do. It aggregates all live data and makes timed snapshots of trends. Doesn't have a frontend yet, but was thinking of using Angular or Lua just have to figure out which one to learn properly first.
@manamanamedia: Just to clarify - by "Payout" do you mean eCPM? Or what is it? Thanks!
Amy
Hey Amy,
good question.
No, payout mean average payout per lead.
I know eCPM would be an better indicator, but afflow live leads don't provide eCPMs or carrier data.
ATM i'm working to add eCPM, carrier data, individual watchlists for GEOs and trend alerts. So, stay tuned ;-)
how would you mix those data sets? given that you can't know which carriers are responsible for the leads? how are you guys using the live lads aggregated in decision making?
I use three things to check if it's worth to push traffic.
1. avg. CPA from my tracker
2. avg. payout for geo + vertical and trends from live leads
3. afflows GEO+vertical+carrier planner
So if i see a trend in payout data, i check if my CPA is lower, and check in afflows planner which carrier is good.
Originally Posted by manamanamedia
The average payout per lead wouldn't tell you anything about how well the vertical is doing though - or am I missing something there? In which case, tracking and comparing stats for the past 2 hr vs. 1 hr vs. 30 min. vs. 5 min. wouldn't be of benefit.
I think a much better indication of a positive trend, would be to show the total revenue of a geo+carrier+vertical combination, in the last 2 hr vs. 1 hr vs. 30 min. etc. It's true that we still won't know the eCPM, but if the revenue experiences a sudden spike, then it means that there's either a sharp increase in 1)eCPM, or 2)traffic volume. Either/both would be indication that the geo+carrier+vertical has suddenly started to heat up. Just a thought.
Tool's looking real slick! Looking forward to seeing it improve.
Amy
Hey Amy,
for me it works. I know my avg. CPA and with the average payout i could see if a strong offer in the vertical. If the payout trend goes down, mostly the good offer is gone or CR decreased.
And you are right, the revenue is also a good indicator, i will add trends for revenue soon.
ATM i'm working in speed, search for data should be a lot faster now.
BTW i've found a way to pull the more data from afflow. Hope i could show carrier data soon.
Cheers
Sounds good!
Before the spike - main offer has a payout of $2 but is converting once every 1000 impressions = $2 eCPM.
After the spike - new main offer has a payout of $1 but is converting once every 200 impressions = $5 eCPM.
According to your criterion, the $2 offer (i.e. higher payout) would be a better performer than the $1 offer, which is obviously not true.
Obviously we don't have access to eCPM data when it comes to live leads, but as was mentioned above, revenue would be the next best indication. Just knowing the payout without also knowing the conversion rate wouldn't tell you anything.
Am I missing something here? Just genuinely wanting to see your logic. Would love to be proven wrong - would be nice to be able to learn something new.
Amy
You're right, a high payout alone don't indicate a good converting offer.
But, if i know i have an avg. CPA of $0,5 for this GEO-vertical and the avg. payout trend goes up from $0,5 to $1 i start to push traffic. In my experience and with my traffic CR seems very stable and when i see a payout spike my profit increase most times.
Revenue is good indicator for me too, if i'm looking for good geo+vertical combis.
Home > Vendors >