Graybeard
Well-Known Member
Just what the title says ...
50K to 200K CPM/day after some testing
other media too ...
I don't have 10 monkeys working for me to check little boxes
An API is a MUST!
Why? this is why...
mysql> SELECT COUNT(zipcode_nb) FROM zip_names ;
+-------------------+
| COUNT(zipcode_nb) |
+-------------------+
| 16161 |
+-------------------+
1 row in set (0.05 sec) Entire USPS (national)
mysql> SELECT COUNT(zipcode_nb), metro_area FROM zip_names WHERE countyName REGEXP 'los angeles';
+-------------------+--------------------------------+
| COUNT(zipcode_nb) | metro_area |
+-------------------+--------------------------------+
| 270 | Los Angeles-Long Beach-Anaheim |
+-------------------+--------------------------------+
mysql> SELECT COUNT(zipcode_nb), metro_area FROM zip_names WHERE countyName REGEXP 'suffolk|fairfax|new york';
+-------------------+-----------------------------+
| COUNT(zipcode_nb) | metro_area |
+-------------------+-----------------------------+
| 135 | New York-Newark-Jersey City |
+-------------------+-----------------------------+
1 row in set (0.05 sec)
mysql> SELECT COUNT(zipcode_nb), metro_area FROM zip_names WHERE state_iso REGEXP 'NJ' AND metro_area REGEXP 'York-Newark-Jersey';
+-------------------+-----------------------------+
| COUNT(zipcode_nb) | metro_area |
+-------------------+-----------------------------+
| 363 | New York-Newark-Jersey City |
+-------------------+-----------------------------+
1 row in set (0.02 sec)
mysql> SELECT COUNT(zipcode_nb), metro_area FROM zip_names WHERE metro_area REGEXP 'Houston';
+-------------------+----------------------------------+
| COUNT(zipcode_nb) | metro_area |
+-------------------+----------------------------------+
| 204 | Houston-The Woodlands-Sugar Land |
+-------------------+----------------------------------+
1 row in set (0.04 sec)
Sk__y__p3: barry_555_5
50K to 200K CPM/day after some testing
other media too ...
I don't have 10 monkeys working for me to check little boxes
An API is a MUST!
Why? this is why...
mysql> SELECT COUNT(zipcode_nb) FROM zip_names ;
+-------------------+
| COUNT(zipcode_nb) |
+-------------------+
| 16161 |
+-------------------+
1 row in set (0.05 sec) Entire USPS (national)
mysql> SELECT COUNT(zipcode_nb), metro_area FROM zip_names WHERE countyName REGEXP 'los angeles';
+-------------------+--------------------------------+
| COUNT(zipcode_nb) | metro_area |
+-------------------+--------------------------------+
| 270 | Los Angeles-Long Beach-Anaheim |
+-------------------+--------------------------------+
mysql> SELECT COUNT(zipcode_nb), metro_area FROM zip_names WHERE countyName REGEXP 'suffolk|fairfax|new york';
+-------------------+-----------------------------+
| COUNT(zipcode_nb) | metro_area |
+-------------------+-----------------------------+
| 135 | New York-Newark-Jersey City |
+-------------------+-----------------------------+
1 row in set (0.05 sec)
mysql> SELECT COUNT(zipcode_nb), metro_area FROM zip_names WHERE state_iso REGEXP 'NJ' AND metro_area REGEXP 'York-Newark-Jersey';
+-------------------+-----------------------------+
| COUNT(zipcode_nb) | metro_area |
+-------------------+-----------------------------+
| 363 | New York-Newark-Jersey City |
+-------------------+-----------------------------+
1 row in set (0.02 sec)
mysql> SELECT COUNT(zipcode_nb), metro_area FROM zip_names WHERE metro_area REGEXP 'Houston';
+-------------------+----------------------------------+
| COUNT(zipcode_nb) | metro_area |
+-------------------+----------------------------------+
| 204 | Houston-The Woodlands-Sugar Land |
+-------------------+----------------------------------+
1 row in set (0.04 sec)
Sk__y__p3: barry_555_5
Last edited: