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:
- Who can do this?
- Frequency of updates
- Connect to Data Feeds
- Data Feeds table prefixes
- Data Feed's URL
Who can do this?
- Enterprise Administrators
- Workplace Administrators
- Site Administrators
- Members of groups with the Access Analytics role
This connection requires the use of your Igloo Authentication credentials.
Frequency of updates
Data Feeds update once daily, Monday through Friday. These updates occur early in the morning, typically between 2 and 7 AM (EST).
Connect to Data Feeds
You can use the following software to connect to your 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
To navigate to your digital workplace's Data Feeds, 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 Data Feeds tables. 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 the URL of a specific table depends on your analytics application. Tools such as Excel and Power BI connect to the root URL and allow you to browse tables. Other tools, such as DOMO, use the URL of specific tables.