From the course: Python for Marketing (2019)
Unlock this course with a free trial
Join today to access over 22,700 courses taught by industry experts.
Importing Facebook and AdWords data - Python Tutorial
From the course: Python for Marketing (2019)
Importing Facebook and AdWords data
- [Instructor] Now we're going to load in a few other CSV files, and we're going to start with Adwords PPC CSV file. It's just a download from Adwords. And, again, like Google Search Console, the file is set up in a very friendly way that allows us to access the data quite easily. But, we've also got an unnamed column in here that we might need to deal with later on, because it looks like it is just an index. Next we'll import Facebook Ad CSV data. In this case you'll notice that we are following the same format as before. However, you will need to parse two date fields: 'reporting starts' and 'reporting ends.' So what you can see here is if you have multiple date columns in your data, you can parse a list, and it will understand that it's a list, and it will do its best to convert those dates into a friendly date/time stamp. If I run this and (growls) just look at the head, again, everything looks fine from a format…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
Introduction to pandas1m 7s
-
(Locked)
Installing Jupyter1m 30s
-
(Locked)
Importing Google Analytics data4m 48s
-
(Locked)
Importing Google Search Console data1m
-
(Locked)
Importing Facebook and AdWords data2m 29s
-
(Locked)
Accessing the Google Trends API2m 14s
-
(Locked)
Visualizing Google data2m 40s
-
(Locked)
Plotting Facebook and Google Ads data3m 18s
-
(Locked)
Visualizing Google Trends data1m 38s
-
-
-
-
-
-
-