Setting up the Segment Integration
This integration will allow you to connect with Segment and start collecting your data. Segment allows you to easily manage integrations with multiple analytics services. By tracking events and users via Segment’s API and libraries, you can send your product’s data to Blendo (as Segment destination) and from there to any data warehouse.Our Blendo – Segment connector will allow you to stream your Segment data to feed your data warehouse and then you BI, or your custom analytics stack.
Here are the steps involved:
- Connecting Segment
- Segment expected Data Model and schema
About Segment
Segment allows you to easily manage integrations with multiple analytics services. By tracking events and users via Segment’s API and libraries, you can send your product’s data to all of your analytics/marketing platforms, with minimal instrumentation code.
How to connect
In order to connect Segment with Blendo, you should verify that you have a valid and active Segment account and the correct user credentials.
To add this integration, go to Blendo dashboard. Click Add a Source and click on Segment and then click on the Segment icon.
In the next screen Blendo will provide you with an API Key that you will need to provide into Segment’s UI. After you have configured your Segment account with the relevant API Key, you should click on “Validate”.
Next, select an optional table prefix that will be added in front of the names of any tables created by this pipeline. Leave the field empty if you prefer the table names not to have any prefix.
Finally, select which Segment resources you want to be synced. By default, all resources are selected. Click on each one you don’t need, to deselect it. When you are read click on the “Create” button. That’s it! Your pipeline is ready to receive data.
Initial sync and Historical data
For a new integration, Blendo will schedule an initial sync job. For Segment as the data are streamed into Blendo its not possible to get historical data but instead you will get any data from the moment you setup the integration and onwords.
What Segment data do I have available?
Blendo creates a table for each Segment pipeline you create. That table has a number of columns that they are automatically changing and detected as your custom event data are coming into Blendo.
For example you may have Segment events like Track (with some properties), Identify (with some traits) or Page (with a name of URL). As the number of events, custom events, and properties could vary, below is an example of a table you are going to get in Blendo. The table will be a series of events with columns like:
|
Column name |
| blendo_imported_at |
| channel |
| context_page_path |
| context_page_referrer |
| context_page_title |
| context_page_url |
| event |
| properties_ (custom properties) |
| timestamp |
| type (eg Track, Identify etc) |
The schema of the table will be like:
| Column | Type |
| blendo_imported_at | Number |
| channel | String |
| context_page_path | String |
| context_page_referrer | String |
| context_page_title | String |
| context_page_url | String |
| event | String |
| properties_ (custom properties columns) | String |
| timestamp | |
| type | String |
Table Rows
Every one Segment event that is received from Blendo will be replicated to your data warehouse.
Table Schema View
You can see the Schema of the table we created from inside Blendo, please do the following
- Click your data source
- Go to the status tab
- Select any of the tables that you want to find out the exact schema and click the eye icon on the right to see the Schema and the Latest Data of the specific table of your pipeline.
