data.jsondata.json file every hourIt shows:
It will total up all of these over all of the configured projects
Note: this demo is only using one of my sample apps
| source "https://rubygems.org" | |
| gem "json" |
| # .github/workflows/main.yml | |
| name: Update | |
| permissions: | |
| contents: write | |
| on: | |
| workflow_dispatch: | |
| schedule: | |
| - cron: '*/30 * * * *' | |
| jobs: | |
| update: | |
| runs-on: ubuntu-latest | |
| steps: | |
| - uses: actions/checkout@v3 | |
| - name: Set up Ruby | |
| uses: ruby/setup-ruby@359bebbc29cbe6c87da6bc9ea3bc930432750108 | |
| with: | |
| ruby-version: '3.1' | |
| - name: Install dependencies | |
| run: bundle install | |
| - name: Run updates | |
| run: bundle exec ruby update.rb | |
| - name: Commit files | |
| run: | | |
| git config --local user.email "[email protected]" | |
| git config --local user.name "github-actions[bot]" | |
| git commit -a -m "Add changes" | |
| - name: Push changes | |
| uses: ad-m/github-push-action@master | |
| with: | |
| github_token: ${{ secrets.GITHUB_TOKEN }} |
| require 'uri' | |
| require 'net/http' | |
| require 'openssl' | |
| require 'json' | |
| def self.get_overview_metrics(api_key:, project_id:) | |
| url = URI("https://api.revenuecat.com/v2/projects/#{project_id}/metrics/overview") | |
| http = Net::HTTP.new(url.host, url.port) | |
| http.use_ssl = true | |
| request = Net::HTTP::Get.new(url) | |
| request["Accept"] = 'application/json' | |
| request["Content-Type"] = 'application/json' | |
| request["Authorization"] = "Bearer #{api_key}" | |
| response = http.request(request) | |
| json = JSON.parse(response.read_body) | |
| return json | |
| end | |
| # This should probably be a github secret | |
| projects = { | |
| "projXXXXXXX": "sk_XXXXXXXXXXXXXX" | |
| } | |
| revenue = 0 | |
| mrr = 0 | |
| subs = 0 | |
| active = 0 | |
| new_cust = 0 | |
| projects.each do |project_id, api_key| | |
| resp = get_overview_metrics(api_key: api_key, project_id: project_id) | |
| metrics = resp["metrics"] | |
| metrics.each do |metric| | |
| case metric["id"] | |
| when "revenue" | |
| revenue += metric["value"] | |
| when "mrr" | |
| mrr += metric["value"] | |
| when "active_subscriptions" | |
| subs += metric["value"] | |
| when "active_users" | |
| active += metric["value"] | |
| when "new_customers" | |
| new_cust += metric["value"] | |
| end | |
| end | |
| end | |
| data = { | |
| frames: [ | |
| { | |
| text: "$#{revenue.to_s}", | |
| icon: 34 | |
| }, | |
| { | |
| text: "$#{mrr.to_s}", | |
| icon: 8381 | |
| }, | |
| { | |
| text: subs.to_s, | |
| icon: 42832 | |
| }, | |
| { | |
| text: active.to_s, | |
| icon: 5337 | |
| }, | |
| { | |
| text: new_cust.to_s, | |
| icon: 14024 | |
| }, | |
| ] | |
| } | |
| File.write('data.json', data.to_json) |