Campbells

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 317362,
      "site_id": 37,
      "cat_id": 57,
      "priority": 2,
      "url": "https://www.campbellslegal.com/",
      "title": "Campbells",
      "description": "Campbells is a leading full service offshore law firm established in 1970 with offices in Hong Kong, the Cayman Islands, and the British Virgin Islands. Campbells provides legal services and advice to clients worldwide with expert knowledge and a commitment to putting their clients first.\r\n",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 68560,
      "approve_dt": "2026-01-08T00:00:00.000Z",
      "source": null,
      "submit_dt": "2019-07-02T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 143,
      "referrals": null,
      "country": 270,
      "countrycode": "VG",
      "loc_id": 270,
      "state_id": 0,
      "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": 2225,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "956f5eac-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jul 02, 2019",
      "subcategory": "Legal Finance",
      "request_types": "",
      "visitcount": 213
   },
   "visits": {
      "storefront": 213,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 13,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Campbells is a leading full service offshore law firm established in 1970 with offices in Hong Kong, the Cayman Islands, and the British Virgin Islands. Campbells provides legal services and advice to clients worldwide with expert knowledge and a commitment to putting their clients first.\r\n",
      "service1": "arbitration and mediation",
      "service2": "banking and structured finance",
      "service3": "blockchain and fintech",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2019-07-02 10:01:34"
   },
   "location": {
      "uuid": "956f5eac-56da-11ed-b77c-b66e99367f32",
      "link_id": 317362,
      "account_id": 68560,
      "company": "Campbells",
      "sid": 37,
      "country": 270,
      "countrycode": "VG",
      "state": 0,
      "city": "0",
      "zip": "VG1110",
      "address": "Floor 4, Banco Popular Building",
      "phone": "1-284-852-4823",
      "fax": null,
      "email": "campbellsuk111@gmail.com",
      "name": "Campbells",
      "status": "",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "40.7040662",
      "lon": "-74.0111456",
      "statename": ""
   },
   "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": ""
}