• Jive Databases in pgAdmin

    A few tips to get things out of the core application system database and the ActivityEngine database. Things that are not available in the Analytics database   For pgAdmin installation guide, follow pages 2-8 her...
    ReeceO
    last modified by ReeceO
  • Database vs CMR Activity Count

    I am trying to get a report of all the top viewed content in our community. Unfortunately, I can not go through CMR, because the Top Content does not include System Blogs, and one of our most widely read blogs is a Sy...
    Erin Clements
    last modified by Erin Clements
  • Is an activity record created when a question is marked as Assumed Answered?

    I'm trying to identify unanswered questions created in the last week. I'm using Data Export v2 and specify certain fields to be returned but with only a date filter (after) to get the last 7 days.   I have a que...
    Tim Reid
    created by Tim Reid
  • Finding the list of group created, date created, and creator

    I think I'm in need of being pointed in the right direction.  I started with the activity_fact table figuring I could query  for create events where the direct object type was a social group and then go find...
    jemjanik
    last modified by jemjanik
  • Identifying Hot Topics

    I'd like to identify the "hottest topics" among recent activity across all the places in our community using data from Data Export. It is possible to retrieve a list of unanswered questions in the last week, for examp...
    Tim Reid
    last modified by Tim Reid
  • "Response" type activity

    Does anyone know what the data representation of a "Response" looks like from the csv data returned from the Data Export Service?  Thanks!
    James Bennett
    created by James Bennett
  • JiveActivityfirehosetable

    Has anyone had any experience with this? Apparently the activity type in this particular field does not match up with the same definition of activities that exist in the other databases. Here's the same question that ...
    alice yang
    created by alice yang
  • Understanding what is meant in Jive by "login"

    I say this previous discussion here, Login Records, but it doesn't really address what I'm interested in. At least I don't think so.   Sangee Parsan is helping me put together some reports, using data pulled fro...
    tmaurer
    last modified by tmaurer
  • Data pull with date filter issue?

    When I pull data using the 'after' filter as in the following example: https://api.jivesoftware.com/analytics/v1/export/activity/csv/content?count=1000000&after=2015-03-31T23:59:48.823 the data being returned in...
    James Bennett
    created by James Bennett
  • What's the latest with Analytics?

    Wondering what the 'SP' is with analytics nowadays...   Is it all self run now, are there plans for a revamped Community Manager Reports, is anyone still running the SAP Business Objects offering or has that bee...
  • Does anybody know how to get analytics for the Skills and Expertise field?

    I haven't been able to find a way to get any data around usage of the Skills & Expertise field in the profiles (where users can tag themselves and others with skills, and create endorsements for others like in Lin...
    cservilio
    last modified by cservilio
  • Tealium in JiveX

    Hello Corey Mathews   I have a question similar to Reference external javaScript in the Third-party analytics console   That question does not mention Tealium by name. Can you confirm, specifically through...
    Ryan Johnston
    last modified by Ryan Johnston
  • Is there any way to run a report of all content in a site?

    I want to be able to run a report of all content in our sites with author, created date, last modified date, last modified by, title, number of views, number of likes, number of bookmarks, and link. Is this possible?
    Kymberlee Taylor
    last modified by Kymberlee Taylor
  • Tables related with  categories created in a thread

    Can you  help me to let me know the tables related with the information  about the categories selected  by thread?
    karina
    last modified by karina
  • Reference external javaScript in the Third-party analytics console

    Hi,   Should we be able to reference javascript files in the Third-party analytics console? i.e. <script type="text/javascript" src="some file"></script>   Thank you,   Audra
    Audra Blissett
    last modified by Audra Blissett
  • Number of Content Follows, Content Shares, Friend requests

    Can someone guide me on how to get the following metrics from jive databases- 1. Number of Followers for Content (threads, questions, blogs etc.) 2. Number of Shares for Content It would be good to have the numbers...
    Donna 840
    last modified by Donna 840
  • Site Catalyst

    Anyone know a good place to find a great Site Catalyst admin.?  We are in need and having a hard time finding someone.  If there are good job boards or any other places we might solicit I'd love to hear abou...
    jim.buck01
    created by jim.buck01
  • Active users' data for a month

    Hello,   I am new to jive analytics and is trying to generate a report with details of users who accessed our site in the month of January (active users). I would like to confirm if the modification timestamp (m...
    vishnu_nair04
    last modified by vishnu_nair04
  • How to get a list of user_id's followed by each user_id in either the Analytics or Application database?

    What's the best way to get a list of user_id's followed by each user_id in either the Analytics or Application database?   I know that a follow is activity_type 270 and based on that I can pull fields like  ...
    Jason Miller
    last modified by Jason Miller
  • Search Results Count

    Hello Everyone,   We have integrated Jive with SiteCatalyst, and are currently capturing internal search terms in a custom evar (search internal to our community). We would like to also capture a count of the nu...
    Krystal Solcich
    last modified by Krystal Solcich