With the native integration with Snowflake, you can model your data and build up analytical interfaces for end-users.
The non-technical people will see the similar interfaces to run queries on data easily:
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
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
It provides marketing reports for your Adwords destinations
Dashboards
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
Measures: total ads
Dimensions: typestatusfinal urlsis activeoriginal idadwords customer id
Join Relations: adwords ad groups.ad_group_id is equal to id column
Dimensions: end dateserving statusnamestatusstart dateadwords customer id
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
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
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
Dimensions: statusnameadwords customer id
Join Relations: adwords campaigns.campaign_id is equal to id column
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.
Once you enter the credentials, you will see all the tables in your database.
You can either use our UI to generate the models automatically or use Jsonnet and sync the models via
GIT.
We have many reporting feature that lets you segment the data, create funnel and retention queries without writing SQL.
One-click integrations help you to start using Rakam without any friction