brunomertins

WITH
  -- Subquery to define static and/or dynamic start and end date for the whole query
  period AS (
  SELECT
    '20200220' AS start_date,
    FORMAT_DATE('%Y%m%d',DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY)) AS end_date),
  -- Subquery to prepare and calculate engagement data
  engagement AS (
  SELECT
    COUNT(DISTINCT

brunomertins

SELECT
  -- Date (dimension)
  event_date AS date,
  -- Year (dimension)
  FORMAT_DATE('%Y', PARSE_DATE("%Y%m%d",
      event_date)) AS year,
  -- ISO Year (dimension)
  FORMAT_DATE('%G', PARSE_DATE("%Y%m%d",
      event_date)) AS iso_year,
  -- Month of Year (dimension)

brunomertins

WITH
  -- Subquery to define static and/or dynamic start and end date for the whole query
  period AS (
  SELECT
    '20200220' AS start_date,
    FORMAT_DATE('%Y%m%d',DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY)) AS end_date)
SELECT
  -- Event count per user (metric | the number of times an individual event (change event_name 'page_view' to event that needs to be counted) was triggered divided by amount of users)
  COUNT(DISTINCT
    CASE

brunomertins

WITH
  -- Subquery to define static and/or dynamic start and end date for the whole query
  period AS (
  SELECT
    '20200220' AS start_date,
    FORMAT_DATE('%Y%m%d',DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY)) AS end_date),
  -- Subquery to prepare and calculate page view data
  pages AS (
  SELECT
    user_pseudo_id,

brunomertins

<?php
//* Do NOT include the opening php tag

//* Enqueue sticky menu script
add_action( 'wp_enqueue_scripts', 'custom_enqueue_script' );
function custom_enqueue_script() {
	wp_enqueue_script( 'sticky-menu', get_stylesheet_directory_uri() . '/js/sticky-menu.js', array( 'jquery' ), '', true );
}

//* Reposition the secondary navigation menu

brunomertins

á --> á
é --> é
í --> í
ó --> ó
ú --> ú
ñ --> ñ

brunomertins

<h1>Titel 1.</h1>
<!--Die Teilüberschriften auf der nächsten Ebene sollten h2-Überschriften sein und so getagt werden-->
<h2>Teilüberschrift 1.1.</h2>
<!--Teilüberschriften zwischen zwei h2-Überschriften sollten h3-Überschriften sein und so getagt werden:-->
<h3>Teilüberschrift 1.1.1.</h3>
<!--In den meisten Fällen wird die Gliederung bis zu h2-Überschriften ausreichend sein.-->

brunomertins

<table>
  <thead>
    <tr>
      <th scope="col">Name</th>
      <th scope="col">Email</th>
      <th scope="col">Dept, Title</th>
      <th scope="col">Phone</th>
    </tr>
  </thead>
  <tbody>

brunomertins

<div itemscope itemtype="http://schema.org/Event">
<a itemprop="url" href="http://www.turansa.com/blog/2011/09/21/excursion-maravillas-dubai-y-la-india-2012/">
Excursión: <span itemprop="name">Dubai y la India 2012</span></a>
<meta itemprop="startDate" content="2012-03-27T17:30">Thu, 03/27/12 5:30 p.m.</div>

brunomertins

<h2>SEO Cheatsheet<h2>
<ul>
<li>Optimized, Relevant Content</li>
<li>Good Semantic Page Markup (H1, H2, etc.)</li>
<li>Good Linking Structure</li>
<li>Keyword-Rich URL Structure</li>
<li>Optimized Assets (File Names)</li>
<li>Optimized Content (Title, Meta, Alt, etc.)</li>
<li>Fast Loading XML/HTML - based pages</li>
<li>Sitemap Files and Robot.txt files</li>