The daily DALS and Blonde effect

[Scruffydog777]

Does anyone have the know how to put these numbers into a line graph form?

[Rev]

OLD --- Current files moved to Post 122 --- OLD






Here is the new version. It is now in segments to improve readability. Each segment has to be the same size, which is why I have to include some blank worksheet.

The Deltas show the "per day" changes.
These numbers are from Ray4AJ's listing in post #1 above.


I should probably explain what the light and dark yellow coding mean.
I look at each artist's "pre-DALS" trend. IF, on a particular day, they significantly exceed THEIR Pre-DALS trend, I highlight the box in light yellow.
IF, on a particular day, they very significantly exceed THEIR Pre-DALS trend, I highlight the box in bright yellow.

Looking at the spreadsheet above, you can easily see the effect of DALS on each artist's daily totals.
- Tal, saw a significant bump in her daily numbers (above what she was seeing before DALS) only around the time she was voted off.
- Alizée, on the other hand, received a huge boost almost immediately. And, as you can see by all the bright yellow in her Facebook list, she continues to benefit significantly.

The following image is the entire spreadsheet. Click on the image to follow the link Then click on the magnifying glass icon in the bottom right a couple of times to see it at full resolution:



OLD --- Current files moved to Post 122 --- OLD

[Scruffydog777]

I would say twitter, then maybe instagram.

[Rev]

OLD --- Current files moved to Post 122 --- OLD




Updated Chart of the 10 spread sheet COUNT columns.



How is this?

Edit:

Here is a version showing baselines for Alizée and Tal for Facebook and Twitter.



If you have a problem seeing a chart clearly, click on the image to follow the link. Then click on the magnifying glass icon in the bottom right a couple of times to see it at full resolution:
.

OLD --- Current files moved to Post 122 --- OLD

[Ray4AJ]

Thanks Rev. Makes it much more clearer!

[Rev]

Updated the spreadsheet in post 82 to the 20th.

Tal is back to pre-DALS daily counts, and it looks like both Laetitia and Alizée got less after-DALS boost than they did in previous weeks.

[Wizard]

Wow, helluva an analysis here! The numbers look very interesting going into the last week.

[Rev]

Updated the spreadsheet in post 82 to the 23rd.

Tal is back to pre-DALS daily counts, and it looks like both Laetitia and Alizée got less after-DALS boost than they did in previous weeks, Although Alizée is still clearly benefiting from her DALS involvement.

[george007]

Another funny trend: the search interest for "alizee" peaked on Saturdays every week during the DALS period starting from 28th September

[Rev]

Updated to November 24th, here:
http://alizeeamerica.com/forums/show...9&postcount=82

Interesting. And it matches the day-after surges she sees in likes.

By the way, her Instagram, Twitter, and Facebook joins were each over 5,000 this morning (according to Ray4AJ). These are the highest one-day counts ever.