Skip to content

Instantly share code, notes, and snippets.

@prussiap
Last active August 29, 2015 14:00
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save prussiap/11186670 to your computer and use it in GitHub Desktop.
Save prussiap/11186670 to your computer and use it in GitHub Desktop.
Account Info
Total Accounts: 1119
Accounts with Private Accounts: 609
Of the accounts with owned products:
Total products Owned: 16362
Total Labor products owned: 9933
Total GeneralMaterial products owned : 5785
Owned_product_types: "Labor", "GeneralMaterial", "Kit", "MountingStructure", "DcOptimizer", "PvModule", "MeteringEquipment", "ElectricalEquipment", "Service", "InverterAccessory", "Tool"
Basic graphs and outlay of data can be found here: https://docs.google.com/spreadsheets/d/17h1NqNDSB_-A5kSPsJmDDJkF1mb2J69vZ7N0utvJlBU/edit?usp=sharing
@unlikely
Copy link

Account with most products owned: SunWorks (id 831)
447 products
355 are GeneralMaterial
24 are Labor

Account "Sunergy", id 8 has most Labor products at 78 (out of 142 total)

number of products marked 'self-provided' which are not Labor or GeneralMaterials is around 200.

@unlikely
Copy link

around 60% of accounts own products.
number marked "self-provided" is around 15k.

@ilozka
Copy link

ilozka commented Apr 22, 2014

By visibility_id:
0 (private): 16324 products
1 (public): 21054 products
2 (shared): 38 products

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment