-
Facebook Advanced - Page Post Video Daily Metrics
Does anyone know how I can pull all the daily metrics for every video I've ever posted on Facebook? Am I looking at the wrong API? I'm currently using the Facebook Advanced connector and the Page Post Video Daily Metrics API. For example, YouTube has 2 sets of parameters: A Start and End Date for when videos are…
-
YouTube Basic User Activity Date Inputs
For most Domo connectors, you have the choice of entering in relative dates (today-2) or a specific date (1/1/2020). For YouTube's Basic User Activity, it appears you can only enter in numbers of days ago. Does anyone have a solution for entering in static parameters? In my screenshot example, Videos Published After (Days…
-
Multiple SQL Update Statements in Same Transform
I'm currently adding one Update Statement per one Transform process box/dataflow in the Domo MySQL tool. How would I combine them in the same process box/dataflow in Domo? Thank you. /* Update Value1*/ UPDATE `table1` SET `Title` = "My Updated Value1" WHERE `Title` = "My Original Value1" /* Update Value2 */ UPDATE `table1`…
-
New Facebook Error
After months of successful runs, I started getting an error message in Domo last week on some Facebook datasets. I've attached a screenshot. Does anyone understand what this error is why it's happening? Domo is ready, but Facebook no longer supports requesting Insights for Pages that you are not an administrator for. I am…
-
Dashboard Page Filter Customization by Card?
I want to use the same dataset in 2 different cards. In the first card, I want to show Quarter Anaylsis revenue (year over year). In the second card, I want to show the current month for different metrics. Date is common to both cards since they share the same dataset. So when I add Date as a Page Filter, my first card is…
-
Scheduler Not Working Properly
I have been experiencing two issues. First, the scheduler doesn't allow me to input double 0s such as 2:00am UTC, it displays as 2:0_AM UTC. I thought it might be my browser, so I tried different ones and the issue is still happening. Second, once I enter in a time (8:30AM UTC), it will automatically switch to a completely…
-
YouTube Enterprise Advanced - Basic User Activity
Does anyone know how to run the Basic User Activity API so that metrics are only populated for videos that were published on or BEFORE the filter date? I am trying to get the historic daily stats for each video and what happens is rows are populating with 0s for videos published AFTER the filtered dates. So, if I want to…
-
Instagram Business IGTV Metrics
I am using the Instagram Business connector and am wondering if there are metrics for IGTV? Similar to YouTube, IGTV has a playlist called a Series and each Series has individual videos with media titles. I would like to be able to measure each Series vs individual posts. In Instagram, the Posts tab also lists IGTV posts…
-
Popular SQL Functions Missing in Domo
Domo, I saw a post from 5 years ago stating that SQL didn't have CAST or CONVERT. It's now 2020 and: * CAST doesn't even show up in the prompts * CONVERT does but doesn't work * ROUND is not even considered in the prompts. Please add these and other popular functions ASAP. It's painful these are not in there...Thank you.
-
YouTube Daily Stats
Within the Domo YouTube Enterprise Connector, it appears the stats are based on Video Publish Date and Video Views by Video. But then for the Domo Google Analytics - Google Ads Connector, which I am using to get YouTube paid stats, it has total video views by day, but not by video. Can you help me figure out how to get the…
-
Magic ETL Exclusion
I'm looking for an efficient way to only keep contacts that appeared in the year 2018 and exclude contacts that appear in the year 2019 AND 2018. It's possible for a contact to appear several times in the same year, so I cannot simply use the Remove Duplicates tile. In Magic ETL, how would I do the equivalent of: SELECT…
-
Google Analytics Custom Metric Dimensions
To start, can you please add to your Google Analytics connector (Custom Metrics): * Page * Landing Page * Medium * Source * Source/Medium * Referral Path * Full Referrer * Exit Page I use these frequently and only being able to drill down to Active Users is extremely limiting. Thank you.