Advanced Tips: Field Types, using Naming Conventions and Calculated Metrics

🤓 Field types and aggregation

If any of your conversion rate numbers look unformatted (for example "240" instead of "24%", try setting the metric as an "average" or "median" on the default aggregation.

Also, don't forget to set the field as a "percent" instead of a "number"

❞ Naming conventions

  1. Always customize the name your data sources and templates otherwise you'll get lost super fast as the Google Play connector itself has 10 different reports.
    ​
  2. For our Google Play connectors for example, we use "G - REPORTNAME". This naming convention makes it super easy to spot what's what. Same for our App Store sources, here's an example:By following this naming convention you can easily understand what each data source contains, making your life much easier.
    ​
  3. You can also use emojis to give a twist to the name of your reports and data sources but also to make it easier for you to distinguish them

➗Calculated metrics

You can subtract "Cancelled Subscriptions" from "New Subscriptions" to see what's your daily overbalance of subscriptions.

Alternatively, you can divide one by the other to get a proxy of your churn rate.