Data Feeds provide analytics data on objects within a digital workplace. Objects are things such as pages, spaces, channels, content, and users. Data on these objects exist in separate tables. Combining these tables is a large part of creating your own custom reports.
Create custom reports from Data Feeds using analytics tools that support Open Data Protocol (OData v4). OData v4 is a RESTful data protocol that returns JavaScript Object Notation (JSON) formatted data.
Sections in this article:
- Access to Data Feeds
- Frequency of updates
- Connecting to Data Feeds
- Data Feeds table prefixes
- Data Feed's URL
Access to Data Feeds
The following Users can access Data Feeds:
- Site Administrators
- Enterprise Administrators
- Users with the Access Analytics Role
This connection requires the use of your Igloo Authentication credentials.
Frequency of updates
Data Feeds update once per day Monday to Friday. These updates occur early in the morning, typically between 2-7 AM (EST).
Connecting to Data Feeds
You can also view Data Feeds using a web browser (see the Data Feed's URL section below).
Data Feeds table prefixes
Data Feeds table names contain prefixes that describe the type of data they contain. These prefixes are:
- Rpt: Report tables aggregate data on activity within a digital workplace.
- Top/Member: Workplace Analytics tables contain data for the Workplace Analytics dashboard.
- d: Dimension tables describe objects.
- f: Fact tables describe specific actions on objects.
- fl: Factless tables describe the state of objects.
- lkp: Lookup tables map a value from another table to a specific value.
Data Feed's URL
The root OData URL will take the following form:
https://{your community domain}/odata
Append a table’s name to this URL to access it. Table names can be found in the Data Feeds tables article. For example, use dContentBlog to return a table that includes all Blog articles in a digital workplace.
https://{your community domain}/odata/dContentBlog
Whether you connect to the base URL, or a URL of a specific table, depends on your analytics application. Tools such as Excel and Power BI connect to the root URL and provide the ability to browse tables. Other tools such as DOMO use the URL of specific tables.