Data Studio
4.4K members online now
4.4K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Getting Doubleclick custom floodlight metrics into Data Studio

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

What is the best way to get Doubleclick custom floodlight variables into Data Studio? Is there anyway to achieve this using the front-end Data Studio web app or a third party app like Supermetrics? Or is the only way to make an API call?

Any insight, direction or description of method would be appreciated. Thanks!

 

1 Expert replyverified_user

Getting Doubleclick custom floodlight metrics into Data Studio

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Replying to my own Q with another account. Here's how I solved my problem in case it helps anyone else:

Using Supermetrcs Super Pro version (supermetrics.com) for Google Drive

Install the Supermetrics sidebar in sheets and activate.

Select following

Datasource: Doubleclick For Advertisers
Select Advertisers: [select your DCM account]
Select Metrics: Conversions
Split by: Date vs Activity
Filter: Advertiser is [client Account Name]

Getting Doubleclick custom floodlight metrics into Data Studio

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Hey Adam, did you get what you wanted here? Your answer to your own Q does not mention Custom FL variables, but merely conversions. Were you after conversions all along?

Getting Doubleclick custom floodlight metrics into Data Studio

Google Employee
# 4
Google Employee

Hi @Adam S -- thanks for the questions.

 

We've explored adding floodlight conversion metrics into the DCM connector but ran into technical problems that are not likely to be resolved in the short-term. I check in with the DCM team every few months and will be sure to bring this up again next time.

 

In the short-term exporting data into Sheets or BigQuery and building Data Studio reports off of that might be your best bet. Not ideal, but gets the job done for one-off dashboards.

 

Best.

 

Alon

Getting Doubleclick custom floodlight metrics into Data Studio

[ Edited ]
Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

My bad. I only pulled conversions out. Still not getting Custom FL variables off the API. Time to look at other options, as per Alon's reply.