I get an error message with the Facebook Ads Advanced connector.

nbrx · 2021-07-13T18:31:33+00:00

There was an error rendering this rich post.

Hi,

I've been trying to decrease the amount of data to pull from the connector for Page Actions and even I'm slicing the data by month I get the following message:

"Domo is ready, but Facebook Ads returned an error: Job Failed. Please reduce the amount of data requested or try again later."

Do you have any suggestions on what else I could try?

I need to get information from posts like reactions, comments, and shares also for dark posts.

Quick Links

Accepted answers

RobynLinden

I just got a response:

Apologies for the delay in response. We found that this issue is related to an ongoing problem that is affecting all customers using Facebook Ads API. I am attaching this case to the ticket and will let you know as soon as this support case has been transferred to a Tier II representative for further updates.

All comments

GrantSmith

Hi @nbrx

How many months of data are you attempting to pull?

You might want to just try and pull a month, set your dataset to append and then pull the next month and the next until you get your entire dataset. I think it may be because you're selecting too wide of a date range. Do you have a lot of pages or actions?

nbrx

Hi!

I'm just trying with one month, before I was able to pull even 3 months but now I'm not able to pull not even a month seperately. I don't know what could change but this started to happen after april.

GrantSmith

What about a single day or week?

did the amount of pages drastically increase?

RobynLinden

I'm having this exact same problem, trying to pull a single day of data. I have about 12 campaigns running (and the processing time was LONGER when I deselected old campaigns).

I've opened a support ticket, I really hope Domo can edit this connector so it doesn't error so often.

@nbrx in the meantime, did you change your Dataset settings to automatically retry upon failure? That has helped me get data in there without having to manually push it. Not every time it fails but...some of the days where I have a failure, auto-retry saves the day.

GrantSmith

It sound like a Facebook limitation and not much Domo can do but I’d be interested in hearing what support comes back with @RobynLinden

nbrx

Thanks for your answer @RobynLinden I've just changed the configuration to retry everytime it fails. The worst part it's that it takes almost 2 hours every time until I see it failed. Let's see what happens with this config and only downloading one month.

csteele

I am having the same issue. I've changed my settings to only pull 1 day (was set at 10) and still receiving the error. We have about 45 active campaigns so not really a lot of data. Things were going pretty well until June 24th. Before that I would only get the 'too much data' error every once in awhile.

nbrx

Does anyone has used another tool to download this data? Like supermetrics or Excel and then upload it into DOMO?

RobynLinden

@nbrx I haven't looked into other solutions yet. Luckily I was just scoping out a new project to use this data, so I'm not in trouble yet. Really hoping this cleans itself up, though - pulling 10 rows of data per day should be a non-event :)

I was wondering if you could pull a smaller time frame and append your data or make a recursive dataflow, rather than pulling a month's worth of campaigns. Not positive how the Facebook data works, but I would assume older data doesn't change, so pulling it repeatedly may not be worth it?

nbrx

I still have no answer from the DOMO Support.

nbrx

UPDATE: I haven't received a response from the support team yet (after a week) but I found out that if I decrease the number of campaigns by brand and only taking one month of data, and trying several times to update the data, I can finally have information by brand, by month (it takes almost 3 or 4 times trying to update). I think that Facebook has some kind of new limit on the API because before I was able to download the whole year's information with the same connector for all the brands, campaigns, and months. A little help from DOMO could improve the experience, maybe a better way to select which campaigns to load by a filtered view.

RobynLinden

I just got a response:

KenTravels

I am having a similar issue. 1. no help from DOMO SUPPORT.

FB ads will not update any data, even with a new dataset built.

Can you get put in Facebook Jail for data uploads?

Jbrorby

@RobynLinden Did it ever start working for you? We just recently downloaded one of the FaceBook Ad dashboards. It was running fine for a couple week then all of a sudden we are getting the same error message

RobynLinden

@Jbrorby I don't have any datasets sitting on this connector type, so I assume it did not! We traffic our social campaigns through a third party platform and send to Domo via SFTP. I then built my own cards.

other categories

Product Ideas
Have a Domo product enhancement idea? Submit or upvote on ideas in the Ideas Exchange.
Ideas Exchange
Suggest & vote on new features you would like to see implemented in the Domo Product.
Data Connections
Ask questions about Connectors, Workbench, Cloud Amplifier and get best practices from Domo peers
Connectors
Connectors, Custom Connectors, Writeback
Workbench
Ask questions about Workbench, a secure, client-side solution for uploading your on-premise data to Domo.
Cloud Integrations
Ask questions about Cloud Integrations and Federated Data connection to your data warehouse or lake.
Data & ETL
Ask questions about Magic ETL, SQL DataFlows, DataFusion, Dataset Views and get best practices from Domo peers
Magic ETL
Ask Magic ETL questions and get answers from Domo peers
SQL DataFlows
Ask SQL DataFlow questions and get answers from Domo peers
Datasets
Ask DataFusion and Dataset Views questions and get answers from Domo peers
Visualize & Apps
Ask questions about Beast Mode, Cards, Charting, Dashboards, Stories, Variables and get best practices from Domo peers
Dashboards
Ask Cards, Dashboards, and Stories questions and get answers from Domo peers
App Studio
Ask questions about building apps in App Studio.
Pro-code Components
Ask questions about pro-code components and Domo Bricks and get answers from Domo peers.
Charting & Analyzer
Ask questions about charting and Analyzer and get answers from Domo peers.
Calculations & Variables (Beast Mode)
Ask questions about using calculated fields and Variables (Beast Modes) in Analyzer.
AI & Data science
Ask questions about DomoAI and get answers from Domo peers.
Domo AI & AI Chat
Ask questions about AI Chat and AI assistants.
Managing AI
Ask questions about managing AI with AI Playground, AI projects, AI models, and more.
Jupyter Workspaces
Ask questions about Jupyter Workspaces, Notebooks, and file share.
Automate
Ask questions about App Framework, Workflows, Domo Bricks, Domo Developer, API and get best practices from Domo peers
Workflows
Ask questions about Task Center, building automations with Domo Workflows, and executing JavaScript or Python code with Code Engine.
Alerts
Ask questions about managing alerts in Domo and get answers from Domo peers.
Distribute
Ask questions about Domo Everywhere, Scheduled Reports, Mobile and get best practices from Domo peers
Domo Everywhere
Ask questions about embedded analytics with Domo Everywhere.
Reporting
Ask questions about Scheduled Reports, Report Builder, and Slideshow Publications.
Manage
Ask questions about Governance Administration, Approvals, Teams, Alerts, and Buzz and get best practices from Domo peers
Governance & Security
Ask questions about People, Groups, Roles, Sandbox, Activity log, Buzz, Teams, Approvals and PDP and get best practices from Domo peers
Navigation & Productivity
Ask questions about navigation, Projects & Tasks, Goals, and Buzz chat.
APIs
Ask APIs and Developer.domo.com questions and get answers from Domo peers
Add-ins & Plugins
Ask questions about plugins, Microsoft add-ins, and other third-party software integrations.
Domo Community Gallery
Watch how our Customers are using Domo to solve their complex problems.
Product Releases
Domo support and product teams are here to live-answer questions about the most recent product releases. Please post questions in this Forum board for all users to benefit (rather than submitting a support ticket).
Domo University
Questions or discussions related to Domo University, trainings and certifications
Community Forums
Getting Started
Welcome to Domo's Community Forums! You'll find everything you need to get started in this category.
Community Announcements
Get the latest from Domo's Community Team.
Social Groups
Archive
Old or outdated content that could still be found helpful.

Find more posts tagged with

Facebook