Manual eva dashboards

QUICK START GUIDE

Learn the basics of how Data Studio works This document presents six key steps to quickly get started using Data Studio. Data Studio is a flexible tool with which the same results can be achieved in several different ways. The workflow described in this article is just a basic example.

1. START WITH A REPORT

Data Studio reports tell stories through data. These stories can be intended to persuade, provide valuable information, validate decisions, or promote change. A good report is one in which finding useful information is quick and easy.

1.1 KEEP CONTENT UP TO DATE

Report data is cached to improve performance. When all charts in a report are fetched from cache, a lightning bolt icon appears in the lower left corner. Report editors can refresh the cache by clicking the refresh data icon.

1.2 CHANGE THE PERIOD

Charts have different default periods depending on the data source they are based on. For example, Google Analytics charts show data from the last 28 days by default. The author of a report may have included a filter by period. In this case, you can use it to view a different period: the period control will apply to the entire report. All charts, including those containing date comparisons, will be subject to the new period that you have set.

1.3 REFINE THE VIEW DATA

Reports can include filters. A filter restricts the data that is displayed in the report and includes only the important dimensions.

1.4 TURN THE PAGE

Data Studio reports can have multiple pages. Use the Page menu or the page controls on the toolbar to navigate the report.

1.5 SHARE A REPORT

Use the File > Share menu option to invite other users to view or collaborate on a report. To share a report that someone else has created, you must get permission from the owner.

1.6 CUSTOMIZE THE REPORT

Use the menu option File > Create a copy ... to save a version that can be modified. The report editor must grant you edit permission to modify the copy. When you log into Data Studio, you will see the main page with the Reports tab selected. All the reports you have access to appear in the center of the screen. The plus (+) buttons allow you to create a new blank report or start with a predefined report template.

Create a report

You will then see the report editor, a blank canvas ready for you to tell your story through the data. In the upper left corner, click Select Report

Connect to data

A data source is a specific instance of a connection to your data. Data sources provide the structure (schema) of the fields that you and other report editors can use to create reports. When creating a report in Data Studio, you can add an existing data source or create one and add it. You can add as many data sources of any type to your reports as you need.

Connect to Analytics sample data

• In the Add data to report panel, click My data sources.
• Select the [Sample] Google Analytics Data data source.
• In the bottom right, click Add.
• The data source is added to your report.
• A table appears with fields from that data source.
• To change the table's data and style, use the properties panel on the right.
• To rename your report, in the top left, click Untitled Report and enter a new name.

Connect to your data

• In the Add data to report panel, click Connect to data.
• Select the kind of data this data source will provide, for example, Google Analytics or Sheets.
• If prompted, click Authorize to allow Data Studio to access your data on your behalf.
• Provide your account details.
• In the bottom right, click Add.
• A table appears with fields from that data source.
• To change the table's data and style, use the properties panel on the right.
• To rename your report, in the top left, click Untitled Report and enter a new name.

Data sources and connectors

Data sources use connectors to get data from a specific platform, system, or product. Free connectors created by Google allow you to access data from Google Sheets, Google Ads, Google Analytics, and other Google Marketing Platform products.

1.7 Add charts and controls to the report

• In the toolbar at the top of the editor, click Insert and select a chart, or select one from the toolbar.
• Select any of the available charts.
• Move and resize the chart, as desired.
• Add or change the dimensions and metrics by clicking the fields in the properties panel, or dragging and dropping them from the Available Fields panel (to the right of the properties panel).

2. OVERVIEW

A. conversations

Reference	Configuration	Screenshot
	Datasource: table session Date Range Dimension:: createDate(date) Dimension: createDate(Month Day) Metric: sessionCode (Conversations per day) Aggregation: Count Distinct Type: Number Comparison calculation: None Running calculation: None sessionCode (Accumulated Conversations) Aggregation: Count Distinct Comparison calculation: None Running calculation: None Sort: createDate - Ascending Default date range: Auto Filter: Create filter with the following parameters. Include botId Equal to (=) value: botId Interactions: check Apply Filter check Enable sorting

B. Average conversations per period

Reference	Configuration	Screenshot
	Datasource: table session Date Range Dimension: createDate(date) Metric: botId Default date range: Auto Filter: Create filter with the following parameters. Include botId Equal to (=) value: botId

C. Conversation ended in human transshipment

Reference	Configuration	Screenshot
	Datasource: select * from user_interaction where answerId in (select id from answer where name = value01 and botId=value02) Date Range Dimension: createDate(date) Metric: Record count Aggregation: auto Type: Number Comparison calculation: None Running calculation: None Default date range: Auto

D. Total conversations

Reference	Configuration	Screenshot
	Datasource: table session Date Range Dimension: createDate(date) Metric: botId Aggregation: Count Type: Number Comparison calculation: None Running calculation: None Default date range: Auto Filter: Create filter with the following parameters. Include botId Equal to (=) value: botId

E. Total messages received

Reference	Configuration	Screenshot
	Datasource: select usrint.id,sess.botId,sess.channelId,usrint.createDate,usrint.text,usrint.confidence from alvoradadb.user_interaction usrint, alvoradadb.session sess where usrint.sessionCode = sess.sessionCode and sess.botId=value01 Date Range Dimension: createDate(date) Metric: id Aggregation: Count Type: Number Comparison calculation: None Running calculation: None Default date range: Auto

F. Top Answers

Reference	Configuration	Screenshot
	Datasource: select an.name,an.description,ui.sessionCode,ui.createDate from alvoradadb.user_interaction ui, alvoradadb.answer an where ui.answerID = an.id and ui.answerId in ('values') Date Range Dimension: createDate(date) Dimension: description name Metric: name Aggregation: Count Type: Number Comparison calculation: None Running calculation: None description: Aggregation: Count Type: Percent Comparison calculation: Percent of total - Relative to corresponding data Running calculation: None Sort: description Aggregation: Count

G. Total messages per users(api calls)

Reference	Configuration	Screenshot
	Datasource: SELECT usrint.id, sess.botId, sess.channelId, usrint.createDate, usrint.text, usrint.confidence FROM alvoradadb.user_interaction usrint, alvoradadb.session sess where usrint.sessionCode = sess.sessionCode and usrint.userSent=1 and sess.botId=value Date Range Dimension: createDate(date) Metric: id Aggregation: Count Type: Number Comparison calculation: None Running calculation: None

H. Total messages per bot

Reference	Configuration	Screenshot
	Datasource: select ui.* from user_interaction as ui inner join session as s on ui.sessionCode = s.sessionCode where ui.id in (select ui.userSentIdfrom user_interaction as ui inner join session as s on ui.sessionCode = s.sessionCode where ui.answerId in(values) and s.botId = value01) order by ui.createDate desc Date Range Dimension: createDate(date) Dimension: createDate Type: Date Hour Minute text: Type: Text Sort: createDate(date)

I. Not Handle by bot

Reference	Configuration	Screenshot
	Datasource: select ui.* from user_interaction as ui inner join session as s on ui.sessionCode = s.sessionCode where ui.id in (select ui.userSentIdfrom user_interaction as ui inner join session as s on ui.sessionCode = s.sessionCode where ui.answerId in(values) and s.botId = value01) order by ui.createDate desc Date Range Dimension: createDate(date) Dimension: createDate Type: Date Hour Minute text: Type: Text Sort: createDate(date)

3. USERS

A. Total Users

Reference	Configuration	Screenshot
	Datasource: table sessions Date Range Dimension: createDate(date) Dimension: createDate (Month Day) Metric: userRef Aggregation: Count Type: Number Comparison calculation: None Running calculation: None Filter: Create filter with the following parameters. Include botId Equal to (=) value: botId

4. MESSAGES

A. Total per day

Reference	Configuration	Screenshot
	Datasource: select b.id, b.name, u.createdate fecha, day(u.createdate) dia, count(*) mensajesEnviados from user_interaction u ,session s , bot b where u.sessionCode = s.sessionCode and b.id = s.botId and u.userSent=1 and b.id =value group by b.id, dia order by b.name, fecha, dia Date Range Dimension: createDate(date) Dimension: createDate Metric: mensajesEnviados Agreggation: Sum Type: Number Comparison calculation: None Running calculation: None Sort: createDate

B. Total per week

Reference	Configuration	Screenshot
	Datasource: select b.id, b.name, u.createdate fecha, week(u.createdate) semana, count(*) mensajesEnviados from user_interaction u ,session s , bot b where u.sessionCode = s.sessionCode and b.id = s.botId and u.userSent=1 and b.id =value group by b.id, semana order by b.name, fecha, semana Date Range Dimension: createDate(date) Dimension: createDate Metric: mensajesEnviados Agreggation: Sum Type: Number Comparison calculation: None Running calculation: None Sort: createDate

C. Total per month

Reference	Configuration	Screenshot
	Datasource: select b.id, b.name, u.createdate fecha, month(u.createdate) mes, count(*) mensajesEnviados from user_interaction u ,session s , bot b where u.sessionCode = s.sessionCode and b.id = s.botId and u.userSent=1 and b.id =value group by b.id, mes order by b.name, fecha, mes Date Range Dimension: createDate(date) Dimension: createDate Metric: mensajesEnviados Agreggation: Sum Type: Number Comparison calculation: None Running calculation: None Sort: createDate

5. SATISFACTION SURVEY

A. Insatisfecho

Reference	Configuration	Screenshot
	Datasource: SELECT stf.sessionCode session,stf.evaluation evaluation,stf.userComments comments,stf.createDate createDate,sess.userRef IP,sess.locale locale FROM alvoradadb.satisfaction stf, alvoradadb.session sess where stf.sessionCode=sess.sessionCode and sess.botId=value01 and sess.channelID=value02 Date Range Dimension: createDate(date) Metric: Record count Filter: evaluation equal 01

B. Neutro

Reference	Configuration	Screenshot
	Datasource: SELECT stf.sessionCode session,stf.evaluation evaluation,stf.userComments comments,stf.createDate createDate,sess.userRef IP,sess.locale locale FROM alvoradadb.satisfaction stf, alvoradadb.session sess where stf.sessionCode=sess.sessionCode and sess.botId=value01 and sess.channelID=value02 Date Range Dimension: createDate(date) Metric: Record count Filter: evaluation equal 02

C. Satisfecho

Reference	Configuration	Screenshot
	Datasource: SELECT stf.sessionCode session,stf.evaluation evaluation,stf.userComments comments,stf.createDate createDate,sess.userRef IP,sess.locale locale FROM alvoradadb.satisfaction stf, alvoradadb.session sess where stf.sessionCode=sess.sessionCode and sess.botId=value01 and sess.channelID=value02 Metric: Record count Filter: evaluation equal 03

5. QUESTIONS

Reference	Configuration	Screenshot
	Datasource: select count(*) cantidad, '75% - 100%' tag, createDate from (select text,createDate, avg(confidence) asertiveness from (select text, confidence,u.createDate from user_interaction u ,session s , bot b where u.sessionCode = s.sessionCode and b.id = s.botId and b.id=value and confidence is not null and text is not null) asd group by text order by text desc ) C1 where asertiveness <= 1 and asertiveness > 0.75 union all select count(*) cantidad, '50% - 75%' tag, createDate from (select text,createDate, avg(confidence) asertiveness from (select text, confidence,u.createDate from user_interaction u ,session s , bot b where u.sessionCode = s.sessionCode and b.id = s.botId and b.id=value and confidence is not null and text is not null) asd group by text order by text desc ) C2 where asertiveness <= 0.75 and asertiveness > 0.5 union all select count(*) cantidad, '25% - 50%' tag, createDate from (select text,createDate, avg(confidence) asertiveness from (select text, confidence,u.createDate from user_interaction u ,session s , bot b where u.sessionCode = s.sessionCode and b.id = s.botId and b.id=value and confidence is not null and text is not null) asd group by text order by text desc) C3 where asertiveness <= 0.5 and asertiveness > 0.25 union all select count(*) cantidad, ' 0% - 25%' tag, createDate from (select text,createDate, avg(confidence) asertiveness from (select text, confidence,u.createDate from user_interaction u ,session s , bot b where u.sessionCode = s.sessionCode and b.id = s.botId and b.id=value and confidence is not null and text is not null) asd group by text order by text desc ) C4 where asertiveness < = 0.25 and asertiveness > 0 Dimension: TAG Type: Number Metric: cantidad Aggregation: Sum Sort: cantidad Aggregation: Sum