This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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
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.