Tinkerwell

Code

use App\User;
use Laravel\Cashier\Order\Order;

$now = Carbon::now();
$week = Carbon::now()->subWeeks(52);

while ($now > $week) {
    $start = $week->startOfWeek()->toDateString();
    $end = $week->endOfWeek()->toDateString();

    echo "*$start - $end* \n";

    $newUsers = User::whereDate('created_at', '>=', $start)
        ->whereDate('created_at', '<=', $end)
        ->whereNull('mollie_mandate_id')
        ->get();
    echo "New users (free): {$newUsers->count()} \n";

    $newOrders = User::whereDate('created_at', '>=', $start)
        ->whereDate('created_at', '<=', $end)
        ->whereNotNull('mollie_mandate_id')
        ->get();
    echo "New users (paid): {$newOrders->count()} \n";

    echo "\n";
    $week->addWeek();
}

Output

[!] Aliasing 'Carbon' to 'Carbon\Carbon' for this Tinker session.
*2019-11-18 - 2019-11-24* 
New users (free): 3 
New users (paid): 0 

*2019-11-25 - 2019-12-01* 
New users (free): 13 
New users (paid): 0 

*2019-12-02 - 2019-12-08* 
New users (free): 3 
New users (paid): 0 

*2019-12-09 - 2019-12-15* 
New users (free): 6 
New users (paid): 0 

*2019-12-16 - 2019-12-22* 
New users (free): 10 
New users (paid): 1 

*2019-12-23 - 2019-12-29* 
New users (free): 1 
New users (paid): 0 

*2019-12-30 - 2020-01-05* 
New users (free): 8 
New users (paid): 1 

*2020-01-06 - 2020-01-12* 
New users (free): 15 
New users (paid): 1 

*2020-01-13 - 2020-01-19* 
New users (free): 10 
New users (paid): 0 

*2020-01-20 - 2020-01-26* 
New users (free): 8 
New users (paid): 0 

*2020-01-27 - 2020-02-02* 
New users (free): 7 
New users (paid): 0 

*2020-02-03 - 2020-02-09* 
New users (free): 12 
New users (paid): 0 

*2020-02-10 - 2020-02-16* 
New users (free): 11 
New users (paid): 0 

*2020-02-17 - 2020-02-23* 
New users (free): 15 
New users (paid): 0 

*2020-02-24 - 2020-03-01* 
New users (free): 8 
New users (paid): 0 

*2020-03-02 - 2020-03-08* 
New users (free): 9 
New users (paid): 0 

*2020-03-09 - 2020-03-15* 
New users (free): 5 
New users (paid): 0 

*2020-03-16 - 2020-03-22* 
New users (free): 9 
New users (paid): 0 

*2020-03-23 - 2020-03-29* 
New users (free): 8 
New users (paid): 0 

*2020-03-30 - 2020-04-05* 
New users (free): 12 
New users (paid): 1 

*2020-04-06 - 2020-04-12* 
New users (free): 10 
New users (paid): 0 

*2020-04-13 - 2020-04-19* 
New users (free): 7 
New users (paid): 0 

*2020-04-20 - 2020-04-26* 
New users (free): 9 
New users (paid): 0 

*2020-04-27 - 2020-05-03* 
New users (free): 5 
New users (paid): 0 

*2020-05-04 - 2020-05-10* 
New users (free): 8 
New users (paid): 0 

*2020-05-11 - 2020-05-17* 
New users (free): 8 
New users (paid): 0 

*2020-05-18 - 2020-05-24* 
New users (free): 10 
New users (paid): 0 

*2020-05-25 - 2020-05-31* 
New users (free): 14 
New users (paid): 0 

*2020-06-01 - 2020-06-07* 
New users (free): 11 
New users (paid): 0 

*2020-06-08 - 2020-06-14* 
New users (free): 9 
New users (paid): 0 

*2020-06-15 - 2020-06-21* 
New users (free): 9 
New users (paid): 1 

*2020-06-22 - 2020-06-28* 
New users (free): 13 
New users (paid): 1 

*2020-06-29 - 2020-07-05* 
New users (free): 30 
New users (paid): 1 

*2020-07-06 - 2020-07-12* 
New users (free): 46 
New users (paid): 0 

*2020-07-13 - 2020-07-19* 
New users (free): 23 
New users (paid): 3 

*2020-07-20 - 2020-07-26* 
New users (free): 14 
New users (paid): 3 

*2020-07-27 - 2020-08-02* 
New users (free): 18 
New users (paid): 0 

*2020-08-03 - 2020-08-09* 
New users (free): 4 
New users (paid): 1 

*2020-08-10 - 2020-08-16* 
New users (free): 14 
New users (paid): 0 

*2020-08-17 - 2020-08-23* 
New users (free): 13 
New users (paid): 0 

*2020-08-24 - 2020-08-30* 
New users (free): 7 
New users (paid): 0 

*2020-08-31 - 2020-09-06* 
New users (free): 47 
New users (paid): 4 

*2020-09-07 - 2020-09-13* 
New users (free): 18 
New users (paid): 0 

*2020-09-14 - 2020-09-20* 
New users (free): 11 
New users (paid): 0 

*2020-09-21 - 2020-09-27* 
New users (free): 16 
New users (paid): 0 

*2020-09-28 - 2020-10-04* 
New users (free): 15 
New users (paid): 1 

*2020-10-05 - 2020-10-11* 
New users (free): 22 
New users (paid): 0 

*2020-10-12 - 2020-10-18* 
New users (free): 10 
New users (paid): 1 

*2020-10-19 - 2020-10-25* 
New users (free): 32 
New users (paid): 3 

*2020-10-26 - 2020-11-01* 
New users (free): 27 
New users (paid): 4 

*2020-11-02 - 2020-11-08* 
New users (free): 16 
New users (paid): 1 

*2020-11-09 - 2020-11-15* 
New users (free): 16 
New users (paid): 0

Get free and paid users

Code

Output