DashThis & Google Sheet Integration

Category : Dashthis

DashThis has launched a new Google Sheet integration. From Zapier to Pinterest, you can now track any platform, CRMs, or proprietary data with Google spreadsheets and add all this data natively in your DashThis reports.

You get your very own custom reports. No add-ons needed! Custom calculations update automatically once the Google Sheet is updated. DashThis is currently connected to Google Sheets for our PIC Gmail accounts.

https://dashthis.com/integrations/google-sheets-reporting-tool/

Rosen & Perry Reviews Campaign

Category : General

Rosen & Perry sent us a list of clients to obtain reviews from – we had fallen way behind the competition.

Initially, we set up Birdeye, but it didn’t come across as professional enough for a high-profile law firm. Instead, we created a Mailchimp account and set up a basic template that resembles an email from Jon Perry that’s a little more personal.

We spread out the sends weekly to hit 15-30 people with each send. This keeps an influx of reviews from looking spammy. It also allows Jon Perry of the firm to respond personally to each review. So far, we’ve done 2 separate sends and hit 37 inboxes. This has resulted in 7 new reviews on Google (19% success rate).

Once we work through everyone, we’ll go back through and send a follow up to anyone who didn’t review on the first send.

GMB Profile = https://g.page/caringlawyers?share

Google’s Custom Audiences

Category : Knowledge Share

We can use custom audiences to target visitors who may be searching for terms around products and services, who have visited a competitor website, or who have shown interest in similar products or services you offer.

These are not remarketing audiences but a great way to get in front of someone who has not visited a client’s website.

The image below provides an example using the client with metal testing devices and services. We have implemented three of these audiences to test in the upcoming quarter:
-Visitors searching for Metal Testing
-Visitors who have visited a competitor website for Metal Testing Analysis
-Visitors searching for the devices (high-cost items) that Verichek uses to complete the Metal Testing

Facebook Budget Calculator

Category : Facebook

In order to know how much money you need in your Facebook budget, I created an excel sheet calculator based on information available in other resources. When you plug in a known or estimated variable such as CTR, CPM, Conversion Value, and Profit, you can determine how much money you will need to spend to reach your given goal.

The cells in the excel calculator that are shaded blue are adjustable. You can adjust the budget variables as necessary until you find the result you want. For example, if you are interested in a traffic goal, use “website sessions” as your end goal and disregard such variables as the sales / ecommerce areas.

This is an estimate as it does not account for diminishing returns or differences in audiences that your goals may be based on.

The Facebook Budget Calculator can be found in the PIC Intranet under “Clients – Pic > Social Media” and in the PIC Document Center. A direct link to the excel sheet is also provided.

Facebook Budget Calculator direct link