Analyze your Intercom data using SQL
Analyze Intercom data over time using SQL with:
- time series data about segment and tag membership
- query using SQL
- no maintenance of webservers or databases
- all data stored as
ndjson
(newline delimited json) in S3
Operator is a package you can upload to AWS Lambda that is triggered on a schedule to collect segment and tag information about users and companies from Intercom, allowing you to analyse usage in new ways.
- Intercom Access Token
- Amazon AWS account
The fastest way to install Operator is to spin up a CloudFormation stack.
As part of the setup you can supply your Intercom access token.
You can create a token using the Intercom Developer Hub following these instructions.
Operator only needs read access to your data, but unfortunately Intercom doesn't permit specifying read-only permissions for access tokens. Furthermore, to list users and companies Extended Scope is required.
You can either use the direct
link
or navigate in your AWS Console to Services > CloudFormation
, choose 'Create Stack' and upload operator.template
from the root of this repository, or use the S3 Link.
Then click 'Next' where you can enter a stack name (operator
is a good default), API token, and a name for the S3 bucket
where your Intercom data will be stored (intercom-APPID
where APPID
is substituted with the unique id for your
Intercom account).
Click 'Next', and then 'Next' again on the Options step (leaving the default options selected), to get to the final Review step.
Check the acknowledgment checkbox and click 'Create' to start the resource creation process.
Once your stack is created, you are ready to start analyzing your Intercom data!
Initially no data will have been collected yet. It will happen automatically once per day. If you want to start
exploring immediately you can trigger the Lambda function by navigating in you AWS Console to Services > Lambda
,
choose the Operator function and click 'Test'.
Coming soon.
Coming soon.