Log in to follow, share, and participate in this socialgroup. Not a member?
Join Now! 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... 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 ... How to get a list of user_id's followed by each user_id in either the Analytics or Application database?
in Jive Analytics
BackCan 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... 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... Does anybody know how to get analytics for the Skills and Expertise field?
in Jive Analytics
BackHello 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... We are looking at reviewing our options and would like to better understand the steps involved with implementing SiteCatalyst with Jive. Any feedback from others is appreciated. Thanks, What is the implementation process for connecting Adobe SiteCatalyst with Jive
in Jive Analytics
BackHi- We have a support community on SBS and one of the things we are really interesting in measuring is the percentage of customer questions that get answered by other customers rather than by our own employees... Reading Eric Ries article on "Vanity Metrics vs. Actionable Metrics" got me inspired to create a "Cohort Analysis" report for our installation of Jive. The idea is to group your users according to when they jo... Do you know if you can extract the social ID for anyone that registered an account in Jive using a social sign on authentication from either the analytics or App DB's? Hi, I heard there's a flag for mobile users somewhere in Jive(?). I don't see it offhand though and when I search the information schema on column names like '%mobile%' nothing comes up. Thanks! In the Jiveinvite table, we can see who has been invited to a group - there is a status indicator with values 1-3. I can't see a table where these status values are dfined. Anyone have anything on this? Also,... Trying to locate the table where the status for invites is documented
in Jive Analytics
BackLately whenever I'm trying to restore .dmp files from JCA to our reporting server's PostgreSQL pgAdmin III tool, the tables won't restore to my database and it will instead time out and freeze the program. When I go t... My Jive community had a bit of spam and thus we're banning people. Someone asked me about the traceability of bans in the Application and Analytics DB's. I see the jiveban table, so for the most part I think t... Hi, I'm wondering if anyone has a query that will give me the activity for a specific piece of content or object ID? I can't seem to find anything that will narrow down the activity to just one document. ... Ultimately, what I want do is be able to export a list of comments or users who have commented in a thread or an idea. Any good SQL queries that would help with this? Thanks in advance!! 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... I'm trying to filter users based on their profiles. I see that profiles are stored in jivedw_userprofile and that the names of field_id's are given in jivedw_profilefield. I noticed that there are several with the sam... If you want to see the total unique viewers but not the names of viewers... Can anyone provide clarity on which activities in Jive can be performed only by admin's (i.e. MODIFY) instead of users and admin? Is this in the documentation? If so, I'm not seeing it. Thanks in advance! Hi, Can anyone explain to me, what does the different dates fields exatly mean in the user and userprofile table? In the user table: initlogin_ts| creation_ts| modification_ts In the userpr...
