Date Ranges

Manual min/max dates

Universal SQL min/max dates

ID Order Datetime Order Month First Name Last Name Email Address State Zipcode Item Category Sales Channel Channel Group Channel Month
1 2021-04-28 2021-04-01 Saxe MacCaughey smaccaughey0@vimeo.com 85 Bunting Trail Missouri 64.1k Model Racehorse Sinister Toys 13.0 Google Paid Paid Search Google Paid2021-04-01
2 2021-01-29 2021-01-01 Elisa McNelis emcnelis1@dagondesign.com 9 Leroy Center Nevada 89.1k Boxing Gloves Cursed Sporting Goods 21.0 Referral Referral Referral2021-01-01
3 2019-05-22 2019-05-01 Cliff Fussey cfussey2@163.com 728 Merry Alley New York 10.1k Mystic Pendant Mysterious Apparel 7.2 Referral Referral Referral2019-05-01
4 2021-06-03 2021-06-01 Gerald O'Kenny gokenny3@rakuten.co.jp 17 Sachtjen Place Florida 33.2k Mystic Pendant Mysterious Apparel 8.0 Google Organic Organic Search Google Organic2021-06-01
5 2021-01-26 2021-01-01 Genvieve Whitford gwhitford4@tinyurl.com 755 American Ash Road North Carolina 28.3k Baseball Card Sinister Toys 3.0 Facebook Ads Social Facebook Ads2021-01-01
6 2020-08-21 2020-08-01 Denise Spanswick dspanswick5@blogtalkradio.com 87 Cordelia Avenue California 95.2k Necklace Mysterious Apparel 13.0 Google Organic Organic Search Google Organic2020-08-01
7 2021-06-10 2021-06-01 Piotr Tomasik ptomasik6@bizjournals.com 8 Bay Crossing Colorado 80.0k Lamp Odd Equipment 34.0 Coupon Other Coupon2021-06-01
8 2021-02-06 2021-02-01 Koral Dubose kdubose7@marketwatch.com 6531 Kropf Avenue North Carolina 27.6k Microscope Odd Equipment 144.0 Google Paid Paid Search Google Paid2021-02-01
9 2020-11-12 2020-11-01 Stephine Josipovic sjosipovic8@mtv.com 641 Utah Hill South Dakota 57.1k Fishing Rod Cursed Sporting Goods 84.5 Google Organic Organic Search Google Organic2020-11-01
10 2019-08-21 2019-08-01 Melisandra Daniell mdaniell9@indiatimes.com 29 Old Shore Hill California 91.6k Microscope Odd Equipment 144.0 Google Paid Paid Search Google Paid2019-08-01
No Results

With string table

ID Order Datetime Order Month First Name Last Name Email Address State Zipcode Item Category Sales Channel Channel Group Channel Month
1 2021-04-28 2021-04-01 Saxe MacCaughey smaccaughey0@vimeo.com 85 Bunting Trail Missouri 64.1k Model Racehorse Sinister Toys 13.0 Google Paid Paid Search Google Paid2021-04-01
2 2021-01-29 2021-01-01 Elisa McNelis emcnelis1@dagondesign.com 9 Leroy Center Nevada 89.1k Boxing Gloves Cursed Sporting Goods 21.0 Referral Referral Referral2021-01-01
3 2019-05-22 2019-05-01 Cliff Fussey cfussey2@163.com 728 Merry Alley New York 10.1k Mystic Pendant Mysterious Apparel 7.2 Referral Referral Referral2019-05-01
4 2021-06-03 2021-06-01 Gerald O'Kenny gokenny3@rakuten.co.jp 17 Sachtjen Place Florida 33.2k Mystic Pendant Mysterious Apparel 8.0 Google Organic Organic Search Google Organic2021-06-01
5 2021-01-26 2021-01-01 Genvieve Whitford gwhitford4@tinyurl.com 755 American Ash Road North Carolina 28.3k Baseball Card Sinister Toys 3.0 Facebook Ads Social Facebook Ads2021-01-01
6 2020-08-21 2020-08-01 Denise Spanswick dspanswick5@blogtalkradio.com 87 Cordelia Avenue California 95.2k Necklace Mysterious Apparel 13.0 Google Organic Organic Search Google Organic2020-08-01
7 2021-06-10 2021-06-01 Piotr Tomasik ptomasik6@bizjournals.com 8 Bay Crossing Colorado 80.0k Lamp Odd Equipment 34.0 Coupon Other Coupon2021-06-01
8 2021-02-06 2021-02-01 Koral Dubose kdubose7@marketwatch.com 6531 Kropf Avenue North Carolina 27.6k Microscope Odd Equipment 144.0 Google Paid Paid Search Google Paid2021-02-01
9 2020-11-12 2020-11-01 Stephine Josipovic sjosipovic8@mtv.com 641 Utah Hill South Dakota 57.1k Fishing Rod Cursed Sporting Goods 84.5 Google Organic Organic Search Google Organic2020-11-01
10 2019-08-21 2019-08-01 Melisandra Daniell mdaniell9@indiatimes.com 29 Old Shore Hill California 91.6k Microscope Odd Equipment 144.0 Google Paid Paid Search Google Paid2019-08-01
No Results