How it works

We support Segment Warehouse with the most common integrations such as Adwords, Facebook Ads, Stripe, etc. Connect your Segment 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

  • Segment Google Adwords
  • Segment Facebook Ads
  • Segment Mobile Analytics
  • Segment User Attribution
  • Segment Pageview Analytics
  • Segment Event Analytics

It provides marketing reports for your Adwords destinations

Dashboards

Google Adwords

Total Spend measures cost in adwords ad performance reports model

Total Clicks measures clicks in adwords ad performance reports model

Interactions measures interactions in adwords ad performance reports model

Average Time On Site measures average time on site in adwords ad performance reports model

Funnel measures impressionsinteractionsconversions in adwords ad performance reports model

Average Bounce Rate measures average bounce rate in adwords ad performance reports model

Engagements measures engagements in adwords ad performance reports model

Campaign Performance measures costconversions in adwords ad performance reports model grouped by campaign name

Active Ads Count measures total ads in adwords ad performance reports model grouped by is active

Models

adwords_ads points to database.schema.ads table

Measures: total ads

Dimensions: typestatusfinal urlsis activeoriginal idadwords customer id

Join Relations: adwords ad groups.ad_group_id is equal to id column

adwords_campaigns points to database.schema.campaigns table

Dimensions: end dateserving statusnamestatusstart dateadwords customer id

Adwords Click Performance points to database.schema.click_performance_reports table

Includes stats at the click level, including both valid and invalid clicks.

Measures: page shown

Dimensions: ad network type 2ad formatad network type 1creative iddeviceslotidgcl idcampaign iddateclick typepagecriteria parametersaoi most specific target id

Join Relations: adwords campaigns.campaign_id is equal to id columnadwords ad groups.ad_group_id is equal to id column

Adwords Campaign Performance points to database.schema.campaign_performance_reports table

Includes a daily snapshot of performance statistics per campaign.

Measures: invalid clicksvideo quartile 100 rateinteractionstotal video viewsviewabilitybudgetengagementsgmail savesaverage bounce rateclick assisted conversionsgmail forwardsaverage time on sitevideo quartile 50 ratecostvideo view rateclicksaverage video view rategmail secondary clicksconversion valueimpressionsconversions

Dimensions: interaction typesbase campaign idadvertising channel sub typecampaign statusdatecampaign trial type

Join Relations: base adwords campaign.base_campaign_id is equal to id columnadwords campaigns.campaign_id is equal to id column

Adwords Ads defined as sql

Measures: invalid clicksvideo quartile 100 rateinteractionstotal video viewsviewabilitybudgetengagementsgmail savesaverage bounce rateclick assisted conversionsgmail forwardsaverage time on sitevideo quartile 50 ratecostvideo view rateclicksaverage video view rategmail secondary clicksconversion valueimpressionsconversions

Dimensions: account descriptive nameaccount currency codeinteraction typesad group namead namecampaign namedate

Join Relations: adwords ads.ad_id is equal to id column

adwords_ad_groups points to database.schema.ad_groups table

Dimensions: statusnameadwords customer id

Join Relations: adwords campaigns.campaign_id is equal to id column

Data modeling

Customizable for your use-case

We have created the models for Segment 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.

Customers

Trusted By

Ready to start?

It's just a few clicks to connect your data.