# Alteryx Designer Discussions

The Expert Exam is now live online! Read about the specifics and what it took to bring it to life in the blog by our very own Elizabeth Bonnell!

Highlighted
5 - Atom

Does anyone have experience connecting Doubleclick Campaign Manager and Bid Manager data? My team uses an override process that matches spend/revenue data from DBM to DCM to obtain more accurate spend information. We are converting our workbooks to Alteryx and are struggling with how to perform this task. Right now we use create date/placement concatenations for both data sets and then using a single formula, are able to allocate DBM spend to DCM line items based on DCM impression allocation for all line items with that data/placement combo.

Current formula utilized:

=IFERROR(J2/SUMIF('DCM Raw'!\$Z:\$Z,'DCM Raw'!Z2,'DCM Raw'!\$J:\$J)*SUMIF('DBM Raw'!\$M:\$M,'DCM Raw'!Z2,'DBM Raw'!\$K:\$K),0)

J2/sumif... is basically finding the ratio of that one line item's impressions verses the total summed impressions for all line items with that date placement combination. Multiplying it by the total DBM revenue for all line items with the matching DBM date/placement combo ensures that DBM revenue is proportionally allocated to the DCM data.

DCM Raw Column J = DCM impressions

DCM Raw Column Z = date/placement concatenation for DCM

DBM Raw Column M = date/placement concatenation for DBM

DBM Raw Column K = Revenue from DBM

Highlighted
Alteryx

Hi @steostro,

I'm not familiar with the data you are using, can you give us a sample and give us a sense for how you are trying to transfom the data?

Thanks,

Jess Silveri
Highlighted
5 - Atom

Hey Jessica,

My team actually figured it out. Thanks for the follow-up!

Highlighted
8 - Asteroid

@steostro Any chance you've been able to Doubleclick Search and not DCM?   *Edit: Figured it out.

Highlighted
5 - Atom

Hi steostro

How you are able to set it up?

Highlighted
7 - Meteor

Hello there,

I am trying t download DCM data (impressions, clicks) at zip code level by placement for a year. I see that you have done something similar, wanted to understand how i can use the download tool since there's no connector for DCM.

it would great if you could share how i can download data from DCM for a particular campaign.

Best,

Soumya

Highlighted
5 - Atom

Have you been able to figure this out?

Labels