Admin Advanced - Media Transparency Center to track campaign

otthon

Hi guys, How are you?

Does anyone know how to solve the Task 3.Utilize the Media Transparency Center to track campaign pacing?
(4. Unfortunately, your client’s planned data does not contain Media Buy Keys and this is the level at which the data sets are generally linked. Therefore, the client needs you to retrieve the Media Buy Keys from DFA and Facebook Ads by using a mapping formula in this data stream in order to complete the client’s request. The above should be completed in the Media Buy Key dimension.)


Thank you!

Alex_Deliysky

Hi @otthon,

I am afraid that the Exam is supposed to be done individually and not to be discussed in the Community. Otherwise, we lose the integrity and validity of the Certificate.

Kind regards,
Aleks

william_mollers

Yeah that is understandable if it were for something like a bachelor's degree...

This is a program that you want us to use right? 

The main issue I have had is that the notes are out of date (UI / UX has changed in Datorama) or that the examples given are not sufficient. 

A lot of the tools have clearly been written by someone who assumes knowledge.

This makes no sense. 

Particularly as the way that Datorama uses elements of SQL is not at all consistent with typical SQL in the formula mapping. 

Overall I like what Datorma achieves as a product, but you really need to spend more money on updating the training manuals / provide clear, more detailed examples. 

Rita_Catarino

Hi otthon 

I'm facing the same problem. I've tried to map media buy key within the buy data data stream or mapping the media buy key as an attribute;
Retrieving all the patterns  from both facebook_ads and DFA data streams;
But i'm not being able to relate the IO Key with the media buy key from the DFA data stream.

Have you solved the exercise?

Thanks in advance
Kind regards 

ramiropoli

Hi Rita, I am currently facing the same problem as you are facing and I am stuck in the exam.

In a previous exercise we were requested to REPLACE the Media Buy Name to have '_' instead of '-'.

This is generating different Dimension values for the Media Buy Names for the different Data Streams.

Even if I adjust them to all be '_' or all of them be '-' I still get a validation error.

My formula currently looks something like this:

VLOOKUP_UNNEST(csv['Media Buy Name'],[Media_Buy_Name],[Media_Buy_Key],false,{'DFA Data','FB Ads2020-2021' })

I also tried with the whole workspace and Data Streams being taken:
VLOOKUP_UNNEST(csv['Media Buy Name'],[Media_Buy_Name],[Media_Buy_Key],true,true)

Have you guys find a solution to it?

Kind regards,
Ramiro

User1107

Having the exact same problem and could not agree more with previous writers in this thread. There are way too few resources available to manage without help from sys admin. 

Rochak

Hi Community members,
I am also stuck at the same point. Support here would be highly appreciable.
Thanks and regards

Shaun

william_mollers said:

Yeah that is understandable if it were for something like a bachelor's degree...

This is a program that you want us to use right? 

The main issue I have had is that the notes are out of date (UI / UX has changed in Datorama) or that the examples given are not sufficient. 

A lot of the tools have clearly been written by someone who assumes knowledge.

This makes no sense. 

Particularly as the way that Datorama uses elements of SQL is not at all consistent with typical SQL in the formula mapping. 

Overall I like what Datorma achieves as a product, but you really need to spend more money on updating the training manuals / provide clear, more detailed examples. 

Agreed please provide more training.