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

<?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

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

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 set the start and end date once 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 traffic source data based on user and session id
  traffic AS (
  SELECT
    user_pseudo_id,

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),
  -- Subquery to prepare and calculate engagement data
  engagement AS (
  SELECT
    COUNT(DISTINCT

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 user data
  user AS (
  SELECT
    user_pseudo_id,

brunomertins

SELECT
  -- event_date (dimension | the date on which the event was logged)
  PARSE_DATE('%Y%m%d',
    event_date) AS event_date,
  -- event_timestamp (dimension | the time (in microseconds, UTC) at which the event was logged on the client)
  TIMESTAMP_MICROS(event_timestamp) AS event_timestamp,
  -- event_name (dimension | the name of the event)
  event_name,
  -- event_key (dimension | the event parameter's key)
  (

brunomertins

SELECT
  -- traffic_source.name (dimension | name of the marketing campaign that first acquired the user)
  traffic_source.name,
  -- traffic_source.medium (dimension | name of the medium (paid search, organic search, email, etc.) that first acquired the user)
  traffic_source.medium,
  -- traffic_source.source (dimension | name of the network that first acquired the user)
  traffic_source.source
FROM
  -- Change this to your Google Analytics 4 export location in BigQuery
  `ga4.analytics_1234567890.events_*`