Have a question? We're here to help. Find frequently asked questions about Glew and get in touch with support.
Great question – BI Tunnel is our custom reporting tool offered to Glew Plus/Enterprise subscribers. It allows you to connect a business intelligence platform to Glew to create custom reports and additional layers of data visualization not available out of the box in Glew. If you’re not a Glew Plus/Enterprise subscriber, you’ll see BI Tunnel in your sidebar menu but will not be able to access it. BI Tunnel can be a good option if there are reports or data manipulations you want that you’re not able to access standard in Glew.io. A Glew Plus/Enterprise subscription does come at an additional cost, which is dependent on your business and data/integrations.
If you’re a Glew Enterprise user, you can update the logo for your enterprise analytics app to match your company’s branding. Just log into your instance of Glew Enterprise, go to App Settings > Appearance, and upload your logo. You can upload a custom logo to appear as a favicon, in the top bar of the app, on the login page, and in your email template. You can also update the colors and fonts for your enterprise analytics app in the same place.
Great news! If you’re a former Glew user and you want to reactivate your subscription, it’s easy to sign up again. Just start a new free trial, re-integrate your store and data sources, and subscribe when you’re ready (before your free trial is up).
If you have Glew.io and want to upgrade to Glew Plus or Glew Enterprise, get in touch with your account representative, or reach out to us at email@example.com to go over your options.
Want to add another store to your Glew account? Just log into Glew, click on your store name in the menu, then click "Add Store." You'll be prompted to input information for an additional store.
Glew allows you to add unlimited users to your store. Go to Store Settings > Users to invite additional users. They'll get an email with login information.
Glew offers three permission levels: Basic, Manager and Admin. You can view the capabilities for each of these levels and update individual user permissions in Store Settings > Users.
You can log into Glew on any browser or device, although Glew is optimized for the most recent versions of Google Chrome, Mozilla Firefox and Safari.
Forgot your password? No problem. Just click on the "Forgot your password?" link on the login screen, then enter your email. We'll send you an email with instructions on how to reset it.
If you’re having trouble connecting your Google Analytics account, it may be because you previously had a Glew account that has since been deactivated. If that’s the case, follow the steps below to remove Glew as a third-party app from your Google account, then reconnect Google Analytics in Glew:
Once you complete those steps to remove Glew as a third-party app, return to your Store Settings in Glew and follow the instructions to connect Google Analytics:
Repeat the steps above if needed for Google Ads. If you are still experiencing issues, please reach out to us at firstname.lastname@example.org.
Select “Security” from the left navigation panel in your Google account.
Scroll to "Third-party apps with account access" and click "Manage third-party access"
Click on Glew from the list of apps and select "Remove Access."
It's easy to push your Glew customer segments into your email or marketing automation platform and use them as lists for greater targeting and personalization. The process will vary slightly depending on which platform you have integrated (we currently have segment pushes enabled for MailChimp and Klaviyo).
First, make sure you have an email or marketing automation platform integrated in Glew (you can confirm this, or connect a platform, in your Store Settings). To get a segment to automatically push to your email or marketing platform, go into a segment under the email campaign tab and toggle on the "Automatically push this segment” button. Lists are updated nightly, so please allow for 24 hours after you enable a segment push. Remember that customers can be added and removed from multiple lists.
Glew offers 40+ integrations with popular ecommerce apps and software platforms, with new integrations being launched every month. You can see a full list of our current integrations on our website.
Glew currently integrates with Mailchimp, Dotmailer, Klaviyo and Bronto. Other platforms, including Listrak and Emma, are coming soon.
Glew currently integrates with Google Ads, Bing Ads, AdRoll and Facebook Ads. Other platforms, including Amazon Ads and Snapchat, are coming soon.
Glew currently integrates with Google Analytics.
Glew currently integrates with Salesforce Commerce Cloud, Magento, WooCommerce, Shopify, Shopify Plus, BigCommerce, PrestaShop, OSCommerce, Zoey and RetailOps.
Since any data stored in Glew is pulled from other platforms, in order to delete data from Glew, you will need to first delete it from the source platform - in this case, your ecommerce cart.
To remove a customer record from Glew, first, delete the customer from your ecommerce platform. Their customer record will be removed from Glew on the next hourly data sync, and no new data will be added for that customer. However, to delete all of a customer's historical purchase data, you will need to do a complete resync of your data - please reach out to our team at email@example.com to kick off a resync.
Glew tracks customer acquisition cost by taking into spend from paid advertising channels you have connected, including Facebook and Google Ads. You'll find customer acquisition cost data in the Lifetime Profitability by Channel table, which is located at Customers > Lifetime Value > LTV Profitability by Channel.
Glew groups product data on a product ID level. If you switch ecommerce platforms, it's important to make sure your product IDs are mapped correctly to ensure that product performance data carries over to your new platform. If product IDs in your new ecommerce platform do not match the product IDs you used in your previous platform, it can cause gaps or discrepancies in your historical data.
Typically, your products will receive new product IDs when you migrate to a new ecommerce platform. In order to map them correctly, you have two options:
1. Match your new product IDs to your old product IDs. You can do this when you upload products to your new ecommerce platform - just make sure you include the existing product IDs. This is what we recommend doing.
2. Match your old product IDs to your new product IDs. If you choose this option, you will need to use the new product IDs assigned when you upload your products, and also go back and attach those new product IDs to all historical order items in order to capture your historical data. We do not recommend this option, as it requires more work and can lead to data gaps and discrepancies if done incorrectly.
Please remember to always use your (old and new) ecommerce platforms for guidance when migrating data - they will be the best sources for specific information and best practices. Learn more about safely migrating ecommerce platforms.
If you use discounts, you may notice discounts usage on your Orders tab, but not see discounted products in the Discounted Products segment in your Products tab. That may be expected, depending on what kind of discounts you are using.
Discounts may be one of two kinds: order-based (i.e., 10% off your entire order) or product-based (i.e., $5 off a specific item). The Orders tab will include order-based discounts, while the Discounted Products tab will include only individual items that are discounted.
If you use mainly order-based discounts, you will see discount usage reflected on your Orders tab, but you will not see discounted products in your Discounted Products segment.
You may notice a discrepancy between the refunds data you see in your Daily Snapshot email and the refunds data you see in your Orders tab (both in Glew and in your ecommerce platform). That's expected, and is because of how and when refunds are calculated.
Refunds in the Daily Snapshot are reported based on the refunded date - when the refund was processed. Refunds on the Orders tab in Glew (along with the Orders tab in your ecommerce platform) are reported based on order date - when the order was placed. For example, you may see a refund reflected in your Daily Snapshot that you do not see in your Orders tab, depending on what date range you have selected. Because refunds are often not processed the same day the order was placed, this can cause a discrepancy between these two areas.
You may notice that your refunds data (number of refunds and amount refunded) looks different in the Orders tab than it does in the Highlights tab or Performance tab. This is normal, and happens because of the way we calculate refunds in both of these places.
In the Orders tab, refunds are calculated on an order level and related metrics are based on order date and grouped by order ID. In Highlights and Performance, refund metrics are based on the refunded date rather than the order date.
If you uploaded your product costs correctly via CSV in our cost manager, but aren't seeing any values for your costs, it may be because of how your product IDs are formatted in your ecommerce platform.
One common cause is when your product IDs are very long, causing them to get saved in scientific notation (for example, 2.25E+11). That means their numeric value in Glew will round to something like 225000000000, rather than saving the actual ID. This causes your cost values to go unsaved and can produce holes in your data.
If this happens to you, you'll need to re-upload your costs, starting with a fresh costs template export, which you can download in the instructions on our Cost Manager page. You'll need to ensure you format the cells before saving the file. To do this in Excel:
If this doesn't work, please reach out to us at firstname.lastname@example.org.
Enabling segment sync will push all customers in that segment for the last 365 days to your default list in Mailchimp or Klaviyo at 12:00 AM UTC (for all segments other than date-based segments, like Three Months Since Last Purchase, which will follow their own date ranges). After that, any new or updated contacts in each segment you sync will be added or removed daily at 12:oo AM UTC.
Glew does follow the email opt-in/unsubscribe rules of your email platform and ecommerce cart. Depending on which email platform and cart you use, we may not push customers who have not opted into receiving marketing emails or customers who have unsubscribed from your emails when you sync a segment. (For example, if you use Shopify, we will only push customers who have an "accepts marketing" flag). Keep in mind that this may cause you to see different numbers in your segments in Glew than are ultimately pushed to your list in Mailchimp or Klaviyo.
If you enable Glew's automatic segment sync to push your customer segments to Mailchimp or Klaviyo, you may see that the number of customers in a segment in Glew is different than the number that ultimately gets pushed to your email platform. This is normal, and can happen for a number of reasons:
Glew’s Email Marketing analysis, under the Performance tab, combines data from both your email platform and your ecommerce cart. If you use Mailchimp and Shopify, you may notice some metrics missing after May 2019, including revenue and orders. This is because we pull those metrics from Mailchimp – when Mailchimp and Shopify ended their partnership, those metrics were no longer automatically available.
In order to view revenue and orders for Mailchimp campaigns, you will need to have your revenue and order data imported from Shopify back into Mailchimp You can do this manually, or using a third-party app like ShopSync or Zapier.
From Mailchimp: “Once the integration (Shopify) is phased out, historical data will remain available in Mailchimp for up to 30 days. After that point, purchase data, and some customer information, will no longer be visible in Mailchimp. Your Shopify data will remain available through your Shopify account, and you can choose to import it back into your Mailchimp account.”
More information, including instructions for how connect your Mailchimp and Shopify accounts using a third-party app: https://mailchimp.com/help/shopify-solutions/
If you use an ad retargeting platform like AdRoll, you may see sales or revenue data in Glew that doesn’t match up with the data you see in your retargeting platform. That’s because of Glew’s first-purchase attribution model, which assigns credit for all of a customer’s sales to the channel that originated their first purchase with you. Since retargeting platforms primarily target existing customers, their sales will be credited to the channel that originally drove them to make a purchase the first time – not the retargeting platform, even if that brings them back to make subsequent purchases.
Cost on a product level (for the individual product) will default to the cost value manually input in Glew. If there is no Glew cost value for that product, or if you have not manually entered costs for your products, product cost will default to the cost listed by your ecommerce platform for that product. If there isn't cost data for a product for a particular day you are reporting on, we will use the product cost for the current day.
Glew includes data for both variant and configurable products - variants are just different versions of a configurable, or parent, product. Some stores make variants products for each size, color, fit, etc. for each configurable product they sell.
However, even if your store is only utilizing configurable products, Shopify automatically creates invisible variant products for each configurable. Since you haven't named those invisible variants, Shopify gives them the name "Default Title," which can get in the way of reporting. To ensure you can create accurate product reports, make sure your product lists always show the configurable products rather than the variants, using the toggle at the top right of the Product List table.
If you are seeing revenue in your Daily Snapshot but no products are appearing in the Top Sellers module, there could be an easy answer: total number of orders. In order for a product to display under Top Sellers in your Daily Snapshot, it needs to have at least 2 orders. If your products don't have > 2 orders, you won't see them under Top Sellers.
Our purchase frequency visualization on the Lifetime Value tab is a cumulative lifetime calculation that compares against the previous period and the previous year. This is the same comparison used for LTV.
If you’re seeing a discrepancy between the Facebook performance data you see in the Facebook Ads Manager and in Glew as it relates to orders, revenue, conversion or ROAS, there could be a few reasons:
All other data relating to ad spend, impressions, and clicks should match what you see in your Facebook Business Manager account.
If you are looking at the correct attribution window, counting the same action type and still seeing a disparity in your data, please get in touch with us at email@example.com.
If you use Shopify, you may see a difference between your returns and refunds in Glew. That's because returns and refunds are considered as two distinct metrics in both Shopify and Glew.
A return is when goods pass from a customer back to you after a customer has made a purchase but decided not to keep it. A refund occurs when you pass the value of those goods back to the customer. A return deals with the purchased items, whereas a refund deals with the monetary value of the purchased items that you will issue the customer when you process a return.
Return on Ad Spend, or ROAS, can be calculated as either a revenue amount or as a ratio.
In Glew, we display ROAS as a ratio on the Facebook performance tab (Performance > Advertising > Facebook), since that is the standard for Facebook. We display overall ROAS as a revenue dollar amount elsewhere in the app.
Here's an example: If you spent $1,000 on advertising in one month and generated $5,000 in revenue, your return would be $5,000/$1,000, or a 5:1 ROAS ratio. A return on ad spend of 5:1 indicates that for every dollar you spend in advertising, you gain $5 in revenue.
Depending on the timeframe and grouping you have selected, you may see fewer or no repeat customers in the total on New vs. Repeat Customers, but still see some or more repeat customers in the visualization. This is because of the way Glew calculates new vs. repeat customers.
Glew defines new customers as those who made their first purchase during the timeframe selected in the date picker. They may have made multiple purchases or just one, but their initial purchase must have been in the timeframe selected. Repeat customers are those who made a repeat purchase in the timeframe selected in the date picker, but whose first purchase happened prior to the timeframe selected.
A customer can only be counted as a new or a repeat customer during a given timeframe – not both. Even if a customer has made multiple purchases during a selected period, if they made their first purchase during that period, they will be counted as a new customer, not a repeat customer.
If you have a longer time period, like a full year, selected in the date picker, it can cause a mismatch between what you see in the new vs. repeat customer totals and what you see in the visualization (like in the image below). That’s because the totals are counting customers only for the period, while the visualization includes all orders. For example, a customer who made their first purchase during the time period selected would be counted as a new customer in the total. But if they made subsequent purchases within that period as well, those purchases would show up in the visualization as repeat customers, since that visualization includes their repeat orders.
Glew defines new customers as those who made their first purchase during the timeframe selected in the date picker. They may have made multiple purchases or just one, but their initial purchase must have been in the timeframe selected.
The repeat customer calculation is based on customers who made a repeat purchase in the timeframe selected in the date picker, but whose first purchase did not happen in that timeframe. Their first purchase must have been made prior to the timeframe selected.
A customer can only be counted as a new or a repeat customer during a given timeframe - not both. Even if a customer has made multiple purchases during a selected period, if they made their first purchase during that period, they will be counted as a new customer, not a repeat customer.
Glew also has the ability to tie initial purchases to later purchases, even when the customer account was created at a later purchase. For example, if a customer places an order but does not create an account at the time, and then comes back later to make a purchase and does create an account, Glew will tie those purchases together and consider that customer a repeat customer, depending on the timeframe selected.
You may see a different order count on the All Orders tab than you do elsewhere in the app – that’s normal. On All Orders, we display every order from your ecommerce platform for the selected date range. We do not exclude orders on this page based on order status like we do in other areas of the app.
You can export any data table or segment in Glew as a CSV. Just look for and click the blue "Export as CSV" button - your data will automatically download.
Good question! While all data is filterable in Glew, the available filters you see on each table will differ depending on what the data is. For example, there are product-specific filters on the Product table and order-specific filters on the Order table.
You can filter any table or data set in Glew. To filter tables and channels, click "Filter" at the top left or right of each section, and choose from the available filters. Note that available filters may differ depending on the data set.
To access different views for performance metrics and other visualizations, you can choose to group the data differently (i.e., by day, week, month, time of day, day of week, etc.). You can also use our date picker at the top of each page in the app to choose a specific date range.
It’s easy to build custom segments from your customers and products in Glew, and you can create them in a few different places.
Customers: You can create custom customer segments at Customers > Segments (click “Create Segment), and on your customer table (just filter the table and click “Save as segment”).
Products: You can filter products at Products > Product List (similarly, just filter the table and click “Save as segment”).
Many of the other tables in Glew, including Inventory and Orders, are also available for segmentation. Remember that you can export customer segments directly to your email or marketing automation platform as lists.
We calculate active, at-risk and lost customers based on Lapse Point, a Diamond Metric calculated in Glew that refers to the number of days that can pass before a customer is likely to never make a purchase again. Each business has a different lapse point depending on their products and expected customer behavior. For example, a cosmetics brand would have a significantly shorter lapse point than a company that sells high-end speakers.
Active: Customers who actively purchase on your site and are well within your store’s Lapse Point.
At-risk: Customers who are within 20% of your Lapse Point and are at risk of not buying from your store again. For example, if your lapse point is 100 days, everyone at 80+ days since their last purchase would be At Risk.
Lost: Customers who have surpassed the Lapse Point since they last bought from your store. For example, if your Lapse Point is 100 days, everyone who hasn’t purchased in 100+ days would be considered Lost.
You can find more information about your store’s Lapse Point in Glew under Customers > Future Value page.
There are many different attribution models in ecommerce. Glew uses first-order attribution, which means that the lifetime value of a customer is attributed to the original channel that led them to purchase from you. For example, if a customer buys from you three times and the first sale came through paid search, while the second and third came from direct traffic, Glew would attribute the revenue from all three sales to paid search.
We believe first-order attribution is the most relevant for ecommerce, because it highlights how you gained a new customer, where they initially came from and how much that channel is worth to your store in the long run.
The order statuses we exclude depend on your ecommerce platform. See below for excluded order statuses by platform:
Good question! We use different colors to indicate how your performance is trending for different metrics in Glew. Green indicates that metric is trending in a positive direction, while red indicates that metric is trending in a negative direction. Additionally, green can represent your best-performing channel, while red can represent your lowest-performing channel.
Great news! You can import unlimited historical data from all your data sources into Glew, which is helpful for historical comparisons, evaluating seasonality and trends and more.
Good question! You can use our Cost Manager page, under Products, to update costs for variant-level products. If you’d rather update costs in bulk, you can import them as a CSV on the same page – just click “Import CSV File” and follow the instructions.
If you use Shopify, BigCommerce or Magento, you can also automatically add costs from your ecommerce platform. You will need to clear out your existing cost data before importing new costs from your ecommerce platform. See our Cost Manager tool for more instructions.
If your Facebook channel data isn't properly displaying as "Facebook" under Channels, check how your order sources are tagged. If you're using "fb" as an order source rather than "Facebook," these orders may not be attributed correctly in Glew. Use "Facebook" to ensure they are mapped correctly. The same is true for "ig" versus "Instagram."
A similar problem can occur if you use a tag like "referral" for Facebook orders - Glew will not be able tell whether they should be associated with paid or organic traffic. Use tags like "paid" or "paid social" to ensure they are mapped correctly to the "facebook-paid" channel.
If one of your data sources is showing all 0's, check Store Settings and make sure an import isn't in progress for that integration.
If an import is currently in progress, we halt hourly updates until the full import is complete. Your data will be current once the full import is finished.
If one of your data sources isn't updating, check Store Settings and make sure an import isn't in progress for that integration. If an import is currently in progress, we halt hourly updates until the full import is complete. Your data will be current once the full import is finished.
If an import is not in progress and your data is still not updating, please reach out to us at firstname.lastname@example.org.
Most data in Glew updates every hour, importing automatically from the data sources you have integrated. You can see the date and time of your last import beside each integration in Store Settings.
The exceptions to hourly imports are customer and inventory data, which is generally updated nightly.
If you're a Glew Plus customer, you can customize the rate at which your data refreshes - please reach out to your account manager or email@example.com for more information.
If you're not receiving your Daily Snapshot report, please check the following:
Through a combination of Google Analytics ecommerce tracking and UTM tags, Glew helps you calculate the revenue brought in from each of your marketing channels. You’ll find this information in Performance > Overview > Revenue by Channel and Net Profit by Channel, as well as other places throughout the app.
If you don’t have your Google Analytics account and UTM tags set up properly, you may see a large amount of revenue coming from channel “unknown” in Glew.
Here’s how to set it up correctly:
1. Connect your Google Analytics To your ecommerce platform:
Google Analytics must first be implemented into the code of your online store. If you have not already done so, set up a new Google Analytics account.
Google provides many good resources that walk through each step of setting up your tracking code. In short, you want to first make sure you are properly tracking the behavior of website visitors, and be able to see how they navigate and interact with your website.
2. Turn On Google Analytics ecommerce tracking:
After you enable behavior tracking, you will need to turn on ecommerce tracking in Google Analytics. With ecommerce tracking turned on, you can see the revenue generated by each product, the total number of products sold, the rate of conversions and more.
First, sign into Google Analytics and click on the Admin tab. In the View column, click on Ecommerce Settings. Where it says Enable Ecommerce, toggle to reveal “On.” Click Next Steps and then submit.
3. Set up UTM parameters and tags:
Google Analytics ecommerce tracking typically ensures your revenue is mapped correctly to each channel, but setting up UTM parameters and tags provides an extra layer of security and data accuracy.
Manual UTM tags are pieces of data that you string behind URLs in order to tell Google Analytics exactly how to organize and attribute traffic and conversions. To have a precise way to calculate ROI by channel, every channel you market and advertise in should include links with custom parameters. In order to calculate Revenue per Channel accurately, you should have UTM tags that cover each of your mediums and sources.
Medium is the overarching category that your sources fall into. The source is the origin of your traffic. Here are some common examples of medium and source tags for ecommerce:
Adding in even more customer parameters like Campaign, Ad Content and Keyword is recommended. See a list of all of the tags Google Analytics can track below:
If you try the steps above and are still seeing unknown channels in Glew, you may need to check what kind of order/transaction ID data your ecommerce platform is passing to your Google Analytics account to ensure that it's being matched up correctly in Glew. To do this, get in touch with our support team at firstname.lastname@example.org.
Since Glew is focused on driving profit for our merchants, we do not include certain order statuses, including ‘canceled,’ ‘fraud,’ ‘pending’ and ‘on-hold’ in our revenue calculations. This is designed to provide you with the most accurate and most profit-driven metrics.
The exception to this is in the Orders tab in Glew, where we include all order statuses by default. If you would like to create a custom revenue report including additional order statuses that are excluded from our general revenue calculations, you can create a report from the Orders tab, where you can add and edit filters to include or exclude specific order statuses. Learn more about how to create reports in Glew.
If you are experiencing a discrepancy between revenue/sales in your ecommerce platform and Glew, please check your Orders tab and see if you have a large number of orders in the excluded order statuses listed above. If that does not answer your question, please reach out to us at email@example.com.
You may notice that the revenue numbers you see in your Orders tab differ from the revenue numbers you see in Highlights. This is normal, and can happen for a few reasons:
You may notice a discrepancy between the revenue numbers you see displayed in Glew and the revenue you see in Google Analytics. This is because Glew pulls your order and revenue data from your ecommerce platform, not Google Analytics. Google Analytics also has a specific revenue calculation that may not match up with your revenue preferences in Glew.
Google Analytics revenue:
You should see your revenue in Glew align with your ecommerce platform revenue.
Your revenue preferences – what you choose to include or exclude from your revenue calculations in Glew, like discounts, refunds and sales tax – apply to most ecommerce platform-specific revenue metrics in Glew, including on the Highlights, Performance Overview and Customers tabs. They do not apply on the Products or Orders tab, where we calculate revenue slightly differently. They also do not apply to revenue metrics that don't come directly from your ecommerce platform, including on the Advertising and Subscriptions tabs.
Revenue on Products and Orders is calculated without shipping or taxes, because an order can contain multiple products, but has a single shipping and tax charge - the individual items in an order do not have a shipping cost or tax associated. We break out discounts, taxes, refunds and shipping separately on the Orders tab for this reason.
There could be a few reasons that revenue from AdRoll as a Channel isn't displaying under Performance:
There could be a few reasons that revenue from Email as a Channel isn’t displaying under Performance:
You may see different revenue displayed on Subscriptions → Revenue than you do on Subscriptions → Customers - this is normal. The Customers tab calculates the total revenue earned from the customer (including any non-subscription orders), while the revenue on Subscription area calculates the revenue value (MRR, or monthly recurring revenue) of the subscription. The Customers tab sums the total of all revenue for the selected date range, not just the value of the subscription.
You may see different revenue numbers on your Highlights tab than you do on Subscriptions – there are a few main differences.
You may see different revenue numbers on your Highlights tab than you do on Products, with Product revenue typically being higher. That's because things like taxes and shipping are calculated on the order level and are not included in revenue calculations for products. You can always adjust your revenue preferences in Store Settings > Data Preferences.
By default, Glew sets revenue preferences based on your ecommerce platform and tries to automatically match how your cart calculates revenue. However, we provide the option to adjust these at any time in your revenue preferences.
Adjusting your revenue preferences will affect all metrics related to revenue and profitability (including revenue, gross margin, gross profit, and net profit). Keep in mind that changing these preferences away from the default may mean you will see a revenue mismatch between Glew and your ecommerce platform. See Revenue under Store Settings > Data Preferences page for more information on your ecommerce platform’s calculations.
If you didn't receive a Daily Snapshot, first check your Daily Snapshot settings in Glew to ensure you have your Daily Snapshot turned on. (You can toggle the Daily Snapshot on or off in your User Settings). If your Daily Snapshot is turned on, next, check your spam folder or promotional tab to ensure that it didn't get caught.
If you did not receive your Daily Snapshot and would like it resent, please reach out to our team at firstname.lastname@example.org and we will resend it for you.
If you need custom reporting outside of what's available in Glew.io, including custom SQL queries, you'll need a Glew Plus or Glew Enterprise subscription. Contact us at email@example.com to discuss upgrading your subscription.
To create a custom report, go to Reports > My Reports > Create a Report. There, you can write a title and description, add the metrics you want by page in Glew, and choose to send the report now, schedule it for later, or schedule a recurring delivery.
The Daily Snapshot is an automated report created by Glew, so you can't change that specific report. However, you can always create a custom report and automate it to send daily, with the specific metrics or visualizations you want to see. Just go to Reports > My Reports > Create a Report to build a new report.
Want to change how you receive the Daily Snapshot? No problem. You can turn your Daily Snapshot on or off easily in Glew - just log in, click on your name, then go to Your Account > Preferences > Email Notifications. You will need to be an Admin- or Manager-level user to update email notifications.
MRR, or monthly recurring revenue, is the predictable revenue a business can expect to earn on a monthly basis, including all recurring charges, credits, and refunds from active subscriptions. It does not include one-time charges, trials, shipping or taxes. MRR is calculated by multiplying your average revenue per subscriber by your total number of paid subscribers.
Glew's MRR calculation also takes subscription frequency into account, so if your subscriptions are quarterly, bi-monthly or semi-annual, it averages that revenue out by month (the same is true for weekly or daily subscriptions).
Average revenue per account, or ARPA, is typically calculated by dividing that total monthly recurring revenue (MRR) by the total number of accounts or subscribers your business has.
Glew takes into account your subscription product costs, just like we do your standard product costs, so that we can provide your subscription profit and margin - something that's hard to get anywhere else. To get your product costs into Glew, you can either import them directly using Shopify (they'll pull in automatically if you use Shopify's product costs feature), or you can upload a CSV with your product costs using our Cost Manager tool.
See Products > Cost Manager for more information and instructions for uploading your product costs CSV.
Yes - ReCharge products are linked to Shopify by their base product name and variant ID, so they are taken into account in our inventory calculations just like any other product in your store. (However, our inventory metrics are order-based rather than based on the number of subscriptions or subscribers).
If you want to split out your subscription purchases from your non-subscription purchases to get an accurate sense of your LTV from both order sources, it’s easy (and we recommend looking at subscription and non-subscription LTV separately, since the calculations are slightly different – our normal LTV calculation is revenue-based, while subscription LTV is profit-based and takes churn rate into consideration).
To view your subscription LTV, you can find lifetime value KPIs on the subscriber or plan level at Subscriptions > Subscribers or Subscriptions > Plans. This will only take into account orders processed through ReCharge. (Remember that you can select a segment in the Segments dropdown at the top of each page or filter in the Subscribers and Plans tables at the bottom of each page to narrow down your view further).
There are a few ways to access your non-subscription LTV. For trending LTV across your entire store, go to Customers > Lifetime Value. To see only your web (non-subscription) order LTV, click the More Options icon on that same metric and add a filter for “Order source is web.”
(Don't forget - you can also add both of these metrics to a report to compare them side-by-side, like in the image below).
Unfortunately, channel/attribution data isn't available in Glew for customers who make their first purchase through ReCharge. This is due to the way the ReCharge/Shopify integration is set up, which causes us to lose that channel-level tracking.
If you're on a table in Glew that shows order source and are viewing ReCharge orders, you may see channel attribution for some orders and not others. This is because we do have channel attribution data for customers whose first purchase was not made through ReCharge, but who came through another medium. For example - if Customer A came from order source = 'web' and channel/medium = 'cpc-google,' then placed a subscription through ReCharge a few months later, you would still see channel/medium = 'cpc-google' for that customer for their subsequent orders.
We handle churn rate slightly differently than ReCharge, so you should expect to see some differences between your churn numbers in ReCharge and in Glew. ReCharge does not include subscriptions that were started and churned in the same month in many of its calculations, while Glew does include those subscriptions. This causes churn rate to appear lower in ReCharge and higher in Glew, since many churned subscriptions are not taken into account in ReCharge. We believe our churn rate provides a more accurate picture of your churn, taking into account all churned subscriptions. Glew also provides churn on both a subscription and a subscriber level, as well as providing both relative (the rate) and absolute (the actual number) churn.
We calculate plans slightly differently than ReCharge, so you should expect to see some differences between your plan numbers in ReCharge and Glew. Plan data is only available via export in ReCharge - there is no way to filter or select a date range. ReCharge also only counts products with subscriptions attached as plans, while Glew includes any products that have subscriptions or one-time purchases. If you would like to adjust your plan data in Glew to more closely match ReCharge, you have a few options:
We calculate active subscribers slightly differently than ReCharge, so you should expect to see different active subscriber numbers in Glew than you do in ReCharge. ReCharge excludes one-time purchasers and excludes the current day by default, while Glew includes one-time purchasers and includes the current day by default. If you want to adjust your active subscriber data to more closely match ReCharge, there are two ways you can do this:
We calculate new subscriptions (or subscriptions created) slightly differently than ReCharge, so you should expect to see different new subscription numbers in Glew than you do in ReCharge. This is because ReCharge excludes subscriptions that were started and churned within the same month (from this metric and related calculations), while Glew includes all subscriptions started in a selected date range, regardless of whether or not they churned that month. We believe this provides a more accurate depiction of both your new subscriptions and your churn. If you would like to adjust your new subscription data in Glew to more closely match ReCharge, you can apply the filters below to the Subscriptions table (please note that these filters will not apply to the KPIs or Insights on the Subscriptions tab):
Note that this will include one-time purchases - if you wish to exclude one-time purchases, you can use the filter “MRR is greater than $0” instead of “Revenue is greater than $0.”
We calculate revenue slightly differently than ReCharge, so you should expect to see different revenue numbers in Glew than you do in ReCharge. The main difference has to do with charge status - ReCharge includes all subscription charge statuses in revenue, including those marked as “refunded” or “queued,” while Glew only includes “successful” charge statuses. We believe this provides a more accurate picture of your true revenue, not including revenue that has been refunded or not yet processed. ReCharge also excludes shipping, taxes and discounts, while Glew excludes shipping and taxes.
MRR, or monthly recurring revenue, is the predictable revenue a business can expect to earn on a monthly basis, including all recurring charges, credits, and refunds from active subscriptions. It does not include one-time charges, trials, shipping or taxes. MRR is calculated by multiplying your average revenue per subscriber by your total number of paid subscribers. New MRR is all monthly recurring revenue from new subscriptions added during the date range selected. Net MRR is the value of all new and current subscriptions, subtracting MRR from churned subscriptions. Churn MRR is the lost revenue attributed to subscriptions that were churned or canceled. Average MRR per subscription is how much recurring revenue you receive, on average, from each active subscription.
A “new” subscriber in Glew is someone who started a new subscription with you during the date range selected - regardless of whether they had a subscription with you previously. A “repeat” subscriber is someone who has more than one subscription with you, with their first subscription started outside of the date range selected. (If you want to get to your number of new subscribers who started their first subscription during the date range selected, look at “first-time subscribers.”)
Yes! You can create custom segments for subscriptions, subscribers and plans, using the same filtering capabilities that are available elsewhere in Glew. Click “Add Filters” or “Edit Filters” on any table, apply the filters you want, check the box for “Save as segment,” then click “Save.” Your segment will show up in the Segment dropdown at the top of the page you created the segment on. Keep in mind that segments will only apply to the pages you create them on, since filtering options vary depending on the page you are on (Subscriptions, Subscribers or Plans).
We currently integrate with ReCharge and Recurly, and our updated subscription analytics platform is only available for ReCharge users. Additional subscription platforms may be added in the future.
Access biweekly group trainings, schedule one-on-one strategy sessions, and contact us anytime via chat, email, phone or video.