Skip to main content

Capturing Data for Reports & Analytics

2 minute read                                                                                                                 Intermediate

While communicating with contacts, data points can be collected and saved. Once done, customised reports can be created from the saved data.

Prerequisites

Below is a step by step process to capture the data first.

  1. Gather the data points from flows.
  2. Save the data with the “Update Contact” function.
  3. Check the data field value in BigQuery.
  4. Generate chart reports in DataStudio.

Detailed steps to generate the reports.

  1. Use Wait for response function in flows to gather the data points. Example: capture name of the contact using contact_name field.

image

  1. Save the data with the Update Contact node. Use this variable format for the data point _@results.fieldname.input_ where the fieldname part can change as per your data point. For simplicity, make field name same as Result Name from the above image.

image

image

  1. Access the field values using variables such as @contact.fields.fieldname

image

  1. Access BigQuery from https://console.cloud.google.com/

image

  1. Select your project from the dropdown.

image

7 . From the left menu, click on triangle next to your project name . Then click on the triangle next to your BOT number **** and click on the Contacts label.

image

8 . Click on the Preview sub-label to view the data in tabular format.

image

9 . Verify the data in your Big Query

image

image

10 . From the Export dropdown on the right, click on Explore with Data Studio option.

image

11 . Google Studio ( https://datastudio.google.com/ ) will open up in another tab.

image

12 . Follow the steps in the below document to create reports.