Site Home  »  Zoho Reports for Google Apps

Zoho Reports for Google Apps

Tags:  

Zoho Reports for Google Apps



Zoho Reports for Google Apps is the integration of Zoho Reports service into the Google Apps Marketplace that enables easy access for Google Apps users to the powerful Online Reporting & Business Intelligence service of Zoho Reports. As a Google Apps user, you can easily install Zoho Reports service into your organization's Google Apps account and quickly start analyzing your business data to get real insights and for informed decision-making. You can also easily create and share reports & dashboards collaboratively using an intuitive drag-and-drop interface.

Key Features of this Integration

  • Single Sign-on with Google Apps: The Single Sign-on capability lets you to sign in to Zoho Reports using your Google Apps Credentials (you can also sign in using your Google ID). You can also access Zoho Reports easily from Google Apps universal navigation
  • Import Google Docs spreadsheets: You can easily import data from your spreadsheets in your Google Docs account into Zoho Reports for powerful analysis and reporting.
  • Share reports with Google Apps Users: You can easily share all the reports & dashboards you create in Zoho Reports with your organization's Google Apps users and your personal Gmail Contacts. 

Benefits

  • No Upfront Cost: Being a hosted Reporting & BI service, you pay as you go (affordable monthly subscriptions). No high upfront cost like perpetual license fees, buying of separate hardware & software etc.,
  • Easy Set Up / Fast Implementation: Having your own BI implementation will take months to set up. With Zoho Reports, you just sign in, import or push your data from multiple sources and generate reports immediately.
  • Highly Collaborative: Sharing, collaboration and publishing are inbuilt in Zoho Reports. No more emailing of reports as attachments.

Other Key Features

  • Upload Any Data: In addition to Google Docs spreadsheets, you can upload any tabular data (CSV, TSV, XLS or HTML files). You can add data directly too, using a 'spreadsheet-like' interface.
  • Push Data to Zoho Reports from your applications: Push data from your hosted or in-house (behind firewall) business applications and databases for reporting and analysis. Connect to SQL Server, Oracle, Sybase, MySQL and MS Access databases to fetch and upload data into Zoho Reports. Also setup scheduled automatic periodic uploads/synchronization
  • Visually Analyze Data: Visually analyze and build insightful reports and dashboards with an easy to use drag-and-drop interface. No IT help required!     
  • Wide range of Reporting components: Use a wide variety of charts, pivot tables and tabular view components to build insightful reports and dashboards.
  • Collaborative Analysis: Data and reports can be shared easily to any user (in addition to Google Apps users). Develop reports together with your colleagues. Share them with each other for better decision making.
  • Embed Reports Anywhere: Embed your reports and dashboards across websites (including your iGoogle pages), blogs and applications for wider consumption.
  • Query with SQL: Create powerful and flexible reports with SQL Queries written in any database dialect/syntax you know.
  • Highly Secure: Governed by strong Zoho Security Practices, including support for a secure encrypted connection.

Slideshow - How to use 'Zoho Reports for Google Apps'

FAQ

1. Who can add 'Zoho Reports for Google Apps' into the Google Apps account?
Only Administrators of Google Apps accounts can add 'Zoho Reports for Google Apps' service into their account.

2. How do I add Zoho Reports to my Google Apps account?
If you are an Administrator of a Google Apps account, just follow these steps:
  1. Login to your Google Apps account
  2. From your Dashboard, click the Add more services link. This will take you to the services page
  3. On the services page, click the Shop the marketplace link. This will take you to the Google Apps Marketplace
  4. Search for Zoho Reports and go to the Zoho Reports listing page 
  5. Click the Add it now button at the top-right
  6. Enter your domain name and activate Zoho Reports for your Google Apps domain

You and your Google Apps users will now be able to access Zoho Reports from Google's universal navigation bar. Also checkout this video and slideshow for more details.

3. How do I add my Google Apps users to Zoho Reports? [or]
How do I make my org's Google Apps users access Zoho Reports from our Google Apps account? [or]
How do I share the data and reports that I create in Zoho Reports to my Google App users?
As a Google Apps Administrator, add Zoho Reports to your Google Apps domain as described in Question 1. All Google Apps users in your domain can now access Zoho Reports from their Google Apps universal navigation bar. For making them access the data, reports and dashboards created in Zoho Reports, please follow the below steps:

  1. Click the database you want to share. In the Explorer window that comes up, choose the views you want to share.
  2. Click on Share -> Share views to new users. 
  3. Click Add Users From -> My Google App Users 
  4. Choose the user email addresses you want to grant access to the specified database's views.
  5. The users you shared will now be able to access the specified database under their Shared To Me tab, when then login/access Zoho Reports.

You can read more about Sharing and Collaboration features in Zoho Reports from this help document.

In summary, you can enable your organization users to access the information in your (organization's) Zoho Reports account using the Sharing and Collaboration features offered by Zoho Reports.

4. Is it possible to link my existing Zoho (Reports) account to my Google Apps ID?
Yes, this is possible. You need to add your Google Apps email address as your Primary email address in Zoho Accounts. Please follow the below instructions,

  1. Login to Zoho accounts at http://accounts.zoho.com
  2. In the homepage, click on Email Address link
  3. In My Email address page, click on Edit link to change the primary email address
  4. Enter your Google Apps email address and your current password for Zoho.
  5. Click on Update.

 

Please note that the primary email address that you've previously added will now be listed as a secondary email address. 

5. How do I import the data in my Spreadsheets from my Google Docs account?

  1. Add Zoho Reports for Google Apps to your domain as described in Question 1
  2. Click the Import Excel, CSV, HTML, Google Docs link in the home page, after you login into Zoho Reports.
  3. In the dialog box that opens, give a suitable name to the database. For the File Type, choose Google Spreadsheets and click the Browse button
  4. Choose the spreadsheet you want to import and click the OK button
  5. Click the Next button and choose the specific sheet to be imported and click Next again
  6. Give an appropriate table name and choose the other parameters
  7. Click the Create button

Your Google spreadsheet data will now get imported into Zoho Reports. Read the document on Importing data into Zoho Reports for a detailed description of the Import process.

6. What are the types of data that I can import into Zoho Reports for doing my analysis?
As a Google Apps user, the obvious data that you should be importing into Zoho Reports will be your Google Docs spreadsheets. Refer to the above Question 5 for how to do this. Other than this, you can also import any data in tabular form. Be it flat files like Excel, CSV, HTML or data from your local databases like Oracle, SQL Server, Sybase, MySQL, MS Access etc., or from your applications. 

7. How much does Zoho Reports cost?
The pricing for Zoho Reports starts at $35/month (supports 5 users, 500,000 rows and unlimited reporting databases, reports & dashboards in the account). There are various plans ranging till $495/month (50 users, 25 million rows and unlimited reporting databases, reports & dashboards). There is an Always Free Plan ($0) targeted at small end reporting requirements (supports 2 users, 5 reporting databases and 100,000 rows in your account).

Zoho Reports also offers a Custom Plan to meet your business need.
Contact us with your custom needs at sales@zohocorp.com for the best price quote.
You can find more details about the various pricing plans offered by visiting http://zoho.com/reports/zohoreports-pricing.html

8. When I add 'Zoho Reports for Google Apps', what pricing plan will I be under?
When you first add Zoho Reports for Google Apps to your domain, by default you will be in the Professional Plus, 15-day trial plan. After 15 days, the Professional Plus plan will expire and your account will be downgraded to the Free plan.

9. How do I buy/subscribe to Zoho Reports paid plans?
Once you are logged in to Zoho Reports from your Google Apps Administrator account, follow the steps given below.

  1. Click on the Subscription link at the top
  2. You will be taken to Your Current Plan tab which lists the details of the plan you are currently subscribed to. By default, all Zoho Reports for Google Apps administrator accounts are subscribed to the 15-day Professional Plus trial
  3. Click on the Upgrade button or the Upgrade tab
  4. Choose the plan you want to upgrade, by clicking the Upgrade button shown corresponding to that plan
  5. In the Payment screen, choose any add-ons if required. Also choose your Payment mode (Monthly, Quarterly, Half-yearly and Yearly modes available)
  6. Provide your Credit Card Details
  7. Click on Proceed to purchase

If you want to stay in the same plan but want to purchase rows/users as add-ons, click on the Manage Your Plan button in Your Current Plan tab. In the next screen, choose the add-on options required and proceed from there.

10. What's coming next in Zoho Reports for Google Apps?
We have quite a few things planned. Some of them are,

  • Scheduled import of Google Docs spreadsheets
  • Importing and analyzing your Google Adwords data
  • Importing and analyzing your Google Analytics data

Some useful links for your reference:


For more questions and answers on Zoho Reports, visit our Zoho Reports FAQ page.

Post a comment

Your Name or E-mail ID (mandatory)


Note: Your comment will be published after approval of the owner.




 RSS of this page