Till now, project managers using Zoho Projects had access to limited reporting options – Gantt and resource utilization charts. Not anymore. Today, we are glad to announce the Zoho Projects Advanced Analytics Add-on, powered by Zoho Reports. Project managers can use this analytics add-on to know & track their key project metrics, and get lots of insights from their projects data.
Recently, I came across a wonderful article shared by a friend on 6 personality and work environment types. The work environments recommended according to personality types made a lot of sense.. I found myself mentally screening myself and other friends, if we were in the right jobs.. Most of us, thankfully, are.
What also set me thinking was, is it possible for one person to assimilate in himself all the personality types and thus be suitable for any work environment?
The answer stared at me like a writing on the wall. YES. If we consider each personality type to be a hat, wearing a different hat at different times is what we all do. Only we don’t do it consciously. And more importantly we are not forced to do it. But what about those who do it consciously and with elan? Who you ask.
A dashboard in Zoho Reports is created by dragging and dropping multiple reports on a single page. Till now, we had one/two column layout options with fixed width & height. We have brought in greater flexibility to the layout now. You can now resize each of the embedded reports within a dashboard. This makes your dashboard look prettier, allotting more space for longer/wider reports, avoiding unnecessary blank spaces where you need to have shorter/smaller reports etc.
Resizing the reports is easy. Go to the Edit Design mode, hover your mouse over the report’s borders that need to be resized and drag as needed.
Charts – More Sorting Options
We have added two more sorting options in Charts, important ones at that. When your chart contains a String or Date column in one axis and Numeric column in the other, you can order the values in String/Date column based on the numeric data in either ascending or descending order.
New options that have been added are:
Options when Y-axis has numeric column and X-axis has String/Date column:
By Y-value – Ascending: Sorts values in X-axis based on Y-values, ordered from smallest to largest
By Y-value – Descending: Sorts values in X-axis based on Y-values, ordered from largest to smallest
Options when X-axis has numeric column and Y-axis has String/Date column:
By X-value – Ascending: Sorts values in Y-axis based on X-values, ordered from smallest to largest
By X-value – Descending: Sorts values in Y-axis based on X-values, ordered from largest to smallest
Try these new features in Zoho Reports and let us know how it goes.
Globo, which is currently the largest commercial television network of Latin America and the third largest in the world (after CBS and NBC), uses Zoho Reports to analyze viewership data about videos and TV shows in its TV and cable TV divisions. Globo is watched by an estimated 120 million people daily.
Here’s what Alexandre Oppermann, Globo’s Business Intelligence Co-ordinator – Web Analytics, had to say about Zoho Reports:
Using Zoho Reports, we generate reports and dashboards that reveal the daily and monthly views of each show and video in its TV and cable TV divisions. Currently, Globo has 40 people actively using Zoho Reports to report against 8.5 million rows of data. And this data set is growing continuously as we aggregate more data everyday.
Compared to our earlier solutions, Zoho Reports gives us flexibility. We can give access to all the data and reports, and our users can do whatever they want. A lot of manual work that we were doing before, we aren’t doing anymore. And that’s increased the productivity of everyone, especially us.
Read the full story about how Globo is using Zoho Reports
Analyzing the various data that your business generates will give you good insights about where you stand. The metrics can be from a wide spectrum. Say, your sales across different regions, the money you spend on different marketing channels and the subsequent returns, the number of support tickets you receive, the number of calls your support reps receive/make, the traffic that your website pages get etc. Zoho Reports, as a business intelligence and reporting service online helps you plot all such data in a graphical manner, makes it easy for you to spot trends and take action wherever necessary. Sign up for Zoho Reports now.
Google Apps marketplace celebrated its
first anniversary last week. And at Zoho, we have had much fun putting our services out there for the past one year. It all started with Zoho CRM and we now have 5 Zoho apps in Google Apps Marketplace. In keeping with the
promise we made last week, we’re kick starting the unveiling of 5 more Zoho apps for Google Apps marketplace today! The star of today’s announcement is Zoho Reports.
Zoho Reports is now available for users in Google Apps marketplace.
Zoho Reports is a powerful online reporting and business intelligence service that helps users get new insights on their business information. One can easily create and share powerful reports and dashboards in minutes with no professional help.
Zoho Reports – Google Apps integration points
Zoho Reports has several integration points with Google products. Here are some highlights:
Single Sign On (SSO)
If you’re a domain admin for Google Apps, you’ll now have an option to add Zoho Reports to your domain through
Shop the marketplace link in Google Apps. Once the app gets added to the domain, all the users within the domain will have access to Zoho Reports through Google’s Universal Navigation bar.
Clicking on the app from the universal navigation bar opens Zoho Reports in a new browser tab. The single sign on lets the users to directly login into Zoho Reports, thereby streamlining the workflow for both Google Apps and Zoho Reports.
Import Google Spreadsheets into Zoho Reports for analysis and reporting
Zoho Reports integrates with Google Docs too. Google Apps users will now be able to analyze the data in their Google spreadsheets using the powerful reporting and analysis features in Zoho Reports.
Share the reports to your Google Contacts/Org users
The users can then go on to share the reports & dashboards created in Zoho Reports to their Google Apps domain users or Google Contacts.
Publish Zoho Reports gadget
And what’s more, it is possible to publish the reports & dashboard you create into iGoogle too.
While the points above summarize the integration in a nutshell, do take a look at the video and the Zoho Show slideshow below that explain this integration in detail between Zoho Reports and Google Apps.
Try Zoho Reports for Google Apps now from Google Apps Marketplace. We love your feedback, keep it coming!
Our special thanks to the Google Apps team for staying with us right through this integration!
To learn more about Zoho Reports for Google Apps, check out http://www.zoho.com/reports/zoho-reports-for-google-apps.html and for our existing Zoho – Google Apps integrations, check out
http://zoho.com/google-apps. And don’t forget to mark your calendars – there are four more Zoho apps on their way to Google Apps marketplace. Stay tuned till next Tuesday
We’re happy to announce that Zoho Reports, our online business intelligence & reporting tool has graduated out of beta today. Zoho Reports helps businesses make better sense of their data by providing useful insights through powerful reporting and analytics, which
transforms to informed decision making. It achieves this through an impressive set of capabilities that lets users easily perform a variety of tasks, such as:
- Upload any data. Zoho Reports lets users securely upload spreadsheets and tabular data such as .CSV, .TSV, .XLS or .HTML files. Of course, users can also add
data directly using the spreadsheet-like interface.
- Push data from any application. Zoho Reports works with hosted and traditional (in-house, behind a firewall) business applications and databases for reporting and analysis. Users can fetch and upload data into Zoho Reports from Oracle, SQL Server, MySQL and MS Access databases. Automatic periodic uploads/synchronization is also supported.
- Drag-and-Drop interface. Users can visually analyze and build insightful reports and dashboards using a drag-and-drop interface, all by themselves.
- Use a variety of reporting components. Users have access to a wide range of reporting components, including charts, pivot tables, tabular view and dashboard components that ensure
the most insightful report building and analysis possible.
- Query with SQL. Zoho Reports lets users create powerful and flexible reports with SQL queries written in any database dialect/syntax.
- Collaborative analysis. Users can develop reports together, enabling informed, collaborative business decisions. Reports can easily be shared with fine-grained
access control, giving the report owner complete control over data and reports being shared.
- Embed reports anywhere. Zoho Reports encourages widespread consumption of business intelligence by enabling users to embed reports in websites, intranets, blogs,
applications, iGoogle and Microsoft SharePoint Server.
- Secure all data and reports. Zoho Reports maintains a highly secure environment for all user data. Access to data and reports is secured with a proper user name and password, via HTTPS (SSL connection) network connectivity. All data and reports are hosted in highly secure datacenters, which offer redundancy, backup and continuity.
New functionalities in this release include,
- Dashboard view. Users can collate similar reports and view them all on a single page. For instance, a dashboard page consisting of 10 reports can be displayed in a “5×2” (five rows and two columns) format.
- iGoogle gadget. Users can embed the gadget version of Zoho Reports in their iGoogle home page, giving them ready access to their reports and dashboards from their iGoogle page.
Like other Zoho products, Zoho Reports offers a generous free edition. And the pricing plans start at $15 per month (for 250,000 rows and 2 users). Take a look at Zoho Reports. We hope you’ll like it.
Google Adwords has become a very important advertising medium for all advertisers & marketing professionals. As one using Google Adwords, you should be analyzing your various campaigns, adgroups, ads etc constantly. But the readymade reports provided by Google Adwords are pretty rudimentary and have the below disadvantages.
- There aren’t actually many report options. The report consists of rows of data which you can see as HTML or export as a csv/xls files.
- The only chart option given plots only one metric (CPM, Clicks, CTR etc) at a time.
- The chart and the data are separate and this means you can’t drill down a chart to see the underlying data.
- The reports don’t allow you to compare how two different campaigns are performing. Or how a campaign in July 2009 (current month) performed as against June 2009 (previous month) or July 2008 (same month, previous year).
- The charts cannot be saved for referencing anytime later.
- The charts cannot be shared or collaborated upon online.
With Zoho Reports, you can do a lot of analysis with the data provided by Google Adwords. Multiple metrics can be plotted and studied. Comparisons between campaigns can be done and a campaign can be compared to how it had performed across different time lines (daily, weekly, monthly, quarterly or even yearly). Based on such analysis, you can take actions to reduce costs and get higher returns for the money you spend on Google Adwords.
Let’s see in this post how Zoho Reports can help you analyze various campaigns & allow you to get the maximum bang for your buck (lower costs, more conversions etc). Embedded below are charts with real data from a Google Adwords account that we have set up. The campaigns have been renamed generically as for mountain bikes. There are 3 campaigns being run, one in the US, one in Europe and one comprising of other countries in Australasia and Africa since Jan 2007.
The above chart shows the avg cost / conversion trends across the various campaigns.
This chart shows how the CTR has varied over the months for the three campaigns. The above two examples compare how various campaigns are performing with respect to each other. We can also compare how a campaign’s various metrics have performed over time.
The above chart plots the impressions vs clicks for the Europe campaign over the past year. If pretty charts aren’t your cup of tea, you can make pivot tables. Like this one for example, which plots the quarterly conversions for the campaigns.
The embedded reports above are just a few samples. The original database with a slew of reports for the three example campaigns are available here – http://reports.zoho.com/ZDBDataSheetView.cc?DBID=4000000163350. You can play around the data, create as many reports as you want and see for yourselves how flexible and powerful your Adwords Campaign data
becomes, when using the right business intelligence tool.
Most importantly, all these set of campaign-level reports are readily available for your Google Adword analysis. All you have to do is to follow the easy steps as mentioned in this page and you can have the same reports as above for your Google Adwords campaigns as well. We are planning to make this easier further by providing a direct Zoho Reports connector to your Google Adwords account soon.
Next, we’ll see with examples how to analyze your Google Adwords campaigns at the Adgroups level.