-
Google Analytics Advanced Connector - User count does not match with GA
I'm using the Google Analytics Advanced Connector and I can't seem to get the correct/exact count of Users when comparing to Google Analytics/Data Studio numbers. I'm aware that Google Analytics aggregates the Users differently compared to the Sessions/Pageviews depending on my selected dimensions (i.e. in order for me to…
-
MySQL Connector to Read Only Some Tables in a Database rather than All Tables in a Database
We are using a MySQL connector to load data from our Google Cloud SQL servers into DOMO. From what I can tell, it is only possible to connect to a Database, and all the tables within that database become accessible via the connector. Any of the tables in our database can be chosen in this window (see the highlighted…
-
Adobe Analytics OAuth 1.4 connector - Update a dataset hourly
-
Json No Code
Is the Json No Code connector OAuth 1.0 or OAuth 2.) The knowledge base article does not specify.
-
Date for Adobe Analytics v2 JWT Partition Connector to come out of Beta?
With Adobe Analytics API v1.4 EOL scheduled for August 18, does anyone know when the Adobe Analytics v2 JWT Partition Connector connector is scheduled to come out of Beta?
-
Deactivating Sample Data Engine Connector
Hello everyone, Is there any way to deactivate the Sample Data Engine Connector? This particular connector is not powering any dataset and when I tap the Deactivate button nothing happens. Thank you for your time.
-
Email connector not finding link
Hi there! According to the KB article for the Email Connector this should be working correctly, but here I am :) I receive a nightly scheduled XLSX report from a third party reporting tool. They recently stopped attaching the report to the email and instead put it a link to a page which then downloads the file from AWS.…
-
SHAREPOINT REST Connector | Issue
Hi, We are trying to connect to our sharepoint domain using specific service account provided for us. We tried following steps from this link: https://domohelp.domo.com/hc/en-us/articles/360043436773-Microsoft-Sharepoint-Online-REST-Connector#2.1. We already passed thru account verification with no issue using client id…
-
Magic ETL join operators
Is there going to be a version of Magic ETL that allows for other operators in a join besides "="? I have a situation where I need to use greater than or equal to and I have to use RedShift for this when I could use Magic ETL is other operators were available.
-
Box advanced connector multiple excel files
In the Details section of the Box Advanced connector, the information icon next to the "Would you like to choose a file from folder" indicated that if selected as Yes, then the connector should pull the files from the folder specified in the "Folder name or ID" field. However, when I execute this data load with a folder…
-
how can I update 0 record in Google Analytics Real Time Connector
I used Google Analytics Real Time Connector to get the "active user" data. I want to display "0" when there are no active users. But I found that the dataset will not be updated when there are no active users. What can I do to let the dataset update or clear data when there are 0 records.
-
MS SQL Server Writeback Connector
Hello, Can the MS SQL Server Writeback connector be used to write data to an Azure database? Thank you, Chris
-
Salesforce connector - report import
Hello! I brought in a tabular report from Salesforce using the Salesforce Connector and I see that few columns are not retrieved. Can anyone help me understand what can cause this.
-
YouTube Connector
Hi there! I'm having trouble figuring out how to pull video views from the YouTube connector. It's not clear what metrics each report has. Thanks!
-
My ETL fail with no indication why
I had an ETL to create some aggregated data sets from a raw dataset. It was running great for months, new data would get added to the raw dataset, the ETL would run and the aggregates would be updated. Maybe the raw dataset grew too large because now it fails and gives no error or indication why. I tried creating an ETL to…
-
Asana Connector - Get hours allocated to a task
Using the Asana connector I have gone through all the available datasets and can't find the hours allocated to a task anywhere. Use case: Use Domo to create a table of team members's resourcing levels by hours on a daily basis.
-
How do I create a Merge Key for Azure Synapse SQL Connector?
We have a large dataset that we update daily, we want to change from the "Replace" update setting to the "Merge" setting. It asks for a "Merge Key Location" - the input field just continuously tries to load something How do we switch to the Merge update method?
-
How to deactivate a user
Hello Community, Is there a way to deactivate Domo user for some time and temporarily suspend it and not delete it...
-
How to get number of followers each month from Twitter advanced connector?
Hi there! I can't seem to figure out how to pull the number of followers my account has each month. If I use the followers report, it returns a list of current followers. Should I append each month and just do a count as the number of followers? That seems kind of crazy as the dataset will get huge and there's a…
-
Tripadvisor, Google My Business, Trustpilot etc
Hi all, Working in the experience industry, we work with Tripadvisor, Google My Business, Trustpilot etc. for reviews and other info. I'd like to pull in that data into Domo. Domo has no connectors even though the platforms are worldwide and very important. Has anybody done anything with any of these kinds of platforms?…
-
NetSuite Connector
Our company is currently planning to get the Oracle NetSuite for the finance department. One of the things we heard is that is is very challenging to pull the data from NetSuite or there are limitation on how many rows you can pull data at one time and others. Can you guys share your experience and challenges if you have…
-
Google Analytics Exclude Filter
I'm working with a very large data set where most of the data is not tied to a GA Campaign. In order to reduce the amount of data I'm working with, I'd like to filter out all rows that do not have the value "(not set)". My current formula: " { "dimensionFilterClauses": [ { "filters": [ { "dimensionName": "ga:campaign",…
-
Connecting with Marketo to count email messages
How do we bring Marketo data into DOMO so we can count how many emails a lead received before making a purchase?
-
Unable to fetch all data from Salesforce Report
Hi, I have created a report in Salesforce and it having more than 89,591 records. But, Domo fetches only 2,000 records from salesforce. why it is happening? is am missing some settings or its DOMO limitation? Please suggest. Salesforce Screenshot : DOMO Screenshot:
-
Governance - partial activity log
I've brought the DomoStats datasets into our instance and have seen that they are quite sizeable (the activity log dataset is currently taking up 40% of our row space). Is there a way to limit the number of rows this connector brings in? I'd like to keep the activity log info, but I really only need the past few months,…
-
Amount (converted) salesforce field
Could anyone please confirm why Domo does not allow me to select the Amount (converted) field from the Opportunities object in salesforce? It is not even listen as an option when attempting to pull that data by browsing objects and fields. I suspect it might be because it might use a conversion formula not…
-
Which Redshift SQL version / functions are supported?
Hey ya'll, I'm trying to write query to do a Regex sub string on some text. Beast Mode and Magic ETL have Regex but not Regex sub string. MySQL has the capability but Domo is on version 5.x~. My last option was Redshift SQL. My query: SELECT SUBSTRING_REGEX("Description", '.*(Red).*') as color from "clothing_db" Error: The…
-
Google Analytics Connector Column Type issue
Hello All, I am having problems with the Google Analytics Connector. The KeyCode management column of a custom dimension, which was recognized as a text type until last month, has suddenly changed to an Integer type. Some IDs in the data still contain alphabetic characters, and I cannot resolve the ETL error. It also…
-
How to hide target in Bullet Chart
I want to create a chart that displays the percentage of opportunities that have closed. I created a Beast Mode that displays a 1 if the Opp has closed and a 0 if it hasn't closed. I then threw it into a bullet chart, categorized by Lead Source. This is all well and good, but I don't want the target value to be visible…
-
Connecting to an Excel file in Microsoft Teams
Good Day, I want to connect Domo to a file stored in Microsoft Teams. Has anyone done this? Love to get some instructions on exporting data out of an excel document stored and updated in teams to push data into Domo. Thanks, Gordon