Connect Snowflake from Rakam

With the native integration with Snowflake, you can model your data and build up analytical interfaces for end-users.

Once the data analyst model your data,

The non-technical people will see the similar interfaces to run queries on data easily:

Segmentation
for product managers
Event metrics and Transactional Data

Drill-down and pivot your data in order to understand how to data distributes.
SELECT
                        
      CAST(DATE_TRUNC('week', "install_date") AS DATE) ,   
      "apps"."name" AS "name",
      sum("iap_revenue") AS "Revenue"
  FROM
     "tenjin"."reporting_cohort_metrics"
  LEFT JOIN
       "tenjin"."apps" AS "apps"
          ON
          (
              "reporting_cohort_metrics"."app_id" = "apps"."id"
       )
  WHERE(
          "apps"."platform" = 'ios'
        )
      AND(
          "install_date" BETWEEN '2019-10-30' AND '2019-11-13'
          )
  GROUP BY
      1,
      2
  ORDER BY
      1 DESC

Compiles to this SQL query

The UI above compiles this SQL query. Hover the SQL in order to see the details.

P.S: The users can export the SQL query whenever they want and customize it later on.

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

WHY Rakam?

You don't have to write SQL for every report.

You might be familiar with SQL but not all the people are. We have a data modeling language that lets you model your data once and build up analytical interfaces that can answer complex questions.

How it works

1

Connect your Snowflake database

Once you enter the credentials, you will see all the tables in your database.

Model your data

You can either use our UI to generate the models automatically or use Jsonnet and sync the models via GIT.

2
3

Analyze Data

We have many reporting feature that lets you segment the data, create funnel and retention queries without writing SQL.

Integrations

Connect Rakam to your company data

One-click integrations help you to start using Rakam without any friction

Ready to try Rakam?

It's free for individual analysts & developers.