There are two custom services running on the deployed machines that are essential for the solution to function properly. These services are gcs-sync (running on WordPress instances – both Admin and Content) and cloudsql-proxy (running on the SQL Proxy instances).
The gcs-sync service runs a script /opt/c2d/downloads/gcs-sync that, depending on the role the VM is assigned (Content or Admin), will check in with the GCS bucket tied to the deployment and determine if content needs to be pushed to or pulled from GCS. If you need to interact with the service, you can do so via systemctl. For example:
systemctl stop gcs-sync
will kill the script checking GCS, and the node will not receive any updates that come from the Administrator Node. Conversely, if the service needs to be started you can do so with the following command:
systemctl start gcs-sync
The cloudsql-proxy service makes use of the Cloud SQL Proxy binary so you can connect to your Cloud SQL instance without having to whitelist IP addresses, which can change when instances are deleted and recreated in a Managed Instance Group. The Cloud SQL binary is located at /opt/c2d/downloads/cloud_sql_proxy and the script that executes the binary is located at /opt/c2d/downloads/cloudsql-proxy. Like the service that runs gcs-sync, it can be interacted with using systemctl. Stopping the service can be done with:
systemctl stop cloudsql-proxy
At this point your instance will not be able to communicate with the Cloud SQL instance, and the application will not function. If you needed to manually start the service for any reason you can do so with the following command:
I say be “Trumped” because for all that he did wrong in tarditional campaigning, he did Political SEO better than anyone had before.
I’ve always been a political guy. I love using technology to those political ends. Earlier this year I was able to leverage my experience in SEO, Adwords, cloud computing, data analysis and web design for a political candidate. It’s why these unique products are bundled into what I offer through Upwork. Today there is no excuse for a candidate to neglect digital media needs. Local candidates can easily benefit from a solid online presence for much less than they might think. The past experience with Brent Ackerson’s campaign was very encouraging.
I’ve started to reposition satellite sites made in March for a new project I’ll mention below. VoteLouisville.com for instance is intended to be a voter education site for anyone who wants to post I just so happen to post all of the stuff there. I have some further plans for louisvilleelection.com but those are all in my head.
All of these sites are hosted by my Google and Amazon cloud accounts, so that stuff has come in handy. I hope to attract additional campaign work if not in 2018 by 2020. I figured this new niche deserved a site so I’m working on candidateseo.com with a handful of .net names also headed there just for ease of use.
I said at the a campaign meeting that I felt radio and TV ads were as effective as yelling out a window. I still feel that way, even more so each day. In these meetings people point out I’m tech savy but others still watch TV … then I think of my 88 and 92 yr old grandparents who recently decided Netflix, Amazon and Hulu were all they needed.
My Grandmother is the idea focus for a campaign, everyone knows older people vote much more regularly and reliably than younger people. She has 29 children, grand children and great grand children. Living in half a dozen states I think now. Guess what that means…she’s on Digital mediums 29 times the amount you’d probably expect.
I’ve also explained to candidates that it is a growing trend for a voter to arrive on election day with one or two races already decided. This voter is now faced with several other races on the same ballot and will likely reach for their phone and decide who to vote for with only minutes of searching for the office or candidates. The results of these searches will ultimately decide these votes. Interestingly the money needed for Political SEO and Campaign Site Digital Marketing, creating content with the candidate amounts to a fraction of what campaigns will spend on radio.
I’ve added Candidate SEO to my domain family because I figured I needed a site as unique as this niche.
Real estate brokers say location, location, location. Did you know that first position in Google search results gets about 35% of users focus but 3rd gets some where around 7%? If one candidate SEOs their site and a negative site against the other unprepared candidate that could be the election.
I’ll be focused these next months on politics and SEO again. I’m excited that Judge Sean Delahanty has signed on board with me to help him get out his digital message. I’ve only had a couple weeks to put into this but check out his new campaign site. There is method to the madness, Ive also create a sister site that serves as a funnel or over flow thats officially the campaign committee‘s site.
Social Media – Candidate SEO – “You’re going to be popularrr”
Most of you will look at this wall of profiles and think to yourself who is ever going to go to these? If you did and you’re running for office send me an email…you need me. These sites aren’t REALLY there to be read by people. All of these sites are visited by search engines and these sites frame an image of a candidate to Google. All of these social media accounts ultimately end up at the campaign site, there is value in reaching voters … but you’ll reach voters if you are at the top of their searches.
I’ll post shortly about the positioning the sites are reaching. If you are running for office in Louisville Kentucky and looking for what you dont know you need reach out to me. Not convinced you need me? What would you say is the least important phrase for me to ranking these pages for on Google? If you aren’t thinking the candidates name you should email me. I’ll explain after the election or ya best ask in person.
Future post I’ll explain why IP based Digital Marketing is so 2001! Don’t do it…its technically and human behaviorally flawed.
Just in case anyone was worried I have not disclosed anything that someone can learn within a little bit of research concerning my candidate’s sites. All the secret sauce is still in the bottle.
I have a solid record of identifying a problem and making a solution that yields measurable results. I was recently the technology manager for a political campaign where I built a WHM/cPanel server on CentOS using Amazon Web Services to host about 14 WordPress websites. The server also provides mailing lists, a team management site, RSS feeds augmentation and its own name servers. I was able to get the server and sites built in a couple months.
I’ve managed the SEO and Adwords for these sites and have data that helps demonstrate the value I added to the organization.
I currently host all of these sites on an Amazon Web Services (AWS) EC2 server running CentOS and WHM. I also built an SQL server with large tables of voter records, city crimes, city financial payments, jail population censuses, web traffic data. This web server is integrated with Google Data Studio providing easily understood graphics. I used Google Cloud Platform for the SQL database solution.
Driving Traffic With SEO
Brentackerson.com channel results were organic and social media driven
Ackerson2018.com channel results were Adwords and paid searches
Each of these sites is intended to attract different target crowds and through SEO optimization, these sites were indexed with the keywords we needed. I’m able to see the effect of this through Google Search Console and Google Analytics.
Search Console lets us see what Google indexed
It’s important that sites remain fresh and update often. Several RSS feeds are collected into one site that then publishes posts through feeds that meet the target audience of different sites. The sites also have keyword auto linking. In the political campaign we built links for the office our candidate was seeking and links for the other candidate to a negative news site. I also posted custom content further building the content quality.
All of these sites had updated sitemaps and robots.txt files. With content that offers linked keywords tailored to the site’s audiences I were able to build on our page traffic and relevancy. Within Weeks we were a top result between the 3rd and 6th position for our competitor’s name.
I have built a network of these sites, with keywords in the domain name. This can be helpful in SEO ranking but also has been proven to increase user click rates with users in unpaid searches. Some sites have a more newspaper feel, some a magazine, others may focus on videos but all of them are meant to capture users and ultimately direct them to a site targeted to them.
Google Analytics Site Statistics Using Google Data Studio and Adwords
I’ve integrated Youtube and Facebook accounts as well as created Tumblr, Pinterest and other social media accounts that can be auto updated from the sites posts. These are intended to continue to spread the word about our site and activities. The social media links improve our ranking. These feeder sites funnel users into the campaign’s primary site.
The SEO of https://www.brentackerson.com was something I was asked to improve and through these sites and social media posts I improved its position from 63rd to 3.6 when searching the candidates name on Google in under two months. Several other keywords are now are well associated with the site. The additional targeted sites and social media accounts were essential to improving the main site’s ranking by giving me plenty of opportunity to back link to the original site.
Performance using Google Adwords. We have a highly targeted audience (one county’s primary voters) On a weekend day before 5pm 14,000 times the candidates name was displayed, 3.4% clicked the search Ads which is actually pretty good. Our Videos are viewed at 28% meaning 1,210 videos were watched. Our target was 2% CTR and 15% View Rate.
The numbers above compare the current 3 day period with the previous 3 day period.
MORE ABOUT ME:
EXPERIENCE: Prior to my current position I worked at Accenture for two years as an Instructional Designer and as a Big Data Technical Trainer for HP for two years. While I was a Help Desk Lead I was able to create a technical training program at Enova Financial.
MBA in Technology Management
MEd Instructional Design
BS Information Technology