Hello dear community! I have two tables I wanted to blend, one is with registrations from our CRM:
And the other is with costs from AdWords:
So I was blending it on date (day=day, month=month, year=year) and campaign.
But that doesnt work. Is that correct because at least one of the tables should have unique values to make the blend? So that while blending it wouldnt aggregate data from the Registration table as to a line 01.12.2018-Fruits-count(user id)?
Try Converting Dates to Month Level and blend or Join with Month and Camaign.