Skip to main content
Skip table of contents

Twitter Trends App

Working in digital, we have to have a close pulse to what is going on in the world but sometimes, we miss things. The Twitter Trends app pulls the top trends from countries all over the world so we can create alerts and messaging.

If you have any issues, submit a service desk ticket

The Twitter Trends App is managed by the PMG Technical Solutions team and has the datasource ready to go for you. You can see the datasource as Social.Twitter_Trends.

We will add countries as needed. To check out what countries are already included run the following in ReportingExplorer using the Custom Redshift report type.

CODE
SELECT 
country,
max(date) as max_date
FROM social.twitter_trends
group by country

If you see the country you need, make sure the max_date column is up to date. However, if you do not see the country you need, submit a ticket here and we will get that added for you.

Use Cases

TOP 10 TRENDING

To get an alert to see the top 10 Trends in a country, save the following SQL in a Custom Alli Alert

CODE
( SELECT * 
  FROM social.twitter_trends
  WHERE country = '{INSERT YOUR COUNTRY NAME HERE}'
  ORDER BY  date DESC, time DESC,rank ASC
  LIMIT 10)

The Top 10 query for the United States would look like this :

CODE
( SELECT * 
  FROM social.twitter_trends
  WHERE country = 'United States'
  ORDER BY rank ASC, date DESC, time DESC
  LIMIT 10)

Alert off of Keywords

The Twitter Trends update hourly so we are always on top of recent news. The alert off of keywords you want to follow, do the following.

  1. Copy this Google Sheet - This Sheet will contain all the keywords you wanted to be alerted off of.

  2. Make it a Datasource in Datawarehouse.

  3. In Marketplace, go to your client, click on Add Pallet and search for Custom Twitter Trend Alert. Once in there, fill out the sheet and set the pallet run on the :15 of each hour to get hourly scrapes.

Here an example of the sheet filled out.

When this runs, it will alert you off Trends that contain any of the keywords in the google sheet.

Download the battlecard

Twitter Trends.pdf

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.