Black Friday Deals Dashboard

All Site Suggestions or General Black Friday Tips

Moderators: Tony, Huy, cematra173, killasnake

nynamyna
Black Friday Newbie
Posts: 7
Joined: Wed Nov 23, 2016 10:54 am

Black Friday Deals Dashboard

Postby nynamyna » Wed Nov 23, 2016 11:03 am

Black Friday Deals Dashboard
I created this dashboard last year and got a good response. I have updated it this year with the latest deals. I hope this helps. I took the excel sheet I got from bfads and I have given credit at the bottom of my dashboard.

Link for 2017 Dashboard

https://public.tableau.com/profile/bhar ... ublish=yes

Link for 2016 Dashboard

https://public.tableau.com/profile/bhar ... ridayDeals

Link for 2015 Dashboard

https://public.tableau.com/views/2015Bl ... _count=yes
Last edited by nynamyna on Sat Nov 18, 2017 1:52 pm, edited 3 times in total.

User avatar
Shopper X
Suspected Line Jumper
Posts: 2426
Joined: Wed Nov 16, 2005 6:05 pm

Re: Black Friday Deals Dashboard

Postby Shopper X » Wed Nov 23, 2016 2:26 pm

Thanks. Hopefully, people will find it useful. I know that some people find the spreadsheet somewhat difficult to use, and they might find the dashboard more helpful.

User avatar
blue3715
Black Friday Pro
Posts: 267
Joined: Wed Oct 29, 2014 4:34 pm

Re: Black Friday Deals Dashboard

Postby blue3715 » Fri Nov 25, 2016 9:14 am

wow, the search function is awesome.. trying to find all "chrome book" deals and a simple search worked awesomely.

Please keep this dashboard going for next year!

dmikester1
Black Friday Amateur
Posts: 18
Joined: Fri Nov 13, 2009 4:55 pm

Re: Black Friday Deals Dashboard

Postby dmikester1 » Wed Nov 08, 2017 3:09 pm

OK, this looks really cool! Are you doing this for 2017?

FYI, the link for 2016 is broke but 2015's works.

User avatar
inthedark
Black Friday Pro
Posts: 3371
Joined: Sat Nov 03, 2007 8:40 am
Location: Michigan

Re: Black Friday Deals Dashboard

Postby inthedark » Thu Nov 09, 2017 7:16 am

nynamyna wrote:Black Friday Deals Dashboard
I created this dashboard last year and got a good response. I have updated it this year with the latest deals. I hope this helps. I took the excel sheet I got from bfads and I have given credit at the bottom of my dashboard.

Here is the link

https://public.tableau.com/shared/JNQBN ... _count=yes

My last year dashboard

https://public.tableau.com/views/2015Bl ... _count=yes


The link isnt working for me

dmikester1
Black Friday Amateur
Posts: 18
Joined: Fri Nov 13, 2009 4:55 pm

Re: Black Friday Deals Dashboard

Postby dmikester1 » Thu Nov 09, 2017 8:29 am

inthedark wrote:The link isnt working for me


Yep, like I said in the post above yours, 2015 works, 2016 does not.

nynamyna
Black Friday Newbie
Posts: 7
Joined: Wed Nov 23, 2016 10:54 am

Re: Black Friday Deals Dashboard

Postby nynamyna » Tue Nov 14, 2017 9:23 pm

dmikester1 wrote:OK, this looks really cool! Are you doing this for 2017?

FYI, the link for 2016 is broke but 2015's works.

I fixed the links. Will be doing it this year.

nynamyna
Black Friday Newbie
Posts: 7
Joined: Wed Nov 23, 2016 10:54 am

Re: Black Friday Deals Dashboard

Postby nynamyna » Tue Nov 14, 2017 9:24 pm

dmikester1 wrote:
inthedark wrote:The link isnt working for me


Yep, like I said in the post above yours, 2015 works, 2016 does not.

Check now. It should be working.

nynamyna
Black Friday Newbie
Posts: 7
Joined: Wed Nov 23, 2016 10:54 am

Re: Black Friday Deals Dashboard

Postby nynamyna » Sat Nov 18, 2017 1:39 pm


User avatar
blue3715
Black Friday Pro
Posts: 267
Joined: Wed Oct 29, 2014 4:34 pm

Re: Black Friday Deals Dashboard

Postby blue3715 » Sun Nov 19, 2017 10:19 am

nynamyna wrote:Here is this Year's Dashboard

https://public.tableau.com/profile/bhar ... ublish=yes



You don't have TrueValue items listed. I was checking the Dewalt 20v drill and didn't find it.

It's right on page 1: https://www.bfads.net/stores/true-value ... day/page-1

What other stores are you missing? this app is great, if it is comprehensive.

User avatar
Shopper X
Suspected Line Jumper
Posts: 2426
Joined: Wed Nov 16, 2005 6:05 pm

Re: Black Friday Deals Dashboard

Postby Shopper X » Sun Nov 19, 2017 5:41 pm

There is something odd/wrong with the tableau. When you select the Store dropdown menu, there are strange values for the first two checkboxes. I temporarily uploaded a screenshot showing the issue:
https://postimg.org/image/447twuo4r/

nynamyna, let me know if you see any problems with the CSV file. However, I opened and imported the CSV file (both today's and yesterday's) just fine with LibreOffice, so the file should be good.

One thing that I recently changed in the CSV file is that for the Home Depot deals, I replaced all the URLs with the text "(archived deal)". Could that have caused the problem? I could instead remove those URLs completely and leave them blank. I replaced those URLs because they aren't really valid since BFAds pulled the Home Depot ad and I wanted to indicate that the deals were pulled from an archived copy.

nynamyna
Black Friday Newbie
Posts: 7
Joined: Wed Nov 23, 2016 10:54 am

Re: Black Friday Deals Dashboard

Postby nynamyna » Sun Nov 19, 2017 8:23 pm

Shopper X wrote:There is something odd/wrong with the tableau. When you select the Store dropdown menu, there are strange values for the first two checkboxes. I temporarily uploaded a screenshot showing the issue:
https://postimg.org/image/447twuo4r/

nynamyna, let me know if you see any problems with the CSV file. However, I opened and imported the CSV file (both today's and yesterday's) just fine with LibreOffice, so the file should be good.

One thing that I recently changed in the CSV file is that for the Home Depot deals, I replaced all the URLs with the text "(archived deal)". Could that have caused the problem? I could instead remove those URLs completely and leave them blank. I replaced those URLs because they aren't really valid since BFAds pulled the Home Depot ad and I wanted to indicate that the deals were pulled from an archived copy.

Hmm..Let me see. May be, it messed it up when i imported the data. I will see if i can fix it. Thanks for all your work regarding this. This wouldn't have been possible without your spreadsheet.

nynamyna
Black Friday Newbie
Posts: 7
Joined: Wed Nov 23, 2016 10:54 am

Re: Black Friday Deals Dashboard

Postby nynamyna » Sun Nov 19, 2017 8:25 pm

blue3715 wrote:
nynamyna wrote:Here is this Year's Dashboard

https://public.tableau.com/profile/bhar ... ublish=yes



You don't have TrueValue items listed. I was checking the Dewalt 20v drill and didn't find it.

It's right on page 1: https://www.bfads.net/stores/true-value ... day/page-1

What other stores are you missing? this app is great, if it is comprehensive.

Thanks. This is based on Shopperx's spreadsheet. I will see if his latest sheets has it.


Return to “Suggestions and Tips”

Who is online

Users browsing this forum: No registered users and 6 guests