How Rakam works

We support Snowplow Warehouse with the most common integrations such as Adwords, Facebook Ads, Stripe, etc.
Connect your Snowplow and turn Rakam into a product & marketing analytics tool.

Behavioral Analytics
We provide features such as funnel and retention so that you can analyze the event data with Rakam easily.
Analyze Event Metrics
You can analyze the raw event data via segmentation feature and see the big picture in your company.
Connect Marketing Data
Join the product data with marketing data and see how your marketing affects the customer retention.







RECIPES

We model the data collected by various solutions, you can start using recipes and customize them for your use-case later on. You can see the source of the models from here: https://github.com/rakam-recipes/Snowplow

MODELS

points to database.schema.users table
The Users resource is the primary way of interacting with Intercom. You can create, update and delete your users, and add custom attributes describing them. Users can be viewed individually or as a list, and can queried using tags or Snowplows. For more info, check out the [Intercom docs](https://developers.intercom.io/docs/users).

Measures

count all rows count unique users sum of custom active project id sum of custom clearbit company indexed at sum of custom clearbit enriched at sum of custom clearbit person indexed at sum of custom stripe account balance sum of custom stripe card expires at sum of custom stripe last charge amount sum of custom stripe last charge at sum of custom stripe plan price sum of custom stripe subscription period start at sum of custom user id sum of location latitude sum of location longitude sum of session count

Dimensions

avatar image url created at email Intercom Id last request at last seen ip location city name location continent code location country code location country name location postal code location region name pseudonym remote created at Snowplows signed up at unsubscribed from emails updated at user agent data user id uuid ts

points to database.schema.admins table
Admins are how you can view your teams and team members. For more info, check out the [Intercom docs](https://developers.intercom.io/docs/admin-model#section-admin-object)

Dimensions

email id name received at type uuid ts

points to database.schema.conversations table
Conversation are how you can communicate with users in Intercom. For more info, check out the [Intercom docs](https://developers.intercom.io/docs/conversations).

Measures

count unique users read total conversations

Dimensions

open assignee id assignee type created at id message author id message author type message body message subject parts read received at updated at user id uuid ts

points to database.schema.Snowplows table
A Snowplow is a group of your users defined by rules that you set For more info, check out the [Intercom docs](https://developers.intercom.io/docs/Snowplows)

Dimensions

created at id name person type received at updated at uuid ts

points to database.schema.conversation_parts table
A conversation part describes an element of the conversation. For more info, check out the [Intercom docs](https://developers.intercom.com/intercom-api-reference/reference#section-conversation-part-object).

Measures

count all rows

Dimensions

assigned to id assigned to type author id author type body conversation id created at id notified at part type received at updated at uuid ts

points to database.schema.companies table
Companies allow you to represent commercial organizations using your product. For more info, check out the [Intercom docs](https://developers.intercom.io/docs/companies).

Measures

all companies all users monthly spend session count

Dimensions

company id created at id last request at name remote created at Snowplows updated at uuid ts

points to database.schema.contacts table
Leads (previously known as Contacts) are useful for representing logged-out users of your application For more info, check out the Intercom docs

Measures

count all rows count unique users sum of location latitude sum of location longitude sum of session count

Dimensions

avatar image url created at id custom job title email id last request at last seen ip location city name location continent code location country code location country name location postal code location region name location timezone name received at unsubscribed from emails updated at user agent data user id uuid ts

points to database.schema.tags table
A tag allows you to label your users and companies and list them using that tag. For more info, check out the Intercom docs

Dimensions

id name received at uuid ts

points to database.schema.social_profiles table
Social data about the user. For more info, check out the [Intercom docs](https://developers.intercom.com/intercom-api-reference/reference#section-social-profile-object)

Dimensions

contact id id name received at url user id username uuid ts
Content Coming Soon...

DASHBOARDS

Facebook Ads
  • Average Frequency
  • Total Impressions
  • Total Spend
  • Total Clicks
  • Total Reach
  • Click Through Rate

MODELS

points to .facebook_ads.ad_sets table

Dimensions

account id configured status effective status end time is active name

Join Relations

facebook ad accounts. is equal to column facebook campaigns. is equal to column


Measures

click through rate clicks frequencyimpressionslink clickspost engagementsreachsocial spendtotal spend

Dimensions

ad group name ad name campaign name date

Join Relations

facebook ad accounts. is equal to column facebook ad sets.adset_id is equal to id column facebook ads.ad_id is equal to id column facebook campaigns. is equal to column

points to .facebook_ads.ad_accounts table

Measures

balance spend cap

Dimensions

name

points to .facebook_ads.campaigns table

Dimensions

buying type date effective status is active name

points to .facebook_ads.ads table

Dimensions

bid type is active name status

Join Relations

facebook ad accounts. is equal to column facebook ad sets.adset_id is equal to id column facebook campaigns. is equal to column

DASHBOARDS

Google Adwords
  • Total Spend
  • Total Clicks
  • Interactions
  • Average Time On Site
  • Funnel
  • Average Bounce Rate
  • Engagements
  • Campaign Performance

MODELS

points to .adwords.campaigns table

Dimensions

adwords customer id end date name serving status start date status


Measures

average bounce rate average time on site average video view rate budget click assisted conversions clicksconversion value conversionscost engagements gmail forwards gmail saves gmail secondary clicks impressions interactions invalid clicks total video views video quartile 100 rate video quartile 50 ratevideo view rate viewability

Dimensions

account currency code account descriptive name ad group name ad name campaign name date interaction types

Join Relations

adwords ads. is equal to column

points to .adwords.ad_groups table

Dimensions

adwords customer id name status

Join Relations

adwords campaigns. is equal to column

points to .adwords.click_performance_reports table
Includes stats at the click level, including both valid and invalid clicks.

Measures

page shown

Dimensions

ad format ad network type 1 ad network type 2 aoi most specific target id campaign id click type creative id criteria parameters date device gcl id id page slot

Join Relations

adwords ad groups. is equal to column adwords campaigns. is equal to column

points to .adwords.ads table

Measures

total ads

Dimensions

adwords customer id final urls is active original id status type

Join Relations

adwords ad groups. is equal to column

points to .adwords.campaign_performance_reports table
Includes a daily snapshot of performance statistics per campaign.

Measures

average bounce rate average time on site average video view rate budget click assisted conversions clicks conversion value conversions cost engagements gmail forwards gmail saves gmail secondary clicks impressions interactions invalid clicks total video views video quartile 100 rate video quartile 50 rate video view rate viewability

Dimensions

advertising channel sub type base campaign id campaign status campaign trial type date campaign trial type

interaction types

adwords campaigns. is equal to column base adwords campaign. is equal to column

DASHBOARDS

Website Overview
  • Totals
  • Total Pageviews
  • Daily Pageviews
  • Daily Sessions
Users Overview
  • Total Users
  • New Users (This week)
  • Active Users (This week)
  • Inactive Users who signed up this week
  • Daily active users this month
Events Overview
  • Daily Events
  • Top Events
  • Metrics
  • Weekly Events

MODELS

points to .RAKAM_AGGREGATES.Snowplow_web_sessions table
Website session information for the pageview event

Measures

Average Duration Average Session Per User Bounce Rate New Sessions Pages Per Session Returning Sessions Total Sessions Distinct Users

Dimensions

duration in s duration in s tier first page url first page url path first referrer last path last search last url page views session end timestamp session id session number session start timestamp
Content Coming Soon...

Image



Customizable for your use-case

We have created the models for Snowplow so that you can start using Rakam without any friction. You can copy the predefined models and create your own models depending on your use-case.

See Demo