The Google Helper

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 334892,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://thegooglehelper.com/",
      "title": "The Google Helper",
      "description": "We can get your business listed on Google, so you stop losing traffic and leads to your competitors. We are Google Experts. We provide Google Web Service Consulting, or ala carte selection of Google My Business Profiles, Knowledge Panels, Google Ads (formerly AdWords), Google Analytics, Google Reviews, Google Local Services Advertising, Google Screened Guaranteed Checkmarks, and Google Analytics with your Web Site. We empower Small to Medium Business with Google Expertise and Experience.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 85639,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-09-04T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 2,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 16,
      "city_id": 8546,
      "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": 5731,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "952c0cf6-6a89-11ef-ab46-b66e99367f32",
      "subdate": "Sep 04, 2024",
      "subcategory": "Web Design",
      "request_types": "",
      "visitcount": 23
   },
   "visits": {
      "storefront": 23,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 12,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "We can get your business listed on Google, so you stop losing traffic and leads to your competitors. We are Google Experts. We provide Google Web Service Consulting, or ala carte selection of Google My Business Profiles, Knowledge Panels, Google Ads (formerly AdWords), Google Analytics, Google Reviews, Google Local Services Advertising, Google Screened Guaranteed Checkmarks, and Google Analytics with your Web Site. We empower Small to Medium Business with Google Expertise and Experience.",
      "service1": "Google Marketing Services",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-09-04 06:47:42"
   },
   "location": {
      "uuid": "952c0cf6-6a89-11ef-ab46-b66e99367f32",
      "link_id": 334892,
      "account_id": 85639,
      "company": "The Google Helper",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 16,
      "city": "8546",
      "zip": "67203-3971",
      "address": "807 N Waco Ave, Suite 23C",
      "phone": "(316) 234-0060",
      "fax": null,
      "email": "thegooglehelper@burst-email.com",
      "name": "The Google Helper",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "37.6979175",
      "lon": "-97.3425899",
      "cityname": "Wichita",
      "statename": "Kansas"
   },
   "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": ""
}