Publisher performance

1-- core.daisycon.publisher_performance
2-- Affiliate results per publisher, Daisycon's statistics grouped by publisher: clicks,
3-- transactions by status, commission, revenue, and the rates affiliate managers
4-- steer on (conversion rate, approval rate, cost of sale, commission per click).
5--
6-- Grain: advertiser_id x publisher_id, totalled over the sync window. Currency: per row.
7-- Depends on: staging.daisycon.statistics_by_publisher, .advertiser
8--
9-- No date column: Daisycon returns these statistics as totals for a date range,
10-- and the window is set by the sync (12 months back on a full sync by default).
11-- Sync the stream in full mode so every row covers the same window. Rates are
12-- ratios of sums; re-sum and divide again when you roll rows up.
13--
14-- approval_rate only counts transactions that have been judged: open ones are left
15-- out of both sides. cost_of_sale divides program commission by the revenue your
16-- tracking reported for the same transactions.
17
18SELECT
19    s.advertiser_id,
20    a.advertiser_name,
21    s.publisher_id,
22    s.publisher_name,
23    s.currency,
24
25    s.clicks,
26    s.unique_clicks,
27    s.transactions,
28    s.transaction_parts,
29    s.open_transactions,
30    s.approved_transactions,
31    s.disapproved_transactions,
32    s.revenue,
33    s.commission,
34    s.program_commission,
35    s.open_program_commission,
36    s.approved_program_commission,
37    s.disapproved_program_commission,
38    s.cpc_clicks,
39    s.cpc_commission,
40