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.

1. Start by navigating to the Social Wall section and initiating a report creation.

2. 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.

3. Specify the date range for which the Social Wall data should be extracted.

4. 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. 
     ​

5. Generate and download the report.

How to add data from one tab to another?

Use the VLOOKUP Formula

1. Open the spreadsheet in Excel or Google Sheets.

2. 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

1. Select all data.

2. Click on Insert > Pivot table.

3. Add the Fields in the Rows and Values.

4. Sort the Rows by Count.

5. 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 support@actimo.com.