Bulloko Contributor

Comments

  • @bduncan717 - I did some exploring. I found that in Box you can click on the folder you want, go into the Folder Properties and you can change the Email Options. There you can "Allow uploads to this folder via email". With that, any attachments to the file, send to that email addess will be dropped in that folder. You can…
  • @Shevy - I apologize, I don't fully understand your question. It sounds like your goal is to have some sort of web form users can edit and then have that dynamically update in Domo?
  • @AndreaChapman - Your idea sounds very simliar to this one here - http://dojo.domo.com/t5/Ideas-Exchange-suggest-and-vote/Run-all-the-steps-in-a-dataflow-to-a-point/idi-p/7126 That one is also currently under review. Be sure to Up Vote it and Comment on it if this is something you want also. If that one isn't exactly what…
  • @caedmon - I think you best bet would be to use a BeastMode Calculation to do this. It would look something like this - CASE WHEN `Date Column' = January then 1 WHEN `Date Column' = Febuary then 2 WHEN `Date Column' = March then 3 WHEN `Date Column' = April then 4 WHEN `Date Column' = May then 5 WHEN `Date Column' = June…
  • @samh - Domo doesn't create API's for other companies. The company (in this case JW Player) will create their own API. We then create a connector that utilizes their API and gets the data we need/want. So yes, JW Player does have an API they have created…
  • When comparing Domo to Adobe I HIGHLY recommend using Adobe's API Explorer - https://marketing.adobe.com/developer/api-explorer You start off with a Report - Queue and put in the JSON for the report you want to Queue. You will get a return of your Report ID. You can then run Report - GetQueue and watch it in the queue.…
  • @joelBroadbent - Google Analytics API doesn't seem to let you query your Custom Dashboards (at least from what I can see). If you work with DomoSupport they can actually get you set up with an "Advanced Google Analtyics" connector. That gives you is the capability to pick which Dimensions, Metrics, and Segments you want.…
  • @jeffcavallo - Given that the error doesn't give you much, it might be best to actually reach out to DomoSupport and see if they can get a little more information on this. If you can, create a NEW DataSet, get it to fail and have DomoSupport look at that one.
  • @gwsv-it - is correct. Going through and using a script to push said data into Google Sheets and then pulling it into Domo is how we bring the data in currently. It does require a little scripting knowledge / skill, but it isn't that bad. Here is a "base" script I have found much success with - function main() { var…
  • @zcameron is exactly right. I found here Salesforce's official documentation regarding this. https://help.salesforce.com/HTViewHelpDoc?id=limits_analyticsapi.htm&language=en_US * The API returns up to the first 2,000 report rows. You can narrow results using filters.
  • I'd also highly recommend testing your query in Adobe Analytics API Explorer and see what Adobe is bringing back - https://marketing.adobe.com/developer/api-explorer
  • @LucasB - If you have an ODBC driver for your MySQL DataBase, then I believe WorkBench would be your best option. WorkBench is hosted locally and then it simply pushes the data you want into Domo. So you don't need to expose the DataBase to the internet.
  • 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…
  • @CoreVest The connector works like this - It sends a request to Facebook asking that the metrics be calculated. Then it checks back periodically to see if the calculations are complete. When the calculations are complete, it returns data. That message happens if something goes wrong while the calculations are being…
  • @kvallee - Depending on the company, sometimes all the data in a single column is actually not all the same. One example is Google - CPC data. This column many time comes in with a $ value, but will sometimes come in as the word "NULL" and sometimes as "Avg .36". Both of which are strings, so that makes the entire column a…
  • @Brenton - I personally am not familiar with BW queries using OLE. Can automate these CSV files in anyway? If so, we have a few options. If your program can push files to an SFTP server, we can bring them in. If you can email reports with an attached file, we have a few options. If you can push these files to a folder on…
  • @Lisa-Chang - A DataFusion should be able to meet your need of taking two datasets and relating them on a one-to-many basis. So in the case of Company to Activities. I assume that each Company has a Name and each Activity has the name of the company. So when building the DataFusion, I would be sure I am selecting "Add…
  • @christophorce - I didn't see any specific connectors that pull Yahoo Finance or Etrade, however if you go into your DataCenter and look for the Quandl Connector you'll see some files that might you what you are looking for - "NASDAQ-100.zip" "EndofDayStockPrices.zip" Take a look and see if those meet your needs!
  • @lisensee - Would it not be possible to instead do this through WorkBench? Looking around I see there are a few ODBC drivers for MongoDB. From what my WorkBench expert has told me, as long as there is an ODBC driver.
  • @jeffcavallo - When you mean it is formatted as a percent, how is it coming through? 90.0%, 90%, 90? What is the CAST / CONVERT function you are trying to run? I think if you try to CAST 90% you actually have to first get rid of the % and THEN cast it.
  • @nick_datasift - Oh perfect! Thanks for that! I've gone ahead and upvoted that one also!
  • @nalbright is exactly right!! If you feel your question is answered, please be sure to mark it as Answered!
  • @AndrewLacy - Great question! I went ahead and did some testing to see how this exactly functioned. If I share a card with Editor A, they can see the DataSet. If I un-share the card with Editor A, they can no longer see said DataSet. The only way to make sure Editor A cannot see that DataSet anymore is to make sure they…
  • @AndrewLacy - To give an Editor access to a DataSet you will need to share a card that is already created on said DataSet. When that card is shared with them, they will have access to view the DataSet and create other cards off of it. They will not be able to change the details of the DataSet itself.
  • @AndrewLacy - Currently we do not have a way to customize the access for the different levels. You can see what they can currently do by going into your Domo Instance, going go the Admin page and looking at the Access Rights. You can also head over to our WIki by clicking on the drop down in the top right hand corner of…
  • Currently the connector will only pull files if they are found in the root directory. We do have an advanced connector that can pull files from other directories. Please feel free to open a ticket with support by email support@domo.com and let us know what you need brought in and we will assist you with it!