A/b Test analysis
budsimpson
ABTestAnalysis-ClassmateExample.xlsxGeneral View rate
| Campaign report | ||||||
| All time | ||||||
| Campaign status | Campaign | Impr. | views | Non - views | Interaction rate | Cost |
| Completed | funnel analysis voice | 58,921 | 2,775 | 56,146 | 4.710% | $ 22.73 |
| Completed | Funnel with voice and music | 58,313 | 2,719 | 55,594 | 4.663% | $ 22.64 |
| Total | Total | 117,234 | 5,494 | 4.686% | $ 45.36 | |
| In general, both campaigns had an interaction rate between 4.5% and 5%. It was very low, so as a professional marketer if it was a real campaign I should revise the content and analyze why the result was not successful. In this particular case, I was expecting to have a better result in the video with music over the "just voice" one, but the analysis said that the music did not impact in a positive way the video. | ||||||
| The Chi-Square Calculator helps me understanding by using statistics if I can decide which campaign is better observing the view rate. In this case, the result was "not significant", so I can't decide between both campaigns using just the view rate. | ||||||
Interaction Rate
In stream Chi-square
| Ad group report | |||||||
| All time | |||||||
| Ad group status | Ad group | View rate | Views | Not Viewed | Ad group type | Impr. | Cost |
| Enabled | Video with voice in stream | 61.76% | 1,161 | 719 | In-stream | 1,880 | 7 |
| Enabled | Funnel with voice and music in stream | 63.87% | 1,011 | 572 | In-stream | 1,583 | 6 |
| The Chi-Square Calculator helps me understanding by using statistics if I can decide which campaign is better observing the view rate. In this case, the result was "not significant", so I can't decide between both campaigns using just the view rate. | |||||||
Age Voice and video
| Age report | |||||||||
| All time | |||||||||
| Demographic status | Age | View rate | Ad group | Views | Impr. | highest view rate | |||
| Enabled | 18 - 24 | 2.19% | Voice and music discovery | 82 | 3,751 | ||||
| Enabled | 25 - 34 | 2.81% | Voice and music discovery | 302 | 10,736 | ||||
| Enabled | 35 - 44 | 3.04% | Voice and music discovery | 413 | 13,570 | ||||
| Enabled | 45 - 54 | 2.62% | Voice and music discovery | 187 | 7,140 | Lowest view rate | |||
| Enabled | 55 - 64 | 3.61% | Voice and music discovery | 243 | 6,740 | ||||
| Enabled | 65+ | 3.92% | Voice and music discovery | 267 | 6,804 | ||||
| Enabled | Unknown | 2.53% | Voice and music discovery | 202 | 7,972 | ||||
| Enabled | 18 - 24 | 71.67% | Funnel with voice and music in stream | 86 | 120 | ||||
| Enabled | 25 - 34 | 72.63% | Funnel with voice and music in stream | 69 | 95 | ||||
| Enabled | 35 - 44 | 70.00% | Funnel with voice and music in stream | 77 | 110 | ||||
| Enabled | 45 - 54 | 65.22% | Funnel with voice and music in stream | 45 | 69 | ||||
| Enabled | 55 - 64 | 62.96% | Funnel with voice and music in stream | 34 | 54 | ||||
| Enabled | 65+ | 56.82% | Funnel with voice and music in stream | 50 | 88 | ||||
| Enabled | Unknown | 62.28% | Funnel with voice and music in stream | 662 | 1,063 | ||||
| Percentage | |||||||||
| Percentage | |||||||||
Device Voice and Music
| Device report | |||||
| All time | |||||
| Device | View rate | Campaign | Impr. | Views | Cost |
| Mobile phones | 4.08% | Funnel with voice and music | 44,616 | 1,820 | 16 |
| Computers | 75.34% | Funnel with voice and music | 373 | 281 | 1 |
| Tablets | 4.56% | Funnel with voice and music | 13,300 | 606 | 6 |
| Percentage | |||||
Voice and Music Gender
| Gender report | ||||||
| All time | ||||||
| Demographic status | Gender | View rate | Ad group | Views | Impr. | Cost |
| Enabled | Female | 3.18% | Voice and music discovery | 769 | 24,200 | 8 |
| Enabled | Unknown | 2.51% | Voice and music discovery | 161 | 6,417 | 2 |
| Enabled | Male | 2.94% | Voice and music discovery | 766 | 26,096 | 8 |
| Enabled | Male | 71.33% | Funnel with voice and music in stream | 214 | 300 | 1 |
| Enabled | Female | 63.74% | Funnel with voice and music in stream | 174 | 273 | 1 |
| Enabled | Unknown | 61.89% | Funnel with voice and music in stream | 635 | 1,026 | 3 |
| Percentage | ||||||
| Percentage | ||||||
Housheld income Voice and video
| Household income report | ||||||
| All time | ||||||
| Demographic status | Household income | View rate | Ad group | Views | Impr. | Cost |
| Enabled | 11 - 20% | 66.67% | Funnel with voice and music in stream | 2 | 3 | 0 |
| Enabled | 41 - 50% | 57.14% | Funnel with voice and music in stream | 4 | 7 | 0 |
| Enabled | Lower 50% | 60.98% | Funnel with voice and music in stream | 25 | 41 | 0 |
| Enabled | 21 - 30% | 100.00% | Funnel with voice and music in stream | 3 | 3 | 0 |
| Enabled | Unknown | 63.82% | Funnel with voice and music in stream | 979 | 1,534 | 5 |
| Enabled | 31 - 40% | 75.00% | Funnel with voice and music in stream | 3 | 4 | 0 |
| Enabled | Top 10% | 100.00% | Funnel with voice and music in stream | 7 | 7 | 0 |
| Enabled | Lower 50% | 2.78% | Voice and music discovery | 70 | 2,516 | 1 |
| Enabled | 41 - 50% | 2.50% | Voice and music discovery | 8 | 320 | 0 |
| Enabled | Unknown | 3.00% | Voice and music discovery | 1,576 | 52,605 | 16 |
| Enabled | 11 - 20% | 3.88% | Voice and music discovery | 9 | 232 | 0 |
| Enabled | Top 10% | 3.23% | Voice and music discovery | 13 | 403 | 0 |
| Enabled | 31 - 40% | 3.74% | Voice and music discovery | 12 | 321 | 0 |
| Enabled | 21 - 30% | 2.53% | Voice and music discovery | 8 | 316 | 0 |
| Percentage | ||||||
| Percentage | ||||||
Parental Voice and Video
| Parental status report | ||||||
| All time | ||||||
| Demographic status | Parental status | View rate | Ad group | Views | Impr. | Cost |
| Enabled | Parent | 3.32% | Voice and music discovery | 579 | 17,442 | 6 |
| Enabled | Not a parent | 2.94% | Voice and music discovery | 872 | 29,616 | 9 |
| Enabled | Unknown | 2.54% | Voice and music discovery | 245 | 9,655 | 2 |
| Enabled | Parent | 67.72% | Funnel with voice and music in stream | 107 | 158 | 1 |
| Enabled | Not a parent | 67.32% | Funnel with voice and music in stream | 241 | 358 | 2 |
| Enabled | Unknown | 62.33% | Funnel with voice and music in stream | 675 | 1,083 | 3 |
| Percentage | ||||||
| Percentage | ||||||
Voice and video Audience Retent
| Percentege by minute and second | |
Voice and music Day and hour
| Day of the week | Hour of the day | Campaign | Impr. | Interactions | Interaction rate | |||||
| Friday | 21 | Funnel with voice and music | 558 | 148 | 26.52% | Average rate Friday | Day | Imteraction Rate | ||
| Friday | 3 | Funnel with voice and music | 26 | 4 | 15.38% | 4.43% | Thursday | 3.370% | ||
| Friday | 7 | Funnel with voice and music | 30 | 3 | 10.00% | Friday | 4.430% | |||
| Friday | 12 | Funnel with voice and music | 75 | 3 | 4.00% | Saturday | 13.840% | |||
| Friday | 4 | Funnel with voice and music | 25 | 1 | 4.00% | Sunday | 3.910% | |||
| Friday | 5 | Funnel with voice and music | 27 | 1 | 3.70% | |||||
| Friday | 20 | Funnel with voice and music | 1,110 | 41 | 3.69% | |||||
| Friday | 6 | Funnel with voice and music | 29 | 1 | 3.45% | |||||
| Friday | 19 | Funnel with voice and music | 1,318 | 44 | 3.34% | |||||
| Friday | 11 | Funnel with voice and music | 61 | 2 | 3.28% | |||||
| Friday | 17 | Funnel with voice and music | 7,793 | 256 | 3.28% | |||||
| Friday | 15 | Funnel with voice and music | 6,242 | 202 | 3.24% | |||||
| Friday | 16 | Funnel with voice and music | 13,304 | 417 | 3.13% | |||||
| Friday | 18 | Funnel with voice and music | 4,831 | 148 | 3.06% | |||||
| Friday | 9 | Funnel with voice and music | 34 | 1 | 2.94% | |||||
| Friday | 13 | Funnel with voice and music | 88 | 2 | 2.27% | |||||
| Friday | 14 | Funnel with voice and music | 232 | 5 | 2.16% | |||||
| Friday | 2 | Funnel with voice and music | 26 | 0 | 0.00% | |||||
| Friday | 1 | Funnel with voice and music | 19 | 0 | 0.00% | |||||
| Friday | 0 | Funnel with voice and music | 12 | 0 | 0.00% | |||||
| Friday | 8 | Funnel with voice and music | 35 | 0 | 0.00% | |||||
| Friday | 10 | Funnel with voice and music | 39 | 0 | 0.00% | |||||
| Day of the week | Hour of the day | Campaign | Impr. | Interactions | Interaction rate | Average rate Saturday | ||||
| Saturday | 0 | Funnel with voice and music | 209 | 75 | 35.89% | 13.48% | ||||
| Saturday | 23 | Funnel with voice and music | 136 | 23 | 16.91% | |||||
| Saturday | 21 | Funnel with voice and music | 311 | 51 | 16.40% | |||||
| Saturday | 11 | Funnel with voice and music | 421 | 67 | 15.91% | |||||
| Saturday | 13 | Funnel with voice and music | 515 | 81 | 15.73% | |||||
| Saturday | 2 | Funnel with voice and music | 122 | 19 | 15.57% | |||||
| Saturday | 8 | Funnel with voice and music | 122 | 19 | 15.57% | |||||
| Saturday | 7 | Funnel with voice and music | 108 | 16 | 14.81% | |||||
| Saturday | 14 | Funnel with voice and music | 463 | 67 | 14.47% | |||||
| Saturday | 6 | Funnel with voice and music | 84 | 12 | 14.29% | |||||
| Saturday | 9 | Funnel with voice and music | 196 | 28 | 14.29% | |||||
| Saturday | 1 | Funnel with voice and music | 147 | 21 | 14.29% | |||||
| Saturday | 10 | Funnel with voice and music | 347 | 49 | 14.12% | |||||
| Saturday | 4 | Funnel with voice and music | 83 | 11 | 13.25% | |||||
| Saturday | 3 | Funnel with voice and music | 83 | 10 | 12.05% | |||||
| Saturday | 22 | Funnel with voice and music | 280 | 30 | 10.71% | |||||
| Saturday | 12 | Funnel with voice and music | 389 | 38 | 9.77% | |||||
| Saturday | 15 | Funnel with voice and music | 659 | 64 | 9.71% | |||||
| Saturday | 16 | Funnel with voice and music | 740 | 70 | 9.46% | |||||
| Saturday | 5 | Funnel with voice and music | 96 | 9 | 9.38% | |||||
| Saturday | 18 | Funnel with voice and music | 428 | 40 | 9.35% | |||||
| Saturday | 20 | Funnel with voice and music | 412 | 38 | 9.22% | |||||
| Saturday | 17 | Funnel with voice and music | 455 | 32 | 7.03% | |||||
| Saturday | 19 | Funnel with voice and music | 857 | 45 | 5.25% | |||||
| Day of the week | Hour of the day | Campaign | Impr. | Interactions | Interaction rate | Average rate Sunday | ||||
| Sunday | 0 | Funnel with voice and music | 225 | 18 | 8.00% | 3.91% | ||||
| Sunday | 4 | Funnel with voice and music | 420 | 27 | 6.43% | |||||
| Sunday | 1 | Funnel with voice and music | 376 | 22 | 5.85% | |||||
| Sunday | 18 | Funnel with voice and music | 789 | 33 | 4.18% | |||||
| Sunday | 6 | Funnel with voice and music | 222 | 9 | 4.05% | |||||
| Sunday | 9 | Funnel with voice and music | 551 | 22 | 3.99% | |||||
| Sunday | 3 | Funnel with voice and music | 753 | 30 | 3.98% | |||||
| Sunday | 14 | Funnel with voice and music | 930 | 37 | 3.98% | |||||
| Sunday | 10 | Funnel with voice and music | 547 | 21 | 3.84% | |||||
| Sunday | 7 | Funnel with voice and music | 469 | 18 | 3.84% | |||||
| Sunday | 11 | Funnel with voice and music | 654 | 22 | 3.36% | |||||
| Sunday | 8 | Funnel with voice and music | 842 | 28 | 3.33% | |||||
| Sunday | 13 | Funnel with voice and music | 981 | 32 | 3.26% | |||||
| Sunday | 12 | Funnel with voice and music | 957 | 29 | 3.03% | |||||
| Sunday | 16 | Funnel with voice and music | 1,487 | 44 | 2.96% | |||||
| Sunday | 2 | Funnel with voice and music | 637 | 18 | 2.83% | |||||
| Sunday | 17 | Funnel with voice and music | 1,412 | 38 | 2.69% | |||||
| Sunday | 15 | Funnel with voice and music | 1,589 | 42 | 2.64% | |||||
| Sunday | 5 | Funnel with voice and music | 254 | 5 | 1.97% | |||||
| Day of the week | Hour of the day | Campaign | Impr. | Interactions | Interaction rate | Average Rate Thursday | ||||
| Thursday | 23 | Funnel with voice and music | 330 | 14 | 4.24% | 3.37% | ||||
| Thursday | 22 | Funnel with voice and music | 65 | 2 | 3.08% | |||||
| Thursday | 21 | Funnel with voice and music | 72 | 2 | 2.78% | |||||
Age Voice
| Age report | ||||||||||
| All time | ||||||||||
| Demographic status | Age | View rate | Ad group | Views | Impr. | Cost | highest view rate | |||
| Enabled | 18 - 24 | 80.84% | Video with voice in stream | 135 | 167 | $ 0.52 | ||||
| Enabled | 25 - 34 | 78.76% | Video with voice in stream | 89 | 113 | $ 0.46 | ||||
| Enabled | 35 - 44 | 69.85% | Video with voice in stream | 95 | 136 | $ 0.67 | ||||
| Enabled | 45 - 54 | 70.24% | Video with voice in stream | 59 | 84 | $ 0.45 | Lowest view rate | |||
| Enabled | 55 - 64 | 67.06% | Video with voice in stream | 57 | 85 | $ 0.51 | ||||
| Enabled | 65+ | 63.79% | Video with voice in stream | 74 | 116 | $ 0.67 | ||||
| Enabled | Unknown | 55.87% | Video with voice in stream | 681 | 1,219 | $ 3.59 | ||||
| Enabled | 18 - 24 | 2.41% | Discovery video voice | 114 | 4,735 | $ 1.14 | ||||
| Enabled | 25 - 34 | 3.02% | Discovery video voice | 334 | 11,049 | $ 3.34 | ||||
| Enabled | 35 - 44 | 2.71% | Discovery video voice | 344 | 12,686 | $ 3.44 | ||||
| Enabled | 45 - 54 | 2.75% | Discovery video voice | 169 | 6,139 | $ 1.69 | ||||
| Enabled | 55 - 64 | 3.12% | Discovery video voice | 190 | 6,084 | $ 1.90 | ||||
| Enabled | 65+ | 3.52% | Discovery video voice | 236 | 6,703 | $ 2.36 | ||||
| Enabled | Unknown | 2.06% | Discovery video voice | 198 | 9,605 | $ 1.98 | ||||
| Percentage | ||||||||||
| Percentage | ||||||||||
Device Voice
| Device report | ||||||
| All time | ||||||
| Device | View rate | Level | Campaign | Impr. | Views | Cost |
| Mobile phones | 4.20% | Campaign | funnel analysis voice | 38,407 | 1,614 | 14 |
| Computers | 75.48% | Campaign | funnel analysis voice | 416 | 314 | 1 |
| Tablets | 4.14% | Campaign | funnel analysis voice | 20,081 | 831 | 8 |
| Percentage | ||||||
Voice Day and hour
| All time | Day | Interaction rate | ||||||||
| Day of the week | Hour of the day | Campaign | Impr. | Interactions | Interaction rate | Average Rate Friday | Thursday | 3% | ||
| Friday | 21 | funnel analysis voice | 942 | 263 | 27.92% | 4.11% | Friday | 4% | ||
| Friday | 4 | funnel analysis voice | 182 | 10 | 5.49% | Saturday | 20% | |||
| Friday | 10 | funnel analysis voice | 173 | 8 | 4.62% | Sunday | 4% | |||
| Friday | 14 | funnel analysis voice | 478 | 22 | 4.60% | |||||
| Friday | 3 | funnel analysis voice | 201 | 8 | 3.98% | |||||
| Friday | 16 | funnel analysis voice | 9,408 | 313 | 3.33% | |||||
| Friday | 1 | funnel analysis voice | 97 | 3 | 3.09% | |||||
| Friday | 6 | funnel analysis voice | 162 | 5 | 3.09% | |||||
| Friday | 18 | funnel analysis voice | 4,680 | 135 | 2.88% | |||||
| Friday | 20 | funnel analysis voice | 1,266 | 36 | 2.84% | |||||
| Friday | 15 | funnel analysis voice | 7,312 | 202 | 2.76% | |||||
| Friday | 17 | funnel analysis voice | 6,641 | 179 | 2.70% | |||||
| Friday | 12 | funnel analysis voice | 293 | 7 | 2.39% | |||||
| Friday | 13 | funnel analysis voice | 341 | 8 | 2.35% | |||||
| Friday | 19 | funnel analysis voice | 1,418 | 31 | 2.19% | |||||
| Friday | 11 | funnel analysis voice | 228 | 5 | 2.19% | |||||
| Friday | 9 | funnel analysis voice | 147 | 3 | 2.04% | |||||
| Friday | 5 | funnel analysis voice | 251 | 5 | 1.99% | |||||
| Friday | 8 | funnel analysis voice | 132 | 2 | 1.52% | |||||
| Friday | 2 | funnel analysis voice | 162 | 2 | 1.23% | |||||
| Friday | 0 | funnel analysis voice | 78 | 0 | 0.00% | |||||
| Friday | 7 | funnel analysis voice | 119 | 0 | 0.00% | |||||
| Friday | 21 | Funnel with voice and music | 558 | 148 | 26.52% | |||||
| Friday | 3 | Funnel with voice and music | 26 | 4 | 15.38% | |||||
| Friday | 7 | Funnel with voice and music | 30 | 3 | 10.00% | |||||
| Friday | 12 | Funnel with voice and music | 75 | 3 | 4.00% | |||||
| Friday | 4 | Funnel with voice and music | 25 | 1 | 4.00% | |||||
| Friday | 5 | Funnel with voice and music | 27 | 1 | 3.70% | |||||
| Friday | 20 | Funnel with voice and music | 1,110 | 41 | 3.69% | |||||
| Friday | 6 | Funnel with voice and music | 29 | 1 | 3.45% | |||||
| Friday | 19 | Funnel with voice and music | 1,318 | 44 | 3.34% | |||||
| Friday | 11 | Funnel with voice and music | 61 | 2 | 3.28% | |||||
| Friday | 17 | Funnel with voice and music | 7,793 | 256 | 3.28% | |||||
| Friday | 15 | Funnel with voice and music | 6,242 | 202 | 3.24% | |||||
| Friday | 16 | Funnel with voice and music | 13,304 | 417 | 3.13% | |||||
| Friday | 18 | Funnel with voice and music | 4,831 | 148 | 3.06% | |||||
| Friday | 9 | Funnel with voice and music | 34 | 1 | 2.94% | |||||
| Friday | 13 | Funnel with voice and music | 88 | 2 | 2.27% | |||||
| Friday | 14 | Funnel with voice and music | 232 | 5 | 2.16% | |||||
| Friday | 2 | Funnel with voice and music | 26 | 0 | 0.00% | |||||
| Friday | 1 | Funnel with voice and music | 19 | 0 | 0.00% | |||||
| Friday | 0 | Funnel with voice and music | 12 | 0 | 0.00% | |||||
| Friday | 8 | Funnel with voice and music | 35 | 0 | 0.00% | |||||
| Friday | 10 | Funnel with voice and music | 39 | 0 | 0.00% | |||||
| Day of the week | Hour of the day | Campaign | Impr. | Interactions | Interaction rate | Average Rate Saturday | ||||
| Saturday | 4 | funnel analysis voice | 9 | 5 | 55.56% | 19.55% | ||||
| Saturday | 19 | funnel analysis voice | 84 | 39 | 46.43% | |||||
| Saturday | 6 | funnel analysis voice | 5 | 2 | 40.00% | |||||
| Saturday | 2 | funnel analysis voice | 55 | 20 | 36.36% | |||||
| Saturday | 18 | funnel analysis voice | 122 | 43 | 35.25% | |||||
| Saturday | 1 | funnel analysis voice | 123 | 42 | 34.15% | |||||
| Saturday | 0 | funnel analysis voice | 357 | 121 | 33.89% | |||||
| Saturday | 3 | funnel analysis voice | 18 | 6 | 33.33% | |||||
| Saturday | 5 | funnel analysis voice | 3 | 1 | 33.33% | |||||
| Saturday | 9 | funnel analysis voice | 27 | 8 | 29.63% | |||||
| Saturday | 10 | funnel analysis voice | 72 | 19 | 26.39% | |||||
| Saturday | 11 | funnel analysis voice | 100 | 26 | 26.00% | |||||
| Saturday | 21 | funnel analysis voice | 273 | 63 | 23.08% | |||||
| Saturday | 7 | funnel analysis voice | 5 | 1 | 20.00% | |||||
| Saturday | 12 | funnel analysis voice | 244 | 47 | 19.26% | |||||
| Saturday | 13 | funnel analysis voice | 457 | 86 | 18.82% | |||||
| Saturday | 22 | funnel analysis voice | 127 | 20 | 15.75% | |||||
| Saturday | 14 | funnel analysis voice | 485 | 76 | 15.67% | |||||
| Saturday | 20 | funnel analysis voice | 291 | 43 | 14.78% | |||||
| Saturday | 17 | funnel analysis voice | 241 | 32 | 13.28% | |||||
| Saturday | 23 | funnel analysis voice | 81 | 10 | 12.35% | |||||
| Saturday | 16 | funnel analysis voice | 464 | 55 | 11.85% | |||||
| Saturday | 15 | funnel analysis voice | 439 | 46 | 10.48% | |||||
| Saturday | 8 | funnel analysis voice | 11 | 1 | 9.09% | |||||
| Saturday | 0 | Funnel with voice and music | 209 | 75 | 35.89% | |||||
| Saturday | 23 | Funnel with voice and music | 136 | 23 | 16.91% | |||||
| Saturday | 21 | Funnel with voice and music | 311 | 51 | 16.40% | |||||
| Saturday | 11 | Funnel with voice and music | 421 | 67 | 15.91% | |||||
| Saturday | 13 | Funnel with voice and music | 515 | 81 | 15.73% | |||||
| Saturday | 2 | Funnel with voice and music | 122 | 19 | 15.57% | |||||
| Saturday | 8 | Funnel with voice and music | 122 | 19 | 15.57% | |||||
| Saturday | 7 | Funnel with voice and music | 108 | 16 | 14.81% | |||||
| Saturday | 14 | Funnel with voice and music | 463 | 67 | 14.47% | |||||
| Saturday | 6 | Funnel with voice and music | 84 | 12 | 14.29% | |||||
| Saturday | 9 | Funnel with voice and music | 196 | 28 | 14.29% | |||||
| Saturday | 1 | Funnel with voice and music | 147 | 21 | 14.29% | |||||
| Saturday | 10 | Funnel with voice and music | 347 | 49 | 14.12% | |||||
| Saturday | 4 | Funnel with voice and music | 83 | 11 | 13.25% | |||||
| Saturday | 3 | Funnel with voice and music | 83 | 10 | 12.05% | |||||
| Saturday | 22 | Funnel with voice and music | 280 | 30 | 10.71% | |||||
| Saturday | 12 | Funnel with voice and music | 389 | 38 | 9.77% | |||||
| Saturday | 15 | Funnel with voice and music | 659 | 64 | 9.71% | |||||
| Saturday | 16 | Funnel with voice and music | 740 | 70 | 9.46% | |||||
| Saturday | 5 | Funnel with voice and music | 96 | 9 | 9.38% | |||||
| Saturday | 18 | Funnel with voice and music | 428 | 40 | 9.35% | |||||
| Saturday | 20 | Funnel with voice and music | 412 | 38 | 9.22% | |||||
| Saturday | 17 | Funnel with voice and music | 455 | 32 | 7.03% | |||||
| Saturday | 19 | Funnel with voice and music | 857 | 45 | 5.25% | |||||
| Day of the week | Hour of the day | Campaign | Impr. | Interactions | Interaction rate | Average Rate Sunday | ||||
| Sunday | 1 | funnel analysis voice | 442 | 32 | 7.24% | 3.99% | ||||
| Sunday | 0 | funnel analysis voice | 154 | 11 | 7.14% | |||||
| Sunday | 6 | funnel analysis voice | 363 | 20 | 5.51% | |||||
| Sunday | 5 | funnel analysis voice | 469 | 23 | 4.90% | |||||
| Sunday | 4 | funnel analysis voice | 641 | 30 | 4.68% | |||||
| Sunday | 8 | funnel analysis voice | 238 | 11 | 4.62% | |||||
| Sunday | 15 | funnel analysis voice | 574 | 25 | 4.36% | |||||
| Sunday | 10 | funnel analysis voice | 2,399 | 99 | 4.13% | |||||
| Sunday | 7 | funnel analysis voice | 222 | 9 | 4.05% | |||||
| Sunday | 2 | funnel analysis voice | 687 | 27 | 3.93% | |||||
| Sunday | 3 | funnel analysis voice | 918 | 36 | 3.92% | |||||
| Sunday | 12 | funnel analysis voice | 511 | 20 | 3.91% | |||||
| Sunday | 9 | funnel analysis voice | 1,997 | 76 | 3.81% | |||||
| Sunday | 11 | funnel analysis voice | 1,014 | 37 | 3.65% | |||||
| Sunday | 13 | funnel analysis voice | 330 | 12 | 3.64% | |||||
| Sunday | 18 | funnel analysis voice | 910 | 30 | 3.30% | |||||
| Sunday | 14 | funnel analysis voice | 387 | 12 | 3.10% | |||||
| Sunday | 17 | funnel analysis voice | 1,023 | 29 | 2.83% | |||||
| Sunday | 16 | funnel analysis voice | 802 | 22 | 2.74% | |||||
| Sunday | 19 | funnel analysis voice | 2 | 0 | 0.00% | |||||
| Sunday | 0 | Funnel with voice and music | 225 | 18 | 8.00% | |||||
| Sunday | 4 | Funnel with voice and music | 420 | 27 | 6.43% | |||||
| Sunday | 1 | Funnel with voice and music | 376 | 22 | 5.85% | |||||
| Sunday | 18 | Funnel with voice and music | 789 | 33 | 4.18% | |||||
| Sunday | 6 | Funnel with voice and music | 222 | 9 | 4.05% | |||||
| Sunday | 9 | Funnel with voice and music | 551 | 22 | 3.99% | |||||
| Sunday | 3 | Funnel with voice and music | 753 | 30 | 3.98% | |||||
| Sunday | 14 | Funnel with voice and music | 930 | 37 | 3.98% | |||||
| Sunday | 10 | Funnel with voice and music | 547 | 21 | 3.84% | |||||
| Sunday | 7 | Funnel with voice and music | 469 | 18 | 3.84% | |||||
| Sunday | 11 | Funnel with voice and music | 654 | 22 | 3.36% | |||||
| Sunday | 8 | Funnel with voice and music | 842 | 28 | 3.33% | |||||
| Sunday | 13 | Funnel with voice and music | 981 | 32 | 3.26% | |||||
| Sunday | 12 | Funnel with voice and music | 957 | 29 | 3.03% | |||||
| Sunday | 16 | Funnel with voice and music | 1,487 | 44 | 2.96% | |||||
| Sunday | 2 | Funnel with voice and music | 637 | 18 | 2.83% | |||||
| Sunday | 17 | Funnel with voice and music | 1,412 | 38 | 2.69% | |||||
| Sunday | 15 | Funnel with voice and music | 1,589 | 42 | 2.64% | |||||
| Sunday | 5 | Funnel with voice and music | 254 | 5 | 1.97% | |||||
| Day of the week | Hour of the day | Campaign | Impr. | Interactions | Interaction rate | Average rate Thursday | ||||
| Thursday | 23 | funnel analysis voice | 4,460 | 100 | 2.24% | 2.66% | ||||
| Thursday | 22 | funnel analysis voice | 1,024 | 22 | 2.15% | |||||
| Thursday | 21 | funnel analysis voice | 268 | 4 | 1.49% | |||||
| Thursday | 23 | Funnel with voice and music | 330 | 14 | 4.24% | |||||
| Thursday | 22 | Funnel with voice and music | 65 | 2 | 3.08% | |||||
| Thursday | 21 | Funnel with voice and music | 72 | 2 | 2.78% | |||||
Gender Voice
| Gender report | ||||||
| All time | ||||||
| Demographic status | Gender | View rate | Ad group | Views | Impr. | Cost |
| Enabled | Male | 76.17% | Video with voice in stream | 294 | 386 | 2 |
| Enabled | Female | 67.67% | Video with voice in stream | 247 | 365 | 2 |
| Enabled | Unknown | 55.52% | Video with voice in stream | 649 | 1,169 | 3 |
| Enabled | Male | 2.64% | Discovery video voice | 636 | 24,070 | 6 |
| Enabled | Female | 3.08% | Discovery video voice | 805 | 26,134 | 8 |
| Enabled | Unknown | 2.12% | Discovery video voice | 144 | 6,797 | 1 |
| Percentage | ||||||
| Percentage | ||||||
Househeld income
| Household income report | ||||||
| All time | ||||||
| Demographic status | Household income | View rate | Ad group | Views | Impr. | Cost |
| Enabled | 21 - 30% | 78.57% | Video with voice in stream | 11 | 14 | 0 |
| Enabled | 11 - 20% | 42.86% | Video with voice in stream | 3 | 7 | 0 |
| Enabled | Top 10% | 84.62% | Video with voice in stream | 11 | 13 | 0 |
| Enabled | Lower 50% | 62.50% | Video with voice in stream | 35 | 56 | 0 |
| Enabled | 41 - 50% | 75.00% | Video with voice in stream | 6 | 8 | 0 |
| Enabled | Unknown | 61.44% | Video with voice in stream | 1,112 | 1,810 | 6 |
| Enabled | 31 - 40% | 100.00% | Video with voice in stream | 12 | 12 | 0 |
| Enabled | 21 - 30% | 3.35% | Discovery video voice | 17 | 507 | 0 |
| Enabled | 41 - 50% | 2.49% | Discovery video voice | 13 | 522 | 0 |
| Enabled | Top 10% | 3.05% | Discovery video voice | 20 | 655 | 0 |
| Enabled | Unknown | 2.73% | Discovery video voice | 1,372 | 50,341 | 14 |
| Enabled | Lower 50% | 3.45% | Discovery video voice | 138 | 4,003 | 1 |
| Enabled | 31 - 40% | 2.80% | Discovery video voice | 16 | 571 | 0 |
| Enabled | 11 - 20% | 2.24% | Discovery video voice | 9 | 402 | 0 |
| Percentage | ||||||
| Percentage | ||||||
Voice Parental
| Parental status report | ||||||
| All time | ||||||
| Demographic status | Parental status | View rate | Ad group | Views | Impr. | Cost |
| Enabled | Parent | 67.96% | Video with voice in stream | 140 | 206 | 1 |
| Enabled | Not a parent | 72.60% | Video with voice in stream | 363 | 500 | 2 |
| Enabled | Unknown | 56.59% | Video with voice in stream | 687 | 1,214 | 3 |
| Enabled | Parent | 3.11% | Discovery video voice | 615 | 19,795 | 6 |
| Enabled | Not a parent | 2.70% | Discovery video voice | 724 | 26,801 | 7 |
| Enabled | Unknown | 2.36% | Discovery video voice | 246 | 10,405 | 2 |
| Percentage | ||||||
| Percentage | ||||||
Voice Audience Retention
| Percentege by minute and second | |||
Youtube Analytics
Youtube
| Video | video length | Views | Likes | Average view duration (in minutes and seconds) | Average percentage viewed | Watch time Minutes |
| Voice | 3:48 | 2,041 | 80% | 0:50 | 21.930% | 1711.00 |
| Voice and video | 3:55 | 2,063 | 66.7% | 0:59 | 25.106% | 2033.00 |
| Voice and Music | ||||||
| Voice | ||||||
| Voice | Voice and video | |||||
| After analyzing the Absolute Audience Retention graph and chart, I can see that the content was not enough engaging to keep the audience more than one minute, that in my case was about 25.9% in the voice video and 21.4% in the voice and music video. As we learned in class, it is very important to create a very engaging and relevant content in the first 5 seconds and try to keep it that way in the rest of the video. | ||||||
5. Report
To make this report, I used all the tools offered by google analytics and youtube analytics to identify how a campaign did over the other one. I made several charts and graphics to facilitate the understanding of the data I collected. Following I will write about the four main differences that I found across the two videos: 1. The audience retention was very close, I was expecting to have more retention with the voice and music video, that I can realize that because of the content was almost the same I just got a better retention with voice and music but the difference was not huge. 2. In the parental status, I saw the "parents" were more interested in the voice and music video. On the other hand, in just the "voice" video it was not that clear. 3. The age analysis was one of the most interesting aspects of the paper. In the voice video, discovery videos the most interested group was people 65+ and fewer interest people from 18 to 24. In-stream, it was the opposite, less interested were the people 65+ and the most were the people from 25 to 34 years. Now, in the voice video; in the discovery campaign, the most interested were the young people and the less people 65+. In the Instream, most was 65+ and less 18 to 24. I can see the music caused a by impact in the category. 4. Devices: It was clear in both campaigns that computers were the most popular device. 5. In the gender analysis, I saw how in both discovery ads the male was more interested, but in both In-stream, female viewed more. 6. Saturday was the best day, more than 50% of the people viewed both campaigns on Saturday.
6. Learnings
I found this assignment extremely interesting. It opens a whole universe to advertise products from my industry in the future. The main skills I enhanced were: 1. Learn how to analyze and organize data from different sources regarding google ads campaigns. 2. To use data to predict with the first results the success or not of a campaign. 3. I got the skill to compare same content with small differences in the production to understand how the public reacts to changes. 4. Now that I got this knowledge, I'm ready to run a real campaign with the company I'm working to. I am preparing the audiovisual material to run it, targeting the Hispanic population in south Florida.
