Skip to content

Instantly share code, notes, and snippets.

Tappity tap tap

Mark MarkEdmondson1234

Tappity tap tap
View GitHub Profile
MarkEdmondson1234 / google_analytics_bigquery_user_mapping_table_customer.sql How to create a user mapping table (or Identity Graph) based on all the available user identifiers in the Google Analytics 4 BigQuery exports (like device-IDs or customer-IDs). Full article on
View google_analytics_bigquery_user_mapping_table_customer.sql
-- Author: Krisjan Oldekamp
lookback_window INT64 DEFAULT 90; -- How many days to lookback into the dataset to search for IDs (compared to today)
-- Deduplicate array of struct
MarkEdmondson1234 /
Last active Apr 22, 2021
Facebook Marketing Partners Team response for Apple's iOS14 Privacy prompt

Hi Mark,

Yesterday (April 20, 2021), Apple confirmed it will make iOS 14.5 available to all iOS users next week, and it will start requiring apps in the App Store to obtain permission through its AppTrackingTransparency framework to “track” users across apps and websites owned by third parties for advertising and measurement purposes.

With the general availability of iOS 14.5 (week of April 26), we will begin rollout of our new advertiser experiences and measurement protocols – including Apple’s SKAdNetwork API (SKAN) and Facebook’s Aggregated Event Measurement (AEM). Once the specific date of the general availability release of 14.5 is confirmed, we will establish the rollout timing of our new experiences and communicate this timing.

You and your clients can expect to see changes in our business and advertising tools, campaign set up, targeting, delivery, measurement, and reporting, following the release of iOS 14.5 and Apple’s prompt enforcement. We are sharing a summary of these changes below, as well a

View AWS-furrr.R
# This example demonstrates running furrr code distributed on 2 AWS instances ("nodes").
# The instances have already been created.
# Two t2.micro AWS instances
# Created from
public_ip <- c("", "")
MarkEdmondson1234 / month_start_end.R
Created Mar 9, 2018
Create month start and end dates for a date range you pass in
View month_start_end.R
add_months <- function(date, n){
seq(date, by = paste (n, "months"), length = 2)[2]
make_date_ranges <- function(start, end){
starts <- seq(from = start,
to = Sys.Date()-1 ,
by = "1 month")
View AdobeAnalytics-GovernanceExport.R
SCAuth("", "xxx")
reportSuites <- GetReportSuites()
evar <- GetEvars(reportSuites$rsid) #%>%
# reportSuite <- reportSuites$rsid
MarkEdmondson1234 / global.R
Created Dec 1, 2017 — forked from raymondben/global.R
gauth shiny example
View global.R
MarkEdmondson1234 / google_calendar_demo.R
Last active Oct 2, 2017
A demo of calling Google Calendar API
View google_calendar_demo.R
## set scopes for calendar
options(googleAuthR.scopes.selected = "",
googleAuthR.client_id = "XXXX", ## add your Google project client Id
googleAuthR.client_secret = "XXXX") ## add your Google project client secret
## make sure calendar API is activated for your Google Project at below URL:
MarkEdmondson1234 / app.R
Last active Jan 25, 2021 — forked from jcheng5/app.R
Using OAuth2 with Shiny
View app.R
# WARNING: This sketch does not make proper use of the "state" parameter.
# Doing so usually involves using cookies, which can be done with the
# Rook package but I have not done that here. If you choose to use this
# approach in production, please check the state parameter properly!
APP_URL <- if (interactive()) {
# This might be useful for local development. If not, just hardcode APP_URL
# to the deployed URL that you'll provide a few lines below.
MarkEdmondson1234 / massiveCPUonGCE.R
Last active Apr 22, 2018
Run massive parallel R jobs cheaply on Google Compute Engine with googleComputeEngineR and future
View massiveCPUonGCE.R
## see also on how to run on Azure
## and cloudyr project for AWS
# now also in docs:
## auto auth to GCE via environment file arguments
MarkEdmondson1234 / knit_cloudstorage.rmd
Created Apr 21, 2017 — forked from mwhitaker/knit_cloudstorage.rmd
Use googleCloudStorageR to automatically upload to Cloud Storage
View knit_cloudstorage.rmd
title: "Host image files on Google Cloud storage"
author: "Michael Whitaker"
date: "January 12, 2017"
self_contained: false
```{r setup, include=FALSE}