Advertising Consulting SEO Internet Marketing Web Design Printing Ad Specs

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 309345,
      "site_id": 6,
      "cat_id": 39,
      "priority": 0,
      "url": "http://www.PamsConsulting.com",
      "title": "Advertising Consulting   SEO   Internet Marketing  Web Design  Printing  Ad Specs",
      "description": "Pam and her team can show you how to improve your bottom line by helping to optimize your business from accounting to sales.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 60581,
      "approve_dt": "2015-08-09T00:00:00.000Z",
      "source": null,
      "submit_dt": "2015-04-28T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 779,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2037,
      "ltop": "",
      "facebook": "http://www.facebook.com/pages/Pams-Consulting/328296147380314",
      "tiktok": "",
      "linkedin": "",
      "twitter": "",
      "googleplus": "http://plus.google.com/+PamsConsulting",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": "",
      "pinterest": "",
      "yelp": "http://www.yelp.com/biz/Pams-Consulting-Huntington-Beach",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 1,
      "googlebot": 0,
      "yahoobot": 0,
      "msnbot": 0,
      "author_id": 0,
      "subcat_id": 261,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "com-",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "954775d1-56da-11ed-b77c-b66e99367f32",
      "subdate": "Apr 28, 2015",
      "subcategory": "Consultants",
      "request_types": "",
      "visitcount": 980
   },
   "visits": {
      "storefront": 980,
      "articles": 0,
      "videos": 0,
      "reviews": 21,
      "coupons": 0,
      "products": 0,
      "social": 16,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Pam's Consulting is a business consultant that also provides advertising consulting, SEO - search engine optimizing, web design, hosting, printing, business cards, flyers, menus, banners, advertising specialty items&promotional items. We service all of Southern California including cities from Orange County such as Anaheim, Buena Park, Cypress Cerritos, Fullerton, Huntington Beach, Irvine, Laguna Beach, Lakeforest, Mission Viejo, San Clemente - cities in Los Angeles County such as Santa Monica, Burbank, Palos Verdes, Torrance, Carson, Gardena, Hermosa Beach, Manhattan Beach, Redondo Beach, Long Beach - and all of San Diego County. ",
      "service1": "advertising consulting",
      "service2": " business consulting",
      "service3": " search engine optimizing",
      "service4": " internet marketing",
      "service5": " web design",
      "service6": " web hosting",
      "service7": " printing",
      "submit_dt": "2015-04-28 21:22:01"
   },
   "location": {
      "uuid": "954775d1-56da-11ed-b77c-b66e99367f32",
      "link_id": 309345,
      "account_id": 60581,
      "company": "Pam's Consulting",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2037",
      "zip": "92649",
      "address": "Do Not Publish",
      "phone": "",
      "fax": "",
      "email": "",
      "name": "",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "33.721051",
      "lon": "-118.0478826",
      "cityname": "Huntington Beach",
      "statename": "California"
   },
   "socialmedia": [
      {
         "title": "Facebook",
         "ptype_id": 29,
         "dbtable": "links_socialmedia",
         "item": "Page",
         "cnt": null
      },
      {
         "title": "Instagram",
         "ptype_id": 30,
         "dbtable": "links_socialmedia",
         "item": "Page",
         "cnt": null
      },
      {
         "title": "Youtube",
         "ptype_id": 31,
         "dbtable": "links_socialmedia",
         "item": "Youtube Video",
         "cnt": null
      },
      {
         "title": "LinkedIn",
         "ptype_id": 32,
         "dbtable": "links_socialmedia",
         "item": "Page",
         "cnt": null
      },
      {
         "title": "TikTok",
         "ptype_id": 33,
         "dbtable": "links_socialmedia",
         "item": "Videos",
         "cnt": null
      },
      {
         "title": "Twitter",
         "ptype_id": 34,
         "dbtable": "links_socialmedia",
         "item": "Page",
         "cnt": null
      },
      {
         "title": "Reddit",
         "ptype_id": 37,
         "dbtable": "links_socialmedia",
         "item": "Reddit",
         "cnt": null
      },
      {
         "title": "SnapChat",
         "ptype_id": 38,
         "dbtable": "links_socialmedia",
         "item": "SnapChat",
         "cnt": null
      }
   ],
   "promos": [
      {
         "item": "article",
         "cnt": 0
      },
      {
         "item": "video",
         "cnt": 0
      },
      {
         "item": "product",
         "cnt": 0
      },
      {
         "item": "coupon",
         "cnt": 0
      },
      {
         "item": "service",
         "cnt": 0
      },
      {
         "item": "article_external",
         "cnt": 0
      },
      {
         "item": "video_external",
         "cnt": 0
      },
      {
         "item": "product_external",
         "cnt": 0
      },
      {
         "item": "coupon_external",
         "cnt": 0
      },
      {
         "item": "service_external",
         "cnt": 0
      }
   ],
   "featuredproduct": ""
}