This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Help with with Data problems

Posted Wednesday
MAJOOMG
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

Hello, I need help to solve an issue that I have been unable to resolve for several days.

I need to generate a sheet showing results of different KPIs of Meta and Google Ads campaigns.

I made a cross table combination for example by impression and for each platform I generate a filter because I don't need everything that is inside the account of each platform but every time I do it, it only takes me one platform (Meta in this case)

I did the formula of sum impressions in google and impression in meta but there is no chance.

What could be happening? I have been looking for help on ChatGTP and it shows me the process I am following but nothing.

Can´t you help me??

Best Regards,

 

Maria Jose

0 1 47
Topic Labels
0 Likes
1 REPLY 1

Posted on --/--/---- --:-- AM
Mehdi_Oudjida
Silver 2
Silver 2
Reply posted on --/--/---- --:-- AM

@MAJOOMG 

To merge the 2 sources in the same chart, you need to mimic UNION ALL operator with data blending feature.

You will find below a tutorial describing how to do it.

https://www.withlookerstudio.com/blog/data-sources/20220222-how-to-mimic-union-all-operator-with-goo...

I hope it helps.

Mehdi