Set up a Google Analytics driven overview of campaigndata in PHP

Your task is to develop an application which allows the creation and monitoring of Google Analytics campaigns. Each campaign will be composed of a collection of user-defined "landing pages" within four different categories. Each page should have its "unique visits"-numbers retrieved. These values will then be used together with pre-defined user-input campaign data, from the creation of a campaign, to show campaign activity and calculate the ROI. The Google Analytics "basic" that we have already use the last API from Google Analytics, so it should be pretty basic to fetch what is needed. You will also get an account and the server-side hosting parts, so you can easily work directly with this in PHP and MySQL to get it up and running using trial and error. See the full description for details on what we want you to do! ## Deliverables Google Analytics driven ROI application --------------------------------------- *** General requirements *** - No frameworks except jQuery are allowed. - All styles should be in separate CSS-files. Inline CSS is big no-no! - File and database structures must be clear & make sense. - The code should be neatly indented and well commented - Names of variables and functions need to be clear and understandable - Use tooltips where appropriate. Clarification is always a good thing. *** Worker requirements *** - Must be able to read & write decently in English. This is very important for communication purposes. - Excellent knowledge in developing in HTML/CSS/PHP/MySQL - Excellent knowledge in Google Analytics & its API *** Expected deliverables *** A fully functional product that meets all the listed specifications and requirements. Nothing else will be accepted. *** Project background & Assignment *** We have a mail distribution system, Otto, and we want to add a standalone application that the costumer can use together with Otto. Your task is to develop an application which allows the creation and monitoring of Google Analytics campaigns. Each campaign will be composed of a collection of user-defined "landing pages" within four different categories. Each page should have its "unique visits"-numbers retrieved. These values will then be used together with pre-defined user-input campaign data, from the creation of a campaign, to show campaign activity and calculate the ROI. The different categories are the following ones: 1. Start page(s) for the campaign. This will measure the total unique visits 2. Landing page(s) after signing up to a form. This will measure sign ups 3. Page(s) visited through links in e-mails (when they use a sign-up form). This will measure the amount of page visit through sent links 4. Landing page(s) after buying a product/service, this will measure the amount of sold products *** Set up *** We need an overview page, a create page and an edit page. OVERVIEW PAGE User controls: - Create campaign button - Date range inputs (to be able to set the the time span when calculating the campaign data, default should be the last 30 days) Data columns: - Campaign name - Unique visits (start page visits) - Number of signups (signup visits) - Links clicked per lead (lead = signup visit) - Number of orders (order page visits) - ROI = ((signups*value) + (clicks*value) + (orders*value)) - (startup cost + (signups*cost) + (clicks*cost) + (orders*cost) See attached picture "[login to view URL]" for visual details. CREATE CAMPAIGN PAGE: User controls: - Go back button - Save buttons Input fields: - Campaign name (text) - Currency code (drop down with known currency codes) - Start up cost (numeric) - Cost per lead (numeric) - Cost per click (numeric) - Cost per order (numeric) - Value per lead (numeric) - Value per click (numeric) - Value per order (numeric) - Start page URLs (textarea with multiple comma separated URLs) - Signup page URLs (textarea with multiple comma separated URLs) - Mail-link page URLs (textarea with multiple comma separated URLs) - Order page URLs (textarea with multiple comma separated URLs) See attached picture "[login to view URL]" for visual details. EDIT CAMPAIGN PAGE: User controls: - Go back button - Save buttons Input fields: The same fields as the create campaign page. Display fields: - Campaign code (the auto-generated code for the campaign) - Analytics code for embedding on website pages (auto-generated) See attached picture "[login to view URL]" for visual details. * * *This broadcast message was sent to all bidders on Monday Sep 3, 2012 5:24:56 AM (by sub-account person id [#8013927][1]): rudberg changed the ExpertRating requirements on this project from: MySQL 5.0 Test CSS 2.0 Test PHP5 Test HTML 4.01 Test PHP Programming Skills Test To: MySQL 5.0 Test