vincentkoc

You are a document to graph generation assistant. You task is to meticulously take some high level concepts, entities and summary of a research paper in JSON and convert this into a graph.

• You will respond back only in JSON with nodes and edges
• You will take a JSON of entities, summary and arguments for a given research paper and convert into a graph to better understand the relationship of the ideas
• You will breakdown larger terms into smaller ideas where possible
• You will ensure that all the nodes and edges are connected, if not you will connect them
• If you are still unable to connect all the nodes and edges, you will connect these to the core/main idea
• You will not make assumptions and only stick to the information provided

Please be critical and discerning in your evaluations.

vincentkoc

/*

GA4 Attribution Model

This query is designed to replicate the old Universal Analytics attribution
model in Google Analytics 4 (GA4). It calculates the source, medium,
campaign, and event rank for each user based on their events. It also retrieves
purchase data and joins it with the first events to attribute the purchase
to a specific source, medium, and campaign.

vincentkoc

Cleanup Redash Queries (Housekeeping)

Use the following clean-up scripts to help locate redundant queries, widgets, dashboards and alerts within Redash. This was mostly to keep lineage lean and reduce discovery of redundant reports and data:

• locate_expired_assets.sql - Finds expired queries and other assets downstream from that query
• locate_expired_dashboards.sql - Finds unused dashboards older than 1 year
• locate_expired_alerts.sql - Finds unused alerts not executed older than 1 year
• locate_expired_users.sql - Finds unused users not logged older than 90 days
• locate_insecure_tokens.sql - Finds API tokens older than 90 days still in use
• locate_orphaned_connections.sql - Finds orphaned data connections with no queries

vincentkoc

import pandas as pd
import hashlib

# Load the csv file into a pandas DataFrame
df = pd.read_csv('filename.csv')

# Define a function to hash a string
def hash_for_google(input):
    if pd.isnull(input):
        return None

vincentkoc

Keybase proof

I hereby claim:

• I am koconder on github.
• I am zuperduper (https://keybase.io/zuperduper) on keybase.
• I have a public key ASBS0nvfhG7bTHtCVfLmGXDw1WPAMVHe9_LSS0q_eF5RKQo

To claim this, I am signing this object:

vincentkoc

Setup Tools

brew install gpg
brew install pinentry-mac
brew install --cask gpg-suite
brew install --cask keybase

Export Keys

vincentkoc

<?php
//  Disable pingback.ping xmlrpc method to prevent Wordpress from participating in DDoS attacks
//  More info at: https://docs.bitnami.com/?page=apps&name=wordpress&section=how-to-re-enable-the-xml-rpc-pingback-feature

// remove x-pingback HTTP header
add_filter('wp_headers', function($headers) {
    unset($headers['X-Pingback']);
    return $headers;
});
// disable pingbacks

vincentkoc

UPDATE wp_options SET option_value = replace(option_value, 'http://thismagicday.com.192.168.1.15.xip.io', 'http://thismagicday.com') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET guid = replace(guid, 'http://thismagicday.com.192.168.1.15.xip.io','http://www.thismagicday.com');

UPDATE wp_posts SET post_content = replace(post_content, 'http://thismagicday.com.192.168.1.15.xip.io', 'http://thismagicday.com');

UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://thismagicday.com.192.168.1.15.xip.io','http://thismagicday.com');

vincentkoc

  ####### START AFFILIATE TRACKING

  # Start on Queries with AFF
  RewriteCond %{QUERY_STRING} \baff=(.*)
  # Write Cookie for 30 days
  RewriteRule .* - [co=yj_aff:%1:.yellowjersey.co.uk:43200:/]

  # Remove AFF Param If Exists via 302 Redirect - Required for UTM and other get tag's.
  RewriteCond %{QUERY_STRING} ^(.*)\baff=(\w*)\b(.*)
  RewriteRule (.*) $1?%1%3 [R=302,L]

vincentkoc

#301 Redirects for .htaccess

#Redirect a single page:
Redirect 301 /pagename.php http://www.domain.com/pagename.html

#Redirect an entire site:
Redirect 301 / http://www.domain.com/

#Redirect an entire site to a sub folder
Redirect 301 / http://www.domain.com/subfolder/