Tuesday, June 21, 2016

How to use “dark social” and “dark social sharing”

According to http://www.clickz.com/clickz/column/2318344/tracking-dark-social-media-a-light-at-the-end-of-the-tunnel you can use the following tools to track dark social sharing, Tynt (free software) or Rio SEO (paid for software) or you create an advanced segment in Google Analytics to further analyze traffic.


What is dark social?

Dark social is basically any traffic you get to your site because your analytics can't correctly identify the site sending you the traffic and accounts for up to 60% of overall referral traffic for various websites. . In simple terms, referral traffic is usually identified by certain “tags” attached to the link whenever it’s shared.  There are two main reasons why your analytics wouldn't be able to figure out the exact source of a visit:

1) If the visitor is coming from a source that can't be traced by your analytics program.
This is what we were talking about: via text message while browsing on your mobile, one-to-one emails or your company's IM client or you viewing an article on another person's computer with them. Most often, the reason your analytics can't keep track of the source of the traffic is because the source doesn't send referral data -- which is how the rest of your analytics gets bucketed.

When someone clicks on your site's URL on Twitter, for example, Twitter will let your analytics know that that's where the visitor came from.

2) If someone shares a link with UTM parameters (those little strips of code you manually add to a URL to track traffic sources, among other things) on an incorrect platform.
For instance, if someone were to share a link through email with UTM parameters on it that designate visitors who click on that link as coming from Twitter, the person they shared it with would get bucketed into the Twitter source category ... even though they didn't actually come from Twitter. 
What dark social is NOT is the "Not Provided" under your organic search settings. Though not knowing what keywords are sending you traffic is definitely frustrating, your analytics still knows that people are coming from searching Google.
Make sense? Now that we're on the same page about what the heck dark social is, I know what your next question is: Is there any way to shed light on your dark social to figure out exactly which sources are sending you traffic?

Really, there's only one way to decode dark social: by removing incorrect UTM parameters from URLs you share on dark social platforms. Yup, I know this isn't for your site, but think about how happy the marketer on the other end will feel when they realize their traffic is more accurate!
So go on, pay it forward. Removing incorrect UTM parameters by hand -- your fellow marketers will start to see their analytics become a little less dark. And who knows? Maybe yours will, too!

The origins of dark social

In 2012, Alexis C. Madrigal wrote an article for The Atlantic called “Dark Social: We Have The Whole History of the Web Wrong” In this piece, Madrigal tells the story of questioning the existing analytics about web traffic, and the fact that they don’t seem to account for sharing links over instant messaging, a communication tool that precedes social networks.

Madrigal turned to data experts at Chartbeat, a tool that provides real-time analytics to publishers, which led them to discovery of a mysterious source that accounted for nearly 60% for traffic on The Atlantic’s site—something Madrigal goes on to call “dark social,” similar to dark energy, a term that’s used to describe a hypothetical form of energy that permeates all space and accelerates the expansion of the universe. (Quite poetic if you apply the same idea to the social web, isn’t it?)

Aside from the fact that The Atlantic article is a highly interesting and relatively easy read, no matter your level of familiarity with different engagement metrics, it also makes two very important points about dark social. The first is the fact that the most important shareability factor in a piece of content is the content itself. No good content = no sharing, however sophisticated your optimization efforts may be. The second point Madrigal makes is that the emergence of social networks didn’t create the social web, but only structured the existing channels by the act of publishing—and tracking—our social interactions.

Seeing dark social in a new light

We’d be happy to leave it at that, but like many other things in the world of web analytics, the story of dark social is a lot more complicated. Just this week, Madrigal wrote a new article, where he revisited the metrics surrounding dark social referrers. His new theory around dark social involved a very much familiar player—Facebook, or more specifically, Facebook’s mobile app.
Since Madrigal’s discovery in 2012, Chartbeat has been trying to narrow down the sources of dark social. Chartbeat’s chief data scientist Josh Schwartz told Marketing Land that Chartbeat set up a test site to eliminate some possible dark social sources, and discovered that some major social networks are not consistent with attaching referral information. Links that come from Reddit on desktop and mobile browser, for example, are trackable; but Reddit links that come from top mobile Reddit apps don’t always contain referral data.
It also turned out that Facebook doesn’t always attach the referrer to the link when a user engages with it on Facebook’s mobile app, or when a desktop user opens the link in a new tab. Given Facebook’s permanent spot at the top of mobile apps, and an established position as a leader in news sharing, this source of “dark social” makes a lot of sense.

What dark social metrics mean for your engagement strategy

Before Chartbeat and Madrigal broke the news about the newly found origins of dark social, RadiumOne has released a helpful report outlining some trends seen in dark social sharing. For example, they found out that 32% of surveyed people only share using dark social: emails, text messages, IMs, or forums. Furthermore, some information tends to be shared privately more than others; top categories for dark social sharing are arts and entertainment, careers, travel, science and education. Plus, the study finds out that click back rates, or the number of times someone clicked on the link you shared, are very high on messaging shared via dark social means.

In light of recent discoveries, one of the things you can do to unmask the origin of dark social traffic is to check for a simultaneous spike in link traffic coming from Facebook or reddit. Major websites have also reported digging into user agent data, which includes a line of code users leave after visiting a website, which identifies their operating system and browser type. User agent information, while not always translated correctly by analytics software, can provide more details about the referrer.


Finally, as Madrigal pointed out two years earlier, “There’s no way to game email or people’s instant messages. There’s no power users you can contact. There’s no algorithms to understand.” The best way to create content that is guaranteed to be shared is by writing interesting, informative, original material.

Thursday, March 15, 2012

GIMP 2.8 is just around the corner, can you taste it LOL

OK so it's been over 2 years since GIMP 2.8 was suppose to be released, but with GIMP 2.7.5 [which is a development release] just released a few days ago, it seems imminent that GIMP 2.8 is finally going to be here.

I know it's been ages but I must thank the few developers that have kept GIMP going as it is a phenominal piece of software, especially when looking at the latest development release mentioned above. A few things that I'm still dissapointed about in the GIMP are that there's still no unselection tool, and I know the reason GIMP developers haven't included this tool is because they feel that there shouldn't be a situation where you need to unselect a tool, but I've found certain instances where this tool might come in handy in the GIMP. Anyways GIMP is open source so I might just write some code myself to include a deselection tool when I have some spare time :P.

The other thing is the lack of highligting a menu item once it's been selected, although looking at GIMP again it looks like they do add a tick mark next to menu items which have been selected. But enough about the 1 or 2 things that GIMP doesn't have, why don't you download the current development version below and give it a try, trust me you won't be dissapointed ;).

The best features for me that I've noticed with the new dev release is GIMP's Single-Window Mode as well as how the images are stacked at the top when you're in Single-Window Mode and multiple images have been opened. To select the single window mode in GIMP go to Windows => Single-Window Mode.

Download GIMP 2.7.5 now.

More Useful Links

Scott Hanselmans => Dev Tools List
Editable/Printable Invoice, Version 2 => Editable/Printable Invoice, Version 2
Windows Intune [Thanks to my boet Craig Kruger for showing me this little gem from Microsoft]. By the way did I mention that Craig is a phenomenal Hardware and Networking specialist, Google or Microsoft would do well to snatch him up :), although his current company CyberLogic isn't that bad either :P.

Tuesday, June 21, 2011

Constraint Naming Conventions

Check Key Constraints => CK_ParentTable_Column
E.g.: CK_Employee_EmployeeId

Default Key Constraints => DF_ParentTable_Column
E.g.: DF_Employee_EmployeeId

Foreign Key Constraints => FK_ParentTable_ChildTable_Column
E.g.: FK_Employee_Job_EmployeeId

Primary Key Constraints => PK_ParentTable_Column
E.g.: PK_Employee_EmployeeId

Unique Key Constraints => IX_ParentTable_Column
E.g.: IX_Employee_Email


CREATE TABLE SYNTAX
CREATE TABLE employee (
EmployeeId INT NOT NULL IDENTITY(1, 1),
FirstName VARCHAR(255),
LastName VARCHAR(255),
Email VARCHAR(255) CONSTRAINT IX_Employee_Email UNIQUE
)

ALTER TABLE SYNTAX
ALTER TABLE employee
ADD CONSTRAINT IX_Employee_Email UNIQUE(Email)

For more info on constraints and constraint naming please refer to the following links:
http://msdn.microsoft.com/en-us/library/ms174979.aspx
http://blog.sqlauthority.com/2007/02/05/sql-server-primary-key-constraints-and-unique-key-constraints/
http://msdn.microsoft.com/en-us/library/ms177420.aspx

Friday, January 7, 2011

Google Apps made easy

There is a nice way of using Google Mail and Calendar if you are using Chrome as a browser.

Step 1.
Install Chrome (if you have not yet... you probably cannot... or no one has told you how much better it is)

Step 2.
Download this and install this little application.
http://dl.google.com/tag/s/ap=mydomain.com/googlewebapps/en/googleappsstandalonesetuptagged.exe

You are done!
What you get is a separate window for your Email and Calendar.., which makes life so much easier...

Once you run this.. it looks like this:



And it looks like this:



Credit goes to Gerhard Pretorius for this useful post.

Wednesday, February 17, 2010

Microsoft SQL Server 2005

How can I change my default database in MS SQL 2005
Log in to SQL Server 2005 and click the New Query button. After that run the system stored procedure sp_defaultdb command as follows:
exec sp_defaultdb @loginame='login', @defdb='master'
To achieve this in Microsoft SQL Server Management Studio you need to edit your login by expanding the Security -> Logins node and then right clicking on your login name and selecting Properties. Once the properties page displays there should be a Default database dropdownlist under the General page as seen below:

Wednesday, February 3, 2010

Software Downloads

Download Center
CodePlex»http://www.codeplex.com/ (Microsoft)
SourceForge»http://sourceforge.net/

Install
Backup and Deployment
Acronis => http://www.acronis.com/download/

CMS
Joomla => http://www.joomla.org/download.html
Wordpress => http://wordpress.org/

Databasing
MySQL => http://dev.mysql.com/downloads/
Navicat => http://navicat.com/
PostgreSQL => http://www.postgresql.org/
Sqlite => http://www.sqlite.org/

Disassembler
Reflector => http://www.red-gate.com/products/dotnet-development/reflector/

Extensions
Firebug => http://getfirebug.com/downloads (Firefox)

Framework
CodeIgniter => http://codeigniter.com/downloads/
JQuery => http://jquery.com/
JQuery UI => http://jqueryui.com/
PHP => http://php.net/downloads.php
YUI Library => ttp://developer.yahoo.com/yui/

IDE
NetBeans => http://netbeans.org/downloads/
Eclipse => http://www.eclipse.org/

IM
GTalk => http://www.google.com/talk/
MSN => http://explore.live.com/windows-live-messenger?os=other
Skype => http://www.skype.com/intl/en-us/get-skype/on-your-computer/windows/

ISO Utility
PowerISO => http://www.poweriso.com/download.htm
MagicISO => ttp://www.magiciso.com/tutorials/miso-magicdisc-history.htm

Issue Tracker
BugTracker.NET => http://ifdefined.com/bugtrackernet.html
Bugzilla => http://www.bugzilla.org/

Multimedia Player
VideoLAN => http://www.videolan.org/vlc/download-windows.html
XBMX => http://xbmc.org/download/

Office
Open Office => http://download.openoffice.org/

Photo Editors
FastStone Photo Resizer => http://www.faststone.org/FSResizerDownload.htm
GIMP => http://www.gimp.org/downloads/
Paint.NET => ttp://www.getpaint.net/download.html
Pixlr => http://pixlr.com/
Sumo Paint => http://www.sumopaint.com/home/

Remote Desktop Utility
Team Viewer => http://www.teamviewer.com/en/download/index.aspx

Social Networks
Facebook => http://www.facebook.com/
LinkedIn => http://www.linkedin.com/
Twitter => http://twitter.com/

Source Control
Git => http://git-scm.com/
SVN => http://subversion.apache.org/packages.html

Text Editors
E-TextEditor => http://www.e-texteditor.com/
Notepad++ => http://notepad-plus-plus.org/download
TextPad => http://www.textpad.com/download/

Web Browsers
Chrome => http://www.google.com/chrome/intl/en/landing_chrome.html?hl=en
Firefox =>
RockMelt => http://www.rockmelt.com/

Wiki
Screw Turn Wiki => http://www.screwturn.eu/

Zip Utilities
7Zip => http://www.7-zip.org/download.html

Online
Database Management
PhpMyAdmin => http://www.phpmyadmin.net/home_page/downloads.php

IDE
phpanywhere => http://phpanywhere.net/

Office
Google docs =>

Issue Tracker
Zoho => http://www.zoho.com/

Training
GCFLearnFree.org => http://www.gcflearnfree.org/
HTML5Rocks => ttp://www.html5rocks.com/
W3Schools => http://www.w3schools.com/

Still to sort
2 Advanced => http://www.2advanced.com/
Advanced System Care => http://www.iobit.com/advancedsystemcareper.html
Belarc Advisor => http://www.belarc.com/free_download.html
BurnAware => http://www.burnaware.com/
Cooliris => http://www.cooliris.com/
CutePDF => http://www.cutepdf.com/products/cutepdf/writer.asp
doPDF => http://www.dopdf.com/
DropBox => http://www.dropbox.com/install
Filezilla => http://filezilla-project.org/download.php
Foxit Reader => http://www.foxitsoftware.com/Secure_PDF_Reader/
Freshmeat => http://freshmeat.net/
Github => https://github.com/
Google Latitude => https://www.google.com/latitude/
Gmail => Gmail
Greenshot => http://getgreenshot.org/
IrfanView => http://www.irfanview.com/main_download_engl.htm
LastPass => https://lastpass.com/misc_download.php
Linq Pad => http://www.linqpad.net/
PathCopy => http://download.cnet.com/Path-Copy/3000-2072_4-10036463.html
PowerGUI => http://www.powergui.org/downloads.jspa
Secunia PSI => http://secunia.com/
Sendback
SnagIt => http://www.techsmith.com/download/snagit/default.asp
Spybot
StumbleUpon.com => http://www.stumbleupon.com/
VNC => http://vnc.en.softonic.com/
WinAmp => http://www.winamp.com/media-player/en
Xmind => http://www.xmind.net/downloads/
Yammer => https://www.yammer.com/company/desktop

Microsoft Visual Studio 2008

How do I change the default browser used in Visual Studio 2008

• Right click a page (.aspx, or on a folder)
• Select Browse With...
• Choose your browser
• Click set as Default



ASP.NET MVC
• Right click on Default.aspx
• Select Browse With...
• Choose your browser
• Click set as Default

How do I reload the cache of a website when pressing the start button (F5) in Visual Studio 2008

To reload the cache of the browser in Visual Studio 2008 when you've clicked the start button do the following:

• Once the browser has loaded up press and hold down the CTRL + F5 key.

How do I use a stored procedure with the linq data source
To use a stored procedure with the linq data source set the linq data sources ContextTypeName property to the DataContext class and create an OnSelecting method for the linq data source returning the stored procedure in the OnSelecting method. Below is an example to help explain the steps I've taken. In your .ascx, .aspx, etc file the linq data source should look something like below:

And your code behind will look something like the following:


How do I maintain the pages current position when inserting or updating a row in a GridView
To maintain the pages current position when inserting or updating a row in a GridView set your pages maintainScrollPositionOnPostBack attribute in the web.config to true as shown below: