Skip to content

Instantly share code, notes, and snippets.

@tal

tal/gist:375822

Created April 22, 2010 21:17
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save tal/375822 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save tal/375822 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
SELECT r.created_dt as "date", sum(clicks) as "clicks", sum(impressions) as "impressions",
sum(actions) as "actions", sum(spend)/1000000 as "spend",
sum(spend)/1000000 / sum(actions) as CPA
Raw
gistfile2.ru
select do
[
r__created_dt.as(:date),
sum(clicks).as(:clicks),
sum(impressions).as(:impressions),
sum(actions).as(:actions),
(sum(spend)/10_000_000).as(:spend),
((sum(spend)/10_000_000)/sum(actions)).as(:cpa)
]
end
Raw
gistfile3.sql
SELECT `r`.`created_dt` AS `date`, sum(`clicks`) AS `clicks`, sum(`impressions`) AS `impressions`, sum(`actions`) AS `actions`, (sum(`spend`) / 10000000) AS `spend`, ((sum(`spend`) / 10000000) / sum(`actions`)) AS `cpa`
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment