Post ProjectBuyersProgrammersFAQForumContactRSS
      MEMBER LOGIN
      SERVICES & FEATURES
  • Post a Project
  • Signup
  • Job Listings
  • Featured Projects
  • Certified Members
  • Top Programmers
  • Affiliate Program
  • RSS Feeds
  •    THE 20 LATEST PROJECTS
    Modify Php Template Website
    Rebrand Software
    For Risalat1 Only
    Web Page Design
    Mailer Program
    High Paying Marketing Project
    Affiliate Marketing Pros
    Hiring Sales Professionals
    Reliable Data Entry
    Two Videos Needed
    English Writer And Editor
    Google Trends Wordpress
    Create A Holding Page
    Customize Oscommerse.only Pros
    Tutor Me With Psd Html& Css
    Modify Boonex Dolphin
    Easy Website Clone..
    Credit Card Website
    Video Blog
    Mobile Software Application
     
       POPULAR NEW PROJECTS
    Swoopo Clones
    Article Writing
    Content Submission
    Landing Pages
    Conversions
    Twitter
    iPhone Applications
     
    Project: Google Analytics API/extract Featured Project! Urgent!
    ID: 1216719535
    Bookmark and Share Post Similar ProjectManage Your Project

    PROJECT DETAILS
    Status: Closed (Cancelled) Urgent!
    Budget: $1750
    Created: 7/22/2008 at 5:38 EST
    Cancelled: 8/6/2008 at 1:25 EST
    Project Creator:
    jferris
    Rating: (No Feedback Yet)
    Description: Google Analytics & Google webmaster tools API

    Data extract
    to create/Generate monthly/Quarterly reports
    in Execl and/or Word.

    We currently run about 30 websites on Google Analytics.

    PHASE 1

    We draw up monthly reports based on Google Analytics (GA) data, mostly. We do this mostly manually currently.

    The first phase of this project is to automate the process for reporting i.e. By doing data extracts:

    • pulling standard data for each website from GA,
    • into either standard MS Excel and/OR MS Word formats, (maybe via a database)
    • so that the format is presentable branded etc without much adjustment by us.
    • i.e. each website will probably have their own excel/word file for each month.

    We would like your suggestions about the best way to do this?

    Currently there is no "official" Google Analytics (GA) API
    - but there is an API which can extract GA report data
    in an XML format...
    We'll probably use that.

    Our simplistic thinking is to extract the report data (via XML) into a database each month
    • probably using http://code.google.com/p/janalytics/
    • pull the relevant info from that database
    • into a proforma excel spreadsheet layout
    (with formatting, macro's , graphs etc)
    • For each website
    • Each month.
    • Effectively, use excel as a report-writing tool.

    •We'd prefer NOT TO USE proprietary or expensive report-writing tools at this phase, although we would consider using something like Jcharts, if it is effective & supportable.. & Excel

    http://www.jfree.org/jfreechart/
    http://www.jfree.org/eastwood/

    • We might also consider some sort of OLAP tool with Excel– so it's easy for us to modify or create new reports against the database

    DELIVERY TIME FRAME: WITHIN NEXT 2 WEEKS (by early – mid August.)
    BUDGET: TBC

    NOTE:

    This first phase of the project is relatively small & simple & the success of that will determine whether we do the 2nd & 3rd phase with the service provider

    We are a java house & would prefer any development to happen in Java , AJAX etc.

    We are also Pro-Google and would want to use Google API's wherever possible.

    Non-negotiable technologies:

    • Google Analytics as bulk of source data
    • Java (wherever possible)
    • Standard Google API's, wherever possible (Google Charts , Adwords API etc)
    • Google Webmaster tools & its rudimentary API

    Option of using Excel (possibly with an OLAP tool or similar) to generate reports from the database ?

    We've done some research on this (we'd normally dev in-house - but we have too much client work at present) & can point you in the direction of what tools/API alternatives etc to use.

    If you've worked with XML, databases, API's & excel before
    this should be a fairly quick & easy...

    Happy Bidding

    Job Type:


    View Message Board for this Project Messages Posted: 26


    PROJECT BIDS
    Programmers Bid Delivery Time Time of Bid Rating  

    (7 bids have been placed. jferris has chosen to keep all bids for this project hidden.)


    Related Projects:
    Google Analytic Stat Retrieval SMS API platform Ebay api upload tool Script To Extract Adsense Link api programmer
    More...


    Copyright © 2001 - 2009
    ScriptLance is a trade-mark of
    R3N3 International Inc
    Bookmark and Share
    Site MapRSSPrivacy PolicyTermsReport ViolationsAffiliatesFAQForumContact Support
    Web Design by: DevFly.com