SEMpdx Search Marketing Forum

Hello,

As a marketing/SEO professional, you would want to spend your time analyzing Google Analytics/AdWords data rather than gathering it! Therefore, I would like to take this opportunity to introduce you to an automated solution for the Google Analytics Reporting developed by DEFTeam solutions utilizing the “best of breed” Business Intelligence tools (Pentaho and PrismCubed), without your getting into the complications of BI.

This turnkey, 100% customizable solution can help you automate the complete data downloading of the required Dimensions/Metrics of concerned GA/UA id’s and then producing reporting, dashboard and analytics with slice/dice and drill down/up features and updating them at regular intervals. So basically an updated report/dashboard can be provided to your desktop at your defined frequency!

The solution uses standard BI practices of pulling data by writing ETLs (Extract Transform and Load), creating a staging area in a standard RDBMS, creating a Data Model and finally creating the required UI (reports etc.). The solution has following salient features:

• A 100% custom developed solution based upon your needs using a proven BI platform
• Automatically downloading of respective data and refreshing of reports at user defined intervals.
• Allows the flexibility of adding data from other sources as well.
• Automatic traffic lighting alerts based upon defined criteria.
• Automatic emailing of reports (bursting) to concerned users.
• Role based security allows only authorized persons to view reports.
• Windows thick client and/or browser based zero foot print solution – with options to download reports in .pdf, Excel formats.
• Scalable solution – grows with your reporting requirements.
• Various pricing models from “per report basis” to complete solution ownership and deployment at your site are available!

In case you are interested in this solution, we will be happy to send you more details.

Looking forward to hearing soon from you.

Best Regards,

Rajendra.k
krajendra@defteam.com

DEFTeam Solutions, Inc.

Post edited 5:00 am – September 13, 2010 by rajendra
Post edited 5:16 am – September 13, 2010 by rajendra
Post edited 5:38 am – September 13, 2010 by rajendra

Hi Scott,

Thanks for approving the post! I will be glad to provide more details. Here are some:

The solution is custom developed based upon the reporting requirements of each client and accordingly we download the data for the concerned Dimension/Metrics. Once the data mart is created, we can use any front end reporting tool to create the reports/visualization.

To see a complete Pentaho based solution, pl. check out a tech cast that is available at one of our press releases that is published on the Pentaho website:

http://www.pentaho.com/news/re…..ration.php

Next you can download another version of the solution that utilizes PrismCubed as a front end:

http://www.defteam.com/GAAR.pdf

We can use other front end tools like Tableau, QlikView etc. based upon what tool is available with the client organization.

In terms of delivery model, we can offer you a solution in multiple models.

The first could be on “per report” based service where DEFTeam will run it as a SAAS and provide you the report(s). In this case the client does not need to bother about any software licensing/consulting cost etc. and DEFTeam will provide you per report based cost. You will be getting a pdf version of the reports on defined intervals.

The second model could be that we run the solution on a cloud instance with complete access to the client but DEFTeam manages the solution.

The other could be that we run the solution at your site wherein you will own the licenses etc.

If you would like to see this solution, we will be glad to do a WebEx demo for you.

Pl. do let me know if you need any further information.

Regards

Rajendra
krajendra@defteam.com

http://www.defteam.com