Skip to content

Instantly share code, notes, and snippets.

View bradlucas's full-sized avatar

Brad Lucas bradlucas

41 followers · 42 following
View GitHub Profile
@bradlucas
bradlucas / ibotta-report-2018-05-25.csv
Created May 26, 2018 12:02
ad_name os date imps clicks spend ?column? ?column? pi_conversions pc_conversions registrations month year bucket
Back to School 45 iOS 2018-05-25 0 0 0.00 0 0 0 May 2018 45 Day Dormant
Evergreen 45 Android 2018-05-25 0 0 0.00 0 0 0 May 2018 45 Day Dormant
Generic 2017 45 Android 2018-05-25 1 0 0.00 0 0 0 May 2018 45 Day Dormant
Registered Not Redeemed 0-14 Days Android 2018-05-25 0 0 0.00 0 0 0 May 2018
Cash Back 60 iOS 2018-05-25 3 0 0.00 0 0 0 May 2018 60 Day Dormant
Evergreen 60 Android 2018-05-25 0 0 0.00 0 0 0 May 2018 60 Day Dormant
Not Registered Android 2018-05-25 0 0 0.00 0 0 0 May 2018
Save Money 45 Android 2018-05-25 0 0 0.00 0 0 0 May 2018 45 Day Dormant
Cash Back 60 Android 2018-05-25 0 0 0.00 0 0 0 May 2018 60 Day Dormant
@bradlucas
bradlucas / ibotta-report-2018-05-24.csv
Created May 25, 2018 12:01
ad_name os date imps clicks spend ?column? ?column? pi_conversions pc_conversions registrations month year bucket
Back to School 45 iOS 2018-05-24 0 0 0.00 0 0 0 May 2018 45 Day Dormant
Evergreen 45 Android 2018-05-24 0 0 0.00 0 0 0 May 2018 45 Day Dormant
Generic 2017 45 Android 2018-05-24 0 0 0.00 0 0 0 May 2018 45 Day Dormant
Registered Not Redeemed 0-14 Days Android 2018-05-24 0 0 0.00 0 0 0 May 2018
Evergreen 60 Android 2018-05-24 0 0 0.00 0 0 0 May 2018 60 Day Dormant
Not Registered Android 2018-05-24 0 0 0.00 0 0 0 May 2018
Save Money 45 Android 2018-05-24 0 0 0.00 0 0 0 May 2018 45 Day Dormant
Cash Back 60 Android 2018-05-24 0 0 0.00 0 0 0 May 2018 60 Day Dormant
Cash Back 45 Android 2018-05-24 0 0 0.00 0 0 0 May 2018 45 Day Dormant
@bradlucas
bradlucas / ibotta-report-2018-05-23.csv
Created May 24, 2018 12:02
ad_name os date imps clicks spend ?column? ?column? pi_conversions pc_conversions registrations month year bucket
Generic 2017 45 Android 2018-05-23 1 0 0.00 0 0 0 May 2018 45 Day Dormant
Evergreen 45 Android 2018-05-23 0 0 0.00 0 0 0 May 2018 45 Day Dormant
Back to School 45 iOS 2018-05-23 0 0 0.00 0 0 0 May 2018 45 Day Dormant
Registered Not Redeemed 0-14 Days Android 2018-05-23 0 0 0.00 0 0 0 May 2018
Cash Back 60 iOS 2018-05-23 0 0 0.00 0 0 0 May 2018 60 Day Dormant
Evergreen 45 iOS 2018-05-23 0 0 0.00 0 0 0 May 2018 45 Day Dormant
Evergreen 60 Android 2018-05-23 0 0 0.00 0 0 0 May 2018 60 Day Dormant
Not Registered Android 2018-05-23 3 0 0.00 0 0 0 May 2018
Save Money 45 Android 2018-05-23 0 0 0.00 0 0 0 May 2018 45 Day Dormant
@bradlucas
bradlucas / ibotta-report-2018-05-22.csv
Created May 23, 2018 12:02
ad_name os date imps clicks spend ?column? ?column? pi_conversions pc_conversions registrations month year bucket
Back to School 45 iOS 2018-05-22 0 0 0.00 0 0 0 May 2018 45 Day Dormant
Evergreen 45 Android 2018-05-22 0 0 0.00 0 0 0 May 2018 45 Day Dormant
Generic 2017 45 Android 2018-05-22 1 0 0.00 0 0 0 May 2018 45 Day Dormant
Registered Not Redeemed 0-14 Days Android 2018-05-22 0 0 0.00 0 0 0 May 2018
Not Registered iOS 2018-05-22 0 0 0.00 0 0 0 May 2018
Evergreen 45 iOS 2018-05-22 0 0 0.00 0 0 0 May 2018 45 Day Dormant
Evergreen 60 Android 2018-05-22 0 0 0.00 0 0 0 May 2018 60 Day Dormant
Not Registered Android 2018-05-22 0 0 0.00 0 0 0 May 2018
Save Money 45 Android 2018-05-22 0 0 0.00 0 0 0 May 2018 45 Day Dormant
@bradlucas
bradlucas / ibotta-report-2018-05-21.csv
Created May 22, 2018 12:01
ad_name os date imps clicks spend ?column? ?column? pi_conversions pc_conversions registrations month year bucket
Generic 2017 45 Android 2018-05-21 1 0 0.00 0 0 0 May 2018 45 Day Dormant
Evergreen 45 Android 2018-05-21 0 0 0.00 0 0 0 May 2018 45 Day Dormant
Registered Not Redeemed 0-14 Days Android 2018-05-21 0 0 0.00 0 0 0 May 2018
Registered Not Redeemed 0-14 Days iOS 2018-05-21 0 0 0.00 0 0 0 May 2018
Cash Back 60 iOS 2018-05-21 3 0 0.00 0 0 0 May 2018 60 Day Dormant
Evergreen 60 Android 2018-05-21 0 0 0.00 0 0 0 May 2018 60 Day Dormant
Not Registered Android 2018-05-21 0 0 0.00 0 0 0 May 2018
Save Money 45 Android 2018-05-21 0 0 0.00 0 0 0 May 2018 45 Day Dormant
Cash Back 60 Android 2018-05-21 0 0 0.00 0 0 0 May 2018 60 Day Dormant
@bradlucas
bradlucas / ibotta-report-2018-05-20.csv
Created May 21, 2018 12:02
ad_name os date imps clicks spend ?column? ?column? pi_conversions pc_conversions registrations month year bucket
Generic 2017 45 Android 2018-05-20 1 1 0.60 0 0 0 May 2018 45 Day Dormant
Evergreen 45 Android 2018-05-20 0 0 0.00 0 0 0 May 2018 45 Day Dormant
Back to School 45 iOS 2018-05-20 0 0 0.00 0 0 0 May 2018 45 Day Dormant
Registered Not Redeemed 0-14 Days Android 2018-05-20 0 0 0.00 0 0 0 May 2018
Evergreen 45 iOS 2018-05-20 1 0 0.00 0 0 0 May 2018 45 Day Dormant
Evergreen 60 Android 2018-05-20 0 0 0.00 0 0 0 May 2018 60 Day Dormant
Not Registered Android 2018-05-20 0 0 0.00 0 0 0 May 2018
Save Money 45 Android 2018-05-20 0 0 0.00 0 0 0 May 2018 45 Day Dormant
Cash Back 60 Android 2018-05-20 0 0 0.00 0 0 0 May 2018 60 Day Dormant
@bradlucas
bradlucas / ibotta-report-2018-05-19.csv
Created May 20, 2018 12:01
ad_name os date imps clicks spend ?column? ?column? pi_conversions pc_conversions registrations month year bucket
Generic 2017 45 Android 2018-05-19 1 0 0.00 0 0 0 May 2018 45 Day Dormant
Registered Not Redeemed 0-14 Days iOS 2018-05-19 0 0 0.00 0 0 0 May 2018
Back to School 45 iOS 2018-05-19 0 0 0.00 0 0 0 May 2018 45 Day Dormant
Evergreen 45 Android 2018-05-19 0 0 0.00 0 0 0 May 2018 45 Day Dormant
Registered Not Redeemed 0-14 Days Android 2018-05-19 0 0 0.00 0 0 0 May 2018
Not Registered iOS 2018-05-19 0 0 0.00 0 0 0 May 2018
Evergreen 45 iOS 2018-05-19 3 1 0.60 0 0 0 May 2018 45 Day Dormant
Evergreen 60 Android 2018-05-19 0 0 0.00 0 0 0 May 2018 60 Day Dormant
Not Registered Android 2018-05-19 0 0 0.00 0 0 0 May 2018
@bradlucas
bradlucas / ibotta-report-2018-05-18.csv
Created May 19, 2018 12:01
ad_name os date imps clicks spend ?column? ?column? pi_conversions pc_conversions registrations month year bucket
Back to School 45 iOS 2018-05-18 0 0 0.00 0 0 0 May 2018 45 Day Dormant
Evergreen 45 Android 2018-05-18 0 0 0.00 0 0 0 May 2018 45 Day Dormant
Generic 2017 45 Android 2018-05-18 0 0 0.00 0 0 0 May 2018 45 Day Dormant
Registered Not Redeemed 0-14 Days Android 2018-05-18 0 0 0.00 0 0 0 May 2018
Evergreen 60 Android 2018-05-18 0 0 0.00 0 0 0 May 2018 60 Day Dormant
Not Registered Android 2018-05-18 0 0 0.00 0 0 0 May 2018
Save Money 45 Android 2018-05-18 0 0 0.00 0 0 0 May 2018 45 Day Dormant
Cash Back 60 Android 2018-05-18 0 0 0.00 0 0 0 May 2018 60 Day Dormant
Cash Back 45 iOS 2018-05-18 0 0 0.00 0 0 0 May 2018 45 Day Dormant
@bradlucas
bradlucas / unzip_if_necessary.py
Last active May 22, 2018 08:59
Unzip gz file if necessary
def unzip_if_necessary(self, filename):
print "unzip_if_necessary: " + filename
f = open(filename)
# Read magic number (the first 2 bytes) and rewind.
magic_number = f.read(2)
f.seek(0)
f.close()
if magic_number == '\x1f\x8b':
@bradlucas
bradlucas / ibotta-report-2018-05-17.csv
Created May 18, 2018 12:02
ad_name os date imps clicks spend ?column? ?column? pi_conversions pc_conversions registrations month year bucket
Generic 2017 45 Android 2018-05-17 1 0 0.00 0 0 0 May 2018 45 Day Dormant
Evergreen 45 Android 2018-05-17 0 0 0.00 1 0 0 May 2018 45 Day Dormant
Back to School 45 iOS 2018-05-17 0 0 0.00 0 0 0 May 2018 45 Day Dormant
Registered Not Redeemed 0-14 Days Android 2018-05-17 0 0 0.00 0 0 0 May 2018
Cash Back 60 iOS 2018-05-17 0 0 0 May 2018 60 Day Dormant
Not Registered iOS 2018-05-17 0 0 0 May 2018
Back to School 45 Android 2018-05-17 2 0 0.00 0 0 0 May 2018 45 Day Dormant
Evergreen 45 iOS 2018-05-17 0 0 0 May 2018 45 Day Dormant
Evergreen 60 Android 2018-05-17 0 0 0.00 0 0 0 May 2018 60 Day Dormant