Home > Paid Traffic Sources > Facebook & Instagram

Facebook Ad Buying Success Spreadsheet, with real world data from A4D media team (5)

01-27-2016 07:32 PM #1 Smaxor (Veteran Member)
Facebook Ad Buying Success Spreadsheet, with real world data from A4D media team

Built this spreadsheet for my Affiliate Managers to help their affiliates have a better chance of success on Facebook campaigns.

The goal of the spreadsheet is to tell you what ad CTR you'd need, by placement, in order to make a campaign successful. All you have to plug in is the guesstimated conversion rate and then CPA. If you don't have a guess for the Conversion rate just talk with your affiliate manager.

All the CTR to CPC costs are sourced from our internal Facebook buying team. We use this worksheet with that team in order to determine:

1. If we want to even test a campaign
2. What we'd need to hit in order for it to be potentially be profitable.

I plan on doing a video or webinar in the next few days if you newer and can't figure it out on your own. I'll be putting it up on my blog http://oooff.com.

Here's the spreadsheet... Let me know what you think.

https://dl.dropboxusercontent.com/u/...Jan%202016.xls

Feel free to ask any questions and I'm happy to help. And always if you want to work with AM's that understand these kinds of things and can help you with this please hit up A4D.

01-28-2016 08:17 AM #2 bobliu (Member)

Very nice spreed sheet Jason, thank you. Does A4D have an offer API?

We had an internal solution that monitored click price data and recorded it daily for every country (it could alert when price hit a certain target) however it was a little troublesome to maintain so we put a pause on that project, could look at getting it up again and making an online version of this and piping it through to you via an API. Would be cool to see this live with DNF/MNF/RHS prices. A lot of work but if enough interest..

01-29-2016 02:35 AM #3 Smaxor (Veteran Member)

Bobliu, add me on skype and we can discuss a little more. Live:jasona_33

Also I made a video that explains the overview of how build our new campaigns out. As well as how we use this spreadsheet.

You can check out the video here and get the new updated worksheet that has Landing Pages factored in.

http://www.oooff.com/php-affiliate-s...heet-included/

01-29-2016 08:26 PM #4 bobliu (Member)

Quote Originally Posted by Smaxor View Post
Bobliu, add me on skype and we can discuss a little more. Live:jasona_33

Also I made a video that explains the overview of how build our new campaigns out. As well as how we use this spreadsheet.

You can check out the video here and get the new updated worksheet that has Landing Pages factored in.

http://www.oooff.com/php-affiliate-s...heet-included/
Good stuff! Sent you a message. Let's build something great.

01-31-2016 01:11 PM #5 rmanor (Member)

Thanks for the spreadsheet Smaxor.

I'm new here and never thought to look at Facebook ad planning this way.

This is tremendously helpful.

Home > Paid Traffic Sources > Facebook & Instagram