Pinpoint Digital, LLC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 347972,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://pinpointdigital.com/",
      "title": "Pinpoint Digital, LLC",
      "description": "Pinpoint Digital, LLC is a Connecticut-based web design and development company founded in 2007 by John Giaccotto, who holds a B.S. in Computer Science and MBA with experience in web development since 1996. Rejecting one-size-fits-all approaches, the company begins each project with a discovery phase to understand clients' online goals and craft appropriate strategies, offering comprehensive design, development, and digital marketing services tailored to each client's unique needs.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 98667,
      "approve_dt": "2025-07-19T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-06-02T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 3,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 7,
      "city_id": 0,
      "ltop": "",
      "facebook": "",
      "tiktok": null,
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": null,
      "youtube": "",
      "youtube_title": null,
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": null,
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 269,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "0a289344-3f69-11f0-a909-b66e99367f32",
      "subdate": "Jun 02, 2025",
      "subcategory": "Marketing",
      "request_types": "",
      "visitcount": 62
   },
   "visits": {
      "storefront": 62,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 26,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Pinpoint Digital, LLC is a website design and digital marketing company in Plainville, Connecticut. We provide a wide range of services from helping you get online to helping to drive more leads to your business. Our digital marketing services include Search Engine Optimization as well as Google Ads management. Contact us today for a free quote.",
      "service1": "custom web design and development",
      "service2": " digital marketing strategy",
      "service3": " client discovery and consultation",
      "service4": " website programming and coding",
      "service5": " online marketing campaigns",
      "service6": " strategic web planning",
      "service7": " comprehensive digital solutions",
      "submit_dt": "2025-06-02 04:21:22"
   },
   "location": {
      "uuid": "0a289344-3f69-11f0-a909-b66e99367f32",
      "link_id": 347972,
      "account_id": 98667,
      "company": "Pinpoint Digital, LLC",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 7,
      "city": "",
      "zip": "06062",
      "address": "55 Whiting Street, Suite 3B, Plainville",
      "phone": "(860) 357-1925",
      "fax": null,
      "email": "pinpointdigital@mail-burst.com",
      "name": "Pinpoint Digital, LLC",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "41.6697418",
      "lon": "-72.8675586"
   },
   "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": ""
}