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.
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
@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?
@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...
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'