As we launch on Etsy with our unique handmade African artworks, we’re diving into the vibrant Etsy ecosystem. Our goal is to understand trends and insights, shaping strategic decisions on product offerings and pricing strategies for success in this dynamic marketplace.
I utilized Octoparse for web scraping techniques to gather data from Etsy
Initiating the preparation phase for analysis by loading essential libraries, importing the required dataset, and executing data cleaning procedures.
Loading essential libraries needed for the analysis process
options(repos = c(CRAN = "https://cloud.r-project.org"))
library(tidyverse)
library(dplyr)
library(lubridate)
library(ggplot2)
library(plotly) #to make ggplot interactive
library(patchwork) #to add all plots into the same board
library(TTR) #to calculate moving avaerage
library(quantmod)
library(tidyquant)
library(zoo)
install.packages("wordcloud") #product description analysis
## package 'wordcloud' successfully unpacked and MD5 sums checked
##
## The downloaded binary packages are in
## C:\Users\hp\AppData\Local\Temp\RtmpUf9nFg\downloaded_packages
library(wordcloud)
install.packages("ggpubr")
## package 'ggpubr' successfully unpacked and MD5 sums checked
##
## The downloaded binary packages are in
## C:\Users\hp\AppData\Local\Temp\RtmpUf9nFg\downloaded_packages
library(ggpubr)
install.packages("corrplot")
## Error in download.file(url, destfile, method, mode = "wb", ...) :
## download from 'https://cloud.r-project.org/bin/windows/contrib/4.3/corrplot_0.92.zip' failed
library(corrplot)
install.packages("reshape2")
## Error in download.file(url, destfile, method, mode = "wb", ...) :
## cannot open URL 'https://cloud.r-project.org/bin/windows/contrib/4.3/reshape2_1.4.4.zip'
library(reshape2)
Load the CSV dataset into the working environment.
Etsy <- read.csv("AfricanArtEtsy.csv")
Exploring imported dataset
View(Etsy)
Reviewing the data: determining the number of rows and columns, as well as examining data types
glimpse(Etsy)
## Rows: 3,036
## Columns: 17
## $ Product_URL <chr> "https://www.etsy.com/listing/1094471127/bolga-fan-ass…
## $ Product_Name <chr> "Dog Collar broad - 51-54cm | Handmade Dog Collar | Af…
## $ Sell_price <chr> "39.10", "179.98", "44.90", "18.19", "5.38", "5.40", "…
## $ Details <chr> "Handmade", "Handmade", "Handmade", "Handmade", "Digit…
## $ Seller_name <chr> "AfricanCreativeCA", "OrionWallArtDecor", "ArteBellaWa…
## $ Dimensions <chr> "", "Width: 4 inches\nHeight: 20 inches", "", "", "", …
## $ Materials <chr> "elephant grass, natural dyes", "Wooden Wall Art, Hand…
## $ Description <chr> "Bolga Fans can add colour and texture to any room. Us…
## $ Shipping <chr> "Delivery cost: USD 30.00", "Free delivery", "Delivery…
## $ Shipsfrom <chr> "Canada", "Türkiye", "Türkiye", "United States", "", "…
## $ Store_Rating <dbl> 5.0, 4.0, NA, 5.0, 5.0, 4.5, 5.0, 5.0, 5.0, 5.0, 4.5, …
## $ Seller_location <chr> "Canada", "Türkiye", "", "", "", "Europe", "", "", "",…
## $ Totals_sales <chr> "394", "111", "", "", "477", "", "1680", "", "1680", "…
## $ listings <int> 92, 56, 19, 965, 73, 109, 167, 85, 167, 72, 113, 167, …
## $ Product_Rating <dbl> 4.8, 4.1, NA, 4.9, 4.9, 4.7, 4.9, 4.9, 4.9, 4.9, 4.7, …
## $ Description_len <int> 416, 914, 926, 1314, 2387, 1800, 952, 1100, 886, 947, …
## $ Reviews <chr> "102", "30", "", "340", "90", "126", "209", "128", "20…
Renaming Totals_sales to Total_sales and Sell_price to Price since this is an analysis to reflect current market values
Etsy <- Etsy %>%
rename(Total_sales = Totals_sales,
Price = Sell_price,
ArtType = Details)
Confirming that the column names have been updated
colnames(Etsy)
## [1] "Product_URL" "Product_Name" "Price" "ArtType"
## [5] "Seller_name" "Dimensions" "Materials" "Description"
## [9] "Shipping" "Shipsfrom" "Store_Rating" "Seller_location"
## [13] "Total_sales" "listings" "Product_Rating" "Description_len"
## [17] "Reviews"
After inspection, it was observed that the columns Sell_Price, Total_sales, Reviews, and Listings are interpreted as character data types instead of numeric. First, converting the columns Sell_Price, Total_sales, Reviews, and Listings to numeric.
Etsy <- Etsy %>%
mutate_at(vars(Price, Total_sales, Reviews, listings, Description_len), as.numeric)
Create groups based on the ‘description_len’ column.
Etsy <- Etsy %>%
mutate(description_group = cut(Description_len, breaks = c(0, 50, 100, 150, Inf),
labels = c("0-50", "51-100", "101-150", "151+"),
include.lowest = TRUE))
Checking for missing values
summary(is.na(Etsy))
## Product_URL Product_Name Price ArtType
## Mode :logical Mode :logical Mode :logical Mode :logical
## FALSE:3036 FALSE:3036 FALSE:2997 FALSE:3036
## TRUE :39
## Seller_name Dimensions Materials Description
## Mode :logical Mode :logical Mode :logical Mode :logical
## FALSE:3036 FALSE:3036 FALSE:3036 FALSE:3036
##
## Shipping Shipsfrom Store_Rating Seller_location
## Mode :logical Mode :logical Mode :logical Mode :logical
## FALSE:3036 FALSE:3036 FALSE:2767 FALSE:3036
## TRUE :269
## Total_sales listings Product_Rating Description_len
## Mode :logical Mode :logical Mode :logical Mode :logical
## FALSE:1412 FALSE:2940 FALSE:2938 FALSE:3036
## TRUE :1624 TRUE :96 TRUE :98
## Reviews description_group
## Mode :logical Mode :logical
## FALSE:2233 FALSE:3036
## TRUE :803
Replacing empty strings with NA across the entire data frame
Etsy <- apply(Etsy, 2, function(x) na_if(x, "")) %>%
as.data.frame()
Etsy$Total_sales <- as.numeric(Etsy$Total_sales)
Etsy$Price <- as.numeric(Etsy$Price)
Calculating estimated revenue and create a new column ‘es_revenue’
Etsy <- Etsy %>%
mutate(es_revenue = Total_sales * Price)
Changing data type of es_revenue column to numeric
Etsy <- Etsy %>%
mutate(es_revenue = as.numeric(es_revenue))
Observing data to determine the unique seller locations in the dataset
unique(Etsy$Seller_location)
## [1] "Canada" "Türkiye"
## [3] NA "Europe"
## [5] "United States" "Australia"
## [7] "France" "Spain"
## [9] "Portugal" "Germany"
## [11] "United Kingdom" "Luxembourg"
## [13] "The Netherlands" "Ukraine"
## [15] "South Africa" "Kenya"
## [17] "Morocco" "China"
## [19] "Thailand" "Philippines"
## [21] "Cameroon" "Israel"
## [23] "Brazil" "Bulgaria"
## [25] "India" "Malaysia"
## [27] "Greece" "Pakistan"
## [29] "North Carolina, United States" "Poland"
## [31] "Italy" "Czechia"
## [33] "Ireland" "Vietnam"
## [35] "Nigeria" "Malta"
## [37] "North America" "Ethiopia"
## [39] "Lithuania" "Latvia"
## [41] "Finland" "Belgium"
Replacing “North Carolina, United States” with “United States” in the Seller_location column
Etsy <- Etsy %>%
mutate(Seller_location = ifelse(grepl("North Carolina, United States", Seller_location),
"United States", Seller_location))
Confirming that the names have been updated
unique(Etsy$Seller_location)
## [1] "Canada" "Türkiye" NA "Europe"
## [5] "United States" "Australia" "France" "Spain"
## [9] "Portugal" "Germany" "United Kingdom" "Luxembourg"
## [13] "The Netherlands" "Ukraine" "South Africa" "Kenya"
## [17] "Morocco" "China" "Thailand" "Philippines"
## [21] "Cameroon" "Israel" "Brazil" "Bulgaria"
## [25] "India" "Malaysia" "Greece" "Pakistan"
## [29] "Poland" "Italy" "Czechia" "Ireland"
## [33] "Vietnam" "Nigeria" "Malta" "North America"
## [37] "Ethiopia" "Lithuania" "Latvia" "Finland"
## [41] "Belgium"
Basic Summary Statistics of specific columns
summary(Etsy[, c("Price", "Total_sales", "Reviews", "listings", "es_revenue")])
## Price Total_sales Reviews listings
## Min. : 0.68 Min. : 2 Length:3036 Length:3036
## 1st Qu.: 9.99 1st Qu.: 193 Class :character Class :character
## Median : 23.63 Median : 642 Mode :character Mode :character
## Mean : 50.90 Mean : 5620
## 3rd Qu.: 51.20 3rd Qu.: 2755
## Max. :936.54 Max. :1051593
## NA's :39 NA's :1624
## es_revenue
## Min. : 16
## 1st Qu.: 2430
## Median : 18761
## Mean : 144698
## 3rd Qu.: 96287
## Max. :8044686
## NA's :1645
The summary reveals that: * Price: the lowest is 0.68, the highest is 936.54, and the average is 50.90., This indicates that if the listing price is $51.20, it’s already higher than 75% of the sample listing prices. However, selling handmade art products doesn’t necessarily justify excessively high prices. * Estimated revenue: the average is $114,698. * Listings: 25% of the sample listings are at 103.0.
Fit a simple linear regression model
model <- lm(Total_sales ~ listings, data = Etsy)
Summarize the model
summary(model)
##
## Call:
## lm(formula = Total_sales ~ listings, data = Etsy)
##
## Residuals:
## Min 1Q Median 3Q Max
## -25276.5 -0.4 0.0 6.5 18491.3
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 40.60 818.89 0.050 0.960467
## listings 3 -34.60 1158.08 -0.030 0.976171
## listings 4 10.10 1002.93 0.010 0.991967
## listings 5 69.07 1337.24 0.052 0.958818
## listings 8 126.73 1337.24 0.095 0.924513
## listings 9 -4.20 1158.08 -0.004 0.997107
## listings 10 14.40 2005.85 0.007 0.994273
## listings 11 3.90 1228.33 0.003 0.997467
## listings 12 117.65 1228.33 0.096 0.923713
## listings 13 66.90 1532.00 0.044 0.965177
## listings 14 -30.60 2005.85 -0.015 0.987831
## listings 15 619.73 1337.24 0.463 0.643140
## listings 16 22.40 1337.24 0.017 0.986638
## listings 17 -16.60 1532.00 -0.011 0.991357
## listings 18 660.85 987.61 0.669 0.503547
## listings 19 -36.60 2005.85 -0.018 0.985445
## listings 20 564.77 1043.88 0.541 0.588595
## listings 21 30.40 1532.00 0.020 0.984172
## listings 22 -34.60 1532.00 -0.023 0.981986
## listings 23 -12.80 1158.08 -0.011 0.991183
## listings 24 165.40 1337.24 0.124 0.901585
## listings 25 42.90 1532.00 0.028 0.977665
## listings 26 -36.60 1337.24 -0.027 0.978170
## listings 27 65.40 2005.85 0.033 0.973996
## listings 28 650.84 1021.33 0.637 0.524096
## listings 29 -28.10 1532.00 -0.018 0.985369
## listings 30 72.93 945.57 0.077 0.938533
## listings 31 354.30 1002.93 0.353 0.723958
## listings 34 -19.60 2005.85 -0.010 0.992205
## listings 35 37.80 1002.93 0.038 0.969942
## listings 36 -29.60 1532.00 -0.019 0.984588
## listings 38 115.26 1072.17 0.107 0.914413
## listings 39 -16.60 1337.24 -0.012 0.990098
## listings 40 40.90 1228.33 0.033 0.973444
## listings 41 228.73 1337.24 0.171 0.864217
## listings 42 48.90 1228.33 0.040 0.968252
## listings 43 125.40 2005.85 0.063 0.950163
## listings 45 52.07 1021.33 0.051 0.959351
## listings 46 1276.65 1228.33 1.039 0.298880
## listings 47 138.40 2005.85 0.069 0.945004
## listings 48 1714.80 1158.08 1.481 0.138971
## listings 49 157.00 1158.08 0.136 0.892187
## listings 50 183.90 1228.33 0.150 0.881017
## listings 51 -35.60 2005.85 -0.018 0.985843
## listings 52 65.00 1158.08 0.056 0.955251
## listings 53 2821.57 1108.78 2.545 0.011073 *
## listings 54 46.98 974.67 0.048 0.961562
## listings 55 373.73 1337.24 0.279 0.779928
## listings 56 105.07 1108.78 0.095 0.924524
## listings 57 6.40 1532.00 0.004 0.996668
## listings 60 856.46 925.66 0.925 0.355048
## listings 61 -15.60 2005.85 -0.008 0.993796
## listings 62 19871.45 915.54 21.705 < 2e-16 ***
## listings 63 26.11 1072.17 0.024 0.980573
## listings 64 2487.47 953.97 2.607 0.009247 **
## listings 65 563.44 903.52 0.624 0.533017
## listings 66 174.40 931.56 0.187 0.851529
## listings 67 171.93 850.27 0.202 0.839793
## listings 68 6.40 2005.85 0.003 0.997455
## listings 69 613.40 1337.24 0.459 0.646536
## listings 70 550.40 1337.24 0.412 0.680718
## listings 72 302.90 1002.93 0.302 0.762698
## listings 73 436.40 2005.85 0.218 0.827810
## listings 74 527.90 1532.00 0.345 0.730475
## listings 76 1136.90 1532.00 0.742 0.458186
## listings 77 152.40 987.61 0.154 0.877393
## listings 79 1073.40 1337.24 0.803 0.422324
## listings 81 2443.40 2005.85 1.218 0.223438
## listings 83 55.40 1337.24 0.041 0.966962
## listings 88 61.26 1072.17 0.057 0.954449
## listings 89 275.90 925.66 0.298 0.765716
## listings 90 76.40 2005.85 0.038 0.969624
## listings 92 353.40 1002.93 0.352 0.724630
## listings 93 60.40 2005.85 0.030 0.975983
## listings 94 1875.40 1158.08 1.619 0.105652
## listings 95 1337.40 1228.33 1.089 0.276486
## listings 96 914.02 1043.88 0.876 0.381440
## listings 97 105.40 1228.33 0.086 0.931635
## listings 98 558.20 1158.08 0.482 0.629900
## listings 99 243.67 987.61 0.247 0.805165
## listings 100 1517.53 1043.88 1.454 0.146310
## listings 102 31.90 1532.00 0.021 0.983391
## listings 103 8095.20 1002.93 8.072 1.83e-15 ***
## listings 104 9252.10 903.52 10.240 < 2e-16 ***
## listings 106 56.40 2005.85 0.028 0.977573
## listings 107 632.40 2005.85 0.315 0.752612
## listings 108 445.90 1043.88 0.427 0.669350
## listings 109 951.40 2005.85 0.474 0.635373
## listings 112 67.40 2005.85 0.034 0.973201
## listings 113 337.40 1228.33 0.275 0.783613
## listings 114 761.07 1108.78 0.686 0.492607
## listings 116 54.40 1532.00 0.036 0.971680
## listings 117 -38.60 2005.85 -0.019 0.984650
## listings 118 391.82 974.67 0.402 0.687764
## listings 119 3.40 2005.85 0.002 0.998648
## listings 121 179.90 1532.00 0.117 0.906542
## listings 124 563.40 2005.85 0.281 0.778858
## listings 125 44.15 1228.33 0.036 0.971334
## listings 126 -7.60 2005.85 -0.004 0.996978
## listings 128 5.40 2005.85 0.003 0.997852
## listings 130 -28.60 2005.85 -0.014 0.988627
## listings 131 86.40 2005.85 0.043 0.965651
## listings 132 60.07 1337.24 0.045 0.964181
## listings 133 6092.40 2005.85 3.037 0.002444 **
## listings 134 1479.63 963.58 1.536 0.124940
## listings 136 1927.40 1072.17 1.798 0.072510 .
## listings 138 0.40 1337.24 0.000 0.999761
## listings 139 478.98 894.17 0.536 0.592297
## listings 141 474.40 1158.08 0.410 0.682149
## listings 143 176.73 1337.24 0.132 0.894880
## listings 144 1167.40 2005.85 0.582 0.560690
## listings 145 -33.60 2005.85 -0.017 0.986638
## listings 147 214.40 1532.00 0.140 0.888727
## listings 149 3781.90 1532.00 2.469 0.013718 *
## listings 155 3288.40 2005.85 1.639 0.101420
## listings 158 125.40 2005.85 0.063 0.950163
## listings 162 134.40 2005.85 0.067 0.946591
## listings 163 353.73 1337.24 0.265 0.791425
## listings 164 1443.40 1158.08 1.246 0.212897
## listings 167 1639.84 865.19 1.895 0.058311 .
## listings 168 574.52 1043.88 0.550 0.582176
## listings 169 8933.40 1532.00 5.831 7.26e-09 ***
## listings 171 411.90 1228.33 0.335 0.737439
## listings 173 41.40 2005.85 0.021 0.983537
## listings 174 472.40 2005.85 0.236 0.813857
## listings 175 83.40 1532.00 0.054 0.956596
## listings 176 2127.40 2005.85 1.061 0.289110
## listings 177 20.40 1532.00 0.013 0.989378
## listings 180 31.40 1108.78 0.028 0.977413
## listings 181 334.40 2005.85 0.167 0.867628
## listings 182 833.40 2005.85 0.415 0.677870
## listings 184 86.90 1228.33 0.071 0.943613
## listings 191 5975.40 2005.85 2.979 0.002957 **
## listings 195 757.40 2005.85 0.378 0.705806
## listings 196 369.15 1043.88 0.354 0.723683
## listings 200 7040.40 1228.33 5.732 1.29e-08 ***
## listings 201 416.40 1158.08 0.360 0.719246
## listings 202 441.40 987.61 0.447 0.655011
## listings 204 4059.40 2005.85 2.024 0.043239 *
## listings 206 889.40 1043.88 0.852 0.394395
## listings 211 53.40 2005.85 0.027 0.978766
## listings 212 756.80 1158.08 0.653 0.513576
## listings 216 219.40 2005.85 0.109 0.912922
## listings 220 -6.60 1532.00 -0.004 0.996563
## listings 221 134.40 2005.85 0.067 0.946591
## listings 224 640.90 1532.00 0.418 0.675779
## listings 225 -13.60 1072.17 -0.013 0.989882
## listings 227 530.40 1228.33 0.432 0.665969
## listings 229 5526.40 2005.85 2.755 0.005965 **
## listings 232 12.40 2005.85 0.006 0.995069
## listings 235 582.40 2005.85 0.290 0.771604
## listings 237 658.40 1532.00 0.430 0.667451
## listings 239 7553.40 1532.00 4.930 9.49e-07 ***
## listings 242 4630.40 2005.85 2.308 0.021162 *
## listings 243 32512.40 1158.08 28.074 < 2e-16 ***
## listings 244 32512.40 2005.85 16.209 < 2e-16 ***
## listings 246 8117.40 1532.00 5.299 1.41e-07 ***
## listings 248 71.40 1158.08 0.062 0.950850
## listings 252 1770.40 2005.85 0.883 0.377640
## listings 253 419.40 2005.85 0.209 0.834419
## listings 256 199.40 2005.85 0.099 0.920832
## listings 258 5667.73 1337.24 4.238 2.44e-05 ***
## listings 260 621.40 2005.85 0.310 0.756778
## listings 261 396.40 872.46 0.454 0.649671
## listings 263 9020.04 953.97 9.455 < 2e-16 ***
## listings 265 1207.73 1337.24 0.903 0.366644
## listings 266 218.40 1532.00 0.143 0.886665
## listings 269 2269.40 2005.85 1.131 0.258142
## listings 270 2835.40 1532.00 1.851 0.064473 .
## listings 271 10.40 1532.00 0.007 0.994585
## listings 272 489.15 1228.33 0.398 0.690544
## listings 278 1534.40 1158.08 1.325 0.185467
## listings 280 2863.40 2005.85 1.428 0.153718
## listings 281 1466.90 1108.78 1.323 0.186119
## listings 282 369.40 2005.85 0.184 0.853922
## listings 283 2412.40 2005.85 1.203 0.229363
## listings 288 1346.40 2005.85 0.671 0.502214
## listings 289 891.40 1532.00 0.582 0.560785
## listings 295 1710.40 2005.85 0.853 0.394012
## listings 296 3607.40 2005.85 1.798 0.072387 .
## listings 305 5050.40 2005.85 2.518 0.011951 *
## listings 313 1299.40 2005.85 0.648 0.517249
## listings 316 6589.40 2005.85 3.285 0.001052 **
## listings 319 1604.50 1002.93 1.600 0.109931
## listings 320 677.40 1532.00 0.442 0.658456
## listings 325 6103.69 875.43 6.972 5.42e-12 ***
## listings 326 -21.60 2005.85 -0.011 0.991410
## listings 329 759.40 2005.85 0.379 0.705065
## listings 335 2300.90 1228.33 1.873 0.061311 .
## listings 339 344.40 1532.00 0.225 0.822174
## listings 340 2955.40 2005.85 1.473 0.140937
## listings 345 7475.40 1158.08 6.455 1.63e-10 ***
## listings 351 484.40 2005.85 0.241 0.809219
## listings 354 6006.40 2005.85 2.994 0.002812 **
## listings 358 412.40 1158.08 0.356 0.721830
## listings 360 171.40 1337.24 0.128 0.898034
## listings 363 749.40 2005.85 0.374 0.708770
## listings 364 25.40 1532.00 0.017 0.986775
## listings 375 9336.07 1337.24 6.982 5.08e-12 ***
## listings 376 1049.40 855.30 1.227 0.220112
## listings 381 367.40 1337.24 0.275 0.783564
## listings 390 3579.40 1158.08 3.091 0.002047 **
## listings 391 1973.90 1532.00 1.288 0.197865
## listings 392 1768.40 2005.85 0.882 0.378178
## listings 394 310.40 2005.85 0.155 0.877050
## listings 396 794.40 2005.85 0.396 0.692153
## listings 397 676.40 1532.00 0.442 0.658928
## listings 403 2012.40 2005.85 1.003 0.315958
## listings 425 240.40 1532.00 0.157 0.875338
## listings 428 282.40 2005.85 0.141 0.888064
## listings 431 4929.40 1532.00 3.218 0.001331 **
## listings 438 779.40 2005.85 0.389 0.697676
## listings 439 2241.40 2005.85 1.117 0.264059
## listings 446 3178.40 1532.00 2.075 0.038252 *
## listings 447 5450.40 2005.85 2.717 0.006688 **
## listings 449 1737.40 2005.85 0.866 0.386592
## listings 456 1262.40 2005.85 0.629 0.529248
## listings 464 438.40 1228.33 0.357 0.721231
## listings 471 1262.40 2005.85 0.629 0.529248
## listings 480 -11.60 1158.08 -0.010 0.992010
## listings 483 1127.40 2005.85 0.562 0.574195
## listings 485 2555.40 2005.85 1.274 0.202947
## listings 486 2714.45 867.38 3.129 0.001798 **
## listings 511 891.40 2005.85 0.444 0.656843
## listings 515 1515.40 2005.85 0.755 0.450120
## listings 518 3065.40 2005.85 1.528 0.126748
## listings 522 -26.60 1043.88 -0.025 0.979675
## listings 529 1570.40 1158.08 1.356 0.175370
## listings 530 1570.40 1228.33 1.278 0.201353
## listings 531 1570.40 2005.85 0.783 0.433852
## listings 536 6149.40 1532.00 4.014 6.38e-05 ***
## listings 539 29962.90 1228.33 24.393 < 2e-16 ***
## listings 541 10747.40 2005.85 5.358 1.03e-07 ***
## listings 555 112.40 2005.85 0.056 0.955323
## listings 556 226.40 1532.00 0.148 0.882543
## listings 561 2921.40 2005.85 1.456 0.145562
## listings 562 39587.40 1532.00 25.840 < 2e-16 ***
## listings 563 3580.40 1021.33 3.506 0.000474 ***
## listings 574 6253.40 2005.85 3.118 0.001872 **
## listings 578 47.40 1532.00 0.031 0.975323
## listings 581 422.40 2005.85 0.211 0.833252
## listings 603 1683.40 2005.85 0.839 0.401518
## listings 605 11181.40 2005.85 5.574 3.14e-08 ***
## listings 619 176.40 2005.85 0.088 0.929939
## listings 623 9992.40 2005.85 4.982 7.34e-07 ***
## listings 632 392.40 2005.85 0.196 0.844939
## listings 647 773.40 2005.85 0.386 0.699890
## listings 658 3831.40 2005.85 1.910 0.056383 .
## listings 660 1191.40 2005.85 0.594 0.552662
## listings 665 1450.40 2005.85 0.723 0.469785
## listings 695 21669.73 1337.24 16.205 < 2e-16 ***
## listings 717 76.90 1532.00 0.050 0.959976
## listings 722 20660.40 1532.00 13.486 < 2e-16 ***
## listings 724 448.90 1532.00 0.293 0.769566
## listings 726 448.40 2005.85 0.224 0.823153
## listings 728 448.40 2005.85 0.224 0.823153
## listings 755 4001.40 2005.85 1.995 0.046309 *
## listings 760 3406.40 2005.85 1.698 0.089752 .
## listings 777 5493.40 2005.85 2.739 0.006270 **
## listings 789 157.40 2005.85 0.078 0.937468
## listings 791 453.40 2005.85 0.226 0.821214
## listings 802 2442.40 1532.00 1.594 0.111170
## listings 812 17786.40 2005.85 8.867 < 2e-16 ***
## listings 821 2132.73 1337.24 1.595 0.111031
## listings 822 562.07 1337.24 0.420 0.674335
## listings 828 337.07 1337.24 0.252 0.801041
## listings 844 5721.40 2005.85 2.852 0.004422 **
## listings 846 2001.40 2005.85 0.998 0.318609
## listings 849 634.40 1228.33 0.516 0.605629
## listings 884 415.40 1532.00 0.271 0.786328
## listings 914 1601.40 1337.24 1.198 0.231357
## listings 916 1600.40 2005.85 0.798 0.425124
## listings 923 1602.40 2005.85 0.799 0.424546
## listings 924 1602.40 1108.78 1.445 0.148693
## listings 926 2345.40 2005.85 1.169 0.242549
## listings 950 2563.40 2005.85 1.278 0.201538
## listings 965 554.40 1337.24 0.415 0.678527
## listings 1009 11382.40 2005.85 5.675 1.78e-08 ***
## listings 1012 1108.40 2005.85 0.553 0.580663
## listings 1013 1107.40 2005.85 0.552 0.581005
## listings 1017 934.40 1532.00 0.610 0.542041
## listings 1053 852.40 1532.00 0.556 0.578054
## listings 1074 13395.90 1532.00 8.744 < 2e-16 ***
## listings 1075 13386.40 2005.85 6.674 3.98e-11 ***
## listings 1084 2718.40 1532.00 1.774 0.076275 .
## listings 1094 19276.40 2005.85 9.610 < 2e-16 ***
## listings 1095 2616.40 2005.85 1.304 0.192381
## listings 1101 3222.40 2005.85 1.606 0.108456
## listings 1152 289.40 2005.85 0.144 0.885308
## listings 1195 388.40 2005.85 0.194 0.846499
## listings 1235 704.11 931.56 0.756 0.449912
## listings 1254 8478.40 2005.85 4.227 2.57e-05 ***
## listings 1280 1102.40 2005.85 0.550 0.582713
## listings 1284 16003.40 2005.85 7.978 3.76e-15 ***
## listings 1307 2904.40 1337.24 2.172 0.030077 *
## listings 1347 299.40 2005.85 0.149 0.881374
## listings 1398 3339.40 2005.85 1.665 0.096237 .
## listings 1450 5685.40 2005.85 2.834 0.004677 **
## listings 1451 5678.40 2005.85 2.831 0.004727 **
## listings 1547 33771.40 2005.85 16.836 < 2e-16 ***
## listings 1556 696.40 2005.85 0.347 0.728521
## listings 1665 12592.40 2005.85 6.278 4.96e-10 ***
## listings 1667 12590.40 2005.85 6.277 4.99e-10 ***
## listings 1721 2432.40 2005.85 1.213 0.225528
## listings 1800 1945.07 1337.24 1.455 0.146086
## listings 1942 18759.83 851.79 22.024 < 2e-16 ***
## listings 1943 14510.40 1337.24 10.851 < 2e-16 ***
## listings 2008 32412.40 2005.85 16.159 < 2e-16 ***
## listings 2010 32411.40 2005.85 16.158 < 2e-16 ***
## listings 2016 32409.40 2005.85 16.157 < 2e-16 ***
## listings 2063 2210.40 2005.85 1.102 0.270718
## listings 2064 2209.40 2005.85 1.101 0.270935
## listings 2149 17510.90 1228.33 14.256 < 2e-16 ***
## listings 2155 20620.40 1532.00 13.460 < 2e-16 ***
## listings 2180 3417.40 1337.24 2.556 0.010737 *
## listings 2204 1407.40 2005.85 0.702 0.483051
## listings 2217 2411.31 987.61 2.442 0.014784 *
## listings 2923 20964.40 1337.24 15.677 < 2e-16 ***
## listings 2950 2829.40 2005.85 1.411 0.158659
## listings 2951 5391.40 1532.00 3.519 0.000451 ***
## listings 3739 4094.40 1532.00 2.673 0.007640 **
## listings 3817 34372.40 1532.00 22.436 < 2e-16 ***
## listings 4276 5461.40 2005.85 2.723 0.006579 **
## listings 4698 15348.40 1072.17 14.315 < 2e-16 ***
## listings 4879 4640.40 2005.85 2.313 0.020886 *
## listings 5542 7895.40 2005.85 3.936 8.81e-05 ***
## listings 6138 30692.40 2005.85 15.301 < 2e-16 ***
## listings73400 1051508.40 1532.00 686.365 < 2e-16 ***
## listings73421 1051552.40 2005.85 524.242 < 2e-16 ***
## listings82679 87237.40 2005.85 43.491 < 2e-16 ***
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 1831 on 1082 degrees of freedom
## (1624 observations deleted due to missingness)
## Multiple R-squared: 0.9989, Adjusted R-squared: 0.9986
## F-statistic: 3037 on 329 and 1082 DF, p-value: < 2.2e-16
l <- ggplot(data = model) +
geom_point(mapping = aes(x = listings, y = Total_sales)) +
geom_smooth(mapping = aes(x = listings, y = Total_sales)) +
labs(title = "Relationship Between Listing And Total Sales", x = "Listings", y = "Sales")+
theme_minimal()
#make plot interactive
ggplotly(l)
We’ve discovered something important: having more product listings in our Etsy store significantly predicts higher sales. This highlights the need to optimize and strategically manage our listings to boost our sales performance positively.
Group by seller location and calculate total sales for each location
sales_by_location <- Etsy %>%
group_by(Seller_location) %>%
summarise(Total_Sales = sum(Total_sales, na.rm = TRUE)) %>%
arrange(desc(Total_Sales))
Set the value for top N (e.g., top 10)
top_n_value <- 10
Create a bar plot to visualize the relationship between top sales and seller locations
sales_by_location %>%
top_n(top_n_value, Total_Sales) %>%
ggplot(aes(x = reorder(Seller_location, Total_Sales), y = Total_Sales)) +
geom_bar(stat = "identity", fill = "purple") +
labs(title = paste("Top", top_n_value, "Seller Locations by Total Sales"),
x = "Seller Location",
y = "Total Sales") +
scale_y_continuous(labels = scales::comma_format()) +
theme(axis.text.x = element_text(angle = 45, hjust = 1, vjust = 1)) +
theme_minimal()
The United States is the top-performing location in terms of total
sales.
Group by Shipsfrom and calculate total sales for each location
ship_location <- Etsy %>%
group_by(Shipsfrom ) %>%
summarise(Total_Sales = sum(Total_sales, na.rm = TRUE)) %>%
arrange(desc(Total_Sales))
Create a bar plot to with top N shipping locations
ship_location %>%
top_n(top_n_value, Total_Sales) %>%
ggplot(aes(x = reorder(Shipsfrom, Total_Sales), y = Total_Sales)) +
geom_bar(stat = "identity", fill = "purple") +
labs(title = paste("Top", top_n_value, "Shipping Locations by Total Sales"),
x = "Shipping Location",
y = "Total Sales") +
scale_y_continuous(labels = scales::comma_format()) +
theme(axis.text.x = element_text(angle = 45, hjust = 1, vjust = 1)) +
theme_minimal()
Stores with “America” as the shipping location correlate with increased
sales
Filter out rows with NA values in ‘ArtType’ or ‘Total_sales’
filtered_data <- Etsy[complete.cases(Etsy$ArtType, Etsy$Total_sales), ]
Create bar plot to visualizate sales distribution across art type
ggplot(data = filtered_data) +
geom_col(aes(x = ArtType, y = Total_sales, fill = ArtType)) +
labs(title = "Total Sales Distribution by Handmade and Digital Downloads", y = "Total Sales") +
scale_y_continuous(labels = scales::comma_format()) +
scale_fill_manual(values = c("pink", "purple")) +
theme_classic() + theme_bw() + theme_minimal()
The bar chart clearly indicates that handmade art is more popular than digital art.
Filter rows for ‘Handmade’ and ‘Digital Downloads’ and then find min and max prices
min_max_prices <- Etsy %>%
filter(ArtType %in% c("Handmade", "Digital download")) %>%
group_by(ArtType) %>%
summarise(Min_Price = min(Price, na.rm = TRUE),
Max_Price = max(Price, na.rm = TRUE))
Digital Art consistently has lower prices than Handmade Art. Despite this, Digital Art records lower sales
Popular Keywords
#Select the first 25 rows and then sort by Total_sales
top_25 <- Etsy %>%
head(25) %>%
arrange(desc(Total_sales))
# Print the top 25 rows
print(top_25)
## Product_URL
## 1 https://www.etsy.com/listing/1394171048/6-hand-made-african-digital-scrapbook?click_key=cb3c8aa09ebf8aff2b0482b307b393b34839cdbb%3A1394171048&click_sum=c521d529&ga_order=most_relevant&ga_search_type=all&ga_view_type=gallery&ga_search_query=african+art&ref=search_grid-1094177-1-10&dd=1
## 2 https://www.etsy.com/listing/1516846441/artwork-print-lady-art-muserum-poster?click_key=a936a0c7054ea7eb76172ff5aaf458a62d13f7a8%3A1516846441&click_sum=2a4e40ff&ga_order=most_relevant&ga_search_type=all&ga_view_type=gallery&ga_search_query=african+art&ref=search_grid-862547-1-3&pro=1&sts=1&dd=1
## 3 https://www.etsy.com/listing/1410055019/african-art-african-african-wall-art?click_key=e66fc665bf2a7284a6a85340f6c889d9cdfa2071%3A1410055019&click_sum=c99e283a&ga_order=most_relevant&ga_search_type=all&ga_view_type=gallery&ga_search_query=african+art&ref=search_grid-862547-1-5&pro=1&sts=1&dd=1
## 4 https://www.etsy.com/listing/1474496117/tribal-ethnic-decoration-artwork-print?click_key=9d6c6a5473390106ee1999fada68e3eaabeb1af5%3A1474496117&click_sum=e717f8fa&ga_order=most_relevant&ga_search_type=all&ga_view_type=gallery&ga_search_query=african+art&ref=search_grid-862547-1-8&pro=1&sts=1&dd=1
## 5 https://www.etsy.com/listing/1530872289/black-woman-art-african-wall-art-vintage?click_key=6d95f2deffd87616a3b85b33d4506d153dbd191c%3A1530872289&click_sum=3fe5c083&ga_order=most_relevant&ga_search_type=all&ga_view_type=gallery&ga_search_query=african+art&ref=search_grid-1094177-1-14&pro=1&sts=1&dd=1
## 6 https://www.etsy.com/listing/1465749216/tribal-ethnic-decoration-artwork-print?click_key=c5e68d13bc28677d7a61d97130acea3a8ab51c85%3A1465749216&click_sum=505b6a8b&ga_order=most_relevant&ga_search_type=all&ga_view_type=gallery&ga_search_query=african+art&ref=search_grid-1094177-1-15&pro=1&sts=1&dd=1
## 7 https://www.etsy.com/listing/1359369217/african-mask-metal-wall-art-african?click_key=f9044c693d1747c1fe7c5ad99a15763293ecfea2%3A1359369217&click_sum=85503388&ga_order=most_relevant&ga_search_type=all&ga_view_type=gallery&ga_search_query=african+art&ref=search_grid-1094176-1-8&pro=1&frs=1
## 8 https://www.etsy.com/listing/1634415603/vibrant-african-wall-basket-set-of-3?click_key=58e3a5d15722170a336c228839c24ecfb1fa6218%3A1634415603&click_sum=84aea170&ga_order=most_relevant&ga_search_type=all&ga_view_type=gallery&ga_search_query=african+art&ref=search_grid-1094176-1-9&pro=1&etp=1&sts=1
## 9 https://www.etsy.com/listing/1427076144/set-of-3-african-maps-watercolour?click_key=5dc63a9145ac117b66c1667165cd52976de8092c%3A1427076144&click_sum=28b7d6a2&ga_order=most_relevant&ga_search_type=all&ga_view_type=gallery&ga_search_query=african+art&ref=search_grid-862547-1-6&pro=1&sts=1&dd=1
## 10 https://www.etsy.com/listing/1427068844/set-of-3-south-african-windpomp?click_key=f54272843945086bf56fec713912b82aea5c5ec3%3A1427068844&click_sum=a2563502&ga_order=most_relevant&ga_search_type=all&ga_view_type=gallery&ga_search_query=african+art&ref=search_grid-1094177-1-13&pro=1&sts=1&dd=1
## 11 https://www.etsy.com/listing/1347792095/african-art-print-set-of-three-ethnic?click_key=24db00a5f74766c4e20a8bf6d90cc72f4ae077a9%3A1347792095&click_sum=27ed5a44&ga_order=most_relevant&ga_search_type=all&ga_view_type=gallery&ga_search_query=african+art&ref=search_grid-862547-1-1&pro=1&sts=1&dd=1
## 12 https://www.etsy.com/listing/1094471127/bolga-fan-assorted-hand-woven-african?click_key=f302dc493db82af270eca6e7e6b82ae5c9f06cab%3A1094471127&click_sum=b2c3b848&ga_order=most_relevant&ga_search_type=all&ga_view_type=gallery&ga_search_query=african+art&ref=search_grid-862546-1-1&pro=1&cns=1
## 13 https://www.etsy.com/listing/1572651608/abstract-ethnic-african-wall-art-set?click_key=0877e89adf0459885ade9a1de6185b80d25f0ae0%3A1572651608&click_sum=27440d4e&ga_order=most_relevant&ga_search_type=all&ga_view_type=gallery&ga_search_query=african+art&ref=search_grid-862547-1-7&dd=1
## 14 https://www.etsy.com/listing/1647958584/african-woman-vibrant-pop-art-digital?click_key=947efe60b94423f27b85771f5e84b5f7c8eb67c8%3A1647958584&click_sum=dcda426a&ga_order=most_relevant&ga_search_type=all&ga_view_type=gallery&ga_search_query=african+art&ref=search_grid-1094177-1-12&pro=1&sts=1&dd=1
## 15 https://www.etsy.com/listing/1438387507/set-of-2-african-wooden-mask-wall-art?click_key=cd24c41e7643705b5ab939fae6886743501e86d9%3A1438387507&click_sum=0332fb76&ga_order=most_relevant&ga_search_type=all&ga_view_type=gallery&ga_search_query=african+art&ref=search_grid-862546-1-2&frs=1
## 16 https://www.etsy.com/listing/1599109734/africa-metal-wall-decor-nature-metal?click_key=3ef7c8ad9b1a787249495955e1acc76df8a1b5f9%3A1599109734&click_sum=52a1754f&ga_order=most_relevant&ga_search_type=all&ga_view_type=gallery&ga_search_query=african+art&ref=search_grid-862546-1-3&pro=1&cns=1
## 17 https://www.etsy.com/listing/1552170014/bo-kaap-watercolor-print-south-africa?click_key=2b421d7a37da4cf751df8f0c2357d2f54cfb0b8d%3A1552170014&click_sum=6a864835&ga_order=most_relevant&ga_search_type=all&ga_view_type=gallery&ga_search_query=african+art&ref=search_grid-862546-1-4&pro=1&sts=1
## 18 https://www.etsy.com/listing/1457761639/set-of-2-african-american-wall-art-afro?click_key=96c6c1dfa9b3b25d040c37f1d71708dbeb002fb4%3A1457761639&click_sum=82b1e6cf&ga_order=most_relevant&ga_search_type=all&ga_view_type=gallery&ga_search_query=african+art&ref=search_grid-862547-1-2&pro=1&dd=1
## 19 https://www.etsy.com/listing/1406261561/african-woman-africa-tribe-kente?click_key=5cc2acac5fde8d6c98529f1b82e5f70b85d75fdf%3A1406261561&click_sum=36526552&ga_order=most_relevant&ga_search_type=all&ga_view_type=gallery&ga_search_query=african+art&ref=search_grid-862547-1-4&dd=1
## 20 https://www.etsy.com/listing/952180673/elephant-pillow-cover-african-themed?click_key=dd6449c80be5947164c8893e1b31f573e69a6be2%3A952180673&click_sum=e9235301&ga_order=most_relevant&ga_search_type=all&ga_view_type=gallery&ga_search_query=african+art&ref=search_grid-1094176-1-5&pro=1&sts=1
## 21 https://www.etsy.com/listing/1649668561/african-american-artafrican-art-wall?click_key=3182ba3e5cf6e0c720020e68eaeca56e184429c0%3A1649668561&click_sum=040bbf82&ga_order=most_relevant&ga_search_type=all&ga_view_type=gallery&ga_search_query=african+art&ref=search_grid-1094176-1-6&pro=1&frs=1
## 22 https://www.etsy.com/listing/1323224976/africa-woman-wall-decor-african-american?click_key=5fa3b51ea34d2f32c70e8887ead1c5009931cb9c%3A1323224976&click_sum=8483331d&ga_order=most_relevant&ga_search_type=all&ga_view_type=gallery&ga_search_query=african+art&ref=search_grid-1094176-1-7&pro=1&sca=1
## 23 https://www.etsy.com/listing/1362981784/sawabona-definition-sawubona-south?click_key=5fc2a00feb33512a5b672e4fd6c98ed11b11eb00%3A1362981784&click_sum=3b2a6af1&ga_order=most_relevant&ga_search_type=all&ga_view_type=gallery&ga_search_query=african+art&ref=search_grid-1094177-1-9&pro=1&sts=1&dd=1
## 24 https://www.etsy.com/listing/1514967939/african-art-abstract-african-wall-art?click_key=f327a3653a3f8524e8486547b0188394136e0829%3A1514967939&click_sum=05be94e9&ga_order=most_relevant&ga_search_type=all&ga_view_type=gallery&ga_search_query=african+art&ref=search_grid-1094177-1-11&pro=1&frs=1
## 25 https://www.etsy.com/listing/1430096985/ubuntu-definition-print-south-wall-art?click_key=428b3969d9948b99c07b8fb1b9d8c6e6905e8b5c%3A1430096985&click_sum=45be8f1b&ga_order=most_relevant&ga_search_type=all&ga_view_type=gallery&ga_search_query=african+art&ref=search_grid-1094177-1-16&pro=1&sts=1&dd=1
## Product_Name
## 1 6 Hand Made African Digital Scrapbook Paper | African Background | Kwanzaa Pattern | instant download
## 2 Black Art Prints , Black And White Wall Art , African art , Photography Artwork , Printable wall art , extra large wall art
## 3 Artwork print , Lady art , Muserum poster , Gallery Wall Art , Black Woman Art , African art , Black and white art , wall art printable ,
## 4 Artwork print , Lady art , Muserum poster , Gallery Wall Art , Black Woman Art , African art , Black and white art , wall art printable ,
## 5 Artwork print , Lady art , Muserum poster , Gallery Wall Art , Black Woman Art , African art , Black and white art , wall art printable ,
## 6 Artwork print , Lady art , Muserum poster , Gallery Wall Art , Black Woman Art , African art , Black and white art , wall art printable ,
## 7 African Women Metal Wall Art, 3 Pieces Metal Wall Art, Gift For Her Valentines Day, African Ladies, Framed Wall Decor, African Queen Decor
## 8 Wholesale Baskets, Colorful Wall Basket, Assorted designs, Custom order
## 9 Set of 3 Africa Maps, Watercolour, Digital Download, Wall Decor, South Africa, Africa, Clipart, map Illustration, World, AI
## 10 Set of 3 African Maps watercolour, Digital Download, Wall Decor, Outline, South African, Protea Design, Clipart, map Illustration, AI
## 11 African Rug Print Set of 3, Black Beige Geometric Art Print, Neutral Wall Art, Digital Download
## 12 Dog Collar broad - 51-54cm | Handmade Dog Collar | African Dog Collar | Bohemian Pet Collar | African Tribe Art
## 13 African Wall Art Set, Black Woman Art, Boho Decor ,Modern African American art set of 3, Boho Art Prints, Boho Wall Art, Abstract Ethnic
## 14 Her Afro Crown Digital Printable Wall Art| Afro Hair Wall Art| Black Woman Art| African American Art| Afrocentric Wall Art| African Art Deco
## 15 Set of 2 African Wooden Mask Wall Art with Animals | Wall Mask Sculpture | Wooden Wall Hanging | Handmade Wall Decor | African Wall Mask
## 16 Birds Metal Wall Decors, 2 Pieces Birds Decor, Birds on branch Metal Sign, Birds Wallart, Livingroom Decor, Kitchen Wallart, Interior Decor
## 17 Bo-Kaap Watercolor Print | Set of 3 | South Africa Gift | Cape Town Decor | Table Mountain Art | South African Cityscape | Colorful Houses
## 18 Set Of 2 African American Wall Art, Afro Bohemian Decor, Modern Afro Print Set, Abstract Ethnic Triptych, African Girls Poster, African Gift
## 19 African Woman | Africa Tribe | Kente Watercolors | Digital Paper Pack | Instant Digital Download | African Decor | African Digital Art
## 20 Elephant Tamer Cushion Cover, African Cushion, Zebra Throw Pillow Top, Ethnic Pillow Cover, Safari Cushion, Decorative Pillow, African Decor
## 21 Black textured wall art Black and white Abstract art Black and white Painting Black and white wall art Black and white 3D textured wall art
## 22 African Woman Metal Wall Map Art, African American Bedroom Wall Decor, African Style Woman Figure Art, African Queen Decor,Housewarming Gift
## 23 Difference Maker Definition Print, Minimal Print, Gift For Sister, Best Friend Gift, Mentor Gift, Wall Art, Teacher Present,Instant Download
## 24 African Art, Abstract African Wall Art, Woman Face Canvas, Modern African Canvas, Home Decor , Ready to Hang
## 25 Baseball Definition Print, Baseball Poster, Baseball Mom gift, Baseball Wall, Teen room decor, fan gift, printable, DOWNLOAD
## Price ArtType Seller_name
## 1 0.68 Digital download TheJokeIsOnMe
## 2 9.10 Digital download 4DisplayArt
## 3 4.95 Digital download 4DisplayArt
## 4 9.10 Digital download 4DisplayArt
## 5 9.10 Digital download 4DisplayArt
## 6 9.10 Digital download 4DisplayArt
## 7 66.00 Handmade PluviartMetalDecor
## 8 78.20 Handmade SifaDesigns
## 9 4.24 Digital download TheQuirkyProtea
## 10 4.24 Digital download TheQuirkyProtea
## 11 5.38 Digital download HomeWallArtPrintable
## 12 39.10 Handmade AfricanCreativeCA
## 13 9.00 Digital download PrintdigiartShop
## 14 4.42 Digital download AfriPaintShop
## 15 179.98 Handmade OrionWallArtDecor
## 16 44.90 Handmade ArteBellaWallArt
## 17 18.19 Handmade GiosStudioNYC
## 18 5.40 Digital download Zentrova
## 19 1.50 Digital download TeeTimeUSA
## 20 10.79 Handmade HomeCraftsTR
## 21 104.40 Handmade HayArtGallery
## 22 59.90 Handmade BrosWallArtDecors
## 23 3.00 Digital download ItalyDesignStudio
## 24 25.00 Handmade PrintOneCanvas
## 25 4.09 Digital download GrandandLovelyPrints
## Dimensions
## 1 Length: 12 inches\nWidth: 12 inches
## 2 <NA>
## 3 <NA>
## 4 <NA>
## 5 <NA>
## 6 <NA>
## 7 <NA>
## 8 Gift wrapping available
## 9 Width: 210 millimetres\nHeight: 297 millimetres
## 10 Width: 210 millimetres\nHeight: 297 millimetres
## 11 <NA>
## 12 <NA>
## 13 <NA>
## 14 <NA>
## 15 Width: 4 inches\nHeight: 20 inches
## 16 <NA>
## 17 <NA>
## 18 <NA>
## 19 <NA>
## 20 Width: 14 inches\nLength: 14 inches
## 21 Width: 32 inches\nHeight: 24 inches
## 22 Gift wrapping available\nSee details\nGift wrapping by BrosWallArtDecors\nWe carefully gift-wrap your products.
## 23 <NA>
## 24 Gift wrapping available
## 25 <NA>
## Materials
## 1 <NA>
## 2 <NA>
## 3 <NA>
## 4 <NA>
## 5 <NA>
## 6 <NA>
## 7 Metal
## 8 ilala palm, sisal, natural dye
## 9 <NA>
## 10 <NA>
## 11 <NA>
## 12 elephant grass, natural dyes
## 13 <NA>
## 14 <NA>
## 15 Wooden Wall Art, Handmade Wall Decor
## 16 Steel, Powder Coat, Black Matte Dye, Gold Dye, White Dye, Silver Dye, Red Dye
## 17 <NA>
## 18 <NA>
## 19 <NA>
## 20 <NA>
## 21 Acrylic, Oil, Canvas
## 22 Steel, Creativity, Love, Passion, Inspiration, Black Matte Dye, Silver Dye, Gold Matte Dye, White Matte Dye
## 23 <NA>
## 24 Cotton, Print, ink, wood
## 25 <NA>
## Description
## 1 Hello,This sale is for 6 hand made African patterns that can be used for scrap-booking, Kwanzaa celebrations, digital wallpapers or various digital media backgrounds and prints, like business cards, flyers and more.Save yourself money and time researching the internet for digital assets and proper licenses. All digital assets sales are final. You are free to use and modify this digital asset for personal, business or educational use. However, you do not have the right to resell or share these images for monetary gain.Image Size:All images are 3600x3600px | 12 / 12 inch | 300DPI RGB colour space and are suitable for Print. Please note that the colours will slightly differ between computers and printers due to different methods of calibration.Help on downloading: http://www.etsy.com/uk/help/article/3949?ref=listing_74033419The Joke Is On Me don't accept returns, exchanges or cancellations. However, contact me if you have any problems with your order.Thank you for shopping,The Joke Is On Me
## 2 ✦ About the artworkCreate a real impact on your wall with this large artwork.It looks great when printed on high quality canvas and stretched on a frame.Or you may get it printed on high quality paper and framed under glass with a mat as well.✦ WHAT'S INCLUDED ✦You will get 3 High-Resolution JPG files at 300 DPI1 x 16" x 24" inches (40 x 60 cm)1 x 24" x 36" inches (60 x 90 cm)1 x 28" x 40" inches (70 x 100 cm)⚡ The file can be printed in various small and large sizes. ⚡ If you need a different size (inches / cm) , add a note when purchasing the item and I'll send the new file to your email inbox FREE.✦PLEASE NOTE✦►Please note that this listing is for an Instant Download - no physical product will be shipped – frame and props are not included►The colors may vary slightly from how they appear in person or how they display from one viewing device to another due to the color calibration of your device or monitor.♥ Thank you for stopping by! ♥
## 3 ✦ About the artworkTitle: The JourneyCreate a real impact on your wall with this large artwork.It looks great when printed on high quality canvas and stretched on a frame.Or you may get it printed on high quality paper and framed under glass with a mat as well.✦ WHAT'S INCLUDED ✦You will get 1 High-Resolution JPG files at 300 DPI 8" x 8" inches ⚡ The file can be printed in various small and large sizes. ⚡ If you need a different size (inches / cm) , add a note when purchasing the item and I'll send the new file to your email inbox FREE.✦PLEASE NOTE✦►Please note that this listing is for an Instant Download - no physical product will be shipped – frame and props are not included►The colors may vary slightly from how they appear in person or how they display from one viewing device to another due to the color calibration of your device or monitor.♥ Thank you for stopping by! ♥
## 4 ✦ À propos de l'œuvre\nCréez un véritable impact sur votre mur avec cette grande œuvre d'art.\nIl a fière allure lorsqu'il est imprimé sur une toile de haute qualité et étiré sur un cadre.\nOu vous pouvez l'obtenir imprimé sur du papier de haute qualité et encadré sous verre avec un passe-partout également.\n✦ CE QUI EST INCLUS ✦\nVous obtiendrez : 2 fichiers JPG haute résolution à 300 DPI\n1 x 19 "x 27" pouces (50 x 70 cm)\n1 x 24 x 36 pouces (60 x 90 cm)\n⚡ Le fichier peut être imprimé en différentes petites et grandes tailles.\n⚡ Si vous avez besoin d'une taille différente (pouces/cm), ajoutez une note lors de l'achat de l'article et j'enverrai le nouveau fichier à votre boîte de réception GRATUITEMENT.\n✦VEUILLEZ NOTER✦\n►Veuillez noter que cette liste est pour un téléchargement instantané - aucun produit physique ne sera expédié - le cadre et les accessoires ne sont pas inclus\n► Les couleurs peuvent varier légèrement de la façon dont elles apparaissent en personne ou de la façon dont elles s'affichent d'un appareil de visualisation à un autre en raison de l'étalonnage des couleurs de votre appareil ou moniteur.\n♥ Merci d'être passé! ♥
## 5 ✦ About the artworkCreate a real impact on your wall with this large artwork.It looks great when printed on high quality canvas and stretched on a frame.Or you may get it printed on high quality paper and framed under glass with a mat as well.✦ WHAT'S INCLUDED You will get 4 High-Resolution JPG files at 300 DPI1 x 16" x 24" inches (40 x 60 cm)1 x 24" x 36" inches (60 x 90 cm)1 x 24" x 40" inches (60 x 100 cm)1 x 28" x 48" inches (70 x 120 cm)⚡ The file can be printed in various small and large sizes. ⚡ If you need a different size (inches / cm), add a note when purchasing the item and I'll send the new file to your email inbox FREE.✦PLEASE NOTE✦►Please note that this listing is for an Instant Download - no physical product will be shipped – frame and props are not included►The colors may vary slightly from how they appear in person or how they display from one viewing device to another due to the color calibration of your device or monitor.♥ Thank you for stopping by! ♥
## 6 Create a real impact on your wall with this large artwork.It looks great when printed on high quality canvas and stretched on a frame.Or you may get it printed on high quality paper and framed under glass with a mat as well.✦ WHAT'S INCLUDED ✦You will get 3 High-Resolution JPG files at 300 DPI1 x 16" x 24" inches (40 x 60 cm)1 x 24" x 36" inches (60 x 90 cm)1 x 28" x 40" inches (70 x 100 cm)⚡ The file can be printed in various small and large sizes. ⚡ If you need a different size (inches / cm), add a note when purchasing the item and I'll send the new file to your email inbox FREE.✦PLEASE NOTE✦►Please note that this listing is for an Instant Download - no physical product will be shipped – frame and props are not included►The colors may vary slightly from how they appear in person or how they display from one viewing device to another due to the color calibration of your device or monitor.♥ Thank you for stopping by! ♥
## 7 Your wall reflects you better than a mirror. - Pluviart● MATERIAL - Constructed from 1.5 mm steel and powder coated with an electrostatic textured powder coat finish.● Resistant to humid environments such as kitchen, bathroom and outdoor.● Product with 3D Shadow effect stands 0.60" away from the wall.● SIMPLE OPERATION - Products require no assembly and are easy to hang. All hanging materials are included in the package. The only thing you need to think about to bring elegance to your wall is which wall to hang it on.● DELIVERED IN A STURDY BOX - It is delivered in a stylish and sturdy package so that you can make your loved ones happy on all special occasions you can think of. You can add special notes in the package.Please contact us with your questions and suggestions.Visit our shop for other metal wall art designs; https://www.etsy.com/shop/PluviartMetalDecor
## 8 Set of 3 Decorative wall baskets .These stunning pieces are beautifully crafted with intricate patterns and eye-catching colors, making them the perfect addition to any space. Each wall basket is meticulously handwoven by skilled artisans, ensuring exceptional quality and authenticity. With their unique design and rich cultural heritage, these colorful baskets will effortlessly infuse your home with a touch of African charm.Ethically & sustainably handcrafted, They are perfect for wall decor/ wall art displayComes with loops attached - ready to hang on your wallSizes included in this set of 3 (12, 10, 8)How to care for your baskets:Dust off lightly when dirty.Keep out of direct sunlight to preserve colors.Please note : each African basket is handmade with natural materials, there may be some variations in weave pattern and color ,it should not be seen as a flaw .I ship worldwide. Fast Shipping!Please send a message if you have any questions or need assistance.To view more products, visit my shop https://www.etsy.com/shop/SifaDesigns
## 9 Welcome to my listing for a stunning watercolour digital download SET OF 3 (Portrait size) map of africa clipart, created using innovative AI technology. As a digital download, you will receive a high-quality JPEG file that you can print at home or at your local print shop, giving you the flexibility to choose the size and material that best suits your needs. Whether you want to print the image on mugs, scarfs, canvas, photo paper, or any other material, this digital download makes it easy to bring this piece into your home or office.Please note that this digital artwork is for personal use only and should not be distributed, shared, or resold. By purchasing this digital download, you agree to use the artwork for personal purposes only.So why wait? Download this stunning watercolour digital print today Don't forget to give me a like or follow me on Instagram to see more of my work and share your creations. Thank you for your support!
## 10 Welcome to my listing for a stunning watercolour digital download SET OF 3 (A4 size) windpomp clipart, created using innovative AI technology. As a digital download, you will receive a high-quality JPEG file that you can print at home or at your local print shop, giving you the flexibility to choose the size and material that best suits your needs. Whether you want to print the image on mugs, scarfs, canvas, photo paper, or any other material, this digital download makes it easy to bring the beauty of the cosmos flower into your home or office.Please note that this digital artwork is for personal use only and should not be distributed, shared, or resold. By purchasing this digital download, you agree to use the artwork for personal purposes only.So why wait? Download this stunning watercolour digital print today Don't forget to give me a like or follow me on Instagram to see more of my work and share your creations. Thank you for your support!
## 11 D I G I T A L - D O W N L O A D\nIntroducing our African art print set of three, featuring minimalist yet captivating ethnic tribal black beige wall art. Embodying simplicity and cultural depth, these prints merge African heritage with a modern, minimalist aesthetic. Add an understated yet striking touch to your space with these rug wall art designs, available as convenient digital downloads. Ideal for enthusiasts of minimalist ethnic wall art, this set offers a subtle yet profound glimpse into Afro-American-inspired decor. Explore this trio of minimalist 3 wall prints, each elegantly showcasing Africa's digital art and enchanting tribal motifs.\nW H A T ' S - I N C L U D E D ?\n📝 Upon purchase, you will receive 5 zipped folders with high-resolution (300 pixels per inch) JPEG files in the aspect ratios below.\n✔️ 2:3 Aspect ratio file for printing:\n- 4"x6" | 6"x9" | 8"x12" | 10"x15" | 12"x18" | 16"x24" | 20"x30" | 24"x36"\ncm: 10x15cm / 20x30cm / 30x45cm / 40x60cm / 50x75cm / 60x90cm\n✔️ 3:4 Aspect ratio file for printing:\n- 6"x8" | 9"x12" | 12"x16" | 15"x20" | 18"x24" | 24"x32"\ncm: 15x20cm / 22x30cm / 30x40cm / 38x50cm / 45x60cm / 60x80cm\n✔️ 4:5 Aspect ratio file for printing:\n- 4"x5" | 8"x10" | 12"x15" | 16"x20" | 24"x30"\ncm: 10x12cm / 20x25cm / 28x35cm / 20x38cm / 40x50cm\n✔️ 11 x 14 Inches (27 x 35 CM)\n✔️ ISO file (International paper size) or 5:7 ratio file for printing:\nA5 |148x210mm| . A4 |210x297mm| . A3 |297x420mm|\nA2 |420x594mm| . A1 |594x841mm|\n📝 Once you have completed the checkout process and your payment has been verified, you can access your downloadable content.\n📌 Your Account- Purchases- Order: https://www.etsy.com/your/purchases\n● Please note that the colors may vary slightly due to different color monitors and printers. The frames are not included in the purchase.\n● For the best outcome, I recommend printing on a matte textured paper. Additionally, it's important to check your frame size for the right fit.\n● This product is intended for personal use only. The files cannot be altered, sold, or distributed in any way. Prints made from the files cannot be sold or distributed.\nFind more printable art selections on my homepage at :\nhttps://www.etsy.com/shop/HomeWallArtPrintable\n© HomeWallArtPrintable Design All Rights Reserved.\nAfrican Art Print Set of 3, Black Beige Wall Art, Rug Art Prints, Neutral Tribal Wall Decor, Digital Download
## 12 Bolga Fans can add colour and texture to any room. Use one or multiple to createa captivating and eco conscious home decor design.Handcrafted fair trade fans originate from West Africa in Ghana. Each fan is uniquely woven from straw called "Elephant grass" and differs in design and colour.Because the fans are handwoven and hand-dyed, there may be small color differences.11" H x 12 W does not include handle (6.5")
## 13 African American Art, Digital Download, Printable Artwork, Home Art Decor, Printable Home Decor, Printable Wall Art, African Wall Art, AfroTribal Art, Afro Artwork, Africa Decor, Abstract Prints, Ethnic Art Prints, Ethnic Wall Art, Tribal Art, Colorful Art Prints, Contemporaray Art, Set of 3 Prints, Boho Interior, Boho Wall Art, Black Woman Art, Boho Home Decor\nIMPORTANT NOTICE:\n*** This is an INSTANT DIGITAL DOWNLOAD product. No physical product will be shipped.\n***You will get ONLY 3 piece of HIGH RESOLUTION JPG Image files at 300 dpi at 2:3 ratio ! I do not include every ratio because there are losses in the image.\nThe fastest, easiest, and least expensive way to decorate your space is with digital art. Download, print, frame them and hang in the spot where you want to . You can print them at home, take them on a flash drive to your local print shop or upload them to a printing service, and have them delivered to your door!\nYour order will include the following:\n📏 2:3 ratio file to print is suitable for these sizes:\nInches: 4x6, 6x9, 8x12, 10x15, 12x18\nCm: 10x15, 20x30, 30x45, 40x60\n*** Friendly Note: If you print from home, please set the printer to “fit” settings to produce the best print.\nYou will receive an email from Etsy with a link to download once your payment has been processed. You will get zip files including high-quality JPG digital images.\n****************************************************\nHERE IS HOW IT WORKS ! :\n* Purchase this listing\n* After payment is confirmed you will be taken to the download page, and an email will be sent to you with your download link\n* Click “Download”, save the file to your computer, print, and enjoy!\n****************************************************\nPLEASE NOTICE:\n● The colors may vary due to monitor and printer color restrictions;\n● The refund option is not available for instant download products;\n● That this purchase is ONLY for personal use.\n● Downloaded files may not be resold or shared\n● The frame and other prop items shown in this sample picture are not included in purchase.\nIf you have any questions or concerns, please let me know.\nThank you for visiting my shop and supporting my small-scale business !\nHave a nice day
## 14 An art pop aesthetic, infusing the portrait with bold, graphic elements and vibrant colors. The woman's face takes center stage, her features highlighted with a radiant blue tone.\nThis digital art print is a downloadable high-resolution file, ensuring that you can instantly adorn your walls with this captivating masterpiece. Tradition and modernity are beautifully fused together, making it an ideal addition to both contemporary and classic interior designs.\n:::::::::::::::::::::::::::::::::::::::::::::::::::::::::\nIMPORTANT NOTICE, PLEASE NOTE:\nTHIS ITEM IS A DIGITAL DOWNLOAD. NO PHYSICAL ITEM WILL BE SHIPPED.\nUpon completing your purchase, you will promptly receive a PDF file containing a Google Drive link. This streamlined delivery method has been implemented due to the substantial size of the product. By clicking on the provided link, you can easily access and download a compressed zip file, which conveniently holds the entire collection of files. This approach ensures a hassle-free and efficient process for acquiring your creative assets.\nInstructions on how to download the file can be found here: https://etsy.me/36ChGK2\n:::::::::::::::::::::::::::::::::::::::::::::::::::::::::\nHOW TO PRINT:\n. You can print at home on your own printer\n. You can print it out by sending it to printing centers\n. You can upload your files online to a printing service such as Adorama Pix, Shutterfly, VistaPrint etc.\n:::::::::::::::::::::::::::::::::::::::::::::\nI N C L U D E D - F I L E S:\nIncluded are 5 folders (per image) with different ratios, each folder has a high res JPG image 300 dpi and high res PDF file. Therefore you will receive a total of 30 image files. These include the following:\nA 4x5 ratio file for printing 4"x5", 8"x10", 16"x20", 40x50cm.\nA 3x4 ratio file for printing 6"x8", 9"x12", 12"x16", 18"x24".\nA 2x3 ratio file for printing 4"x6", 6"x9", 8"x12", 10"x15", 12"x18", 16"x24", 20"x30", 24"x36".\nAn international paper size file for printing 5"x7", A5, A4, A3, A2, A1, 50x70cm.\nA file for printing 11"x14" , "22x28".\nIf you require a different size or have any questions, please message me before purchase to discuss and I will do my best to assist!\n::::::::::::::::::::::::::::::::::::::\nCOPYRIGHT NOTICE\n::::::::::::::::::::::::::::::::::::::\nPERSONAL USE ONLY.\nThis artwork is property of © AfriPaintShop and is for personal use only. Commercial use is strictly prohibited, although you may print these files as many times as you'd like. Please refrain from sharing, re-selling, or uploading to publicly available websites.\n:::::::::::::::::::::::::::::::::::::::::::::::::::::::::\nDisclaimer:\nAll digital products are high resolution 300 DPI however, output quality may differ depending on the printer used. It is advised to examine the file with a quality monitor and print out from a high quality printer.\nPrint designs are placed on paper sizes in different proportions, there will be slight variations in design layout and dimensions e.g. some ratios may include a white border for correct positioning.\nDigital items aren't eligible for returns or exchanges on Etsy because of the nature of these items. Therefore, please be advised all purchases are non refundable or exchangeable.
## 15 Amani Wooden Wall MaskAmani is a 2 pieces wooden mask set which is handmade. Dimensions: 50cm x 11cm / 19.6 '' x 3.9''Handmade Wooden African Mask Sets will make your wall talk to you with their authentic look.The Masks will be delivered to you with the hanging attachment behind them and it is easy to hang with just a single nail. OUR GUARANTEEWe truly believe we have some of the best products in the world, and we want to make sure we back that up with a risk-free ironclad 30 days guarantee.If you don't have a positive experience for ANY reason, we will do WHATEVER it takes to make sure you are 100% satisfied with your purchase.Buying items online can be a daunting task, so we want you to realize that there are absolutely ZERO risks in buying something and trying it out. If you don't like it, no hard feelings we'll make it right.We have 24/7/365 Email Support. Please contact us if you need assistance.
## 16 Size:\n14"x6"/35x15 cm\n20"x8.6/50x22 cm\n27"x12" /70x31 cm\n32"x14"/80x35 cm\n40"x17"/100x44 cm\n47"x21"/120x52 cm\n54"x24"/140x62 cm\nFeel free to message us for custom sizes\n▪️ Free Shipping and Express Shipping Service\n▪️You can easily hang our decors with nails/screws.\n▪️Weatherproof coat used in our decors, Black has a silky feeling, other colors offer smooth feeling.\n▪️My decors have elevation screws so decors stay away from wall about 0.6", it makes a better view on you walls\n▪️We use high quality 16 gauge steel, it is lightweight and sturdy\n▪️We use sturdy packages to make it to you safe and sound.\n▪️Message us if you have any questions.\nAfrica Metal Wall Decor, Nature Metal Decor, Safari Animals Wall Art,Wildlife Wall Art,Outdoor Decor, Tree Home Decoration,Savannah Wall Art\nMetal Wall Decor, Gift for Her, Gift for Him, Housewarming Gift, Nice Gift, Unique Gift, Large Wall Decor, Metal Wallart, Minimal Wall Art
## 17 🎁 𝗚𝗘𝗧 𝟰𝟬% 𝗢𝗙𝗙 𝗧𝗢𝗗𝗔𝗬: https://cutt.ly/GIOS_DISCOUNTS🖼️ 𝗚𝗘𝗧 𝗔𝗦 𝗔 𝗖𝗔𝗡𝗩𝗔𝗦: https://www.etsy.com/listing/1574106345🛍 𝗦𝗔𝗩𝗘 │ 30% OFF 2 • 𝗕𝗨𝗡𝗗𝗟𝗘𝟮 │ 35% OFF 3 • 𝗕𝗨𝗡𝗗𝗟𝗘𝟯 │Transport yourself to the vibrant streets of Bo-Kaap, Cape Town, with this captivating watercolor art print. The artwork beautifully captures the essence of Bo-Kaap, where colorful houses line the cobbled streets, creating a picturesque scene. It evokes a sense of joy and admiration for the neighborhood's unique blend of culture and architecture.🗺️𝗦𝗛𝗜𝗣𝗣𝗜𝗡𝗚 𝗔𝗡𝗗 𝗣𝗥𝗢𝗖𝗘𝗦𝗦𝗜𝗡𝗚📦\u2028North America Orders (5x7, 8x10, 11x14, 12x16, 12x18)\u2028• Paper quality: 230 g/m²\u2028International orders & large print sizes (16x20 & 18x24)\u2028• Paper quality: 189 g/m²\u2028🌎𝗘𝗖𝗢-𝗙𝗥𝗜𝗘𝗡𝗗𝗟𝗬 𝗖𝗢𝗠𝗠𝗜𝗧𝗠𝗘𝗡𝗧💚\u2028This product is made especially for you as soon as you place an order, which is why it takes us a bit longer to deliver it to you. We try our best to use recycled materials and low carbon footprint packaging. Making products on demand instead of in bulk helps reduce overproduction, so thank you for making thoughtful purchasing decision!\u2028✨𝗡𝗢𝗧𝗘: 𝗣𝗥𝗜𝗡𝗧𝗦 𝗗𝗢 𝗡𝗢𝗧 𝗜𝗡𝗖𝗟𝗨𝗗𝗘 𝗙𝗥𝗔𝗠𝗘𝗦, 𝗗𝗘𝗠𝗢𝗡𝗦𝗧𝗥𝗔𝗧𝗜𝗩𝗘 𝗣𝗨𝗥𝗣𝗢𝗦𝗘𝗦 𝗢𝗡𝗟𝗬- 𝗠𝗢𝗖𝗞𝗨𝗣𝗦 𝗡𝗢𝗧 𝗧𝗢 𝗦𝗖𝗔𝗟𝗘.
## 18 Abstract Africa Abstract Figures Art africa art print africa decor African American Art Afro Abstraction AfroTribal Art Bohemian Home contemporary art Modern Abstraction Modern Collage Modern Ethno Motive 2 piece wall art set juneteenth wall art\n------------------------------------\nDownload very easily the high resolution poster in different ratios. Print the poster at any print shop or using your own printer and you're ready!\n*ONLY DIGITAL FILE DOWNLOAD – no physical items will be delivered.\nSIZE GUIDE:\n▶️ International Standard Size\n| A4 | A3 JPEG\nPlease contact me if there is a size you want.\n♥ HOW IT WORKS ♥\n1. Purchase the item and you will immediately be taken to the downloads page\n2. Etsy confirms your payment (usually within a couple of minutes)\n3. Your files will always be available for download here: https://www.etsy.com/your/purchases (“Download Files” button to the right of your purchase). PLEASE NOTE: Etsy doesn`t let you download items through their app, you must access it through the Etsy website on your computer or Ipad.\n4. Then download, save and print\nIf you have any problems or concerns, please do not hesitate to contact me and I will help you through the process.\n♥ KINDLY NOTE ♥\n• This is a DIGITAL item - no physical item will be shipped.\n• For PERSONAL use only. You are welcome to print as many copies as you like for personal use or as gifts, but please don't resell/redistribute or reproduce our artwork commercially.\n• The printable files offered in this listing are NOT for resale or sharing in any form.\n♥ NOTE ♥\nDue to this being a digital product, all sales are final; No refunds, returns or exchanges will be given after purchase. Please carefully read each item's description before buying. If you have any questions, please ask before you purchase.
## 19 *Didn't find what you are looking for? Check out my custom order listing and let me create something amazing just for you.**An agreement for Commercial Use and Redistribution of any digital downloaded design in my store is also now available for customers looking to resell*These are digital downloads of 5 Africa-inspired designs (includes 4 altogether image) in 12' x 12' JPG format with a resolution of 300 dpi. Images can be resized easy in any online resizing tool after download.The files will be delivered in a zip file format and can be unzipped from a computer. The printed colors may vary due to differences in computer monitors, printers, and paper quality. No physical items will be shipped, and instant downloads are final sales with no refunds or exchanges. You can use the images for personal or commercial purposes but cannot redistribute, sell, or share the images. Using the images to create clipart, digital or downloadable files, embroidery files, sublimation design files, and other digital graphics for sale is not allowed. If you have any questions, you can contact the seller.
## 20 Add a completely different atmosphere to your home with Elephants pillow covers. Hundreds of models with vivid colors and unique patterns for you are at our shop. Ethnic African Pillow Covers are presented to you as a stylish decoration item with fabric selection and sewing details. Each pattern was carefully designed. Vivid and realistic prints in photo quality, do not fade depending on washing and usage, and retain their first day properties for years.They are stylish and high quality products that can be used safely in your living room, kitchen and any corner of your home with their easy-to-clean feature. As it is suitable for daily use, it will reveal your sense of love at all occasions.🌸 Amazing Gift for Elephant LoversIndian Design Cushion Features----------------------* Dimensions: 12x12 inches (30x30 cm) 14x14 inches (35x35 cm) 16x16 inches (40x40 cm) 17x17 inches (43x43 cm) 18x18 inches (45x45 cm) 20x20 inches (50x50 cm) 22x22 inches (55x55 cm) 24x24 inches (60x60 cm)* Fabric: Prepared by knitting method from polyester and cotton yarns. Soft, velvety and shiny texture. * Printing: Vivid and realistic 3D digital printing. Flashy and vibrant colors.* Hidden zipper for a seamless look and easy care.* For one sided pillowcases, front side is printed and the back is solid white.* Cover only, inner padding NOT INCLUDED. * Our products have OEKO-TEX® Standard 100 certification standards. They do not contain any chemicals harmful to human and animal health.🌸 Care Instructions: Machine washable, gentle cycle max 104°F (40°C). Dry low heat. Do not tumble dry or dry clean.🌸 Visit/Like Our Shop:www.etsy.com/shop/HomeCraftsTR🌸 You can send us a message 24/7. Your satisfaction is our top priority.
## 21 If this original painting is sold, your painting will be created in the same style, with very similar colors, and you will get a painting of the same quality and beauty as you see from the picture.Because all of our paintings are handmade and often custom made, there may be minor or minor changes to yours. Your painting may not be exactly like the picture you ordered. It will be almost the same, but not quite the same. What I can guarantee is the quality of the work we deliver, it will be a beautiful painting as you wish.Colors of the artwork might appear a little different than on the actual item, depending on your screen resolution and calibration. Please keep this in mind prior to purchase.About the production of this painting:1. Material: Acrylic/Canvas/Oil2. Frameless:Canvas rolled up for transportation3.100% handmade production painting4. Artist: W.J5. Packing: frameless (high quality plastic tube/carton tube) rolled up for transportation6. Shipping time: You accept cancellations 12 hours after placing your order! It is estimated that the production painting will be completed within 1-2 weeks. After the production is completed, the photos of the finished product will be sent to you for viewing. After you are satisfied, we will arrange the packaging and hand it over to the courier company for delivery. It is estimated that it will take 6-8 working days (Sent from offshore Hong Kong)7. After receiving the package, if you are not satisfied with the item or have any questions, you can send me an email at any time, and I will reply you as soon as I see it!Custom order acceptable, There are 5 sizes available to each shape. If you still can not find a perfect size in the listing, please send me an information about your custom size.SHIPPING & POSTAGE.All paintings sent by post are insured, so any damage caused to the paintings in transit will be reimbursed by the shipping company. All you have to do is contact us and take the damaged photos and send them to me by mail,I'll take care of the rest.Ship worldwide, Do not need to bear any postage. The same order, buys 2 or more units, again without any shipping costs.I wish you a pleasant shopping experienceThank you so much
## 22 📏 DIMENSIONS : (Height x Width)\n19.7 x 12.7” / 50 x 32 cm\n23.6 x 15.2” / 60 x 38.6 cm\n27.6 x 17.7” / 70 x 45 cm\n31.5 x 20.2” / 80 x 51.4 cm\n37.4 x 24” / 95 x 61 cm\n📢 Welcome to BrosWallArtDecors\n✈️ FREE & EXPRESS SHIPPING! 🖤\n⭐ Africa Woman Wall Decor, African American Bedroom Metal Wall Art, African Queen Woman Figure Art, African Style Art Home Decor, Unique Gift\n📐 We can produce custom sizes for you. Please contact us for custom size requests.\n🎨 COLOR : Electrostatic powder coating (Gold, Black, Silver, White )\n🛠️ MATERIAL: 1.5 mm mild steel\n🛠️ READY TO HANG - EASY TO HANG - Only one nail is needed to hang the wall clock. Hanging apparatus comes assembled.\n🛠️ NO ASSEMBLY REQUIRED - Metal wall art SET arrives ready to hang with a pre-installed sawtooth hanger.\n✨ 3D SHADOW EFFECT - The sawtooth hanger keeps the wall art approximately 1 inch off the wall for added depth, dimension, and shadow.\n✨ Break-resistant and sturdy\n🌼 No smell and harmful chemicals involved, concerning health-wise\n✨ Delivery with a special and sturdy packaging\n✨ Moisture and damp resistant\n🤝 Contact us if you need assistance.\n📦 Packing : Sturdy box suitable for transport and gift.\n💎 TOP QUALITY : No harmful substances, non - toxic, safe for humans and animals. 1.5mm best quality steel with electrostatic matte black paint. Waterproof. You can use it indoor and outdoor.\n🏆 ORIGINAL DECORATION : Metal wall art is a modern art that will always attract and admire your visitors and you. New fashion of your home by BrosWallArtDecors. Best decoration idea for living room, bedroom, dining room, TV background wall, kitchen, hallway and office. Suitable for country house, apartment, modern house, rustic house, and ranches.\n💎 QUALITY GUARANTEED AND FREE SHIPPING : If for any reason you are not happy with your selection we offer a %100 money back guarentee. Please don't hesitate to contact us if you have any further questions.\n🎁 MEANINGFUL GIFT : The laser-cut details of flowers wall art is sure to catch the eyes of your family and friends. It’s ideal as a gift for housewarming, weddings, or other special occasions.\n✨ Metal transformed into stylish wall art for you. The elegant metal wall art will be stunning beauty to your wall. This unique design will reflect your style in your space. Your guests won't be able to keep their eyes off your high-quality metal wall decor with impressive details.\n✨ It’s ideal as a gift for Christmas, housewarmings, anniversaries, weddings, or other special occasions. An elegant gift for your lover. A meaningful gift for your family. An unforgettable gift for your friends. Choose as a gift and watch their happiness!\n✨ You may decorate with metal wall art in all your spaces; home decoration, living room decoration, bedroom decoration, kitchen decoration, office decoration, garage decoration, bathroom decoration, entryway decoration, garden decoration, outdoor decoration, and more...\n✨ If you want, you can check our other metal decors on our etsy page: https://www.etsy.com/shop/BrosWallArtDecors\nMetal Wall Art, Black Metal Wall Art, Large Metal Wall Art, Metal Art Wall Decor, Gold Metal Wall Art, Metal Art Tree Wall Decor, Outdoor Metal Wall Art, Tree of Life Metal Wall Art, Islamic Metal Wall Art, Metal Wall Art Outdoor, Metal Leaf Wall Art, Metal Bird Wall Art, 4 Set Metal Wall Art, Metal Owl Wall Art, Metal Wall Art for Bedroom, Metal Wall Art for Outdoor, Lion Metal Wall Art, Geometric Mountain Metal Wall Art, African Metal Wall Art, Gold Metal Wall Art, Metal Animal Wall Art, Metal World Map Wall Art, World Map Metal Wall Art, Cactüs Metal Wall Art, 3 Piece Metal Wall Art, Metal Wall Art Abstract, Metal Gold Wall Art
## 23 Sawabona Definition | Sawubona South African Digital Print | I See You | The Way Of Waterr | African Wall Art | Digital Download\nInstantly DOWNLOAD and PRINT this printable wall art to give your wall decor a refresh.\n_______________________________________________________________________________________\nSIZING INFORMATION\nYour download includes four high-resolution 300dpi files in the below sizes.\n2:3 ratio JPG (prints 20x30in, 16x24in, 12x18in, 8x12in, 4x6in)\n4:5 ratio JPG (prints 16x20in, 8x10in, 4x5in)\nISO JPG | 5x7 ratio (prints A0, A1, A2, A3, A4, A5 - largest is 33.11x46.81in)\n11x14 JPG (prints 11x14in)\n_______________________________________________________________________________________\nHOW TO PRINT\nTo access your files, login to your Etsy account and go to purchases\nor follow the link... www.etsy.com/it/your/purchases\nHere you will find PDF files with your print. You can download this on your computer.\nHere is a useful article about digital downloads on Etsy.\nhttps://www.etsy.com/help/article/3949\nDownload the files instantly and print them by yourself at home, local print shop or an online printing service.\n________________________________________________________________________________________\nPLEASE NOTE\nThis is a DIGITAL file. No product will be physically shipped to you.
## 24 African Art, Abstract African Wall Art, Woman Face Canvas, Modern African Canvas, Home Decor, Ready to Hang\nStyle description;\nCanvas is printed with Mimaki archival inks and stretched on 1 1" wood stretcher bars. Framed and ready to hang!\nMimaki ink, a new concept of water-based Natural inks technology. It can be safely used anywhere including baby rooms.\nProducing:\n- Printed in vivid high resolution, on museum grade canvases.\n- UV protection coating, long term fade resistant.\nSizes Options\n- 14x20 inch (35x50 cm)\n- 20x28 inch (50x70 cm)\n- 24x32 inch (60x80 cm)\n- 28x40 inch (70x100 cm)\n- 40x60 inch (100x150 cm)\nShipping İnformation;\nI will send items within 1-3 business days after payment confirmation.\nIf you ordered from Europe, the cargo will come with TNT, All cargoes outside Europe are sent with FedEx.\nShipments are sent by express, it usually takes between 1 and 5 days to any part of the world.
## 25 Ubuntu Definition Print, South Wall Art, Ubuntu Poster, Self Love Home Decor, Inspirational Quote DIGITAL DOWNLOAD, Printable Wall Art\nWHAT'S INCLUDED ?\n✔ Instant DIGITAL DOWNLOAD ONLY - UBUNTU Definition Print Gift\n(nothing will be shipped)\n✔ PRINT ANY SIZE up to: 22x28" (55x71cm) at full 300 dpi resolution\n✔ YOU WILL RECEIVE 2 22x28" FILES - 1 JPEG & 1 PDF\n✔ 2 High Resolution files @ 300 DPI\n✔ printable wall art\n✔ download link sent instantly.\nInstant digital download (nothing will be shipped).\n___________________________________________________\n✔HOW DO I PRINT THIS?\nOnce purchased, download your files. You can print your downloaded files\nin the same way you would print photos\n✔At your local print shop.\n✔At your local Boots/ Walmart / Tesco / Asda.\n✔At home (use heavier paper eg 230gsm archival paper which can be purchased in art and stationary stores.)\n✔Using online printing services eg BonusPrint, VistaPrint, Shutterfly etc.\n___________________________________________________\n✔WHAT ELSE?\nmore definition prints here:\nhttps://www.etsy.com/uk/shop/GrandandLovelyPrints?ref=seller-platform-mcnav&search_query=definition
## Shipping Shipsfrom Store_Rating Seller_location
## 1 <NA> <NA> 5.0 Australia
## 2 <NA> <NA> 5.0 <NA>
## 3 <NA> <NA> 5.0 <NA>
## 4 <NA> <NA> 5.0 <NA>
## 5 <NA> <NA> 5.0 <NA>
## 6 <NA> <NA> 5.0 <NA>
## 7 Free delivery Türkiye 5.0 Türkiye
## 8 <NA> Kenya 5.0 <NA>
## 9 <NA> <NA> 5.0 <NA>
## 10 <NA> <NA> 5.0 <NA>
## 11 <NA> <NA> 5.0 <NA>
## 12 Delivery cost: USD 30.00 Canada 5.0 Canada
## 13 <NA> <NA> 4.5 Türkiye
## 14 <NA> <NA> 5.0 <NA>
## 15 Free delivery Türkiye 4.0 Türkiye
## 16 Delivery cost: USD 50.00 Türkiye <NA> <NA>
## 17 Delivery cost: USD 9.99 United States 5.0 <NA>
## 18 <NA> <NA> 4.5 Europe
## 19 <NA> <NA> 5.0 <NA>
## 20 Delivery cost: USD 26.99 Türkiye 5.0 <NA>
## 21 Free delivery United States <NA> United States
## 22 Delivery cost: USD 39.90 Türkiye 5.0 Türkiye
## 23 <NA> <NA> 5.0 <NA>
## 24 Free delivery Türkiye 4.5 Europe
## 25 <NA> <NA> 5.0 <NA>
## Total_sales listings Product_Rating Description_len Reviews
## 1 1755 48 4.9 1002 192
## 2 1680 167 4.9 952 209
## 3 1680 167 4.9 886 209
## 4 1680 167 4.9 1146 209
## 5 1680 167 4.9 984 209
## 6 1680 167 4.9 932 209
## 7 1452 60 4.8 875 401
## 8 571 227 5.0 1048 149
## 9 481 72 4.9 947 66
## 10 481 72 4.9 957 66
## 11 477 73 4.9 2387 90
## 12 394 92 4.8 416 102
## 13 376 113 4.7 2214 42
## 14 215 66 4.8 3223 26
## 15 111 56 4.1 914 30
## 16 NA 19 <NA> 926 <NA>
## 17 NA 965 4.9 1314 340
## 18 NA 109 4.7 1800 126
## 19 NA 85 4.9 1100 128
## 20 NA 4575 4.8 1725 <NA>
## 21 NA 104 <NA> 2207 <NA>
## 22 NA 312 4.9 3690 <NA>
## 23 NA 402 4.9 1306 257
## 24 NA 371 4.7 913 139
## 25 NA 1916 4.9 1135 <NA>
## description_group es_revenue
## 1 151+ 1193.40
## 2 151+ 15288.00
## 3 151+ 8316.00
## 4 151+ 15288.00
## 5 151+ 15288.00
## 6 151+ 15288.00
## 7 151+ 95832.00
## 8 151+ 44652.20
## 9 151+ 2039.44
## 10 151+ 2039.44
## 11 151+ 2566.26
## 12 151+ 15405.40
## 13 151+ 3384.00
## 14 151+ 950.30
## 15 151+ 19977.78
## 16 151+ NA
## 17 151+ NA
## 18 151+ NA
## 19 151+ NA
## 20 151+ NA
## 21 151+ NA
## 22 151+ NA
## 23 151+ NA
## 24 151+ NA
## 25 151+ NA
#Extract unique keywords from product names
keywords <- top_25 %>%
select(Product_Name) %>%
mutate(Keywords = strsplit(as.character(Product_Name), " ")) %>%
unnest(Keywords) %>%
mutate(Keywords = gsub(",", "", Keywords)) %>% # Remove commas
distinct()
Calculate the frequency of each keyword
keyword_freq <- table(keywords$Keywords)
Convert the table to a data frame and arrange by frequency
popular_keywords <- as.data.frame(keyword_freq) %>%
arrange(desc(Freq))
Print the popular keywords by frequency
print(popular_keywords)
## Var1 Freq
## 1 African 16
## 2 Wall 16
## 3 Art 14
## 4 Decor 12
## 5 Set 7
## 6 3 6
## 7 Black 6
## 8 Digital 6
## 9 of 6
## 10 Woman 6
## 11 | 5
## 12 Download 5
## 13 Gift 5
## 14 Print 5
## 15 Abstract 4
## 16 American 4
## 17 art 4
## 18 3
## 19 2 3
## 20 Africa 3
## 21 Ethnic 3
## 22 Metal 3
## 23 Modern 3
## 24 South 3
## 25 wall 3
## 26 Afro 2
## 27 AI 2
## 28 and 2
## 29 Artwork 2
## 30 Bohemian 2
## 31 Clipart 2
## 32 Colorful 2
## 33 Definition 2
## 34 For 2
## 35 Handmade 2
## 36 Her 2
## 37 Illustration 2
## 38 map 2
## 39 Maps 2
## 40 Paper 2
## 41 Pieces 2
## 42 Poster 2
## 43 printable 2
## 44 Printable 2
## 45 Prints 2
## 46 Queen 2
## 47 Tribe 2
## 48 white 2
## 49 - 1
## 50 3D 1
## 51 51-54cm 1
## 52 6 1
## 53 Afrocentric 1
## 54 And 1
## 55 Animals 1
## 56 Art| 1
## 57 Assorted 1
## 58 Background 1
## 59 Baseball 1
## 60 Basket 1
## 61 Baskets 1
## 62 Bedroom 1
## 63 Beige 1
## 64 Best 1
## 65 Birds 1
## 66 Bo-Kaap 1
## 67 Boho 1
## 68 branch 1
## 69 broad 1
## 70 Canvas 1
## 71 Cape 1
## 72 Cityscape 1
## 73 Collar 1
## 74 Cover 1
## 75 Crown 1
## 76 Cushion 1
## 77 Custom 1
## 78 Day 1
## 79 Deco 1
## 80 decor 1
## 81 Decorative 1
## 82 DecorHousewarming 1
## 83 Decors 1
## 84 Design 1
## 85 designs 1
## 86 Difference 1
## 87 Dog 1
## 88 download 1
## 89 DOWNLOAD 1
## 90 Elephant 1
## 91 extra 1
## 92 Face 1
## 93 fan 1
## 94 Figure 1
## 95 Framed 1
## 96 Friend 1
## 97 Gallery 1
## 98 Geometric 1
## 99 gift 1
## 100 Girls 1
## 101 Hair 1
## 102 Hand 1
## 103 Hang 1
## 104 Hanging 1
## 105 Home 1
## 106 Houses 1
## 107 instant 1
## 108 Instant 1
## 109 Interior 1
## 110 Kente 1
## 111 Kitchen 1
## 112 Kwanzaa 1
## 113 Ladies 1
## 114 Lady 1
## 115 large 1
## 116 Livingroom 1
## 117 Made 1
## 118 Maker 1
## 119 Map 1
## 120 Mask 1
## 121 Mentor 1
## 122 Minimal 1
## 123 Mom 1
## 124 Mountain 1
## 125 Muserum 1
## 126 Neutral 1
## 127 Of 1
## 128 on 1
## 129 order 1
## 130 Outline 1
## 131 Pack 1
## 132 Painting 1
## 133 Pattern 1
## 134 Pet 1
## 135 Photography 1
## 136 Pillow 1
## 137 poster 1
## 138 PresentInstant 1
## 139 print 1
## 140 Protea 1
## 141 Ready 1
## 142 room 1
## 143 Rug 1
## 144 Safari 1
## 145 Scrapbook 1
## 146 Sculpture 1
## 147 set 1
## 148 Sign 1
## 149 Sister 1
## 150 Style 1
## 151 Table 1
## 152 Tamer 1
## 153 Teacher 1
## 154 Teen 1
## 155 textured 1
## 156 Throw 1
## 157 to 1
## 158 Top 1
## 159 Town 1
## 160 Triptych 1
## 161 Valentines 1
## 162 Wallart 1
## 163 Watercolor 1
## 164 Watercolors 1
## 165 watercolour 1
## 166 Watercolour 1
## 167 White 1
## 168 Wholesale 1
## 169 with 1
## 170 Women 1
## 171 Wooden 1
## 172 World 1
## 173 Zebra 1
In our analysis, key product keywords associated with the highest sales include ‘African,’ ‘Wall,’ ‘Art,’ and ‘Decor.’ Consider incorporating these powerful keywords into product names to enhance visibility and appeal to our target audience
Explore the relationship between description length and total sales
#Summarize the relationship with summary statistics, excluding NA values
summary_stats <- Etsy %>%
filter(!is.na(Total_sales)) %>%
group_by(description_group) %>%
summarise(mean_sales = mean(Total_sales),
median_sales = median(Total_sales),
min_sales = min(Total_sales),
max_sales = max(Total_sales),
n_sales = n())
Using Total_sales as the metric for success, using 96287 because it 3rd quatrant in summary
successful_stores <- Etsy[Etsy$es_revenue > 96287 , ]
Word cloud for Product descriptions
text <- paste(successful_stores$Description, collapse = " ")
wordcloud(words = names(table(strsplit(text, "\\s+"))),
freq = table(strsplit(text, "\\s+")), min.freq = 5)
Compare mean values of numerical features
# Convert relevant columns to numeric
successful_stores[, c("Price", "Total_sales", "Reviews", "listings", "es_revenue")] <- lapply(successful_stores[, c("Price", "Total_sales", "Reviews", "listings", "es_revenue")], as.numeric)
Etsy[, c("Price", "Total_sales", "Reviews", "listings", "es_revenue")] <- lapply(Etsy[, c("Price", "Total_sales", "Reviews", "listings", "es_revenue")], as.numeric)
# Remove rows with missing values
successful_stores <- successful_stores[complete.cases(successful_stores), ]
Etsy <- Etsy[complete.cases(Etsy), ]
# Calculate mean values
mean_values_successful <- colMeans(successful_stores[, c("Price", "Total_sales", "Reviews", "listings", "es_revenue")])
mean_values_all <- colMeans(Etsy[, c("Price", "Total_sales", "Reviews", "listings", "es_revenue")])
Set the scipen option to a large value to avoid scientific notation
options(scipen = 1000)
#Custom colors
custom_colors <- c("pink", "purple")
Create a matrix for barplot
bar_matrix <- rbind(mean_values_all, mean_values_successful)
Create side-by-side barplot with custom colors, labels, and title
# Create a barplot
barplot(bar_matrix, beside = TRUE, col = custom_colors,
main = "Comparison of Mean Values",
xlab = "Stores",
ylab = "Mean Values",
ylim = range(c(bar_matrix)))
# Add x-axis labels
axis(1, at = c(1.5, 3.5), labels = c("All Stores", "Successful Stores"))
# Add a legend
legend("topleft", legend = c("All Stores", "Successful Stores"), fill = custom_colors)
This graph highlights the distinct success of high-performing stores, showcasing notable increases in sales, revenue, and listings, while maintaining consistent review and pricing levels across the board
Create Corrolation Matrix
#Select only numeric columns
numeric_Etsy <- Etsy[sapply(Etsy, is.numeric)]
#Create a correlation matrix
cor_matrix <- cor(numeric_Etsy, use = "pairwise.complete.obs")
Plot the heatmap
corrplot(cor_matrix, method = "color", type = "upper",
order = "original", # Try using "original" instead of "hclust"
addrect = 2,
tl.cex = 0.7, tl.col = "black",
col = colorRampPalette(c("white", "purple"))(100))
Total Sales, Listings, and Reviews are strongly positively correlated, indicating that they collectively contribute to store success.
Description Length shows a weak negative correlation (-0.19) with total sales, implying that longer descriptions might have a slight negative impact on sales.
Estimated Revenue (es_revenue) exhibits a strong positive correlation (0.73) with total sales and listings, highlighting significant potential growth opportunities.
Popular Art Styles: Handmade art is consistently more popular than digital art in the Etsy marketplace.
Keywords and Sales: Key product keywords associated with the highest sales include ‘African,’ ‘Wall,’ ‘Art,’ and ‘Decor.’
Price Range Insights: The average listing price is $50.90, and if priced at $51.20, it’s higher than 75% of the sample listing prices.
Success Patterns among Stores: Successful stores showcase notable increases in sales, revenue, and listings while maintaining consistent review and pricing levels.
Popular Art Styles: Focus on crafting and promoting more handmade art products in your Etsy store to align with customer preferences.
Keywords and Sales: Be cautious not to set prices too high; explore competitive yet attractive pricing strategies within the popular price range for African art on Etsy.
Price Range Insights: Be cautious not to set prices too high; explore competitive yet attractive pricing strategies within the popular price range for African art on Etsy.
Success Patterns among Stores: Identify and implement attributes common among high-performing African art stores to enhance your store’s appeal and performance.
Explore different popular art styles on Etsy to diversify your offerings and cater to a broader audience.
Analyze Etsy search data to understand the impact of various keywords on sales and identify effective search terms for African art.
Consider increasing the number of listings, as 25% of the sample listings have 103 or more, aligning with plausible strategies for success.