Zoho Reports

More Power to the Math Wizard in You – Aggregate Formulas

| By Arvind
0

Zoho Reports has long supported custom formulas, where you can define your own formula that involves two or more columns. These formulas are applied at the row level. Say there is Column A and Column B and you want a Column C which does string concatenation (combining texts). You can have a formula column defined as
concat(Column A, Column B).

There are scenarios where aggregation formulas (sum, avg, min, max etc) are to be applied at the column level. Here’s a real world example. In Google Adwords, Click Through Rate (CTR) is defined as (No. of Clicks)/(No. of Impressions). If you just go by averaging the CTR as Avg(CTR), you will end up with the wrong average value for the month, quarter or year. But if you let Zoho Reports know that CTR is actually sum(Clicks)/sum(Impressions) by using the Aggregate Formula, then you’ll arrive at the right values.…


CONTINUE READING

Analyse your Business Reports – Now in 9 Languages!

| By Arvind
4

是否需要深入查看您的销售人数？
Besoin d'informations plus détaillées sur vos données Google Adwords?
Möchten Sie analysieren, wie sich Ihr Umsatz nach Produkten/Regionen entwickelt hat?
Mi chiedevo come stia andando ciascuna delle sue campagne di marketing?
サイト・トラフィックの分析が必要ではありませんか？
Gostaria de acompanhar continuamente a métrica de desempenho dos seus colaboradores?
¿Necesita un análisis profundo de los indicadores de sus finanzas?

We humans usually tend to think and question in our native language. And then we convert those thoughts to the language we want to speak in. As a non-native speaker of English, I hear this advice quite often:

If you want to master English, think in English.

…


CONTINUE READING

TeamSupport.com integrates Zoho Reports

| By Arvind
0

TeamSupport.com, provider of web-based customer support and help desk software solutions had earlier integrated with Zoho CRM. Now, TeamSupport.com’s integrated with Zoho Reports too. With this integration you can create custom reports and dashboards on a variety of TeamSupport data – tickets, ticket status history, portal logins, KB traffic and chat requests – and share them throughout your organization.

Read more about the TeamSupport.com – Zoho Reports integration.

If you are an Independent Software Vendor (ISV) like TeamSupport, you too can take advantage of Zoho Reports’ reporting capabilities, and make it the reporting module of your product/service. We offer a white label solution too that you can use for making your own private labeled (re-branded) reporting solution for your clients.…


CONTINUE READING

Zoho Reports: Email your Business Dashboards as PDF

| By Arvind
0

Creating business dashboards have always been easy with Zoho Reports. Dashboards thus created can be shared and accessed from web URLs. But you may have clients (or colleagues) who would like to view the dashboards as PDF files. Now, how nice would it be if your dashboards were to be emailed as beautifully formatted PDFs with your own company’s logo?

Till recently, it was possible only for individual reports to be exported/mailed as PDF. Now, dashboards can be exported/emailed as PDF too.

You can even schedule the dashboard PDF files to be emailed at regular intervals using the scheduled emailing of reports feature.

Note: The PDF generation is optimized for charts. Just make sure that the dashboards you convert as PDF don’t contain large data tables.…


CONTINUE READING

Case Study: Measuring Marketing Effectiveness with Zoho Reports

| By Arvind
3

An important part of every marketer’s job is to know how each of his/her campaigns are performing. “What’s the ROI (return on investment) from this campaign?” is a question in every marketer’s mind. Based on that, the marketer proceeds with making decisions on which campaigns to continue and which ones to stop.


Chris Swanson is the owner of BMA Marketing, a firm that manages paper coupon programs for bowling centers. As a marketer, Chris was interested in knowing the returns each of his campaigns generate. He not only studies the returns, but also shares the info transparently with all his clients. This is crucial for his clients as they get to know how the coupon campaign that Chris is running for them is performing.…


CONTINUE READING

The Smart Way to Share your Business Reports

| By Arvind
0

Consider this. You have created a beautiful monthly financial report using Zoho Reports, that you need to share with your CEO and the various business heads of regions. The CEO would like to see the data across regions while the regional heads would like to see the data from his/her own region alone. Previously, you would have made multiple copies of the report you created and shared a report each, to your CEO and to each business head. Now, this has been made simpler. You can apply filter criteria for each of the users you are sharing the report with and achieve it all with just a single report. This brings in two big benefits:

  • Avoid unnecessary crowding of reports due to duplication
  • More fine-grained control over data that is being shared

‘Filter Criteria‘ is accessible from the Sharing wizard.…


CONTINUE READING

Visualize your data better: Conditional formatting and more!

| By Arvind
7

A chart makes it easy to see a trend over time or to compare how different figures stack up. To achieve a similar effect with plain tabular data is difficult, but not impossible! That’s what conditional formatting in Zoho Reports achieves.


Conditional Formatting of Tabular Data

You often see conditional formatting applied to financial data, where positive values are typically in green and negative values in red. A similar example below, where we show the best ‘CTR’s in green, the bad ones in red and the intermediate ones in yellow. You can apply color to the cell background and to the font (‘Clicks’ column in the below example).

Definitely easy to identify outliers and easy to comprehend, right?…


CONTINUE READING