View check.rs
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
if account.owner != program_id { | |
msg!("Greeted account does not have the correct program id"); | |
return Err(ProgramError::IncorrectProgramId); | |
} |
View keypair58.rb
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
require_relative "base58" | |
def bytes_to_base58(bytes) | |
hex = bytes.pack("C*").unpack("H*").first | |
Base58.encode(hex) | |
end | |
keypair = "6Tyktf6mEqUMEKm2ZpLn3srEwk9zsT5jiE54EgPgToikMFYww1LGFUXgwgr6hvc9CikpaNaBH2vmkmqN3Usrxpd" | |
keypair_hex = Base58.decode(keypair).rjust(128, "0") | |
keypair_bytes = [keypair_hex].pack('H*').bytes.to_a |
View keypair.rb
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
require_relative "base58" | |
def bytes_to_base58(bytes) | |
hex = bytes.pack("C*").unpack("H*").first | |
Base58.encode(hex) | |
end | |
keypair_bytes = [4,182,130,247,119,117,227,207,112,73,170,126,222,197,244,99,215,107,255,202,33,43,36,17,104,111,157,246,196,192,174,95,240,23,238,206,118,215,154,238,229,96,11,37,156,123,51,223,5,231,17,117,86,136,103,14,75,95,175,132,148,54,1,46] | |
private_key_bytes = keypair_bytes[0, 32] | |
public_key_bytes = keypair_bytes[32..-1] |
View fb_conversions.lookml
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
view: fb_conversions { | |
derived_table: { | |
sql: | |
select * | |
from fivetran.fb_ad_insights_action_values | |
where action_type = "offsite_conversion.fb_pixel_purchase" ;; | |
} | |
dimension: primary_key { | |
type: string |
View facebook-ad-insights-view.lookml
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
view: fb_ad_insights { | |
sql_table_name: fivetran.fb_ad_insights ;; | |
dimension: primary_key { | |
type: string | |
sql: concat(cast(${date_date} as string), ${campaign_id}, ${country}) ;; | |
hidden: yes | |
primary_key: yes | |
} |
View facebook-ad-insights-joining.lookml
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
explore: fb_ad_insights { | |
label: "Facebook" | |
view_label: "Facebook" | |
join: fb_conversions { | |
view_label: "Facebook" | |
type: left_outer | |
relationship: one_to_one | |
sql_on: ${fb_ad_insights.primary_key} = ${fb_conversions.primary_key} ;; | |
} |
View ad-insights-primary-key.lookml
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
dimension: primary_key { | |
type: string | |
sql: concat(cast(${date_date} as string), ${campaign_id}, ${country}) ;; | |
hidden: yes | |
primary_key: yes | |
} |
View facebook-conversion-value.sql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
select | |
campaign_id, | |
sum(value) as total_conversion_value | |
from facebook_ad_insights.ad_insights_action_values | |
where | |
action_type = 'offsite_conversion.fb_pixel_purchase' and | |
date = '2018-10-01' | |
group by 1 | |
order by 1 |
View facebook-ad-insights-spend.sql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
View base-model-macro-variable.sql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
select | |
id, | |
from {{ source(var('base.users')) }} |
NewerOlder