Swrve’s Export API provides a basic set of per-KPI function calls that can be combined with the Google docs ImportHtml feature to enable a direct pull of KPI information into Google Spreadsheets.
You need the following to get started:
- Your API key and personal key. These are provided for each specific app and each user you have set up with the Swrve service.
- Swrve’s Export API documentation
- Google Spreadsheets
The key part of each file is the Swrve URL that requests the data for a specific KPI from your app’s dashboard. The following is an example for determining the daily active users (DAU) for the entire year of 2015 so far:
=ImportHtml("https://dashboard.swrve.com/api/1/exporter/kpi/dau?personal_key=YOUR_PERSONAL_KEY_HERE&api_key=YOUR_API_KEY_HERE&start=2015-01-01", "table", 0)
=ImportHtml("https://eu-dashboard.swrve.com/api/1/exporter/kpi/dau?personal_key=YOUR_PERSONAL_KEY_HERE&api_key=YOUR_API_KEY_HERE&start=2015-01-01", "table", 0)
Create more queries
You can easily create several web queries that invoke different Swrve Export API calls, though each must be in a separate file. The following are some examples. Consult the Export API docs for API details, specifications and limitations.
Get the DAU for the year so far:
Get the monthly active users (MAU) for the year so far: