mattm

dimension: primary_key {
  type: string
  sql: concat(cast(${date_date} as string), ${campaign_id}, ${country}) ;;
  hidden: yes
  primary_key: yes
}

mattm

select
  campaign_id,
  sum(spend) as total_spend,
  sum(impressions) as total_impressions,
  sum(spend) / sum(impressions) * 1000 as cpm, 
  sum(inline_link_clicks) as link_clicks,
  sum(inline_link_clicks) / sum(impressions) as ctr
from facebook_ad_insights.ad_insights
where date = '2018-10-01'
group by 1

mattm

POPULATION_SIZE = 24
NUM_BITS = 64
NUM_GENERATIONS = 1000
CROSSOVER_RATE = 0.7
MUTATION_RATE = 0.001

class Chromosome
  
  attr_accessor :genes

mattm

select
	id,
	email
from {{ source(var('base.users')) }}

mattm

{% macro source(table_name) %}

	{% if target.name == 'prod' %}
	  {{ return("preceden_heroku." ~ table_name) }}
	{% else %}
	  {{ return(table_name) }}
	{% endif %}

{% endmacro %}

mattm

select
	id,
	email
from {{ var('base.users') }}

mattm

vars:
  "base.users" : "users"

mattm

AANDG
AAS
ABILENE
ABRASIVE
ACCOMPLICE
ACENTO
ACTIONSPORTS
ADAGE
ADAIR
ADAY

mattm

; The use of the Data contained in Verisign Inc.'s aggregated
; .com, and .net top-level domain zone files (including the checksum
; files) is subject to the restrictions described in the access Agreement
; with Verisign Inc.

$ORIGIN COM.
$TTL 900
@ IN    SOA     a.gtld-servers.net. nstld.verisign-grs.com. (
				  1526140941 ;serial
				  1800 ;refresh every 30 min

mattm

; The use of the Data contained in Verisign Inc.'s aggregated
; .com, and .net top-level domain zone files (including the checksum
; files) is subject to the restrictions described in the access Agreement
; with Verisign Inc.

$ORIGIN COM.
$TTL 900
@ IN    SOA     a.gtld-servers.net. nstld.verisign-grs.com. (
				  1526140941 ;serial
				  1800 ;refresh every 30 min