The new UNION operator combines tables vertically. Joins were already available and combine them horizontally.
Google renamed "join" to "merge", since the term now covers both blend types.
Watch out: this is a true UNION, not UNION ALL. Rows shared by the tables get deduplicated. To keep every row, add a static dimension, for example the table name.
The lower part of the merge setup lets you map fields across sources that don't share the same data model.
Spotted by Mehdi Oudjida
Free. Read by 125K+ marketers every week.
Subscribe for freeGoogle is rolling out a mixed media ad creation flow. Product feeds can go in the same ad too. What else changes for new ads: Video level creative preference controls…
Spotted by Anthony Higman, via Hana Kobzová
That's the change as it was shared, with no details yet on which formats, countries or accounts see it. No word on whether viewers can still skip these ads or…
Spotted by Anthony Higman
The ad sits above the AI answer. Sitelinks show right under it. Google AI Mode mostly places its ads at the bottom of the page, so Bing's placement is different.…
Via Search Engine Watch
