What is your approach to group campaigns across different data streams?

mohit · June 2019

An insertion order in DV360, a campaign in Facebook Ads, a campaign in YouTube Ads, a funding order under Twitter are all part of the same "Christmas campaign". Ad Ops who setup DV360 called this "Christmas 2019" and Ad Ops who set up Twitter ads call it "Christmas Offer" and story goes on other platforms too. Nomenclature guidelines exist but not followed accurately all the time. I am sure this is a common story for a lot of folks here.

How do you handle this? How do you create a true "campaign" dashboard which consolidates all of this?

_ben_easley · June 2019

Hey @mohit

There's a great new feature that's still in beta that's perfect for this-- data classification! Data Classification allows you to classify your data without using a single line of code - empowering you to easily accomplish tasks that would have previously been done through other Classification Tools, like Calculated Dimensions or VLOOKUP. Read more up on data classification HERE.

With your specific use case, you could generate a report containing all of the campaign keys within a given workspace. Next, create a second row in your spreadsheet that will contain the "correct" campaign name. You can give the column a name like "new campaign name". Once you've got this all set up, all you need to do is upload the spreadsheet and select the appropriate linking dimension (campaign key). The data classification feature also creates a data stream, so if you need to continue updating/adding to your campaign names, you can easily do that through manual upload or using an automated solution. One thing to note about this process, is that you're essentially creating a new field ("new campaign name" in my example) that is linked by way of a data fusion (this occurs behind the scenes). This new field will enable you to do the type of reporting that you've listed above, but it is not part of the ads bucket (ads data model), and technically it's not an attribute of the campaign.

Example of what our data classification source file looks like:

mohit · June 2019

Hi Ben thanks for your comment. This is great. We were using a VLOOKUP to essentially do the same thing but this option makes it easier. I just gave it a try and within a few minutes I was able to replace an existing VLOOKUP with this feature and it worked quite efficiently & fast. Nice feature.

Jsonic90 · April 2020

Thank you very much for this! It helped me resolve an issue I was having on DV360.

I have a question though. Is there a way to make this process fully automated?
I had to pull a report from DV360 which included their Campaign Name (VALUE) and Line Item ID (Key) and then matched it up to the Strategy Key on DTR.

So once new campaigns are added, would we need to manually update the relevant ID's and Campaign Names? Is there a way to link DV360 to the Data Classification setup successfully?

TLZ · April 2020

Could you use one of the connectors to pull the Display and Video 360 data and then create a report in datorama which you push to the classification stream to account for new ID's?

jfb · November 2020

Hello,
does someone has a recommendation which harmonization or classification can be used to link data from different data stream types?

What is your approach to group campaigns across different data streams?

Comments