Skip to main content

POWr Admin Pages

Numbers Page​

Churn - user churn. Only look at paying users (nobody on free trial or using credit). Only if have paid us once. Number is run at the time you load the page.

Churn ++ - user isn't retained if haven't been with POWr for over 90 days. Wix Subscription Churn - only when a subscription is downgraded. Don't have user churn.

Upgrades - compared to previous 30 days.

Pending Transactions Count - could be for same user or even same app.

Revenue - think it's just upgrade rev

Active Users - viewed in last 10 days on a page.

Transactions - money flowing through eCommerce plugins through PayPal.

Reviews - comes from Zendesk. Tracking actual reviews on Shopify/Weebly/Wix/WordPress (anything that comes through Reviews channel). Doesn't include BigCommerce or Facebook.

Goals Page​

Upgrade Model by Day - POWr line is the important one in terms of yearly goal. This is total upgrades (not just new).

Churn Model by Day - POWr line is the important one in terms of yearly goal. Can exclude Wix and Countdown. Same definition as numbers page, but runs once a day.

Revenue Model by Day - POWr projection excludes Wix.

Revenue Last 30 Days by Day

Net Revenue Retention by Day - more of a vanity metric, Shopify and Wix uses it in quarterly reports. Usually looks better than churn. Look at users and rev gained/lost on a user. If user goes Pro to Biz it counts as negative churn. Goal is to be at 100% - even if not growing upgrades, get same amount of money from them.

Analytics

Upgrades Page​

Good for looking at distribution of different plans. Whole page excludes Wix. Just POWr upgrades.

LEVEL:

New Subscriptions - for the year so far.

Total Subscriptions - includes app subscriptions. Wouldn't appear in New Subs as they don't exist anymore.

SUBSCRIPTION TYPE:

Monthly vs yearly

LEVEL AND SUBSCRIPTION TYPE: Looks at both combined.

Need to look a month back - don't look at last one as it's not a complete month.

Can download as CSV, image in Hamburger button. Link to High Charts too for quick copy/paste of table or different graph views.

POWr by Platform​

Shows us all platforms. Totals of everything. Load Raw data - better for historical data. More trustworthy than Daily Analytics (pulling cached data so is faster). Usually takes ~1hr to load.

Can see all the things running in powr.io/sidekiq/workers. If no longer in the list, it probably got aborted. More than 10 in busy means DON'T RUN IT! Best to load towards end of the day or weekend to avoid interfering with Eng pushes.

Shows you last 30 days of data.

Churn number on this needs fixing.

With Volcano a 'New Saved App' is one where the user has clicked 'Publish' in the Editor.

Wix - can trust new saved apps, total active apps. Monthly rev only includes Wix users who pay through POWr. So don't have accurate numbers on conversion to paying etc.

Can we clarify how we define a 'saved' app in Wix?

weebly-integrated vs weebly in Raw. See more rev for weebly-integrated. weelby-integrated = people who found us in Weebly App Center.

Daily analytics shows the opposite of what you see in raw.

POWr by App​

Raw vs Daily Analytics By default loads for all platforms. Starts running the second you load the page. Same is true for Wix here because only have trustworthy new saved app info. Messes up numbers if looking at conversion to upgrade etc. Lists all apps in every platform and can also look at only one platform (probably only want to do that with method=daily_analytics).

Usually load it for platforms that make us more that 1K/mo.

To do that, take URL and add '&platform=' and comma separate platform names with no spaces. E.g. https://www.powr.io/admin/powr-by-app?method=raw_data&aliases=false&platform=shopify,weebly-integrated,html,wordpress,squarespace,bigcommerce,jimdo,iframe,muse,weebly,joomla,lightspeed,google,blogger,facebook,godaddy

Aliases (Raw) Lists out all aliases separately, including soft aliases. Can be useful for listings to know which aliases have most demand. Don't load frequently as it slows shit down.

Analytics Deep Dive​

Analytics Denogginizer Daily Analytics is better

Show you new apps, upgrades, downgrades etc.

Raw Data - use for things before December 2017. Super slow.

Have to select a platform to return results.

Definition is the same as in other pages. Saved Apps = when they hit Publish.

Active Apps - N.B. apps created in last few days may not be showing here.

Cancel Feedback​

Trigger: Cancel - when the cancel feedback record was created. The day they went to downgrade page, it's the day they went to cancel. If a wobbly cancels yearly upgrade and still has 7 months left it's in this number.

Downgrade - shows actual number of plans that were downgraded. Not submitted cancellations, only actually implemented downgrades.

Export options don't currently work. Command + A and copy into Google Sheet.

Number of Apps - includes any apps they created.

App Type - which app the upgrade is associated with.

Cancel Feedback Create Date - triggered by wobbly or support hitting 'Cancel' in downgrade flow. Subscription Cancel Date - when the plan will actually be downgraded (can be immediate if support initiate). Only appears once it's actually expired/cancelled. Subscription Expiration Date - when it's due to downgrade. Cancelled By - gives email of admin who downgraded.

Cancel reasons - includes all the reasons we've ever had.

Reviews​

Only tracking positive reviews.

Popup = emoji face review request.

Cohort Analysis​

Cohortification

Take long to load - up to 1hr.

Set a specific cohort and see what happened to it. Always based on a date.

Could compare a Shopify user who signed up on X date vs all other users and see trends.

E.g. start date is March 1st, and select cohort size e.g. 7 days. Will take users from 7 days before start date.

One week cohort is likely ideal.

Useful for seeing results of an experiment - select time frame where users fit into it and see conversion to active/upgrade/downgrade.

Always takes a cohort of 7 days. For every day it looks at last 7 days.

Take cohorts every day and gives you an average over time. See cached data.

Gives you a trend in conversion to active over time.

Upgraded - people who are active who upgraded. Active to upgrade.

If you get it to load save it to Google Drive!! Can do screenshots or should be able to export with cute Ivan charts.

=> Look at cohort of when we launched Shopify free fall - how did that affect active rate and retention rate.

Downgrades and Billing Changes​

Not convinced data on here is completely accurate. Idea is it shows us when a user switches from monthly to yearly and downgrades from Pro to Starter etc.

Project Canary​

Shows performance (Apps Saved) for apps and platforms for a baseline date range compared to current date. Limit Baseline Number - minimum number of apps saved. By default is 10.

Intended to show big changes. By default shows 20% Limit Percent Change.

Multiple App Types​

Trying to prove that if a user has more than 1 app, the more likely they are to stay. Choose dates on load.

Conversion Comparison​

N.B. Conversion to active might need sanity checking. Choose your cohorts (1 & 2). Have to select a platform and an app.

Shows all platforms excluding Wix as a baseline reference so you can compare selected platform/app with overall performance.

How Many Days After Should Cohort Be Included? - Use this as a means of normalizing the data. It makes the cohorts look at the same number of days, otherwise the pre-cohort will have more time. Must put a number in here. If number is 0, it will look at only the dates of the cohort.

Churn = % of users who are already cancelled.

Deltas show % change from cohort 1 to 2.

Email Spot Check​

A/B Tests​

Links to Split

A/B Tests - Better Split​

Shows full list

A/B results​

https://www.powr.io/admin/powr_ab

Google Optimize​

Successinator​

Broken?

List of All Apps​

Shows parents and aliases (including hard + soft). Soft aliases - don't exist in mini market. Hard to upgrade them. Hard aliases - shown in mini market.

App Details​

Can change price tables here. When an app is no longer active in Shopify uncheck it in the 'Active Platforms' list. Avoids people being sent to a 404 page. If 'Active platform' isn't selected, it will redirect users to standalone rather than Weebly.