1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Need a LAMP stack desktop software for tracking a mobile banner

Discussion in 'Hire a Freelancer' started by sean richer, Mar 23, 2017.

  1. sean richer

    sean richer Newbie

    Joined:
    Mar 23, 2017
    Messages:
    1
    Likes Received:
    0
    Gender:
    Male
    LAMP stack sofware needed. We need to create a JS code in the form of an Ad Tag that will load a banner that is clickable and log information. The information is logged upon banner loading. Based off this information that is logged from the user and device, the Ad Tag should make a choice whether to show url1 or url2.


    Advertiser Feature / Table / Screen
    • Feature
      • Ability to add an advertiser, edit an advertiser, see a list of advertisers. Will be used to maintain a relationship to other data.
    • Fields
      • ID
      • Name
      • Date Created (auto)
      • Created By (auto)
    • Screens
      • Create Screen
      • View List Screen
      • Edit Screen
    • Description of Functionality
      • I want to be able to associate an Ad Tag with an advertiser. To do this I will create an advertiser and then select them when creating an Ad Tag. I want to be able to edit the name of an advertiser if needed. This relationship will mainly be used in grouping, filtering and reporting.

    Publisher Feature / Table / Screen
    • Feature
      • Ability to add a publisher, edit a publisher, see a list of publishers. Will be used to maintain a relationship to other data.
    • Fields
      • ID
      • Name
      • Date Created (auto)
      • Created By (auto)
    • Screens
      • Create Screen
      • View List Screen
      • Edit Screen
    • Description of Functionality
      • I want to be able to associate an Ad Tag with a publisher. To do this I will create a publisher and then select them when creating an Ad Tag. I want to be able to edit the name of a publisher if needed. This relationship will mainly be used in grouping, filtering and reporting.

    Ad Tag
    • Feature
      • Ability to add an Ad Tag, edit an Ad Tag, see a list of Ad Tags. Will be used to maintain a relationship to other data and save settings.
    • Fields
      • ID
      • Name
      • Advertiser (relationship) not-required?
      • Publisher (relationship)
      • Date Created (auto)
      • Created By (auto)
      • Include Locations (ajax predictive with multi-select) City, State, Country
      • Excluded Locations (ajax predictive with multi-select) City, State, Country
      • Safe URL (text)
      • Status (dropdown) Active or Inactive - required status. This means its showing the banner and safe URL when active (with smart logic off)
      • Smart Tag Logic: On or Off - (this actually applies the logic to show url1 or url2 on click. If smart logic is off, only load the creative and safe URL. Smart logic must be on for it to have the option to go to url2 on click.
      • Creative Banner - Allow uploading of an image or URL that will show when active.
      • Geo - Which Geo to load Tag for?
    • Screens
      • Create Screen
      • View List Screen
        • Button to Edit
        • Button to view Log
        • Status Indicator
        • Smart Logic Indicator
        • Get JS Code Button
      • Edit Screen
    • Description of Functionality
      • I want to be able to create an Ad Tag and select its options, once created I should be able to get the JS code. I want to be able to edit its settings if needed by hitting an edit button from the View Ad Tags List screen. I want to be able to see its Active Status and Smart Logic Status from the View Ad Tags List screen(we will always start it as active and then turn on the smart logic once the Ad Tag gets a certain amount of impressions). I want to be able to click into its log and see the Ad Tag Impression Log below from the View Ad Tags list screen.

    Ad Tag Impression Log
    • Screens
      • View Log Screen (per campaign or aggregate)
    • Log Data Collected
      • Transaction ID
      • All Mobile & Desktop User and Machine Information. EVERYTHING!
      • IP
      • Device ID
      • Ad Tag ID
      • Ad Tag Name
      • Advertiser
      • Publisher
      • Referrer?
      • Safe URL
      • Date & Time of Impression
      • Decision e.g. Passed (url1) / Failed (url2)
      • Reason (if Failed) Proxy IP, Smart Logic Off etc.
      • Add to Ban list button?
        • Log should not be normalized as a table for faster list loading?

    Logic
    • Ad Tag Loads >> Parameters sent when tag loads >> Decision is made >> url1 or url2 is loaded on click
      • This should happen server side
    • Save all the parameters and create a transaction ID
     
  2. PeterWinters

    PeterWinters BANNED BANNED

    Joined:
    Mar 11, 2017
    Messages:
    7
    Likes Received:
    0
    Gender:
    Male
    I can provide this service. Skype: peterwints06
     
  3. cnick79

    cnick79 Jr. VIP Jr. VIP

    Joined:
    Jun 10, 2010
    Messages:
    686
    Likes Received:
    369
    Location:
    Google's SandBox
    This is one of the more detailed specs I've seen. I love it. You might want to consider a NoSQL solution for the log data instead of storing it in a relational database. You can then have an ETL process that stores the data into a log reporting table. You don't want logging to be a bottle neck. Pm me your due by date.