Google Ads connector - Location tab - Geographic View Report

emmanuelfabre_1 · December 2023

Hello,

I brought in some simple data from the Google Ads Geographic Views report. Something as simple as metrics_clicks or metrics_impressions are not matching the UI's Location tab, under 'Targeted Locations'.

The strangest part is the clicks and impressions match (connector and UI) for some of our Client Customer IDs, but not others.

Has anyone come across this? Any ideas what might be going on?

DashboardDude · December 2023

@emmanuelfabre_1 ,

So I hope this helps, but may need to see what you're seeing to better understand: https://www.loom.com/share/91cfb0365f8c4e1d9f550edde5f7017d?sid=8043a2ac-1421-4bca-8735-899d9d238900

Also here is that google sheet with list of Google IDs per state name:

https://docs.google.com/spreadsheets/d/1knmM7-12XMIWH2SPMsmDyqXjAvjKuBl3ZrYT6tq0THw/edit?usp=sharing

emmanuelfabre_1 · December 2023

Even if I do a pull on the Country-Level, total clicks and total impressions do not match up; the UI numbers are higher by about 10%.

DashboardDude · December 2023

@emmanuelfabre_1 ,

So I hope this helps, but may need to see what you're seeing to better understand: https://www.loom.com/share/91cfb0365f8c4e1d9f550edde5f7017d?sid=8043a2ac-1421-4bca-8735-899d9d238900

Also here is that google sheet with list of Google IDs per state name:

https://docs.google.com/spreadsheets/d/1knmM7-12XMIWH2SPMsmDyqXjAvjKuBl3ZrYT6tq0THw/edit?usp=sharing

DashboardDude · December 2023

@emmanuelfabre_1 ,

It could be by date. If you want, feel free to book 30 with me and we can look at this together:

https://www.dashboarddudes.com/book-a-dude

Link to my schedule is above

emmanuelfabre_1 · December 2023

@DashboardDude Wow! Thank you!! Apologies for not checking this sooner, yesterday was my in-office day, including 4 hours on the road . I just booked time with you tomorrow.

Yes, I used the constants key [provided by Google API documentation] to map Zip Code constants in MagicETL, and create a Criteria ID field —> REPLACE(segments_geoTargetPostalCode, 'geoTargetConstants/', '') .

I have done this for Target Locations by coordinates as well, mapping to the same key and creating Criteria ID field —> REPLACE(segments_geoTargetMostSpecificLocation, 'geoTargetConstants/', '') .

The problem is now that each ETL works for one Target Type (location or zip code).
For example, if I filter for campaigns with just zip code target types, the zip code ETL data matches.

But each ETL still brings in all the data, regardless of Target Type.
If I check 'by coordinates data' in the zip code ETL, it's wrong, and vice versa.

I cannot find a way to segment or filter or exclude data in the GAds connector based on which Target Type is used.

Any help is appreciated!

DashboardDude · December 2023

@emmanuelfabre_1

Glad we got it to work! Great to talk today.

emmanuelfabre_1 · December 2023

I can't recommend @DashboardDude enough!!

Thank you for going above and beyond in helping me. I am signing up as I type this!

Google Ads connector - Location tab - Geographic View Report

Best Answer

Answers

Categories