Two Trees PPC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 335780,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://www.twotreesppc.com",
      "title": "Two Trees PPC",
      "description": "Full-service digital marketing agency with a focus on transparency, flexibility, and high-performance marketing campaigns. We offer the power of a full marketing team without the worry of constantly needing to train your team, and the constant recruitment of the best marketing talent. For the price of just one employee, we take care of all your marketing department needs - allowing your small marketing team to do the work of a much larger marketing team. We are focused on the success of our regional businesses and further contributing to our local economy. ",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 86523,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-09-23T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2436,
      "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": 5732,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "08b51db3-79ef-11ef-ab46-b66e99367f32",
      "subdate": "Sep 23, 2024",
      "subcategory": "Business Services",
      "request_types": "",
      "visitcount": 3
   },
   "visits": {
      "storefront": 3,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 1,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-09-23 21:01:42"
   },
   "location": {
      "uuid": "08b51db3-79ef-11ef-ab46-b66e99367f32",
      "link_id": 335780,
      "account_id": 86523,
      "company": "Two Trees PPC",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2436",
      "zip": "95827",
      "address": "9960 Business Park Dr, Sacramento, CA 95827",
      "phone": "19165806770",
      "fax": null,
      "email": "LESOrLtg.directory@usestyle.ai",
      "name": "Two Trees PPC",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "38.5745116",
      "lon": "-121.3276689",
      "cityname": "Sacramento",
      "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": ""
}