Populate Data in Field Views- User Info Report
2 minute read
Intermediate
Flat fields table contain contact specific data based on the data points an Organisation has defined in their system. Organisation needs to have enough contact fields information available to visualise this report.
Prerequisites
How to verify if you have enough contact fields information available.
1 . Go to Big query and execute the below queries to check if there is enough data in contacts and messages tables.
Note - beginner-290513.917777711114 needs to be changed with your product ID
SELECT * FROM beginner-290513.917777711114.contactsLIMIT 1000
SELECT * FROM beginner-290513.917777711114.messages LIMIT 1000
2 . Get the data in your reports for Contacts and Messages tables. Follow the steps from 1 to 6 in Integrate DataStudio to create visualisations & reports to get the data for Contacts and Messages tables.
Steps to configure your Field Views (User info) report.
1 . Select Field View (User Info) report from the dropdown.
2 . You may see error in the report chart section.
3 . Click on Resources >> Manage added data source
4 . Click on Edit on Flat fields section.
5 . Click on Edit connections
6 . Click on My Projects. Click your project . Click on your data set. Then click on flat_fields table.
7 . It will open up Big Query. select flat_field table from the list of tables.
8 . Click on Invoke store procedure
9 . Click on Run button
10 . Click on Reconnect
11 . Click on Done
12 . Now data will be updated in Flat_fields.
Plot the data in the charts
1 . Click on the chat where you want to plot the data from Flat fields.
2 . Click on Data link in right pane.
3 . Notice under Dimension section it says Invalid dimension
4 . Drag the data field from the Available fields section to the dimension section.
5 . And you will be able to see the data in the charts.
