LinkedIn
Twitter
Hi everyone,
I am currently facing the following challenge: I would like to combine data from Google Adwords and Google Search Console. I am using the merged data sources option for this. I connect the data with the month and a full outer join and display the clicks. I then use the whole thing in a stacked chart. Everything works smoothly. The stacked chart clearly shows the clicks and Google Ads & the GSC at monthly level. The comparison with the data from the two tools shows 100% congruence.
However, I would like to filter the data in advance, as I am only interested in clicks on certain keywords. To do this, I use the filter option for the two data sources in the merged data source - i.e. once for Google Ads and once for the Google Search Console. I use the following RegEx in both:
Google Ads (Search account): Include - search term - regular expression match - ^(Keyword A|Keyword B|Keyword C)$ AND Exclude - search term - is null
Google Ads (Shopping account): Include - search term - regular expression match - ^(Keyword A|Keyword B|Keyword C)$ AND Exclude - search term - is null
GSC: Include - Query - Match regular expression - ^(Keyword A|Keyword B|Keyword C)$ AND Exclude - Query - is null
With these settings, the stacked chart (but also any other visualization including table display) behaves very strangely: While the data from Google Ads remains correct, the period with this filter setting does not seem to work for the data from the GSC. The period Jan - Oct is set. The data from the GSC is completely missing for the period Aug to Oct. If I shorten the period to July to October, the data from the GSC is back and accurate.
So the big question: What could be the reason here? I would appreciate any tips 🙂
Felix
