Skip to content

Instantly share code, notes, and snippets.

@SFEley

SFEley/NEW Everyone Who Has Not Purchased.rb

Created July 6, 2016 20:10
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 SFEley/1d33ab053e243079185ca5c3b443cc77 to your computer and use it in GitHub Desktop.
Save SFEley/1d33ab053e243079185ca5c3b443cc77 to your computer and use it in GitHub Desktop.
Download ZIP
Old/New Purchase Segments Comparison - Store 3753
Raw
NEW Everyone in Springbot.rb
NEW Everyone in Springbot (3753)
Customers: 23946
Emails: 23941
{"top_five_product_ids"=>
["56d9371969702d2796eaa301",
"5628be3669702d4721cf8702",
"5628be5069702d4773d2b702",
"56d9372169702d27cfe4c100"],
"month_to_date_sales"=>7904.39,
"total_sales"=>913655.5599999987,
"sales_by_month"=>
{"2014-03"=>
{"revenue"=>5996.589999999998,
"orders"=>24,
"average_order_value"=>249.8579166666666},
"2014-04"=>
{"revenue"=>88754.72999999986,
"orders"=>358,
"average_order_value"=>247.9182402234633},
"2014-05"=>
{"revenue"=>51501.59999999997,
"orders"=>219,
"average_order_value"=>235.1671232876711},
"2014-06"=>
{"revenue"=>56820.65999999996,
"orders"=>208,
"average_order_value"=>273.1762499999998},
"2014-07"=>
{"revenue"=>74042.04,
"orders"=>316,
"average_order_value"=>234.31025316455694},
"2014-08"=>
{"revenue"=>47932.70999999999,
"orders"=>238,
"average_order_value"=>201.39794117647057},
"2014-09"=>
{"revenue"=>50264.40999999996,
"orders"=>234,
"average_order_value"=>214.80517094017077},
"2014-10"=>
{"revenue"=>62154.789999999986,
"orders"=>255,
"average_order_value"=>243.74427450980386},
"2014-11"=>
{"revenue"=>105152.43,
"orders"=>471,
"average_order_value"=>223.25356687898088},
"2014-12"=>
{"revenue"=>81366.24999999996,
"orders"=>432,
"average_order_value"=>188.34780092592584},
"2015-01"=>
{"revenue"=>72344.28999999998,
"orders"=>330,
"average_order_value"=>219.22512121212114},
"2015-02"=>
{"revenue"=>69130.56,
"orders"=>224,
"average_order_value"=>308.61857142857144},
"2015-03"=>
{"revenue"=>98186.80999999982,
"orders"=>395,
"average_order_value"=>248.5742025316451},
"2015-04"=>
{"revenue"=>71992.81999999989,
"orders"=>347,
"average_order_value"=>207.47210374639738},
"2015-05"=>
{"revenue"=>42235.979999999996,
"orders"=>191,
"average_order_value"=>221.1307853403141},
"2015-06"=>
{"revenue"=>88859.9799999998,
"orders"=>328,
"average_order_value"=>270.9145731707311},
"2015-07"=>
{"revenue"=>67149.15999999992,
"orders"=>271,
"average_order_value"=>247.78287822878198},
"2015-08"=>
{"revenue"=>46142.31999999998,
"orders"=>208,
"average_order_value"=>221.8380769230768},
"2015-09"=>
{"revenue"=>48104.44000000001,
"orders"=>225,
"average_order_value"=>213.79751111111116},
"2015-10"=>
{"revenue"=>57245.32999999996,
"orders"=>248,
"average_order_value"=>230.82794354838694},
"2015-11"=>
{"revenue"=>134040.46999999983,
"orders"=>460,
"average_order_value"=>291.39232608695613},
"2015-12"=>
{"revenue"=>108475.4099999997,
"orders"=>561,
"average_order_value"=>193.3608021390369},
"2016-01"=>
{"revenue"=>81531.8399999999,
"orders"=>360,
"average_order_value"=>226.47733333333304},
"2016-02"=>
{"revenue"=>67367.75999999994,
"orders"=>335,
"average_order_value"=>201.09779104477593},
"2016-03"=>
{"revenue"=>151414.83999999988,
"orders"=>563,
"average_order_value"=>268.9428774422733},
"2016-04"=>
{"revenue"=>74410.35999999981,
"orders"=>344,
"average_order_value"=>216.3091860465111},
"2016-05"=>
{"revenue"=>62098.399999999914,
"orders"=>366,
"average_order_value"=>169.6677595628413},
"2016-06"=>
{"revenue"=>74919.99999999991,
"orders"=>342,
"average_order_value"=>219.06432748537986},
"2016-07"=>
{"revenue"=>7904.39,
"orders"=>29,
"average_order_value"=>272.5651724137931}},
"lifetime_sales"=>2047541.369999998,
"average_order_value"=>230.52706259851362,
"customer_lifetime_value"=>1372.267287473714,
"average_annual_spend"=>274.4534574947428,
"unique_customer_count"=>6531,
"lifetime_orders"=>8882,
"top_referrers"=>
[{"revenue"=>1419009.9099999699, "orders"=>6219, "name"=>""},
{"revenue"=>362151.9000000038, "orders"=>1560, "name"=>"www.google.com.au"},
{"revenue"=>107079.34999999985, "orders"=>466, "name"=>"www.adreno.com.au"},
{"revenue"=>23283.710000000014, "orders"=>77, "name"=>"scubadiving.com.au"},
{"revenue"=>17234.540000000008,
"orders"=>66,
"name"=>"www.googleadservices.com"},
{"revenue"=>17212.210000000003, "orders"=>78, "name"=>"www.facebook.com"},
{"revenue"=>14986.340000000002, "orders"=>38, "name"=>"www.ozdiscount.com"},
{"revenue"=>13719.190000000006, "orders"=>70, "name"=>"www.bing.com"},
{"revenue"=>10240.470000000001, "orders"=>43, "name"=>"www.paypal.com"},
{"revenue"=>10213.78, "orders"=>46, "name"=>"www.google.com"}]}
Raw
NEW Everyone Who Has Not Purchased.rb
NEW Everyone Who Has Not Purchased (3753)
Customers: 17411
Emails: 17411
{"top_five_product_ids"=>[],
"month_to_date_sales"=>0.0,
"total_sales"=>0.0,
"sales_by_month"=>{},
"lifetime_sales"=>0.0,
"average_order_value"=>0.0,
"customer_lifetime_value"=>0.0,
"average_annual_spend"=>0.0,
"unique_customer_count"=>0,
"lifetime_orders"=>0,
"top_referrers"=>[]}
Raw
NEW Everyone Who Purchased.rb
NEW Everyone Who Purchased (3753)
Customers: 6535
Emails: 6531
{"top_five_product_ids"=>
["56d9371969702d2796eaa301",
"5628be3669702d4721cf8702",
"5628be5069702d4773d2b702",
"56d9372169702d27cfe4c100"],
"month_to_date_sales"=>7904.39,
"total_sales"=>913655.5599999987,
"sales_by_month"=>
{"2014-03"=>
{:revenue=>5996.589999999998,
:orders=>24,
:average_order_value=>249.8579166666666},
"2014-04"=>
{:revenue=>88754.72999999986,
:orders=>358,
:average_order_value=>247.9182402234633},
"2014-05"=>
{:revenue=>51501.59999999997,
:orders=>219,
:average_order_value=>235.1671232876711},
"2014-06"=>
{:revenue=>56820.65999999996,
:orders=>208,
:average_order_value=>273.1762499999998},
"2014-07"=>
{:revenue=>74042.04,
:orders=>316,
:average_order_value=>234.31025316455694},
"2014-08"=>
{:revenue=>47932.70999999999,
:orders=>238,
:average_order_value=>201.39794117647057},
"2014-09"=>
{:revenue=>50264.40999999996,
:orders=>234,
:average_order_value=>214.80517094017077},
"2014-10"=>
{:revenue=>62154.789999999986,
:orders=>255,
:average_order_value=>243.74427450980386},
"2014-11"=>
{:revenue=>105152.43,
:orders=>471,
:average_order_value=>223.25356687898088},
"2014-12"=>
{:revenue=>81366.24999999996,
:orders=>432,
:average_order_value=>188.34780092592584},
"2015-01"=>
{:revenue=>72344.28999999998,
:orders=>330,
:average_order_value=>219.22512121212114},
"2015-02"=>
{:revenue=>69130.56,
:orders=>224,
:average_order_value=>308.61857142857144},
"2015-03"=>
{:revenue=>98186.80999999982,
:orders=>395,
:average_order_value=>248.5742025316451},
"2015-04"=>
{:revenue=>71992.81999999989,
:orders=>347,
:average_order_value=>207.47210374639738},
"2015-05"=>
{:revenue=>42235.979999999996,
:orders=>191,
:average_order_value=>221.1307853403141},
"2015-06"=>
{:revenue=>88859.9799999998,
:orders=>328,
:average_order_value=>270.9145731707311},
"2015-07"=>
{:revenue=>67149.15999999992,
:orders=>271,
:average_order_value=>247.78287822878198},
"2015-08"=>
{:revenue=>46142.31999999998,
:orders=>208,
:average_order_value=>221.8380769230768},
"2015-09"=>
{:revenue=>48104.44000000001,
:orders=>225,
:average_order_value=>213.79751111111116},
"2015-10"=>
{:revenue=>57245.32999999996,
:orders=>248,
:average_order_value=>230.82794354838694},
"2015-11"=>
{:revenue=>134040.46999999983,
:orders=>460,
:average_order_value=>291.39232608695613},
"2015-12"=>
{:revenue=>108475.4099999997,
:orders=>561,
:average_order_value=>193.3608021390369},
"2016-01"=>
{:revenue=>81531.8399999999,
:orders=>360,
:average_order_value=>226.47733333333304},
"2016-02"=>
{:revenue=>67367.75999999994,
:orders=>335,
:average_order_value=>201.09779104477593},
"2016-03"=>
{:revenue=>151414.83999999988,
:orders=>563,
:average_order_value=>268.9428774422733},
"2016-04"=>
{:revenue=>74410.35999999981,
:orders=>344,
:average_order_value=>216.3091860465111},
"2016-05"=>
{:revenue=>62098.399999999914,
:orders=>366,
:average_order_value=>169.6677595628413},
"2016-06"=>
{:revenue=>74919.99999999991,
:orders=>342,
:average_order_value=>219.06432748537986},
"2016-07"=>
{:revenue=>7904.39, :orders=>29, :average_order_value=>272.5651724137931}},
"lifetime_sales"=>2047541.369999998,
"average_order_value"=>230.52706259851362,
"customer_lifetime_value"=>1372.267287473714,
"average_annual_spend"=>274.4534574947428,
"unique_customer_count"=>6531,
"lifetime_orders"=>8882,
"top_referrers"=>
[{"revenue"=>1419009.9099999699, "orders"=>6219, "name"=>""},
{"revenue"=>362151.9000000038, "orders"=>1560, "name"=>"www.google.com.au"},
{"revenue"=>107079.34999999985, "orders"=>466, "name"=>"www.adreno.com.au"},
{"revenue"=>23283.710000000014, "orders"=>77, "name"=>"scubadiving.com.au"},
{"revenue"=>17234.540000000008,
"orders"=>66,
"name"=>"www.googleadservices.com"},
{"revenue"=>17212.210000000003, "orders"=>78, "name"=>"www.facebook.com"},
{"revenue"=>14986.340000000002, "orders"=>38, "name"=>"www.ozdiscount.com"},
{"revenue"=>13719.190000000006, "orders"=>70, "name"=>"www.bing.com"},
{"revenue"=>10240.470000000001, "orders"=>43, "name"=>"www.paypal.com"},
{"revenue"=>10213.78, "orders"=>46, "name"=>"www.google.com"}]}
Raw
OLD Everyone in Springbot.rb
OLD Everyone in Springbot (3753)
Customers: 23930
Emails: 23926
{"unique_customer_count"=>6516,
"month_to_date_sales"=>14151.230000000001,
"top_referrers"=>
[{"revenue"=>1432447.4499999695, "orders"=>6250, "name"=>""},
{"revenue"=>362843.8000000039, "orders"=>1565, "name"=>"www.google.com.au"},
{"revenue"=>107650.29999999984, "orders"=>470, "name"=>"www.adreno.com.au"},
{"revenue"=>23283.710000000014, "orders"=>77, "name"=>"scubadiving.com.au"},
{"revenue"=>17394.480000000007,
"orders"=>67,
"name"=>"www.googleadservices.com"},
{"revenue"=>17380.210000000003, "orders"=>79, "name"=>"www.facebook.com"},
{"revenue"=>14986.340000000002, "orders"=>38, "name"=>"www.ozdiscount.com"},
{"revenue"=>13719.190000000006, "orders"=>70, "name"=>"www.bing.com"},
{"revenue"=>10240.470000000001, "orders"=>43, "name"=>"www.paypal.com"},
{"revenue"=>10213.78, "orders"=>46, "name"=>"www.google.com"}],
"average_annual_spend"=>275.5580722172482,
"total_sales"=>923395.0999999988,
"sales_by_month"=>
{"2014-03"=>
{"revenue"=>5996.589999999998,
"orders"=>24,
"average_order_value"=>249.8579166666666},
"2014-04"=>
{"revenue"=>90244.42999999988,
"orders"=>360,
"average_order_value"=>250.6789722222219},
"2014-05"=>
{"revenue"=>51501.59999999997,
"orders"=>219,
"average_order_value"=>235.1671232876711},
"2014-06"=>
{"revenue"=>56820.65999999996,
"orders"=>208,
"average_order_value"=>273.1762499999998},
"2014-07"=>
{"revenue"=>74042.04,
"orders"=>316,
"average_order_value"=>234.31025316455694},
"2014-08"=>
{"revenue"=>47932.70999999999,
"orders"=>238,
"average_order_value"=>201.39794117647057},
"2014-09"=>
{"revenue"=>50686.309999999954,
"orders"=>236,
"average_order_value"=>214.7724999999998},
"2014-10"=>
{"revenue"=>63231.08999999999,
"orders"=>257,
"average_order_value"=>246.0353696498054},
"2014-11"=>
{"revenue"=>106426.72999999998,
"orders"=>473,
"average_order_value"=>225.00365750528536},
"2014-12"=>
{"revenue"=>81366.24999999996,
"orders"=>432,
"average_order_value"=>188.34780092592584},
"2015-01"=>
{"revenue"=>72649.17999999998,
"orders"=>331,
"average_order_value"=>219.48392749244707},
"2015-02"=>
{"revenue"=>69130.56,
"orders"=>224,
"average_order_value"=>308.61857142857144},
"2015-03"=>
{"revenue"=>98908.50999999982,
"orders"=>400,
"average_order_value"=>247.27127499999955},
"2015-04"=>
{"revenue"=>71992.81999999989,
"orders"=>347,
"average_order_value"=>207.47210374639738},
"2015-05"=>
{"revenue"=>42235.979999999996,
"orders"=>191,
"average_order_value"=>221.1307853403141},
"2015-06"=>
{"revenue"=>88859.9799999998,
"orders"=>328,
"average_order_value"=>270.9145731707311},
"2015-07"=>
{"revenue"=>67149.15999999992,
"orders"=>271,
"average_order_value"=>247.78287822878198},
"2015-08"=>
{"revenue"=>46142.31999999998,
"orders"=>208,
"average_order_value"=>221.8380769230768},
"2015-09"=>
{"revenue"=>48104.44000000001,
"orders"=>225,
"average_order_value"=>213.79751111111116},
"2015-10"=>
{"revenue"=>58298.52999999996,
"orders"=>251,
"average_order_value"=>232.26505976095604},
"2015-11"=>
{"revenue"=>134040.46999999983,
"orders"=>460,
"average_order_value"=>291.39232608695613},
"2015-12"=>
{"revenue"=>108475.4099999997,
"orders"=>561,
"average_order_value"=>193.3608021390369},
"2016-01"=>
{"revenue"=>81531.8399999999,
"orders"=>360,
"average_order_value"=>226.47733333333304},
"2016-02"=>
{"revenue"=>67563.75999999994,
"orders"=>337,
"average_order_value"=>200.4859347181007},
"2016-03"=>
{"revenue"=>153029.48999999987,
"orders"=>567,
"average_order_value"=>269.8932804232802},
"2016-04"=>
{"revenue"=>74460.30999999981,
"orders"=>345,
"average_order_value"=>215.8269855072458},
"2016-05"=>
{"revenue"=>62358.299999999916,
"orders"=>369,
"average_order_value"=>168.99268292682905},
"2016-06"=>
{"revenue"=>75238.99999999991,
"orders"=>343,
"average_order_value"=>219.3556851311951},
"2016-07"=>
{"revenue"=>14151.230000000001,
"orders"=>43,
"average_order_value"=>329.0983720930233}},
"top_five_product_ids"=>
["56d9371969702d2796eaa301",
"5628be3669702d4721cf8702",
"5628be5069702d4773d2b702",
"56d9372169702d27cfe4c100"],
"lifetime_orders"=>8924,
"lifetime_sales"=>2062569.6999999979,
"average_order_value"=>231.1261429852082,
"customer_lifetime_value"=>1377.7903610862409}
Raw
OLD Everyone Who Has Not Purchased.rb
OLD Everyone Who Has Not Purchased (3753)
Customers: 17414
Emails: 17414
{"unique_customer_count"=>9,
"month_to_date_sales"=>0,
"top_referrers"=>[],
"average_annual_spend"=>0,
"total_sales"=>0,
"sales_by_month"=>{},
"top_five_product_ids"=>[],
"lifetime_orders"=>0,
"lifetime_sales"=>0,
"average_order_value"=>0,
"customer_lifetime_value"=>0}
Raw
OLD Everyone Who Purchased.rb
OLD Everyone Who Purchased (3753)
Customers: 6494
Emails: 6494
{"unique_customer_count"=>6494,
"month_to_date_sales"=>7904.39,
"top_referrers"=>
[{"revenue"=>1419009.9099999694, "orders"=>6219, "name"=>""},
{"revenue"=>362151.9000000038, "orders"=>1560, "name"=>"www.google.com.au"},
{"revenue"=>107079.34999999985, "orders"=>466, "name"=>"www.adreno.com.au"},
{"revenue"=>23283.710000000014, "orders"=>77, "name"=>"scubadiving.com.au"},
{"revenue"=>17234.540000000008,
"orders"=>66,
"name"=>"www.googleadservices.com"},
{"revenue"=>17212.210000000003, "orders"=>78, "name"=>"www.facebook.com"},
{"revenue"=>14986.340000000002, "orders"=>38, "name"=>"www.ozdiscount.com"},
{"revenue"=>13719.190000000006, "orders"=>70, "name"=>"www.bing.com"},
{"revenue"=>10240.470000000001, "orders"=>43, "name"=>"www.paypal.com"},
{"revenue"=>10213.78, "orders"=>46, "name"=>"www.google.com"}],
"average_annual_spend"=>274.4534574947428,
"total_sales"=>913655.5599999987,
"sales_by_month"=>
{"2014-03"=>
{"revenue"=>5996.589999999998,
"orders"=>24,
"average_order_value"=>249.8579166666666},
"2014-04"=>
{"revenue"=>88754.72999999985,
"orders"=>358,
"average_order_value"=>247.91824022346327},
"2014-05"=>
{"revenue"=>51501.59999999996,
"orders"=>219,
"average_order_value"=>235.16712328767105},
"2014-06"=>
{"revenue"=>56820.659999999945,
"orders"=>208,
"average_order_value"=>273.17624999999975},
"2014-07"=>
{"revenue"=>74042.03999999998,
"orders"=>316,
"average_order_value"=>234.31025316455688},
"2014-08"=>
{"revenue"=>47932.709999999985,
"orders"=>238,
"average_order_value"=>201.3979411764705},
"2014-09"=>
{"revenue"=>50264.40999999995,
"orders"=>234,
"average_order_value"=>214.80517094017074},
"2014-10"=>
{"revenue"=>62154.78999999999,
"orders"=>255,
"average_order_value"=>243.7442745098039},
"2014-11"=>
{"revenue"=>105152.43000000001,
"orders"=>471,
"average_order_value"=>223.2535668789809},
"2014-12"=>
{"revenue"=>81366.24999999994,
"orders"=>432,
"average_order_value"=>188.34780092592578},
"2015-01"=>
{"revenue"=>72344.28999999998,
"orders"=>330,
"average_order_value"=>219.22512121212114},
"2015-02"=>
{"revenue"=>69130.56,
"orders"=>224,
"average_order_value"=>308.61857142857144},
"2015-03"=>
{"revenue"=>98186.80999999982,
"orders"=>395,
"average_order_value"=>248.5742025316451},
"2015-04"=>
{"revenue"=>71992.81999999989,
"orders"=>347,
"average_order_value"=>207.47210374639738},
"2015-05"=>
{"revenue"=>42235.98,
"orders"=>191,
"average_order_value"=>221.13078534031416},
"2015-06"=>
{"revenue"=>88859.9799999998,
"orders"=>328,
"average_order_value"=>270.9145731707311},
"2015-07"=>
{"revenue"=>67149.15999999993,
"orders"=>271,
"average_order_value"=>247.78287822878204},
"2015-08"=>
{"revenue"=>46142.31999999998,
"orders"=>208,
"average_order_value"=>221.8380769230768},
"2015-09"=>
{"revenue"=>48104.44000000001,
"orders"=>225,
"average_order_value"=>213.79751111111116},
"2015-10"=>
{"revenue"=>57245.329999999965,
"orders"=>248,
"average_order_value"=>230.82794354838697},
"2015-11"=>
{"revenue"=>134040.46999999983,
"orders"=>460,
"average_order_value"=>291.39232608695613},
"2015-12"=>
{"revenue"=>108475.4099999997,
"orders"=>561,
"average_order_value"=>193.3608021390369},
"2016-01"=>
{"revenue"=>81531.8399999999,
"orders"=>360,
"average_order_value"=>226.47733333333304},
"2016-02"=>
{"revenue"=>67367.75999999994,
"orders"=>335,
"average_order_value"=>201.09779104477593},
"2016-03"=>
{"revenue"=>151414.83999999988,
"orders"=>563,
"average_order_value"=>268.9428774422733},
"2016-04"=>
{"revenue"=>74410.35999999981,
"orders"=>344,
"average_order_value"=>216.3091860465111},
"2016-05"=>
{"revenue"=>62098.399999999914,
"orders"=>366,
"average_order_value"=>169.6677595628413},
"2016-06"=>
{"revenue"=>74919.99999999991,
"orders"=>342,
"average_order_value"=>219.06432748537986},
"2016-07"=>
{"revenue"=>7904.39,
"orders"=>29,
"average_order_value"=>272.5651724137931}},
"top_five_product_ids"=>
["56d9371969702d2796eaa301",
"5628be3669702d4721cf8702",
"5628be5069702d4773d2b702",
"56d9372169702d27cfe4c100"],
"lifetime_orders"=>8882,
"lifetime_sales"=>2047541.369999998,
"average_order_value"=>230.52706259851362,
"customer_lifetime_value"=>1372.267287473714}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment