Last updated: 11.06.2021 by Natalia Ponomareva
Estimated read time: 3 - 4 minutes
How to create a report?
Downloading your data from the Social Wall is a simple process.
Start by navigating to the Social Wall section and initiating a report creation.
Decide whether to create a report for the current workspace or all workspaces. In this article, the focus is on creating a report for a single workspace.
Specify the date range for which the Social Wall data should be extracted.
Select the data to be included in the report:
For Company Groups data, it's common to select all available data.
For Contacts data, you can select the data you will need.
Generate and download the report.
How to add data from one tab to another?
Use the VLOOKUP Formula
Open the spreadsheet in Excel or Google Sheets.
Find the two tabs: 'Company groups', and 'Contacts'.
The 'Company Groups' tab contains details of contact activity.
The 'Contacts tab' includes the contact details, such as name, email address, country, department, etc.
To link the activity type to a specific contact, we'll use the Contact ID column.
Create the columns you would like to move on to the 'Company groups' tab.
Use the VLOOKUP formula to move the contact information from the 'Contacts' tab to the "Company Groups" tab based on matching 'Contact ID' values.
=VLOOKUP(lookup_value, table_array, column_index_number, FALSE)
lookup_value = Contact ID field
table_array = the range on the 'Contacts' tab
column_index_number = the column number in the range selected
FALSE = FALSE or 0
Use the same formula until you move all the contact information needed to the 'Company groups' tab.
How to summarise the data?
Create Pivot Tables
Select all data.
Click on Insert > Pivot table.
Add the Fields in the Rows and Values.
Sort the Rows by Count.
Add columns to see the number of times each user commented, posted, reacted or replied on the Social Wall.
We hope you found it useful! Let us know if you have any questions!
Tags: Article, SEO,Social wall, social, engagement, Q&A, private groups, company groups, private
Note: If you do not have Social Wall, please reach out to support via our support chat or by writing to [email protected].