-
Amazon Vendor Central Data
Hi, Has anyone figured out how to automate the influx of 1P amazon vendor central data? We are doing manual pulls right now and I don't think there is an API for sales info. Thank you,
-
market share over time with maximum slices
Hello, I'm trying to find a card or a way to build a card that shows me our market share over time and our main competitors market share over time (say top 6 competitors) and will group all the other smaller competitors into an "all other competitor category". The pie chart has a nice feature where you can pick your…
-
Connecting Data Through Email When You Have to Click on a LInk
Hello, I'm trying to connect Amazon marketing data. I set up a report to come to me daily through email, but I have to click on a link that says "download", then I have to click "Open". Does anyone know if it is possible to automate this connection? Thank you,
-
widen dashboard
Is anybody aware of how to widen the dashboard. There seems to be a lot of wasted real estate on the sides. Thanks!
-
Pulling latest 4 weeks from Max date in Beastmode
Hello All - I'm trying to create a filter for the latest 4, 13, 26, and 52 weeks so I can pull sales by these time frames. I'm not trying to pull from the current date, but from the max date that is available because our reporting only comes in every 4 weeks. This is my current query that is only returning 'other'. CASE…
-
Sum Previous 4 Weeks of Sales Together
Hi, I'm trying to sum our weekly sales data into 4 weeks of sales. For example, if we had $10 in sales each of the past 4 weeks, the value returnded should be $40. I'm using this function: SUM(CASE WHEN WEEK('Week Beginning') > WEEK('Week Beginning') - 4 THEN 'Sales' ELSE 0 END) But this is just returning the sales for…
-
Summing up sales for previous year
Hello - I'm trying to pull into a table on my card the following: Current Year Sales Previous Year Sales The calculation I'm using for previous year sales in beast mode is CASE WHEN YEAR(current_date()) = YEAR(`week_beginning`) - 1 THEN SUM(`sales`) ELSE 0 END or sum(CASE WHEN YEAR(current_date()) = YEAR(`week_beginning`)…
