G-Accon is an Add-On in Google Sheets that allows for connection and integration with HubSpot.

We can upload analytics reports into Google Sheets and use the DashThis-Google Sheets integration to create reporting widgets based on HubSpot data. A 2-way synchronization allows data updated in the Google Sheet to be updated in HubSpot as well.

Automation allows you to refresh data on a schedule and email an export of that data to yourself or a client!

https://app.hubspot.com/ecosystem/4211083/marketplace/apps/marketing/analytics-data/g-accon

In the past few months, we’ve avoided potentially catastrophic issues related to domain renewals and registrars with CaringLawyers.com and MyOfficeFurniture.net.

With CaringLawyers.com, the site and email went down as a result of the domain expiring. This was previously handled by an old IT team who did not hand off or clarify who had access to the domain upon their contract expiring.

We performed a check-in on domain expiration with MyOfficeFurniture.net and “lucked” into finding that OFW’s original registrar had shut down that side of the business. PIC had to backtrack through several companies to re-obtain access to their DNS settings.

Domains expiring are almost worst case scenarios in our industry, next to someone else buying the domain upon expiration or backups not working. IT teams have providen unreliable and unorganized when it comes to managing this information. Also, clients often lose track of who registered or is responsible for renewing the domain at a company.

For all sites that PIC builds, redesigns, or manage, we need to track and store domain registration information so we can avoid these issues.

In preparation of Black Friday and Cyber Monday, we began to segment our main Smart Shopping Campaign into three Smart Shopping Campaigns with our client Lion Country Supply. First we looked at products under $30 with a goal of 500% Return on Ad Spend (ROAS). The next segment is products between $30 and $100 with a goal of 350% ROAS. Lastly, we have a segment for products over $100 with a goal of 350% ROAS. In this process, we found a few benefits to our system!

We now have control over ROAS by pricing group. This provides clarity on how profitable we are at a segmented level and allows us to easily see by price breakdown against the entire product library.

We can optimize to profit margins. In our current trial, Lion Country Supply makes $200 off a Garmin Collar but $2 off a Lion Country Supply non-electronic collar. Splitting our campaigns has allowed us to be very aggressive with the ROAS for low-cost items.

Smart Shopping Campaigns also allows varying Cost Per Click (CPC) on items with a different price. In our Lion Country Supply example, we have our variables set for under $30 at $0.25 CPC, between $30 and $100 at $0.54 CPC, and over $100 at $0.64 CPC.

Below you can see a snapshot of these three campaigns and the corresponding transactions, revenue, and ROAS for each! In Part 2 I will show my analysis of the test and other changes we’ve made during the next month.