The full presentation is available here in the Retrospective for Rock N Rescue’s Dealer Page LaunchPad & Growth Driven Design PIC’s LaunchPad websites are state-of-the-art websites, designed to current standards that give Marketing control of the content without reliance on the IT Department. GDD Themes Establish: (1)Harvest by adding action items to complete important items …
Use Google Sheets to Find Company URLs from Company Names
Problem: I needed to find Company URLs from company names to sync contacts to companies in HubSpot. Solution: Use, “https://autocomplete.clearbit.com/v1/companies/suggest?query=” along with the company name to fetch data on the company Create this function in Google Sheet scripts: function FETCH(url) { var response = UrlFetchApp.fetch(url); Logger.log(response.getContentText()); var out = JSON.parse(response.getContentText()); return out[0][“domain”]; } Run the …
Continue reading “Use Google Sheets to Find Company URLs from Company Names”
CallRail – Setting up goals for first time and repeat callers in Google Analytics
Tracking first-time callers: Category Setting: Phone Label Setting: Regular Expression Value: .*Call-01 Tracking additional calls: Category Setting: Phone Label Setting: Regular Expression Value: .*Call-.*[2-5]