Skip to main content
Answered

Looking for reporting help and API transformation


  • New Participant
  • 4 replies

We have begun exporting conversation data from the API to calculate our own metrics, and we're running into issues with calculating the metrics correctly. We need help transforming the data to run some great reporting in Looker.

 

Our data stack is: Intercom <> Hevo <> Snowflake <> Looker

 

For a few examples, here are some top reports we want to create: 

  • Volume by
    • Tags
    • Conversation Data
    • Channel
    • Agent
  • Time
    • To first admin response
    • Between follow up replies

 

Please reach out if you are a consultant who can help or if you have recommendations on how to find an Intercom Data expert! Thank you!

 

KEYWORDS: Data, Snowflake, Looker, HELP, Consultant, API, Transformation

Best answer by Colin L11

I would agree with Eric here, I'm fairly sure all these reports are available within Intercom. So unless there is a clear business need to export and generate outside of Intercom, I would advise against doing this.

 

That said, if you 'had to' get the data out, you'll have some challenges as you'll need to pull every conversation in turn and extract the data as Intercom doesn't have a 'reporting' endpoint in the API. The middle ground would be using webhooks to catch new and updating conversations, but depending on your volume you could have a considerable amount of data flowing.

 

So, wrapping up, I'd ensure there is a clear business case for this as although it's not complicated from a data standpoint, it's a reasonably big effort for reports that largely already exist.

View original
Did this topic help you find an answer to your question?

2 replies

Eric Fitz
Employee
Forum|alt.badge.img+5
  • Employee
  • 1630 replies
  • August 16, 2021

@colin l11​ I know you're particularly knowledgable about using Intercom data for analytics, do you think you might be able to help here?

 

@zach b​, is there a particular reason why you're looking to export this to Looker? Intercom has native functionality for the reports you've mentioned there.


Forum|alt.badge.img+1
  • Active User
  • 17 replies
  • Answer
  • August 16, 2021

I would agree with Eric here, I'm fairly sure all these reports are available within Intercom. So unless there is a clear business need to export and generate outside of Intercom, I would advise against doing this.

 

That said, if you 'had to' get the data out, you'll have some challenges as you'll need to pull every conversation in turn and extract the data as Intercom doesn't have a 'reporting' endpoint in the API. The middle ground would be using webhooks to catch new and updating conversations, but depending on your volume you could have a considerable amount of data flowing.

 

So, wrapping up, I'd ensure there is a clear business case for this as although it's not complicated from a data standpoint, it's a reasonably big effort for reports that largely already exist.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings