/edd-appsmith-stats

Building real time BI charts for Easy Digital Downloads using Appsmith

Primary LanguageJavaScriptGNU General Public License v3.0GPL-3.0

Contributors Forks Stargazers Issues GPL License


Logo

EDD Appsmith Stats

Better reporting for Easy Digital Downloads
Read the blog post »

About The Project

This project attempts to provide a better reporting solution for Easy Digital Downloads than what is built into the plugin.

It can be imported into Appsmith (either cloud or self-hosted) and connected to your own WordPress database to provide real time business intelligence reports based on your sales data.

Example

(back to top)

Getting Started

  1. Either sign up for a free Appsmith account or install the package on your own server.

  2. Fork this repository.

  3. Follow this guide to import your repository to your Appsmith workspace.

  4. Head to Datasources » Easy Digital Downloads and enter the connection information to your database. You will probably need to allow-list Appsmith's IP addresses. Database connection

  5. Choose a page under Pages and you should see your data populated. If not, check the status bar for errors (for example custom table prefixes will need to be updated in the SQL queries)

  6. Have fun! 📈🥳

Contents

The current list of pages and charts is:

Customers and Revenue

  • New customers by month
  • New customers percent change year-over-year
  • Revenue - new vs. recurring
  • Product sales by volume
  • Product sales by revenue

MRR and Growth

  • Current month, net new MRR breakdown
  • MRR overview
  • Subscribers overview
  • Growth rate

Renewals and Cancellations

  • Renewal rate last 12 months
  • Renewal rate last month
  • Estimated recurring revenue next 30 days
  • Estimated recurring revenue next 365 days
  • First year renewal rates
  • Renewal rates by month
  • Renewal rates by month of year

Refunds

  • Refund rate average 12 months
  • Refund rate last month
  • Refund rates by month
  • New customer refund rates by year

Software licensing

  • Top 20 license IDs by number of site activations

Support

  • New customer support request rates, first 30 days vs. first year (requires Gravity Forms and some query tweaking)

Sites Stats

  • These charts are usage stats unique to WP Fusion

Examples

(back to top)

Contributing

Contributions are what make the open source community such an amazing place to learn, inspire, and create. Any contributions you make are greatly appreciated.

If you have a suggestion that would make this better, please fork the repo and create a pull request. You can also simply open an issue with the tag "enhancement". Don't forget to give the project a star! Thanks again!

  1. Fork the Project
  2. Create your Feature Branch (git checkout -b feature/AmazingFeature)
  3. Commit your Changes (git commit -m 'Add some AmazingFeature')
  4. Push to the Branch (git push origin feature/AmazingFeature)
  5. Open a Pull Request

(back to top)

Appsmith

This app is built using Appsmith. Turn any datasource into an internal app in minutes. Appsmith lets you drag-and-drop components to build dashboards, write logic with JavaScript objects and connect to any API, database or GraphQL source.

Github • Docs • Community • Tutorials • Youtube • Discord

License

Distributed under the GNU GPL v3. See LICENSE for more information.

(back to top)

Contact

Jack Arturo - @verygoodplugins / drunk.support

Project Link: https://github.com/verygoodplugins/edd-appsmith-stats

(back to top)