For me it’s very interesting to see, which are the top-performing articles, to recognize, which content my readers want. Because more and more people subscribe to my newsletters over the time, I need to compare the number of clicks on an article to the numbers of emails sent.

The following snippet works perfectly for me to get a good understanding about the content, however the report is pretty ugly. So, use the code as a base for your needs.

<?php
$servername = "yourIP";
$username = "yourDatabaseUser";
$password = "yourPassword";
$database = "yourDatabase";

$connection = new mysqli($servername, $username, $password, $database);

$sql = "SELECT email_id, COUNT(url) AS numberOfLinkClicks, url FROM wp_newsletter_stats w WHERE url <>'' GROUP BY url";
$result_article_counts = $connection->query($sql);

while($rowOuter = $result_article_counts->fetch_assoc()) {
	$sql = "SELECT id, sent FROM wp_newsletter_emails WHERE id = " . $rowOuter['email_id'];
	$result_newsletter_counts = $connection->query($sql);
	while($rowInner = $result_newsletter_counts->fetch_assoc()) {
		$numberOfSentEmails = $rowInner['sent'];
	}
	$link = $rowOuter['url'];
	$numberOfLinkClicks = $rowOuter['numberOfLinkClicks'];
	$click_rate = $numberOfLinkClicks / $numberOfSentEmails;
	if ($click_rate > 0.15) {
		$bold = "<b>"; 
	$bold2 = "</b>";
	} else {
		$bold =""; 
	$bold2 = "";
	}
	echo "Link: " . $link . " -> Clickrate: " . $bold . $click_rate . $bold2 . "<br>";
}
	
$connection->close();
?>

So sollen die Social Media Buttons in der Footer-Leiste aussehen:

Vorgehen

Design -> Widgets -> Footer Widget 1 und dann als Blocktyp Individuelles HTML

<a href="https://www.linkedin.com/company/14795319" target="_blank">
<img style="width: 40px; height: 40px;" src="/images/LinkedIn 32px.gif" alt="linkedin-button" />
</a>

Deprecated

Folgendes Vorgehen hat mir bei einem größeren WordPress-Update (inkl. Templates) den Social-Media-Icon-Footer gelöscht und ist daher keine gute Lösung:

Man lege die Icons in passender Größe in einen /image-Ordner.

Ich habe das Theme „Forefront“, welches auf dem Theme „GeneratePress“ aufbaut. In Design -> Editor gehe ich auf „GeneratePress“ in der dropdownbox und anschließend wähle ich footer.php. Dort füge ich zwischen:

	<?php
	endif;
	do_action('generate_after_footer_widgets');
	?>

und
<!-- .site-info -->
	<?php do_action( 'generate_after_footer_content' ); ?>

folgendes Codesnippet ein
	<footer class="site-info" itemtype="http://schema.org/WPFooter" itemscope="itemscope">
		<div id="social_media">
			<a href="https://www.facebook.com/projektfisch" target="_blank">
				<img src="/images/projekt-fisch-facebook.svg" alt="projekt-fisch-facebook-button" style="width:40px;height:40px;"/>
			</a>
			<a href="https://twitter.com/ProjektFisch" target="_blank">
				<img src="/images/projekt-fisch-twitter.svg" alt="projekt-fisch-twitter-button" style="width:40px;height:40px;"/>
			</a>
			<a href="https://plus.google.com/111580706390601723057" target="_blank">
				<img src="/images/projekt-fisch-google.svg" alt="projekt-fisch-google+-button" style="width:40px;height:40px;"/>
			</a>
			<a href="https://www.xing.com/profile/Michael_Wowro" target="_blank">
				<img src="/images/projekt-fisch-xing.svg" alt="projekt-fisch-xing-button" style="width:40px;height:40px;"/>
			</a>
			<a href="http://www.it-freelancer-magazin.de/index.php/feed/" target="_blank">
				<img src="/images/projekt-fisch-rss.svg" alt="projekt-fisch-rss-button" style="width:40px;height:40px;"/>
			</a>
		</div>
		<div class="inside-site-info grid-container grid-parent">
			<?php do_action( 'generate_credits' ); ?>
		</div>
	</footer>

Wer sich das Ganze in live anschauen möchte, kann sich mal den Footer des IT Freelancer Magazins anschauen.