Getting Adwords Data into Domo
Hi,
I'm trying to get some data from Adwords into Domo and having some trouble.
I recall at one point their was an Adwords connector but this doesn't seem to be available anymore?
I've connected my Google Analytics and Google Adwords accounts and the Adwords information is displaying in my Analytics account, but when I pull it through into Domo through a custom Google Analytics connector, the columns appear correctly but the CPC/CTR/Impressions/etc information just returns values of 0
Has anyone had any experience getting this data into Domo? Or does anyone know why this is returning values of 0?
Any help would be appreciated
Best Answers
-
Hi After some trial and error, i came up with the following. You cannot pull in default channel grouping as a dimension when getting adwords data out of a GA account that is connected to an Adwords account - why, I don't know. But there it is, once I dropped that from the set dimensions I've got cpc, cpm, cpc, actual cost etc pulling into my domo reports via the google analytics connector.
thanks!
Nicole
1 -
In the Knowledge Base you can now find the new and improved guide to getting AdWords data in Domo: http://knowledge.domo.com?cid=googleadwords0
Answers
-
What dimensions are you pulling? I would recommend Ad Group and Keyword Match Type from the AdWords section, and Campaign and Keyword from the Traffic Sources section, and whatever date grains you want.
0 -
Hi @CantStopTheHopp,
I've set up the custom report with those dimensions and then selected all the Adwords metrics to be pulled in.When the report runs it returned those columns but the values returned are all 0 (this isn't what shows in GA).
Any advice?
Nick
0 -
That is strange. I would send in a support ticket.
0 -
In general we've been taking Google Adwords, using a script to push the desired data into Google Sheets and then pulling it into Domo.
I myself have not worked much with the linked Analytics / Adwords, but it sounds like it might be a feasible solution.
If you are seeing discrepancies between Google Analytics and Domo I HIGHLY recommend using Google Analytics API Query Explorer - https://ga-dev-tools.appspot.com/query-explorer/
There you can select the metrics, dimensions, and segments just like in Domo.
What we find many times is that Google Analytics will give you a nice dashboard, but does not tell you how that dashboard was created or what they are doing, so it makes it VERY hard to match.
If you instead compare Domo to the Query Explorer (or you could make a customized flat report in Google Analytics) I have found it to always match.
1 -
@Nick-Hede, did Bulloko's reply help answer your question?
0 -
I am having the same problem - we should be able to use the domo GA connector to pull in data however all columns are being returned as 0
0 -
Hi After some trial and error, i came up with the following. You cannot pull in default channel grouping as a dimension when getting adwords data out of a GA account that is connected to an Adwords account - why, I don't know. But there it is, once I dropped that from the set dimensions I've got cpc, cpm, cpc, actual cost etc pulling into my domo reports via the google analytics connector.
thanks!
Nicole
1 -
Thanks nnestel,
I took the default channel grouping off and managed to get my data through. Thanks again!0 -
In the Knowledge Base you can now find the new and improved guide to getting AdWords data in Domo: http://knowledge.domo.com?cid=googleadwords0
-
Also see this thread on same topic.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 99 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 728 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive