Clicks to Sales Info
We are looking for a script, filter or piece of software to pour through our log files and pick out referring sales information for our pay per click marketing efforts.
Our website - [url removed, login to view] is run on LaGarde Storefront software using a Microsoft SQL Server and asp pages. We are hosted with a dedicated host ([url removed, login to view]). We currently have a live data feed being updated every 1/2 hour. We also download orders in real time and do the payment processing on our store software (rPRO).
Currently we are able to view using Web trends on this site where traffic referrals are coming from and the words looked to search for us on the site. The key piece of info we are missing though is what word actually converts to a sale.
We do heavy pay per click campaigns and do utilize some of the tracking features from Google and overture - but want to get way from that. When setting up new campaigns we do use a standardized format of:
[url removed, login to view];term=pillowsale
Where the ref is the search engine we buy clicks on and the term is the keyword or phrase.
We use a variety of PPC Engines including: Google, MSN, Yahoo, Ask Jeeves, Looksmart, etc...
So in theory we would be able to run a report - lets say in access that can pump out a report like:
Referrer Term or Phrase Clicks Sales
We would in turn marry this with the pay per click engines data of clicks, costs, etc….then create our own report to show effectiveness on a word by word campaign, etc…
Said report would need to be run for any time period of choice.
So first we need to get the referrer and sales data.
It is very important to note that the site is mission critical and we need a trusted source who will not disrupt existing sales. Our goal is to have someone check under the hood and then develop a cost effective solution.