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 Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 544 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 345 Distribute
- 87 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 8 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive