How to run a custom data export query?

After a good night’s sleep, and after getting my first data export, I think I get it - I think you’re supposed to feed these .csv files into your own sql database and then you run the example queries on the database (?)

Hi ​@James Allen,

Yes, you’re exactly right! There’s any number of database services that you could use - RevenueCat will export to Amazon, Google Cloud, and Azure Blob (Microsoft), who all have their own version of a SQL tool and will likely make it easy to feed the CSV file in, but you can also find other open-source or third party services that you may like as well. 

Let us know if we can elaborate at all!

Thanks ​@kaitlin, I ended up using a simple sqlite database. In case this is useful for future readers, this is how I did it on mac:

brew install sqlite3
sqlite3 ./report.db
sqlite> DROP TABLE transactions;
sqlite> .mode csv
sqlite> .separator ,
sqlite> .import transactions.csv transactions

Then I can run queries. Some of the syntax in the examples have to be translated from Postgres to Sqlite, for example changing json_extract_path_text to JSON_EXTRACT. So to get a count of which of my customers has chosen each charity:

SELECT 
  COUNT(*), 
  JSON_EXTRACT(custom_attributes, '$.charity.value') AS charity 
FROM customers 
WHERE instr(custom_attributes, 'charity') > 0 
GROUP BY charity;