The increase in content consumption paired with reduced competitor brand presence has made auxiliary platforms such as Pinterest, YouTube, and Reddit ideal partners for brands looking to increase viewership, make connections, and acquire new customers during this time. Social media usage is up across all channels while people in quarantine try to fill their time. […]
SQL can be scary; even its name, Structured Query Language, is enough to deter you from even trying to learn about it. Once you get down to the nitty-gritty, though, you’ll see, not only do the daily tasks you execute in Excel translate directly and easily, but SQL has a few more tricks up its […]
Detailed targeting + effective placements + great copy + engaging creative = the perfect social campaign. By working closely with our client’s social teams, PMG effectively manages all of these. But there’s one invisible variable in this equation that is often forgotten: bidding. Budgets are easy to change and understand, but bidding can be much […]
The CASE statement is SQL’s method of handling your standard IF/THEN logic in Excel. You begin with CASE, followed by at least one pair of WHEN and THEN statements, and then you END it. You can be exhaustive in your WHEN/THEN statements, accounting for every possibility, or you can also use the ‘else’ functionality, and […]