cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
%3CLINGO-SUB%20id%3D%22lingo-sub-494317%22%20slang%3D%22en-US%22%3EIs%20there%20a%20report%20to%20show%20me%20the%20%23posts%20on%20a%20specific%20conversation%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-494317%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20cost%20the%20number%20of%20responses%2Fposts%20on%20a%20specific%20conversation%20ID%3F%26nbsp%3B%20For%20instance%20if%20i%20have%20an%20issue%20that%20customers%20are%20raising%20on%20SM%20i%20would%20like%20to%20be%20able%20to%20quantify%20the%20number%20of%20contacts%20that%20have%20come%20through%20our%20SM%20channels%20and%20attach%20a%20cost%20per%20contact.%20Is%20there%20any%20report%20available%20that%20will%20give%20me%20this%20information%3F%3C%2FP%3E%3CP%3EAppreciate%20any%20help%20here%20folks.%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EElaine%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-494546%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20a%20report%20to%20show%20me%20the%20%23posts%20on%20a%20specific%20conversation%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-494546%22%20slang%3D%22en-US%22%3E%3CP%3EI%20verified%20the%20API%20browser%20is%20only%20looking%20at%20stage.%26nbsp%3B%20%26nbsp%3BTo%20get%20the%20above%20query%20to%20work%20on%20your%20production%20environment%20you%20would%20need%20to%20do%20this%20from%20a%20browser%3A%3C%2FP%3E%3CPRE%3Ehttps%3A%2F%2F%5Byourcommunity%5D.com%2Fapi%2F2.0%2Fsearch%3Fq%3Dselect%20count(*)%20from%20messages%20where%20parent.id%3D'123'%3C%2FPRE%3E%3CP%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-494420%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20a%20report%20to%20show%20me%20the%20%23posts%20on%20a%20specific%20conversation%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-494420%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Flithosphere.lithium.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F74931%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%40Elaine_ThreeIre%3C%2FA%3E%26nbsp%3B-%20You%20may%20be%20able%20to%20get%20to%20this%20via%20the%20search%20export%20reports.%26nbsp%3B%20It's%20not%20enabled%20by%20default%2C%20contact%20support%20to%20have%20it%20enabled%20if%20you%20can't%20get%20it%20working%20-%26gt%3B%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Flithosphere.lithium.com%2Ft5%2FSearch-tools%2FExport-community-search-results-to-a-CSV-file%2Fta-p%2F37608%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Flithosphere.lithium.com%2Ft5%2FSearch-tools%2FExport-community-search-results-to-a-CSV-file%2Fta-p%2F37608%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-494374%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20a%20report%20to%20show%20me%20the%20%23posts%20on%20a%20specific%20conversation%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-494374%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Flithosphere.lithium.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F55712%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%40VikasB%3C%2FA%3E%26nbsp%3BExcuse%20my%20ignorance.%26nbsp%3B%20I've%20not%20used%20the%20API%26nbsp%3B%20browser%20in%20Studio%20before%20so%20I%20tried%20this.%26nbsp%3B%20It%20returned%200%20replies%20for%20a%20thread%20that%20has%206%20replies.%26nbsp%3B%20%26nbsp%3BThen%20I%20started%20wondering%20if%20the%20API%20browser%20is%20only%20looking%20at%20our%20stage%20server%20environment%20so%20I%20tried%20some%20other%20searches%20using%20the%20browser%20and%20it%20seemed%20to%20confirm%20to%20me%20that%20searches%20in%20the%20API%20browser%20are%20only%20looking%20at%20the%20staging%20server%20so%20are%20only%20useful%20in%20testing%2C%20not%20in%20returning%20actual%20useful%20data.%26nbsp%3B%20%26nbsp%3B%20Can%20you%20confirm%20and%2For%20educate%20me%20on%20what%20the%20API%20browser%20is%20looking%20at%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-494331%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20a%20report%20to%20show%20me%20the%20%23posts%20on%20a%20specific%20conversation%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-494331%22%20slang%3D%22en-US%22%3EThanks%20for%20your%20reply%20I%20actually%20found%20this%20detail%20under%20the%20combined%20data%20export%20in%20the%20smart%20view.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-494323%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20a%20report%20to%20show%20me%20the%20%23posts%20on%20a%20specific%20conversation%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-494323%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Flithosphere.lithium.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F74931%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%40Elaine_ThreeIre%3C%2FA%3E%3C%2FP%3E%3CP%3EYou%20can%20use%20an%20API%20to%20count%20the%20replies%20on%20a%20specific%20conversation%3C%2FP%3E%3CPRE%3Eselect%20count(*)%20from%20messages%20where%20parent.id%3D'123'%3C%2FPRE%3E%3CP%3ETo%20run%20an%20API%2C%20go%20to%20%3CSTRONG%3EStudio%20%26gt%3B%20API%20Browser%3C%2FSTRONG%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor
Occasional Contributor

Is there a report to show me the #posts on a specific conversation?

I am trying to cost the number of responses/posts on a specific conversation ID?  For instance if i have an issue that customers are raising on SM i would like to be able to quantify the number of contacts that have come through our SM channels and attach a cost per contact. Is there any report available that will give me this information?

Appreciate any help here folks.

Thanks

Elaine

0 Kudos
5 Replies 5
Highlighted
Honored Contributor
Honored Contributor

Re: Is there a report to show me the #posts on a specific conversation?

@Elaine_ThreeIre

You can use an API to count the replies on a specific conversation

select count(*) from messages where parent.id='123'

To run an API, go to Studio > API Browser 

Give kudos if you find my posts helpful or mark solution if it answers your query
Reply
Loading...
Highlighted
Occasional Contributor
Occasional Contributor

Re: Is there a report to show me the #posts on a specific conversation?

Thanks for your reply I actually found this detail under the combined data export in the smart view.
0 Kudos
Reply
Loading...
Highlighted
Honored Contributor
Honored Contributor

Re: Is there a report to show me the #posts on a specific conversation?

@VikasB Excuse my ignorance.  I've not used the API  browser in Studio before so I tried this.  It returned 0 replies for a thread that has 6 replies.   Then I started wondering if the API browser is only looking at our stage server environment so I tried some other searches using the browser and it seemed to confirm to me that searches in the API browser are only looking at the staging server so are only useful in testing, not in returning actual useful data.    Can you confirm and/or educate me on what the API browser is looking at?  

--
Community manager in the Micro Focus Community. My computer always used to beat me at chess, but it is no match for me now I changed the competition to kick boxing.
0 Kudos
Reply
Loading...
Highlighted
Honored Contributor
Honored Contributor

Re: Is there a report to show me the #posts on a specific conversation?

@Elaine_ThreeIre - You may be able to get to this via the search export reports.  It's not enabled by default, contact support to have it enabled if you can't get it working -> https://lithosphere.lithium.com/t5/Search-tools/Export-community-search-results-to-a-CSV-file/ta-p/3...

0 Kudos
Reply
Loading...
Highlighted
Honored Contributor
Honored Contributor

Re: Is there a report to show me the #posts on a specific conversation?

I verified the API browser is only looking at stage.   To get the above query to work on your production environment you would need to do this from a browser:

https://[yourcommunity].com/api/2.0/search?q=select count(*) from messages where parent.id='123'

  

--
Community manager in the Micro Focus Community. My computer always used to beat me at chess, but it is no match for me now I changed the competition to kick boxing.
0 Kudos
Reply
Loading...