Warehouse destinations are the main way of getting direct access to the underlying Freshpaint data. Once you've setup a data warehouse, you can run SQL over the raw Freshpaint data. Once configured, Freshpaint will sync data to your data warehouse every six hours.
For every event you send to a warehouse, Freshpaint will create a corresponding table. For example, if you send an event,
View Homepage to your warehouse, Freshpaint will create a table,
view_homepage, and load all the
View Homepage events into it. All event tables have the following fields, along with any custom properties you send in your events:
The name of the event definition matched by the event.
The Unix time in seconds the event occurred at.
The id of the pageview the event belongs to. All events performed in the same pageview will have the same
The id of the session the event belongs to. A session is a group of actions perform in the same time frame. A session ends after 30 minutes of inactivity. All events performed in the same session will have the same
The name of the web browser.
The version of the web browser.
A Freshpaint generated unique identifier for the device the event was sent from. This is sometimes referred to as the
The domain of the page the event occurred on.
The full URL of the page that first referred the user to your site.
The domain of the page that first referred the user to your site.
The value of utm_campaign on the user's first visit.
The value of utm_content on the user's first visit.
The value of utm_medium on the user's first visit.
The value of utm_source on the user's first visit.
The value of utm_term on the user's first visit.
The name of the operating system the user was using.
The URL path of the page the event was performed on.
The URL of the page the user was on before the page they performed the event on.
The domain of the page the user was on before the page they perfomed the event on. It may be your own domain.
The height of the user's screen.
The width of the user's screen.
The full URL of the page the event was performed on.
The identity associated with the user through Identify.
The most recent value of the utm_campaign UTM property.
The most recent value of the utm_content UTM property.
The most recent value of the utm_medium UTM property.
The most recent value of the utm_source UTM property.
The most recent value of the utm_term UTM property.
In addition to any event tables, you create, Freshpaint will also create an
identifies table with all the identify calls you made.
The identity assigned to the user for the given identify call.
The ID of the device the identify call was performed on.
The time the identify call was performed.
The table will also contain any user properties you send in your identify calls.
Freshpaint supports sending data to the following warehouses: