How to get number of followers each month from Twitter advanced connector?
Hi there!
I can't seem to figure out how to pull the number of followers my account has each month. If I use the followers report, it returns a list of current followers. Should I append each month and just do a count as the number of followers? That seems kind of crazy as the dataset will get huge and there's a possibility of losing previous data.
Thanks!
Answers
-
Hi @user015090
It looks like the Twitter API doesn't give you a count of followers for each month. You can utilize a recursive dataflow to have your twitter dataset as an input, group based on the BATCH_RUN timestamp (you can convert this to a date or just a year and month). Group by this year & month value and count the number of followers you have in your Twitter dataset. Then append this aggregated to your output dataset. You'll want to make sure your Twitter dataset is configured to REPLACE to overwrite old data.
Typically recursive DataFlows can be an issue when you have a large dataset but since you're only taking monthly snapshots (1 row per month) you'll be fine.
Here's some documentation for recursive DataFlows:
Magic ETL 2.0: Creating a Recursive/Snapshot DataFlow in Magic ETL v2 (Beta)
Magic ETL 1.0: Creating a Recursive/Snapshot ETL DataFlow
**Was this post helpful? Click the heart icon**
**Did this solve your problem? Accept it as a solution!**1 -
0
Categories
- 10.6K All Categories
- APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 339 Workbench
- 251 Domo Best Practices
- 11 Domo Certification
- 461 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 62 Kowaza
- 296 仲間に相談
- 649 ひらめき共有