Connectors
Connectors
Google Ads connector - Location tab - Geographic View Report
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?
Welcome!
Best Answer
-
So I hope this helps, but may need to see what you're seeing to better understand:
Also here is that google sheet with list of Google IDs per state name:
John Le
Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more
Signup here:
0
Answers
-
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%.
0 -
So I hope this helps, but may need to see what you're seeing to better understand:
Also here is that google sheet with list of Google IDs per state name:
John Le
Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more
Signup here:
0 -
It could be by date. If you want, feel free to book 30 with me and we can look at this together:
Link to my schedule is above
John Le
Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more
Signup here:
0 -
@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!0 -
Glad we got it to work! Great to talk today.
John Le
Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more
Signup here:
0 -
I can't recommend @DashboardDude enough!!
Thank you for going above and beyond in helping me. I am signing up as I type this!1
Welcome!
Welcome!
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 659 Datasets
- 116 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 82 App Studio
- 45 Variables
- 776 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 82 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive