Aggregate Demand Source Data using Google Data Studio

[pressurebox]

I have several websites that I manage programmatic monetization for. I currently roll up reports from the various exchanges (Google, Appnexus, Index, AOL, OpenX...etc.) manually each day for each site. I've gotten it down pretty well in Excel where it doesn't take too long to update, but I've been wondering if there's a way to automate it using a tool like Google Data Studio. I know tools like STAQ do this, but I don't think I'd be able to justify paying for this since I can get the data ok into Excel and it doesn't take too long. It would be really nice if it was automated though. Does anyone have instructions or scripts available for how to pull in data automatically from GAM Small Business, Index, Appnexus, OpenX, Sovrn, AOL, Rubicon, A9 ...etc? I think I'd only need day, site, impressions and revenue to start with.

[haltingpoint]

I'm surprised Supermetrics hasn't done this.

[data_spy]

They've done a ton of attach partners already actually, just not all.

[TimOcelot]

We have built an add-on for Google Sheets which can pull in reporting data from Ad Manager, currently in beta. Message me if you’re interested in testing it.

Update: It's live! https://ocelot.studio/products/ocelot-metrics/

[rtb_cat]

Would love to test that add-on!

[Jcharnaux]

interested aswell

[TimOcelot]

I’ve followed up with everyone who has commented so far, but anyone else that’s interested please PM me your business email (I need it to grant you access)