https://www.columbusmarketingexperts.com

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 337884,
      "site_id": 90,
      "cat_id": 90,
      "priority": 2,
      "url": "https://www.columbusmarketingexperts.com",
      "title": "https://www.columbusmarketingexperts.com",
      "description": " Everything you need to rank your business better and drive more conversions from Google. Our online marketing service provides local SEO but scales to international techniques and services for businesses, agencies, and other enterprises. We specialize in driving organic traffic, optimizing websites, and enhancing your brand's visibility. Our team delivers practical, result-oriented solutions tailored just for you. Ready to dominate the search engines?",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 88603,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-11-18T00: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": 34,
      "city_id": 17102,
      "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": 6519,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "bfd42baa-a55a-11ef-a909-b66e99367f32",
      "subdate": "Nov 18, 2024",
      "subcategory": "SEO",
      "request_types": "",
      "visitcount": 40
   },
   "visits": {
      "storefront": 40,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "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": "",
      "service1": "Search Engine Optimization",
      "service2": "Building and Optimizing Websites",
      "service3": "Complete Ads Campaigns Including Commercials",
      "service4": "Complete Social Media Management",
      "service5": "Backlink Building and Citations Building",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-11-18 03:11:05"
   },
   "location": {
      "uuid": "bfd42baa-a55a-11ef-a909-b66e99367f32",
      "link_id": 337884,
      "account_id": 88603,
      "company": "Columbus Marketing Experts",
      "sid": 90,
      "country": 277,
      "countrycode": "US",
      "state": 34,
      "city": "17102",
      "zip": "43026",
      "address": "3372 Paxton Court",
      "phone": "(614) 929-6411",
      "fax": null,
      "email": "columbusmarket@brite-mail.com",
      "name": "Columbus Marketing Experts",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "40.0215253",
      "lon": "-83.1373771",
      "cityname": "Hilliard",
      "statename": "Ohio"
   },
   "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": ""
}