user046467 Member

Comments

  • Thanks for your reply and oops I missed an important part in my opening post. It does actually show the percentage. It doesn't show the value name. Product 1 is too long but Prod 1 fits. But as I can understand from your post there isn't an (easy) way to force this anyway? I do have the legend on the left side so it does…
    in Show labels on pie chart even if it's too small Comment by user046467 August 2020
  • Thank you for your reply @MichelleH I think you might have misunderstood me (or I did). I attached an image of what I am trying to accomplish. So although I have 48 sales compared to 54 last month my target is 45. But with the normal gauge I cant compare to last month. And with the period over period gauge I cant set a…
    in Use Gauge : Target + comparison Comment by user046467 August 2020
  • Excellent @GrantSmith sometimes it can be so simple but for a newcomer like me it's a lot harder haha. I understand how it works now and got it working. The only thing I don't understand is the first line: CASE WHEN SUM(CASE WHEN `page` LIKE '%/page1/%' THEN `Unique Pageviews` ELSE 0 END) I left it out and it gave me the…
    in Beastmode: Filter pages and divide them Comment by user046467 August 2020
  • Thanks both for your replies. @jaeW_at_Onyx "unique visitors" is just a metric from Google Analytics. So you can also call it just "visitors". I tried both calculations but it's missing something as it counts the cases but I need to sum the values from "unique visitors". I've attached a filed of the data I am receiving…
    in Beastmode: Filter pages and divide them Comment by user046467 August 2020
  • Thanks for your reply @jaeW_at_Onyx That option is not showing for "Google Sheets" sadly.
    in Google Ads + Google Sheets overwrites the old data Comment by user046467 July 2020
  • Thanks @GrantSmith ! I am new to SQL so figuring everything out by trial and error. But this makes perfect sense so I will try this soon 
    in ETL Addition empty fields Comment by user046467 June 2020
  • @jaeW_at_Onyx Thanks for your response. From what I can see all the data is coming in so that's working fine. But with the (simple) Facebook Ads connector I can just select "Date" and select a timeframe I want within the date selector card. Facebook Advanced Ads doesn't offer "date" I only have "batch_last_run",…
    in Automatically add new Facebook ads campaigns to dataset and filters within cards Comment by user046467 June 2020
  • Thanks @jaeW_at_Onyx I got it working! Another question (or should I open a new topic?) which I am struggling with is getting the date selector to work with the FB Ads advanced connection. Every date dimension doesn't seem to be working. I get the calendar but I just don't get data for the specific period (it says there is…
    in Automatically add new Facebook ads campaigns to dataset and filters within cards Comment by user046467 June 2020
  • Hi @GrantSmith Thanks for your quick reply. I haven't used that one yet but that doesn't solve the second/filter problem if I am correct. Because I filter by campaign name (in the card editor) and have to manually select it to include it within the card. Is there any way to come around this? Otherwise I might have to do…
    in Automatically add new Facebook ads campaigns to dataset and filters within cards Comment by user046467 June 2020
Default Avatar