A script or software that pulls information from both AdWords and ClickBank accounts and delivers them in an easy excel format.
The language of which this is written is not important. It can be web based or desktop based. The main information we're looking to get is:
1) Cost from AdWords campaigns and/or keywords
2) Conversions from AdWords campaigns and/or keywords
3) Earning from ClickBank (separated by merchant ID)
4) Earning per ClickBank with tarcking ID (note, this trackign ID will be the keywords used in AdWords).
## Deliverables
I cannot provide my ClickBank and AdWords details. You will basically have to use/get you own.
The script/software has to be able to do the following:
**Main Function 1** **- Campaign ROI**
1) User specifies AdWords account details
2) User specifies ClickBank account details
3) User specifies AdWords campaign names (might be more than one)
4) User specifies ClickBank merchant IDs for earnings (might be more than one)
5) User specifies timeframe (date range)
6) User specifies time range (daily, monthly, summary)
RESULT: Result is presented in an excel spreadsheet comparing the results for cost of the specified campaigns (obtained from AdWords) vs earnings from the specified merchant IDs (obtained from Clickbank) and ROI (return on investment) in the format requested by the user (daily ROI, monthly ROI, etc.)
**Extra:** ClickBank earnings are in USD and AdWords in AUD. It would be good if the software/script could also pull conversion rates for the day and convert the results to either USD or AUD.
**Note:** ClickBank and AdWords operate under different times. AdWords being used is in Australian Eastern Time. I have no idea which time zone ClickBank is set, but it yould be good if the results were adjusted for this.
**Main Function 2** **- Keyword ROI**
1) User specifies AdWords account details
2) User specifies ClickBank account details
3) User specifies AdWords campaign names (might be more than one)
4) User specifies ClickBank merchant IDs for earnings (might be more than one)
5) User specifies timeframe (date range)
6) User specifies time range (daily, monthly, summary)
RESULT: Result is presented in an excel spreadsheet comparing the results for the cost of the keywords (from AdWords) compared to the earnings from those keywords (tracking ID from ClickBank) and including the ROI for these keywords.
**Extra:** would be good if it could show the number of conversions from Adwords for each keyword as well.
**Bonus:** It would be a bonus if the script/software could b easily modified in the future to accomodate for other sites such as 2Checkout, Comission Junctions, etc. This is not necessary, but thinking of this along the process might earn you another project in the near future.
**IMPORTANT:** **Function 2 is optional!** Please let us know if your bid will vary significantly if the script/software has only function 1.