1188055 - Sponsored Rollup Generation in Zenko

Status: RESOLVED INCOMPLETE

(Content Services Graveyard :: Tiles: Administration Front-End, defect)

Description

[Matthew Ruttley [:mruttley]]

(Quoting sbohan's email)

Need for our top 25 Directory Tiles countries a breakdown of sponsored partner performance by day. Due to the fact that some users see old tiles if they don't have their tiles service updated, even if a tile is scheduled for a certain day, ALL the impressions and clicks for that day are not being reported.

1. See attached spreadsheet - this is meant to be a representation of what I need (did something like it months ago)

2. Tabs - each tab in the spreadsheet is per-country (can I get all of them? If that's too much work can I get the top 25 by volume?)

3. Column breakdown:
Date column (per month) is ColumnA
B-F is for client 1, H-L Client 2, etc. - basically each client running in a given month get their own set of columns

4. For each Client/Month I need the total Impressions, Clicks, Pins, Blocks per day for their units

5. I think I listed 6 client columns, I really dont think we have ever had more clients in the same month in the USA. Less than 6 is fine (some countries only run Booking.com so it might be easier in those)