PHP Guru Wanted for PPC Affiliate Tracking Back-End
£250-750 GBP
货到付款
I am an affiliate marketer.
I use PPC advertising (Google Adwords & Bing Ads) to drive traffic to my affiliate sites.
It's essential to track which PPC keywords result in affiliate sales, in order to optimise advertising spending.
HOW I CURRENTLY PERFORM TRACKING
Currently, I have a separate AdGroup for each product I promote, in this structure:
CAMPAIGN > ADGROUP > KEYWORD > ADVERT
I send product-specific keywords to product-specific landing pages.
When the user clicks to leave my site and visit the shop, a unique id is attached to the link which is reported in my affiliate sales.
At the end of the week, I compare the amount I've spent on advertising, to the income I've made from affiliate sales, for each product. I do this manually by exporting reports from the affiliate networks and importing them into Excel.
HOW I WANT TO PERFORM TRACKING
I want to quickly and accurately calculate profit/loss for each PPC campaign (broken down into adgroup, keyword, and advert), rather than doing it manually.
I don't care about a nice front-end design. The system is for internal use only.
Something like this: [url removed, login to view] - but much simpler. I only need 4 basic reports:
1. Campaign clicks - Campaign spend - Affiliate income - Profit/Loss
2. Adgroup clicks - Adgroup spend - Affiliate income - Profit/Loss
3. Keyword clicks - Keyword spend - Affiliate income - Profit/Loss
4. Individual Advert clicks - Individual Advert spend - Affiliate income - Profit/Loss
For flexible date ranges.
So if plotting this data, date on the x-axis and GBP on the y-axis (clicks could also be plotted on 2nd y-axis). Just like this: [url removed, login to view]
Campaign would be the highest level chart/report - to give an indication of profit at a glance.
But then each AdGroup or even each Keyword can generate its own chart/report.
LINKING AFFILIATE SALES TO THE RESPONSIBLE KEYWORDS/ADVERTS
Each affiliate tracking ID will need to contain this data, in order to be associated with the correct adgroup. It can follow a standard structure. Something like:
campaign_id-adgroup_id-keyword-ad
SKILLS REQUIRED
- PHP
- MYSQL
- Google Adwords API
- Bing Ads API
- Affilate Window API
- Ebay Partner Network API
- Amazon Associates API
- Commission Junction API
- Webgains API
- Affiliate Future API
Note: No front-end design skills are required. I can add fancy flot charts later if required.
项目ID: #5484374
关于项目
有16名威客正在参与此工作的竞标,均价£898/小时
10+ years of experience in programming PHP/MYSQL. I had done much programming into development and also bug fixing all these years. You can check my profile for my reputation and ranking . I can work on this project an 更多
Hello, With 99% completion rate, 650+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page !!)... you can never go wro 更多
I have check this requirement,have some query,so need to discuss this,please tell me how we can start the discussion. to know more about us please check Private Message. We have a team of professionals,they have more 更多
Greetings, Thank you for giving us a chance to bid on your project. We have looked at your project specs and we are confident that we can deliver you robust and reliable solution. We have successfully completed more th 更多
Hello, I am able to complete your this project so let me have a chance to make you happy. Thanks, Regards, ATechsWorld
Hello Recruiter, Thanks for sharing this post, I work for leading US brands promotion on Search Engine. I have good knowledge of target audience and the way people look their brands online. I would be interested to 更多